PHP DB::findAll方法代码示例

 /**
  * @param $qid
  * @return array
  * 根据问题编号查找所有问题答案
  */
 function getAnswer_by_qid($qid)
 {
     $res = array();
     if (is_array($qid)) {
         foreach ($qid as $id) {
             $sql = 'select * from ' . $this->_answerTable . ' where qid=' . $id . ' order by dateline desc';
             $temp = DB::findAll($sql);
             if (!empty($temp)) {
                 $res[] = $temp;
             }
         }
     } else {
         $sql = 'select * from ' . $this->_answerTable . ' where qid=' . $qid . ' order by dateline desc';
         $temp = DB::findAll($sql);
         if (is_array($temp)) {
             foreach ($temp as $key => $val) {
                 $val['dateline'] = date("Y-m-d H:i:s  T", $val['dateline']);
                 $temp[$key] = $val;
             }
         }
         if (!empty($temp)) {
             $res = $temp;
         }
     }
     return $res;
 }

 function getOneMonthSalaryDetail($usercode, $Year, $Month)
 {
     //表格数据
     $sql = "SELECT filed_index\n                from " . $this->_filetable . "\n                where activestatus = '0'\n                ORDER BY sortnum";
     $fileArr = DB::findAll($sql);
     //循环数据生成SQL语句  将detail表橫表变竖表
     $sql = "";
     foreach ($fileArr as $k => $val) {
         $sql .= "SELECT \"" . $val["filed_index"] . "\" as filename," . $val["filed_index"] . " as num from " . $this->_dtailtable . " WHERE userno=\"" . $usercode . "\"\n                 and year=\"" . $Year . "\" and month=\"" . $Month . "\" union ";
     }
     $sql = rtrim(trim($sql), 'union ');
     $sql = "SELECT filed_index,chinese_name,english_name,sortnum,\n                CASE WHEN isstrong = 0 THEN '' WHEN isstrong = 1 THEN 'uk-text-bold' END AS isstrong,\n                CASE WHEN islarger = 0 THEN '' WHEN islarger = 1 THEN 'uk-text-large' END AS islarger,\n                color,detailtable.num FROM " . $this->_filetable . " left join (" . $sql . ") detailtable\n               on " . $this->_filetable . ".filed_index=detailtable.filename\n               where salary_filed.activestatus='0'\n               order by " . $this->_filetable . ".sortnum";
     return DB::findAll($sql);
 }

 function getAll($sid)
 {
     $sql = 'select * from ' . $this->_table . ' where sid=' . $sid;
     $temp = DB::findAll($sql);
     if (is_array($temp)) {
         foreach ($temp as $key => $val) {
             $val['dateline'] = date("Y-m-d  T", $val['dateline']);
             $temp[$key] = $val;
         }
     } elseif (!empty($temp)) {
         $temp['dateline'] = date("Y-m-d  T", $temp['dateline']);
     }
     return $temp;
 }

 public function findOne($where = array(), $field = array('*'))
 {
     //array('id'=>1,'pid'=>1)
     $fieldstr = implode(',', $field);
     if (count($where) >= 1) {
         foreach ($where as $k => $v) {
             $str .= $k . '="' . $v . '" and ';
         }
         $str = substr($str, 0, -5);
         $sql = 'select ' . $fieldstr . ' from ' . $this->_table . ' where ' . $str;
     } else {
         $sql = 'select ' . $fieldstr . ' from ' . $this->_table;
     }
     return DB::findAll($sql);
 }

 public function findall($where = array())
 {
     //array('id'=>1,'pid'=>1)
     if (count($where) >= 1) {
         foreach ($where as $k => $v) {
             $str .= $k . '="' . $v . '" and ';
         }
         $str = substr($str, 0, -5);
         $sql = 'select * from ' . $this->_table . ' where ' . $str;
     } else {
         $sql = 'select * from ' . $this->_table;
     }
     //print_r($sql);
     //die();
     return DB::findAll($sql);
 }

 function getAll($sid)
 {
     $sql = 'select * from ' . $this->_table . " where sid=" . $sid . ' order by dateline desc';
     $temp = DB::findAll($sql);
     if (is_array($temp)) {
         foreach ($temp as $key => $val) {
             $username = unserialize($val['username']);
             if (is_array($username)) {
                 $val['username'] = implode(",", $username);
             }
             $val['dateline'] = date("Y-m-d  T", $val['dateline']);
             $temp[$key] = $val;
         }
     } elseif (!empty($temp)) {
         $temp['username'] = unserialize($temp['username']);
         $temp['dateline'] = date("Y-m-d  T", $temp['dateline']);
     }
     return $temp;
 }

 function getinquirydetail($inquireid)
 {
     //获取调查问卷题目详情
     $sql = "select * from " . $this->_inquiryquestion . " where inquireid=\"" . $inquireid . "\" order by sortnum";
     $inquiryquestionArr = DB::findAll($sql);
     $sql = "select " . $this->_inquiryoption . ".* from " . $this->_inquiryquestion . "," . $this->_inquiryoption . " where " . $this->_inquiryoption . ".questionid=" . $this->_inquiryquestion . ".id" . " and " . $this->_inquiryquestion . ".inquireid=\"" . $inquireid . "\" order by sortnum";
     $inquiryoptionArr = DB::findAll($sql);
     //将选项作为数组直接插入到问题后
     for ($j = 0; $j < count($inquiryquestionArr); $j++) {
         if (isset($newoptionArr)) {
             unset($newoptionArr);
         }
         for ($i = 0; $i < sizeof($inquiryoptionArr); $i++) {
             if ($inquiryoptionArr[$i]["questionid"] == $inquiryquestionArr[$j]["id"]) {
                 $newoptionArr[] = $inquiryoptionArr[$i];
             }
         }
         if (isset($newoptionArr)) {
             $inquiryquestionArr[$j]["data"] = $newoptionArr;
         }
     }
     return $inquiryquestionArr;
 }

 function findAll($appid)
 {
     $sql = 'select * from ' . $this->_table . ' where appid="' . $appid . '"';
     return DB::findAll($sql);
 }

     <?php 
echo '<h3 align="center">Entrenadores Inactivos</h3>
     <table class="table table-hover">
     <tr>
     <td>Folio</td>
     <td>Nombre</td>
     <td>Apellidos</td>
     <td>Alias</td>
     <td>Activar</td>
     </tr>';
$susp0 = $_POST['susp0'];
$data = array();
$data = array('suspendido' => $susp0);
$db = new DB("root", "110992", "localhost", "centrospokemon");
$entrenadores = $db->findAll('entrenadores', $data);
//$db->pretty();
foreach ($entrenadores as $entre) {
    ?>
     <tr>
       <td><?php 
    echo $entre['id'];
    ?>
</td>
       <td><?php 
    echo $entre['nombre'];
    ?>
</td>
       <td><?php 
    echo $entre['apellidos'];
    ?>

<?php

require '../../boot.php';
require '../../session.php';
if (!isset($session) || $session->auth == "") {
    Common::Error(401, 'json');
}
$req = Request::all($_REQUEST);
if (empty($req)) {
    exit;
}
$users = DB::findAll("users_detail", $req);
for ($i = 0; $i < count($users); $i++) {
    $users[$i]->password = 'xxxxxxxx';
}
echo json_encode($users);
exit;

<?php

require '../../boot.php';
require '../../session.php';
if (!isset($session) || $session->auth == "") {
    Common::Error(401, 'json');
}
$req = Request::all($_REQUEST);
if (empty($req)) {
    $users = DB::get("users");
    for ($i = 0; $i < count($users); $i++) {
        $users[$i]->password = 'xxxxxxxx';
        $users[$i]->satker = Suggest::getSatker($users[$i]->kd_subunit);
    }
    echo json_encode($users);
    exit;
}
$users = DB::findAll("users", $req);
for ($i = 0; $i < count($users); $i++) {
    $users[$i]->password = 'xxxxxxxx';
    $users[$i]->satker = Suggest::getSatker($users[$i]->kd_subunit);
}
echo json_encode($users);
exit;

     <?php 
echo '<h3 align="center">Regeneradores Inactivos</h3>
     <table class="table table-hover">
     <tr>
     <td>Folio</td>
     <td>Slots</td>
     <td>Slots Funcionales</td>
     <td>Mantenimiento</td>
     <td>Centro Pokemon</td>
     <td>Activar</td>
     </tr>';
$susp0 = $_POST['susp0'];
$data = array();
$data = array('suspendido' => $susp0);
$db = new DB("root", "110992", "localhost", "centrospokemon");
$enfermeras = $db->findAll('vista_regeneradores', $data);
//$db->pretty();
foreach ($enfermeras as $enfe) {
    $mante = $enfe['esta_mantenimiento'];
    if ($mante == 1) {
        $imprimir = "Si";
    } else {
        $imprimir = "No";
    }
    ?>
     <tr>
      <td><?php 
    echo $enfe['id'];
    ?>
</td>
      <td><?php 

    $centros = $db->findAll('catalogo_estatus', $data);
    foreach ($centros as $cen) {
        ?>
     <option value="<?php 
        echo $centropoke;
        ?>
" select><?php 
        echo $cen['nombre'];
        ?>
</option>
     <?php 
    }
    ?>
     <?php 
    $db = new DB("root", "110992", "localhost", "centrospokemon");
    $estatus = $db->findAll('catalogo_estatus');
    //$db->pretty();
    foreach ($estatus as $est) {
        ?>
     <option value="<?php 
        echo $poke['estatus'];
        ?>
" ><?php 
        echo $est['nombre'];
        ?>
</option>
     <?php 
    }
    ?>
     </select>
     </div>

    echo $cata['habilidad'];
    ?>
<br>
         </div>
          <?php 
}
?>
       </td>
      <td>
     <?php 
#$id = $_GET['id'];
$id_prevolucion = $id;
$data = array();
$data = array('id_prevolucion' => $id_prevolucion);
$db = new DB("root", "110992", "localhost", "centrospokemon");
$catalogos = $db->findAll('vista_evolucion', $data);
foreach ($catalogos as $cata) {
    ?>
       <div align="center">
        <b>Evolucion: <b> 
       <b><?php 
    echo $cata['especie'];
    ?>
</b><br>
      <img src="./images/<?php 
    echo $cata['imagen'];
    ?>
">
      </div>
     <?php 
}

<?php

include "DB.php";
?>
<html>
<head>
  <title>To Do List</title>
</head>
<body>
  <h1>To Do List</h1>
  <form action="save.php" method="POST">
    <input type="text" id="task" name="task" placeholder="Write a task">
    <button type="submit">Guardar</button>
  </form>
  <a href="json.php">Ver en JSON</a>
  <hr/>
<?php 
$db = new DB("root", "110992", "localhost", "todo");
$tareas = $db->findAll('tasks');
//$db->pretty();
foreach ($tareas as $tarea) {
    echo $tarea['id'] . " - " . $tarea['task'] . " <a style=\"color:red\" href=\"delete.php?id=" . $tarea['id'] . "\">&times;</a> | <a href=\"update.php?id=" . $tarea['id'] . "\">Editar</a><br/>";
}
?>
</body>
</html>