PHP部分如下,其中{"userId":"117034910192","eventId":"95"}:
public function isRegistered($userId, $eventId)
{
// TODO: Implement isRegistered() method.
$pdo=$this->fetchMysqlConnection();
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
echo $userId;
echo $eventId;
$sql="select id from event_table where id=".$eventId."AND event_table.member_list like '%,".$userId.",%'";
try{
$result = $pdo->query($sql);
print_r($result);
//echo $result->fetch();
$this->endMysqlConnection($pdo);
return(($result!=0)?true:false);
}catch (PDOException $e){
echo "PDOError: ".$e;
}
//var_dump( $count);
//echo $count->rowCount();
exit();
}
输出:11703491019295
报错:
PDOError: exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'event_table.member_list like '%,117034910192,%'' at line 1' in /var/www/jdjbz/EventModule/DaoImpl/EventMapperImpl.php:171
Stack trace:
#0 /var/www/jdjbz/EventModule/DaoImpl/EventMapperImpl.php(171): PDO->query('select id from ...')
#1 /var/www/jdjbz/EventModule/ServiceImpl/EventServiceImpl.php(223): EventModule\DaoImpl\EventMapperImpl->isRegistered('117034910192', '95')
#2 /var/www/jdjbz/EventModule/Controller/EventAction.php(81): EventModule\ServiceImpl\EventServiceImpl->getEventBasicStatus('95', '117034910192')
#3 /var/www/jdjbz/EventModule/Utils/Request.php(54): EventModule\Controller\EventAction::getEventDescription(Array)
#4 /var/www/jdjbz/EventModule/Utils/index.php(14): EventModule\Utils\Request::getRequest()
#5 {main}
但是,求救这是什么鬼- -
public function isRegistered($userId, $eventId)
{
// TODO: Implement isRegistered() method.
$pdo=$this->fetchMysqlConnection();
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
echo $userId;
echo $eventId;
$sql="select id from event_table where id=".$eventId."AND event_table.member_list like '%,".$userId.",%'";
try{
$result = $pdo->query($sql);
print_r($result);
//echo $result->fetch();
$this->endMysqlConnection($pdo);
return(($result!=0)?true:false);
}catch (PDOException $e){
echo "PDOError: ".$e;
}
//var_dump( $count);
//echo $count->rowCount();
exit();
}
输出:11703491019295
报错:
PDOError: exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'event_table.member_list like '%,117034910192,%'' at line 1' in /var/www/jdjbz/EventModule/DaoImpl/EventMapperImpl.php:171
Stack trace:
#0 /var/www/jdjbz/EventModule/DaoImpl/EventMapperImpl.php(171): PDO->query('select id from ...')
#1 /var/www/jdjbz/EventModule/ServiceImpl/EventServiceImpl.php(223): EventModule\DaoImpl\EventMapperImpl->isRegistered('117034910192', '95')
#2 /var/www/jdjbz/EventModule/Controller/EventAction.php(81): EventModule\ServiceImpl\EventServiceImpl->getEventBasicStatus('95', '117034910192')
#3 /var/www/jdjbz/EventModule/Utils/Request.php(54): EventModule\Controller\EventAction::getEventDescription(Array)
#4 /var/www/jdjbz/EventModule/Utils/index.php(14): EventModule\Utils\Request::getRequest()
#5 {main}
但是,求救这是什么鬼- -
错不错你说了不算