EllisLab Community Forums

Multiple search criteria

2013-06-18T03:34:38-05:00

I am currently working on generating reports on the application I am developing. In my report (search form), there are several criterias (document_type, source_type, source, status and datetime). In my model, I am checking if the post variables from the form are empty before doing a query. My problem is, what if a user did not select a document_type or he only filled up 1 or 2 or 3 or 4 criteria? How can I make the search query? Thanks in advance.

MODEL:

$document_type = $this->input->post('specific_document_type');
$source_type   = $this->input->post('specific_source_type');
$source        = $this->input->post('specific_source');
$status        = $this->input->post('specific_status');
$date          = date('Y-m-d', strtotime($this->input->post('specific_date')));

if (!empty($document_type) && !empty($source_type) && !empty($source) && !empty($status) && !empty($date))
{
 $query = $this
   ->db
   ->select("reference_number, transaction_type, document_type, source_type, source_name, source_location, subject_matter, status")
   ->select("DATE_FORMAT(datetime, '%m/%d/%Y-%h:%i %p') as datetime_added", FALSE)
   ->like('document_type', $document_type)
   ->like('source_type', $source_type)
   ->like('source_location', $source)
   ->like('status', $status)
   ->like('DATE(datetime)', $date)
   ->order_by('document_id', 'desc')
   ->get('documents');
 return $query->result_array();
} 

User confirmation link email issue

2013-06-18T01:21:41-05:00

Hi i’m developing a web system which users can register.When user registers the confirmation link sends to his/her email address.Then user should click the link to confirm his registration.I’m using google smtp to send the email.It’s working properly.The problem is when i click the link it’s not marks the user as activated.This is my model and controller.

Index Controller

$email=$_POST['email'];
      
      $this->load->library('email',$config);
      $this->email->set_newline("\r\n");
      $this->email->from('myemail', 'Email Name');
      
      
      $this->email->to($email);
      $this->email->subject('Email subject');
      
      
      $this->email->message('Click the link below to activate your account' . anchor('http://localhost/mySite/index.php/Index/account_activation'.$activationCode,'Confirmation Register'));
                        
      
      if($this->email->send())
          {
        echo 'OK';
       }
       
      else
       {
        show_error($this->email->print_debugger());
       } 

Model

function confirm_registration($register_code){
 
   $val_code = "SELECT email FROM `users` WHERE hash='?'";
   $result = $this->db->query($val_code, $register_code);
  
   if ($result->num_rows() == 1) {
  
    $update_activated = "UPDATE `users` SET is_activated = 1 WHERE hash = ?";
    
  
    $this->db->query($update_activated, $register_code);
  
    return TRUE;
   }
   else {
    return FALSE;
   }
 } 

Why is not working?I checked it manually by running the SQL query.Then it works.Please help!

database connection

2013-06-18T12:05:43-05:00

I am getting the error not able to select database : database_name. But the problem is that this error is coming at random times, sometimes it works and other times it throws this error.

Empty POST Information

2013-06-17T15:44:37-05:00

Hi everybody,

For whatever reason, $_POST and $this->input->post(‘my_var’); are all empty in my CodeIgniter application whenever submitting a POST request.

I wrote a test script outside of CodeIgniter (below) to ensure that it wasn’t improper server/PHP configuration. The script below worked. I am running other non-CI apps on the web server and they are having no $_POST issues.

<?php

if (isset($_POST['do_post']))
{
 echo 'submit button was clicked';
}

?>

<form action="post_test.php" method="post">
 <input type="hidden" name="do_post" value="1">
 <input type="submit" name="submit_button" value="Submit Post Request">
</form> 

Within my CI script, I’ve put:

//var_dump($_POST);
  //var_dump($this->input->post());
  //echo file_get_contents("php://input"); 

inside the app. $_POST is empty and $this->input->post() returns FALSE, but php://input returns the POST’ed information.

Any ideas of what might be causing this? Thanks in advanced. I’m stumped.

{“status”:false,“error”:“Unknown method.”} Rest client

2013-06-18T13:14:19-05:00

The GET functions works but the POST function gives me the following error:

{“status”:false,“error”:“Unknown method.”}

Any idea what it could be. Im calling the post function like this:

$this->rest->post($url, $params2);

Uploading .ISO files

2013-06-17T12:28:57-05:00

I have an uploadloader form working with the upload library. All is working except I can’t get .iso files to upload.

I keep getting ‘The filetype you are attempting to upload is not allowed.’

I updated the mimes.php file to include

$mimes = array( 'hqx' => 'application/mac-binhex40',
       'iso' =>  array('application/iso-image','application/octet-stream'),
    'cpt' => 'application/mac-compactpro', ... 

But I still get the same error. It is not a file size issue, if I compress the iso into a .zip wrapper the file uploads with no issues.

Thanks in advance.

Chris

Site level settings

2013-06-15T00:31:51-05:00

Hi,

We are doing ecom based. So we need to setup the few configurations like display the product per page, search settings (on/ off), country & currency settings. How to do that?

Thanks

Routing multilingual pages

2013-06-18T09:08:26-05:00

I haven’t been able to find a similar situation in previous threads. I’m having trouble setting up my routes correctly. Basically what I need is, regardless of the language key entered I want my uri to be routed to what’s on the right hand side. If I just do this it works fine:


$route['en/quote/quote-response'] = 'quote/process_form/quote-response';

I need something like this but it doesn’t work:

$route['(en|cz|sp)/quote/quote-response'] = 'quote/process_form/quote-response'; 

I’m aware this is something simple, the answer might just be a missing symbol at the end of at the beginning? truth is I’m not so good at regex, I’ve tried different things to no avail :/

Thanks for your help.

please help - codeigniter search and pagination

2013-06-17T02:31:14-05:00

hi,
please help me with this problem
i have one one table connected with database,

i want to add feature pagination and select in that database but already try and error

my code is like this :

app/ VIEWS

<div id="data">  
    <div id="loading" ></div>    
                <table border="0" width="100%" cellspacing="0" class="table table-bordered">
                <tr>
     <th><center>No</center></th>
                    <th><center>PO_NO</center></th>
                    <th><center>Start_Date</center></th>
                    <th><center>New_Project_ID</center></th> 
                    <th><center>Activity_ID</center></th>                    
                    <th colspan="2"><center>Aksi</center></th>
                </tr>
                <?php 
    $i=1;
    foreach($data as $baris){?>
                <tr>
                    <td><?php echo $i ?></td>
                    <td><?php echo $baris->PO_NO ?></td>
                    <td><?php echo $baris->Start_Date ?></td>
                    <td><?php echo $baris->New_Project_ID ?></td>
                    <td><center><?php echo $baris->Activity_ID ?><center></td>                   
                    <td width="80"><center><a class="btn btn-small" href="#"><i class="icon-pencil"></i> EDIT</a></center></td>
                    <td width="80"><center><a class="btn btn-small" href="#"><i class="icon-trash"></i> HAPUS</a></center></td>
                </tr>
                <?php
    $i++;
    }?>
                </table>
    <?php echo $this->pagination->create_links(); ?>
            </div> 

app/controllers

function __construct(){
        parent::__construct();
    //    $this->load->model('modeldata');
    }
    
    function index(){
        $data['judul'] = 'Data PO';
       //  $data['data'] = $this->modeldata->getDatadata();
    
  
  //add
  
  $this->load->library('pagination');
  $this->load->library('table');
  
  $config['base_url'] = 'http://localhost/cig/index.php/site/index';
  $config['total_rows'] = $this->db->get('po_data')->num_rows();
  $config['per_page'] = 10;
  $config['num_links'] = 20;
  $config['full_tag_open'] = '<div id="pagination">';
  $config['full_tag_close'] = '</div>';
  
  $this->pagination->initialize($config);
  
  $data['data'] = $this->db->get('po_data', $config['per_page'], $this->uri->segment(3));
  //add
   $this->load->view('v_data',$data); 

and got error like this

http://i41.tinypic.com/2r78pdz.png

before i try to add pagination and search the page like this
http://i39.tinypic.com/i5n8n7.png

can someone help me with this

cant’ load assets

2013-06-18T07:16:11-05:00

Hi there,

I inherited a web site and after downloading it and placing it in the dev environment I can’t see the css and javascript loaded.

I’ve checked on firebug and in the href for the css tag I’ve got something like “/assets/css…”.

It does work if I remove the “/” from the beginning in the config file.

I’ve never worked with codeigniter before, so I think I’m missing something here, but it’s probably very basic.

Thanks for any help.

Marcello