Posted By

rickygri on 10/10/12

Tagged

mysql
php

Versions (?)

Last Edited at 10/10/12 10:33pm

Statistics

Viewed 938 times

Favorited by 0 user(s)

Related snippets

PDO Insert array function

/ Published in: PHP

PDO-format insert array function

Highlighted TextExpand

public function insert($table,$fields,$values) {

$db = $this->db_connect; // CONNECT

//build the fields
        $buildFields = '';
        if (is_array($fields)) {
            //loop through all the fields
            foreach($fields as $key => $field) {
                if ($key == 0) {
                    //first item
                    $buildFields .= $field;
                } else {
                    //every other item follows with a ","
                    $buildFields .= ', '.$field;
                }   
            }
        } else {
            //we are only inserting one field
            $buildFields .= $fields;
        }

//build the values
        $buildValues = '';
        if (is_array($values)) {
            //loop through all the fields
            foreach($values as $key => $value) {
                if ($key == 0) {
                    //first item
                    $buildValues .= '?';
                } else {
                    //every other item follows with a ","
                    $buildValues .= ', ?';
                }   
            }
        } else {
        //we are only inserting one field
            $buildValues .= ':value';
        }

$prepareInsert = $db->prepare('INSERT INTO '.$table.'('.$buildFields.') VALUES ('.$buildValues.')');

//execute the update for one or many values
        if (is_array($values)) {
            $prepareInsert->execute($values);
        } else {
            $prepareInsert->execute(array(':value' => $values));
        }
        //record and print any DB error that may be given
        $error = $prepareInsert->errorInfo();
        if ($error[1]) {
            print_r($error);
        } else {
            return true;
        }

}

// Use like this ->

// Change the line below to your timezone!
    date_default_timezone_set('Europe/London');
    $date = date('d-m-Y h:i:s a', time());

//inserting multiple items
    $fields[] = 'forename';
    $fields[] = 'surname';
    $fields[] = 'email';
    $fields[] = 'timestamp';

$values[] = "Rick";
    $values[] = "Grimaldi";
    $values[] = "rickygri@gmail.com";
    $values[] = $date;

if($db->insert('users', $fields, $values)) {
        echo "Success";
    } else {
        echo "Fail";
    }

URL: http://digipiph.com/blog/insert-mysql-pdo-function

Report this snippet Tweet

Comments

Subscribe to comments

Comment:

You need to login to post a comment.