public function testQueryInsertSqlStringSingleColumn() { $query = new QueryInsert('MyTable'); $query->setColumns(array('col')); $requiredSql = 'INSERT INTO MyTable(col) VALUES(?)'; $this->assertEquals($query->__toString(), $requiredSql); }
public function insert($table, $colsAndValues = null) { $query = new QueryInsert($table); $query->setColumns(array_keys($colsAndValues)); $stmt = $this->_db->prepare($query); $index = 1; foreach ($colsAndValues as $column => $value) { $stmt->bindValue($index++, $value); } return $stmt->execute(); }
public function insert($table, $values) { $queryInsert = new QueryInsert(); return $queryInsert->getSql(); }