无法使用PHP获取MySql输出 [英] Can not get MySql output with PHP
本文介绍了无法使用PHP获取MySql输出的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我是PHP和MySql的新手.我试图连接到MySql数据库并在屏幕上显示其内容.但是什么都没有显示出来.尽管我能够获得祝贺"消息以进行连接,但是我却无能为力.请帮助我找出我的代码有什么问题.
I'm new to PHP and MySql. I am trying to connect to MySql database and display its contents on screen. But nothing is displaying out. Though I am able to get "congrats" message for connection, I am not able to get anything else. Please help me out to figure out what is the problem with my code.
<?php
$dbhost= "localhost";
$dbuser= "root";
$dbpass= "";
$dbconnect= mysqli_connect('$dbhost', '$dbuser', '$dbpass','$mydb');
/*mysqli_select_db($mydb);*/
if(!mysqli_select_db){
echo "database not found";
die(mysqli_error());
}
else{
echo "congrats";
}
$query = "SELECT * FROM userinfo";
$result = mysqli_query($dbconnect, $query);
while($record = mysqli_fetch_array($result)){
echo $record['Name'], $record['Email'], $record['Contact'];
}
?>
推荐答案
您尚未定义$mydb
变量的值.还进行了其他一些更正.尝试执行以下代码.
you have not defined the value of $mydb
variable. Also made few other corrections. Try to execute below code.
<?php
$dbhost= "localhost";
$dbuser= "root";
$dbpass= "";
$mydb = "your_dbname";
$dbconnect= mysqli_connect($dbhost, $dbuser, $dbpass,$mydb);
/*mysqli_select_db($mydb);*/
if(!mysqli_select_db){
echo "database not found";
die(mysqli_error());
}
else{
echo "congrats";
}
$query = "SELECT * FROM userinfo";
$result = mysqli_query($dbconnect, $query);
while($record = mysqli_fetch_array($result)){
echo $record['Name']." ".$record['Email']." ".$record['Contact'];
}
?>
这篇关于无法使用PHP获取MySql输出的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文