query($query)){ return $result; } else { $final['error'] = "Database error."; if($debug){ $final['debug'] = $debug; $final['query'] = trim(preg_replace('/\s\s+/', ' ', $query)); $final['mysql_error'] = $GLOBALS['mysqli']->error; } echo json_encode($final); exit; } } function DBSelect($query, $debug = 0, $filterNil = 0) { //filterNil: 2 if nil or 0 should be removed from the data, 1 if only 0 $data = array(); if($result = $GLOBALS['mysqli']->query($query. " LIMIT 500")){ while($row=$result->fetch_assoc()) { if($filterNil == 2){ $data[] =array_filter($row); } else if($filterNil == 1) { $data[] =array_filter($row , 'notZero'); } else { $data[] = $row; } } } else { $final['error'] = "Database error."; if($debug){ $final['debug'] = $debug; $final['query'] = trim(preg_replace('/\s\s+/', ' ', $query)); $final['mysql_error'] = $GLOBALS['mysqli']->error; } echo json_encode($final); exit; } return $data; } function notZero($var){ return ($var !== NULL && $var !== FALSE && $var !== ''); } function DBInsert($inputArray, $table, $debug = 0) { $query = "INSERT IGNORE INTO `{$table}` (`".implode("`, `", array_keys($inputArray))."`) VALUES ('".implode("', '", $inputArray)."') "; if($result = $GLOBALS['mysqli']->query($query)){ return $GLOBALS['mysqli']->insert_id; } else { $final['error'] = "Database error."; if($debug){ $final['debug'] = $debug; $final['query'] = trim(preg_replace('/\s\s+/', ' ', $query)); $final['mysql_error'] = $GLOBALS['mysqli']->error; } echo json_encode($final); exit; } return 0; } function DBUpdate($updateArray, $whereArray, $table, $debug = 0) { $set = ""; foreach ($updateArray as $key => $value){ // add "," if it's not the first if($set != ''){ $set .= ", "; } $set .= "`{$key}` = '{$value}'"; } $where = ""; foreach ($whereArray as $key => $value){ // add "," if it's not the first if($where != ''){ $where .= ", "; } $where .= "`{$key}` = '{$value}'"; } $query = "UPDATE `{$table}` SET {$set} WHERE {$where}"; if($result = $GLOBALS['mysqli']->query($query)){ return 1;//$GLOBALS['mysqli']->insert_id; } else { $final['error'] = "Database error."; if($debug){ $final['debug'] = $debug; $final['query'] = trim(preg_replace('/\s\s+/', ' ', $query)); $final['mysql_error'] = $GLOBALS['mysqli']->error; } echo json_encode($final); exit; } return 0; } function DBInsertOrUpdate($inputArray, $table, $debug = 0) { $set = ""; foreach ($inputArray as $key => $value){ // add "," if it's not the first if($set != ''){ $set .= ", "; } $set .= "`{$key}` = '{$value}'"; } $query = "INSERT INTO `{$table}` (`".implode("`, `", array_keys($inputArray))."`) VALUES ('".implode("', '", $inputArray)."') ON DUPLICATE KEY UPDATE {$set}"; if($result = $GLOBALS['mysqli']->query($query)){ return $GLOBALS['mysqli']->insert_id; } else { $final['error'] = "Database error."; if($debug){ $final['debug'] = $debug; $final['query'] = trim(preg_replace('/\s\s+/', ' ', $query)); $final['mysql_error'] = $GLOBALS['mysqli']->error; } echo json_encode($final); exit; } return 0; }
Notice: Undefined index: Content-Type in /var/www/zumzet.ro/html/api/quizApp/index.php on line 10

Warning: mysqli::__construct(): (HY000/1045): Access denied for user 'SQLUser'@'localhost' (using password: YES) in /var/www/zumzet.ro/html/api/quizApp/index.php on line 18
Failed to connect to MySQL: Access denied for user 'SQLUser'@'localhost' (using password: YES)
Warning: mysqli::set_charset(): Couldn't fetch mysqli in /var/www/zumzet.ro/html/api/quizApp/index.php on line 22

Warning: array_map() expects parameter 1 to be a valid callback, function 'array_map_callback' not found or invalid function name in /var/www/zumzet.ro/html/api/quizApp/index.php on line 37
Test Layout

Change views/default.php


Warning: mysqli::close(): Couldn't fetch mysqli in /var/www/zumzet.ro/html/api/quizApp/index.php on line 80