Im trying to figure out how to run an sql query via a url with a string appended to it like this:
domain.com/collection.php?keyword=chicken%garlic
That would display a listing of recipes where the ingredients specifically contained both chicken
and garlic.
This is what I have in my regular SQL statement in the coding, how would I make it so that the URL controls the SQL query itself?
Quote:
$con=mysqli_connect("localhost","user","pass","dat abase");
$result = mysqli_query($con,"SELECT * FROM Recipe WHERE Ingredient REGEXP '(?=.*chicken)(?=.*garlic)' ORDER BY RAND() LIMIT 10;");
|
Is this even possible without significantly changing what I already use for the pages SQL query?
The end goal is to be able to randomly list a bunch of specific recipes from the database in their own page, kind of like how sites like TasteofHome and BHG do for their visitors as a 'recipe collection' article.
So in this instance, that url when clicked would display some filler content, with a dynamically generated listing of 10 (or however many I choose) random recipes that contain both chicken and garlic in their ingredients.
As I undertand it, I'll need to put an escape string in the page somewhere to(?)
Any help/pointers would be greatly appreciated.