Phppdo database operation summary

Phppdo database operations summary using preprocessing methods:

$ Dbh = new PDO ('MySQL: host = localhost; dbname = access_control ', 'root', ''); $ dbh-> setAttribute (PDO: ATTR_ERRMODE, PDO :: ERRMODE_EXCEPTION); $ dbh-> exec ('set names utf8');/* Add * // $ SQL = "INSERT INTO 'user' set 'login' =: login AND 'password' =: password "; $ SQL =" INSERT INTO 'user' ('login', 'password') VALUES (: login,: password )"; $ stmt = $ dbh-> prepare ($ SQL); $ stmt-> execute (array (': login' => 'kevin2 ',': password '=> ''); echo $ dbh-> lastinsertid ();/* modify */$ SQL =" UPDATE 'user' SET 'password' =: password WHERE 'user _ id' =: userId "; $ stmt = $ dbh-> prepare ($ SQL); $ stmt-> execute (array (': userid' => '7', ': password' => '4607e782c4d86fd5364d7e3168bb10d9'); echo $ stmt-> rowCount (); /* DELETE */$ SQL = "DELETE FROM 'user' WHERE 'login' LIKE 'Kevin _'"; // kevin % $ stmt = $ dbh-> prepare ($ SQL); $ stmt-> execute (); echo $ stmt-> rowCount (); /* query */$ login = 'Kevin % '; $ SQL = "SELECT * FROM 'user' WHERE 'login' LIKE: login "; $ stmt = $ dbh-> prepare ($ SQL); $ stmt-> execute (array (': login' => $ login )); while ($ row = $ stmt-> fetch (PDO: FETCH_ASSOC) {print_r ($ row);} print_r ($ stmt-> fetchAll (PDO: FETCH_ASSOC ));