本文整理汇总了PHP中sql::row方法的典型用法代码示例。如果您正苦于以下问题:PHP sql::row方法的具体用法?PHP sql::row怎么用?PHP sql::row使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类sql
的用法示例。
在下文中一共展示了sql::row方法的8个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: edit_admin
function edit_admin($cid = '')
{
if (!common::is_logged_in()) {
redirect('login');
}
if ($cid == '') {
redirect('admn');
}
$data['error'] = "";
$data['num'] = $this->mod_admin->get_admin_info();
if ($_POST['save']) {
if ($this->form_validation->run('valid_admin') && $data['num'] == 0) {
$data = array('user_id' => $_POST['user_name'], 'password' => $_POST['password'], 'email' => $_POST['email']);
$this->db->update('admin', $data, array('id' => $cid));
$data['new'] = $_POST['user_name'];
$data['current'] = $this->session->userdata('user_id');
$this->session->set_userdata('user_id', $data['new']);
$this->session->set_flashdata('msg', "<div class='success'>Content Changed Successfully</div>");
redirect('admn');
} else {
$this->session->set_flashdata('msg', "<div class='error'>User Exist,choose another name</div>");
redirect('admn');
}
}
$data = sql::row('admin', 'id=' . $cid);
$data['error'] = $err ? $err : '';
$data['dir'] = 'admn';
$data['action'] = 'admn/edit_admin/' . $cid;
$data['page'] = 'add_admn';
$data['page_title'] = "Edit";
$this->load->view('main', $data);
}
示例2: edit_user
function edit_user($user_id = '')
{
if (!common::update_permit()) {
common::redirect();
}
if ($_POST['save']) {
if ($this->form_validation->run('valid_user')) {
$this->mod_user->update_user();
//Don't Change
$this->session->set_flashdata('msg', 'Content Updated Successfully!');
redirect('user');
}
}
$id = $user_id;
if ($id == '') {
redirect('user');
}
$data = sql::row("scic_user", "id={$id}");
$this->session->set_userdata('edit_user_id', $data['id']);
//Don't Change
$data['nav_array'] = array(array('title' => 'Manage Users', 'url' => site_url('user')), array('title' => 'Add New User', 'url' => ''));
$data['dir'] = 'user';
$data['action'] = 'user/edit_user/' . $user_id;
$data['page'] = 'user_form';
//Don't Change
$data['page_title'] = 'Edit User';
$this->load->view('main', $data);
}
示例3: edit_question
function edit_question($id = '')
{
if ($_POST['save']) {
if ($this->form_validation->run('new_question')) {
if ($this->question_model->update_question()) {
//$this->session->unset_userdata('edit_qid');
$this->session->set_flashdata('msg', 'Question Updated Successfully!!!');
redirect('question');
}
}
}
$this->session->set_userdata('edit_qid', $id);
$data = sql::row('scic_question', 'id=' . $id);
$multi_answer = sql::row('scic_multi_ans', 'qid=' . $id);
$answer = sql::row('scic_answer', 'ans_number=' . $id, 'answer');
$data['answer'] = $answer;
$data['multi_answer'] = $multi_answer;
$data['msg'] = $this->session->flashdata('msg');
$data['action'] = 'question/edit_question';
$data['dir'] = 'shorturl';
$data['page'] = 'add_url';
$data['page_title'] = 'Edit Questions';
$this->load->view('main', $data);
}
示例4: sendEmail
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!";
}
}
示例5: submit_third_part
function submit_third_part()
{
$data['msg'] = "";
$logged_in = $this->session->userdata('logged_in');
$type = $this->session->userdata('type');
if ($logged_in && $type == 'part_iii') {
if (isset($_POST['submit_math'])) {
if ($this->answer_submission->submit_third()) {
$check = sql::row("scic_result", "user_id={$logged_in}");
if ($check['first_part'] != -1 && $check['second_part'] != -1 && $check['notification'] == 0) {
$this->answer_submission->sendEmail($logged_in);
}
$data['msg'] = "You have successfully completed the Third part question section. Please <a href='" . site_url('logout') . "'>click here</a> to continue.";
} else {
$data['msg'] = "Something Wrong.";
}
}
} else {
$data['msg'] = "Do not adopt unfair means. <a href='" . site_url('logout') . "'>click here</a> to continue.";
}
$data['title'] = 'Test Done!!';
$data['dir'] = 'general';
$data['page'] = 'success';
$this->load->view('main', $data);
}
示例6: edit_url
function edit_url($id = '')
{
if ($_POST['save']) {
if ($this->form_validation->run('add_url')) {
if ($this->shorturl_model->update_url($id)) {
$this->session->set_flashdata('msg', 'Url Updated Successfully!!!');
redirect('shorturl');
}
}
}
$data = sql::row('urls', 'id=' . $id);
$data['msg'] = $this->session->flashdata('msg');
$data['dir'] = 'shorturl';
$data['page'] = 'edit_url';
$this->load->view('main', $data);
}
示例7: delete_question
function delete_question($id = '')
{
$ty = sql::row('scic_multi_ans', 'qid=' . $id);
if ($ty != null) {
$sql = "delete from scic_multi_ans where qid=" . $id;
$this->db->query($sql);
}
$sql = "delete from scic_question where id=" . $id;
$this->db->query($sql);
$sql = "delete from scic_answer where ans_number=" . $id;
return $this->db->query($sql);
}
示例8: evaluate_third
function evaluate_third($user_id = '')
{
if (!common::update_permit()) {
common::redirect();
}
$id = $user_id;
if ($_POST['save']) {
if ($this->form_validation->run('valid_third')) {
$this->mod_result->update_third_marks($id);
//Don't Change
$this->session->set_flashdata('msg', 'Third Part Evaluated Successfully!');
$check = sql::row("scic_result", "user_id={$id}");
if ($check['general'] != -1 && $check['third_part'] != -1 && $check['notification'] == 0) {
$this->mod_result->sendEmail($id);
}
redirect('result');
}
}
if ($id == '') {
redirect('result');
}
$data = sql::row("scic_result", "user_id={$id}");
//$this->session->set_userdata('edit_user_id', $data['id']); //Don't Change
$data['nav_array'] = array(array('title' => 'Manage Results', 'url' => site_url('result')), array('title' => 'Evaluate Third Part', 'url' => ''));
$data['question'] = $this->mod_result->get_third();
$data['answer'] = $this->mod_result->get_third_answer($id);
$data['dir'] = 'result';
$data['action'] = 'result/evaluate_third/' . $user_id;
$data['page'] = 'third_form';
//Don't Change
$data['page_title'] = 'Evaluation';
$this->load->view('main', $data);
}