Code: Select all
<?php
/**
* @return noting
* @param $table table name
* @param $fields table field names
* @param $values values
* @desc takes table name, field names and values for the fields, the number of
values must match number of fields.
*/
function insert($table, $fields, $values)
{
$into = explode(",", $fields);
$value = explode(",", $values);
if(count($value) != count($into))
{
die("<b>Mysql Error: Fields Count Mismatch!</b><br />Unable to insert record.");
}
for($x = 0; $x<=count($value); $x++)
{
$value[$x] = addslashes(trim($value[$x]));
$into[$x] = trim($into[$x]);
if(!empty($value[$x]))
{
if($x == 0)
{
$fields .= "`$into[$x]`";
$gen_query .= "'$value[$x]'";
}
else
{
$fields .= ", `$into[$x]`";
$gen_query .= ", '$value[$x]'";
}
}
}
$query = mysql_query("INSERT INTO `$table` ($fields) VALUES($gen_query)")or die("<b>Mysql Error: Invild Query!</b><br />Unable to insert record.");
}
//this is how i am useing it
$insert = $mysql->insert("useronline", "timestamp,ip,username", "$timestamp,$ip,guest");
?>thanks in adv for your help.