how can troubleshoot further? have 3 styles of querying. fetchtype = 'single' ( single row is) , 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 coming false , see no data in sql table.
i verified querytype exists in lookup table , other queries working.
here actual query. inserted new lines make readable.
"signup_insert" => "insert credentials (h_token, h_file, h_pass, email, name, picture, privacy) values (?, ?, ?, ?, ?, ?, ?)"
here debug code 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;
Comments
Post a Comment