A question about PDO
PHP Code
if (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 =:p WD"; Require_once (' conn.php '); $sth = $db->prepare ($sql); $sth->bindparam (': LoginName ', $loginName, PDO::P aram_str, +); $sth->bindparam (':p wd ', $PWD, PDO::P aram_str, +); $sth->execute (); $rowCount = $sth->fetchcolumn (); Var_dump ($rowCount);//has been 0 $db = NULL; if ($rowCount = = 1) { echo ""; } else { alert (' Username or password is wrong! '); echo ""; }}
After submitting a user name and password that exists in the database or prompting for a password error, what is it?
------Solution--------------------
See if you can get the data with a normal query
PHP Code