note 103378 added to mysqli.prepare

This example script shows how the class in my previous post can be put to use: <?php require( "your-mysql-connect-vars.php" ); define( "RETURN_NULL", 0 ); define( "RETURN_RESULTS", 1 ); // Default. define( "RETURN_AFFECTEDROWS", 2 ); define( "RETURN_NUMROWS", 3 ); define( "RETURN_OBJECT", 4 ); $sql = new sql(); $db = $sql->init(); $res = $sql->query( $db, "create table temp ( tid int primary key auto_increment, tname varchar(255), tage int, mistert varchar(255) )", array(), RETURN_NULL ); var_dump( $res ); print "<br /><br />\r\n\r\n"; $res = $sql->query( $db, "insert into temp values ( NULL, 'Some guy named Ted', 36, 'Pity' )", array(), RETURN_NULL ); var_dump( $res ); print "<br /><br />\r\n\r\n"; $res = $sql->query( $db, "update temp set mistert = ? where mistert = ?", array( "Pity da", "Pity" ), RETURN_AFFECTEDROWS ); var_dump( $res ); print "<br /><br />\r\n\r\n"; $res = $sql->query( $db, "insert into temp ( tname, tage, mistert ) values ( ?, ?, ? )", array( "Your Mother", 16, "FOO!" ), RETURN_NULL ); var_dump( $res ); print "<br /><br />\r\n\r\n"; $res = $sql->query( $db, "select tname, mistert from temp where tid = ? AND tname = ?", array( "id" => 1, "name" => "Some guy named Ted" ) ); var_dump( $res ); print "<br /><br />\r\n\r\n"; $res = $sql->query( $db, "select * from temp" ); var_dump( $res ); print "<br /><br />\r\n\r\n"; // The key is completely moot (so long as it's unique); in fact, you can omit it altogether. --Kris $res = $sql->query( $db, "select tid from temp where tid = ?", array( 1 ) ); var_dump( $res ); print "<br /><br />\r\n\r\n"; $res = $sql->query( $db, "select * from temp where tname = ? AND mistert = ?", array( "Your Mother", "FOO!" ) ); var_dump( $res ); print "<br /><br />\r\n\r\n"; $res = $sql->query( $db, "drop table temp", array(), RETURN_NULL ); var_dump( $res ); ?> ---- Server IP: 69.147.83.197 Probable Submitter: 174.21.233.183 ---- Manual Page -- http://www.php.net/manual/en/mysqli.prepare.php Edit -- https://master.php.net/note/edit/103378 Del: integrated -- https://master.php.net/note/delete/103378/integrated Del: useless -- https://master.php.net/note/delete/103378/useless Del: bad code -- https://master.php.net/note/delete/103378/bad+code Del: spam -- https://master.php.net/note/delete/103378/spam Del: non-english -- https://master.php.net/note/delete/103378/non-english Del: in docs -- https://master.php.net/note/delete/103378/in+docs Del: other reasons-- https://master.php.net/note/delete/103378 Reject -- https://master.php.net/note/reject/103378 Search -- https://master.php.net/manage/user-notes.php