db.php
<?
$host = "localhost" ;
$user = "root" ;
$password = "root" ;
$database = "chat" ;
function dbconnect($host,$user,$password,$database){
mysql_connect($host,$user,$password)
or die ("登录数据库失败") ;
mysql_select_db($database)
or die ("连接数据库失败!");
}dbconnect($host,$user,$password,$database);//查询用户信息
function select_usinfo(){
$select_usinfo = "select * from usinfo ";
$result_select_usinfo = mysql_query($select_usinfo)
or die("查询失败!" . mysql_error()) ;
return ($row_select_usinfo = mysql_fetch_array($result_select_usinfo)) ;
}
?>act.php
<?PHP
select_usinfo();
echo $row_select_usinfo['usname'];
?>为什么输不出来?求解释!
<?
$host = "localhost" ;
$user = "root" ;
$password = "root" ;
$database = "chat" ;
function dbconnect($host,$user,$password,$database){
mysql_connect($host,$user,$password)
or die ("登录数据库失败") ;
mysql_select_db($database)
or die ("连接数据库失败!");
}dbconnect($host,$user,$password,$database);//查询用户信息
function select_usinfo(){
$select_usinfo = "select * from usinfo ";
$result_select_usinfo = mysql_query($select_usinfo)
or die("查询失败!" . mysql_error()) ;
return ($row_select_usinfo = mysql_fetch_array($result_select_usinfo)) ;
}
?>act.php
<?PHP
select_usinfo();
echo $row_select_usinfo['usname'];
?>为什么输不出来?求解释!
select_usinfo();
echo $row_select_usinfo['usname'];这样将输出 Array
include 'db.php';
act.php需包含头文件include('db.php');
$row_select_usinfo = select_usinfo();
echo $row_select_usinfo['usname'];
$row_select_usinfo = select_usinfo();
echo $row_select_usinfo['usname'];
<? 修改成 <?php 先
function dbconnect($host,$user,$password,$database){
mysql_connect($host,$user,$password)
or die ("登录数据库失败") ;
mysql_select_db($database)
or die ("连接数据库失败!");
}
dbconnect($host,$user,$password,$database);
//查询用户信息
function select_usinfo(){
$select_usinfo = "select * from user ";
$result_select_usinfo = mysql_query($select_usinfo)
or die("查询失败!" . mysql_error()) ;
$row_select_usinfo = array();
while($row_select_usinfo[] = mysql_fetch_array($result_select_usinfo));
return $row_select_usinfo;
}
$row_select_usinfo = select_usinfo();
var_dump($row_select_usinfo);
exit;
就可以了还想问一句,我db.php里需要return()吗?
function select_usinfo(){
$select_usinfo = "select * from user limit 1";
$result_select_usinfo = mysql_query($select_usinfo)
or die("查询失败!" . mysql_error()) ;
if($row_select_usinfo[] = mysql_fetch_array($result_select_usinfo))
return $row_select_usinfo;
else
return null
}
$row_select_usinfo = select_usinfo();
var_dump($row_select_usinfo);
exit;
//查询用户信息
function select_usinfo(){
global $row_select_usinfo;
$select_usinfo = "select * from usinfo ";
$result_select_usinfo = mysql_query($select_usinfo)
or die("查询失败!" . mysql_error()) ;
return ($row_select_usinfo = mysql_fetch_array($result_select_usinfo)) ;
}
为什么我echo $row_select_usinfo['usname'];只能输出一条记录?
mysql_fetch_array 返回的就是数组
不过你只返回了一条记录,当然也就只能显示一条记录了
//查询用户信息
function select_usinfo(){
$select_usinfo = "select * from usinfo ";
$result_select_usinfo = mysql_query($select_usinfo)
or die("查询失败!" . mysql_error()) ;
return ($row_select_usinfo = mysql_fetch_array($result_select_usinfo)) ;
}应改为
//查询用户信息
function select_usinfo(){
$select_usinfo = "select * from usinfo ";
$result_select_usinfo = mysql_query($select_usinfo)
or die("查询失败!" . mysql_error()) ;
while($row = mysql_fetch_array($result_select_usinfo)) {
$row_select_usinfo[] = $row;
}
return $row_select_usinfo;
}
//这样使用
foreach(select_usinfo() as $row_select_usinfo) {
echo $row_select_usinfo['usname'] . '<br />';
}