duanque3125 2017-04-05 22:10
浏览 7

我的PDO查询似乎随机停止工作?

How can I troubleshoot further? I have 3 styles of querying. This is for a fetchType = 'single' ( single row that is) and a populated parameterArray

public function query($fetchType, $queryType, $parameterArray=null)
{
    $query=$this->sql_array[$queryType];
    if($parameterArray==null)
    {
        $pdoStatement = $this->db_one->query($query);
        $results = $pdoStatement->fetchAll(PDO::FETCH_ASSOC);
        return $results;
    }
    $this->db_one->quote($query);
    $pdoStatement = $this->db_one->prepare($query);
    $results = $pdoStatement->execute($parameterArray);
    if($fetchType=='single')
    {
        $results = $pdoStatement->fetch(PDO::FETCH_ASSOC);
    }
    else if($fetchType=='multiple')
    {
        $results = $pdoStatement->fetchAll(PDO::FETCH_ASSOC);
    }
    return $results;
}

My results is coming back false and I see no data in the sql table.

I verified that the queryType exists in the lookup table and that other queries are working.

Here is the actual query. I inserted new lines to make readable.

"signup_insert" =>            
"INSERT INTO credentials 
(h_token, h_file, h_pass, email, name, picture, privacy) 
VALUES (?, ?, ?, ?, ?, ?, ?)"

Here is the debug code I created:

$pipe['debug_h_token']=$h_token;
$pipe['debug_h_file']=$h_file;
$pipe['debug_h_pass']=$h_pass;
$pipe['debug_email']=$this->TO->get('email');
$pipe['debug_name']=$this->TO->get('name');
$pipe['debug_picture']=$picture;
$pipe['debug_privacy']=$privacy;

$test = $this->DBO->query('single', 'signup_insert', array(
    $h_token,
    $h_file,
    $h_pass,
    $this->TO->get('email'),
    $this->TO->get('name'),
    $picture,
    $privacy
));
$pipe['debug_test'] = $test;
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 微信小程序协议怎么写
    • ¥15 c语言怎么用printf(“\b \b”)与getch()实现黑框里写入与删除?
    • ¥20 怎么用dlib库的算法识别小麦病虫害
    • ¥15 华为ensp模拟器中S5700交换机在配置过程中老是反复重启
    • ¥15 java写代码遇到问题,求帮助
    • ¥15 uniapp uview http 如何实现统一的请求异常信息提示?
    • ¥15 有了解d3和topogram.js库的吗?有偿请教
    • ¥100 任意维数的K均值聚类
    • ¥15 stamps做sbas-insar,时序沉降图怎么画
    • ¥15 买了个传感器,根据商家发的代码和步骤使用但是代码报错了不会改,有没有人可以看看