Binding multiple values in pdo

by

You can always bind values within the arguments of execute() as long as you’re fine with the values being treated as PDO::PARAM_STR (string).

$result_set = $pdo->prepare("INSERT INTO `users` (`username`, `password`, `first_name`, `last_name`) VALUES (:username, :password, :first_name, :last_name)");
$result_set->execute(array(
    ':username' => '~user',
    ':password' => '~pass',
    ':first_name' => '~John',
    ':last_name' => '~Doe'
));

You can use the array passed just like any array:

$user = "Nile";
$pdo->execute(array(":user" => $user));

More Related Contents:

  1. PHP PDO and Mysql [closed]
  2. How to properly set up a PDO connection
  3. PDO MySQL: Use PDO::ATTR_EMULATE_PREPARES or not?
  4. PDO Prepared Inserts multiple rows in single query
  5. Why I am getting Cannot pass parameter 2 by reference error when I am using bindParam with a constant value?
  6. PDO with “WHERE… IN” queries [duplicate]
  7. implement LIKE query in PDO
  8. PHP PDO prepared statement — MySQL LIKE query
  9. Unable to retrieve UTF-8 accented characters from Access via PDO_ODBC
  10. How to connect to mssql using pdo through PHP and Linux?
  11. How do I loop through a MySQL query via PDO in PHP?
  12. Binding params for PDO statement inside a loop
  13. PDO fetchAll array to one dimensional
  14. PDO try-catch usage in functions
  15. How do I enable php to work with postgresql?
  16. How to prevent PDO from interpreting a question mark as a placeholder?
  17. PHP PDO returning single row
  18. Laravel 5.4 on PHP 7.0: PDO Exception – Could not find driver (MySQL)
  19. Using LIKE in bindParam for a MySQL PDO Query [duplicate]
  20. How to handle PDO exceptions [duplicate]
  21. php artisan migrate throwing [PDO Exception] Could not find driver – Using Laravel
  22. Get Last Executed Query in PHP PDO
  23. PDO and MySQL Fulltext searches
  24. PHP Laravel: No connection could be made because the target machine actively refused it
  25. PDO bindParam into one statement?
  26. PDO Unbuffered queries
  27. prepared parameterized query 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