关于pdo的一个疑问
php codeif (isset($_post['loginname']) && isset($_post['pwd']) && $_post['action'] == 'submit') { $loginname = $_post['loginname']; $pwd = $_post['pwd']; echo $loginname.' '.$pwd; $sql = select count(*) from tb_esq where login_name = :loginname and pwd = :pwd; require_once ('conn.php'); $sth = $db->prepare($sql); $sth->bindparam(':loginname', $loginname, pdo::param_str, 25); $sth->bindparam(':pwd', $pwd, pdo::param_str, 25); $sth->execute(); $rowcount = $sth->fetchcolumn(); var_dump($rowcount);//一直是0 $db = null; if ($rowcount == 1) { echo ; } else { alert('用户名或密码错误!'); echo ; }}
在提交了数据库中存在的用户名和密码之后还是提示密码错误，为什么呢
------解决方案--------------------
先用普通查询 看能否得到数据
php code$sql = select count(*) from tb_esq where login_name = '$loginname' and pwd = '$pwd';$result = $db->query($sql);$row = $result->fetch(pdo::fetch_assoc);print_r($row);