Microsoft Word - Core PHP Programming Using PHP to Build Dynamic Web Sites

ibase_close($dbLink); ?> boolean ibase_rollback(integer link) The ibase_rollback function causes a transaction to roll back. ...

Two mSQL extensions exist, one for mSQL version 1 and one for version 2. You must load the appropriate extension to enable the f ...

$Link = msql_connect("msql.clearink.com"); msql_select_db("store", $Link); $Result = msql_query("SELECT Name FROM customer", $Li ...

print(msql_error()); } msql_close($Link); ?> string msql_error() Use msql_error to retrieve the last error message returned b ...

$Link = msql_connect("msql.clearink.com"); msql_select_db("store", $Link); $Query = "SELECT * FROM item i, SKU s "; $Query .= "W ...

array msql_fetch_row(integer result) The msql_fetch_row function returns an array with one element for each resulting column. FA ...

msql_close($Link); ?> string msql_fieldflags(integer result, integer field) The msql_fieldflags function returns all the flag ...

$Result = msql_query($Query, $Link); print("Field 0 is ". msql_fieldname($Result, 0)); msql_close($Link); ?> string msql_fiel ...

<? $Link = msql_connect("msql.clearink.com"); msql_select_db("store", $Link); $Query = "INSERT INTO store VALUES (0, 'Martine ...

print($row_array[0]. "\n"); } msql_close($Link); ?> integer msql_list_tables(string database, integer link) The msql_list_tab ...

The msql_num_rows function returns the number of rows in the result set. <? $Link = msql_connect("msql.clearink.com"); msql_s ...

<? $Link = msql_connect("msql.clearink.com"); msql_select_db("store", $Link); $Query = "SELECT * FROM item i, SKU s "; $Query ...

The mysql_affected_rows function returns the number of rows affected by the last query made to the specified database connection ...

Use mysql_close to close the connection to a database. The connect must have been opened with mysql_connect. Use of this functio ...

boolean mysql_create_db(string database, integer link) Use mysql_create_db to create a new database. Note that you must open a c ...

The mysql_db_query function executes a query on the specified database and returns a result identifier. If the link argument is ...

$Query = "SELECT FROM tax "; if(!($dbResult = mysql_query($Query, $dbLink))) { // get error and error number $errno = mysql_errn ...

object mysql_fetch_field(integer result, integer field) ...

Use the mysql_fetch_field function to get information about a field in a result set. Fields are numbered starting with zero. The ...

<? //connect to server as freetrade user, no password $dbLink = mysql_pconnect("localhost", "freetrade", ""); //select the 'f ...