Tag: insert

PHP PDO Firebird inserting

I’m new in Firebird but I’d like to write a small script in PHP that reads a CSV file and fills an existing Firebird db with its data. The problem is I don’t really know how to use the autoincrement …

php how to store and read json data via mysql?

insert json mysql php

php how to store and read json data via mysql? then, how to update data value? read out the data, then insert it with an json_encode and decode process, or only easy way update? then insert another change to [{“id”: “1”, “value”: “yes”},{“id”: “2”, “value”: “yes”}]… Or even if a long long value. [{“id”: “1”, “value”: “yes”},{“id”: “2”, “value”: “yes”}…{“id”:

PDO Mysql prepared statement last_insert_id returns wrong value on multi-insert?

insert lastinsertid mysql pdo php

I noticed that if I prepare a multi-insert statement and execute it into MySQL via PDO, and then request the last_insert_id, I get the first ID of the multiple inserted rows, not the last one. Specifically: will create these rows on an empty table: But the last_insert_id will return “1”. Is this a known issue or am I doing something