pdo 与mysql 的有关问题,
程序员文章站
2022-06-04 17:08:24
...
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这条语句测试是有结果的
请高手分析下,是什么原因导致的??
------解决方案--------------------
有没有报错呢?
------解决方案--------------------
程序在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 ;相关文章
相关视频
上一篇: Hive的UDF实现详解
下一篇: 深入密码加salt原理的分析
推荐阅读
-
Mysql5.7中使用group concat函数数据被截断的问题完美解决方法
-
Windows 64 位 mysql 5.7以上版本包解压中没有data目录和my-default.ini及服务无法启动的快速解决办法(问题小结)
-
浅谈SQLServer的ISNULL函数与Mysql的IFNULL函数用法详解
-
mysql proxy问题的解决方法
-
完美解决MySQL通过localhost无法连接数据库的问题
-
ScrollView与ListView合用(正确计算Listview的高度)的问题解决
-
Fedora14下android开发: eclipse与ibus确有冲突的问题分析
-
实例解析Java中的synchronized关键字与线程安全问题
-
Mysql单文件存储删除数据文件容量不会减少的bug与解决方法
-
浅谈mysqldump使用方法(MySQL数据库的备份与恢复)