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