Jump to content

Need help with this form processing script

kevinkhan

By kevinkhan
in PHP Coding Help

 Share

Recommended Posts

kevinkhan Regular Member

kevinkhan

Posted
Posted

When i click submit.. A blank page is returned.. I want the same form to be returned and the $message to be displayed on top of the form.. Can anyone tell me what is wrong with this code ??

 

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
	<meta http-equiv="content-type" content="text/html; charset=utf-8" />
	<title>Event Promotion</title>


<!-- 
	<script type="text/javascript" src="js/validation.js"></script>
-->

</head>
<body>
   <?php  
  $dbHost = 'xxxx';
$dbName = 'xxxx';	
$dbUser = 'xxxx';
$dbPass = 'xxxx';


$conn = mysql_connect($dbHost, $dbUser, $dbPass) or die('Error connecting to mysql'.mysql_error());
mysql_select_db($dbName);


function confirm_query($result_set)
  {
  if (!$result_set)
    {
    die("Database query failed " . mysql_error());
    }
  }
   
   if(isset($_POST['submit']))
        {
      // echo "hello";
          $firstName = mysql_prep($_POST['firstName']);
          $lastName = trim(mysql_prep($_POST['lastName']));
          $mobile = mysql_prep($_POST['mobile']);
          $email = mysql_prep($_POST['email']);
          $county = trim(mysql_prep($_POST['county']));
          $dateOfBirth = mysql_prep($_POST['date3']."-".$_POST['date2']."-".$_POST['date1']);
          $gender = trim(mysql_prep($_POST['gender']));
          $events = implode(', ', $_POST['events']);
          $comments = trim(mysql_prep($_POST['comments']));
          
          
          echo $firstName;
          
             
          $query = "INSERT INTO user
                    (
                    firstName,lastName,mobile,email,county,dateOfBirth,gender,comments,events
                    )
                    VALUES
                    (
                    '{$firstName}','{$lastName}','{$mobile}','{$email}','{$county}','{$dateOfBirth}','{$gender}','{$events}','{$comments}'
                    )";
             
   
                  
           $result = mysql_query($query, $conn);
          
           confirm_query($result);
            if(mysql_affected_rows() ==1)
            {
            // Success
            $message = "Thanks for submitting your details.";
            echo "<p class=\"errorMessage\">".$message."</p>";
            }
            else
            {
            // Failed
            $message = "The page update failed.";
            $message .= "<br />". mysql_error();
            }
            
            
          }
        
          
?>        

						<form name="frm" action="index.php" method="POST">
						<table width="100%" border="0" cellspacing="2" cellpadding="3"  class="mainForm">
							<tr>
							<td class="normalText" align="left" style="padding:0px 0px 0px 33px">
								<table border="0" cellspacing="3" cellpadding="2">
									<tr>
										<td class="normalHeading" colspan="2" style="padding-bottom:6px">
											Join Our Mailing List
											<div id="error_msg" class="txtErrorMsg" align="center"> </div>
											<?php echo "<p>".$message."</p>"?>
										</td>
									</tr>
									<tr>
										<td class="normalText" width="30%">First Name</td>
										<td><input type="text" name="firstName" id="firstName"  class="input1" style="width:195px" maxlength="10"/></td>
									</tr>
									<tr>
										<td class="normalText">Last Name</td>
										<td><input type="text" name="lastName" id="lastName" class="input1" style="width:195px" maxlength="10"/></td>
									</tr>
									<tr>
										<td class="normalText">Mobile</td>
										<td><input type="text" name="mobile"  id="mobile" class="input1"  style="width:195px" maxlength="10" onkeypress="return fnIsIntNumber(event,this);"/></td>
									</tr>
									<tr>
										<td class="normalText">E mail</td>
										<td><input type="text" name="email" id="email" class="input1"  style="width:195px" onblur="IsEmail(this.vlaue)"/></td>
									</tr>
									<tr>
										<td class="normalText">Home Town</td>
										<td>
											<select name="county" id="county"  style="width:197px;height:24px"> 
												<option value="0">--- Select ---</option>
												<option value="Antrim">Antrim</option>
												<option value=Armagh>Armagh</option>
												<option value=Carlow>Carlow</option>
												<option value=Cavan>Cavan</option>
												<option value=Clare>Clare</option>
												<option value=Cork>Cork</option>
												<option value=Derry>Derry</option>
												<option value=Donegal>Donegal</option>
												<option value=Down>Down</option>
												<option value=Dublin>Dublin</option>
												<option value=Fermanagh>Fermanagh</option>
												<option value=Galway>Galway</option>
												<option value=Kerry>Kerry</option>
												<option value=Kildare>Kildare</option>
												<option value=Kilkenny>Kilkenny</option>
												<option value=Laois>Laois</option>
												<option value=Leitrim>Leitrim</option>
												<option value=Limerick>Limerick</option>
												<option value=Longford>Longford</option>
												<option value=Louth>Louth</option>
												<option value=Mayo>Mayo</option>
												<option value=Meath>Meath</option>
												<option value=Monaghan>Monaghan</option>
												<option value=Offaly>Offaly</option>
												<option value=Roscommon>Roscommon</option>
												<option value=Sligo>Sligo</option>
												<option value=Tipperary>Tipperary</option>
												<option value=Tyrone>Tyrone</option>
												<option value=Waterford>Waterford</option>
												<option value=Westmeath>Westmeath</option>
												<option value=Wexford>Wexford</option>
												<option value=Wicklow>Wicklow</option>
											</select>
										</td>
									</tr>
									<tr>
										<td class="normalText">Date Of Birth</td>
										<td>
											<select name="date1" style="width:43px"> 
												<option value=1>1</option><option value=2>2</option><option value=3>3</option><option value=4>4</option><option value=5>5</option><option value=6>6</option><option value=7>7</option><option value=8>8</option><option value=9>9</option><option value=10>10</option><option value=11>11</option><option value=12>12</option><option value=13>13</option><option value=14>14</option><option value=15>15</option><option value=16>16</option><option value=17>17</option><option value=18>18</option><option value=19>19</option><option value=20>20</option><option value=21>21</option><option value=22>22</option><option value=23>23</option><option value=24>24</option><option value=25>25</option><option value=26>26</option><option value=27>27</option><option value=28>28</option><option value=29>29</option><option value=30>30</option><option value=31>31</option>  
											</select>
											<select name="date2" style="width:43px"> 
												<option value=1>1</option><option value=2>2</option><option value=3>3</option><option value=4>4</option><option value=5>5</option><option value=6>6</option><option value=7>7</option><option value=8>8</option><option value=9>9</option><option value=10>10</option><option value=11>11</option><option value=12>12</option>  
											</select>
											<select  name="date3" style="width:106px"> 
												<option value=1955>1955</option><option value=1956>1956</option><option value=1957>1957</option><option value=1958>1958</option><option value=1959>1959</option><option value=1960>1960</option><option value=1961>1961</option><option value=1962>1962</option><option value=1963>1963</option><option value=1964>1964</option><option value=1965>1965</option><option value=1966>1966</option><option value=1967>1967</option><option value=1968>1968</option><option value=1969>1969</option><option value=1970>1970</option><option value=1971>1971</option><option value=1972>1972</option><option value=1973>1973</option><option value=1974>1974</option><option value=1975>1975</option><option value=1976>1976</option><option value=1977>1977</option><option value=1978>1978</option><option value=1979>1979</option><option value=1980>1980</option><option value=1981>1981</option><option value=1982>1982</option><option value=1983>1983</option><option value=1984>1984</option><option value=1985>1985</option><option value=1986>1986</option><option value=1987>1987</option><option value=1988>1988</option><option value=1989>1989</option><option value=1990>1990</option><option value=1991>1991</option><option value=1992>1992</option><option value=1993>1993</option><option value=1994>1994</option><option value=1995>1995</option><option value=1996>1996</option><option value=1997>1997</option><option value=1998>1998</option><option value=1999>1999</option><option value=2000>2000</option><option value=2001>2001</option><option value=2002>2002</option><option value=2003>2003</option><option value=2004>2004</option><option value=2005>2005</option><option value=2006>2006</option><option value=2007>2007</option><option value=2008>2008</option><option value=2009>2009</option><option value=2010>2010</option>  
											</select>
										</td>
									</tr>
									<tr>
										<td class="normalText">Gender</td>
										<td valign="middle" valign="middle">
											<input type="radio" name="gender" id="genderM" value="1" /> Male    
											<input type="radio" name="gender" id="genderFM" value="0" checked/> Female
										</td>
									</tr>
										<tr>
										<td class="normalText">Comments</td>
										<td>
											<textarea name="comments" id="comment" cols="22" rows="3" ></textarea>    
										</td>
									</tr>
									<tr>
										<td class="normalText" valign="top">Events you<br /> would be <br />interested in</td>
										<td valign="middle" align="left" style="margin: 0px">
											<table border="0" cellspacing="0" cellpadding="0" style="margin:0px" class="tblEvents">
												<tr>
													<td><input class="events" type="checkbox"  name="events[]" value="Teenage Discos" />  Teenage Discos</td>
													<td><input class="events" type="checkbox"  name="events[]"  value="Concerts" />  Concerts</td>
												</tr>
												<tr>
													<td><input class="events" type="checkbox"  name="events[]"  value="Club Nights" />  Club Nights</td>
													<td><input class="events" type="checkbox"  name="events[]"  value="70s Nights" />  70s Nights</td>
												</tr>
												<tr>
													<td><input class="events" type="checkbox"  name="events[]"  value="80s Nights" />  80s Nights</td>
													<td><input class="events" type="checkbox"  name="events[]"  value="Circuses" />  Circuses</td>
												</tr>
												<tr>
													<td><input class="events" type="checkbox"  name="events[]"  value="Funderland" />  Funderland</td>
													<td><input class="events" type="checkbox"  name="events[]"  value="Matches" />  Sports Events<br /></td>
												</tr>
											</table>
										</td>
									</tr>
									<tr>
										<td class="normalText"> </td>
										<td valign="middle"><input class="send" type="image" value='submit' src="images/submit.gif" name="submit" onclick="return validchk();"/></td>
									</tr>
								</table>
							</td>
						</tr>
					</table>
					</form>						

</body>
</html>
<?php   mysql_close($conn); ?>

PFMaBiSmAd Advanced Member

PFMaBiSmAd

Posted
Posted

Your code does not define the function mysql_prep(), either directly or through an include/require statement, so you are getting a fatal runtime error.

 

You should be developing and debugging php code on a system with error_reporting set to E_ALL and display_errors set to ON in your php.ini so that php would help you by displaying all the errors it detects. You would save a TON of time.

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.