How do I get my php form to go to next page after mysql?

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
User avatar
cap2cap10
Forum Contributor
Posts: 158
Joined: Mon Apr 14, 2008 11:06 pm

How do I get my php form to go to next page after mysql?

Post by cap2cap10 »

How Do I get my php form to move to next page after data has been uploaded to php?

Code: Select all

<?php require('form_header1.htm')?>
<?php
 include 'open_jsnew.php';
if (isset($_POST['submitted']))
{
// Handle the form.
 
 
// Sanitize the input:
 
 
 
$username = filter_input(INPUT_POST, 'username', FILTER_SANITIZE_STRING, FILTER_FLAG_NO_ENCODE_QUOTES);
 
if ($username) {
 
echo "<p>Username: $username<br />\$_POST['username']: {$_POST['username']}</p>\n";
 
}
else {
 
echo '<p class="error">Please enter your username.</p>';
 
}
 
 
 
$password = filter_input(INPUT_POST, 'password', FILTER_SANITIZE_STRING, FILTER_FLAG_NO_ENCODE_QUOTES);
 
if ($password) {
 
echo "<p>Password: $password<br />\$_POST['password']: {$_POST['password']}</p>\n";
 
}
else {
 
echo '<p class="error">Please enter your password.</p>';
 
}
 
 
 
$FName = filter_input(INPUT_POST, 'name', FILTER_SANITIZE_STRING, FILTER_FLAG_NO_ENCODE_QUOTES);
 
if ($FName) {
 
echo "<p>First Name: $FName<br />\$_POST['FName']: {$_POST['FName']}</p>\n";
 
}
else {
 
echo '<p class="error">Please enter your  First Name.</p>';
 
}
 
 
 
$MName = filter_input(INPUT_POST, 'MName', FILTER_SANITIZE_STRING, FILTER_FLAG_NO_ENCODE_QUOTES);
 
if ($MName) {
 
echo "<p>Middle Name: $MName<br />\$_POST['MName']: {$_POST['MName']}</p>\n";
 
}
else {
 
echo '<p class="error">Please enter your Middle Name.</p>';
 
}
 
 
 
$LName = filter_input(INPUT_POST, 'LName', FILTER_SANITIZE_STRING, FILTER_FLAG_NO_ENCODE_QUOTES);
 
if ($LName) {
 
echo "<p> Last Name: $LName<br />\$_POST['LName']: {$_POST['LName']}</p>\n";
 
}
else {
 
echo '<p class="error">Please enter your Last Name.</p>';
 
}
 
 
 
// Validate the email address using FILTER_VALIDATE_EMAIL:
 
 
$Email = filter_input(INPUT_POST, 'Email', FILTER_VALIDATE_EMAIL);
 
if ($Email) {
 
echo "<p>E-mail Address: $Email</p>\n";
 
}
else {
 
echo '<p class="error">Please enter your E-mail Address.</p>';
 
}
 
 
 
$Address = filter_input(INPUT_POST, 'Address', FILTER_SANITIZE_STRING, FILTER_FLAG_NO_ENCODE_QUOTES);
 
if ($Address) {
 
echo "<p>Address: $Address<br />\$_POST['Address']: {$_POST['Address']}</p>\n";
 
}
else {
 
echo '<p class="error">Please enter your Address.</p>';
 
}
 
 
 
$Suite = filter_input(INPUT_POST, 'Suite', FILTER_SANITIZE_STRING, FILTER_FLAG_NO_ENCODE_QUOTES);
 
if ($Suite) {
 
echo "<p>Suite/Apartment: $Suite<br />\$_POST['Suite']: {$_POST['Suite']}</p>\n";
 
}
else {
 
echo '<p class="error">Please enter your Suite/Apartment.</p>';
 
}
 
 
 
 
$City = filter_input(INPUT_POST, 'City', FILTER_SANITIZE_STRING, FILTER_FLAG_NO_ENCODE_QUOTES);
 
if ($City) {
 
echo "<p>City: $City<br />\$_POST['City']: {$_POST['City']}</p>\n";
 
}
else {
 
echo '<p class="error">Please enter your City.</p>';
 
}
 
 
 
$State = filter_input(INPUT_POST, 'State', FILTER_SANITIZE_STRING, FILTER_FLAG_NO_ENCODE_QUOTES);
 
if ($State) {
 
echo "<p>State: $State<br />\$_POST['State']: {$_POST['State']}</p>\n";
 
}
else {
 
echo '<p class="error">Please enter your State.</p>';
 
}
 
 
 
$Zipcode = filter_input(INPUT_POST, 'Zipcode', FILTER_VALIDATE_INT);
 
if ($Zipcode) {
 
echo "<p>Zip Code: $Zipcode</p>\n";
 
}
else {
 
echo '<p class="error">Please enter your Home Zip Code.</p>';
 
}
 
 
 
 
// Validate the Hphone number using FILTER_VALIDATE_INT:
 
 
$Hphone_1 = filter_input(INPUT_POST, 'Hphone_1', FILTER_VALIDATE_INT);
 
if ($Hphone_1) {
 
echo "<p>Home Phone Number: $Hphone_1</p>\n";
 
}
 
$Hphone_2 = filter_input(INPUT_POST, 'Hphone_2', FILTER_VALIDATE_INT);
 
if ($Hphone_2) {
 
echo "<p>Home Phone Number: $Hphone_2</p>\n";
 
}
 
$Hphone_3 = filter_input(INPUT_POST, 'Hphone_3', FILTER_VALIDATE_INT);
 
if ($Hphone_3) {
 
echo "<p>Home Phone Number: $Hphone_3</p>\n";
 
}
 
// Validate the Mphone number using FILTER_VALIDATE_INT:
 
 
$Mphone_1 = filter_input(INPUT_POST, 'Mphone_1', FILTER_VALIDATE_INT);
 
if ($Mphone_1) {
 
echo "<p>Mobile Phone Number: $Mphone_1</p>\n";
 
}
 
$Mphone_2 = filter_input(INPUT_POST, 'Mphone_2', FILTER_VALIDATE_INT);
 
if ($Mphone_2) {
 
echo "<p>Mobile Phone Number: $Mphone_2</p>\n";
 
}
 
$Mphone_3 = filter_input(INPUT_POST, 'Mphone_3', FILTER_VALIDATE_INT);
 
if ($Mphone_3) {
 
echo "<p>Mobile Phone Number: $Mphone_3</p>\n";
 
}
 
// Validate the Wphone number using FILTER_VALIDATE_INT:
 
 
$Wphone_1 = filter_input(INPUT_POST, 'Wphone_1', FILTER_VALIDATE_INT);
 
if ($Wphone_1) {
 
echo "<p>Work Phone Number: $Wphone_1</p>\n";
 
}
 
$Wphone_2 = filter_input(INPUT_POST, 'Wphone_2', FILTER_VALIDATE_INT);
 
if ($Wphone_2) {
 
echo "<p>Work Phone Number: $Wphone_2</p>\n";
 
}
$Wphone_3 = filter_input(INPUT_POST, 'Wphone_3', FILTER_VALIDATE_INT);
 
if ($Wphone_3) {
 
echo "<p>Work Phone Number: $Wphone_3</p>\n";
 
}
$Extension = filter_input(INPUT_POST, 'Hphone', FILTER_VALIDATE_INT);
 
if ($Extension) {
 
echo "<p>Ext: $Extension</p>\n";
 
}
 
}
 
 
mysql_query("INSERT INTO js_login(username, password, FName, MName, LName, Email) VALUES ('$username', '$password',
 '$FName', '$MName', '$LName', '$Email') ") or die(mysql_error());
 
mysql_query("INSERT INTO js_account(FName, MName, LName, Email, Address, Suite, City, State, Zipcode,
Country, Hphone_1, Hphone_2, Hphone_3, Mphone_1, Mphone_2, Mphone_3, Wphone_1, Wphone_2, Wphone_3, Extension)
VALUES ('$FName', '$MName', '$LName', '$Email','$Address', '$Suite', '$City', '$State', '$Zipcode',
'$Country', '$Hphone_1', '$Hphone_2', '$Hphone_3', '$Mphone_1', '$Mphone_2', '$Mphone_3', '$Wphone_1',
'$Wphone_2', '$Wphone_3', '$Extension') ") or die(mysql_error());
 
 
 
 
 
header("Location: login1.php");
 
echo "<table  border=0>
    <tr>
        <td valign=top width=350 >
<div>
<fieldset style=padding-left:18px; bgcolor=#00FF33> <legend><span class=style1>Log-in info: </span></legend>
<form method=POST action=js_new.php>
<span class=style4><IMG height=10 src=images/arrow_orange_trans.jpg                         width=12>Username:<BR>
<input name=username type=text   size=30 tabindex=1 maxlength=30><BR>
<IMG height=10 src=images/arrow_orange_trans.jpg                         width=12>Password:<BR>
<input name=password type=password  size=30 tabindex=2 maxlength=30><BR>
<IMG height=10 src=images/arrow_orange_trans.jpg                         width=12>Confirm Password:<BR>
<input name=conf_password type=PASSWORD  size=30 tabindex=3 maxlength=30><BR>
<IMG height=10 src=images/arrow_orange_trans.jpg                         width=12>First Name: <BR>
<input name=FName type=text  size=30 tabindex=4 maxlength=30><BR>
<IMG height=10 src=images/arrow_orange_trans.jpg                         width=12>Middle Name:<BR>
<input name=MName type=text size=30  tabindex=5 maxlength=30><BR>
<IMG height=10 src=images/arrow_orange_trans.jpg                         width=12>Last Name: <BR>
<input name=LName type=text size=30 tabindex=6 maxlength=30><BR>
<IMG height=10 src=images/arrow_orange_trans.jpg                         width=12>E-mail: <BR>
<input name=Email type=TEXT size=41 tabindex=7 maxlength=50><BR>
<IMG height=10 src=images/arrow_orange_trans.jpg                         width=12>Confirm Email: <BR>
<input name=conf_email type=text size=41 tabindex=8 maxlength=50></span><P>
</fieldset></td>
        <td width=350 valign=top height=350>
<fieldset style=padding-left:18px;> <legend><span class=style1>Account info: </span></legend><P>
<span class=style4><IMG height=10 src=images/arrow_orange_trans.jpg                         width=12>Address: <BR>
<INPUT name=Address type=text size=30 tabindex=9 maxlength=60><BR>
<span class=style4><IMG height=10 src=images/arrow_orange_trans.jpg                         width=12>Apartment/Suite: <BR>
<INPUT name=Suite type=text size=8 tabindex=10 maxlength=5><BR>
<IMG height=10 src=images/arrow_orange_trans.jpg                         width=12>City: <BR>
<INPUT name=City type=text  size=30  tabindex=11 maxlength=30><BR>
<IMG  src=images/arrow_orange_trans.jpg     height=10                    width=12>State/Province: <BR>
<INPUT name=State type=text  size=30  tabindex=12 maxlength=30><BR>
<IMG  src=images/arrow_orange_trans.jpg   height=10                      width=12>Zip Code:<BR>
<INPUT name=Zipcode type=text  size=30  tabindex=13 maxlength=20><BR>
<IMG  src=images/arrow_orange_trans.jpg  height=10                       width=12>Country: <BR>
<SELECT type=textbox name=Country tabindex=14 >
 
<OPTION value=USA>United States</OPTION>
<OPTION                           value=CAN>Canada</OPTION>
<OPTION                           value=AFG>Afghanistan</OPTION>
<OPTION                           value=ALB>Albania</OPTION>
<OPTION                           value=DZA>Algeria</OPTION>
<OPTION value=ASM>American                           Samoa</OPTION>
<OPTION value=AND>Andorra</OPTION>
<OPTION value=AGO>Angola</OPTION>
<OPTION value=AIA>Anguilla</OPTION>
<OPTION value=ATA>Antarctica</OPTION>
<OPTION value=ATG>Antigua And Barbuda</OPTION>
<OPTION value=ARG>Argentina</OPTION>
<OPTION value=ARM>Armenia</OPTION>
<OPTION value=ABW>Aruba</OPTION>
<OPTION value=AUS>Australia</OPTION>
<OPTION value=AUT>Austria</OPTION>
<OPTION value=AZE>Azerbaijan</OPTION>
<OPTION                           value=BHS>Bahamas</OPTION>
<OPTION                           value=BHR>Bahrain</OPTION>
<OPTION                           value=BGD>Bangladesh</OPTION>
<OPTION                           value=BRB>Barbados</OPTION>
<OPTION                           value=BLR>Belarus</OPTION>
<OPTION                           value=BEL>Belgium</OPTION>
<OPTION                           value=BLZ>Belize</OPTION>
<OPTION                           value=BEN>Benin</OPTION>
<OPTION                           value=BMU>Bermuda</OPTION>
<OPTION                           value=BTN>Bhutan</OPTION>
<OPTION                           value=BOL>Bolivia</OPTION>
<OPTION value=BIH>Bosnia                           And Herzegovina</OPTION>
<OPTION                           value=BWA>Botswana</OPTION>
<OPTION value=BVT>Bouvet                           Island</OPTION>
<OPTION value=BRA>Brazil</OPTION>
<OPTION value=IOT>British Indian Ocean                           Territory</OPTION>
<OPTION value=BRN>Brunei                           Darussalam</OPTION>
<OPTION                           value=BGR>Bulgaria</OPTION>
<OPTION value=BFA>Burkina                           Faso</OPTION>
<OPTION value=BDI>Burundi</OPTION>
<OPTION value=KHM>Cambodia</OPTION>
<OPTION                           value=CMR>Cameroon</OPTION>
<OPTION value=CPV>Cape                           Verde</OPTION>
<OPTION value=CYM>Cayman                           Islands</OPTION>
<OPTION value=CAF>Central African                           Republic</OPTION>
<OPTION value=TCD>Chad</OPTION>
<OPTION value=CHL>Chile</OPTION>
<OPTION                           value=CHN>China</OPTION>
<OPTION value=CXR>Christmas                           Island</OPTION>
<OPTION value=CCK>Cocos (Keeling)                           Islands</OPTION>
<OPTION value=COL>Colombia</OPTION>
<OPTION value=COM>Comoros</OPTION>
<OPTION                           value=COG>Congo</OPTION>
<OPTION value=COK>Cook                           Islands</OPTION>
<OPTION value=CRI>Costa Rica</OPTION>
<OPTION value=CIV>Cote Divoire</OPTION>
<OPTION                           value=HRV>Croatia (Local Name: Hrvatska)</OPTION>
<OPTION value=CUB>Cuba</OPTION>
<OPTION                           value=CYP>Cyprus</OPTION>
<OPTION value=CZE>Czech                           Republic</OPTION>
<OPTION value=ZAR>Democratic                           Republic of the Congo</OPTION>
<OPTION                           value=DNK>Denmark</OPTION>
<OPTION                           value=DJI>Djibouti</OPTION>
<OPTION                           value=DMA>Dominica</OPTION>
<OPTION                           value=DOM>Dominican Republic</OPTION>
<OPTION                           value=TMP>East Timor</OPTION>
<OPTION                           value=ECU>Ecuador</OPTION>
<OPTION                           value=EGY>Egypt</OPTION>
<OPTION value=SLV>El                           Salvador</OPTION>
<OPTION value=GNQ>Equatorial                           Guinea</OPTION>
<OPTION value=ERI>Eritrea</OPTION>
<OPTION value=EST>Estonia</OPTION>
<OPTION                           value=ETH>Ethiopia</OPTION>
<OPTION value=FLK>Falkland                           Islands (Malvinas)</OPTION>
<OPTION value=FRO>Faroe                           Islands</OPTION>
<OPTION value=FJI>Fiji</OPTION>
<OPTION value=FIN>Finland</OPTION>
<OPTION                           value=FRA>France</OPTION>
<OPTION value=GUF>French                           Guiana</OPTION>
<OPTION value=PYF>French                           Polynesia</OPTION>
<OPTION value=ATF>French Southern                           Territories</OPTION>
<OPTION value=GAB>Gabon</OPTION>
<OPTION value=GMB>Gambia</OPTION>
<OPTION                           value=GEO>Georgia</OPTION>
<OPTION                           value=DEU>Germany</OPTION>
<OPTION                           value=GHA>Ghana</OPTION>
<OPTION                           value=GIB>Gibraltar</OPTION>
<OPTION                           value=GRC>Greece</OPTION>
<OPTION                           value=GRL>Greenland</OPTION>
<OPTION                           value=GRD>Grenada</OPTION>
<OPTION                           value=GLP>Guadeloupe</OPTION>
<OPTION                           value=GUM>Guam</OPTION>
<OPTION                           value=GTM>Guatemala</OPTION>
<OPTION                           value=GIN>Guinea</OPTION>
<OPTION value=GNB>Guinea                           Bissau</OPTION>
<OPTION value=GUY>Guyana</OPTION>
<OPTION value=HTI>Haiti</OPTION>
<OPTION                           value=HMB>Heard And Mc Donald Islands</OPTION>
<OPTION        value=HND>Honduras</OPTION>
<OPTION value=HKG>Hong                           Kong</OPTION>
<OPTION value=HUN>Hungary</OPTION>
<OPTION value=ISL>Iceland</OPTION>
<OPTION                           value=IND>India</OPTION>
<OPTION                           value=IDN>Indonesia</OPTION>
<OPTION value=IRN>Iran                           (Islamic Republic Of)</OPTION>
<OPTION                           value=IRQ>Iraq</OPTION>
<OPTION                           value=IRL>Ireland</OPTION>
<OPTION                           value=ISR>Israel</OPTION>
<OPTION                           value=ITA>Italy</OPTION>
<OPTION                           value=JAM>Jamaica</OPTION>
<OPTION                           value=JPN>Japan</OPTION>
<OPTION                           value=JOR>Jordan</OPTION>
<OPTION                           value=KAZ>Kazakhstan</OPTION>
<OPTION                           value=KEN>Kenya</OPTION>
<OPTION                           value=KIR>Kiribati</OPTION>
<OPTION value=PRK>Korea,                           Democratic Peoples Republic OF</OPTION>
<OPTION                           value=KOR>Korea, Republic Of</OPTION>
<OPTION                           value=KWT>Kuwait</OPTION>
<OPTION                           value=KGZ>Kyrgyzstan</OPTION>
<OPTION value=LAO>Lao                           Peoples Democratic Republic</OPTION>
<OPTION                           value=LVA>Latvia</OPTION>
<OPTION                           value=LBN>Lebanon</OPTION>
<OPTION                           value=LSO>Lesotho</OPTION>
<OPTION                           value=LBR>Liberia</OPTION>
<OPTION value=LBY>Libyan                           Arab Jamahiriya</OPTION>
<OPTION                           value=LIE>Liechtenstein</OPTION>
<OPTION                           value=LTU>Lithuania</OPTION>
<OPTION                           value=LUX>Luxembourg</OPTION>
<OPTION                           value=MRC>Macau</OPTION>
<OPTION                           value=MKD>Macedonia</OPTION>
<OPTION                           value=MDG>Madagascar</OPTION>
<OPTION                           value=MWI>Malawi</OPTION>
<OPTION                           value=MYS>Malaysia</OPTION>
<OPTION                           value=MDV>Maldives</OPTION>
<OPTION                           value=MLI>Mali</OPTION>
<OPTION                           value=MLT>Malta</OPTION>
<OPTION value=MHL>Marshall                           Islands</OPTION>
<OPTION value=MTQ>Martinique</OPTION>
<OPTION value=MRT>Mauritania</OPTION>
<OPTION                           value=MUS>Mauritius</OPTION>
<OPTION                           value=MYT>Mayotte</OPTION>
<OPTION                           value=MEX>Mexico</OPTION>
<OPTION                           value=FSM>Micronesia, Federated States Of</OPTION>
<OPTION value=MDA>Moldova, Republic Of</OPTION>
<OPTION value=MCO>Monaco</OPTION>
<OPTION                           value=MNG>Mongolia</OPTION>
<OPTION                           value=MSR>Montserrat</OPTION>
<OPTION                           value=MAR>Morocco</OPTION>
<OPTION                           value=MOZ>Mozambique</OPTION>
<OPTION                           value=MMR>Myanmar</OPTION>
<OPTION                           value=NAM>Namibia</OPTION>
<OPTION                           value=NRU>Nauru</OPTION>
<OPTION                           value=NPL>Nepal</OPTION>
<OPTION                           value=NLD>Netherlands</OPTION>
<OPTION                           value=ANT>Netherlands Antilles</OPTION>
<OPTION                           value=NCL>New Caledonia</OPTION>
<OPTION value=NZL>New                           Zealand</OPTION>
<OPTION value=NIC>Nicaragua</OPTION>
<OPTION value=NER>Niger</OPTION>
<OPTION                           value=NGA>Nigeria</OPTION>
<OPTION                           value=NIU>Niue</OPTION>
<OPTION value=NFK>Norfolk                           Island</OPTION>
<OPTION value=MNP>Northern Mariana                           Islands</OPTION>
<OPTION value=NOR>Norway</OPTION>
<OPTION value=OMN>Oman</OPTION>
<OPTION                           value=PAK>Pakistan</OPTION>
<OPTION                           value=PLW>Palau</OPTION>
<OPTION value=PSE>Palestinian                           Territory, Occupied</OPTION>
<OPTION                           value=PAN>Panama</OPTION>
<OPTION value=PNG>Papua New                           Guinea</OPTION>
<OPTION value=PRY>Paraguay</OPTION>
<OPTION value=PER>Peru</OPTION>
<OPTION                           value=PHL>Philippines</OPTION>
<OPTION                           value=PCN>Pitcairn</OPTION>
<OPTION                           value=POL>Poland</OPTION>
<OPTION                           value=PRT>Portugal</OPTION>
<OPTION value=PRI>Puerto                           Rico</OPTION>
<OPTION value=QAT>Qatar</OPTION>
<OPTION                           value=REU>Reunion</OPTION>
<OPTION                           value=ROM>Romania</OPTION>
<OPTION value=RUS>Russian                           Federation</OPTION>
<OPTION value=RWA>Rwanda</OPTION>
<OPTION value=KNA>Saint Kitts And Nevis</OPTION>
<OPTION value=LCA>Saint Lucia</OPTION>
<OPTION                           value=VCT>Saint Vincent And The Grenadines</OPTION>
<OPTION value=WSM>Samoa</OPTION>
<OPTION value=SMR>San                           Marino</OPTION>
<OPTION value=STP>Sao Tome And                           Principe</OPTION>
<OPTION value=SAU>Saudi                           Arabia</OPTION>
<OPTION value=SEN>Senegal</OPTION>
<OPTION value=SME>Serbia and Montenegro</OPTION>
<OPTION value=SYC>Seychelles</OPTION>
<OPTION                           value=SLE>Sierra Leone</OPTION>
<OPTION                           value=SGP>Singapore</OPTION>
<OPTION                           value=SVK>Slovakia (Slovak Republic)</OPTION>
<OPTION                           value=SVN>Slovenia</OPTION>
<OPTION value=SLB>Solomon                           Islands</OPTION>
<OPTION value=SOM>Somalia</OPTION>
<OPTION value=ZAF>South Africa</OPTION>
<OPTION                           value=SGS>South Georgia</OPTION>
<OPTION                           value=ESP>Spain</OPTION>
<OPTION value=LKA>Sri                           Lanka</OPTION>
<OPTION value=SHN>St. Helena</OPTION>
<OPTION value=SPM>St. Pierre And Miquelon</OPTION>
<OPTION value=SDN>Sudan</OPTION>
<OPTION                           value=SUR>Suriname</OPTION>
<OPTION value=SJM>Svalbard                           And Jan Mayen Islands</OPTION>
<OPTION                           value=SWZ>Swaziland</OPTION>
<OPTION                           value=SWE>Sweden</OPTION>
<OPTION                           value=CHE>Switzerland</OPTION>
<OPTION                           value=SYR>Syrian Arab Republic</OPTION>
<OPTION                           value=TWN>Taiwan</OPTION>
<OPTION                           value=TJK>Tajikistan</OPTION>
<OPTION                           value=TZA>Tanzania, United Republic Of</OPTION>
<OPTION value=THA>Thailand</OPTION>
<OPTION                           value=TGO>Togo</OPTION>
<OPTION                           value=TKL>Tokelau</OPTION>
<OPTION                           value=TON>Tonga</OPTION>
<OPTION value=TTO>Trinidad                           And Tobago</OPTION>
<OPTION value=TUN>Tunisia</OPTION>
<OPTION value=TUR>Turkey</OPTION>
<OPTION                           value=TKM>Turkmenistan</OPTION>
<OPTION                           value=TCA>Turks And Caicos Islands</OPTION>
<OPTION                           value=TUV>Tuvalu</OPTION>
<OPTION                           value=UGA>Uganda</OPTION>
<OPTION                           value=UKR>Ukraine</OPTION>
<OPTION value=ARE>United                           Arab Emirates</OPTION>
<OPTION value=GBR>United                           Kingdom</OPTION>
<OPTION value=UMI>United States Minor                           Outlying Islands</OPTION>
<OPTION                           value=URY>Uruguay</OPTION>
<OPTION                           value=UZB>Uzbekistan</OPTION>
<OPTION                           value=VUT>Vanuatu</OPTION>
<OPTION value=VAT>Vatican                           City State (Holy See)</OPTION>
<OPTION                           value=VEN>Venezuela</OPTION>
<OPTION value=VNM>Viet                           Nam</OPTION>
<OPTION value=VGB>Virgin Islands                           (British)</OPTION>
<OPTION value=VIR>Virgin Islands                           (U.S.)</OPTION>
<OPTION value=WLF>Wallis And Futuna                           Islands</OPTION>
<OPTION value=ESH>Western                           Sahara</OPTION>
<OPTION value=YEM>Yemen</OPTION>
<OPTION value=YUG>Yugoslavia</OPTION>
<OPTION                           value=ZMB>Zambia</OPTION>
<OPTION                           value=ZWE>Zimbabwe</OPTION></SELECT> <BR>
<IMG height=10 src=images/arrow_orange_trans.jpg width=12>Home Phone: <BR>
(<INPUT name=Hphone_1 size=3 type=textbox maxlength=3 tabindex=15>) - <INPUT name=Hphone_2 size=3 type=textbox maxlength=3 tabindex=16> - <INPUT name=Hphone_3 size=4 type=textbox maxlength=4 tabindex=17><br>
<IMG height=10 src=images/arrow_orange_trans.jpg width=12>Mobile Phone: <BR>
(<INPUT name=Mphone_1 size=3 type=textbox maxlength=3 tabindex=18>) - <INPUT name=Mphone_2 size=3 type=textbox maxlength=3 tabindex=19> - <INPUT name=Mphone_3 size=4 type=textbox maxlength=4 tabindex=20><br>
 
<IMG height=10 src=images/arrow_orange_trans.jpg width=12>Work Phone: (optional)<BR>
(<INPUT name=Wphone_1 size=3 type=textbox maxlength=3 tabindex=21>) - <INPUT name=Wphone_2 size=3 type=textbox maxlength=3 tabindex=22> - <INPUT name=Wphone_3 size=4 type=textbox maxlength=4 tabindex=23> Ext: <INPUT name=extension size=5 type=textbox maxlength=5 tabindex=24><p>
 
<P>&nbsp;<P> <P></fieldset></td>
    </tr>
    <tr>
    <td colspan=2 align=right>
    <input type=hidden name=submitted value=true />
    <input type=submit name=submit value=Register />
    <input type=reset name=Reset value=Reset /></form></td>     </tr> </table>";
 
mysql_close();
?>
 
<? require('footer.html')?>
js_new.php is the name of this form. I keep getting an error message:

Warning: Cannot modify header information - headers already sent by (output started at .../form_header1.htm:8) in .../js_new.php on line 286

:banghead: Please enlighten this novice

Batoe
matthijs
DevNet Master
Posts: 3360
Joined: Thu Oct 06, 2005 3:57 pm

Re: How do I get my php form to go to next page after mysql?

Post by matthijs »

You should post this in the Code forum, not here in general discussion
gilley55
Forum Newbie
Posts: 11
Joined: Tue Aug 19, 2008 10:13 am

Re: How do I get my php form to go to next page after mysql?

Post by gilley55 »

I Made the Changes for you in red
in the future if you need to include other external files just do it the way i have it here. Do not put them in their own php tags like the following <?php require('form_header1.htm');?> thats wrong.

and if you want to go to the next page after the user uploads just put a link in the the upload button
make sure the link is the last thing in the upload code inside the button


1. <?php
require('form_header1.htm');
require('footer.html');

3. include 'open_jsnew.php';
4. if (isset($_POST['submitted']))
5. {
6. // Handle the form.
7.
8.
9. // Sanitize the input:
10.
11.
12.
13. $username = filter_input(INPUT_POST, 'username', FILTER_SANITIZE_STRING, FILTER_FLAG_NO_ENCODE_QUOTES);
14.
15. if ($username) {
16.
17. echo "<p>Username: $username<br />\$_POST['username']: {$_POST['username']}</p>\n";
18.
19. }
20. else {
21.
22. echo '<p class="error">Please enter your username.</p>';
23.
24. }
25.
26.
27.
28. $password = filter_input(INPUT_POST, 'password', FILTER_SANITIZE_STRING, FILTER_FLAG_NO_ENCODE_QUOTES);
29.
30. if ($password) {
31.
32. echo "<p>Password: $password<br />\$_POST['password']: {$_POST['password']}</p>\n";
33.
34. }
35. else {
36.
37. echo '<p class="error">Please enter your password.</p>';
38.
39. }
40.
41.
42.
43. $FName = filter_input(INPUT_POST, 'name', FILTER_SANITIZE_STRING, FILTER_FLAG_NO_ENCODE_QUOTES);
44.
45. if ($FName) {
46.
47. echo "<p>First Name: $FName<br />\$_POST['FName']: {$_POST['FName']}</p>\n";
48.
49. }
50. else {
51.
52. echo '<p class="error">Please enter your First Name.</p>';
53.
54. }
55.
56.
57.
58. $MName = filter_input(INPUT_POST, 'MName', FILTER_SANITIZE_STRING, FILTER_FLAG_NO_ENCODE_QUOTES);
59.
60. if ($MName) {
61.
62. echo "<p>Middle Name: $MName<br />\$_POST['MName']: {$_POST['MName']}</p>\n";
63.
64. }
65. else {
66.
67. echo '<p class="error">Please enter your Middle Name.</p>';
68.
69. }
70.
71.
72.
73. $LName = filter_input(INPUT_POST, 'LName', FILTER_SANITIZE_STRING, FILTER_FLAG_NO_ENCODE_QUOTES);
74.
75. if ($LName) {
76.
77. echo "<p> Last Name: $LName<br />\$_POST['LName']: {$_POST['LName']}</p>\n";
78.
79. }
80. else {
81.
82. echo '<p class="error">Please enter your Last Name.</p>';
83.
84. }
85.
86.
87.
88. // Validate the email address using FILTER_VALIDATE_EMAIL:
89.
90.
91. $Email = filter_input(INPUT_POST, 'Email', FILTER_VALIDATE_EMAIL);
92.
93. if ($Email) {
94.
95. echo "<p>E-mail Address: $Email</p>\n";
96.
97. }
98. else {
99.
100. echo '<p class="error">Please enter your E-mail Address.</p>';
101.
102. }
103.
104.
105.
106. $Address = filter_input(INPUT_POST, 'Address', FILTER_SANITIZE_STRING, FILTER_FLAG_NO_ENCODE_QUOTES);
107.
108. if ($Address) {
109.
110. echo "<p>Address: $Address<br />\$_POST['Address']: {$_POST['Address']}</p>\n";
111.
112. }
113. else {
114.
115. echo '<p class="error">Please enter your Address.</p>';
116.
117. }
118.
119.
120.
121. $Suite = filter_input(INPUT_POST, 'Suite', FILTER_SANITIZE_STRING, FILTER_FLAG_NO_ENCODE_QUOTES);
122.
123. if ($Suite) {
124.
125. echo "<p>Suite/Apartment: $Suite<br />\$_POST['Suite']: {$_POST['Suite']}</p>\n";
126.
127. }
128. else {
129.
130. echo '<p class="error">Please enter your Suite/Apartment.</p>';
131.
132. }
133.
134.
135.
136.
137. $City = filter_input(INPUT_POST, 'City', FILTER_SANITIZE_STRING, FILTER_FLAG_NO_ENCODE_QUOTES);
138.
139. if ($City) {
140.
141. echo "<p>City: $City<br />\$_POST['City']: {$_POST['City']}</p>\n";
142.
143. }
144. else {
145.
146. echo '<p class="error">Please enter your City.</p>';
147.
148. }
149.
150.
151.
152. $State = filter_input(INPUT_POST, 'State', FILTER_SANITIZE_STRING, FILTER_FLAG_NO_ENCODE_QUOTES);
153.
154. if ($State) {
155.
156. echo "<p>State: $State<br />\$_POST['State']: {$_POST['State']}</p>\n";
157.
158. }
159. else {
160.
161. echo '<p class="error">Please enter your State.</p>';
162.
163. }
164.
165.
166.
167. $Zipcode = filter_input(INPUT_POST, 'Zipcode', FILTER_VALIDATE_INT);
168.
169. if ($Zipcode) {
170.
171. echo "<p>Zip Code: $Zipcode</p>\n";
172.
173. }
174. else {
175.
176. echo '<p class="error">Please enter your Home Zip Code.</p>';
177.
178. }
179.
180.
181.
182.
183. // Validate the Hphone number using FILTER_VALIDATE_INT:
184.
185.
186. $Hphone_1 = filter_input(INPUT_POST, 'Hphone_1', FILTER_VALIDATE_INT);
187.
188. if ($Hphone_1) {
189.
190. echo "<p>Home Phone Number: $Hphone_1</p>\n";
191.
192. }
193.
194. $Hphone_2 = filter_input(INPUT_POST, 'Hphone_2', FILTER_VALIDATE_INT);
195.
196. if ($Hphone_2) {
197.
198. echo "<p>Home Phone Number: $Hphone_2</p>\n";
199.
200. }
201.
202. $Hphone_3 = filter_input(INPUT_POST, 'Hphone_3', FILTER_VALIDATE_INT);
203.
204. if ($Hphone_3) {
205.
206. echo "<p>Home Phone Number: $Hphone_3</p>\n";
207.
208. }
209.
210. // Validate the Mphone number using FILTER_VALIDATE_INT:
211.
212.
213. $Mphone_1 = filter_input(INPUT_POST, 'Mphone_1', FILTER_VALIDATE_INT);
214.
215. if ($Mphone_1) {
216.
217. echo "<p>Mobile Phone Number: $Mphone_1</p>\n";
218.
219. }
220.
221. $Mphone_2 = filter_input(INPUT_POST, 'Mphone_2', FILTER_VALIDATE_INT);
222.
223. if ($Mphone_2) {
224.
225. echo "<p>Mobile Phone Number: $Mphone_2</p>\n";
226.
227. }
228.
229. $Mphone_3 = filter_input(INPUT_POST, 'Mphone_3', FILTER_VALIDATE_INT);
230.
231. if ($Mphone_3) {
232.
233. echo "<p>Mobile Phone Number: $Mphone_3</p>\n";
234.
235. }
236.
237. // Validate the Wphone number using FILTER_VALIDATE_INT:
238.
239.
240. $Wphone_1 = filter_input(INPUT_POST, 'Wphone_1', FILTER_VALIDATE_INT);
241.
242. if ($Wphone_1) {
243.
244. echo "<p>Work Phone Number: $Wphone_1</p>\n";
245.
246. }
247.
248. $Wphone_2 = filter_input(INPUT_POST, 'Wphone_2', FILTER_VALIDATE_INT);
249.
250. if ($Wphone_2) {
251.
252. echo "<p>Work Phone Number: $Wphone_2</p>\n";
253.
254. }
255. $Wphone_3 = filter_input(INPUT_POST, 'Wphone_3', FILTER_VALIDATE_INT);
256.
257. if ($Wphone_3) {
258.
259. echo "<p>Work Phone Number: $Wphone_3</p>\n";
260.
261. }
262. $Extension = filter_input(INPUT_POST, 'Hphone', FILTER_VALIDATE_INT);
263.
264. if ($Extension) {
265.
266. echo "<p>Ext: $Extension</p>\n";
267.
268. }
269.
270. }
271.
272.
273. mysql_query("INSERT INTO js_login(username, password, FName, MName, LName, Email) VALUES ('$username', '$password',
274. '$FName', '$MName', '$LName', '$Email') ") or die(mysql_error());
275.
276. mysql_query("INSERT INTO js_account(FName, MName, LName, Email, Address, Suite, City, State, Zipcode,
277. Country, Hphone_1, Hphone_2, Hphone_3, Mphone_1, Mphone_2, Mphone_3, Wphone_1, Wphone_2, Wphone_3, Extension)
278. VALUES ('$FName', '$MName', '$LName', '$Email','$Address', '$Suite', '$City', '$State', '$Zipcode',
279. '$Country', '$Hphone_1', '$Hphone_2', '$Hphone_3', '$Mphone_1', '$Mphone_2', '$Mphone_3', '$Wphone_1',
280. '$Wphone_2', '$Wphone_3', '$Extension') ") or die(mysql_error());
281.
282.
283.
284.
285.
286. header("Location: login1.php");
287.
288. echo "<table border=0>
289. <tr>
290. <td valign=top width=350 >
291. <div>
292. <fieldset style=padding-left:18px; bgcolor=#00FF33> <legend><span class=style1>Log-in info: </span></legend>
293. <form method=POST action=js_new.php>
294. <span class=style4><IMG height=10 src=images/arrow_orange_trans.jpg width=12>Username:<BR>
295. <input name=username type=text size=30 tabindex=1 maxlength=30><BR>
296. <IMG height=10 src=images/arrow_orange_trans.jpg width=12>Password:<BR>
297. <input name=password type=password size=30 tabindex=2 maxlength=30><BR>
298. <IMG height=10 src=images/arrow_orange_trans.jpg width=12>Confirm Password:<BR>
299. <input name=conf_password type=PASSWORD size=30 tabindex=3 maxlength=30><BR>
300. <IMG height=10 src=images/arrow_orange_trans.jpg width=12>First Name: <BR>
301. <input name=FName type=text size=30 tabindex=4 maxlength=30><BR>
302. <IMG height=10 src=images/arrow_orange_trans.jpg width=12>Middle Name:<BR>
303. <input name=MName type=text size=30 tabindex=5 maxlength=30><BR>
304. <IMG height=10 src=images/arrow_orange_trans.jpg width=12>Last Name: <BR>
305. <input name=LName type=text size=30 tabindex=6 maxlength=30><BR>
306. <IMG height=10 src=images/arrow_orange_trans.jpg width=12>E-mail: <BR>
307. <input name=Email type=TEXT size=41 tabindex=7 maxlength=50><BR>
308. <IMG height=10 src=images/arrow_orange_trans.jpg width=12>Confirm Email: <BR>
309. <input name=conf_email type=text size=41 tabindex=8 maxlength=50></span><P>
310. </fieldset></td>
311. <td width=350 valign=top height=350>
312. <fieldset style=padding-left:18px;> <legend><span class=style1>Account info: </span></legend><P>
313. <span class=style4><IMG height=10 src=images/arrow_orange_trans.jpg width=12>Address: <BR>
314. <INPUT name=Address type=text size=30 tabindex=9 maxlength=60><BR>
315. <span class=style4><IMG height=10 src=images/arrow_orange_trans.jpg width=12>Apartment/Suite: <BR>
316. <INPUT name=Suite type=text size=8 tabindex=10 maxlength=5><BR>
317. <IMG height=10 src=images/arrow_orange_trans.jpg width=12>City: <BR>
318. <INPUT name=City type=text size=30 tabindex=11 maxlength=30><BR>
319. <IMG src=images/arrow_orange_trans.jpg height=10 width=12>State/Province: <BR>
320. <INPUT name=State type=text size=30 tabindex=12 maxlength=30><BR>
321. <IMG src=images/arrow_orange_trans.jpg height=10 width=12>Zip Code:<BR>
322. <INPUT name=Zipcode type=text size=30 tabindex=13 maxlength=20><BR>
323. <IMG src=images/arrow_orange_trans.jpg height=10 width=12>Country: <BR>
324. <SELECT type=textbox name=Country tabindex=14 >
325.
326. <OPTION value=USA>United States</OPTION>
327. <OPTION value=CAN>Canada</OPTION>
328. <OPTION value=AFG>Afghanistan</OPTION>
329. <OPTION value=ALB>Albania</OPTION>
330. <OPTION value=DZA>Algeria</OPTION>
331. <OPTION value=ASM>American Samoa</OPTION>
332. <OPTION value=AND>Andorra</OPTION>
333. <OPTION value=AGO>Angola</OPTION>
334. <OPTION value=AIA>Anguilla</OPTION>
335. <OPTION value=ATA>Antarctica</OPTION>
336. <OPTION value=ATG>Antigua And Barbuda</OPTION>
337. <OPTION value=ARG>Argentina</OPTION>
338. <OPTION value=ARM>Armenia</OPTION>
339. <OPTION value=ABW>Aruba</OPTION>
340. <OPTION value=AUS>Australia</OPTION>
341. <OPTION value=AUT>Austria</OPTION>
342. <OPTION value=AZE>Azerbaijan</OPTION>
343. <OPTION value=BHS>Bahamas</OPTION>
344. <OPTION value=BHR>Bahrain</OPTION>
345. <OPTION value=BGD>Bangladesh</OPTION>
346. <OPTION value=BRB>Barbados</OPTION>
347. <OPTION value=BLR>Belarus</OPTION>
348. <OPTION value=BEL>Belgium</OPTION>
349. <OPTION value=BLZ>Belize</OPTION>
350. <OPTION value=BEN>Benin</OPTION>
351. <OPTION value=BMU>Bermuda</OPTION>
352. <OPTION value=BTN>Bhutan</OPTION>
353. <OPTION value=BOL>Bolivia</OPTION>
354. <OPTION value=BIH>Bosnia And Herzegovina</OPTION>
355. <OPTION value=BWA>Botswana</OPTION>
356. <OPTION value=BVT>Bouvet Island</OPTION>
357. <OPTION value=BRA>Brazil</OPTION>
358. <OPTION value=IOT>British Indian Ocean Territory</OPTION>
359. <OPTION value=BRN>Brunei Darussalam</OPTION>
360. <OPTION value=BGR>Bulgaria</OPTION>
361. <OPTION value=BFA>Burkina Faso</OPTION>
362. <OPTION value=BDI>Burundi</OPTION>
363. <OPTION value=KHM>Cambodia</OPTION>
364. <OPTION value=CMR>Cameroon</OPTION>
365. <OPTION value=CPV>Cape Verde</OPTION>
366. <OPTION value=CYM>Cayman Islands</OPTION>
367. <OPTION value=CAF>Central African Republic</OPTION>
368. <OPTION value=TCD>Chad</OPTION>
369. <OPTION value=CHL>Chile</OPTION>
370. <OPTION value=CHN>China</OPTION>
371. <OPTION value=CXR>Christmas Island</OPTION>
372. <OPTION value=CCK>Cocos (Keeling) Islands</OPTION>
373. <OPTION value=COL>Colombia</OPTION>
374. <OPTION value=COM>Comoros</OPTION>
375. <OPTION value=COG>Congo</OPTION>
376. <OPTION value=COK>Cook Islands</OPTION>
377. <OPTION value=CRI>Costa Rica</OPTION>
378. <OPTION value=CIV>Cote Divoire</OPTION>
379. <OPTION value=HRV>Croatia (Local Name: Hrvatska)</OPTION>
380. <OPTION value=CUB>Cuba</OPTION>
381. <OPTION value=CYP>Cyprus</OPTION>
382. <OPTION value=CZE>Czech Republic</OPTION>
383. <OPTION value=ZAR>Democratic Republic of the Congo</OPTION>
384. <OPTION value=DNK>Denmark</OPTION>
385. <OPTION value=DJI>Djibouti</OPTION>
386. <OPTION value=DMA>Dominica</OPTION>
387. <OPTION value=DOM>Dominican Republic</OPTION>
388. <OPTION value=TMP>East Timor</OPTION>
389. <OPTION value=ECU>Ecuador</OPTION>
390. <OPTION value=EGY>Egypt</OPTION>
391. <OPTION value=SLV>El Salvador</OPTION>
392. <OPTION value=GNQ>Equatorial Guinea</OPTION>
393. <OPTION value=ERI>Eritrea</OPTION>
394. <OPTION value=EST>Estonia</OPTION>
395. <OPTION value=ETH>Ethiopia</OPTION>
396. <OPTION value=FLK>Falkland Islands (Malvinas)</OPTION>
397. <OPTION value=FRO>Faroe Islands</OPTION>
398. <OPTION value=FJI>Fiji</OPTION>
399. <OPTION value=FIN>Finland</OPTION>
400. <OPTION value=FRA>France</OPTION>
401. <OPTION value=GUF>French Guiana</OPTION>
402. <OPTION value=PYF>French Polynesia</OPTION>
403. <OPTION value=ATF>French Southern Territories</OPTION>
404. <OPTION value=GAB>Gabon</OPTION>
405. <OPTION value=GMB>Gambia</OPTION>
406. <OPTION value=GEO>Georgia</OPTION>
407. <OPTION value=DEU>Germany</OPTION>
408. <OPTION value=GHA>Ghana</OPTION>
409. <OPTION value=GIB>Gibraltar</OPTION>
410. <OPTION value=GRC>Greece</OPTION>
411. <OPTION value=GRL>Greenland</OPTION>
412. <OPTION value=GRD>Grenada</OPTION>
413. <OPTION value=GLP>Guadeloupe</OPTION>
414. <OPTION value=GUM>Guam</OPTION>
415. <OPTION value=GTM>Guatemala</OPTION>
416. <OPTION value=GIN>Guinea</OPTION>
417. <OPTION value=GNB>Guinea Bissau</OPTION>
418. <OPTION value=GUY>Guyana</OPTION>
419. <OPTION value=HTI>Haiti</OPTION>
420. <OPTION value=HMB>Heard And Mc Donald Islands</OPTION>
421. <OPTION value=HND>Honduras</OPTION>
422. <OPTION value=HKG>Hong Kong</OPTION>
423. <OPTION value=HUN>Hungary</OPTION>
424. <OPTION value=ISL>Iceland</OPTION>
425. <OPTION value=IND>India</OPTION>
426. <OPTION value=IDN>Indonesia</OPTION>
427. <OPTION value=IRN>Iran (Islamic Republic Of)</OPTION>
428. <OPTION value=IRQ>Iraq</OPTION>
429. <OPTION value=IRL>Ireland</OPTION>
430. <OPTION value=ISR>Israel</OPTION>
431. <OPTION value=ITA>Italy</OPTION>
432. <OPTION value=JAM>Jamaica</OPTION>
433. <OPTION value=JPN>Japan</OPTION>
434. <OPTION value=JOR>Jordan</OPTION>
435. <OPTION value=KAZ>Kazakhstan</OPTION>
436. <OPTION value=KEN>Kenya</OPTION>
437. <OPTION value=KIR>Kiribati</OPTION>
438. <OPTION value=PRK>Korea, Democratic Peoples Republic OF</OPTION>
439. <OPTION value=KOR>Korea, Republic Of</OPTION>
440. <OPTION value=KWT>Kuwait</OPTION>
441. <OPTION value=KGZ>Kyrgyzstan</OPTION>
442. <OPTION value=LAO>Lao Peoples Democratic Republic</OPTION>
443. <OPTION value=LVA>Latvia</OPTION>
444. <OPTION value=LBN>Lebanon</OPTION>
445. <OPTION value=LSO>Lesotho</OPTION>
446. <OPTION value=LBR>Liberia</OPTION>
447. <OPTION value=LBY>Libyan Arab Jamahiriya</OPTION>
448. <OPTION value=LIE>Liechtenstein</OPTION>
449. <OPTION value=LTU>Lithuania</OPTION>
450. <OPTION value=LUX>Luxembourg</OPTION>
451. <OPTION value=MRC>Macau</OPTION>
452. <OPTION value=MKD>Macedonia</OPTION>
453. <OPTION value=MDG>Madagascar</OPTION>
454. <OPTION value=MWI>Malawi</OPTION>
455. <OPTION value=MYS>Malaysia</OPTION>
456. <OPTION value=MDV>Maldives</OPTION>
457. <OPTION value=MLI>Mali</OPTION>
458. <OPTION value=MLT>Malta</OPTION>
459. <OPTION value=MHL>Marshall Islands</OPTION>
460. <OPTION value=MTQ>Martinique</OPTION>
461. <OPTION value=MRT>Mauritania</OPTION>
462. <OPTION value=MUS>Mauritius</OPTION>
463. <OPTION value=MYT>Mayotte</OPTION>
464. <OPTION value=MEX>Mexico</OPTION>
465. <OPTION value=FSM>Micronesia, Federated States Of</OPTION>
466. <OPTION value=MDA>Moldova, Republic Of</OPTION>
467. <OPTION value=MCO>Monaco</OPTION>
468. <OPTION value=MNG>Mongolia</OPTION>
469. <OPTION value=MSR>Montserrat</OPTION>
470. <OPTION value=MAR>Morocco</OPTION>
471. <OPTION value=MOZ>Mozambique</OPTION>
472. <OPTION value=MMR>Myanmar</OPTION>
473. <OPTION value=NAM>Namibia</OPTION>
474. <OPTION value=NRU>Nauru</OPTION>
475. <OPTION value=NPL>Nepal</OPTION>
476. <OPTION value=NLD>Netherlands</OPTION>
477. <OPTION value=ANT>Netherlands Antilles</OPTION>
478. <OPTION value=NCL>New Caledonia</OPTION>
479. <OPTION value=NZL>New Zealand</OPTION>
480. <OPTION value=NIC>Nicaragua</OPTION>
481. <OPTION value=NER>Niger</OPTION>
482. <OPTION value=NGA>Nigeria</OPTION>
483. <OPTION value=NIU>Niue</OPTION>
484. <OPTION value=NFK>Norfolk Island</OPTION>
485. <OPTION value=MNP>Northern Mariana Islands</OPTION>
486. <OPTION value=NOR>Norway</OPTION>
487. <OPTION value=OMN>Oman</OPTION>
488. <OPTION value=PAK>Pakistan</OPTION>
489. <OPTION value=PLW>Palau</OPTION>
490. <OPTION value=PSE>Palestinian Territory, Occupied</OPTION>
491. <OPTION value=PAN>Panama</OPTION>
492. <OPTION value=PNG>Papua New Guinea</OPTION>
493. <OPTION value=PRY>Paraguay</OPTION>
494. <OPTION value=PER>Peru</OPTION>
495. <OPTION value=PHL>Philippines</OPTION>
496. <OPTION value=PCN>Pitcairn</OPTION>
497. <OPTION value=POL>Poland</OPTION>
498. <OPTION value=PRT>Portugal</OPTION>
499. <OPTION value=PRI>Puerto Rico</OPTION>
500. <OPTION value=QAT>Qatar</OPTION>
501. <OPTION value=REU>Reunion</OPTION>
502. <OPTION value=ROM>Romania</OPTION>
503. <OPTION value=RUS>Russian Federation</OPTION>
504. <OPTION value=RWA>Rwanda</OPTION>
505. <OPTION value=KNA>Saint Kitts And Nevis</OPTION>
506. <OPTION value=LCA>Saint Lucia</OPTION>
507. <OPTION value=VCT>Saint Vincent And The Grenadines</OPTION>
508. <OPTION value=WSM>Samoa</OPTION>
509. <OPTION value=SMR>San Marino</OPTION>
510. <OPTION value=STP>Sao Tome And Principe</OPTION>
511. <OPTION value=SAU>Saudi Arabia</OPTION>
512. <OPTION value=SEN>Senegal</OPTION>
513. <OPTION value=SME>Serbia and Montenegro</OPTION>
514. <OPTION value=SYC>Seychelles</OPTION>
515. <OPTION value=SLE>Sierra Leone</OPTION>
516. <OPTION value=SGP>Singapore</OPTION>
517. <OPTION value=SVK>Slovakia (Slovak Republic)</OPTION>
518. <OPTION value=SVN>Slovenia</OPTION>
519. <OPTION value=SLB>Solomon Islands</OPTION>
520. <OPTION value=SOM>Somalia</OPTION>
521. <OPTION value=ZAF>South Africa</OPTION>
522. <OPTION value=SGS>South Georgia</OPTION>
523. <OPTION value=ESP>Spain</OPTION>
524. <OPTION value=LKA>Sri Lanka</OPTION>
525. <OPTION value=SHN>St. Helena</OPTION>
526. <OPTION value=SPM>St. Pierre And Miquelon</OPTION>
527. <OPTION value=SDN>Sudan</OPTION>
528. <OPTION value=SUR>Suriname</OPTION>
529. <OPTION value=SJM>Svalbard And Jan Mayen Islands</OPTION>
530. <OPTION value=SWZ>Swaziland</OPTION>
531. <OPTION value=SWE>Sweden</OPTION>
532. <OPTION value=CHE>Switzerland</OPTION>
533. <OPTION value=SYR>Syrian Arab Republic</OPTION>
534. <OPTION value=TWN>Taiwan</OPTION>
535. <OPTION value=TJK>Tajikistan</OPTION>
536. <OPTION value=TZA>Tanzania, United Republic Of</OPTION>
537. <OPTION value=THA>Thailand</OPTION>
538. <OPTION value=TGO>Togo</OPTION>
539. <OPTION value=TKL>Tokelau</OPTION>
540. <OPTION value=TON>Tonga</OPTION>
541. <OPTION value=TTO>Trinidad And Tobago</OPTION>
542. <OPTION value=TUN>Tunisia</OPTION>
543. <OPTION value=TUR>Turkey</OPTION>
544. <OPTION value=TKM>Turkmenistan</OPTION>
545. <OPTION value=TCA>Turks And Caicos Islands</OPTION>
546. <OPTION value=TUV>Tuvalu</OPTION>
547. <OPTION value=UGA>Uganda</OPTION>
548. <OPTION value=UKR>Ukraine</OPTION>
549. <OPTION value=ARE>United Arab Emirates</OPTION>
550. <OPTION value=GBR>United Kingdom</OPTION>
551. <OPTION value=UMI>United States Minor Outlying Islands</OPTION>
552. <OPTION value=URY>Uruguay</OPTION>
553. <OPTION value=UZB>Uzbekistan</OPTION>
554. <OPTION value=VUT>Vanuatu</OPTION>
555. <OPTION value=VAT>Vatican City State (Holy See)</OPTION>
556. <OPTION value=VEN>Venezuela</OPTION>
557. <OPTION value=VNM>Viet Nam</OPTION>
558. <OPTION value=VGB>Virgin Islands (British)</OPTION>
559. <OPTION value=VIR>Virgin Islands (U.S.)</OPTION>
560. <OPTION value=WLF>Wallis And Futuna Islands</OPTION>
561. <OPTION value=ESH>Western Sahara</OPTION>
562. <OPTION value=YEM>Yemen</OPTION>
563. <OPTION value=YUG>Yugoslavia</OPTION>
564. <OPTION value=ZMB>Zambia</OPTION>
565. <OPTION value=ZWE>Zimbabwe</OPTION></SELECT> <BR>
566. <IMG height=10 src=images/arrow_orange_trans.jpg width=12>Home Phone: <BR>
567. (<INPUT name=Hphone_1 size=3 type=textbox maxlength=3 tabindex=15>) - <INPUT name=Hphone_2 size=3 type=textbox maxlength=3 tabindex=16> - <INPUT name=Hphone_3 size=4 type=textbox maxlength=4 tabindex=17><br>
568. <IMG height=10 src=images/arrow_orange_trans.jpg width=12>Mobile Phone: <BR>
569. (<INPUT name=Mphone_1 size=3 type=textbox maxlength=3 tabindex=18>) - <INPUT name=Mphone_2 size=3 type=textbox maxlength=3 tabindex=19> - <INPUT name=Mphone_3 size=4 type=textbox maxlength=4 tabindex=20><br>
570.
571. <IMG height=10 src=images/arrow_orange_trans.jpg width=12>Work Phone: (optional)<BR>
572. (<INPUT name=Wphone_1 size=3 type=textbox maxlength=3 tabindex=21>) - <INPUT name=Wphone_2 size=3 type=textbox maxlength=3 tabindex=22> - <INPUT name=Wphone_3 size=4 type=textbox maxlength=4 tabindex=23> Ext: <INPUT name=extension size=5 type=textbox maxlength=5 tabindex=24><p>
573.
574. <P>&nbsp;<P> <P></fieldset></td>
575. </tr>
576. <tr>
577. <td colspan=2 align=right>
578. <input type=hidden name=submitted value=true />
579. <input type=submit name=submit value=Register />
580. <input type=reset name=Reset value=Reset /></form></td> </tr> </table>";
581.
582. mysql_close();
583. ?>
User avatar
cap2cap10
Forum Contributor
Posts: 158
Joined: Mon Apr 14, 2008 11:06 pm

Re: How do I get my php form to go to next page after mysql?

Post by cap2cap10 »

:banghead: Still doesn't work. I am still getting the same error.

Is there another way to link form to next page without using "header (location:.....)"?

Batoe
gilley55
Forum Newbie
Posts: 11
Joined: Tue Aug 19, 2008 10:13 am

Re: How do I get my php form to go to next page after mysql?

Post by gilley55 »

the second reason your code is not working has to do with your "form_header1.htm"
be resourcefulness and use google when you have an error. when you have an error you can't solve just copy the error as it is and paste it into a search engine. If the error is too long just copy a bit of it 99% of the time someone has already asked and got an answer
anyway here is a search i did for you http://www.kirupa.com/forum/showthread.php?t=265403

if the explanation there isn't clear enough do another search on google with your error
User avatar
cap2cap10
Forum Contributor
Posts: 158
Joined: Mon Apr 14, 2008 11:06 pm

Re: How do I get my php form to go to next page after mysql?

Post by cap2cap10 »

Thanks, I googled it and found the solution:

ob_start();

at the start of the code eliminates the error!

with:

ob_end_flush();

at the end.

Batoe :D
User avatar
JAB Creations
DevNet Resident
Posts: 2341
Joined: Thu Jan 13, 2005 6:44 pm
Location: Sarasota Florida
Contact:

Re: How do I get my php form to go to next page after mysql?

Post by JAB Creations »

I would either pass it through the form (questionable on client trust) or assign a URL string to a $_SESSION variable.
Post Reply