// 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);
    }

Simple method to insert data to sql

Simple PDO Insert method

mysql, php

PHP