PHP telah
menyediakan banyak perintah fungsi bawaan yang bisa kita gunakan dalam
membuat aplikasi web. Fungsi-fungsi tersebut juga sangat beragam dari
pengolahan string, pengolahan dan manipulasi gambar, sampai melakukan
komunikasi dengan database. PHP juga mendukung banyak database tidak
terkecuali berikut ini adalah beberapa perintah Mysql yang biasa di gunakan
Contoh :
Contoh :
Contoh :
Contoh :
Mysql_connect
Memilih Server Database Mysql
<?php
$ link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$ link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($ link);
$ link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$ link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($ link);
Mysql_select_db
Memilih database MySQLContoh :
<?php
$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link) {
die('Not connected : ' . mysql_error());
}
$db_selected = mysql_select_db('db_mahasiswa', $link);
if (!$db_selected) {
die ('Gagal : ' . mysql_error());
}
?>
$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link) {
die('Not connected : ' . mysql_error());
}
$db_selected = mysql_select_db('db_mahasiswa', $link);
if (!$db_selected) {
die ('Gagal : ' . mysql_error());
}
?>
mysql_close
Menutup koneksi database MySqlContoh :
<?php
$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);
?>
$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);
?>
Mysql_db_name
Mengambil nama database yang sedang aktifContoh :
<?php
error_reporting(E_ALL);
$link = mysql_connect('dbhost', 'username', 'password');
$db_list = mysql_list_dbs($link);
$i = 0;
$cnt = mysql_num_rows($db_list);
while ($i < $cnt) {
echo mysql_db_name($db_list, $i) . "\n";
$i++;
}
?>
error_reporting(E_ALL);
$link = mysql_connect('dbhost', 'username', 'password');
$db_list = mysql_list_dbs($link);
$i = 0;
$cnt = mysql_num_rows($db_list);
while ($i < $cnt) {
echo mysql_db_name($db_list, $i) . "\n";
$i++;
}
?>
Mysql_errno
Mengambil nomor error dari operasi MySqlContoh :
<?php
$link = mysql_connect("localhost", "mysql_user", "mysql_password");
if (!mysql_select_db("nonexistentdb", $link)) {
echo mysql_errno($link) . ": " . mysql_error($link). "\n";
}
mysql_select_db("kossu", $link);
if (!mysql_query("SELECT * FROM nonexistenttable", $link)) {
echo mysql_errno($link) . ": " . mysql_error($link) . "\n";
}
?>
$link = mysql_connect("localhost", "mysql_user", "mysql_password");
if (!mysql_select_db("nonexistentdb", $link)) {
echo mysql_errno($link) . ": " . mysql_error($link). "\n";
}
mysql_select_db("kossu", $link);
if (!mysql_query("SELECT * FROM nonexistenttable", $link)) {
echo mysql_errno($link) . ": " . mysql_error($link) . "\n";
}
?>
mysql_fecth_array
Mengambil hasil query dalam bentuk arrayContoh :
<?php
mysql_connect("localhost", "mysql_user", "mysql_password") or
die("Could not connect: " . mysql_error());
mysql_select_db("mydb");
$result = mysql_query("SELECT id, name FROM mytable");
while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
printf ("ID: %s Name: %s", $row[0], $row["name"]);
}
mysql_free_result($result);
?>
mysql_connect("localhost", "mysql_user", "mysql_password") or
die("Could not connect: " . mysql_error());
mysql_select_db("mydb");
$result = mysql_query("SELECT id, name FROM mytable");
while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
printf ("ID: %s Name: %s", $row[0], $row["name"]);
}
mysql_free_result($result);
?>