PHP  MySQL Connection and Data Access Three Syntax

12/27/2008

 

Procedural Syntax                                                           Object-Oriented Syntax

$dbc = mysqli_connect ($host, $user, $password, $dbname ); |   $dbc = new mysqli ($host, $user, $password, $dbname);

mysqli_select_db( $dbc, $dbname );                                      |   $dbc -> select_db ($dbc, $dbname);

$query = "SELECT username, password FROM user_info";      |      Same
$result = mysqli_query ( $dbc, $query );                                |     $result = $dbc -> query ( $query ) ;

$row = mysqli_fetch_assoc ( $result );                                   |   $row = $result -> fetch_assoc ( ) ;

$number_rows = mysqli_num_rows ( $result );                      |   $number_rows = $result -> num_rows ;

extract  ( $row ) ;                                                                   |   Same

mysqli_free_result ( $result );                                                |   $result -> free ( );

mysqli_close( $dbc );                                                            |   $dbc -> close ( );

     

[ Object-Oriented Syntax

 $dbc = new mysqli ($host, $user, $password, $dbname);

$dbc -> select_db ($dbc, $dbname);

$query = "SELECT username, password FROM user_info";        

$result = $dbc -> query ( $query ) ;

$row = $result -> fetch_assoc ( ) ;

$number_rows = $result -> num_rows ;

extract  ( $row ) ;

$result -> free ( );

$dbc -> close ( ); ]

 

Use PEAR DB

$db_type = ‘mysql’;

require_once ( ‘DB.php’ );

$dsn = “$db_type://$user:$password/$dbname”;

$dbc = DB::connect($dsn);

if (DB::isError($dbc) )  {

   exit (“Unable to connect: “ . $dbc -> getMessage( ) . “\n”) ;

}

$query = “SELECT username, password FROM user_info";

$result = $dbc -> query ( $query ) ;

if (DB::isError($result)  {

   exit (“Query ($query) failed: “ . $result -> getMessage( ) . “\n”);

}

while ($row = $result -> fetchRow(DB_FETCHMODE_ASSOC) )  {

     

};