|
 |
| |
ดูโค๊ด+แก้ไขให้หน่อยครับ มันติดต่อฐานข้อมูลไม่ได้ครับ |
| |
 |
|
|
 |
 |
|
Config.php
<?php
mysql_connect("localhost","root","123")
or die("Can not connect Server");
mysql_select_db("cat")
or die("Can not connect Database");
?>
Register.php
<?php
$host ="localhost";
$un = "root";
$pwd = "123";
$Myconn = mysql_connect($host,$un,$pwd)
or die("Can not connect Server");
$StrSQL = "SELECT * FROM form1";
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">
<title>Register</title>
<html>
<head>
<script language="javascript">
function checkID(id)
{
if(id.length != 13) return false;
for(i=0, sum=0; i < 12; i++)
sum += parseFloat(id.charAt(i))*(13-i); if((11-sum%11)%10!=parseFloat(id.charAt(12)))
return false; return true;}
function validate()
{
if(!checkID(document.form1.t1.value))
{
alert('เลขบัตรประจำตัวประชาชนไม่ถูกต้อง');
document.form1.t1.focus();
return false;
}
if (document.form1.t1.value=="")
{
alert('กรุณาป้อนหมายเลขบัตรประจำตัวประชาชนให้ครบด้วยค่ะ');
document.form1.t1.focus();
return false;
}
if(document.form1.t1.value=="")
{
alert('กรุณาป้อนหมายเลขบัตรประจำตัวประชาชนให้ครบด้วยค่ะ');
document.form1.t1.focus();
return false;
}
if(document.form1.t_name.value=="")
{
alert('กรุณาใส่ชื่อภาษาไทยด้วยค่ะ');
document.form1.t_name.focus();
return false;
}
if(document.form1.t_sur.value=="")
{
alert('กรุณาใส่นามสกุลภาษาไทยด้วยค่ะ');
document.form1.t_sur.focus();
return false;
}
if(document.form1.e_name.value=="")
{
alert('กรุณาใส่ชื่อภาษาอังกฤษด้วยค่ะ');
document.form1.e_name.focus();
return false;
}
if(document.form1.e_sur.value=="")
{
alert('กรุณาใส่นามสกุลภาษาอังกฤษด้วยค่ะ');
document.form1.e_sur.focus();
return false;
}
}
</script>
Job_Edit.php
<?php
$host ="localhost";
$un = "root";
$pwd = "123";
$Myconn = mysql_connect($host,$un,$pwd)
or die("Can not connect Server");
$StrSQL = "SELECT * FROM form1";
?>
<?
$id1 = $_POST[t1];
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<form action="Save.php" name="frmAdd" method="post">
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">
<title>Untitled Document</title>
<html>
<head>
<title>เพิ่มเติมรายละเอียด การสมัครเป็นสมาชิก</title>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">
<link href="board.css" rel="stylesheet" type="text/css">
<style>
BODY {font-family:;font-size="10"
background-color: #OOOOFF;
background-color: #FFFFFF;
margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
}
A:link {text-decoration: none; color: #CCOOOO ;text-decoration:underline;color: #000000}
A:visited {text-decoration: none; color: #OOOOFF}
A:hover {text-decoration: none; color: #006600}
A:active {text-decoration: none; color: #FFOOOO}
.style2 {
color: #FFFFFF;
font-weight: bold;
}
.style5 {color: #000000}
.style6 {color: #000000; font-weight: bold; }
.style7 {font-size: 14px}
.style8 {color: #FFFFFF; font-weight: bold; font-size: 14px; }
-->
</style>
</head>
<BODY>
<table width="843" border="0" cellpadding="4" cellspacing="0" class="normal" >
<TR VALIGN=TOP ALIGN=LEFT bgcolor="#2D77D1" >
<TD bgcolor="#FFFFFF" style="color: #FFFFFF;">
<form name="form1" method="post" action="job_edit.php" >
<table width="841" border="0" cellpadding="0" cellspacing="1">
<tr bgcolor="#FF9900">
<td height="28" colspan="5" class="normal"><div align="center" class="style6 style7"></div> <div align="center"><span class="style2">ข้อมูลส่วนตัว</span> </div></td>
</tr>
<tr>
<td width="160" height="30" bgcolor="#666666" class="normal"> <div align="center">เลขประจำตัวประชาชน </div></td>
<td colspan="4" bgcolor="#FFCC99" class="style5 normal">
<?
echo $id1
?>
</td>
</tr>
<tr>
<td height="29" bgcolor="#666666"><div align="center"><span class="normal">ชื่อ-นามสกุล(Tha)*</span></div></td>
<td colspan="4" bgcolor="#FFCC99"><span class="style6">
<select name="t_pre" id="t_pre" method"post">
<option value="นาย">นาย</option>
<option value="น.ส." >น.ส.</option>
<option value="นาง" >นาง</option>
<option selected value= "<? echo $t_pre; ?>">
</option>
</select>
<input name="t_name" type="text" id="t_name" size="25" maxlength="40" value = "<? echo $_POST['t_name']; ?>">
<input name="t_sur" type="text" id="t_sur" size="25" maxlength="40" value = "<? echo $_POST['t_sur']; ?>">
</span></td>
</tr>
<tr>
<td height="29" bgcolor="#666666"><div align="center"><span class="normal">ชื่อ-นามสกุล(Eng)*</span></div></td>
<td colspan="4" bgcolor="#FFCC99"><span class="style6">
<select name="e_pre" id="e_pre" method"post">
<option value="Mr.">Mr.</option>
<option value="Mrs." >Mrs.</option>
<option value="Ms." >Ms.</option>
<option selected value= "<? echo $e_pre; ?>">
</select>
<input name="e_name" type="text" id="e_name" size="25" maxlength="40" value = "<? echo $_POST['e_name']; ?>">
-
<input name="e_sur" type="text" id="e_sur" size="25" maxlength="40" value = "<? echo $_POST['e_sur']; ?>">
</span></td>
</tr>
<tr>
<td height="29" bgcolor="#666666"><div align="center"><span class="normal">รหัสพนักงาน (6หลัก)*</span></div></td>
<td colspan="4" bgcolor="#FFCC99"><span class="style6">
<input name="j_email" type="text" id="j_hight2" value="" size="12" maxlength="6">
( เพื่อตรวจสอบสิทธิการเป็นพนักงาน กสท )</span></td>
</tr>
<tr>
<td rowspan="4" bgcolor="#666666"><div align="center"><span class="normal">ที่อยู่ตามทะเบียนบ้าน</span></div> <div align="center"></div> </td>
<td width="96" height="29" bgcolor="#FFCC99"><div align="center" class="style6"><span class="normal">บ้านเลขที่</span></div></td>
<td width="199" bgcolor="#FFCC99"><input name="j_add" type="text" id="j_add" value="" size="30" maxlength="20"></td>
<td width="105" bgcolor="#FFCC99"><div align="center" class="style6"><span class="normal">หมู่ที่</span></div></td>
<td width="275" bgcolor="#FFCC99"><input name="j_mu" type="text" id="j_mu" value="" size="30" maxlength="5"></td>
</tr>
<tr>
<td width="96" height="29" bgcolor="#FFCC99"><div align="center" class="style6"><span class="normal">ซอย</span></div></td>
<td width="199" bgcolor="#FFCC99"><input name="j_soi" type="text" id="j_soi" value="" size="30" maxlength="50"></td>
<td bgcolor="#FFCC99"><div align="center" class="style6"><span class="normal">ถนน</span></div></td>
<td bgcolor="#FFCC99"><input name="j_road" type="text" id="j_road" value="" size="30" maxlength="50"></td>
</tr>
<tr>
<td width="96" height="29" bgcolor="#FFCC99"><div align="center" class="style6"><span class="normal">แขวง/ตำบล</span></div></td>
<td width="199" bgcolor="#FFCC99"><input name="j_dist" type="text" id="j_dist" value="" size="30" maxlength="50"></td>
<td bgcolor="#FFCC99"><div align="center" class="style6"><span class="normal">เขต/อำเภอ</span></div></td>
<td bgcolor="#FFCC99"><input name="j_amph" type="text" id="j_amph" value="" size="30" maxlength="50"></td>
</tr>
<tr>
<td width="96" height="29" bgcolor="#FFCC99"><div align="center" class="style6"><span class="normal">จังหวัด</span></div></td>
<td width="199" bgcolor="#FFCC99"><input name="j_city" type="text" id="j_city" value="" size="30" maxlength="50"></td>
<td bgcolor="#FFCC99"><div align="center" class="style6"><span class="normal">รหัสไปรษณีย์</span></div></td>
<td bgcolor="#FFCC99"><input name="j_zip" type="text" id="j_zip" value="" size="30" maxlength="10"></td>
</tr>
<tr>
<td rowspan="2" bgcolor="#666666"><div align="center"><span class="normal">โทรศัพท์</span></div> <div align="center"></div></td>
<td width="96" height="29" bgcolor="#FFCC99"><div align="center" class="style6"><span class="normal">ที่บ้าน</span></div></td>
<td width="199" bgcolor="#FFCC99"><input name="j_p_home" type="text" id="j_p_home" value="" size="30" maxlength="50"></td>
<td bgcolor="#FFCC99"><div align="center" class="style6"><span class="normal">ที่ทำงาน</span></div></td>
<td bgcolor="#FFCC99"><input name="j_p_off" type="text" id="j_p_off" value="" size="30" maxlength="50"></td>
</tr>
<tr>
<td width="96" height="29" bgcolor="#FFCC99"><div align="center" class="style6"><span class="normal">โทรศัพท์เคลื่อนที่</span></div></td>
<td width="199" bgcolor="#FFCC99"><input name="j_mobile" type="text" id="j_mobile" value="" size="30" maxlength="50"></td>
<td bgcolor="#FFCC99"><div align="center" class="style6"><span class="normal">โทรสาร</span></div></td>
<td bgcolor="#FFCC99"><input name="j_fax" type="text" id="j_fax2" value="" size="30" maxlength="50"></td>
</tr>
sgfsdfdsf
</table>
<table width="840" border="0" cellpadding="4" cellspacing="0" class="normal" >
<tr bgcolor="#2D77D1">
add.php
<!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=iso-8859-1" />
<title>Untitled Document</title>
</head>
<body>
<?php
$host ="localhost";
$un = "root";
$pwd = "123";
$Myconn = mysql_connect("localhost","root","123") or die("Error Connect to Database");
mysql_select_db("cat");
$strSQL = "INSERT INTO form1 ";
$strSQL = "VALUES (t1,t_pre,t_name,t_sur,e_pre,e_name,e_sur,j_email,j_add,j_mu,j_soi,j_road,j_dish,j_amph,j_city,j_zip,j_p_home,j_p_off,mobile,fax) ";
$strSQL ="('".$_POST["t1"]."','".$_POST["t_pre"]."','".$_POST["t_name"]."' ";
$strSQL =",'".$_POST["t_sur"]."','".$_POST["e_pre"]."','".$_POST["e_name"]."') ";
$strSQL =",'".$_POST["e_sur"]."','".$_POST["j_email"]."','".$_POST["j_add"]."') ";
$strSQL =",'".$_POST["j_mu"]."','".$_POST["j_soi"]."','".$_POST["j_road"]."') ";
$strSQL =",'".$_POST["j_dish"]."','".$_POST["j_amph"]."','".$_POST["j_city"]."') ";
$strSQL =",'".$_POST["j_zip"]."','".$_POST["j_p_home"]."','".$_POST["j_p_off"]."') ";
$strSQL =",'".$_POST["mobile"]."','".$_POST["fax"]."') ";
$result = mysql_query($strSQL);
if($result)
{
echo " ok ..Thank you.. .";
}
else
{
echo "Error Save [".$strSQL."]";
}
mysql_close($Myconn);
?>
พอเซฟมันก้อบอกเออเร่อเซฟ พอเข้าตรง Job edit มันก็ติดต่อฐานข้อมูลไม่ได้ครับ
ผมต้องแก้อะไรตรงไหน รบกวนดูบวกแนะนำหรือแก้ไขให้ด้วยครับ ขอบคุณครับ
Tag : PHP, MySQL, JavaScript
|
|
|
 |
 |
 |
 |
| Date :
2010-08-18 14:05:21 |
By :
wonderfulls |
View :
856 |
Reply :
4 |
|
 |
 |
 |
 |
|
|
|
|
 |
 |
|
 |
 |
| |
|
|
|
| |
|
ทำไมเขียนคำสั่งติดต่อฐานข้อมูลหลายรอบจัง
ใช้ include ไปใช้งาน น่าจะเหมาะสมกว่าน่ะครับ
Config.php
Code (PHP)
<?php
mysql_connect("localhost","root","123")
or die("Can not connect Server");
mysql_select_db("cat")
or die("Can not connect Database");
?>
ลองรันไฟล์นี้ตรงๆ ดูว่ามีการแจ้ง error ขึ้นมาหรือเปล่า
|
| |
|
|
| |
| Date :
2010-08-18 17:41:35 |
By :
iieszz |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
ทีหลังก็ใส่แท็กซะด้วยนะอ่านยากชิบอ๋าย
|
| |
|
|
| |
| Date :
2010-08-18 17:52:10 |
By :
Dragons_first |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
<?php
$Myconn; //
$host ="localhost";
$un = "root";
$pwd = "123";
$db ="cat"; //เพิ่ม database
$Myconn = mysql_connect($host,$un,$pwd)
or die("Can not connect Server");
mysql_select_db($db) or die("database not connect");//เพิ่มใหม่
$StrSQL = "SELECT * FROM form1";
?>
|
| |
|
|
| |
| Date :
2010-08-18 20:59:42 |
By :
p_kokmas |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
ขอบคุณทุกท่านมากๆครับ
|
| |
|
|
| |
| Date :
2010-08-19 09:03:41 |
By :
wonderfulls |
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
| |
|
 Load balance : Server 01
|
