Form is not submitting to the databases
hello,
i'm having issue right now. click complete registration page on site.
https://www.encourageexcellence.org/registration.php
the values entered won't submit nor return error messages. show me i'm doing wrong? here code
[code]
<?php
if (isset($_post['submitted'])){
require_once('connections/encourage.php');
$fields = array(
'email',
'state',
'district',
'gender',
'age',
'profession',
);
if (safe($_post['survey']=="yes")){
$survey = "yes";
}
else{
$survey = "no";
}
foreach($fields $fieldname) {
if(isset($_post[$fieldname]) , safe(trim(stripslashes($_post[$fieldname]))) !==''){
$$fieldname = safe(trim(stripslashes($_post[$fieldname])));
}else {
$errors[] = "please enter your". $fieldname .""; //code validate fields
}
if(filter_var($email, filter_validate_email) == true){
} else {
$errors[] = 'please enter valid email address';
}
}
if(!isset($errors)){
$query = "select user_id participants email='$email'";
$result = mysql_query($query);
if(mysql_num_rows($result) == 0) {
$query = "insert participants (email, state, district, gender, age, profession, survey, registration_date)
values ('$email', '$state', '$district', '$gender', '$age', '$profession','$survey', now())"; //databasse connection
$result = mysql_query ($query);
if ($result){
$url = 'http://'. $_server['http_host'] . dirname($_server['php_self']);
if ((substr($url, -1) == '/') || (substr($url, -1) == '\\')) {
$url = substr ($url, 0, -1);
}
$url .= '/thanks.php';
header("location: $url"); //this line of error reporting after submitting database
exit();
} else {
$errors[] = 'you not registered due system error. apologize inconvenience.';
$errors[] = mysql_error() . '<br /><br />query: ' . $query;
}
} else {
$errors[] = 'the email address has been registered.';
}
}
mysql_close();
} else {
$errors = null;
}
if (!empty($errors)){
echo '<h1 id="mainhead">error!</h1>
<p class="error">the following error(s) occurred:<br />';
foreach($errors $msg) {
echo " - $msg<br/>\n";
}
echo '</p><p>please try again.</p><p><br/></p>';
}
function safe($string)
{
$pattern = "/\r|\n|\%0a|\%0d|content\-type:|bcc:|to:|cc:/i";
return preg_replace($pattern, '', $string);
}
?>
<!----html code-->
<form id="form1" name="form1" method="post" action"registration.php">
<fieldset class="first">
<label class="email" for="email">email:* </label>
<input name="email" value="<?php if(isset($_post['email'])) echo $_post['email'];?>"/>
<label for="state"/>state:* </label>
<input name="state" value="<?php if(isset($_post['state'])) echo $_post['state'];?>"/>
<label for="schooldistrict"/>school district:* </label>
<input name="district" value="<?php if(isset($_post['district'])) echo $_post['district'];?>" />
<label for="gender">gender:* </label>
<select name="gender">
<option>choose gender</option>
<option value="male" <?php echo ($form['gender'] == 'male' ? ' selected' : ''); ?>>male</option>
<option value="female"<?php echo ($form['gender'] == 'female' ? ' selected' : ''); ?>>female</option>
</select>
<label for="age"/>your age:* </label>
<input name="age" type="text" class="age" maxlength="2" value="<?php if(isset($_post['age'])) echo $_post['age'];?>" />
<label for="profession"/>profession:* </label>
<input name="profession" value="<?php if(isset($_post['profession'])) echo $_post['profession'];?>" />
<label for="survey"/>willingness participate in future surveys:</label>
<input name="survey" type="checkbox" value="yes" />
</fieldset>
<fieldset>
<input name="submit" type="submit" class="btn1" value="complete registration" />
<input class="btn" name="reset" type="reset" value="clear form" />
<input type="hidden" name="submitted" value="true" />
</fieldset>
</form>
[/code]
thanks in advanced!
the form html incorrect.
<form id="form1" name="form1" method="post" action"registration.php">
you're missing a = after action
More discussions in Develop server-side applications in Dreamweaver
adobe
Comments
Post a Comment