大家好,又见面了,我是你们的朋友全栈君。
我是这个站点的新手 – 请温和请:P
localhost上的mySQL数据库适用于插入语句,但只要将数据库连接更改为服务器连接它给了我错误:错误代码1146:1146没有任何错误描述。可能是什么原因?
根据我的错误捕获逻辑,连接一直成功到查询运行的一部分。在本地版本上,它就像一个魅力。有任何想法吗?数据库错误代码1146 – 本地与在线
:::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::
if($errors == 0)
{
$DBConnect = @mysql_connect(“db.start.ca”, “nokeekwe”, “classifiedlol”);
if($DBConnect === FALSE)
{
echo “
Unable to connect. ” .
“Error code ” . mysql_errno() . “: ” .
mysql_error() . “
\n”;
$errors++;
}
else
{
$DBName = “nokeekwe”;
result = @mysql_select_db(DBName,
if($result === FALSE)
{
echo “
Unable to select DB. ” .
“Error code ” . mysql_errno($DBConnect) .
“: ” . mysql_error($DBConnect) .
“
\n”;
$errors++;
}
}
}
if($errors > 0)
{
echo “
Please use your browser’s BACK button” .
” to return to the form and fix your errors.
\n”;
}
if($errors == 0)
{
title = stripslashes(_POST[‘title’]);
desc = stripslashes(_POST[‘desc’]);
req = stripslashes(_POST[‘req’]);
employer = stripslashes(_POST[’employer’]);
phone = stripslashes(_POST[‘phone’]);
fax = stripslashes(_POST[‘fax’]);
email = stripslashes(_POST[’email’]);
address = stripslashes(_POST[‘address’]);
insertJob = “INSERT INTO tbljobs (jobTitle, jobDesc, jobReq, jobEmployer, jobPhone, jobFax, jobEmail, jobAddress) VALUES (‘title’, ‘desc’, ‘req’, ‘employer’, ‘phone’, ‘fax’, ‘email’, ‘
QueryResult = mysql_query(insertJob,
if($QueryResult === FALSE)
{
echo “
Unable to save your job. ” .
” Error code ” .
mysql_errno($DBConnect) . “: ” .
mysql_errno($DBConnect) . “
\n”;
//echo $insertJob;
$errors++;
}
else
{
echo “Job Lead Saved!”;}
mysql_close($DBConnect);
}
很多谢谢
2012-06-15
webGirl
+1
请提供一些代码参考,以便更好地理解 –
+0
提供您的数据库逻辑。这将是非常有用 –
+0
首先,请删除mysql_ *并使用mysqli或PDO代替mysql_ *不再被维护,第二次尝试在mysql_connect和mysql_delect_db之前删除@并且还将’ db.start.ca’与’localhost’ –
发布者:全栈程序员栈长,转载请注明出处:https://javaforall.cn/137468.html原文链接:https://javaforall.cn