Preprocessing techniques for MySQL operations in PHP (1) Database DML operations statements

<?php//preprocessing Technology//Create a Mysqli object $mysqli = new mysqli ("hostname", "MySQL User name", "Password", "database Name");//Determine if the link succeeds if ($mysqli->connect_ Error) {die ($mysqli->connect_error);} Create precompiled Object $sql = "INSERT into table name (Name,qq,age) VALUES (?,?,?)"; $mysqli _compile = $mysqli->prepare ($sql);//binding parameter $name= "Tao"; $qq = "12345678"; $age = "20";//Give? Assignment, "SSI" means string,string,int, data type and order one by one corresponds to//bind_param () here the number of parameters is variable. $mysqli _compile->bind_param ("SSI", $name. $QQ, $age);//EXECUTE statement, return boolean value $res = $mysqli _compile->execute ();// The failure prints out the reason if (! $res) {die ("failure reason =". $mysqli _compile-error);} Close resource $musqli->close ();? >