วันอังคารที่ 9 กรกฎาคม พ.ศ. 2562

pm-002

เสื้อผ้าฝ้ายชินมัย คอกะเหรี่ยง แต่งพู่-130



เขียนโดย ที่ ไม่มีความคิดเห็น:

phamuang

phamuang


https://balllol.blogspot.com/2019/07/001.html

https://balllol.blogspot.com/2019/07/pm-002.html
เขียนโดย ที่ ไม่มีความคิดเห็น:

เสื้อคลุมมัดย้อม-001

เสื้อคลุมมัดย้อม-149



เขียนโดย ที่ ไม่มีความคิดเห็น:

วันอังคารที่ 4 มีนาคม พ.ศ. 2557

showtest

<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>
เขียนโดย ที่ ไม่มีความคิดเห็น:

add

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>add_page</title>
<style type="text/css">
</style></head>
<body>
<?php
$day = array ('1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23',
 '24','25','26','27','28','29','30','31');
$month = array ('January','February','March','April','May','June','July','August','September','October','November','December');
$year = array ('1980','1981','1982','1983','1984','1985','1986','1987','1988','1989','1990','1991','1992','1993','1994',
  '1995','1996','1997','1998','1999','2000');
$province = array ('เชียงใหม่','เชียงราย','ลำพูน','ลำปาง','แพร่','แม่ฮองสอน','พะเยา','น่าน');//action="lab7_55523206012-2.php"
?>

<font color="#FF0000"><u>เพิ่มข้อมูลลูกค้า</u></font>
<form method="post" name="resume_form" style="border-left-width: medium" action="showtest.php" onsubmit="return Showtxt();" ;>

<fieldset>
<legend>ข้อมูลลูกค้า</legend>
<table>
<tr>
 <td height="50">ชื่อ : <td><input type="text" name="name" onblur="Chkrange_name()"></td></td></tr>
<tr><td height="50">นามสกุล : <td><input type="text" name="lastname" onblur="Chkrange_lastname()"></td></td></tr>
<tr><td height="50">เพศ : <td><input type="radio" name="gender" value="ชาย" >ชาย
 <input type="radio" name="gender" value="หญิง"> หญิง</td></td></tr>
 <tr><td height="50">วัน-เดือน-ปี เกิด : <td><select name="Day" size="1">
 <option selected="selected" value="">Day</option>
<?php for($d=0;$d<=30;$d++) { ?>
  <option value="<?php echo $d+1;?>"><?php echo $day[$d];?></option>
<?php } ?></select>
       
       <select name="Month" size="1">
        <option selected="selected" value="">Month</option>
<?php for($m=0;$m<=11;$m++) { ?>
  <option value="<?php echo $m+1;?>"><?php echo $month[$m];?></option>
<?php } ?></select>
       
       <select name="Year" size="1">
        <option selected="selected" value="">Year</option>
<?php for($y=0;$y<=20;$y++) { ?>
  <option value="<?php echo $year[$y];?>"><?php echo $year[$y];?></option>
<?php } ?></select></td></td></tr>
       
  <tr><td height="50">จังหวัด :<td><select name="province" size="1">
 <option selected="selected">Province</option>
<?php for($p=0;$p<=7;$p++) { ?>
  <option value="<?php echo $province[$p];?>"><?php echo $province[$p];?></option>
<?php } ?></select></td></td></tr>
    <tr><td height="50">ที่อยู่ :<td><input type="text" name="address" onblur="Chkrange_address()"></td></td></tr>  
<tr><td height="50">รหัสไปรษณีย์ :<td><input type="text" name="zipcode" maxlength="5" onkeypress="CheckNum()" onblur="Chkrange_zipcode()" /><label style="color:#F00">**ใส่ได้เฉพาะตัวเลข**</label></td></td></tr>
    <tr><td height="50">โทรศัพท์ :<td><input type="text" name="tell" maxlength="10" onkeypress="CheckNum()" onblur="Chkrange_tell()" /><label style="color:#F00">**ใส่ได้เฉพาะตัวเลข**</label></td></td></tr>
    <tr><td height="50">รายละเอียดอื่นๆ :<td><textarea name="Cus_d" cols="50" rows="5"></textarea>
      </td></td></tr>
      </table>
</fieldset>
<fieldset>
<legend>Account ของ ลูกค้า</legend>
<table>
<tr><td>CustomerID : <td width="500" height="50"><input type="text" name="cusid"></td></td></tr>
<tr><td>Username : <td width="500" height="50"><input type="text" name="username" maxlength="10" onblur="Chkrange_username()"></td></td></tr>
<tr><td>Password : <td width="500" height="50"><input type="password" name="passA" maxlength="20" onblur="Chkrange_passA()"/></td></td></tr>
    <tr><td>Confirm Password : <td width="500" height="50"><input type="password" name="passB" maxlength="20" onblur="Chkrange_passB()"></td></td></tr>
</table>
</fieldset>

<div align="center"><table><tr><td>

<input type="submit" name="sum" value="เพิ่มข้อมูลลูกค้า"/>
<input type="submit" name="cancle" value="ยกเลิก"/></td>
<input type="hidden" name="add_page" value="1" />

</form>
<script>
function Showtxt()
{
if(document.resume_form.name.value==""||document.resume_form.lastname.value==""||document.resume_form.gender.value==""||document.resume_form.Day.value==""||document.resume_form.Month.value==""||document.resume_form.Year.value==""||document.resume_form.province.value==""||document.resume_form.address.value==""||document.resume_form.zipcode.value==""||document.resume_form.tell.value==""||document.resume_form.Cus_d.value==""||document.resume_form.cusid.value==""||document.resume_form.username.value==""||document.resume_form.passA.value==""||document.resume_form.passB.value=="")
{
alert("กรุณากรอกข้อมูลให้ครบ");
return false;
}
else{
alert(document.resume_form.name.value);
return true;
}

}
function Chkrange_name(){
if(document.resume_form.name.value.length<3){
alert("Please enter name to complete");
return false;
}
}
function Chkrange_lastname(){
if(document.resume_form.lastname.value.length<3){
alert("Please enter last name to complete");
return false;
}
}
function Chkrange_address(){
if(document.resume_form.address.value.length<3){
alert("Please enter address to complete");
return false;
}
}
function Chkrange_zipcode(){
if(document.resume_form.zipcode.value.length<3){
alert("Please enter zipcode to complete");
return false;
}
}
function Chkrange_tell(){
if(document.resume_form.tell.value.length<3){
alert("Please enter telephone number to complete");
return false;
}
}
function Chkrange_username(){
if(document.resume_form.username.value.length<5){
alert("Please enter username to complete");
return false;
}
}
function Chkrange_passA(){
if(document.resume_form.passA.value.length<8){
alert("Please enter password to complete");
return false;
}
}
function Chkrange_passB(){
if(document.resume_form.passB.value.length<8){
alert("Please enter password to complete");
return false;
}
}




function CheckNum(){
if(event.keyCode < 48 || event.keyCode > 57){
event.returnValue = false;
}
}




</script>
  <td></td>
  </tr>
 
</body>
</html>
เขียนโดย ที่ ไม่มีความคิดเห็น:
สมัครสมาชิก: ความคิดเห็น (Atom)