why using strips in the url database Mysql php cannot be read

Question

I have a problem calling the database in the URL with MYSQL, where I call the url post

/post/**how-to-noodle-with-egg**

why does the database call an error with a strip at the URL?

if me display in page use

$_GET['title'];

why only get "how"? why not get full url? so page post me not found data because only get "how" not full text with strip

My code :

$a = $_GET['title'];

"SELECT * FROM `post` WHERE title = '$a";

in my database title : how-to-noodle-with-egg ( use strip )

maybe someone here can help my problem

@MohitKumar, only the posts I call are not all, before I use ID to call data. now I try to call data using the title. — Aing Macan, Jul 21 '19 at 17:52
You want this http://localhost/index.php?a=how-to-noodle-with-egg — Mohit Kumar, Jul 21 '19 at 18:03
yes, that's the url I've used htaccess. before :localhost/test/post.php/$title=how-to-noodle-with-egg, after : localhost/test/post/how-to-noodle-with-egg. — Aing Macan, Jul 21 '19 at 18:13

score -1 · Answer 1 · answered Jul 21 '19 at 17:37

-1

Your SQL query is missing trailing ':

"SELECT * FROM post WHERE title = '$a";

Should be:

"SELECT * FROM post WHERE title = '$a'";

I'd also strongly suggest to properly escape $a to avoid SQL injections.

answered Jul 21 '19 at 17:37

5lava

oh, I forgot to add it to the question, I've tried it like that, illegible. – Aing Macan Jul 21 '19 at 17:44
So then please post a complete code so we'd be able to help you. Otherwise, we have to make blind guesses. – 5lava Jul 21 '19 at 17:47
@5lava op wants post title in url ,with respective id from databases? – Mohit Kumar Jul 21 '19 at 17:50
Well, if the problem is why `how-to-noodle-with-egg` was stripped down to just `how` (i.e. `$_GET['title'] == 'how'`) then op should look into webserver configuration. Specifically, how URL is parsed and turned into `$_GET` parameters. – 5lava Jul 21 '19 at 18:03
$ a = $ _GET ['title']; ("SELECT * FROM post WHERE title = '$a'"); – Aing Macan Jul 21 '19 at 18:03
@AingMacan Can you do `var_dump($_GET);` and post the result? – 5lava Jul 21 '19 at 18:04
/post/how-to-noodle-with-egg if me call use: echo $_GET['title']; why only get "how" not full text with strip – Aing Macan Jul 21 '19 at 18:05
I will try first – Aing Macan Jul 21 '19 at 18:06

1 Answers1