程序在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这条语句测试是有结果的请高手分析下,是什么原因导致的??
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这条语句测试是有结果的请高手分析下,是什么原因导致的??
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;
}
}
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 = "SELECT member_id FROM " . __DB_PREFIX__ . "member WHERE email=" . $name . " AND password'" . $password . "";
这个试一下,可好使?
$sql = "SELECT member_id FROM " . __DB_PREFIX__ . "member WHERE email=" . $name . " AND password=" . $password ;
不好意思,刚刚贴错了
原来的是:$sql = "SELECT member_id FROM " . __DB_PREFIX__ . "member WHERE email='" . $name . "' AND password='" . $password . "'";
现在问题是出在什么地方了,不清楚呀!!
$result = $stmt->fetch(PDO_FETCH_ASSOC);
print_r($result);//看看是否有打印结果!
------------
Description:
------------
Using PDO DBLIB driver to connect to MySQL server each SELECT query
I've
tried this far returns a valid resultset but PDOStatement::rowCount()
always returns 0.When i use php 5.1.6 all works fine.Reproduce code:
---------------
<?php $db = new PDO("mysql:host=xxx;dbname=xxx", "xxx", "xxx",
array(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY => true)); $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $r = $db->query("SELECT * FROM xxx");
echo "<pre>";
echo "rowCount = ".$r->rowCount();
echo "</pre>";?>Expected result:
----------------
rowCount = 540554Actual result:
--------------
rowCount = 0
Bug #40822 pdo rowcount bug原文地址:http://bugs.php.net/bug.php?id=40822
http://blog.csdn.net/windcsg/article/details/8058648