我的PHP代码中连接到数据库的错误在哪里 [英] where is my error in my php code in connecting to the database

问题描述

 < ？php 
 $ host = '  localhost'; 
 $ user = '  root'; 
 $ password = '  root'; 
 $ database = '  s5_db'; 
 $ port = '  8889'; 
 $ socket = '  / Applications / MAMP / tmp / mysql / mysql.sock'; 
 
 
 
 
 
 $ conn = mysqli_connect（$ host，$ user，$ password，$ database，$ port，$ socket）; 
 
  if （！$ conn）{
 
 die（  连接失败： .mysqli_connect_error（））; 
}  else  {
 echo  连接通行证：; 
} 

测试代码后显示连接通过但我在另一个脚本上运行以下代码后

如下：





$ test = mysqli_query（$ conn）;







if（！$ test）{

echo'conn有错误';

}否则{

echo'conn没关系没有错误';

}



它返回conn有错误

请指向我我的错误

解决方案

host = ' localhost';

user = ' root';

password = ' 根;

<?php 
$host   =  'localhost';
$user = 'root';
$password = 'root';
$database  =  's5_db';
$port   =   '8889';
$socket = '/Applications/MAMP/tmp/mysql/mysql.sock';





$conn  = mysqli_connect($host, $user, $password, $database, $port, $socket);

 if (!$conn) {
     
     die("failed connection : ". mysqli_connect_error());
 } else {
     echo "connection pass : ";
}

after testing the code it shows connection pass but after i run the following code on another script
which follows :


$test = mysqli_query($conn);



if(!$test){
echo 'conn has an error';
} else {
echo 'conn is okay no errors ';
}

it returns conn has an error
please point to me my error

解决方案

host = 'localhost';

user = 'root';

password = 'root';

这篇关于我的PHP代码中连接到数据库的错误在哪里的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！