PHP文件在服务器上上传时给我错误 - PHP file give me error when uploading on server

PHP file give me error when uploading on server

本文关键字：错误服务器 PHP 文件 | 更新日期: 2023-12-02

<?php
$con = “mysqli_connect("https://some.com”,”userid”,”password”)”;
if (!$con)
  {
  die('Could not connect:'.mysql_error());
  }
mysql_select_db(“tomcatsp_userID”, $con);
$sql=INSERT INTO ‘SampleTable’ (USERID, PASSWORD) VALUES ('$_POST[USERID]’,’$_POST[PASSWORD]’);
if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }
echo "1 record added to tags";
mysql_close($con)
?>

这是我的 php 代码，我想上传到服务器上。但是当我上传到服务器上时给我错误。

下面是错误日志，请帮助我解决此类要求。

#1064 - 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 '<?php $con = mysql_connect("https://173.243.120.204:2083â€

更改此行并尝试删除主机名中的https

$con = mysqli_connect("https://myaddress.com”,”abc”,xyz”);
 to
$con = mysqli_connect("myaddress.com”,”abc”,xyz”);

mysql_connect("address","username","password") or die("cannot connect DB");
mysql_select_db("iglobe") or die("cannot select DB");
$sql="INSERT INTO SampleTable (USERID, PASSWORD) VALUES ('$_POST[USERID]’,’$_POST[PASSWORD]’)";
mysql_query($sql) or die(mysql_error());;
if(!$sqlselect)
  die('Error: '.mysql_error());
else
  echo "1 record added to tags";

<?php
$con = mysqli_connect("myaddress.com","abc","xyz");
if (!$con)
  {
  die('Could not connect:'.mysqli_error());
  }
mysqli_select_db("iglobe", $con);
$sql="INSERT INTO SampleTable (USERID, PASSWORD) VALUES (".$_POST[USERID].",'".$_POST[PASSWORD]."')";
$result=mysqli_query($con,$sql);
if (!$result)
die('Error: ' . mysqli_error());
echo "1 record added to tags";
mysqli_close($con)
?>

问题 1

问题出在以下行上：

$con = mysql_connect("https://myaddress.com”,”abc”,xyz”);

您没有在xyz”附近添加开场"

更改它，如下所示：

$con = mysql_connect('myaddress.com','abc','xyz');

有关mysql_connect的更多详细信息，请查看本手册

问题 2

以下行也不正确，用引号括起来：

$sql=INSERT INTO ‘SampleTable’ (USERID, PASSWORD) VALUES ('$_POST[USERID]’,’$_POST[PASSWORD]’);

将其更改为：

$sql= "INSERT INTO ‘SampleTable’ (USERID, PASSWORD) VALUES ('$_POST[USERID]’,’$_POST[PASSWORD]’)";

mysql_connect 从

php 5.5.0 开始被弃用此扩展从 PHP 5.5.0 开始已弃用，将来将被删除。相反，应该使用 MySQLi 或 PDO_MySQL 扩展。

 $mysqli = new mysqli('localhost', 'my_user', 'my_password', 'my_db');

这是"官方"OO的方式，

但是$connect_error直到PHP 5.2.9和5.3.0才被破坏。

 if ($mysqli->connect_error) 
  {
   die('Connect Error (' . $mysqli->connect_errno . ')'. $mysqli->connect_error);
  }