The mysqli API
	<?php // connect, prepare insert, bind, execute, close $link = mysqli_connect("localhost", $user, $passwd); $stmt = mysqli_prepare($link, "INSERT INTO my_table VALUES (?,?)"); mysqli_bind_param($stmt, &$d1, MYSQLI_BIND_STRING,                                         &$d2, MYSQLI_BIND_STRING); $d1 = ‘MySQL'; $d2 = ‘PHP'; // the execute could be in a loop to insert many values mysqli_execute($stmt); mysqli_stmt_close($stmt); // for replication setups mysqli_slave_query($link, $sql); mysqli_master_query($link, $sql) ?>
			Copyright 2003, Jeremy Zawodny