รบกวนช่วยดูทีครับ ผมต้องการให้ผู้ใช้กรอกข้อมูลลงไปแล้วพอกดปุ่มก็เพิ่มข้อมูลลงในฐานข้อมูล
คือผมทำ textfield ให้กรอกข้อมูลครับ เมื่อกรอกข้อมูลเสร้จแล้วจะเพิ่มข้อมูลลงในฐานข้อมูล แต่พอลองทำแล้วมันขึ้นแบบเนี้ยครับCode Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\AppServ\www\MediaNVC\AddData.php on line 16
Code (PHP) <?php
$host="127.0.0.1";
$user="root";
$passwd="1234";
$dbname="medianvc";
mysql_connect($host,$user,$passwd) or die("Could not connect to Host");
mysql_select_db($dbname) or die("Could not connect to Database");
$sql="insert into'roomdata'('date','mth','year','start','end','room','user','info')
values('$date','$mth','$year','$start','$end','$room','$user','$info')";
mysql_query("set NAMES utf8");
$sqlquery=mysql_db_query($dbname,$sql);
$checkadd="select*from'roomdata'where date='$date'";
$result=mysql_db_query($dbname,$checkadd);
$checkadd="select*from'roomdata'where date='$date'";
$result=mysql_db_query($dbname,$checkadd);
$num=mysql_num_rows($result);
if($num==1)
{
print"<br>access add to database";
}
mysql_close();
?>
Tag PHP, MySQL, CakePHP
Date :
2011-04-05 09:46:34By :
tempestarView :
707Reply :
2
Code (PHP) <html>
<head>
<title>ThaiCreate.Com PHP & MySQL Tutorial</title>
</head>
<body>
<?
$objConnect = mysql_connect("localhost","root","root") or die("Error Connect to Database");
$objDB = mysql_select_db("mydatabase");
$strSQL = "INSERT INTO customer ";
$strSQL .="(CustomerID,Name,Email,CountryCode,Budget,Used) ";
$strSQL .="VALUES ";
$strSQL .="('".$_POST["txtCustomerID"]."','".$_POST["txtName"]."','".$_POST["txtEmail"]."' ";
$strSQL .=",'".$_POST["txtCountryCode"]."','".$_POST["txtBudget"]."','".$_POST["txtUsed"]."') ";
$objQuery = mysql_query($strSQL);
if($objQuery)
{
echo "Save Done.";
}
else
{
echo "Error Save [".$strSQL."]";
}
mysql_close($objConnect);
?>
</body>
</html>
Go to : PHP MySQL Add/Insert Record
Date :
2011-04-05 10:37:53By :
webmaster
Code (PHP) $host="127.0.0.1";
$user="root";
$passwd="1234";
$dbname="medianvc";
mysql_connect($host,$user,$passwd) or die("Could not connect to Host");
mysql_select_db($dbname) or die("Could not connect to Database");
$sql="insert into roomdata (date,mth,year,start,end,room,user,info')values('$date','$mth','$year','$start','$end','$room','$user','$info')";
mysql_query("set NAMES utf8");
$sqlquery=mysql_db_query($dbname,$sql);
$checkadd="select * from roomdata where date='$date'";
$result=mysql_db_query($dbname,$checkadd);
$num=mysql_num_rows($result);
if($num==1)
{
print"<br>access add to database";
}
mysql_close();
Date :
2011-04-05 10:39:00By :
avsqlz
Server 03
Load balance : Server 03
