Warning: mysqli_query() expects parameter 1 to be mysqli, null given in....
Code (PHP) $sql = "SELECT user_id FROM users WHERE user_name='".$u_name."'";
$db_query = mysql_query($conn,$sql) or die("Error Qeury [".$db_query."]"); <<----- บรรทัดนี้ครับ
$result = mysql_fetch_array($db_query) or die('Error Qeury ['.$result.']');
Date :
2010-10-14 20:20:09By :
deawx
mysql_query() ธรรมดาได้ ครับ...
Date :
2010-10-14 20:40:53By :
Newboy
mysqli_connect อยู่ไหนครับ
Date :
2010-10-15 00:07:07By :
PlaKriM
Code (PHP) error_reporting(E_ALL ^ E_NOTICE);
//---> Connect to DB --->
$host = 'localhost';
$user = 'root';
$pw = 'root';
$db_name = 'my_db';
$conn = mysqli_connect($host,$user,$pw);
if (!$conn) {
die('Connect Error : (' . mysqli_connect_errno() . ')<hr/>'. mysqli_connect_error());
}
Date :
2010-10-15 00:45:59By :
Newboy
$sql = "SELECT user_id FROM users WHERE user_name='".$u_name."'";
Date :
2010-10-15 02:06:34By :
PlaKriM
Code (PHP) error_reporting(E_ALL ^ E_NOTICE);
//---> Connect to DB --->
$host = 'localhost';
$user = 'root';
$pw = 'root';
$db_name = 'dynamaxim';
$conn = mysqli_connect($host,$user,$pw);
if (!$conn) {
die('Connect Error : (' . mysqli_connect_errno() . ')<hr/>'. mysqli_connect_error());
}
//-------------
$u_name = $_POST['username'];
$chkUser = selectUsername($u_name);
if($chkUser){
echo "<script>alert('Username Availided !');history.back();</script>";
die;
}else
echo 'OK';
//--------------
function selectUsername($u_name){
$sql = "SELECT user_id FROM users WHERE user_name='".$u_name."'";
$db_query = mysqli_query($conn,$sql) or die("Error Qeury [".$db_query."]");
$result = mysqli_fetch_array($db_query) or die('Error Qeury ['.$result.']');
return $result;
}
//-------------
<form id="register" name="register" method="post" action="reg.php" enctype="multipart/form-data">
<input type="text" name="username" id="username" />
<input type="submit" name="submit" id="submit" value="Submit" />
</form>
Date :
2010-10-15 02:13:22By :
Newboy
ดัน ครับ...
Date :
2010-10-15 13:14:14By :
Newboy
Code (PHP) error_reporting(E_ALL ^ E_NOTICE);
//---> Connect to DB --->
$host = 'localhost';
$user = 'root';
$pw = 'root';
$db_name = 'dynamaxim';
global $conn; //เพิ่ม
$conn = mysqli_connect($host,$user,$pw);
if (!$conn) {
die('Connect Error : (' . mysqli_connect_errno() . ')<hr/>'. mysqli_connect_error());
}
//-------------
$u_name = $_POST['username'];
$chkUser = selectUsername($u_name);
if($chkUser){
echo "<script>alert('Username Availided !');history.back();</script>";
die;
}else
echo 'OK';
//--------------
function selectUsername($u_name){
global $conn;
$sql = "SELECT user_id FROM users WHERE user_name='".$u_name."'";
$db_query = mysqli_query($conn,$sql) or die(mysqli_error($conn));
$result = mysqli_fetch_array($db_query) or die(mysqli_error($conn));
return $result;
}
//-------------
<form id="register" name="register" method="post" action="reg.php" enctype="multipart/form-data">
<input type="text" name="username" id="username" />
<input type="submit" name="submit" id="submit" value="Submit" />
</form>
Date :
2010-10-15 13:22:47By :
PlaKriM
Code (PHP) function selectUsername($u_name){
global $conn;
$sql = "SELECT user_id FROM users WHERE user_name='".$u_name."'";
$db_query = mysqli_query($conn,$sql) or die("Error Qeury [".$db_query."]");
$result = mysqli_fetch_array($db_query) or die('Error Qeury ['.$result.']');
return $result;
}
Date :
2010-10-15 13:25:16By :
pjgunner.com
ขึ้น Error Qeury [] ไม่ฟ้องอย่างอื่นเลยครับ...Code (PHP) function selectUsername($u_name){
global $conn;
$sql = "SELECT user_id FROM users WHERE user_name='".$u_name."'";
$db_query = mysqli_query($conn,$sql) or die("ำrror Qeury [".$db_query."]");
$result = mysqli_fetch_array($db_query) or die('Error Qeury ['.$result.']'); //<<--- Error Qeury [] ตรงนี้ครับ...
$result = mysqli_fetch_array($db_query) or die(mysqli_error($conn)); // ถ้าแบบนี้ไม่มีอะไรเกิดขึ้นเลยครับ... ขาวสะอาด
return $result;
}
Date :
2010-10-15 18:52:04By :
Newboy
Code (PHP) error_reporting(E_ALL ^ E_NOTICE);
//---> Connect to DB --->
$host = 'localhost';
$user = 'root';
$pw = 'root';
$db_name = 'dynamaxim';
global $conn; //เพิ่ม
$conn = mysqli_connect($host,$user,$pw);
if (!$conn) {
die('Connect Error : (' . mysqli_connect_errno() . ')<hr/>'. mysqli_connect_error());
}
//-------------
$u_name = $_POST['username'];
$chkUser = selectUsername($u_name);
if($chkUser){
echo "<script>alert('Username Availided !');history.back();</script>";
die;
}else
echo 'OK';
//--------------
function selectUsername($u_name){
global $conn;
$sql = "SELECT user_id FROM users WHERE user_name='".$u_name."'";
$db_query = mysqli_query($conn,$sql) or die(mysqli_error($conn));
$result = mysqli_fetch_array($db_query, MYSQLI_ASSOC) or die(mysqli_error($conn));
return $result;
}
//-------------
<form id="register" name="register" method="post" action="reg.php" enctype="multipart/form-data">
<input type="text" name="username" id="username" />
<input type="submit" name="submit" id="submit" value="Submit" />
</form>
Date :
2010-10-16 00:41:23By :
PlaKriM
ได้แล้วครับ ขอบคุณครับ... ทำไปทำมาเป็นแบบนี้ครับ
Date :
2010-10-16 01:57:35By :
Newboy
งง คับ ทำไมต้อง mysqli ด้วยคับ แตกต่างกันยังไง กับ mysql ทำมาดา
Date :
2011-10-13 11:03:23By :
yokoiioyok
ดีค่ะ
Date :
2017-10-04 12:45:29By :
ชนกสุดา
ลองเข้าไปดูในไฟล์ connectdb.php
Date :
2017-10-04 13:04:46By :
Chaidhanan
$sql = "SELECT user_id FROM users WHERE user_name='".$u_name."'";
Date :
2021-07-29 15:03:43By :
teerasak
โทษทีคับ
Date :
2021-07-29 15:04:53By :
teerasak
1
Date :
2024-07-07 13:18:36By :
pHqghUme
Server 04
Load balance : Server 04
