I have been asked to take the values from a form and submit them to a mySQL database. Normally this wouldn't be a problem but I can't edit the form and the names are all "form[surname]" or "form[address]" etc.
I have been informed that the form is passing the data through as an array called form[] However when I tried to serialize the array using
Code: Select all
$form=serialize($_POST['form']);Here's the code below
Code: Select all
<?php
$con = mysql_connect("localhost","root","");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("hpoolSFC", $con);
$form=serialize($_POST['form']);
$sql="INSERT INTO enrollment (title, forename, surname, dob, gender, housenum, street1, street2, town, county, postcode, email, hometel, mobtel, pginitials, pgsurname, pgaddress, pgphone, schoolattended, careerinfo, courses, primary, id) VALUES('$form')";
if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
echo "1 record added";
mysql_close($con);
?>Code: Select all
<form method="post" id="userForm" enctype="multipart/form-data" action="http://www.hpoolsfc.ac.uk/enrol-online.html">
<table border="0" class="enrol">
<td colspan="3"><hr>
<span style="color:#000;font-weight:bold;">Yoooooooooour Details</span></td>
<tr>
<td width=22%">Title:</td>
<td><select name="form[Title][]" size="1" id="Title" ><option value="Mr">Mr</option><option value="Miss">Miss</option><option value="Ms">Ms</option><option value="Mrs">Mrs</option></select><div class="formClr"></div><span id="component87" class="formNoError">Invalid Input</span></td>
<td></td>
</tr>
<tr>
<td>Forenames: (*)</td>
<td><input type="text" value="" size="30" name="form[Forenames]" id="Forenames" /><div class="formClr"></div><span id="component91" class="formNoError">Invalid Input</span></td>
<td></td>
</tr>
<tr>
<td>Surname: (*)</td>
<td><input type="text" value="" size="30" name="form[Surname]" id="Surname" /><div class="formClr"></div><span id="component86" class="formNoError">Invalid Input</span></td>
<td></td>
</tr>
<tr>
<td>Date of Birth: (*)</td>
<td><input id="txtcal0" name="form[DOB]" type="text" value="" /><input id="btn0" type="button" value="..." onclick="showHideCalendar('cal0Container');" class="btnCal" /><div id="cal0Container" style="clear:both;display:none;position:absolute;z-index:9994"></div><div class="formClr"></div><span id="component85" class="formNoError">Invalid Input</span></td>
<td></td>
</tr>
<tr>
<td>Gender: (*)</td>
<td><input type="text" value="" size="10" name="form[Gender]" id="Gender" /><div class="formClr"></div><span id="component84" class="formNoError">Invalid Input</span></td>
<td></td>
</tr>
<tr>
<td>House Num/Name: (*)</td>
<td><input type="text" value="" size="30" name="form[HouseNum]" id="HouseNum" /><div class="formClr"></div><span id="component83" class="formNoError">Invalid Input</span></td>
<td></td>
</tr>
<tr>
<td>Street 1: (*)</td>
<td><input type="text" value="" size="40" name="form[Street1]" id="Street1" /><div class="formClr"></div><span id="component82" class="formNoError">Invalid Input</span></td>
<td></td>
</tr>
<tr>
<td>Street 2:</td>
<td><input type="text" value="" size="40" name="form[Street2]" id="Street2" /><div class="formClr"></div><span id="component81" class="formNoError">Invalid Input</span></td>
<td></td>
</tr>
<tr>
<td>Town or City: (*)</td>
<td><input type="text" value="" size="40" name="form[Town]" id="Town" /><div class="formClr"></div><span id="component80" class="formNoError">Invalid Input</span></td>
<td></td>
</tr>
<tr>
<td>County: (*)</td>
<td><input type="text" value="" size="30" name="form[County]" id="County" /><div class="formClr"></div><span id="component79" class="formNoError">Invalid Input</span></td>
<td></td>
</tr>
<tr>
<td>Post Code: (*)</td>
<td><input type="text" value="" size="10" name="form[Postcode]" id="Postcode" /><div class="formClr"></div><span id="component78" class="formNoError">Invalid Input</span></td>
<td></td>
</tr>
<tr>
<td>Email: (*)</td>
<td><input type="text" value="" size="30" name="form[Email]" id="Email" /><div class="formClr"></div><span id="component92" class="formNoError">Invalid Input</span></td>
<td></td>
</tr>
<tr>
<td>Home Telephone:</td>
<td><input type="text" value="" size="15" name="form[HomePhone]" id="HomePhone" /><div class="formClr"></div><span id="component77" class="formNoError">Invalid Input</span></td>
<td></td>
</tr>
<tr>
<td>Mobile Telephone: (*)</td>
<td><input type="text" value="" size="15" name="form[Mobile ]" id="Mobile " /><div class="formClr"></div><span id="component76" class="formNoError">Invalid Input</span></td>
<td></td>
</tr>
<tr>
<td colspan="3"><hr>
<span style="color:#000;font-weight:bold;">Parent or Guardian Details</span></td>
</tr>
<tr>
<td>Initials: (*)</td>
<td><input type="text" value="" size="5" name="form[Initials]" id="Initials" /><div class="formClr"></div><span id="component90" class="formNoError">Invalid Input</span></td>
<td></td>
</tr>
<tr>
<td>Surname: (*)</td>
<td><input type="text" value="" size="30" name="form[Parentsurname ]" id="Parentsurname " /><div class="formClr"></div><span id="component75" class="formNoError">Invalid Input</span></td>
<td></td>
</tr>
<tr>
<td valign="top">Address</td>
<td><textarea cols="40" rows="8" name="form[Parentaddress]" id="Parentaddress" ></textarea><div class="formClr"></div><span id="component89" class="formNoError">Invalid Input</span></td>
<td></td>
</tr>
<tr>
<td>Parent Phone</td>
<td><input type="text" value="" size="15" name="form[Parentphone]" id="Parentphone" /><div class="formClr"></div><span id="component74" class="formNoError">Invalid Input</span></td>
<td></td>
</tr>
<tr>
<td colspan="3"><hr>
<span style="color:#000;font-weight:bold;">Education</span></td></tr>
<tr>
<td>11-16 School Attended (*)</td>
<td><select name="form[School][]" size="1" id="School" ><option value="Brierton">Brierton</option><option value="Dyke House">Dyke House</option><option value="English Martyrs">English Martyrs</option><option value="High Tunstall">High Tunstall</option><option value="Manor">Manor</option><option value="S.T Hilds">S.T Hilds</option><option value="Other (Please specify)">Other (Please specify)</option><option value=""></option><option value=""></option><option value=""></option><option value=""></option><option value=""></option><option value=""></option></select><div class="formClr"></div><span id="component73" class="formNoError">Invalid Input</span></td>
<td></td>
</tr>
<tr>
<td>Other School</td>
<td><input type="text" value="" size="30" name="form[Otherschool]" id="Otherschool" /><div class="formClr"></div><span id="component72" class="formNoError">Invalid Input</span></td>
<td></td>
</tr>
<tr>
<td colspan="3"><hr>
<span style="color:#000;font-weight:bold;">Careers</span><br>It will help us to provide appropriate guidance over your programme of study at the college if you would indicate below any career interests you may have. For example are you considering higher education and for what type of employment are you eventually aiming?
</td></tr>
<tr>
<td>Career Info</td>
<td><textarea cols="40" rows="8" name="form[CareerInfo]" id="CareerInfo" ></textarea><div class="formClr"></div><span id="component94" class="formNoError">Invalid Input</span></td>
<td></td>
</tr>
<tr>
<td colspan="3"><hr>
<span style="color:#000;font-weight:bold;">Courses that I am interested in at the college</span><br>Please select below any of the college courses you are interested in taking and would like to discuss at interview.
</td></tr>
<tr>
<td>Courses (*)</td>
<td><input name="form[Courses][]" type="checkbox" value="Art " id="Courses0" /><label for="Courses0">Art </label><br/><input name="form[Courses][]" type="checkbox" value="Biology " id="Courses1" /><label for="Courses1">Biology </label><br/><input name="form[Courses][]" type="checkbox" value="Business Studies " id="Courses2" /><label for="Courses2">Business Studies </label><br/><input name="form[Courses][]" type="checkbox" value="Chemistry <br><br>" id="Courses3" /><label for="Courses3">Chemistry <br><br></label><br/><input name="form[Courses][]" type="checkbox" value="Child Care and Education " id="Courses4" /><label for="Courses4">Child Care and Education </label><br/><input name="form[Courses][]" type="checkbox" value="Communication and Culture " id="Courses5" /><label for="Courses5">Communication and Culture </label><br/><input name="form[Courses][]" type="checkbox" value="Computing and ICT <br><br>" id="Courses6" /><label for="Courses6">Computing and ICT <br><br></label><br/><input name="form[Courses][]" type="checkbox" value="Critical Thinking " id="Courses7" /><label for="Courses7">Critical Thinking </label><br/><input name="form[Courses][]" type="checkbox" value="Design Technology " id="Courses8" /><label for="Courses8">Design Technology </label><br/><input name="form[Courses][]" type="checkbox" value="English " id="Courses9" /><label for="Courses9">English </label><br/><input name="form[Courses][]" type="checkbox" value="Film Studies <br><br>" id="Courses10" /><label for="Courses10">Film Studies <br><br></label><br/><input name="form[Courses][]" type="checkbox" value="Geography " id="Courses11" /><label for="Courses11">Geography </label><br/><input name="form[Courses][]" type="checkbox" value="General Studies " id="Courses12" /><label for="Courses12">General Studies </label><br/><input name="form[Courses][]" type="checkbox" value="Health and Social Care " id="Courses13" /><label for="Courses13">Health and Social Care </label><br/><input name="form[Courses][]" type="checkbox" value="History <br><br>" id="Courses14" /><label for="Courses14">History <br><br></label><br/><input name="form[Courses][]" type="checkbox" value="Law " id="Courses15" /><label for="Courses15">Law </label><br/><input name="form[Courses][]" type="checkbox" value="Mathematics " id="Courses16" /><label for="Courses16">Mathematics </label><br/><input name="form[Courses][]" type="checkbox" value="Media Studies " id="Courses17" /><label for="Courses17">Media Studies </label><br/><input name="form[Courses][]" type="checkbox" value="Modern Foreign Languages <br><br>" id="Courses18" /><label for="Courses18">Modern Foreign Languages <br><br></label><br/><input name="form[Courses][]" type="checkbox" value="Music " id="Courses19" /><label for="Courses19">Music </label><br/><input name="form[Courses][]" type="checkbox" value="Performing Arts " id="Courses20" /><label for="Courses20">Performing Arts </label><br/><input name="form[Courses][]" type="checkbox" value="PE/Sports " id="Courses21" /><label for="Courses21">PE/Sports </label><br/><input name="form[Courses][]" type="checkbox" value="Photography " id="Courses22" /><label for="Courses22">Photography </label><br/><input name="form[Courses][]" type="checkbox" value="Physics <br><br>" id="Courses23" /><label for="Courses23">Physics <br><br></label><br/><input name="form[Courses][]" type="checkbox" value="Psychology " id="Courses24" /><label for="Courses24">Psychology </label><br/><input name="form[Courses][]" type="checkbox" value="Philosophy and Ethics " id="Courses25" /><label for="Courses25">Philosophy and Ethics </label><br/><input name="form[Courses][]" type="checkbox" value="Science in Society " id="Courses26" /><label for="Courses26">Science in Society </label><br/><input name="form[Courses][]" type="checkbox" value="Sociology <br<br>" id="Courses27" /><label for="Courses27">Sociology <br<br></label><br/><input name="form[Courses][]" type="checkbox" value="Textiles " id="Courses28" /><label for="Courses28">Textiles </label><br/><input name="form[Courses][]" type="checkbox" value="Travel and Tourism " id="Courses29" /><label for="Courses29">Travel and Tourism </label><br/><div class="formClr"></div><span id="component95" class="formNoError">Invalid Input</span></td>
<td></td>
</tr>
<tr>
<td colspan="3"><hr></td></tr>
<tr>
<td>Primary Choice</td>
<td><input name="form[FirstChoice][]" type="checkbox" value="Hartlepool Sixth Form College is my first choice for further education." id="FirstChoice0" /><label for="FirstChoice0">Hartlepool Sixth Form College is my first choice for further education.</label><div class="formClr"></div><span id="component101" class="formNoError">Invalid Input</span></td>
<td></td>
</tr>
<tr>
<td colspan="3"><hr>
<span style="color:#000;font-weight:bold;">Anti Spam</span><br>Please enter the two words in the box below so we know you are a real person!
</td></tr>
<tr>
<tr>
<td></td>
<td><script type="text/javascript">
var RecaptchaOptions = {
theme : "white"
};
</script><script type="text/javascript" src="http://api.recaptcha.net/challenge?k=6LcteLwSAAAAAK6oTvERh0RJCdggjp99sYdYhceE"></script>
<noscript>
<iframe src="http://api.recaptcha.net/noscript?k=6LcteLwSAAAAAK6oTvERh0RJCdggjp99sYdYhceE" height="300" width="500" frameborder="0"></iframe><br/>
<textarea name="recaptcha_challenge_field" rows="3" cols="40"></textarea>
<input type="hidden" name="recaptcha_response_field" value="manual_challenge"/>
</noscript><div class="formClr"></div><span id="component93" class="formNoError">Invalid Input</span></td>
<td></td>
</tr>
<tr>
<td></td>
<td><input type="submit" value="Submit" name="form[Submit]" id="Submit" /><div class="formClr"></div></td>
<td></td>
</tr>
</table>
<input type="hidden" name="form[formId]" value="7"/></form>