I created a huge form that posts to a page. I collect the data and try and put it in the database but nothing happens. Is there a limit to what you can put into a database at one time?
Here is my create table query
CREATE TABLE application (appid integer not null auto_increment primary key,
fname VARCHAR(30),
lname VARCHAR(30),
haddress VARCHAR(100),
city VARCHAR(30),
state VARCHAR(30),
zip VARCHAR(30),
hphone VARCHAR(30),
cphone VARCHAR(30),
email VARCHAR(30),
bday VARCHAR(30),
height VARCHAR(30),
weight VARCHAR(30),
eyecolor VARCHAR(30),
haircolor VARCHAR(30),
looking1 VARCHAR(30),
looking2 VARCHAR(30),
photo VARCHAR(255),
occup VARCHAR(30),
employer VARCHAR(30),
caddress VARCHAR(100),
ccity VARCHAR(30),
cstate VARCHAR(30),
czip VARCHAR(30),
bphone VARCHAR(30),
ext VARCHAR(30),
eyears VARCHAR(30),
emonths VARCHAR(30),
grewup VARCHAR(30),
school1 VARCHAR(30),
school2 VARCHAR(30),
school3 VARCHAR(30),
college VARCHAR(30),
degrees1 VARCHAR(30),
degrees2 VARCHAR(30),
otherdegrees VARCHAR(30),
incomelvl VARCHAR(30),
datewho VARCHAR(30),
mstatus VARCHAR(30),
dategoals VARCHAR(30),
yousmoke VARCHAR(30),
datesmoke VARCHAR(30),
usedrugs VARCHAR(30),
drink VARCHAR(30),
children VARCHAR(30),
numchildren VARCHAR(30),
numlivewith VARCHAR(30),
childrenages VARCHAR(30),
wantchildren VARCHAR(30),
prefer VARCHAR(30),
pets VARCHAR(30),
petsyes VARCHAR(30),
datewpets VARCHAR(30),
allergic VARCHAR(30),
allergicyes VARCHAR(30),
ethnic VARCHAR(30),
ethnicpref1 VARCHAR(30),
ethnicpref2 VARCHAR(30),
ethnicpref3 VARCHAR(30),
ethnicpref4 VARCHAR(30),
ethnicpref5 VARCHAR(30),
ethnicpref6 VARCHAR(30),
ethnicpref7 VARCHAR(30),
ethnicpref8 VARCHAR(30),
politicalviews1 VARCHAR(30),
politicalviews2 VARCHAR(30),
politicalviews3 VARCHAR(30),
politicalviews4 VARCHAR(30),
politicalother VARCHAR(30),
religiouspref VARCHAR(30),
samereligion VARCHAR(30),
persontraits1 VARCHAR(30),
persontraits2 VARCHAR(30),
persontraits3 VARCHAR(30),
persontraits4 VARCHAR(30),
persontraits5 VARCHAR(30),
persontraits6 VARCHAR(30),
persontraits7 VARCHAR(30),
persontraits8 VARCHAR(30),
persontraits9 VARCHAR(30),
persontraits10 VARCHAR(30),
persontraits11 VARCHAR(30),
persontraits12 VARCHAR(30),
persontraits13 VARCHAR(30),
persontraits14 VARCHAR(30),
persontraits15 VARCHAR(30),
persontraits16 VARCHAR(30),
persontraits17 VARCHAR(30),
persontraits18 VARCHAR(30),
persontraits19 VARCHAR(30),
persontraits20 VARCHAR(30),
persontraits21 VARCHAR(30),
persontraits22 VARCHAR(30),
persontraits23 VARCHAR(30),
persontraits24 VARCHAR(30),
persontraits25 VARCHAR(30),
persontraits26 VARCHAR(30),
persontraits27 VARCHAR(30),
persontraits28 VARCHAR(30),
persontraits29 VARCHAR(30),
persontraits30 VARCHAR(30),
persontraits31 VARCHAR(30),
persontraits32 VARCHAR(30),
persontraits33 VARCHAR(30),
persontraits34 VARCHAR(30),
persontraits35 VARCHAR(30),
persontraits36 VARCHAR(30),
persontraits37 VARCHAR(30),
persontraits38 VARCHAR(30),
persontraits39 VARCHAR(30),
persontraits40 VARCHAR(30),
persontraits41 VARCHAR(30),
persontraits42 VARCHAR(30),
persontraits43 VARCHAR(30),
persontraits44 VARCHAR(30),
persontraits45 VARCHAR(30),
persontraits46 VARCHAR(30),
persontraits47 VARCHAR(30),
persontraits48 VARCHAR(30),
persontraits49 VARCHAR(30),
persontraits50 VARCHAR(30),
persontraits51 VARCHAR(30),
persontraits52 VARCHAR(30),
othertraits VARCHAR(30),
activities1 VARCHAR(30),
activities2 VARCHAR(30),
activities3 VARCHAR(30),
activities4 VARCHAR(30),
activities5 VARCHAR(30),
activities6 VARCHAR(30),
activities7 VARCHAR(30),
activities8 VARCHAR(30),
activities9 VARCHAR(30),
activities10 VARCHAR(30),
activities11 VARCHAR(30),
activities12 VARCHAR(30),
activities13 VARCHAR(30),
activities14 VARCHAR(30),
activities15 VARCHAR(30),
activities16 VARCHAR(30),
activities17 VARCHAR(30),
activities18 VARCHAR(30),
activities19 VARCHAR(30),
activities20 VARCHAR(30),
activities21 VARCHAR(30),
activities22 VARCHAR(30),
activities23 VARCHAR(30),
activities24 VARCHAR(30),
activities25 VARCHAR(30),
activities26 VARCHAR(30),
activities27 VARCHAR(30),
activities28 VARCHAR(30),
activities29 VARCHAR(30),
activities30 VARCHAR(30),
activities31 VARCHAR(30),
activities32 VARCHAR(30),
otheractivities VARCHAR(30),
space VARCHAR(30),
readmaterial1 VARCHAR(30),
readmaterial2 VARCHAR(30),
readmaterial3 VARCHAR(30),
readmaterial4 VARCHAR(30),
othermaterial VARCHAR(30),
tvprograms1 VARCHAR(30),
tvprograms2 VARCHAR(30),
tvprograms3 VARCHAR(30),
tvprograms4 VARCHAR(30),
tvprograms5 VARCHAR(30),
tvprograms6 VARCHAR(30),
tvprograms7 VARCHAR(30),
tvprograms8 VARCHAR(30),
othertv VARCHAR(30),
movies1 VARCHAR(30),
movies2 VARCHAR(30),
movies3 VARCHAR(30),
movies4 VARCHAR(30),
movies5 VARCHAR(30),
movies6 VARCHAR(30),
movies7 VARCHAR(30),
movies8 VARCHAR(30),
othermovies VARCHAR(30),
health VARCHAR(30),
healthyes VARCHAR(30),
dietarypref VARCHAR(30),
dietaryyes VARCHAR(30),
exercise VARCHAR(30),
exerciseyes VARCHAR(30),
travel VARCHAR(30),
travelyes VARCHAR(30),
traveling1 VARCHAR(30),
traveling2 VARCHAR(30),
traveling3 VARCHAR(30),
travelloc VARCHAR(30),
importanttraits VARCHAR(255),
notcompatiable VARCHAR(255),
idealage VARCHAR(30),
idealheight VARCHAR(30),
idealweight VARCHAR(30),
idealhaircolor VARCHAR(30),
idealeyecolor VARCHAR(30),
idealchildren VARCHAR(30),
idealperson VARCHAR(30),
geoloc1 VARCHAR(30),
geoloc2 VARCHAR(30),
geoloc3 VARCHAR(30),
geoloc4 VARCHAR(30),
geoloc5 VARCHAR(30),
geoloc6 VARCHAR(30),
othergeoloc VARCHAR(30),
dateservice VARCHAR(30),
dateserviceyes VARCHAR(30),
donediff VARCHAR(255),
hearabout1 VARCHAR(30),
hearabout2 VARCHAR(30),
hearabout3 VARCHAR(30),
hearabout4 VARCHAR(30),
hearabout5 VARCHAR(30) )
Here is my php code.
[code]//This is the directory where images will be saved
$target = “uploads/”;
$target = $target . basename( $_FILES[‘photo’][‘name’]);
//This gets all the other information from the form
$fname=$_POST[‘fname’];
$lname=$_POST[‘lname’];
$hadress=$_POST[‘haddress’];
$city=$_POST['city '];
$state=$_POST[‘state’];
$zip=$_POST[‘zip’];
$hphone=$_POST[‘hphone’];
$cphone=$_POST[‘cphone’];
$email=$_POST[‘email’];
$bday=$_POST[‘bday’];
$height=$_POST[‘height’];
$weight=$_POST[‘weight’];
$eyecolor=$_POST[‘eyecolor’];
$haircolor=$_POST[‘haircolor’];
$looking1=$_POST[‘looking1’];
$looking2=$_POST[‘looking2’];
$pic=($_FILES[‘photo’][‘name’]);
$occup=$_POST[‘occup’];
$employer=$_POST[‘employer’];
$caddress=$_POST[‘caddress’];
$ccity=$_POST[‘ccity’];
$cstate=$_POST[‘cstate’];
$czip=$_POST[‘czip’];
$bphone=$_POST[‘bphone’];
$ext=$_POST[‘ext’];
$eyears=$_POST[‘eyears’];
$emonths=$_POST[‘emonths’];
$grewup=$_POST[‘grewup’];
$school1=$_POST[‘school1’];
$school2=$_POST[‘school2’];
$school3=$_POST[‘school3’];
$college=$_POST[‘college’];
$degrees1=$_POST[‘degrees1’];
$degrees2=$_POST[‘degrees2’];
$otherdegrees=$_POST[‘otherdegrees’];
$incomelvl=$_POST[‘incomelvl’];
$datewho=$_POST[‘datewho’];
$mstatus=$_POST[‘mstatus’];
$dategoals=$_POST[‘dategoals’];
$yousmoke=$_POST[‘yousmoke’];
$datesmoke=$_POST[‘datesmoke’];
$usedrugs=$_POST[‘usedrugs’];
$drink=$_POST[‘drink’];
$children=$_POST[‘children’];
$numchildren=$_POST[‘numchildren’];
$numlivewith=$_POST[‘numlivewith’];
$childrenages=$_POST[‘childrenages’];
$wantchildren=$_POST[‘wantchildren’];
$prefer=$_POST[‘prefer’];
$pets=$_POST[‘pets’];
$petsyes=$_POST[‘petsyes’];
$datewpets=$_POST[‘datewpets’];
$allergic=$_POST[‘allergic’];
$allergicyes=$_POST[‘allergicyes’];
$ethinc=$_POST[‘ethnic’];
$ethincpref1=$_POST[‘ethnicpref1’];
$ethincpref2=$_POST[‘ethnicpref2’];
$ethincpref3=$_POST[‘ethnicpref3’];
$ethincpref4=$_POST[‘ethnicpref4’];
$ethincpref5=$_POST[‘ethnicpref5’];
$ethincpref6=$_POST[‘ethnicpref6’];
$ethincpref7=$_POST[‘ethnicpref7’];
$ethincpref8=$_POST[‘ethnicpref8’];
$politicalviews1=$_POST[‘politicalviews1’];
$politicalviews2=$_POST[‘politicalviews2’];
$politicalviews3=$_POST[‘politicalviews3’];
$politicalviews4=$_POST[‘politicalviews4’];
$politicalother=$_POST[‘politicalother’];
$religiouspref=$_POST[‘religiouspref’];
$samereligion=$_POST[‘samereligion’];
$persontraits1=$_POST[‘persontraits1’];
$persontraits2=$_POST[‘persontraits2’];
$persontraits3=$_POST[‘persontraits3’];
$persontraits4=$_POST[‘persontraits4’];
$persontraits5=$_POST[‘persontraits5’];
$persontraits6=$_POST[‘persontraits6’];
$persontraits7=$_POST[‘persontraits7’];
$persontraits8=$_POST[‘persontraits8’];
$persontraits9=$_POST[‘persontraits9’];
$persontraits10=$_POST[‘persontraits10’];
$persontraits11=$_POST[‘persontraits11’];
$persontraits12=$_POST[‘persontraits12’];
$persontraits13=$_POST[‘persontraits13’];
$persontraits14=$_POST[‘persontraits14’];
$persontraits15=$_POST[‘persontraits15’];
$persontraits16=$_POST[‘persontraits16’];
$persontraits17=$_POST[‘persontraits17’];
$persontraits18=$_POST[‘persontraits18’];
$persontraits19=$_POST[‘persontraits19’];
$persontraits20=$_POST[‘persontraits20’];
$persontraits21=$_POST[‘persontraits21’];
$persontraits22=$_POST[‘persontraits22’];
$persontraits23=$_POST[‘persontraits23’];
$persontraits24=$_POST[‘persontraits24’];
$persontraits25=$_POST[‘persontraits25’];
$persontraits26=$_POST[‘persontraits26’];
$persontraits27=$_POST[‘persontraits27’];
$persontraits28=$_POST[‘persontraits28’];
$persontraits29=$_POST[‘persontraits29’];
$persontraits30=$_POST[‘persontraits30’];
$persontraits31=$_POST[‘persontraits31’];
$persontraits32=$_POST[‘persontraits32’];
$persontraits33=$_POST[‘persontraits33’];
$persontraits34=$_POST[‘persontraits34’];
$persontraits35=$_POST[‘persontraits35’];
$persontraits36=$_POST[‘persontraits36’];
$persontraits37=$_POST[‘persontraits37’];
$persontraits38=$_POST[‘persontraits38’];
$persontraits39=$_POST[‘persontraits39’];
$persontraits40=$_POST[‘persontraits40’];
$persontraits41=$_POST[‘persontraits41’];
$persontraits42=$_POST[‘persontraits42’];
$persontraits43=$_POST[‘persontraits43’];
$persontraits44=$_POST[‘persontraits44’];
$persontraits45=$_POST[‘persontraits45’];
$persontraits46=$_POST[‘persontraits46’];
$persontraits47=$_POST[‘persontraits47’];
$persontraits48=$_POST[‘persontraits48’];
$persontraits49=$_POST[‘persontraits49’];
$persontraits50=$_POST[‘persontraits50’];
$persontraits51=$_POST[‘persontraits51’];
$persontraits52=$_POST[‘persontraits52’];
$othertraits=$_POST[‘othertraits’];
$activities1=$_POST[‘activities1’];
$activities2=$_POST[‘activities2’];
$activities3=$_POST[‘activities3’];
$activities4=$_POST[‘activities4’];
$activities5=$_POST[‘activities5’];
$activities6=$_POST[‘activities6’];
$activities7=$_POST[‘activities7’];
$activities8=$_POST[‘activities8’];
$activities9=$_POST[‘activities9’];
$activities10=$_POST[‘activities10’];
$activities11=$_POST[‘activities11’];
$activities12=$_POST[‘activities12’];
$activities13=$_POST[‘activities13’];
$activities14=$_POST[‘activities14’];
$activities15=$_POST[‘activities15’];
$activities16=$_POST[‘activities16’];
$activities17=$_POST[‘activities17’];
$activities18=$_POST[‘activities18’];
$activities19=$_POST[‘activities19’];
$activities20=$_POST[‘activities20’];
$activities21=$_POST[‘activities21’];
$activities22=$_POST[‘activities22’];
$activities23=$_POST[‘activities23’];
$activities24=$_POST[‘activities24’];
$activities25=$_POST[‘activities25’];
$activities26=$_POST[‘activities26’];
$activities27=$_POST[‘activities27’];
$activities28=$_POST[‘activities28’];
$activities29=$_POST[‘activities29’];
$activities30=$_POST[‘activities30’];
$activities31=$_POST[‘activities31’];
$activities32=$_POST[‘activities32’];
$otheractivities=$_POST[‘otheractivities’];
$space=$_POST[‘space’];
$readmaterial1=$_POST[‘readmaterial1’];
$readmaterial2=$_POST[‘readmaterial2’];
$readmaterial3=$_POST[‘readmaterial3’];
$readmaterial4=$_POST[‘readmaterial4’];
$othermaterial=$_POST[‘othermaterial’];
$tvprograms1=$_POST[‘tvprograms1’];
$tvprograms2=$_POST[‘tvprograms2’];
$tvprograms3=$_POST[‘tvprograms3’];
$tvprograms4=$_POST[‘tvprograms4’];
$tvprograms5=$_POST[‘tvprograms5’];
$tvprograms6=$_POST[‘tvprograms6’];
$tvprograms7=$_POST[‘tvprograms7’];
$tvprograms8=$_POST[‘tvprograms8’];
$othertv=$_POST[‘othertv’];
$movies1=$_POST[‘movies1’];
$movies2=$_POST[‘movies2’];
$movies3=$_POST[‘movies3’];
$movies4=$_POST[‘movies4’];
$movies5=$_POST[‘movies5’];
$movies6=$_POST[‘movies6’];
$movies7=$_POST[‘movies7’];
$movies8=$_POST[‘movies8’];
$othermovies=$_POST[‘othermovies’];
$health=$_POST[‘health’];
$healthyes=$_POST[‘healthyes’];
$dietarypref=$_POST[‘dietarypref’];
$dietaryyes=$_POST[‘dietaryyes’];
$exercise=$_POST[‘exercise’];
$exerciseyes=$_POST[‘exerciseyes’];
$travel=$_POST[‘travel’];
$travelyes=$_POST[‘travelyes’];
$traveling1=$_POST[‘traveling1’];
$traveling2=$_POST[‘traveling2’];
$traveling3=$_POST[‘traveling3’];
$travelloc=$_POST[‘travelloc’];
$importantraits=$_POST[‘importanttraits’];
$notcompatiable=$_POST[‘notcompatiable’];
$idealage=$_POST[‘idealage’];
$idealheight=$_POST[‘idealheight’];
$idealweight=$_POST[‘idealweight’];
$idealhaircolor=$_POST[‘idealhaircolor’];
$idealeyecolor=$_POST[‘idealeyecolor’];
$idealchildren=$_POST[‘idealchildren’];
$idealperson=$_POST[‘idealperson’];
$geoloc1=$_POST[‘geoloc1’];
$geoloc2=$_POST[‘geoloc2’];
$geoloc3=$_POST[‘geoloc3’];
$geoloc4=$_POST[‘geoloc4’];
$geoloc5=$_POST[‘geoloc5’];
$geoloc6=$_POST[‘geoloc6’];
$othergeoloc=$_POST[‘othergeoloc’];
$dateservice=$_POST[‘dateservice’];
$dateserviceyes=$_POST[‘dateserviceyes’];
$donediff=$_POST[‘donediff’];
$hearabout1=$_POST[‘hearabout1’];
$hearabout2=$_POST[‘hearabout2’];
$hearabout3=$_POST[‘hearabout3’];
$hearabout4=$_POST[‘hearabout4’];
$hearabout5=$_POST[‘hearabout5’];
// Connects to your Database
$conn = mysql_connect(“localhost”, “root”, “admin”) or die(mysql_error()) ;
mysql_select_db(“mmm”) or die(mysql_error()) ;
//Writes the information to the database
mysql_query(“INSERT INTO ‘application’ VALUES (’’, ‘$fname’,’$lname’,’$hadress’,’$city’,’$state’,’$zip’,’$hphone’,’$cphone’,’$email’,’$bday’,’$height’,’$weight’,’$eyecolor’,’$haircolor’,’$looking1’,’$looking2’,’$pic’,’$occup’,’$employer’,’$caddress’,’$ccity’,’$cstate’,’$czip’,’$bphone’,’$ext’,’$eyears’,’$emonths’,’$grewup’,’$school1’,’$school2’,’$school3’,’$college’,’$degrees1’,’$degrees2’,’$otherdegrees’,’$incomelvl’,’$datewho’,’$mstatus’,’$dategoals’,’$yousmoke’,’$datesmoke’,’$usedrugs’,’$drink’,’$children’,’$numchildren’,’$numlivewith’,’$childrenages’,’$wantchildren’,’$prefer’,’$pets’,’$petsyes’,’$datewpets’,’$allergic’,’$allergicyes’,’$ethinc’,’$ethincpref1’,’$ethincpref2’,’$ethincpref3’,’$ethincpref4’,’$ethincpref5’,’$ethincpref6’,’$ethincpref7’,’$ethincpref8’,’$politicalviews1’,’$politicalviews2’,’$politicalviews3’,’$politicalviews4’,’$politicalother’,’$religiouspref’,’$samereligion’,’$persontraits1’,’$persontraits2’,’$persontraits3’,’$persontraits4’,’$persontraits5’,’$persontraits6’,’$persontraits7’,’$persontraits8’,’$persontraits9’,’$persontraits10’,’$persontraits11’,’$persontraits12’,’$persontraits13’,’$persontraits14’,’$persontraits15’,’$persontraits16’,’$persontraits17’,’$persontraits18’,’$persontraits19’,’$persontraits20’,’$persontraits21’,’$persontraits22’,’$persontraits23’,’$persontraits24’,’$persontraits25’,’$persontraits26’,’$persontraits27’,’$persontraits28’,’$persontraits29’,’$persontraits30’,’$persontraits31’,’$persontraits32’,’$persontraits33’,’$persontraits34’,’$persontraits35’,’$persontraits36’,’$persontraits37’,’$persontraits38’,’$persontraits39’,’$persontraits40’,’$persontraits41’,’$persontraits42’,’$persontraits43’,’$persontraits44’,’$persontraits45’,’$persontraits46’,’$persontraits47’,’$persontraits48’,’$persontraits49’,’$persontraits50’,’$persontraits51’,’$persontraits52’,’$othertraits’,’$activities1’,’$activities2’,’$activities3’,’$activities4’,’$activities5’,’$activities6’,’$activities7’,’$activities8’,’$activities9’,’$activities10’,’$activities11’,’$activities12’,’$activities13’,’$activities14’,’$activities15’,’$activities16’,’$activities17’,’$activities18’,’$activities19’,’$activities20’,’$activities21’,’$activities22’,’$activities23’,’$activities24’,’$activities25’,’$activities26’,’$activities27’,’$activities28’,’$activities29’,’$activities30’,’$activities31’,’$activities32’,’$otheractivities’, ‘$space’,’$readmaterial1’, ‘$readmaterial2’, ‘$readmaterial3’, ‘$readmaterial4’, ‘$othermaterial’, ‘$tvprograms1’,’$tvprograms2’,’$tvprograms3’,’$tvprograms4’,’$tvprograms5’,’$tvprograms6’, ‘$tvprograms7’,’$tvprograms8’,’$othertv’,’$movies1’, ‘$movies2’, ‘$movies3’, ‘$movies4’, ‘$movies5’, ‘$movies6’, ‘$movies7’, ‘$movies8’, ‘$othermovies’,’$health’,’$healthyes’,’$dietarypref’,’$dietaryyes’,’$exercise’,’$exerciseyes’,’$travel’,’$travelyes’,’$traveling1’,’$traveling2’,’$traveling3’,’$travelloc’,’$importantraits’,’$notcompatiable’,’$idealage’,’$idealheight’,’$idealweight’,’$idealhaircolor’,’$idealeyecolor’,’$idealchildren’,’$idealperson’,’$geoloc1’, ‘$geoloc2’, ‘$geoloc3’, ‘$geoloc4’, ‘$geoloc5’, ‘$geoloc6’, ‘$othergeoloc’,’$dateservice’,’$dateserviceyes’, ‘$donediff’, ‘$hearabout1’,’$hearabout2’,’$hearabout3’,’$hearabout4’,’$hearabout5’)”) ;
//Writes the photo to the server
if(move_uploaded_file($_FILES[‘photo’][‘tmp_name’], $target))
{
//Tells you if its all ok
echo "Congratulations and Welcome to the Family.";
}
else {
//Gives and error if its not
echo "Sorry, there was a problem uploading your file.";
}
echo($fname) ;
// Close connection to Mysql
mysql_close($conn);[/code]
Can anyone see what im doing wrong?