|
![](/images/resource/spacer.gif) |
|
การ INSERT ข้อมูลเข้าไปที่ Table แบบมีเงื่อนไขครับ |
|
![](/images/resource/viewboard_01.gif?v=1001) |
|
|
![](/images/resource/viewboard_03.gif?v=1001) |
![](/images/resource/viewboard_04.gif?v=1001) |
|
select ดูก่อนครับ ถ้าไม่ซ้ำค่อย insert
|
![](/images/resource/blockviewtopic_01.gif?v=1001) |
![](/images/resource/blockviewtopic_02.gif?v=1001) |
![](/images/resource/blockviewtopic_03.gif?v=1001) |
![](/images/resource/blockviewtopic_04.gif?v=1001) |
Date :
2012-11-09 11:45:24 |
By :
cyberstein |
|
![](/images/resource/blockviewtopic_06.gif?v=1001) |
![](/images/resource/blockviewtopic_07.gif?v=1001) |
![](/images/resource/blockviewtopic_08.gif?v=1001) |
![](/images/resource/blockviewtopic_09.gif?v=1001) |
|
|
![](/images/resource/viewboard_06.gif?v=1001) |
![](/images/resource/viewboard_07.gif?v=1001) |
|
![](/images/resource/viewboard_08.jpg?v=1001) |
![](/images/resource/viewboard_09.gif?v=1001) |
![](/images/resource/viewboard_01.gif?v=1001) |
|
|
![](/images/resource/viewboard_03.gif?v=1001) |
![](/images/resource/viewboard_04.gif?v=1001) |
|
เอาไปลองเอง ![](/images/bbcode/grin.gif?v=1001)
Code (PHP)
<?
include("connect.php");
$strSQL = "SELECT * FROM member WHERE NAME = '".trim($_POST["NAME"])."' ";
$objQuery = mysql_query($strSQL);
$objResult = mysql_fetch_array($objQuery);
if($objResult)
{
echo "บันทึก ชื่อซ้ำกันไม่ได้";
echo "<meta http-equiv=refresh content=1;URL=insert.php>";
}
else
{
$strSQL = "INSERT INTO member ";
$strSQL .="(id,NAME,color) ";
$strSQL .="VALUES ";
$strSQL .="('".$_POST["id"]."','".$_POST["NAME"]."','".$_POST["color"]."') ";
$objQuery = mysql_query($strSQL);
if($objQuery)
{
echo "บันทึกข้อมูลเรียบร้อย";
echo "<meta http-equiv=refresh content=1;URL=member.php>";
}
else
{
echo "Error Save [".$strSQL."]";
}
}
?>
|
![](/images/resource/blockviewtopic_01.gif?v=1001) |
![](/images/resource/blockviewtopic_02.gif?v=1001) |
![](/images/resource/blockviewtopic_03.gif?v=1001) |
![](/images/resource/blockviewtopic_04.gif?v=1001) |
Date :
2012-11-09 11:56:26 |
By :
compiak |
|
![](/images/resource/blockviewtopic_06.gif?v=1001) |
![](/images/resource/blockviewtopic_07.gif?v=1001) |
![](/images/resource/blockviewtopic_08.gif?v=1001) |
![](/images/resource/blockviewtopic_09.gif?v=1001) |
|
|
![](/images/resource/viewboard_06.gif?v=1001) |
![](/images/resource/viewboard_07.gif?v=1001) |
|
![](/images/resource/viewboard_08.jpg?v=1001) |
![](/images/resource/viewboard_09.gif?v=1001) |
|
|
|
![](/images/digitalocean-banner.jpg)
|
Load balance : Server 00
|