MYSQL_AFFECTED_ROWS
//connect to server as root user, no password
$conn = mysql_pconnect("localhost", "root", "");
//select the 'test' database
mysql_select_db("test", $conn);
//update some invoices
$Query = "UPDATE inventory " .
"SET Active = 'Y' " .
"WHERE ID < 100 ";
$result = mysql_query($Query, $conn);
Search for: WorkOrder# or Status
T
//establish connection
if(!($conn = mysql_connect("localhost:3606", "root", "")))
{
print("mysql_connect failed!<BR>\n");
}
//select database
if(!(mysql_select_db("test", $conn)))
{
print("mysql_select_db failed!<BR>\n");
print(mysql_errno() . ": ");
print(mysql_error() . "<BR>\n");
}
MYSQL_CREATE_DB
//connection
$conn = mysql_connect("localhost", "root", "password");
//create database
mysql_create_db("mydb", $conn);
MYSQL_DATA_SEEK
//connect to server as root user, no password
$conn = mysql_pconnect("localhost", "root", "");
//select the 'mydb' database
mysql_select_db("mydb", $conn);
//get states from tax table
$Query = "SELECT State " .
"FROM tax ";
$result = mysql_query($Query, $conn);
//jump to fifth row
mysql_data_seek($result, 4);
//get row
$row = mysql_fetch_row($result);
//print state name
print($row[0]);
MYSQL_DB_QUERY
//connect to server as root user, no password
$conn = mysql_pconnect("localhost", "root", "");
//truncate session table
$Query = "DELETE FROM session ";
$result = mysql_db_query("mydb", $Query, $conn);
MYSQL_DROP_DB
//connection
$conn = mysql_connect("localhost", "admin", "secret");
//drop garbage database
if(mysql_drop_db("garbage", $conn))
{
print("Database dropped.<BR>");
}
else
{
print("Database drop failed!<BR>");
}
MYSQL_ERRNO
//connect to server as root user, no password
$conn = mysql_pconnect("localhost", "root", "");
//select the 'mydb' database
mysql_select_db("mydb", $conn);
//try to execute a bad query (missing fields)
$Query = "SELECT FROM tax ";
if(!($result = mysql_query($Query, $conn)))
{
// get error and error number
$errno = mysql_errno($conn);
$error = mysql_error($conn);
print("ERROR $errno: $error<BR>\n");
}
MYSQL_FETCH_ARRAY
//connect to server as root user, no password
$conn = mysql_pconnect("localhost", "root", "");
//select the 'mydb' database
mysql_select_db("mydb", $conn);
//get rates from tax table
$Query = "SELECT State, Rate " .
"FROM tax ";
$result = mysql_query($Query, $conn);
// get each row
while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
// print state and rate
print("{$row["State"]} = {$row["Rate"]}<BR>\n");
}
MYSQL_FETCH_FIELD
//connect to server as root user, no password
$conn = mysql_pconnect("localhost", "root", "");
//select the 'mydb' database
mysql_select_db("mydb", $conn);
//get everything from address table
$Query = "SELECT * " .
"FROM address a, user u " .
"WHERE u.Address = a.ID ";
$result = mysql_query($Query, $conn);
// get description of each field
while($Field = mysql_fetch_field($result))
{
print("$Field->table, $Field->name, $Field->type<BR>\n");
}
MYSQL_FETCH_LENTHS
//connect to server as root user, no password
$conn = mysql_pconnect("localhost", "root", "");
//select the 'mydb' database
mysql_select_db("mydb", $conn);
//get everything from address table
$Query = "SELECT * " .
"FROM address ";
$result = mysql_query($Query, $conn);
//get field lengths
$lengths = mysql_fetch_lengths($result);
//print length of the third column
print($lengths[2]);
MYSQL_FETCH_OBJECT
//connect to server as root user, no password
$conn = mysql_pconnect("localhost", "root", "");
//select the 'mydb' database
mysql_select_db("mydb", $conn);
//get unique cities from address table
$Query = "SELECT City, StateProv " .
"FROM address ";
$result = mysql_query($Query, $conn);
// get each row
while($row = mysql_fetch_object($result))
{
// print name
print("$row->City, $row->StateProv<BR>\n");
}
MYSQL_FETCH_ROW
//connect to server as root user, no password
$conn = mysql_pconnect("localhost", "root", "");
//select the 'mydb' database
mysql_select_db("mydb", $conn);
//get unique cities from address table
$Query = "SELECT DISTINCT City, StateProv " .
"FROM address ";
$result = mysql_query($Query, $conn);
//get each row
while($row = mysql_fetch_row($result))
{
// print city, state
print("$row[0], $row[1]<BR>\n");
}
MYSQL_FIELD_SEEK
//connect to server as root user, no password
$conn = mysql_pconnect("localhost", "root", "");
//select the 'mydb' database
mysql_select_db("mydb", $conn);
// get everything from address table
$Query = "SELECT * " .
"FROM address ";
$result = mysql_query($Query, $conn);
//skip to second field
mysql_field_seek($result, 1);
//get description of each field
while($Field = mysql_fetch_field($result))
{
print("$Field->table, $Field->name, $Field->type<BR>\n");
}
MYSQL_FIELD_TABLE
//connect to server as root user, no password
$conn = mysql_pconnect("localhost", "root", "");
//select the 'mydb' database
mysql_select_db("mydb", $conn);
//get everything from user table
//get everything from address table
$Query = "SELECT * " .
"FROM address a, user u " .
"WHERE u.Address = a.ID ";
$result = mysql_query($Query, $conn);
$Fields = mysql_num_fields($result);
for($i = 0; $i < $Fields; $i++)
{
print(mysql_field_table($result, $i) . "<BR>\n");
}
MYSQL_FREE_RESULT
//connect to server as root user, no password
$conn = mysql_pconnect("localhost", "root", "");
//select the 'mydb' database
mysql_select_db("mydb", $conn);
//get everything from user table
$Query = "SELECT * " .
"FROM user ";
$result = mysql_query($Query, $conn);
//free result set
mysql_free_result($result);
MYSQL_INSERT_ID
//connect to server as root user, no password
$conn = mysql_pconnect("localhost", "root", "");
//select the 'mydb' database
mysql_select_db("mydb", $conn);
//insert a row
$Query = "INSERT INTO user (Login, Password) " .
"VALUES('leon', 'secret') ";
$result = mysql_query($Query, $conn);
//get id
print("ID is " . mysql_insert_id($conn));
MYSQL_LIST_DBS
//connect to server as root user, no password
$conn = mysql_pconnect("localhost", "root", "");
//get list of databases
$result = mysql_list_dbs($conn);
//get each row
while($row = mysql_fetch_row($result))
{
// print name
print($row[0] . "<BR>\n");
}
MYSQL_LIST_FIELDS
//connect to server
$conn = mysql_pconnect("localhost", "root", "");
//get list of fields
$result = mysql_list_fields("mydb", "invoice", $conn);
//start HTML table
print("<TABLE>\n");
print("<TR>\n");
print("<TH>Name</TH>\n");
print("<TH>Type</TH>\n");
print("<TH>Length</TH>\n");
print("<TH>Flags</TH>\n");
print("</TR>\n");
//loop over each field
for($i = 0; $i < mysql_num_fields($result); $i++)
{
print("<TR>\n");
print("<TD>" . mysql_field_name($result, $i) . "</TD>\n");
print("<TD>" . mysql_field_type($result, $i) . "</TD>\n");
print("<TD>" . mysql_field_len($result, $i) . "</TD>\n");
print("<TD>" . mysql_field_flags($result, $i) . "</TD>\n");
print("</TR>\n");
}
//close HTML table
print("</TABLE>\n");
MYSQL_LIST_TABLES
//connect to server as root user, no password
$conn = mysql_pconnect("localhost", "root", "");
//get list of tables
$result = mysql_list_tables("mydb", $conn);
//get each row
while($row = mysql_fetch_row($result))
{
//print name
print($row[0] . "<BR>\n");
}
MYSQL_PCONNECT
//persistent connection
$conn = mysql_pconnect("localhost", "root", "");
MYSQL_RESULT
//connect to server as root user, no password
$conn = mysql_connect("localhost", "root", "");
//select the 'mydb' database
mysql_select_db("mydb", $conn);
// get everything from customer table
$Query = "SELECT * FROM " .
"user " .
"WHERE user.login like 'A%' ";
$result = mysql_query($Query, $conn);
// get number of rows
$rows = mysql_num_rows($result);
for($i = 0; $i < $rows; $i++)
{
$name = mysql_result($result, $i, "user.login");
print("$name<BR>\n");
}
| |
|