SQLSTATE[HY000] [1045] Access denied for user 'xxx'@'localhost' (using password: YES about php-pdo-mysql-class HOT 9 CLOSED

你设置肯定错了，要解决就新建个账户给数据库用。

from php-pdo-mysql-class.

https://github.com/lincanbin/PHP-PDO-MySQL-Class/blob/master/demo.php
我写了个Demo，修改五十多行左右的数据库连接设置后可以直接跑。

from php-pdo-mysql-class.

谢谢。。恩 明天我试试。。不过今天中午的时候我新建了一个用户还是报同样的错误

from php-pdo-mysql-class.

还是无效
我代码是这么写的
?php

$myusername=NULL;
$errowinfo=NULL;
if($_SERVER['REQUEST_METHOD'] == 'POST')
{
$myusername=$_POST['email'];
$mypassword=$_POST['password'];

/* else
{
$myusername=$_POST['email'];
$mypassword=$_POST['password']; }*/
//require 'config.php';
define('DBHost', 'localhost');
define('DBName', 'shad');
define('DBUser', 'shad');
define('DBPassword', 'qweqwe');
require(dirname(FILE)."/src/PDO.class.php");
$DB = new Db(DBHost, DBName, DBUser, DBPassword);
$tbl_name="user"; // Table name

//pdo
$DB->query("SELECT * FROM $tbl_name WHERE email=? and pass=?", array($myusername,$mypassword));

// Mysql_num_row is counting table row
$count=mysql_num_rows($DB);

// If result matched $myusername and $mypassword, table row must be 1 row

if($count==1){
echo '登陆成功';

from php-pdo-mysql-class.

mysql_num_rows是MySQL的函数，在新版本PHP是废弃特性，这个是PDO，你用这个干嘛？
获取结果集直接count结果数组即可。
登陆应该这样写，用不着写那么多：

//pdo
$Result = $DB->query("SELECT * FROM $tbl_name WHERE email=? and pass=?", array($myusername,$mypassword));

if($Result){
echo '登陆成功';
}

然后demo.php能跑吗？

from php-pdo-mysql-class.

demo可以跑。。

from php-pdo-mysql-class.

$result=$DB->query("SELECT * FROM user WHERE email=?",array($user));

while($row = mysql_fetch_array($result))
{
$vpnuser=$row['vpnuser'];
$vpnpass=$row['vpnpass'];
$vpnflow=$row['vpnflow'];
$sspass=$row['passwd'];
$ssflow=$u+$d;
$port=$row['port'];
$endtime=$row['endtime'];
}
那读取数据，可以继续这样读么 我试了下好像会出错，用array的方式也是出错的

from php-pdo-mysql-class.

你真是旧版mysql写上瘾了

foreach($DB->query("SELECT * FROM user WHERE email=?",array($user)) as $row){
 $vpnuser=$row['vpnuser'];
 $vpnpass=$row['vpnpass'];
 $vpnflow=$row['vpnflow'];
 $sspass=$row['passwd'];
 $ssflow=$u+$d;
 $port=$row['port'];
 $endtime=$row['endtime'];
}

如果你只要一行结果，那么只需要这样就可以了

$row = $DB->row("SELECT * FROM user WHERE email=?",array($user));
$vpnuser=$row['vpnuser'];
$vpnpass=$row['vpnpass'];
$vpnflow=$row['vpnflow'];
$sspass=$row['passwd'];
$ssflow=$u+$d;
$port=$row['port'];
$endtime=$row['endtime'];

from php-pdo-mysql-class.

https://github.com/lincanbin/Carbon-Forum/blob/master/login.php

你可以看看这个项目，就是用这个PDO类的。

from php-pdo-mysql-class.