Selecting Table from a dropdown list

handley · January 13, 2011

Hi,

I've got a basic sign up form but I want a drop down list which will list different catergories that relate to different tables which when selected will input the sign up information into that table which was selected from the catergory drop down.

This is the signup form

_{<html><head><title>Birthdays Insert Form</title>}

_{<style type="text/css">}

_{td {font-family: tahoma, arial, verdana; font-size: 10pt }}

_</style>

_</head>

_<body>

_{<table width="300" cellpadding="5" cellspacing="0" border="2">}

_{<tr align="center" valign="top">}

_{<td align="left" colspan="1" rowspan="1" bgcolor="64b1ff">}

_{<h3>Insert Record</h3>}

_{<form method="POST" action="test.php">}

_<?

_{print "Enter Company Name: <input type=text name=company_name size=30><br>";}

_{print "Enter Contact Name: <input type=text name=contact_name size=30><br>";}

_{print "Enter Telephone: <input type=text name=telephone size=20><br>";}

_{print "Enter Fax: <input type=text name=fax size=30><br>";}

_{print "Enter Email: <input type=text name=email size=30><br>";}

_{print "Enter Address: <input type=text name=address1 size=20><br>";}

_{print "Enter Address: <input type=text name=address2 size=30><br>";}

_{print "Enter Postcode: <input type=text name=postcode size=30><br>";}

_{print "Enter Town / City: <input type=text name=town_city size=20><br>";}

_{print "Enter Website: <input type=text name=website size=30><br>";}

_{print "Enter Company Type: <select name='table'> <option>stationary</option><option>reception</option></select><br>";}

_{print "<br>";}

_{print "<input type=submit value=Submit><input type=reset>";}

_?>

_</form>

_{</td></tr></table>}

_</body>

_</html>

This is the part which I can't figure out and is probably totally wrong! Im trying to use this script to sort the drop down list to then run the correct script to insert the form data.

_{<html xmlns="}_{http://www.w3.org/1999/xhtml">}

_<head>

_{<title>Hello!</title>}

_</head>

_<body>

_<?php

_{if($_POST['table']=='stationary' 'birthdays_insert_record.php')}

_else

_{if($_POST['table']=='reception' 'insert_reception.php')}

_?>

_</body>

_</html>

This is the script which works! that inserts the form data into a specific table

_{<html><head><title>Birthdays Insert Record</title></head>}

_<body>

_<?

_{/* Change db and connect values if using online */}

_{$company_name=$_POST['company_name'];}

_{$contact_name=$_POST['contact_name'];}

_{$telephone=$_POST['telephone'];}

_{$fax=$_POST['fax'];}

_{$email=$_POST['email'];}

_{$address1=$_POST['address1'];}

_{$address2=$_POST['address2'];}

_{$postcode=$_POST['postcode'];}

_{$town_city=$_POST['town_city'];}

_{$website=$_POST['website'];}

_{$db="myflawlesswedding";}

_{$link = mysql_connect('localhost', 'root' , '');}

_{if (! $link)}

_{die(mysql_error());}

_{mysql_select_db($db , $link) or die("Select Error: ".mysql_error());}

_{$result=mysql_query("INSERT INTO reception (company_name, contact_name, telephone, fax, email, address1, address2, postcode, town_city, website) VALUES (}

_{'$company_name',}

_{'$contact_name',}

_{'$telephone',}

_'$fax',

_'$email',

_'$address1',

_'$address2',

_'$postcode',

_{'$town_city',}

_{'$website')") or die("Insert Error: ".mysql_error());}

_{mysql_close($link);}

_{print "Record added";}

_?>

_{<form method="POST" action="birthdays_insert_form.php">}

_{<input type="submit" value="Insert Another Record">}

_</form>

_<br>

_{<form method="POST" action="birthdays_dbase_interface.php">}

_{<input type="submit" value="Dbase Interface">}

_</form>

_</body>

_</html>

I hope somebody can help me out here! or can point me in a better way to sort this problem!

Thanks for any advice!

QuickOldCar · January 13, 2011

Try from this:

<?php
if($_POST['table']=='stationary' 'birthdays_insert_record.php')

else

if($_POST['table']=='reception' 'insert_reception.php')
?>

To this:

<?php
if($_POST['table']=='stationary') {
include('birthdays_insert_record.php'):
} elseif ($_POST['table']=='reception') {
include('insert_reception.php');
} else {
echo "Nothing was inserted";
}
?>

handley · January 13, 2011

I've changed the code but im getting a parse error on this line

include('birthdays_insert_record.php'):

Ive checked to see if the filename is correct which it is in all files.

Any ideas?

Pikachu2000 · January 13, 2011

That's a colon at the end instead of a semicolon . . .

QuickOldCar · January 13, 2011

Ha, so it is, good eye.

Corrected:

<?php
if($_POST['table']=='stationary') {
include('birthdays_insert_record.php');
} elseif ($_POST['table']=='reception') {
include('insert_reception.php');
} else {
echo "Nothing was inserted";
}
?>

handley · January 13, 2011

Works perfectly!!

Thanks alot for the help, its much appreciated!

Sign In

Selecting Table from a dropdown list

Recommended Posts

handley

Link to comment

Share on other sites

QuickOldCar

Link to comment

Share on other sites

handley

Link to comment

Share on other sites

Pikachu2000

Link to comment

Share on other sites

QuickOldCar

Link to comment

Share on other sites

handley

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information