PDO bindParam into one statement?

by

Example 2 on the execute page is what you want:

$sth->execute(array(':calories' => $calories, ':colour' => $colour));

You may want to look at the other examples too. With question mark parameters, it would be:

$q = $dbc -> prepare("INSERT INTO accounts (username, email, password) VALUES (?, ?, ?)");
$q->execute(array($_POST['username'], $_POST['email'], $_POST['password']));

If those are the only columns, you can just write:

$q = $dbc -> prepare("INSERT INTO accounts VALUES (?, ?, ?)");
$q->execute(array($_POST['username'], $_POST['email'], $_POST['password']));

More Related Contents:

  1. Insert form in MySQL with PDO [duplicate]
  2. Undefined index $_POST
  3. How to check if a row exists in MySQL? (i.e. check if username or email exists in MySQL)
  4. Getting raw SQL query string from PDO prepared statements
  5. How do I use password hashing with PDO to make my code more secure? [closed]
  6. How do I set ORDER BY params using prepared PDO statement?
  7. “Invalid parameter number: parameter was not defined” Inserting data
  8. Having issue with matching rows in the database using PDO
  9. How can I properly use a PDO object for a parameterized SELECT query
  10. How do I return integer and numeric columns from MySQL as integers and numerics in PHP?
  11. PDO with INSERT INTO through prepared statements [closed]
  12. PDO::fetchAll vs. PDO::fetch in a loop
  13. PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
  14. Real escape string and PDO [duplicate]
  15. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  16. PDO Connection Test
  17. PHP PDO vs normal mysql_connect
  18. Can I create a database using PDO in PHP?
  19. PHP PDO and MySQLi [duplicate]
  20. PDO fetch one column from table into 1-dimensional array
  21. Getting a PHP PDO connection from a mysql_connect()?
  22. PDO error: SQLSTATE[HY000]: General error: 2031
  23. Having issue with matching rows in the database
  24. Use of PDO in classes [duplicate]
  25. Check if row exists in the database before inserting
  26. PHP/PDO/MySQL: inserting into MEDIUMBLOB stores bad data
  27. PHP/SQL Insert Error when using Named Placeholders
  28. How to escape single-quote (apostrophe) in string using php
  29. php, mysql – Too many connections to database error
  30. PDO and MySQL ‘between’

Leave a Comment