Integrating PHP dan MySQL Diposting oleh Dewi Nurmilah , Minggu, 01 November 2009 at 18.43, in

Pada bagian ini kita akan mengintegrasikan PHP dengan MySQL. PHP menyediakan fungsi-fungsi

untuk melakukan koneksi ke MySQL, mengambil data, mengupdate data, dan operasi database

lainnya.

connection.inc

$HOST = “localhost”; //database server, bisa menggunakan IP

$USER = “root”; //user login ke database

$PASS = “”; //password untuk login ke database

$DATA = “mydatabase”; //nama database

?>

testconnection.php

Setiap ingin melakukan koneksi ke database digunakan fungsi mysql_connect, kemudian untuk

memlilih database digunakan mysql_select_db, untuk menutup koneksi gunakan mysql_close


include (“connection.inc”);

$con = mysql_connect($HOST,$USER,$PASS); //koneksi database

mysql_select_db($DATA); //pilih database

//... lakukan operasi database di sini

mysql_close($con); //tutup koneksi

?>

membaca data dari database – mysql_fetch_array

include (“connection.inc”);

$con = mysql_connect($HOST,$USER,$PASS); //koneksi database

mysql_select_db($DATA); //pilih database

$result = mysql_query(“select * from PhoneBook”);

while ( $fetch = mysql_fetch_array($result) ){

echo $fetch[0] . “ “ . $fetch[“email”] . “
”;

}
mysql_close($con); //tutup koneksi

?>

menghitung jumlah record – mysql_num_rows

include (“connection.inc”);

$con = mysql_connect($HOST,$USER,$PASS); //koneksi database

mysql_select_db($DATA); //pilih database

$result = mysql_query(“select * from PhoneBook”);

$number_rows = mysql_num_rows($result);

echo $number_rows;

mysql_close($con); //tutup koneksi

?>

mengubah data di database – mysql_query


include (“connection.inc”);

$con = mysql_connect($HOST,$USER,$PASS); //koneksi database

mysql_select_db($DATA); //pilih database

$result = mysql_query(“update PhoneBook set

email=’somebody@hotmail.com’ where name=’john’”);

if($result){

echo “update success”;

}else{

echo “update fail”;

}

mysql_close($con); //tutup koneksi

?>

mendapatkan informasi kolom dari suatu tabel – mysql_num_fields, mysql_fetch_field


include (“connection.inc”);

$con = mysql_connect($HOST,$USER,$PASS); //koneksi database

mysql_select_db($DATA); //pilih database

$result = mysql_query("select * from PhoneBook")

or die("Query failed: " . mysql_error());

$i = 0;

while ($i < mysql_num_fields($result)) { //get column count

echo "Information for column $i:
\n";

$meta = mysql_fetch_field($result);

if (!$meta) {

echo "No information available
\n";

}

echo "

blob: $meta->blob
 

max_length: $meta->max_length
 

multiple_key: $meta->multiple_key
 

name: $meta->name
 

not_null: $meta->not_null  

numeric: $meta->numeric
 

primary_key: $meta->primary_key
 

table: $meta->table
 

type: $meta->type
 

unique_key: $meta->unique_key

unsigned: $meta->unsigned  

zerofill: $meta->zerofill  

";
$i++;
}
mysql_free_result($result);
mysql_close($con); //tutup koneksi
?>