Mysql Custom Select

I use below query:

$query = $this->db->query('select * from class_routine where semester='$semester' and day='$day' and time_schedule='$time_schedule' and (batch='$batch_no' or section='$section' or teacher='$teacher' or room='$room');');

And I get this error:

Parse error: syntax error, unexpected '$semester' (T_VARIABLE) in C:\xampp\htdocs\crm\application\models\m_class_routine.php on line 9

Hi Nahid.tct,

Either of the following should work. In your query string you are failing to join the string data with the full stop (period) character.

PHP Code:

$query = $this->db->query('select * from class_routine where semester='.$semester.' and day='.$day.' and time_schedule='.$time_schedule.' and (batch='.$batch_no.' or section='.$section.' or teacher='.$teacher.' or room='.$room.');'); 


or

PHP Code:

$query = $this->db->query("select * from class_routine where semester='$semester' and day='$day' and time_schedule='$time_schedule' and (batch='$batch_no' or section='$section' or teacher='$teacher' or room='$room');"); 


Hope this helps  

You may wish to take a look at the query builder class: CI2 | CI3. Whilst your method would work it's always nice to learn a new method, eh? and it may help simplify your future database queries

Jamie Bond
Full time International Development undergraduate.
Part time website developer.