ຊ່ວຍເບີງໂຄດໃຫ້ແດ່ມັນຟ້ອງ
Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\\xampp\\htdocs\\ticket\\data.php on line 16

<?php

$name=$_POST['name'];
//echo $name;

mysql_connect("localhost","root","");
$name = mysql_real_escape_string($_POST['name']);


if($name == NULL)
echo "please enter a name";
else
{

$phonenumber = mysql_query("SELECT phonenumber FROM ticket.user WHERE name='$name");
$phonenumber_num_rows = mysql_num_rows($phonenumber);
if($phonenumber_num_rows == 0)
echo "Name dose not exist";
else
{
$phonenumber=mysql_result($phonenumber,0);
echo "$name 's phonenumber is $phonenumber";
}
}

?>

ໂຄດຫຍັງນິ ບໍ່ຮູ້ເລີຍ ຮິຮິ

ເຮົາກະບໍ່ຮູ້

^^

ເຮົາກະບໍ່ຮູ້

ເອົາໃປເລີຍ session php ແບບເຕັມໆ

CREATE TABLE `member` (
`UserID` int(3) unsigned zerofill NOT NULL auto_increment,
`Username` varchar(20) NOT NULL,
`Password` varchar(20) NOT NULL,
`Name` varchar(100) NOT NULL,
`Status` enum('ADMIN','USER') NOT NULL default 'USER',
PRIMARY KEY (`UserID`),
UNIQUE KEY `Username` (`Username`)
) ENGINE=MyISAM AUTO_INCREMENT=3 ;

--
-- Dumping data for table `member`
--

INSERT INTO `member` VALUES (001, 'win', 'win123', 'Weerachai Nukitram', 'USER');
INSERT INTO `member` VALUES (002, 'chai', 'chai123', 'Surachai Sirisart', 'ADMIN');


PHP MySQL Member Login



login.php เป็น Form Login


ThaiCreate.Com Tutorials


<form>
Login<br>
<table border="1" style="width: 300px">
<tbody>
<tr>
<td>  Username</td>
<td>
<input>
</td>
</tr>
<tr>
<td>  Password</td>
<td><input>
</td>
</tr>
</tbody>
</table>
<br>
<input>
</form>




check_login.php
<?
session_start();
mysql_connect("localhost","root","root");
mysql_select_db("mydatabase");
$strSQL = "SELECT * FROM member WHERE Username = '".trim($_POST['txtUsername'])."'
and Password = '".trim($_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 Member Login


<?
session_start();
if($_SESSION['UserID'] == "")
{
echo "Please Login!";
exit();
}

if($_SESSION['Status'] != "ADMIN")
{
echo "This page for Admin only!";
exit();
}

mysql_connect("localhost","root","root");
mysql_select_db("mydatabase");
$strSQL = "SELECT * FROM member WHERE UserID = '".$_SESSION['UserID']."' ";
$objQuery = mysql_query($strSQL);
$objResult = mysql_fetch_array($objQuery);
?>


ThaiCreate.Com Tutorials


Welcome to Admin Page! <br>
<table border="1" style="width: 300px">
<tbody>
<tr>
<td width="87">  Username</td>
<td width="197"><?=$objResult["Username"];?>
</td>
</tr>
<tr>
<td>  Name</td>
<td><?=$objResult["Name"];?></td>
</tr>
</tbody>
</table>
<br>
<a href="edit_profile.php">Edit</a><br>
<br>
<a href="logout.php">Logout</a>



PHP MySQL Member Login



user_page.php
<?
session_start();
if($_SESSION['UserID'] == "")
{
echo "Please Login!";
exit();
}

if($_SESSION['Status'] != "USER")
{
echo "This page for User only!";
exit();
}

mysql_connect("localhost","root","root");
mysql_select_db("mydatabase");
$strSQL = "SELECT * FROM member WHERE UserID = '".$_SESSION['UserID']."' ";
$objQuery = mysql_query($strSQL);
$objResult = mysql_fetch_array($objQuery);
?>


ThaiCreate.Com Tutorials


Welcome to User Page! <br>
<table border="1" style="width: 300px">
<tbody>
<tr>
<td width="87">  Username</td>
<td width="197"><?=$objResult["Username"];?>
</td>
</tr>
<tr>
<td>  Name</td>
<td><?=$objResult["Name"];?></td>
</tr>
</tbody>
</table>
<br>
<a href="edit_profile.php">Edit</a><br>
<br>
<a href="logout.php">Logout</a>




PHP MySQL Member Login


edit_profile.php
<?
session_start();
if($_SESSION['UserID'] == "")
{
echo "Please Login!";
exit();
}

mysql_connect("localhost","root","root");
mysql_select_db("mydatabase");
$strSQL = "SELECT * FROM member WHERE UserID = '".$_SESSION['UserID']."' ";
$objQuery = mysql_query($strSQL);
$objResult = mysql_fetch_array($objQuery);
?>


ThaiCreate.Com Tutorials


<form>
Edit Profile! <br>
<table width="400" border="1" style="width: 400px">
<tbody>
<tr>
<td width="125">  UserID</td>
<td width="180">
<?=$objResult["UserID"];?>
</td>
</tr>
<tr>
<td>  Username</td>
<td>
<?=$objResult["Username"];?>
</td>
</tr>
<tr>
<td>  Password</td>
<td><input><?=$objResult["Password"];?>">
</td>
</tr>
<tr>
<td>  Confirm Password</td>
<td><input><?=$objResult["Password"];?>">
</td>
</tr>
<tr>
<td> Name</td>
<td><input><?=$objResult["Name"];?>"></td>
</tr>
<tr>
<td>  Status</td>
<td>
<?=$objResult["Status"];?>
</td>
</tr>
</tbody>
</table>
<br>
<input>
</form>




PHP MySQL Member Login


save_profile.php
<?
session_start();
if($_SESSION['UserID'] == "")
{
echo "Please Login!";
exit();
}
mysql_connect("localhost","root","root");
mysql_select_db("mydatabase");

if($_POST["txtPassword"] != $_POST["txtConPassword"])
{
echo "Password not Match!";
exit();
}
$strSQL = "UPDATE member SET Username = '".trim($_POST['txtPassword'])."'
,Name = '".trim($_POST['txtName'])."' WHERE UserID = '".$_SESSION["UserID"]."' ";
$objQuery = mysql_query($strSQL);

echo "Save Completed!<br>";

if($_SESSION["Status"] == "ADMIN")
{
echo "<br> Go to <a href='admin_page.php'>Admin page</a>";
}
else
{
echo "<br> Go to <a href='user_page.php'>User page</a>";
}

mysql_close();
?>


PHP MySQL Member Login

logout.php
<?
session_start();
session_destroy();
header("location:login.php");
?>



ອ້າງອີງເຖິງ http://www.thaicreate.com/community/php-mysql-login-form-check-username-password.html

ມາຈອບເບິ່ງນຳ...

^^

ຕາມສະບາຍເດີ້ ພີ່ນ້ອງ

ບໍ່ຮູ້ນຳຄືກັນ ແຮໆ

ໃຊ້ Joomla ຫຼື ແມ່ນຫຍັງ ?? ກະບອກ ລະອຽດແດ່
ທ່ານ ກຳລັງ ໃຊ້ xampp ຢູ່
ໃຫ້ ປ່ຽນໄປໃຊ້ AppServ ດີກວ່າ xampp

ໃຊ້ php ຂຽນ

ບໍ່ຈັກເລີຍ

ມາແວ່ຊື່ໆໆ

ອືມ...

session ທ່ານດືງເອົາ ຊື່ຂື້ນມາໂຊບໍ່ໄດ້

ຂອບໃຈທຸກທ່ານ ອີອີ ແກ້ໄຂໄດ້ແລ້ວ

ບໍຮູ້ຄືກັນ
ຕອນອ່ານ ວ່າບໍ່ຮູ້ ບາດ ເຂົ້າມາອ່ານ ແລ້ວ ແຮງຫນັກ ກວ່າຕອນບໍ່ອ່ນອີກ ແຕ່ກໍ່ຍັງດີ ທີ່ໄດ້ຮູ້ວ່າເລື່ອງນີ້ເປັນ ອີກເລືອ່ງຫນຶ່ງທີ່ຍັງບໍ່ທັງໄດ້ຮູ້

ສົນໃຈຄືກັນ php

ເຄື່ອງໝາຍຜິດ

ຈາກ

$phonenumber = mysql_query("SELECT phonenumber FROM ticket.user WHERE name='$name");

ປ່ຽນເປັນ

$phonenumber = mysql_query("SELECT phonenumber FROM ticket.user WHERE name='$name' ");

ງົງເລີຍເຮົາ

ພາສາphp ເຮົາບ່ອຄ່ອຍຮູ້ປານໃດ ຮູ້ແຕ່ພາສາລາວເດີ້ ຊ່ອຍສອນພາສາ HTML CSS XML JAVASCRIPT ASP PHP SQL ໃຫ້ຂ້ອຍແນ່ເດີ້ຊຶເອົາເງິນໃຫ້

ທ່ານເຂົ້າໃປສືກສາເອົາເລີຍ............ເຄຮີກເລີຍ................

ມີຜູ້ຮູ້ ມາຊ່ວຍ ແລ້ວເບາະ