Just using mysql real escape string [closed]

by

it is not working … the strings like />., still can be enter in the sql database

It is working.

mysql_real_escape_string is a function that escapes characters which have special meaning in SQL.

/ and > do not have special meaning in SQL, so it shouldn’t touch them.

If they did have special meaning, then the point of the function is to allow them to be inserted into the database. It makes changes such as converting ' (meaning “Start or end an SQL string”) to \' (meaning “An apostrophe”).

More Related Contents:

  1. Unable to insert data in MySQL database [duplicate]
  2. How chnage image size before uploaded on server [closed]
  3. PHP PDO: charset, set names?
  4. Undefined function mysql_connect()
  5. “Connect failed: Access denied for user ‘root’@’localhost’ (using password: YES)” from php function [duplicate]
  6. mysqli::mysqli(): (HY000/2002): Can’t connect to local MySQL server through socket ‘MySQL’ (2)
  7. How to retract a salted password from the Database and auth user?
  8. What is the difference between MySQL, MySQLi and PDO? [closed]
  9. Fatal error: [] operator not supported for strings
  10. Fetching data from MySQL database to HTML dropdown list
  11. Can I use a PDO prepared statement to bind an identifier (a table or field name) or a syntax keyword?
  12. Post and get at the same time in php
  13. How to solve General error: 2006 MySQL server has gone away
  14. ini_set, set_time_limit, (max_execution_time) – not working
  15. Find Point in polygon PHP
  16. unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING error [duplicate]
  17. Setting a connect timeout with PDO
  18. How to build a JSON array from mysql database
  19. What is the best way to insert multiple rows in PHP PDO MYSQL?
  20. How to display a date as iso 8601 format with PHP
  21. How to generate unique id in MySQL?
  22. Fatal error: Call to undefined method mysqli_stmt::fetch_array() [duplicate]
  23. adding 30 minutes to datetime php/mysql
  24. Remotely connecting to a MySQL database
  25. Create table with PHP and populate from MySQL
  26. Cannot figure out how to run a mysqli_multi_query and use the results from the last query
  27. PHP add up two time variables
  28. SQLSTATE[HY000] [1698] Access denied for user ‘root’@’localhost’
  29. Which MySQL datatype to use for an IP address? [duplicate]
  30. phpmysql error – #1273 – #1273 – Unknown collation: ‘utf8mb4_general_ci’

Leave a Comment