Posted By

BergBenji on 10/22/12

Tagged

mysql
php

Versions (?)

Last Edited at 10/22/12 09:28pm

Statistics

Viewed 718 times

Favorited by 0 user(s)

Related snippets

Simple PDO Insert method

/ Published in: PHP

Simple method to insert data to sql

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

// Build the field:value array
$in = array();
$in['fieldname'] = 'Value';
$in['fieldname2'] = 'Value 2';
 
// Insert into db
$db->insert('tablename', $in);
 
// Method:
public function insert($table, $data)
    {
	ksort($data);
	$fieldnames = '`'.implode('`, `', array_keys($data)).'`';
	$fieldvalues = ':'.implode(', :', array_keys($data));
 
	$SQL = "INSERT INTO `{$table}` ({$fieldnames}) VALUES ({$fieldvalues})";
	$sth = $this->prepare($SQL);
	return $sth->execute($data);
    }