$_POST
Posted: Mon Nov 10, 2008 5:08 pm
what am I doing wrong? failed to insert data into the DB...! been working on this all day! can't get it to work!
<?php
$a1=$_POST[first_name];
$a2=$_POST[last_name];
$a3=$_POST[work_phone];
$a4=$_POST[cell_phone];
$a5=$_POST[company];
$a6=$_POST[address];
$a7=$_POST[address_2];
$a8=$_POST[city];
$a9=$_POST[state];
$a10=$_POST[zip];
$a11=$_POST[email];
$a12=$_POST[payment_type];
$a13=$_POST[sem_id];
$a14=$_POST[sem_title];
$a15=$_POST[sem_month];
$a16=$_POST[sem_day];
$a17=$_POST[sem_year];
$a18=$_POST[sem_time_hr];
$a19=$_POST[sem_time_min];
$a20=$_POST[sem_time_day];
$db = mysqli_connect( "localhost" , "amp", "123456" , "amp" )
or die ("not able to connect.");
$query = "INSERT INTO attendees (
first_name,
last_name,
work_phone,
cell_phone,
company,
address_1,
address_2,
city,
state,
zip,
email,
sem_id,
sem_title,
sem_month,
sem_day,
sem_year,
sem_time_hr,
sem_time_min,
sem_time_day,
payment_type
)
VALUES (
'$a1',
'$a2',
'$a3',
'$a4',
'$a5',
'$a6',
'$a7',
'$a8',
'$a9',
'$a10',
'$a11',
'$a12',
'$a13',
'$a14',
'$a15',
'$a16',
'$a17',
'$a18',
'$a19',
'$a20'
)";
mysql_query($query) or die("Error adding data!");
?>
<?php
$a1=$_POST[first_name];
$a2=$_POST[last_name];
$a3=$_POST[work_phone];
$a4=$_POST[cell_phone];
$a5=$_POST[company];
$a6=$_POST[address];
$a7=$_POST[address_2];
$a8=$_POST[city];
$a9=$_POST[state];
$a10=$_POST[zip];
$a11=$_POST[email];
$a12=$_POST[payment_type];
$a13=$_POST[sem_id];
$a14=$_POST[sem_title];
$a15=$_POST[sem_month];
$a16=$_POST[sem_day];
$a17=$_POST[sem_year];
$a18=$_POST[sem_time_hr];
$a19=$_POST[sem_time_min];
$a20=$_POST[sem_time_day];
$db = mysqli_connect( "localhost" , "amp", "123456" , "amp" )
or die ("not able to connect.");
$query = "INSERT INTO attendees (
first_name,
last_name,
work_phone,
cell_phone,
company,
address_1,
address_2,
city,
state,
zip,
email,
sem_id,
sem_title,
sem_month,
sem_day,
sem_year,
sem_time_hr,
sem_time_min,
sem_time_day,
payment_type
)
VALUES (
'$a1',
'$a2',
'$a3',
'$a4',
'$a5',
'$a6',
'$a7',
'$a8',
'$a9',
'$a10',
'$a11',
'$a12',
'$a13',
'$a14',
'$a15',
'$a16',
'$a17',
'$a18',
'$a19',
'$a20'
)";
mysql_query($query) or die("Error adding data!");
?>