Example #1
0
 public function simpleQuery($query)
 {
     $db = new mysqli(dbhost, dbuser, dbpass, dbname);
     $explode = explode("'", $query);
     $query = "";
     $x = 0;
     while (isset($explode[$x])) {
         if ($x / 2 == floor($x / 2) and $x != 0) {
             $escape = $db->mysqli_real_escape_string($explode[$x]);
             $explode[$x] = "'" . $escape . "'";
         }
         $query = $query . $explode[$x];
         $x++;
     }
     if (!($result = $db->query($query))) {
         $db->free();
         $db->close();
         return FALSE;
     }
     if ($db->connect_errno > 0) {
         $db->free();
         $db->close();
         return FALSE;
     }
     $outarray['rows'] = $db->mysqli_rows($result);
     $x = 0;
     if ($outarray['rows'] > 0) {
         while ($x < $outarray['rows']) {
             $resultrows = $db->mysqli_array($result);
             $outarray['rowdata'][$x] = $resultrows;
             $x++;
         }
         $out = $outarray;
     } else {
         $db->free();
         $db->close();
         return FALSE;
     }
     $db->free();
     $db->close();
     return TRUE;
 }