Call to undefined method PDO::execute()

by

->execute() is for prepared statements. e.g.

$stmt = $dbh->prepare('some query here');
$stmt->execute();

You’re trying to execute a query directly on the main DB object. For PDO, that means

 $dbh->exec('query goes here');

You really should look into prepared statements. You’re vulnerable to SQL injection attacks as is, and since you’re using PDO to begin with, it’s basically unforgivable to NOT be writing safe queries.

More Related Contents:

  1. PHP PDO and Mysql [closed]
  2. How to properly set up a PDO connection
  3. PHP PDO prepared statements
  4. PDO MySQL: Use PDO::ATTR_EMULATE_PREPARES or not?
  5. PDO Prepared Inserts multiple rows in single query
  6. Why I am getting Cannot pass parameter 2 by reference error when I am using bindParam with a constant value?
  7. mysql PDO how to bind LIKE
  8. Connect PHP to MSSQL via PDO ODBC
  9. PDO closing connection
  10. How to get the total number of rows of a GROUP BY query?
  11. How do I use pdo’s prepared statement for order by and limit clauses?
  12. What is PDO & why should I use it?
  13. How to install pdo driver in php docker image?
  14. MySQL retrieve variable from Stored Procedure in PHP PDO
  15. Understanding pdo mysql transactions
  16. Call to a member function fetch() on boolean [duplicate]
  17. How to prevent PDO from interpreting a question mark as a placeholder?
  18. PHP PDO returning single row
  19. Laravel 5.4 on PHP 7.0: PDO Exception – Could not find driver (MySQL)
  20. Using LIKE in bindParam for a MySQL PDO Query [duplicate]
  21. How to handle PDO exceptions [duplicate]
  22. php artisan migrate throwing [PDO Exception] Could not find driver – Using Laravel
  23. Get Last Executed Query in PHP PDO
  24. PDO and MySQL Fulltext searches
  25. PHP Laravel: No connection could be made because the target machine actively refused it
  26. PDO Unbuffered queries
  27. escaping column name with PDO
  28. What is the PDO equivalent of function mysql_real_escape_string?
  29. Installing PDO driver on MySQL Linux server
  30. PDO Exception Questions – How to Catch Them

Leave a Comment