Re: insert json into mysql from url with PHP

[Peter Brawley]

In your Insert stmt, $json is a string so for MySQL it needs to be quoted. If that isn't the only fix need, to debug ...

$sql = "INSERT INTO db.table (field1) VALUES ( '$json' )" );
echo "sql=$sql";

... copy & paste $sql into the mysql client program, debug it, backfit those fixes into your coded Insert stmt.



Edited 1 time(s). Last edit at 03/14/2022 09:17AM by Peter Brawley.