คือหนูจะเขียนโค้ดสร้างหน้าล็อคอินค่ะปล้วมันเออเร่อ โค้ดประมาณนี้คะ
<?php
require 'connectdb.php';
$login_username = mysqli_real_escape_string ($db,$conn,$_POST['username']);
$login_password = mysqli_real_escape_string ($db,$conn,$_POST['password']);
$salt = 'sdctu39ijuchoplkacxzbvnmjhto';
$hash_login_password = hash_hmac ('sha256', $login_password, $salt);
$sql = "SELECT * FROM tb_login WHERE login_username=? AND login_password=?";
$stmt = mysqli_prepare($db,$conn,$sql);
mysqli_stmt_bind_param($stmt,"ss",$login_username,$hash_login_password);
mysqli_execute($stmt);
$result_user = mysqli_stmt_get_result($stmt);
if ($result_user->num_rows == 1) {
session_start();
$row_user = mysqli_fetch_array($result_user,MYSQLI_ASSOC);
$_SESSION['login_id'] = $row_user['login_username'];
header("Location: main.php");
} else {
echo "ผู้ใช้หรือรหัสผ่านไม่ถูกต้อง";
}
เออเร่อแบบนี้ค่ะ
Warning: mysqli_real_escape_string() expects exactly 2 parameters, 3 given in /home/cabox/workspace/login.php on line 4
Warning: mysqli_real_escape_string() expects exactly 2 parameters, 3 given in /home/cabox/workspace/login.php on line 5
Warning: mysqli_prepare() expects exactly 2 parameters, 3 given in /home/cabox/workspace/login.php on line 11
Warning: mysqli_stmt_bind_param() expects parameter 1 to be mysqli_stmt, null given in /home/cabox/workspace/login.php on line 12
Warning: mysqli_execute() expects parameter 1 to be mysqli_stmt, null given in /home/cabox/workspace/login.php on line 13
Fatal error: Call to undefined function mysqli_stmt_get_result() in /home/cabox/workspace/login.php on line 14
โค้ด PHP เออเร่อค่าช่วยด้วยค่าา
<?php
require 'connectdb.php';
$login_username = mysqli_real_escape_string ($db,$conn,$_POST['username']);
$login_password = mysqli_real_escape_string ($db,$conn,$_POST['password']);
$salt = 'sdctu39ijuchoplkacxzbvnmjhto';
$hash_login_password = hash_hmac ('sha256', $login_password, $salt);
$sql = "SELECT * FROM tb_login WHERE login_username=? AND login_password=?";
$stmt = mysqli_prepare($db,$conn,$sql);
mysqli_stmt_bind_param($stmt,"ss",$login_username,$hash_login_password);
mysqli_execute($stmt);
$result_user = mysqli_stmt_get_result($stmt);
if ($result_user->num_rows == 1) {
session_start();
$row_user = mysqli_fetch_array($result_user,MYSQLI_ASSOC);
$_SESSION['login_id'] = $row_user['login_username'];
header("Location: main.php");
} else {
echo "ผู้ใช้หรือรหัสผ่านไม่ถูกต้อง";
}
เออเร่อแบบนี้ค่ะ
Warning: mysqli_real_escape_string() expects exactly 2 parameters, 3 given in /home/cabox/workspace/login.php on line 4
Warning: mysqli_real_escape_string() expects exactly 2 parameters, 3 given in /home/cabox/workspace/login.php on line 5
Warning: mysqli_prepare() expects exactly 2 parameters, 3 given in /home/cabox/workspace/login.php on line 11
Warning: mysqli_stmt_bind_param() expects parameter 1 to be mysqli_stmt, null given in /home/cabox/workspace/login.php on line 12
Warning: mysqli_execute() expects parameter 1 to be mysqli_stmt, null given in /home/cabox/workspace/login.php on line 13
Fatal error: Call to undefined function mysqli_stmt_get_result() in /home/cabox/workspace/login.php on line 14