 |
[PHP+MySQL]ไม่สามารถบันทึกข้อมูลลงฐานข้อมูลได้ และไม่มี Error ใดๆแสดงครับ |
|
 |
|
|
 |
 |
|
สวัสดีครับ รบกวนพี่ๆเพื่อนๆสมาชิกช่วยดูให้นิดนึงครับว่าผมพลาดตรงไหน บันทึกข้อมูลลงฐานข้อมูลไม่ได้ครับ และไม่มีเออเร่อใดๆ
Code (PHP)
<?php include('function.php'); ?>
<?php
if(isset($_POST["sbmt"]))
{
$cn=makeconnection();
$s="insert into booking(Packageid,Name,Gender,Mobileno,Email,NoofDays,Child,Adults,) values('" . $_REQUEST["pid"] ."','" . $_POST["t1"] ."','" . $_POST["r1"] ."','" . $_POST["t2"] ."','" . $_POST["t3"] ."','" . $_POST["t4"] ."','" . $_POST["t5"] ."','" . $_POST["t6"] ."')";
mysqli_query($cn,$s);
echo "<script>alert('Record Save');</script>";
}
?>
<?php
$s="select * from package,category,subcategory where package.category=category.cat_id and package.subcategory=subcategory.subcatid and package.packid='" . $_GET["pid"] ."'";
$result=mysqli_query($cn,$s);
$r=mysqli_num_rows($result);
//echo $r;
$n=0;
$data=mysqli_fetch_array($result);
mysqli_close($cn);
?>
<form method="post" enctype="multipart/form-data">
<p>Package Id: <?php echo $data[0];?></p>
<p>Pack Name: <?php echo $data[1];?></p>
<p>Name</p>
<input type="text" name="t1" required pattern="{3,500}" title"Please Enter Only Characters and numbers between 1 to 50 for Name"/>
<p>Gender</p>
<input type="radio" name="r1" value="Male" checked="checked" />Male<input type="radio" name="r1" value="Female"/>Female
<p>Mobile No.</p>
<input type="text" name="t2" required pattern="[0-9]{10}" title"Please Enter Only Characters and numbers between 1 to 50 for Name"/>
<p>Email</p>
<input type="text" name="t3" required pattern="{3,500}" title"Please Enter Only Characters and numbers between 1 to 50 for Name"/>
<p>No.of Days</p>
<input type="number" name="t4" required pattern="[1 _]{1,20}" title"Please Enter Only Characters and numbers between 1 to 50 for Name"/>
<p>No.of Children</p>
<input type="number" name="t5" required pattern="[1 _]{1,20}" title"Please Enter Only Characters and numbers between 1 to 50 for Name"/>
<p>No.of Adults</p>
<input type="number" name="t6" required pattern="[1 _]{1,20}" title"Please Enter Only Characters and numbers between 1 to 50 for Name"/>
<input type="submit" value="Booking" name="sbmt">
</form>
Tag : PHP, MySQL
|
|
 |
 |
 |
 |
Date :
2017-11-11 20:09:40 |
By :
TH.Ditsakorn |
View :
723 |
Reply :
1 |
|
 |
 |
 |
 |
|
|
|
 |
 |
|
 |
 |
 |
|
|
 |
 |
|
Code (PHP)
$s="insert into booking(Packageid,Name,Gender,Mobileno,Email,NoofDays,Child,Adults,) values('" . $_REQUEST["pid"] ."','" . $_POST["t1"] ."','" . $_POST["r1"] ."','" . $_POST["t2"] ."','" . $_POST["t3"] ."','" . $_POST["t4"] ."','" . $_POST["t5"] ."','" . $_POST["t6"] ."')";
$cn->query($s) or die( $s ."<br>". $cn->error);
if( $cn->affected_rows == 0 ){
echo "<script>alert('Can not insert\\\\n$s')</script>"; exit;
}
echo "<script>alert('Record Save ".$cn->affected_rows." record(s)');</script>";
|
 |
 |
 |
 |
Date :
2017-11-11 20:58:35 |
By :
Chaidhanan |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
|
|