PHP All POST Vars to MySql

// PHP All POST Vars to MySql
// Paul Radich [email protected]
 
// Dependencies : mysql.class.php http://www.phpclasses.org/package/3698-PHP-MySQL-database-access-wrapper.html
 
//Include DB Class
include("mysql.class.php");
 
 
//Global Vars
$db = new MySQL();
$vars = array();
$tableName = "";
$keys = "";
$vals = "";
 
 
//Build Query Vals from Post Vals
foreach ($_POST as $key => $value) {
	if($key != "submit"){
		if (strlen($keys) == 0) {$keys =  $key;} else { $keys .= ", " . $key ;}
		if (strlen($vals) == 0) {$vals = "'" . mysql_real_escape_string($value) . "'"; } else {$vals .= ", '" . mysql_real_escape_string($value) . "'";}
	}
}
 
 
//Exacute Query
$db->Query("INSERT INTO " . $tableName . " (".$keys.") Values (" . $vals.")");