Easily take any JSON object and create+insert it into a mysql table built from its structure. Also search, update, index, and validate tables with JSON.
include("config.php");
include("include.classloader.php");
$classLoader->addToClasspath(ROOT);
$mysql = new MySQLConn(DATABASE_HOST, DATABASE_NAME, DATABASE_USER, DATABASE_PASS);
$db = new JSONtoMYSQL($mysql);
// create some json
$obj = json_decode('{"id":4,"name" : "asfd"}');
// save it to a table
$db->save($obj, "brandnewtable");
// SELECT * from brandnewtable WHERE id = 4
$obj = $db->table("brandnewtable")->find(["id" => 4]);
print_r($obj);
// SELECT * FROM brandnewtable WHERE id > 4 ORDER BY name DESC
$obj = $db->table("brandnewtable")->find(["id" => 4], ["id" => ">"], ["name DESC"]);
print_r($obj);
// SELECT * FROM brandnewtable WHERE id IN (4, 5, 6, 7)
$obj = $db->table("brandnewtable")->find(["id" => [4, 5, 6, 7]]);
print_r($obj);
Has json-to-mysql saved you some time? Become a Github Sponsor and buy me a coffee ☕️ 😄