how to call json with and without data [on hold]

20
January 13, 2019, at 04:40 AM

i tried to make a json from php and want it can be get with data like http://localhost/moviereview/?action=get_review&genre=biography and or without data like http://localhost/moviereview/?action=get_review

this is the code that i tried

 $query = mysqli_query($connection, 'SELECT user_review.*, data_movie.* FROM data_movie INNER JOIN user_review ON data_movie.id = user_review.id_movie WHERE genre = "'. $genre .'" order by created_at desc')
  or mysqli_query($connection, 'SELECT user_review.*, data_movie.* FROM data_movie INNER JOIN user_review ON data_movie.id = user_review.id_movie order by created_at desc')
  or die(mysqli_error($connection));

but it doesn't work. please help

READ ALSO
Image from database is not appearing on the .jsp page [on hold]

Image from database is not appearing on the .jsp page [on hold]

The screenshot below shows my web page that is not showing the imageCan someone see why that might be

15
convert the url & hashtag into link

convert the url & hashtag into link

In my code I have #hashtag standing but also Iframe + URL but It shows only the hashtag further it does not show the Iframe + URL

12