Search engine PHP return error [closed]

by

On line 33 you have $i++, but you haven’t initialised $i

I expect you have a syntax error in your MySQL query. Try this:

$query1 = mysql_query($query) or die(mysql_error());

which will display the SQL error which you’ll have to fix.

More: Your SQL is susceptible to an injection attack. Make sure you escape your inputs properly, and don’t use mysql() – it”s deprecated. Use mysqli or PDO instead.

More Related Contents:

  1. Laravel – only a zero is saved to the database
  2. storing user_id in session variable
  3. MySQL Great Circle Distance (Haversine formula)
  4. How to insert multiple rows from array using CodeIgniter framework?
  5. How to store repeating dates keeping in mind Daylight Savings Time
  6. Why is mysqli giving a “Commands out of sync” error?
  7. JSON encode MySQL results
  8. PHP mysql insert date format
  9. How to store file name in database, with other info while uploading image to server using PHP?
  10. How to best store user information and user login and password
  11. Laravel: connect to databases dynamically
  12. Error while sending QUERY packet
  13. PDO fetch one column from table into 1-dimensional array
  14. PHP: Calling MySQL Stored Procedure with Both INPUT AND OUTPUT Parameters (NOT “INOUT”)
  15. Detect mysql update/insertion failure due to violated unique constraint
  16. PHP + MySql + Stored Procedures, how do I get access an “out” value?
  17. Get all mysql selected rows into an array
  18. Select from mysql table WHERE field=’$array’?
  19. How to bind SQL variables in PHP?
  20. PHP – Secure member-only pages with a login system
  21. MySQL ORDER BY IN()
  22. mysql – INSERT date range into date columns IF dates don’t overlap with existing ones
  23. php password_verify() hash and pass won’t match
  24. PHP mySQL – Insert new record into table with auto-increment on primary key
  25. Using utf8mb4 with php and mysql
  26. how do I get month from date in mysql
  27. MySQL, how to insert null dates
  28. Can I detect and handle MySQL Warnings with PHP?
  29. How to write a stored procedure in phpMyAdmin?
  30. mysql count into PHP variable

Leave a Comment