php @ mysql问题，使用MySQL保留字 [英] php@mysql problem, using MySQL reserved words
问题描述
下面是我的PHP代码，我需要将jobseeker简历保存在数据库中。但是不起作用并显示消息：在phpMyadmin中添加字段名resume_ID作为主键后，列计数与第1行的值计数不匹配。我不知道我做了什么错误。谢谢。
do_resume.php
[PHP]<？php
include_once（" database.php"）;
类用户{
函数linkid（）
{
$ db = new db（）;
$ link_id = $ db-> dbconnect（）;
返回$ link_id;
} //结束函数linkid
函数add_user（$ arr）
{
< br $>
$ link_id = $ this-> linkid（）;
$ fullName = $ arr [''fullName''];
$ nric = $ arr [''nric''];
$ gender = $ arr [''gender''];
$ day = $ arr [''day''];
$ month = $ arr [''month''];
$ year = $ arr [''year' '];
$ maritalStatus = $ arr [''maritalStatus''];
$国籍= $ arr [''国籍''];
$ emailAdd = $ arr [''emailAdd''];
$ contactNum = $ arr [''contactNum''];
$ contactAdd = $ arr [''contactAdd''];
$ languages1 = $ arr ['' languages1''];
$ languages2 = $ arr [''languages2''];
$ education = $ arr [''education''];
$ workExp = $ arr [''workExp''];
$ curricularAct = $ arr [''curricularAct''];
$ skills = $ arr [''技能''];
$ references = $ arr [''references''];
if（$ fullName ==""）{
$ message =" Opps ..你忘了输入你的全名！< br>" ;;
include（" ; resume.php"）;
}
其他
如果（$ nric ==""）{
$ message =" Opps ..你佛rgot进入你的NRIC！< br>" ;;
include（" resume.php"）;
}
>
其他
如果（$ gender ==""）{
$ message ="请选择你的性别！< br>" ;;
包括（" resume.php"）;
}
else
if（$ maritalStatus ==""）{
$ message ="请选择您的婚姻状况！ < br>" ;;
包含（" resume.php"）;
}
否则
if（$ nationality ==""）{
$ message =" Opss ..你忘了输入你的国籍！< br>" ;;
包含（" resume.php"）;
}
另外
if（$ emailAdd ==""）{
$ message =" Opps ..你忘了输入你的电子邮件地址！< br>" ;;
include（" resume.php&qu ot;）;
}
其他
if（$ contactNum ==""）{
$ message =" Opps ..您忘了输入您的联系电话号码！< br>" ;;
include（" resume.php"）;
}
其他
如果（ $ contactAdd ==""）{
$ message =" Opps ..您忘了输入您的联系地址！< br>" ;;
include（ " resume.php"）;
}
其他
if（$ languages1 ==""）{
$ message ="请选择您的语言（口语）！< br>" ;;
include（ " resume.php"）;
}
其他
if（$ languages2 ==""）{
$ message ="请选择您的语言（书面）！< br>" ;;
include（ " resume.php"）;
}
其他
if（$ education ==""）{
$ message ="您需要填写您的教育水平！< br>" ;;
include（" resume.php"）;
}
if（$ workExp ==""）{
$ message ="您需要填写您的工作经验！< br>" ;;
include（" resume.php"）;
}
其他
if（$ references ==""）{
$ message ="您需要填写参考文献！< br>" ;;
include（" resume.php"）;
}
其他
{
$ myquery =" INSERT INTO简历
VALUES（'$ fullName''，''$ nric''，''$'''''$ day''，''$ month''，''$ year ''，'''马ritalStatus''，''$ nationality''，'$ emailAdd''，'$ contactNum''，''$ contactAdd''，''$ languages1''，''$ languages2''，''$ education ''，''$ workExp''，''$ curricularAct''，''$ skills''，''$ references''）" ;;
$ result = mysql_query（$ myquery，$ link_id）或死（mysql_error（））;
include_once（" resume_success.php" ;）;
}
}
}
？> [/ PHP]
do_resume_Pre.php
[PHP]<？php
include_once（" do_resume.php"）;
$ act = $ _REQUEST [''act''];
if（$ act ==''adduser''）{
$ arr = $ _REQUEST;
$ usr =新用户（）;
$ usr-> add_user（$ arr）;
exit（）;
}
？> [/ PHP]
database.php
[PHP]<？php
class db {
var $ sqlserver =" localhost" ;;
var $ sqldatabase =" ums e-job portal";
var $ sqluser =" root";
var $ sqlpass ="&q uot ;;
var $ link_id;
函数dbconnect（）{
$ link_id = mysql_connect（$ this-> sqlserver，$ this-> sqluser，$ this-> sqlpass）;
$ dbh = mysql_select_db（$ this-> sqldatabase）;
返回$ this-> link_id = $ link_id;
}
}
？> [/ PHP]
resume_success.php
[PHP]<？php
include（" index.php"）;
？> [/ PHP]
Below is my php code which i need to save the jobseeker resume in database. But does not function and show the message: Column count doesn''t match value count at row 1 after i add a field name resume_ID as a primary key in phpMyadmin. i dont know what is the error i done. Thanks.
do_resume.php
[PHP]<?php
include_once("database.php");
class user {
function linkid ()
{
$db = new db();
$link_id = $db->dbconnect();
return $link_id;
} // end function linkid
function add_user($arr)
{
$link_id = $this->linkid();
$fullName = $arr[''fullName''];
$nric = $arr[''nric''];
$gender = $arr[''gender''];
$day = $arr[''day''];
$month = $arr[''month''];
$year = $arr[''year''];
$maritalStatus = $arr[''maritalStatus''];
$nationality = $arr[''nationality''];
$emailAdd = $arr[''emailAdd''];
$contactNum = $arr[''contactNum''];
$contactAdd = $arr[''contactAdd''];
$languages1 = $arr[''languages1''];
$languages2 = $arr[''languages2''];
$education = $arr[''education''];
$workExp = $arr[''workExp''];
$curricularAct = $arr[''curricularAct''];
$skills = $arr[''skills''];
$references = $arr[''references''];
if($fullName==""){
$message="Opps.. You forgot enter your Full Name!<br>";
include("resume.php");
}
else
if($nric==""){
$message="Opps.. You forgot enter your NRIC!<br>";
include("resume.php");
}
else
if($gender==""){
$message="Please select your Gender!<br>";
include("resume.php");
}
else
if($maritalStatus==""){
$message="Please select your Marital Status!<br>";
include("resume.php");
}
else
if($nationality==""){
$message="Opss.. You forgot enter your Nationality!<br>";
include("resume.php");
}
else
if($emailAdd==""){
$message="Opps.. You forgot enter your Email Address!<br>";
include("resume.php");
}
else
if($contactNum==""){
$message="Opps.. You forgot enter your Contact Number!<br>";
include("resume.php");
}
else
if($contactAdd==""){
$message="Opps.. You forgot enter your Contact Address!<br>";
include("resume.php");
}
else
if($languages1==""){
$message="Please select your Languages(oral)!<br>";
include("resume.php");
}
else
if($languages2==""){
$message="Please select your Languages(written)!<br>";
include("resume.php");
}
else
if($education==""){
$message="You need to fill in your Education Level!<br>";
include("resume.php");
}
else
if($workExp==""){
$message="You need to fill in your Work Experiences!<br>";
include("resume.php");
}
else
if($references==""){
$message="You need to fill in your References!<br>";
include("resume.php");
}
else
{
$myquery = "INSERT INTO resume
VALUES ( ''$fullName'', ''$nric'', ''$gender'', ''$day'', ''$month'', ''$year'', ''$maritalStatus'', ''$nationality'', ''$emailAdd'', ''$contactNum'', ''$contactAdd'', ''$languages1'', ''$languages2'', ''$education'', ''$workExp'', ''$curricularAct'', ''$skills'', ''$references'' )";
$result = mysql_query($myquery,$link_id) or die(mysql_error());
include_once("resume_success.php");
}
}
}
?>[/PHP]
do_resume_Pre.php
[PHP]<?php
include_once("do_resume.php");
$act = $_REQUEST[''act''];
if ($act == ''adduser'') {
$arr = $_REQUEST;
$usr = new user();
$usr->add_user($arr);
exit();
}
?>[/PHP]
database.php
[PHP]<?php
class db {
var $sqlserver = "localhost";
var $sqldatabase = "ums e-job portal";
var $sqluser = "root";
var $sqlpass = "";
var $link_id;
function dbconnect () {
$link_id = mysql_connect($this->sqlserver, $this->sqluser, $this->sqlpass);
$dbh = mysql_select_db($this->sqldatabase);
return $this->link_id = $link_id;
}
}
?>[/PHP]
resume_success.php
[PHP]<?php
include("index.php");
?>[/PHP]
推荐答案
db = new db（）;
db = new db();
link_id =
link_id =
db-> dbconnect（）;
return
db->dbconnect();
return
这篇关于php @ mysql问题，使用MySQL保留字的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
