#connect.php
/*
DEFINE('DB_USERNAME', 'root');
DEFINE('DB_PASSWORD', 'root');
DEFINE('DB_HOST', 'localhost');
DEFINE('DB_DATABASE', 'cambodia_fishinglicense');
$mysqli = new mysqli(DB_HOST, DB_USERNAME, DB_PASSWORD, DB_DATABASE);
*/
$serverName = "localhost";
$userName = "seafdec_sd";
$userPassword = "CA2p0rU9DI";
$dbName = "seafdec_book";
$conn = mysqli_connect($serverName,$userName,$userPassword,$dbName);
mysqli_query($conn,"SET CHARACTER SET 'utf8'");
mysqli_query($conn,"SET SESSION collation_connection ='utf8_unicode_ci'");
// Check connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
else
{
//echo "Connect Successful";
}
//$mysqli_close($conn);
?>
No. |
Title |
Author |
Publisher |
Page |
Call Number |
Series |
No. |
Title |
Author |
Publisher |
Page |
Call Number |
Series |
$sql = "SELECT * FROM main";
$rs = mysqli_query($conn,$sql) or die (mysqli_error()." Error $sql");
$count = mysqli_num_rows($rs);
$no=1;
while($row=mysqli_fetch_array($rs))
{
?>
|
|
|
|
|
|
|
} //end while
?>
|