我正在尝试创建一个注册页面,它将信息添加到SQL表中。这是我执行此操作的PHP代码…谁能告诉我这是什么错误?
<?php $con=mysqli_connect("Correct Website is here","Correct Username","Correct Pass","Correct DB"); if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); } $DBsql = mysql_query("SELECT username, email from Profiles"); $sql = mysql_fetch_array($DBsql); if(!($_POST['username'] == $sql['username']) && ($_POST['email'] == $sql['email'])) { if ($_POST['password'] == $_POST['password2']){ $sql="INSERT INTO Profiles (firstName, lastName, username, email, password, region, group, verified) VALUES ('$_POST[firstname]','$_POST[lastname]','$_POST[username]','$_POST[email]','$_POST[password]','$_POST[region]','member','no')"; }else{ echo '<script type="text/javascript">' , 'window.alert("The passwords do not match.")' , '</script>'; } } else { echo '<script type="text/javascript">' , 'window.alert("That username or email is already in use.")' , '</script>'; } mysqli_close($con); ?>
它给出了以下错误:
Warning: mysqli_connect() [function.mysqli-connect]: (HY000/1130): Host '31.170.161.96' is not allowed to connect to this MySQL server in /home/a5349216/public_html/register.php on line 2 Failed to connect to MySQL: Host 'ip' is not allowed to connect to this MySQL server Warning: mysql_query() [function.mysql-query]: Access denied for user 'username'@'localhost' (using password: NO) in /home/username/public_html/register.php on line 8 Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/username/public_html/register.php on line 8 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/username/public_html/register.php on line 9 Warning: mysqli_close() expects parameter 1 to be mysqli, boolean given in /home/username/public_html/register.php on line 27
如果您的mysql数据库不在同一服务器(本地主机)上,则需要为该服务器的mysql用户/数据库从远程服务器授予访问权限。请参阅本文以获取一些可能对您有所帮助的步骤。听起来好像很遥远。
https://support.rackspace.com/how-to/mysql-connect-to-your-database- remotely/