mysqli扩展
1 | <br /> $conn = new mysqli( 'localhost' , 'root' , '123' , 'zx' , '3306' );<br /><br /> if (mysqli_connect_errno()) {<br /> printf( "Connect failed: %s\n" , mysqli_connect_error());<br /> exit ();<br />}<br /><br /><br /> $prepare = $conn -> prepare( "INSERT INTO test (uid,name) VALUES('?','?')" );<br /><br /> $num = 12;<br /><br /> $hanzi = "xiha" ;<br /><br /> $prepare -> bind_param( 'is' , $num , $hanzi );<br /><br /><br /><br /> $prepare -> execute();<br /><br /><br />
|
Copy after login
test表字段,uid int(11) name varchar(30)
Warning: mysqli_stmt::bind_param() [function.mysqli-stmt-bind-param]: Number of variables doesn't match number of parameters in prepared statement in