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) ) {

};