$hostname = "mysql.ece.cmu.edu";
$database = "travmgmt";
$username = "textrav";
$password = "tExt44v";
$news = mysql_pconnect($hostname, $username, $password) or die(mysql_error());
mysql_select_db($database) or die(mysql_error());
echo $form_data." is the value
";
unset ($form_data["Submit"]);
$query = "INSERT INTO ";
$column = "`upload-test` (";
$data = "VALUES (";
foreach ($form_data as $key => $value ) {
$column .= "`$key`, ";
$data .= "'$value', ";
echo $column.$data."
";
}
$column = rtrim($column, ", ");
$data = rtrim($data, ", ");
$query = $query . $column . ") " . $data . ");";
echo $query."
";
mysql_query($query);
mysql_close($news);
?>