Database error occurred in codeigniter

Question

1519 viewsFebruary 14, 2020codeigniter

0

Atanu Chakraborty (anonymous) Posted August 23, 2018

In codeigniter 404 page not found when database error occurred. When I try to fetch data from MySQL using Hebrew character in where clause.

My code is:

1

2

3

4

5

<?php

$uri_segment=end($this->uri->segments);

$se_query=$this->db->query("SELECT * FROM tours WHERE tour_slug='".$uri_segment."'");

$sec_data=$se_query->result_array();

?>

My URL is:
http://example.com/tour-details/מופע-פלמנקו

How can I fetch data using Hebrew character in where clause, which Hebrew character get from URL.

2 Answers

Write your answer.

score 0 · Answer 1 · 2020-02-14T10:35:11+00:00

Information on the data and all programs is fit for the future implications in the Mad off the cities. The data and myassignmenthelp review are ascertained for the functions of the team. The marked opinion is held for the postures for the town. The solution is inquired for the attachment for the certain items for the mid of the posts for the feeble counts and nominations for the clients.

score 0 · Answer 2 · 2018-08-24T08:28:16+00:00

You need to use this code urldecode($uri_segment);

For example:

1

2

3

4

5

6

7

<?php

$uri_segment1=end($this->uri->segments);

$uri_segment=urldecode($uri_segment1);

//echo $uri_segment;

$raw_query=$this->db->query("SELECT * FROM tbl_tours WHERE tour_slug='".$uri_segment."'");

$sec_data=$raw_query->result_array();

?>

Output: SELECT * FROM tours WHERE tour_slug=’שלום’