function query($query, $conn = false) { /* * set the database connection globally * or pass the database connection as second parameter in function call (optional) */ if(!$conn && trim($conn) == '') { global $conn; } if(isset($query) && !empty($query)) { $query = trim($query); $result = mysqli_query($conn, $query); $query_type = trim(strtolower(explode(" ", $query)[0])); if($query_type == "select") { if($result && mysqli_num_rows($result)>0) { $data = []; while($row = mysqli_fetch_assoc($result)) { foreach($row as $key=>$val) { $row[$key] = str_replace("\'", "'", $val); } $data[] = $row; } return $data; } } elseif($query_type == "insert") { $id = mysqli_insert_id($conn); if($id) { return $id; } } elseif($query_type == "update" || $query_type == "delete") { if($result && mysqli_affected_rows($conn)>0) { return true; } } } return false; }