PHP – GetSQLValueString function

by

Your function escapes the string using MySQL’s built-in string escaping function, then if it is a non-numeric value, surrounding it in single quotes. This function was written for inserting variable data into SQL queries.

$sql = "SELECT * FROM users WHERE username = " . GetSQLValueString($_GET['username'], 'text');
$result = mysql_query($sql);

More Related Contents:

  1. How to remove array index from json object while convert array to jsonobject php? [closed]
  2. when upload zip folder validate that only .jpg,.png files will save inside zip folder +php [closed]
  3. Search engine PHP return error [closed]
  4. How to include a PHP variable inside a MySQL statement
  5. Use global variables in a class
  6. difference between two arrays
  7. Warning: mysqli_connect(): (HY000/1045): Access denied for user ‘username’@’localhost’ (using password: YES)
  8. Why is PHP printing my number in scientific notation, when I specified it as .000021?
  9. Build SELECT query with dynamic number of LIKE conditions as a mysqli prepared statement
  10. How can I write SQL for a table that shares the same name as a protected keyword in MySql? [duplicate]
  11. Detect language from string in PHP
  12. Does PHP have short-circuit evaluation?
  13. Session lost when switching from HTTP to HTTPS in PHP
  14. Remove style attribute from HTML tags
  15. Truncate text containing HTML, ignoring tags
  16. Match a^n b^n c^n (e.g. “aaabbbccc”) using regular expressions (PCRE)
  17. How to delete a file via PHP?
  18. How to create a PSR-4 autoloader for my project?
  19. Convert JPG/GIF image to PNG in PHP?
  20. How to decode eval( gzinflate( base64_decode(
  21. Send XML data to webservice using php curl
  22. Retrieve (or simulate) full query from PDO prepared statement
  23. Array_merge versus + [duplicate]
  24. How to get whole and decimal part of a number?
  25. Error handling in PHP
  26. How to set current page “active” in php
  27. Get number of rows matched by UPDATE query with PHP mysqli
  28. Sort by date (newest)
  29. CakePHP switch database (using same datasource) on the fly?
  30. Escape HTML to PHP or Use Echo? Which is better?

Leave a Comment