欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  后端开发

pdo 与mysql 的有关问题,

程序员文章站 2024-01-27 14:55:40
...
pdo 与mysql 的问题,请教高手?
程序在window下正常,然而在linux下,
register:
public function Insert($input) {

$time = time ();

$sql = " INSERT INTO " . __DB_PREFIX__ . "member(
`email`,
`password`,
`secrecy_email`,
`lock`,
`add_time`,
`last_login_time`
)VALUES(
'" . $input ['name'] . "',
'" . md5 ( $input ['password'] ) . "',
'" . $input ['email'] . "',
0,
" . $time . ",
" . $time . "
)";

$stmt = $this->prepare ( $sql );

if (! $stmt->execute ()) {
throw new Exception ( join ( ' ', $stmt->errorInfo () ) );
}
}
这个方法好用,但是:
public function Account($name, $password) {

$sql="select member_id from gm_member where email='mygirl' and password='25d55ad283aa400af464c76d713c07ad'";
//$sql = "SELECT member_id FROM " . __DB_PREFIX__ . "member WHERE email='" . $name . "' AND password='" . $password . "'";
//$sth = $this->prepare ( $sql );
//$sth->execute ();
$stmt = $this->prepare ( $sql );

if (! $stmt->execute ()) {
throw new Exception ( join ( ' ', $stmt->errorInfo () ) );
}
return ($stmt->rowCount () == 1) ? true : false;

}
}
这个法就不能用,为什么呢?
也就是说insert是可以的,但是用select 的时,就查不出来 了,在mysql 中用$sql这条语句测试是有结果的

请高手分析下,是什么原因导致的??

------解决方案--------------------
有没有报错呢?
------解决方案--------------------
PHP code

public function Account($name, $password) {

$sql="select member_id from gm_member where email='mygirl' and password='25d55ad283aa400af464c76d713c07ad'";
//$sql = "SELECT member_id FROM " . __DB_PREFIX__ . "member WHERE email='" . $name . "' AND password='" . $password . "'";
//$sth = $this->prepare ( $sql );
//$sth->execute ();
$stmt = $this->prepare ( $sql );
       
        if (! $stmt->execute ()) {
            throw new Exception ( join ( ' ', $stmt->errorInfo () ) );
        }
[color=#FF0000]$result = $stmt->fetch(PDO_FETCH_ASSOC);
print_r($result);[/color]看看有结果不!
return ($stmt->rowCount () == 1) ? true : false;
     
}
}

------解决方案--------------------
PHP code

public function Account($name, $password) {

$sql="select member_id from gm_member where email='mygirl' and password='25d55ad283aa400af464c76d713c07ad'";
//$sql = "SELECT member_id FROM " . __DB_PREFIX__ . "member WHERE email='" . $name . "' AND password='" . $password . "'";
//$sth = $this->prepare ( $sql );
//$sth->execute ();
$stmt = $this->prepare ( $sql );
       
        if (! $stmt->execute ()) {
            throw new Exception ( join ( ' ', $stmt->errorInfo () ) );
        }
$result = $stmt->fetch(PDO_FETCH_ASSOC);
print_r($result);
return ($stmt->rowCount () == 1) ? true : false;
     
}
}

------解决方案--------------------
SQL code

$sql = "SELECT member_id FROM " . __DB_PREFIX__ . "member WHERE email=" . $name . " AND password'" . $password . "";

------解决方案--------------------
SQL code

$sql = "SELECT member_id FROM " . __DB_PREFIX__ . "member WHERE email=" . $name . " AND password=" . $password ;
 
pdo 与mysql 的有关问题,

声明:本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系admin@php.cn核实处理。

相关文章

相关视频