PHP Sql::fetch方法代码示例

 static function resetPassword($data)
 {
     PDOSql::$pdobj = pdoConnect();
     $hash = Sql::esc($data['h']);
     $type = Sql::esc($data['t']);
     $email = Sql::esc($data['q']);
     $pass1 = Sql::esc($data['pass1']);
     $pass2 = Sql::esc($data['pass2']);
     if ($pass1 !== $pass2) {
         return array('success' => false, 'data' => '', 'msg' => 'Las contraseñas no coinciden');
     }
     if ($type == 'C') {
         $get_hash = "SELECT id, email, resetHash from clientes where email ='" . $email . "' AND resetHash = '" . $hash . "'";
         $delete_hash = "UPDATE clientes set password = MD5('" . $pass1 . "'), resetHash = null where email ='" . $email . "' AND resetHash = '" . $hash . "'";
     } elseif ($type == 'U') {
         $get_hash = "SELECT id, email, resetHash from usuarios where email ='" . $email . "' AND resetHash = '" . $hash . "'";
         $delete_hash = "UPDATE usuarios set password = MD5('" . $pass1 . "'), resetHash = null where email ='" . $email . "' AND resetHash = '" . $hash . "'";
     } else {
         return array('success' => false, 'data' => '', 'msg' => 'Problema con el reseteo');
     }
     $h = Sql::fetch($get_hash);
     if (count($h) == 1) {
         $u = Sql::update($delete_hash);
         return array('success' => true, 'data' => array('id' => $h[0]['id']), 'msg' => 'Se realizo la operacion con exito.');
     } else {
         return array('success' => false, 'data' => '', 'msg' => 'Codigo invalido');
     }
 }

 static function markAsRead($id)
 {
     PDOSql::$pdobj = pdoConnect();
     $id = Sql::esc($id);
     $iduser = Sql::esc($_SESSION['userID']);
     $res = Sql::fetch("UPDATE notifications set status = '1', view_date = NOW() WHERE id = '{$id}' AND iduser = '{$iduser}'");
     return array('success' => true, 'data' => $res, 'msg' => '');
 }

 /**
  * Parses the template and executes the listing
  * @return void Prints the listing
  */
 public function execute()
 {
     if ($this->template == null) {
         Kernel::Log('There\'s no template, cannot generate listing');
         return false;
     } else {
         $columns = Text::parseStringVar($this->template);
         foreach ($columns as $key => $i) {
             if (in_array($i, array_keys($this->vars))) {
                 unset($columns[$key]);
             }
         }
         if (isset($this->options['max_regs']) && isset($this->options['page_index'])) {
             if ($this->options['max_regs'] < 2) {
                 Kernel::Log('The max_regs option must be higher than 1');
                 return false;
             }
             $rows_page = $this->options['max_regs'];
             $index = $this->options['page_index'];
             if (isset($this->options['criteria'])) {
                 $this->options['criteria'] = ' ' . $this->options['criteria'];
             } else {
                 $this->options['criteria'] = '';
             }
             $rows = Sql::numRows('SELECT ' . implode(', ', $columns) . ' FROM ' . $this->table . $this->options['criteria']);
             if (!isset($this->options['template_pag'])) {
                 $pag = new HTMLObj('div');
                 $pag->class = "sonicwulf_pages";
             } else {
                 $pag_html = '';
             }
             for ($i = 0; $i <= ceil($rows / $this->options['max_regs']) - 1; $i++) {
                 if (!isset($this->options['template_pag'])) {
                     $div = $pag->addChild('a');
                     $div->addContent($i);
                     $div->href = $_SERVER['PHP_SELF'] . '?' . $this->options['get_name'] . '=' . $i;
                     $div->class = 'sonicwulf_pagenum';
                 } else {
                     $parse = Text::parseStringVar($this->options['template_pag']);
                     if (in_array('href', $parse)) {
                         $pag_html .= str_replace('%page_link%', $_SERVER['PHP_SELF'] . '?' . $this->options['get_name'] . '=' . $i, $this->options['template_pag']);
                     } else {
                         Kernel::Log('There\'s no HREF attribute on the template, please add the atrribute');
                         return false;
                     }
                 }
             }
             if (!isset($this->options['template_pag'])) {
                 $pag_html = $pag->executeNoFormat();
             }
         } else {
             $rows_page = null;
             $index = null;
             $pag_html = null;
         }
         foreach ($this->getQuery($columns, $rows_page, $index) as $reg) {
             $string = $this->template;
             foreach ($columns as $i) {
                 if (isset($reg[$i])) {
                     $string = str_replace("%" . $i . "%", $reg[$i], $string);
                 }
             }
             foreach ($this->vars as $key => $i) {
                 if (is_array($i)) {
                     $data = Sql::fetch("SELECT " . $i[0] . " FROM " . $i[1] . $i[2]);
                     $string = str_replace("%" . $key . "%", $data[0][$i[0]], $string);
                 } else {
                     $string = str_replace("%" . $key . "%", $i, $string);
                 }
             }
             echo $string;
         }
         echo $pag_html;
     }
 }

 static function rubros()
 {
     PDOSql::$pdobj = pdoConnect();
     $rubs = Sql::fetch("SELECT rubro from rubros_generales ORDER BY id");
     $r = array();
     foreach ($rubs as $rub) {
         $r[] = array('rubro' => $rub['rubro']);
     }
     return $r;
 }