PHPPDO data insert operation

Insert the PHPPDO data // pass an array to bind the value to the name parameter in the pre-processing query, and execute the SQL

Insert php pdo data

Code:

// Data insertion // prepare an SQL statement $ SQL = "INSERT INTO 'test' ('name') VALUES (: name )"; // call the prepare method to prepare for query $ stmt = $ pdo-> prepare ($ SQL); // pass an array to bind the value to the name parameter in the pre-processing query, and execute SQL $ stmt-> execute (array (': name' => 'Wang Wu ')); // obtain the ID of the last inserted data echo $ pdo-> lastInsertId ().'
';