PHP sql::count方法代码示例

 function is_user()
 {
     $valid = sql::count('admin', "admin_email='{$_POST['email']}'");
     if ($valid > 0) {
         return TRUE;
     } else {
         $this->form_validation->set_message('is_user', 'Email is invalid!');
         return FALSE;
     }
 }

 function get_user_grid()
 {
     $sortname = common::getVar('sidx', 'id');
     $sortorder = common::getVar('sord', 'asc');
     $sort = "ORDER BY {$sortname} {$sortorder}";
     $searchField = common::getVar('searchField');
     $searchValue = common::getVar('searchValue');
     $con = 1;
     if ($searchField != '' && $searchValue != '') {
         $con .= " and {$searchField} like '%{$searchValue}%'";
     }
     $sql = "select * from scic_user where  {$con} {$sort}";
     $page = common::getVar('page', 1);
     $limit = common::getVar('rows');
     $count = sql::count("scic_user");
     if ($count > 0) {
         $total_pages = ceil($count / $limit);
     } else {
         $total_pages = 0;
     }
     if ($page > $total_pages) {
         $page = $total_pages;
     }
     if ($limit < 0) {
         $limit = 0;
     }
     $start = $limit * $page - $limit;
     if ($start < 0) {
         $start = 0;
     }
     $sql_query = $this->db->query($sql . " limit {$start}, {$limit}");
     $rows = $sql_query->result_array();
     $i = 0;
     $responce->page = $page;
     $responce->total = $total_pages;
     $responce->records = $count;
     foreach ($rows as $row) {
         $status = $row[status] == 'active' ? 'Active' : 'Inactive';
         $responce->rows[$i]['id'] = $row['id'];
         $responce->rows[$i]['cell'] = array($row['username'], $row['password'], $status);
         //$row['first_name'] . ' ' . $row['last_name'], $row['email'],
         $i++;
     }
     header("Expires: Sat, 17 Jul 2010 05:00:00 GMT");
     header("Last-Modified: " . gmdate("D, d M Y H:i:s") . "GMT");
     header("Cache-Control: no-cache, must-revalidate");
     header("Pragma: no-cache");
     header("Author: Mohaimen khan");
     header("Email: joyes528@gmail.com");
     header("Content-type: text/x-json");
     echo json_encode($responce);
     return '';
 }

 function get_shorturl_grid()
 {
     $sortname = common::getVar('sidx', 'id');
     $sortorder = common::getVar('sord', 'desc');
     $sort = "ORDER BY {$sortname} {$sortorder}";
     $serachoption = '1 ';
     if ($this->session->userdata('purchase_search') != '') {
         $serachoption = $this->session->userdata('purchase_search');
         //$this->session->unset_userdata('purchase_search');
     }
     $sql = "select * from urls where " . $serachoption . $sort;
     $page = common::getVar('page', 1);
     $limit = common::getVar('rows');
     $i = 0;
     $count = sql::count('urls', '1');
     if ($count > 0) {
         $total_pages = ceil($count / $limit);
     } else {
         $total_pages = 5;
     }
     if ($page > $total_pages) {
         $page = $total_pages;
     }
     if ($limit < 0) {
         $limit = 0;
     }
     $start = $limit * $page - $limit;
     if ($start < 0) {
         $start = 0;
     }
     $sql_query = $this->db->query($sql . " limit {$start}, {$limit}");
     $rows = $sql_query->result_array();
     $responce->page = $page;
     $responce->total = $total_pages;
     $responce->records = $count;
     foreach ($rows as $row) {
         $surl = "guit.biz/" . $row['shortcode'];
         $responce->rows[$i]['id'] = $row['id'];
         $responce->rows[$i]['cell'] = array($row['shortcode'], $surl, $row['url'], $row['ga_campaign'], $row['ga_adgroup'], $row['ga_ad_content'], $row['ga_keyword']);
         $i++;
     }
     header("Expires: Sat, 17 Jul 2010 05:00:00 GMT");
     header("Last-Modified: " . gmdate("D, d M Y H:i:s") . "GMT");
     header("Cache-Control: no-cache, must-revalidate");
     header("Pragma: no-cache");
     header("Author:Mohaimen khan");
     header("Email: joyes@sec.ac.bd");
     header("Content-type: text/x-json");
     echo json_encode($responce);
     return '';
 }

 function sendEmail($id)
 {
     // parameters of your mail server and how to send your email
     $config = array('protocol' => 'smtp', 'smtp_host' => 'ssl://smtp.googlemail.com', 'smtp_port' => 465, 'smtp_user' => 'test@aslingga.com', 'smtp_pass' => 'testpasswdxxx', 'mailtype' => 'html');
     $data = sql::row("scic_result", "user_id={$id}");
     $count = sql::count("scic_question", "type='1' and status='active'");
     $mul_marks = $data['first_part'] / $count * 100;
     $count = sql::count("scic_question", "type='1' and status='active'");
     $count_mth = sql::count("scic_question", "type='2' and status='active'");
     $math_marks = $data['second_part'] / $count_mth * 100;
     $name = sql::row("scic_skillset", "user_id={$id}");
     $t_tme = common::time_diff($name['left_time'], $name['arrival_time']);
     $sql = "SELECT * FROM scic_general,scic_question WHERE user_id={$id} and id=ans_number and scic_general.type='0' and scic_question.type='0'";
     $query = $this->db->query($sql, array($type));
     $result = $query->result_array();
     // recipient, sender, subject, and you message
     $to = "mike@space-coast-ic.com";
     $from = "Mohaimen@space-coast-ic.com";
     $subject = "Test Result::" . $name['fullname'];
     $message = "Candidate Name: " . $name['fullname'] . "</br> Candidate Email: " . $data['email'] . "</br> Marks in General: " . $data['general'] . "</br> Marks in first part:" . $mul_marks . " Percent(" . $data['first_part'] . " right answer among " . $count . " problems) </br> Marks in Second Part:" . $math_marks . " Percent(" . $data['second_part'] . " right answer among " . $count_mth . " problems) </br> Marks in Third Part: " . $data['third_part'] . "</br> Total Time Taken: " . $t_tme . " Seconds </br> </br>";
     $message .= "****<strong><u>Test Details::General Section</u></strong>**** </br>";
     foreach ($result as $row) {
         $message .= "<strong>" . $row['texts'] . "</strong></br><strong><u>Ans: </u></strong>" . $row['answer'] . "</br>";
     }
     $sql = "SELECT texts,scic_part_i.answer as given_answer,scic_answer.answer as org_answer,first,second,third,fourth FROM scic_part_i,scic_question,scic_multi_ans,scic_answer WHERE scic_part_i.user_id={$id} and scic_question.id=scic_part_i.ans_number and scic_answer.ans_number=scic_part_i.ans_number and scic_answer.type='1' and  scic_part_i.type=scic_question.type and scic_multi_ans.qid=scic_part_i.ans_number";
     $query = $this->db->query($sql, array($type));
     $result = $query->result_array();
     $message .= "</br>****<strong><u>Test Details::Multiple Choice Section</u></strong>**** </br>";
     foreach ($result as $row) {
         if ($row['given_answer'] == "a") {
             $mul = $row['first'];
             if ($row['given_answer'] != $row['org_answer']) {
                 $mul = $mul . "(<font color='red'>Wrong Answer</font>)";
             }
         } else {
             if ($row['given_answer'] == "b") {
                 $mul = $row['second'];
                 if ($row['given_answer'] != $row['org_answer']) {
                     $mul = $mul . "(<font color='red'>Wrong Answer</font>)";
                 }
             } else {
                 if ($row['given_answer'] == "c") {
                     $mul = $row['third'];
                     if ($row['given_answer'] != $row['org_answer']) {
                         $mul = $mul . "(<font color='red'>Wrong Answer</font>)";
                     }
                 } else {
                     if ($row['given_answer'] == "d") {
                         $mul = $row['fourth'];
                         if ($row['given_answer'] != $row['org_answer']) {
                             $mul = $mul . "(<font color='red'>Wrong Answer</font>)";
                         }
                     } else {
                         $mul = "None(<font color='red'>Wrong Answer</font>)";
                     }
                 }
             }
         }
         $message .= "<strong>" . $row['texts'] . "</strong></br><strong><u>Ans: </u></strong>" . $mul . "</br>";
     }
     $sql = "SELECT texts,scic_part_ii.answer as given_answer,scic_answer.answer as org_answer FROM scic_part_ii,scic_question,scic_answer WHERE scic_part_ii.user_id={$id} and scic_question.id=scic_part_ii.ans_number and scic_part_ii.type=scic_question.type and scic_answer.type='2' and scic_answer.ans_number=scic_part_ii.ans_number";
     $query = $this->db->query($sql, array($type));
     $result = $query->result_array();
     $message .= "</br>****<strong><u>Test Details::Math Section</u></strong>**** </br>";
     foreach ($result as $row) {
         if ($row['given_answer'] != $row['org_answer']) {
             $mul = $row['given_answer'] . "(<font color='red'>Wrong Answer</font>)";
         } else {
             $mul = $row['given_answer'];
         }
         //"None(<font color='red'>Wrong Answer</font>)";
         $message .= "<strong>" . $row['texts'] . "</strong></br><strong><u>Ans: </u></strong>" . $mul . "</br>";
     }
     $sql = "SELECT * FROM scic_part_iii,scic_question WHERE user_id={$id} and id=ans_number and scic_part_iii.type=scic_question.type";
     $query = $this->db->query($sql, array($type));
     $result = $query->result_array();
     $message .= "</br>****<strong><u>Test Details::Scenerio Section</u></strong>**** </br>";
     foreach ($result as $row) {
         $message .= "<strong>" . $row['texts'] . "</strong></br><strong><u>Ans: </u></strong>" . $row['answer'] . "</br>";
     }
     // load the email library that provided by CI
     //$this->load->library('email', $config);
     $this->load->library('email');
     // this will bind your attributes to email library
     //$this->email->set_newline("\r\n");
     $this->email->from($from, 'Space Coast IC');
     $this->email->to($to);
     $this->email->subject($subject);
     $this->email->message($message);
     $this->email->set_mailtype("html");
     // send your email. if it produce an error it will print 'Fail to send your message!' for you
     if ($this->email->send()) {
         $sql = "update scic_result set\n                notification=1\n                where user_id={$id}";
         return $this->db->query($sql);
     } else {
         echo "Fail to send your message!";
     }
 }

            Current Page: <?php 
echo $page;
?>
          </div>
          <ul>
            <?php 
$search = "";
$query = "SELECT rsn FROM rsAcc";
if (isset($_GET['search'])) {
    if (preg_match('([A-Za-z0-9\\-\\_]+)', $_GET['search'])) {
        $query = $query . " WHERE rsn LIKE '%" . $sql->escape($_GET['search']) . "%'";
        $search = "&search=" . $_GET['search'];
    }
}
$query = $query . " ORDER BY " . $sortType . " " . $sortDir;
$count = ceil($sql->count($query) / $perPage);
if ($page > 1) {
    echo "<li><a href=\"?page=" . ($page - 1) . "&sortType={$sortType}&sortDir={$realDir}{$search}\">&#x25C0</a></li>";
} else {
    echo "<li>&#x25C1</li>";
}
for ($i = 1; $i < $count + 1; $i++) {
    echo "<li><a href=\"?page={$i}&sortType={$sortType}&sortDir={$realDir}{$search}\">{$i}</a></li>";
}
if ($page < $count) {
    echo "<li><a href=\"?page=" . ($page + 1) . "&sortType={$sortType}&sortDir={$realDir}{$search}\">&#x25B6</a></li>";
} else {
    echo "<li>&#x25B7</li>";
}
?>
          </ul>

 function get_question_grid()
 {
     $sortname = common::getVar('sidx', 'id');
     $sortorder = common::getVar('sord', 'desc');
     $sort = " ORDER BY {$sortname} {$sortorder}";
     $searchField = $_REQUEST['searchField'];
     //common::getVar('searchField');
     //$searchValue = common::getVar('searchValue');
     $con = 1;
     if ($searchField != '0' && $searchField != '') {
         $searchField = $searchField - 1;
         $con .= " and type = {$searchField} ";
     }
     $sql = "select * from scic_question where " . $con . $sort;
     $page = common::getVar('page', 1);
     $limit = common::getVar('rows');
     $i = 0;
     $count = sql::count('scic_question', '1');
     if ($count > 0) {
         $total_pages = ceil($count / $limit);
     } else {
         $total_pages = 5;
     }
     if ($page > $total_pages) {
         $page = $total_pages;
     }
     if ($limit < 0) {
         $limit = 0;
     }
     $start = $limit * $page - $limit;
     if ($start < 0) {
         $start = 0;
     }
     $sql_query = $this->db->query($sql . " limit {$start}, {$limit}");
     $rows = $sql_query->result_array();
     $responce->page = $page;
     $responce->total = $total_pages;
     $responce->records = $count;
     foreach ($rows as $row) {
         if ($row['type'] == 0) {
             $label = "General";
         } else {
             if ($row['type'] == 1) {
                 $label = "First Part";
             } else {
                 if ($row['type'] == 2) {
                     $label = "Second part";
                 } else {
                     if ($row['type'] == 3) {
                         $label = "Third part";
                     } else {
                         $label = "None";
                     }
                 }
             }
         }
         $responce->rows[$i]['id'] = $row['id'];
         $responce->rows[$i]['cell'] = array($row['texts'], $label, $row['status']);
         $i++;
     }
     header("Expires: Sat, 17 Jul 2010 05:00:00 GMT");
     header("Last-Modified: " . gmdate("D, d M Y H:i:s") . "GMT");
     header("Cache-Control: no-cache, must-revalidate");
     header("Pragma: no-cache");
     header("Author:Mohaimen khan");
     header("Email: joyes@sec.ac.bd");
     header("Content-type: text/x-json");
     echo json_encode($responce);
     return '';
 }