打印

[求助]新手问php问题!急需!

[求助]新手问php问题!急需!

<?php
     $connid=@mysql_connect("localhost","","");
     $sql="select * from user_info";
     $result=mysql_db_query("user",$sql);
     $name=mysql_result($result,0,"username");
     $sex=mysql_result($result,0,"sex");
     $email=mysql_result($result,0,"Email");
  ?>

<html>
<head>
<title>信息</title>
</head>
<body>
<table>
<tr>
    <td>用户名:</td>
       <td>
       <?php
         echo $name;
        ?></td>
<tr>
   <td>性 别</td>
   <td>
    <?php
     echo $sex;
    ?></td>
<tr>
  <td>Email</td>
  <td>
   <?php
    echo $email;
   ?></td>
</tr>
</table>
浏览效果,出现错误信息:
Warning: mysql_db_query() [function.mysql-db-query]: Access denied for user 'www-data'@'localhost' (using password: NO) in /var/www/show.php on line 4

Warning: mysql_db_query() [function.mysql-db-query]: A link to the server could not be established in /var/www/show.php on line 4

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /var/www/show.php on line 5

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /var/www/show.php on line 6

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /var/www/show.php on line 7
      
用户名:
  性 别
  Email
请大家帮帮忙!哪里出错了!!

TOP

[code:1]

_adslin_db();
$sql = "SELECT *
    FROM user_info";
$result = mysql_query($sql);
$row = mysql_fetch_assoc($result);
$name = $row["name"];
$sex = $row["sex"];
$email = $row["email"];

function _adslin_db ($dbhost = "localhost", $dbuser= "root", $dbpw = "123456", $dbname= "adslin_database")
{
    $adslin_dbc = mysql_connect($dbhost, $dbuser, $dbpw);
    mysql_select_db($dbname, $adslin_dbc);
    return $adslin_dbc;
}

[/code:1]

TOP

谢谢版主!我试试看.
还有我想问:mysql我没有设置用户密码,是不是一定要设的??

TOP

没有设置的话,相关密码处就留空好了,但数据库用户名是默认就有root的哦

http://dev.mysql.com/doc/refman/5.0/en/database-administration.html

随意看看就OK了

TOP