Insert/update helper function using PDO

by

I usually have a class extending PDO, but my class is pretty custom. If I get it cleaned up and tested I will post it at a later time. Here is a solution to your system, however.

function dbSet($fields, &$values) {
    $set="";
    $values = array();

    foreach ($fields as $field) {
        if (isset($_POST[$field])) {
            $set .= "`$field` = ?,";
            $values[] = $_POST[$field];
        }
    }

    return rtrim($set, ',');
}

$fields = explode(" ","name surname lastname address zip fax phone date");
$_POST['date'] = $_POST['y']."-".$_POST['m']."-"$_POST['d'];

$query  = "UPDATE $table SET ".dbSet($fields, $values).", stamp=NOW() WHERE id=?";
$values[] = $id;

$dbh->prepare($query);
$dbh->execute($values);

This may not be perfect and could use tweaking. It takes into account that $dbh is setup with a PDO Connection. Pending any minor syntax issues I made, that should work.

EDIT

Really though, I think I would go for Doctrine ORM (or another ORM). As you setup the model and add all the validation there, then it is as simple as:

$table = new Table();
$table->fromArray($_POST);
$table->save();

That should populate the contents easily. This is of course with an ORM, like Doctrine.

UPDATED

Did some minor tweaks to the first code, such as putting isset back and using rtrim over substr. Going to work on providing a mock up of a PDO Extension class just gotta layout the way to do it and do some unit tests to make sure it works.

More Related Contents:

  1. PHP PDO: charset, set names?
  2. How can I use PDO to fetch a results array in PHP?
  3. PHP PDOException: “SQLSTATE[HY093]: Invalid parameter number”
  4. Causes of MySQL error 2014 Cannot execute queries while other unbuffered queries are active
  5. Use bound parameter multiple times
  6. What is the difference between MySQL, MySQLi and PDO? [closed]
  7. how safe are PDO prepared statements
  8. Can I use a PDO prepared statement to bind an identifier (a table or field name) or a syntax keyword?
  9. PHP PDO – Num Rows
  10. How to solve General error: 2006 MySQL server has gone away
  11. How to install pdo driver in php docker image?
  12. Replacing mysql_* functions with PDO and prepared statements
  13. MySQL retrieve variable from Stored Procedure in PHP PDO
  14. Calling stored procedure with Out parameter using PDO
  15. When *not* to use prepared statements?
  16. How to insert an array into a single MySQL Prepared statement w/ PHP and PDO
  17. Setting a connect timeout with PDO
  18. What is the best way to insert multiple rows in PHP PDO MYSQL?
  19. PDO MySQL: Insert multiple rows in one query
  20. How to bind LIKE values using the PDO extension?
  21. Error while using PDO prepared statements and LIMIT in query [duplicate]
  22. PDO prepared statement fetch() returning double results
  23. Warning: PDO::__construct(): [2002] No such file or directory (trying to connect via unix:///tmp/mysql.sock) in
  24. SQLSTATE[HY093]: Invalid parameter number: parameter was not defined
  25. PHP 7 RC3: How to install missing MySQL PDO
  26. PHP Laravel: No connection could be made because the target machine actively refused it
  27. PDO bindParam into one statement?
  28. Insert value list does not match column list: 1136 Column count doesn’t match value count
  29. What is the PDO equivalent of function mysql_real_escape_string?
  30. Installing PDO driver on MySQL Linux server

Leave a Comment