PHP insert ‘ into SQL [duplicate]

by

Instead of trying to escape the apostrophe, it is much better practice to use prepared statements and binded parameters which will also solve your problem. It solves your problem because you then don’t need to escape the apostrophe (‘):

$type_of_poker = "hold'em no limit";

//binding the parameters to your sql statement
$sql = "INSERT INTO hands (type_of_poker) VALUES (:type_of_poker)";
$stmt = $conn->prepare($sql);
$stmt->bindParam(':type_of_poker',$type_of_poker);
$stmt->execute();

Let me know if that worked for you! 🙂

More Related Contents:

  1. How to create this type of JSON data from PHP [closed]
  2. how to write php code for the key press enter button when fill the form?
  3. for loop is not executed /getting error like loop is not working
  4. Organization db for blog posts with Mysql and Php [closed]
  5. PHP – Change value y,n in database [closed]
  6. I can’t view the database content on a php page [closed]
  7. mysqli or PDO – what are the pros and cons? [closed]
  8. mysqli_stmt::bind_result(): Number of bind variables doesn’t match number of fields in prepared statement
  9. How to resolve ambiguous column names when retrieving results?
  10. mysqli::mysqli(): (HY000/2002): Can’t connect to local MySQL server through socket ‘MySQL’ (2)
  11. Maximum execution time in phpMyadmin
  12. PHP PDO – Num Rows
  13. Post and get at the same time in php
  14. MySQL – Access denied for user [duplicate]
  15. Calling stored procedure with Out parameter using PDO
  16. Setting up Laravel on a Mac php artisan migrate error: No such file or directory [duplicate]
  17. How to display an BLOB image stored in MySql database?
  18. What is the best way to insert multiple rows in PHP PDO MYSQL?
  19. How to bind LIKE values using the PDO extension?
  20. How do I set the selected item in a drop down box
  21. Fatal error: Call to undefined function mysqli_result()
  22. access denied for user @ ‘localhost’ to database ” [closed]
  23. Warning: PDO::__construct(): [2002] No such file or directory (trying to connect via unix:///tmp/mysql.sock) in
  24. WordPress Fatal error: Uncaught Error: Call to undefined function mysql_connect() in /wp-includes/wp-db.php:1570
  25. How can I employ “if exists” for creating or dropping an index in MySQL?
  26. PHP MySQL pagination with random ordering
  27. How does {} affect a MySQL Query in PHP? [duplicate]
  28. When should I close a database connection in PHP?
  29. php connection pooling mysql [duplicate]
  30. Limit pagination page number

Leave a Comment