Posted By

rickygri on 10/10/12

Tagged

mysql
php

Versions (?)

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

Statistics

Viewed 1120 times

Favorited by 0 user(s)

Related snippets

PDO Insert array function

/ Published in: PHP

PDO-format insert array function

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

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[] = "[email protected]";
    $values[] = $date;
 
 
    if($db->insert('users', $fields, $values)) {
        echo "Success";
    } else {
        echo "Fail";
    }