Argthtjtr

Database StructureI am trying raw query in an controller(Codeigniter) and i am trying to get the values from the range provided by the user on newDate and newDate2..My problem is it displays nothing..How do i write the query for this..I just want to display the qty,productname,bundle according to the voucherno(vno)...Here is my tried code

Controller Code:

$startdate         = $this->input->post('SDate');

$enddate           = $this->input->post('EDate');

$date              = str_replace('/', '-', $startdate);

$newDate           = date("Y-m-d", strtotime($date));

$date2             = str_replace('/', '-', $enddate);

$newDate2          = date("Y-m-d", strtotime($date2));

$data['startdate'] = $startdate;

$data['enddate']   = $enddate;

$query             = $this->db->query('SELECT `vno`,`Prdtname`,`Qty`,`bundle` FROM purchaseitem WHERE billdate >= "$newDate"AND billdate <= "$newDate2" ORDER by `vno`')->result_array();

$data['query']     = $query;

View Code:

<?php foreach ($query as $row): ?>

                                            <tr><td></td><td></td><td></td><td></td>

                                        <td><?=$row['Prdtname'];?></td>

                                        <td><?=$row['Qty'];?></td>

                                        <td><?=$row['bundle'];?></td>



                                        <?php endforeach ?> 

Change your query to below query and check.

You have to pass date in single or doube quote.

$query = $this->db->query('SELECT `vno`,`Prdtname`,`Qty`,`bundle` FROM purchaseitem WHERE billdate >= "'.$newDate.'" AND billdate <= "'.$newDate2.'" ORDER by `vno`')->result_array();

Let me know if still having issue.

You can use Between

SELECT `vno`,`Prdtname`,`Qty`,`bundle` FROM purchaseitem WHERE billdate BETWEEN "$newDate" AND "$newDate2" ORDER by `vno`

If you store the date only, I would try to use unix timestamp.

$snewsDate = strtotimr($startdate);

$newDate2 = strtotime($enddate);



SELECT `vno`,`Prdtname`,`Qty`,`bundle` FROM purchaseitem WHERE billdate BETWEEN 

UNIX_TIMESTAMP($newDate) AND UNIX_TIMESTAMP($newDate2) ORDER by `vno

Try this one:

$startdate         = $this->input->post('SDate');

$enddate           = $this->input->post('EDate');

$newDate           = date_format(date_create($startdate),"Y-m-d");

$newDate2          = date_format(date_create($enddate),"Y-m-d");

$data['startdate'] = $startdate;

$data['enddate']   = $enddate;

$query             = $this->db->query("SELECT vno,Prdtname,Qty,bundle FROM purchaseitem WHERE billdate BETWEEN '$newDate' AND '$newDate2' ORDER by vno")->result_array();

$data['query']     = $query;