public static function doCall($sql, $return = true, $debug = false) { $DBobject = parent::init(); //call the database $result = $DBobject->query($sql); if ($DBobject->errno) { $_SESSION['errors'][] = '<p>select failed: ' . $DBobject->error . '<br> statement was: <strong>' . $sql . '</strong></p>'; return array(); } elseif ($return == true) { $ret = array(); while ($row = $result->fetch_assoc()) { $ret[] = $row; } return $ret; } if ($debug == true) { logfile::doLog(__FUNCTION__ . ' : $sql is ' . $sql); } }
public static function doCall($table, $primary, $wnummer, $data, $debug = false) { $DBobject = parent::init(); $sql = "UPDATE {$table} SET "; foreach ($data as $key => $value) { if ($value == null) { $sql .= "{$key} = null, "; } else { $sql .= "{$key} = '{$value}', "; } } $sql = rtrim($sql, ", "); $sql .= " WHERE " . $primary . " = '" . $wnummer . "'"; if ($debug == true) { logfile::doLog(__FUNCTION__ . ' : $sql is ' . $sql); } $DBobject->query($sql); if ($DBobject->errno) { } }