mysqli Function | mysql Function |
mysqli_connect($host, $user, $passwd, $dbname) | mysql_connect($host, $user, $passwd) followed by mysql_select_db($dbname) |
mysqli_errno($cxn) | mysql_errno( ) or mysql_errno($cxn) |
mysqli_error($cxn) | mysql_error( ) or mysql_error($cxn) |
mysqli_fetch_array($result) | mysql_fetch_array($result) |
mysqli_fetch_assoc($result) | mysql_fetch_assoc($result) |
mysqli_fetch_row($result) | mysql_fetch_row($result) |
mysqli_insert_id($cxn) | mysql_insert_id($cxn) |
mysqli_num_rows($result) | mysql_num_rows($result) |
mysqli_query($cxn, $sql) | mysql_query($sql) or mysql_query($sql, $cxn) |
mysqli_select_db($cxn, $dbname) | mysql_select_db($dbname) |
mysqli_real_escape_string($cxn, $data) | mysql_real_escape_string($data) |
petInfo | [1] | [petName] | = | Unicorn |
[petDescription] | = | Spiral horn centered in forehead | ||
[price] | = | 10000 | ||
[2] | [petName] | = | Pegasus | |
[petDescription] | = | Flying; wings sprouting from back | ||
[price] | = | 15000 | ||
[3] | [petName] | = | Pony | |
[petDescription] | = | Very small; half the size of standard horse | ||
[price] | = | 500 | ||
lastName | firstName | phone |
---|---|---|
Parker | Peter | 2125551212 |