<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head>
<body>
<?php
session_start();
if(isset($_POST['add_page'])){
$cusid = $_POST['cusid'];
$fname = $_POST['name'];
$lname = $_POST['lastname'];
$gender = $_POST['gender'];
$day = $_POST['Day'];
$month = $_POST['Month'];
$year = $_POST['Year'];
$time = mktime(0,0,0,$month,$day,$year);
$address = $_POST['address'];
$province = $_POST['province'];
$zipcode = $_POST['zipcode'];
$tell = $_POST['tell'];
$Cus = $_POST['Cus_d'];
$user = $_POST['username'];
$passA = $_POST['passA'];
// หาเวลาประทับ unix ปัจจุบัน
$nowunix = mktime();
// หาความแตกต่าง
$ageunix = $nowunix - $time;
//แปลงจากวินาทีเป็นปี
$age = ($ageunix / (365 * 24 * 60 * 60));
$con = mysql_connect("localhost","root","");
mysql_select_db("mystore",$con);
mysql_query("SET NAMES UTF8");
mysql_query("SET character_set_results=utf8");
mysql_query("SET character_set_client=utf8");
mysql_query("SET character_set_connection=utf8");
$sql='insert into customer(Customer_id,Customer_Name,Customer_Lastname,Gender,Age,Birthdate,Address,Province,Zipcode,Telephone,Customer_description,username,password) value("'.$cusid.'","'.$fname.'","'.$lname.'","'.$gender.'","'.$age.'","'.$time.'","'.$address.'","'.$province.'","'.$zipcode.'","'.$tell.'","'.$Cus.'","'.$user.'","'.$passA.'")';
mysql_query($sql,$con)
or die("Not Insert data"."<br>".mysql_error());
}
?>
<?php
$con = mysql_connect("localhost","root","");
mysql_select_db("mystore",$con);
mysql_query("SET NAMES UTF8");
mysql_query("SET character_set_results=utf8");
mysql_query("SET character_set_client=utf8");
mysql_query("SET character_set_connection=utf8");
$ListSQL = "SELECT * FROM customer ";
$result = mysql_query($ListSQL,$con);
echo "<table border=1 align=center width=1000> ";
echo "<tr align=center>";
echo "<td>ID</td>"."<td>name</td>";
echo "</tr>";
while($show=mysql_fetch_array($result)){
echo "<tr align=center>";
echo "<td>".$show["Customer_id"]."</td>"."<td>".$show["Customer_Name"]." ".$show["Customer_Lastname"]."</td>"."<td>".$show["Gender"]."</td>"."<td>".$show["Birthdate"]."</td>";
echo "</tr>";
}
mysql_close($con);
echo "</table>";
?>
</body>
</html>
ไม่มีความคิดเห็น:
แสดงความคิดเห็น