Menu
Community /Pin to ProfileBookmark
@NogDogMar 15.2019 — #Yep, a "?" is not valid SQL -- but if you use the prepare method and then bind a parameter to it and execute() it, you may be okay. @NogDogMar 15.2019 — #Tutorials can be useful for a quick, general introduction -- but you're better off using the php.net manual to really figure out how to do things. Simply mimicking what somewhat else did isn't much use if you don't understand why they did it, and potentially recognize why they might not be making the best recommendation for what you need to do.
And no, I'm not going to spend hours here typing out tutorials. I have a full-time coding job, hobbies, youtube videos to watch, sleep to catch up on, etc., etc., and so forth.
Sql Syntax Error
Folks,
What is wrong with my php mysql query ?
[code]
$total_pages = $conn->query(“SELECT * FROM browsing_histories WHERE username = ?”)->num_rows;
Fatal error: Uncaught mysqli_sql_exception: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘?’ at line 1 in C:xampphtdocstestsearch.php:31 Stack trace: #0 C:xampphtdocstestsearch.php(31): mysqli->query(‘SELECT * FROM b…’) #1 {main} thrown in C:xampphtdocstestsearch.php on line 31
If I remove the “WHERE username = ?” part and make it like the following then I get no error.
[code]
$total_pages = $conn->query(“SELECT * FROM browsing_histories WHERE username = ?”)->num_rows;
But making it like this means getting it to pull all rows from the table. I do not want that. I want to pull matching rows in the “username” column.
How to fix this ? How should it have been ?
Sign in
to post a comment14 Comments(s) ↴
0
@NogDogMar 15.2019 — #0
@NogDogMar 15.2019 — #And no, I'm not going to spend hours here typing out tutorials. I have a full-time coding job, hobbies, youtube videos to watch, sleep to catch up on, etc., etc., and so forth.