int mysql_affected_rows([cresource connection])

Example

<?php
  $query = "INSERT INTO people 
            VALUES(\"selina\", \"" . crypt("sarah", "se") . "\")";
  
  $connection = mysql_connect("localhost", "fred", "shhh");
  mysql_select_db("wedding", $connection);
  
  $result = mysql_query($query, $connection);
  
  echo "Inserted " . mysql_affected_rows($connection) . " row(s)";
  
?>

int mysql_change_user( string username, string password [, string database
[, cresource connection]])

WARNING: The function mysql_change_user( ) is available only through MySQL DBMS Version 3.23.3 and later. In addition, the function is missing from PHP Version 4 (up to and including the current PHP 4.1.2), with calls to the function reporting it as an undefined function. This is likely to be fixed in future PHP versions.

Example

<?php
  $connection = mysql_connect("localhost", "fred", "shhh");
  mysql_select_db("wedding", $connection);
  
  // The database will still be "wedding" on the current connection
  if (mysql_change_user("richo", "twelve") == true)
     echo "Changed user to richo";
  else
     echo "Change to user richo failed!";
?>

boolean mysql_close([cresource connection])

Example

<?php
  $query = "SELECT * FROM presents";
  
  $connection = mysql_connect("localhost", "fred", "shhh");
  mysql_select_db("wedding", $connection);
  
  $result = mysql_query($query, $connection);
  
  while ($row = mysql_fetch_array($result))
     echo $row["present"] . "\n";
  
  mysql_close($connection);
?>

cresource mysql_connect([string hostname [, string username [, string password 
[, boolean new_connection]]]])

Example

<?php
  
  // This is a typical function call
  // Local machine, user "fred" and password "shhh"
  // On a Unix machine, this defaults to Unix socket
  $connection1 = mysql_connect("localhost", "fred", "shhh");
  
  // Local machine, user "fred" and password "shhh"
  // Adding the port forces a TCP/IP connection
  // on a Unix machine
  $connection2 = mysql_connect("localhost:3306", "fred", "shhh");
  
  // Remote machine "blah.webdatabasebook.com" on port 4000
  $connection3 = mysql_connect("blah.webdatabasebook.com:4000", "fred", "shhh");
  
?>

boolean mysql_create_db (string database [, cresource connection])

Example

<?php
  $connection = mysql_connect("localhost", "fred", "shhh");
  
  if (mysql_create_db("temp", $connection))
     echo "Created database 'temp'";
  else
     echo "Create database 'temp' failed!";
?>

boolean mysql_data_seek (qresource query, int row)

Example

<?php
  $query = "SELECT * FROM presents";
  
  $connection = mysql_connect("localhost", "fred", "shhh");
  mysql_select_db("wedding", $connection);
  
  $result = mysql_query($query, $connection);
  
  if (!mysql_data_seek($result, 7))
     echo "Could not seek to the eighth row!"; 
  
  $row = mysql_fetch_array($result); 
  
  echo "Eighth row: " . $row["present"];       
?>

string mysql_db_name (qresource query, int row[, mixed unused])

TIP: This function is an alias to mysql_result( ). It is therefore possible to supply a third argument to this function, but it should not be used in practice with mysql_db_name( ).

Example

<?php
  $connection = mysql_connect("localhost", "fred", "shhh");
  mysql_select_db("wedding", $connection);
  
  $result = mysql_list_dbs($connection);
  
  echo "The databases available are:\n";
  
  for ($x=0; $x < mysql_num_rows($result); $x++)
     echo mysql_db_name($result, $x) . "\n";
?>

boolean mysql_drop_db(string database [, cresource connection])

Example

<?php
  $connection = mysql_connect("localhost", "fred", "shhh");
  
  if (mysql_drop_db("temp", $connection)) 
     echo "Dropped database 'temp'";
  else
     echo "Drop database 'temp' failed!";
?>

int mysql_errno([resource connection])

Example

<?php
  $connection = mysql_connect("localhost", "fred", "shhh");
  
  mysql_select_db("not-a-database", $connection);
  
  // Prints MySQL reported error 1049
  if (mysql_errno( ))
     echo "MySQL reported error " . mysql_errno( );
?>

string mysql_error([cresource connection])

Example

<?php
  $connection = mysql_connect("localhost", "fred", "shhh");
  
  mysql_select_db("not-a-database", $connection);
  
  // Prints MySQL reported error: Unknown database 'not-a-database'
  if (mysql_errno( ))
     echo "MySQL reported error: " . mysql_error( );
?>

string mysql_escape_string (string input)

Example

<?php
  $person = "Steven O'Grady";
  $person = mysql_escape_string($person);
  
  // Prints: Steven O\'Grady
  echo $person;
?>

array mysql_fetch_array (qresource query [, int array_type])

NOTE: Prior to PHP 4.0.5, NULL values were not returned into the array, but this has been fixed in recent versions.

This bug doesn't affect associative access, but it causes renumbering for numeric access. If a table has a NULL attribute, the array returned has one fewer element. The missing element can still be referenced associatively, because referencing a nonexistent element correctly returns NULL. However, if you want to avoid having arrays of different lengths returned, ensure that all attributes have a value or upgrade to a new release of PHP.

Example

<?php
  $query = "SELECT * FROM presents";
  
  $connection = mysql_connect("localhost", "fred", "shhh");
  mysql_select_db("wedding", $connection);
  
  $result = mysql_query($query, $connection);
  
  while ($row = mysql_fetch_array($result))
  {
     echo "ID:\t{$row["present_id"]}\n";
     echo "Quantity:\t{$row["quantity"]}\n";
     echo "Present:\t{$row["present"]}\n";   
     echo "Shop:\t{$row["shop"]}\n\n";
  }
?>

array mysql_fetch_assoc (qresource query)

Example

<?php
  $query = "SELECT people_id FROM people";
  
  $connection = mysql_connect("localhost", "fred", "shhh");
  mysql_select_db("wedding", $connection);
  
  $result = mysql_query($query, $connection);
  
  echo "Users:\n";
  
  while ($row = mysql_fetch_assoc($result))
     echo $row["people_id"] . "\n";
?>

object mysql_fetch_field(qresource query [, int attribute ])

Example

<?php
  $connection = mysql_connect("localhost", "fred", "shhh");
  
  $result = mysql_list_fields("wedding", "presents");
  
  echo "Presents table attributes:\n";
  
  while ($row = mysql_fetch_field($result))
  {
     echo $row->name;          
     echo " is an attribute of type " . $row->type . ".";
     if ($row->not_null == true)
        echo " It cannot be null.\n";
     else
        echo " It can be null.\n";
  }
?>

array mysql_fetch_lengths(qresource query)

Example

<?php
  $query = "SELECT * FROM presents";
  
  $connection = mysql_connect("localhost", "fred", "shhh");
  mysql_select_db("wedding", $connection);
  
  $result = mysql_query($query, $connection);  
  
  while ($row = mysql_fetch_row($result))
  {
     echo "The total length of this row is: ";
     $row2 = mysql_fetch_lengths($result);
    
     $length = 0;
     foreach ($row2 as $element)
        $length += $element;
 
     echo $length . "\n";
  }
?>

object mysql_fetch_object(qresource query [, int array_type])

Example

<?php
  $query = "SELECT * FROM presents";
  
  $connection = mysql_connect("localhost", "fred", "shhh");
  mysql_select_db("wedding", $connection);
  
  $result = mysql_query($query, $connection);
  
  while ($row = mysql_fetch_object($result, MYSQL_ASSOC))
  {
     echo "\n\nQuantity:\t" . $row->quantity;
     echo "\nPresent:\t" . $row->present;
     echo "\nShop:\t" . $row->shop;
  }
?>

array mysql_fetch_row(qresource query)

Example

<?php
  $query = "SELECT * FROM presents";
  
  $connection = mysql_connect("localhost", "fred", "shhh");
  mysql_select_db("wedding", $connection);
  
  $result = mysql_query($query, $connection);
  
  while ($row = mysql_fetch_row($result))
  {
    for($x=0;$x<mysql_num_fields($result);$x++)
       echo $row[$x] . " "; 
    echo "\n";
  }
?>

string mysql_field_flags(qresource query, int attribute)

Example

<?php
  $connection = mysql_connect("localhost", "fred", "shhh");
  
  $result = mysql_list_fields("wedding", "presents");
  
  for($x=0; $x < mysql_num_fields($result); $x++)
     echo mysql_field_name($result, $x) . 
          " has the properties: " . 
          mysql_field_flags($result, $x) . "\n";
?>

string mysql_field_name(qresource query, int attribute)

Example

<?php
  $connection = mysql_connect("localhost", "fred", "shhh");
  
  $result = mysql_list_fields("wedding", "presents");
  
  echo "The attributes of presents are: ";
  for($x=0; $x < mysql_num_fields($result); $x++)
     echo mysql_field_name($result, $x) . " ";
?>

int mysql_field(qresource query, int attribute)

Example

<?php
  $connection = mysql_connect("localhost", "fred", "shhh");
  
  $result = mysql_list_fields("wedding", "presents");
  
  for($x=0; $x < mysql_num_fields($result); $x++)
     echo mysql_field_name($result, $x) . 
          " has a maximum length of " . 
          mysql_field_len($result, $x) . "\n";
?>

boolean mysql_field_seek(qresource query, int attribute)

Example

<?php
  $connection = mysql_connect("localhost", "fred", "shhh");
  
  $result = mysql_list_fields("wedding", "presents");
  
  mysql_field_seek($result, 2);
  
  $field = mysql_fetch_field($result);
  
  echo "The third attribute is " . $field->name;
?>

string mysql_field_table(qresource query, int attribute)

Example

<?php
  $query = "SELECT * FROM presents, people WHERE presents.people_id = people.people_id";
  
  $connection = mysql_connect("localhost", "fred", "shhh");
  mysql_select_db("wedding", $connection);
  
  $result = mysql_query($query, $connection);
  
  echo "The table associated with the first attribute is " . mysql_field_table($result, 1);
?>

string mysql_field_type(qresource query, int attribute)

Example

<?php
  $query = "SELECT * FROM presents, people WHERE presents.people_id = people.people_id";
  
  $connection = mysql_connect("localhost", "fred", "shhh");
  mysql_select_db("wedding", $connection);
  
  $result = mysql_query($query, $connection);
  
  for($x=0;$x<mysql_num_fields($result);$x++)
     echo "The type of attribute $x is " . mysql_field_type($result, $x) . "\n";
?>

boolean mysql_free_result(qresource query)

Example

<?php
  $query = "SELECT * FROM presents";
  
  $connection = mysql_connect("localhost", "fred", "shhh");
  mysql_select_db("wedding", $connection);
  
  $result = mysql_query($query, $connection);
  
  while ($row = mysql_fetch_object($result, MYSQL_ASSOC))
  {
     echo "\n\nQuantity:\t" . $row->quantity;
     echo "\nPresent:\t" . $row->present;
     echo "\nShop:\t" . $row->shop;
  }
  
  mysql_free_result($result);
?>

string mysql_get_client_info( )

Example

<?php
  // Prints (on our machine): This is the 3.23.44 MySQL client library.
  echo "This is the " . mysql_get_client_info( ) . " MySQL client library.";
?>

string mysql_get_host_info([cresource connection])

Example

<?php
  mysql_connect("localhost", "root", "drum");
  
  // Prints: This is a Localhost via UNIX socket connection to MySQL.   
  echo "This is a " . mysql_get_host_info( ) . " connection to MySQL.";
?>

int mysql_get_proto_info([cresource connection])

Example

<?php
echo "You are connected to MySQL using protocol " . mysql_get_proto_info( ); 
?>

string mysql_get_server_info([cresource connection])

Example

<?php
  mysql_connect("localhost", "fred", "shhh");
  
  // Prints (on our machine): This is MySQL version 3.23.44-log      
  echo "This is MySQL version " . mysql_get_server_info( );      
?>

int mysql_insert_id([cresource connection])

Example

<?php
  $query = "INSERT INTO presents 
            VALUES(NULL, \"Bike\", \"Fitzroy Cycles\", 1, \"Red\", \"350.00\", NULL)";
  
  $connection = mysql_connect("localhost", "root", "drum");
  mysql_select_db("wedding", $connection);
  
  $result = mysql_query($query, $connection);
  
  echo "Inserted record " . mysql_insert_id($connection);            
?>

qresource mysql_list_dbs([cresource connection])

Example

<?php
  $connection = mysql_connect("localhost", "fred", "shhh");
  mysql_select_db("wedding", $connection);
  
  $result = mysql_list_dbs($connection);
  
  echo "The databases available are:\n";
  
  for ($x=0; $x < mysql_num_rows($result); $x++)
     echo mysql_db_name($result, $x) . "\n";
?>

qresource mysql_list_fields(string database, string table[, cresource connection])

Example

<?php
  $connection = mysql_connect("localhost", "fred", "shhh");
  
  $result = mysql_list_fields("wedding", "presents");
  
  echo "The attributes of presents are: ";
  for($x=0; $x < mysql_num_fields($result); $x++)
     echo mysql_field_name($result, $x) . " ";
?>

qresource mysql_list_tables(string database[, cresource connection])

Example

<?php
  $connection = mysql_connect("localhost", "fred", "shhh");
  
  $result = mysql_list_tables("wedding", $connection);
  
  echo "The tables of wedding are: ";           
  for($x=0; $x < mysql_num_rows($result); $x++)
     echo mysql_tablename($result, $x) . " ";
?>

int mysql_num_fields(qresource query)

Example

<?php
  $connection = mysql_connect("localhost", "fred", "shhh");
  
  $result = mysql_list_fields("wedding", "presents", $connection);
  
  echo "There are " . mysql_num_fields($result) . " attributes in presents";
?>

int mysql_num_rows(qresource query)

Example

<?php
  $query = "SELECT * FROM presents WHERE present LIKE 'M%'"; 
  
  $connection = mysql_connect("localhost", "fred", "shhh");
  mysql_select_db("wedding", $connection);
  
  $result = mysql_query($query, $connection);
  
  echo "There are " . mysql_num_rows($result) . " presents that begin with M";
?>

cresource mysql_pconnect([string hostname [, string username [, string password]]])

qresource mysql_query(string query[, cresource connection])

Example

<?php
  $query = "SELECT * FROM people WHERE people_id LIKE 'h%'";
  
  $connection = mysql_connect("localhost", "fred", "shhh");
  mysql_select_db("wedding", $connection);
  
  $result = mysql_query($query, $connection);
  
  while ($row = mysql_fetch_array($result))
     echo $row["people_id"] . "\n";
  
?>

string mysql_result(qresource query, int row[, mixed attribute])

NOTE: mysql_result() is different from functions that return entire rows, such as mysql_fetch_row( ).

You should not mix calls to mysql_result( ) with calls to other functions that read data from a result set. Also, mysql_result( ) is much slower for reading row data than row-specific functions, and should not be used for this task.

Example

<?php
  $query = "SELECT count(*) FROM people";
  
  $connection = mysql_connect("localhost", "fred", "shhh");
  mysql_select_db("wedding", $connection);
  
  $result = mysql_query($query, $connection);
  
  $count = mysql_result($result, 0);
  echo "There are " . $count . " rows in people";
?>

boolean mysql_select_db(string database[, cresource connection])

Example

<?php
  $connection = mysql_connect("localhost", "fred", "shhh");
  mysql_select_db("wedding", $connection);
?>

string mysql_tablename(qresource query, int table[, mixed unused])

TIP: This function is an alias to mysql_result( ). It is therefore possible to supply a third argument to this function, but it should not be used in practice with mysql_tablename( ).

Example

<?php
  $connection = mysql_connect("localhost", "fred", "shhh");
  
  $result = mysql_list_tables("wedding", $connection);
  
  echo "The tables of wedding are: ";
  for($x=0; $x < mysql_num_rows($result); $x++)
     echo mysql_tablename($result, $x) . " ";
?>

qresource mysql_unbuffered_query(string query[, cresource connection])

Example

<?php
  $query = "SELECT * FROM presents";
  
  $connection = mysql_pconnect("localhost", "fred", "shhh");
  mysql_select_db("wedding", $connection);
  
  $result = mysql_unbuffered_query($query, $connection);
  
  while ($row = mysql_fetch_array($result))
     echo $row["present"] . "\n";
?>