初学thinkphp5 ,今天做注册功能,向Oracle数据库插入数据,有一个自增主键id,然后执行插入语句,数据库显示已经插入成功了 ,但是页面一直报这个错误。
有没有大神能帮忙解决一下?代码
$db_data = [
69 'ID' => null,
70 'USER_NAME' => $post_data['name'],
71 'USER_PASSWORD' =>MD5($post_data['pwd']),
72 'USER_STATUS' => '0',
73 'USER_AUTH' => '2',
74 ];
75 //$userId = Db::name('user')->getLastInsID();
76 //echo $userId;
77 $result = Db('user')->insert($db_data);
78 if($result)
79 {
80 return $this->success('注册成功','Login/login');
81 }
不知道为啥图片放不上来,错误信息:
SQLSTATE[HY000]: General error: 936 OCIStmtExecute: ORA-00936: missing ex
pression
(/opt/lampp/include/php/ext/pdo/pdo_oci/oci_statement.c:159)
/**
* 获取最近插入的ID
* @access public
* @param string $sequence 自增序列名
* @return string
*/
public function getLastInsID($sequence = null)
{
$pdo = $this->linkID->query("select {$sequence}.nextval as id from dual");//这一句标红
$pdo = $this->linkID->query("select {$sequence}.currval as id from dual");
$result = $pdo->fetchColumn();
$pdo = $this->linkID->query("alter sequence {$sequence} increment by -1");
$pdo = $this->linkID->query("select {$sequence}.nextval as id from dual");
$pdo = $this->linkID->query("alter sequence {$sequence} increment by 1");
return $result;
}
/**