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

The mysql_fetchrow function returns an array that represents all the fields for a row in the result set. Each call produces the ...

The mysql_field_seek function moves the internal field pointer to the specified field. The next call to mysql_fetch_field will g ...

string mysql_field_type(integer result, integer field) Use mysql_field_type to get the type of a particular field in the result ...

integer mysql_list_dbs(integer link) The mysql_list_dbs function queries the server for a list of databases. It returns a result ...

integer mysql_list_tables(string database, integer link) Use mysql_list_tables to get a result pointer to a list of tables for a ...

//get each row while($row = mysql_fetch_row($dbResult)) { //print name print($row[0]. "\n"); } ?> integer mysql_num_fields(in ...

The mysql_result function returns the value of the specified field in the specified row. The field argument may be a number, in ...

Excel workbooks. A good place to start learning more about ODBC is Microsoft's page at <http://www.microsoft.com/data/odbc/ & ...

$Query .= "FROM employee "; $Query .= "WHERE id=17 "; $Result = odbc_do($Connection, $Query); // make sure binmode is set for bi ...

odbc_close_all() The odbc_close_all function closes every connection you have open to ODBC data sources. Like odbc_close, it wil ...

Use odbc_connect to connect to an ODBC data source. A connection identifier is returned, which is used by most of the other func ...

passed by reference and will be set with the value of the result columns. See odbc_prepare for an example of use. integer odbc_f ...

// execute query $Query = "SELECT name, price "; $Query .= "FROM catalog "; $Result = odbc_do($Connection, $Query); print(odbc_f ...

boolean odbc_free_result(integer result) Use odbc_free_result to free the memory associated with the result set. This is not str ...

// execute query $Query = "SELECT name, price "; $Query .= "FROM catalog "; $Result = odbc_do($Connection, $Query); print(odbc_n ...

The odbc_prepare function parses a query and prepares it for execution. A result identifier that may be passed to odbc_execute i ...

$Result = odbc_do($Connection, $Query); while(odbc_fetch_row($Result)) { $name = odbc_result($Result, 1); $price = odbc_result($ ...

// put everything on sale $Query = "UPDATE catalog "; $Query .= "SET price = price * 0.9 "; $Result = odbc_do($Connection, $Quer ...

The Oracle 7 functions require two environment variables to be set: ORACLE_HOME and ORACLE_SID. They are most likely not set for ...

The ocibindbyname function binds an Oracle placeholder to a PHP variable. You must supply a valid statement identifier as create ...