Monday 30 September 2013

Connection Code PHP - MSql

Ini tak sekedar hanya connection stringnya saja, tetapi juga bagaimana cara menulis query MySQL-nya dan membaca hasil Querynya dengan looping while
<?php
//konfigurasi nama server username,password nama database
$myServer = "server-name";
$myUser = "user-name";
$myPass = "password";
$myDB = "database-name";
//tes konek ke servernya
$dbhandle = mssql_connect($myServer, $myUser, $myPass)
or die("Couldn't connect to SQL Server on $myServer");
//tes konek ke databasenya
$selected = mssql_select_db($myDB, $dbhandle)
or die("Couldn't open database $myDB");
//deklarasi querynya
$query = "select * from namaTablenya ";
//mengeksekusi query di atas
$result = mssql_query($query);
//looping hasilnya dengan while
while($row = mssql_fetch_array($result))
{
echo "<li>" . $row["idSiswa"] . $row["nama"] . $row["kelas"] . "</li>";
}
//menutup koneksi ke database
mssql_close($dbhandle);
?>

No comments:

Post a Comment