Select data from MySQL using Hebrew character in where clause.
In Codeigniter I have done using these code, apply these code.
Example code:
<?php $uri_segment=urldecode($hebrew_character); $my_query=$this->db->query("SELECT * FROM table_name WHERE text_slug='".$hebrew_character."'"); $sec_data=$my_query->result_array(); print_r($sec_data); ?>
If you want to display you SQL query the set this code below of yout select query.
<?php print_r($this->db->last_query()); ?>
Output: SELECT * FROM tbl_tours WHERE tour_slug=’שלום’
I hope it will be helpful for you. If you have any query then ask here fast.
Question and answer is powered by AnsPress.io