 |
เพิ่มข้อมูลจากหน้าฟอร์มลงฐานข้อมูล แล้วข้อมูลไม่บันทึกลงฐานข้อมูลครับ ผู้รู้ช่วยหน่อยนะครับ |
| |
 |
|
|
 |
 |
|
นี่ไฟล์ save_resume.php นะครับ
<?php
include("connectDB.php");
$FirstnameTh=$_POST["FirstnameTh"];
$LastnameTh=$_POST["LastnameTh"];
$FirstnameEn=$_POST["FirstnameEn"];
$LastnameEn=$_POST["LastnameEn"];
$Birthday=$_POST["Birthday"];
$Race=$_POST["Race"];
$Nationality=$_POST["Nationality"];
$Religion=$_POST["Religion"];
$Height=$_POST["Height"];
$Weight=$_POST["Weight"];
$Sex=$_POST["Sex"];
$Blood=$_POST["Blood"];
$IdentificationNo=$_POST["IdentificationNo"];
$DriverNo=$_POST["DriverNo"];
$Address=$_POST["Address"];
$Telephone=$_POST["Telephone"];
$Marital=$_POST["Marital"];
$Military=$_POST["Military"];
$Hobbies=$_POST["Hobbies"];
$AbilityCar=$_POST["AbilityCar"];
$TypingTh=$_POST["TypingTh"];
$TypingEn=$_POST["TypingEn"];
$MoreDetail=$_POST["MoreDetail"];
$Firstname=$_POST["Firstname"];
$Lastname=$_POST["Lastname"];
$AddressFam=$_POST["AddressFam"];
$TelephoneFam=$_POST["TelephoneFam"];
$Workplace=$_POST["Workplace"];
$Position=$_POST["Position"];
$Relationship=$_POST["Relationship"];
$ApplicantId=$_POST["ApplicantId"];
$QuaId=$_POST["QuaId"];
$Level=$_POST["Level"];
$Institution=$_POST["Institution"];
$Major=$_POST["Major"];
$Certificate=$_POST["Certificate"];
$Grade=$_POST["Grade"];
$Admission=$_POST["Admission"];
$Graduated=$_POST["Graduated"];
$ExpId=$_POST["ExpId"];
$Company=$_POST["Company"];
$Position=$_POST["Position"];
$Scope=$_POST["Scope"];
$Salary=$_POST["Salary"];
$Exp=$_POST["Exp"];
$TrainingId=$_POST["TrainingId"];
$Course=$_POST["Course"];
$InstitutionTrain=$_POST["InstitutionTrain"];
$Period=$_POST["Period"];
$year=$_POST["year"];
$LangId=$_POST["LangId"];
$Language=$_POST["Language"];
$SpeakLev=$_POST["SpeakLev"];
$ListenLev=$_POST["ListenLev"];
$ReadLev=$_POST["ReadLev"];
$WriteLev=$_POST["WriteLev"];
$ProId=$_POST["ProId"];
$Program=$_POST["Program"];
$ProLev=$_POST["ProLev"];
$sql="insert into applicant(FirstnameTh,LastnameTh,FirstnameEn,LastnameEn,Birthday,Race,Nationality,Religion,Height,Weight,Sex,Blood,IdentificationNo,DriverNo,Address,Telephone,Marital,Military,Hobbies,AbilityCar,TypingTh,TypingEn,MoreDetail) value('$ApplicantId','$FirstnameTh','$LastnameTh','$FirstnameEn','$LastnameEn','$Birthday','$Race','$Nationality','$Religion','$Height','$Weight','$Sex','$Blood,'$IdentificationNo','$DriverNo','$Address','$Telephone','$Marital','$Military','$Hobbies','$AbilityCar','$TypingTh','$TypingEn','$MoreDetail')";
$result=mysql_query($sql);
$sql="insert into family(Firstname,Lastname,AddressFam,TelephoneFam,Workplace,PositionFam,Relationship) value('$Firstname','$Lastname','$AddressFam','$TelephoneFam','$Workplace','$PositionFam','$Relationship')";
$result=mysql_query($sql);
$sql="insert into education(ApplicantId,QuaId,Level,Institution,Major,Certificate,Grade,Admission,Graduated) value('$ApplicantId','$QuaId','$Level','$Institution','$Major','$Certificate','$Grade','$Admission','$Graduated')";
$result=mysql_query($sql);
$sql="insert into experiences(ExpId,Company,Position,Scope,Salary,Exp) value('','$Company','$Position','$Scope','$Salary','$Exp')";
$result=mysql_query($sql);
$sql="insert into training(TrainingId,Course,InstitutionTrain,Period,year) value('','$Course','$InstitutionTrain','$Period','$year')";
$result=mysql_query($sql);
$sql="insert into language(LangId,Language) value('','$Language')";
$result=mysql_query($sql);
$sql="insert into langlevel(LangId,ApplicantId,SpeakLev,ListenLev,ReadLev,WriteLev) value('$LangId','$ApplicantId','$SpeakLev','$ListenLev','$ReadLev','$WriteLev')";
$result=mysql_query($sql);
$sql="insert into program(ProId,program) value('','$program')";
$result=mysql_query($sql);
$sql="insert into prolevel(ProId,ApplicantId,ProLev) value('$ProId','$Applicant','$ProLev')";
$result=mysql_query($sql);
if($result==true)
{
echo"<font color='#00ff66'>เพิ่มข้อมูลเรียบร้อย</font>";
}
mysql_close($con);
?>
|
ประวัติการแก้ไข
2014-02-06 10:13:33
 |
 |
 |
 |
| Date :
2014-02-06 10:13:43 |
By :
falcaoza |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
| |
|
|
|
| |
|
มันจะเข้า db ได้ไงล่ะครับ คุณไม่ได้ connect ฐานข้อมูลเลย
|
| |
|
|
| |
| Date :
2014-02-06 10:12:51 |
By :
itpcc |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
ลองเปลี่ยนจาก
Code (PHP)
$result=mysql_query($sql);
เป็น
Code (PHP)
$result=mysql_query($sql) or die(mysql_error());
|
| |
|
|
| |
| Date :
2014-02-06 10:16:46 |
By :
itpcc |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
ช่วยหน่อยครับ พอกดบันทึกแล้วขึ้น 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 'โสด','','','','','','')' at line 1
แก้ยังไงครับ Code (PHP)
|
| |
|
|
| |
| Date :
2014-02-06 10:41:02 |
By :
falcaoza |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
ไม่มีใครช่วยได้เลยหรอครับ
|
| |
|
|
| |
| Date :
2014-02-06 12:40:46 |
By :
falcaoza |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
คุณก็รอ และ ให้โอกาส คนที่เค้าตอบบ้างสิครับ
แล้วมันก็บอก ซินแท็กเออเร่อ ลองไปไล่ code ดูก่อนไหมว่าอะไรมันเกินมันขาด
|
| |
|
|
| |
| Date :
2014-02-06 12:51:07 |
By :
apisitp |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
insert into applicant(FirstnameTh,LastnameTh,FirstnameEn,LastnameEn,Birthday,Race,Nationality,Religion,Height,Weight,Sex,Blood,IdentificationNo,DriverNo,Address,Telephone,Marital,Military,Hobbies,AbilityCar,TypingTh,TypingEn,MoreDetail) value('$ApplicantId','$FirstnameTh','$LastnameTh','$FirstnameEn','$LastnameEn','$Birthday','$Race','$Nationality','$Religion','$Height','$Weight','$Sex','$Blood,'$IdentificationNo','$DriverNo','$Address','$Telephone','$Marital','$Military','$Hobbies','$AbilityCar','$TypingTh','$TypingEn','$MoreDetail')";
ต้องเป็น
values
,'$Blood, ตก ' ไปหนึ่งตัว
|
| |
|
|
| |
| Date :
2014-02-06 12:54:55 |
By :
sakuraei |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
ขอบคุณทุกท่านมากครับ
|
| |
|
|
| |
| Date :
2014-02-06 13:07:45 |
By :
falcaoza |
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
