Ejemplo n.º 1
0
 function __construct($data, $table, $cond)
 {
     if (Main::$con == FALSE) {
         Main::openConnection();
         $this->newCon = TRUE;
     }
     $data = Main::escape($data);
     $query = Main::generateQuery('UPDATE', $data, $table, $cond);
     mysql_query($query) or Main::throwException('Internal Error Occured', 0, 'Query Failed' . mysql_error());
     //Main::displaySuccess('DataBase Updated Successfully');
 }
Ejemplo n.º 2
0
 function getDetailsContains($table, $data = '*', $cond)
 {
     if (Main::$con == FALSE) {
         Main::openConnection();
         $this->newCon = TRUE;
     }
     $data = Main::escape($data);
     $query = "SELECT ";
     if (is_array($data)) {
         $i = 0;
         foreach ($data as $value) {
             if ($i < 1) {
                 $query .= "`{$value}`";
             } else {
                 $query .= ",`{$value}`";
             }
             $i++;
         }
     } else {
         if ($query == '*') {
             $query .= '*';
         } else {
             $query .= "`{$data}`";
         }
     }
     $query .= " FROM `{$table}`";
     $query .= " WHERE ";
     $i = 0;
     foreach ($cond as $key => $value) {
         if ($i < 1) {
             $query .= "`{$key}` LIKE '%{$value}%'";
         } else {
             $query .= "AND `{$key}` LIKE '%{$value}%'";
         }
         $i++;
     }
     $result = mysql_query($query) or die('Query Failed' . mysql_error());
     if (mysql_num_rows($result) > 0) {
         while ($row = mysql_fetch_assoc($result)) {
             $data[] = $row;
         }
         return $data;
     } else {
         return array();
     }
 }