'INERT MULTIPLE HTML ELEMENTS INTO A SINGLE MYSQL COLUMN WITH PHP'
Dear All
I am trying to process form data with PHP and insert the data into a database. My problem is (1) that I have two '<input>' elements that I want to 'INSERT INTO' one MySQL column (address) of the table 'user_feedback' and (2) I have three '<select>' elements that I want to group together and INSERT INTO another single column (dob) of the same table.
In both scenarios I am able to insert the first named value for example '$_POST[dob]' and '$_POST[address1]' but not the subsequent ones (separated by commas). Does any one know if or how this can be done? Many thanks.
Below is the table I created:
mysql> create table user_feedback (id int not null primary key auto_increment, f
irst_name varchar(50), surname varchar(50), dob varchar(50), sex varchar(7), add
ress varchar(255), postcode varchar(25), email varchar(50), chosen_location varc
har(50), time varchar(50), month varchar(18), date varchar(50), comments varchar
(25));
Below is my php script:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<body>
<?php
$conn = mysql_connect("elita", "user", "password");
mysql_select_db("feedback", $conn);
$sql = "INSERT INTO user_feedback (first_name, surname, dob, sex, address, postcode, email, chosen_location, time, month, date, comments) VALUES ('$_POST[firstname_1]', '$_POST[surname_1]', '$_POST[dob], [dates1], [months1]', '$_POST[sex]', '$_POST[address1], [address2]', '$_POST[postcode1]', '$_POST[email1]', '$_POST[location]', '$_POST[time]', '$_POST[months]', '$_POST[dates2]', '$_POST[AdditionalComments]')";
if (mysql_query($sql, $conn)) {
echo "record added";
} else {
echo "error - record not added";
}
?>
</body>
</html>
And below are the affected parts of the HTML page which corresond to the problems:
(1):
<input class="contact4" name="address1" type="text" accesskey="f" tabindex="6" value="address" size="40" alt="input address" accept= "The Unicode Standard, Version 3.0" max="max" length="40" />
<input class="contact7" name="address2" type="text" accesskey="g" tabindex="7" value="address" size="40" alt="input address" accept="The Unicode Standard, Version 3.0" max="max" length="40" />
(2)
<select class="contact1"name="dob" size="1" tabindex="10" accesskey="j" value="dob_1">
<option name="0" value="year">year</option>
<option name="1" value="1910">1910</option>
<option name="2" value="1911">1911</option>
<option name="3" value="1912">1912</option>
<option name="4" value="1913">1913</option>
<option name="5" value="1914">1914</option>
<select class="contact2" name="dates1" tabindex="11" accesskey="k" value="dates_1">
<optgroup name="dates1" value="dates_1">
<option name="00_1" value="00b_1">Date</option>
<option name="01_1" value="01b_1">1st</option>
<select class="contact3" name="months1" tabindex="12" accesskey="l" value="months_1">
<optgroup name="months1" value="months_1">
<option name="00a_1" value="00a_1">Month</option>
<option name="jan_1" value="jan_1">January</option>
Thanks in advance for any help!!
_________________
remember, know to forget
|
|
||||||||||||||||||||||||||||||||
|
Home •
Watched Topics •
Register •
Search•
Directory FAQ • Memberlist • Usergroups • Log in• Stores • Items • Bank |
||||||||||||||||||||||||||||||||
|
THE PHP FORUM.NET IS HIRING MODERATORS.
PLEASE SEND A PRIVATE MESSAGE TO PRATAMISHUS IF YOU WANT TO EARN SOME EXTRA CASH (Registered users only).
|
||||||||||||||||||||||||||||||||
|
Powered by phpBB © phpBB Group � Design by phpBBStyles.com | Styles Database |
||||||||||||||||||||||||||||||||
|
|
|