มันขึ้น error แบบนี้ค่ะ ต้องแก้ยังไงคะ
Fatal error: Uncaught Error: Call to undefined function mysql_select_db() in C:\xampp1\htdocs\myphp\check_login.php:3 Stack trace: #0 {main} thrown in C:\xampp1\htdocs\myphp\check_login.php on line 3
โค้ดตามนี้เลยค่ะ
<?php
session_start();
mysql_connect("localhost","root","root");
mysql_select_db("mydatabase, [$link]");
$strSQL = "SELECT * FROM member WHERE Username = '".mysql_real_escape_string($_POST['txtUsername'])."'
and Password = '".mysql_real_escape_string($_POST['txtPassword'])."'";
$objQuery = mysql_query($strSQL);
$objResult = mysql_fetch_array($objQuery);
if(!$objResult)
{
echo "Username and Password Incorrect!";
}
else
{
$_SESSION["UserID"] = $objResult["UserID"];
$_SESSION["Status"] = $objResult["Status"];
session_write_close();
if($objResult["Status"] == "ADMIN")
{
header("location:admin_page.php");
}
else
{
header("location:user_page.php");
}
}
mysql_close();
?>
เชื่อม php กับ mysql
Fatal error: Uncaught Error: Call to undefined function mysql_select_db() in C:\xampp1\htdocs\myphp\check_login.php:3 Stack trace: #0 {main} thrown in C:\xampp1\htdocs\myphp\check_login.php on line 3
โค้ดตามนี้เลยค่ะ
<?php
session_start();
mysql_connect("localhost","root","root");
mysql_select_db("mydatabase, [$link]");
$strSQL = "SELECT * FROM member WHERE Username = '".mysql_real_escape_string($_POST['txtUsername'])."'
and Password = '".mysql_real_escape_string($_POST['txtPassword'])."'";
$objQuery = mysql_query($strSQL);
$objResult = mysql_fetch_array($objQuery);
if(!$objResult)
{
echo "Username and Password Incorrect!";
}
else
{
$_SESSION["UserID"] = $objResult["UserID"];
$_SESSION["Status"] = $objResult["Status"];
session_write_close();
if($objResult["Status"] == "ADMIN")
{
header("location:admin_page.php");
}
else
{
header("location:user_page.php");
}
}
mysql_close();
?>