public function insertOnUpdate($table, $data, $update)
{
if (empty($data) || empty($update)) {
return false;
}
$sql = SqlBuilder::buildInsertOnUpdateSql($table, $data, $update);
$stmt = $this->_dao->prepare($sql);
$params = $this->buildParams($data, $update);
$this->bindParams($stmt, $params);
if ($stmt->execute()) {
return $stmt->affected_rows;
}
return false;
}
public function insertOnUpdate($table, $data, $update)
{
if (empty($data)) {
return false;
}
$sql = SqlBuilder::buildInsertOnUpdateSql($table, $data, $update);
$params = null;
if (is_array($data)) {
$params = array_values($data);
}
if (is_array($update)) {
$params = array_merge($params, array_values($update));
}
$stmt = $this->_dao->prepare($sql);
$result = $stmt->execute($params);
$affect_count = $stmt->rowCount();
return $affect_count === 0 ? $result : $affect_count;
}
