รบกวนท่านเซียน php ช่วยแนะนำหน่อย เรื่อง ด้าต้าเบส ครับ เทสหลายรอบแล้ว แต่มึนตืบเลย
ตัวอย่าง ฟอร์ม Code (PHP) <form id="signup" action="add.php" method="post" >
<h1>Make an apoitment.</h1>
<table align="center" width="500">
<tr>
<td><div ><input type="name" name="name" placeholder="your Name" required=""> </div> </td>
<td><div ><input type="phone" name="phone" placeholder="Phone:321-111-1111" required=""> </div> </td>
<td> <div ><input type="email" name="email" placeholder="your@email " required=""> </div></td>
</tr>
<tr><td><div > <select id="cou" name="cou">
<option selected="selected" >selected Course</option>
<option value="Blow dry">Blow dry</option>
<option value="Shampoo & pro dry">Shampoo & pro dry</option>
<option value="Shampoo,cut and style">Shampoo,cut and style</option>
<option value="Men's haircut">Men's haircut </option>
<option value="Children Hair cut">Children Hair cut </option>
<option value="Advanced Styles">Advanced Styles</option>
<option value="Color Touch-up">Color Touch-up</option>
<option value="All over color">All over color</option>
<option value="Partial Highligh">Partial Highligh</option>
<option value="Full Highlight">Full Highlight</option>
<option value="Partial Baylayage">Partial Baylayage</option>
<option value="Full Baylayag">Full Baylayag</option>
<option value="Makeup application">Makeup application</option>
</select>
</div> </td>
<td><div > <input type="date" name="recdate" id="dateInput" value="" /> </div> </td>
<td> <div id="sigampm" > <input type="time" name="rectime">
<select name="ampm" >
<option value="am">AM</option>
<option value="pm">PM</option>
</select>
</div></td>
</tr>
<tr>
<td> </td>
<td></td>
<td></td>
</tr>
</table>
<div >
</div>
<div id="signupp" ><input type="ment" name="ment" placeholder=" Your Comment " required="" > </div>
<div align="center"> <button type="reset" name="reset">reset</button> <button type="submit" name="submit"> an apoitment</button> </div>
</form>
Code (PHP) <?php
include('connect.php');
$name=$_POST['name'];
$phone=$_POST['phone'];
$email=$_POST['email'];
$cou=$_POST['cou'];
$dateInput=$_POST['dateInput'];
$timeInput =$_POST['timeInput'];
$ampm =$_POST['ampm'];
$ment=$_POST['ment'];
$sql = "INSERT INTO customer( name,phone,email,cou,dateInput,timeInput,ampm,ment)
VALUES('$name','$phone','$email','$cou','$dateInput','$timeInput','$ampm','$ment' )";
$result=mysql_query($sql);
echo $sql;
echo mysql_error();
if($result) {
echo "Record add successfully";
}
?>
Quote:
INSERT INTO customer( name,phone,email,cou,recdate,rectime,ampm,ment) VALUES(,'tom yamyai','0839746624','
[email protected] ','Shampoo & pro dry','2016-03-18','06:10','pm','i need to try' )You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''tom yamyai','0839746624','
[email protected] ','Shampoo & pro dry','2016-03-18','06:1' at line 2
Tag PHP, MySQL
ประวัติการแก้ไข
Date :
2016-03-16 00:03:46By :
kangpla111View :
964Reply :
9
VALUES(,
Date :
2016-03-16 05:40:15By :
Chaidhanan
Code PHP
Date :
2016-03-16 06:01:45By :
nomzod
ผมแก้แล้ว แต่ วันที่กับเวลา แอดไม่ได้ หมายถึง โพส ไม่ผ่านครับ Quote: INSERT INTO customer( name,phone,email,cou,dateInput,timeInput,ampm,ment) VALUES('kangpla','0123456789','
[email protected] ','Blow dry'
,'','', 'am','sddddddddddddddddddddddddddddddddddddddddddddddddddddddddd' )Record add successfully
ประวัติการแก้ไข
Date :
2016-03-16 21:42:02By :
kangpla111
timestamp on update current_timestamp ไม่ต้องไปใส่ มันใส่ให้เองอัตตโนมัตCode (SQL)
INSERT INTO customer( name,phone,email,cou,dateInput,ampm,ment) VALUES('kangpla','0123456789','[email protected] ','Blow dry',now(),'am','sddddddddddddddddddddddddddddddddddddddddddddddddddddddddd' )
Date :
2016-03-17 01:58:27By :
Chaidhanan
ใจเย็นๆค่อยๆไล่ดูครับCode (PHP) <form method="post">
<input type="date" name="recdate" id="dateInput" value="" />
<input type="time" name="rectime">
<input type="submit" name="button" id="button" value="Submit">
</form>
recdate -------------- > <?=$_POST['recdate']?><br>
rectime -------------- > <?=$_POST['rectime']?><br>
Code (PHP) <form method="post">
<input type="date" name="recdate" id="dateInput" value="" />
<input type="time" name="rectime">
<input type="submit" name="button" id="button" value="Submit">
</form>
recdate -------------- > <?=date("Y-m-d",strtotime($_POST['recdate']))?><br>
rectime -------------- > <?=date("H:i:s",strtotime($_POST['rectime']))?><br>
$dateInput=$_POST['dateInput']; Code (PHP) $dateInput=date("Y-m-d",strtotime($_POST['recdate']))
$timeInput=date("H:i:s",strtotime($_POST['rectime']))
Date :
2016-03-17 02:59:23By :
meannerss
Date :
2016-03-17 09:04:42By :
mr.win
ถ้าอยากจะใช้แค่ time ก็เปลี่ยน type ให้ถูกต้อง อย่าไปใช้ timestamp มันใหญ่เกิน
Date :
2016-03-18 00:54:51By :
Chaidhanan
Server 01
Load balance : Server 01
Quote:
