Hello all I have been everywhere and cannot get any help I have created a registration for and its functioning and sending data to the database… however I am having issues
when I run the script it gives this error on all 5 fields
Notice: Undefined variable: confirmemailErr in C:\Program Files (x86)\Zend\Apache2\htdocs\DC\create.php on line 121
all 5 fields have same notice but if I click submit with fields empty the error clears and displays properly
this statement in my html is causing this error <?php echo $confirmemailErr;?>
now on top of that I have a query to tell me if the username is taken same for the email field it works but then stops ive been on this for about 4 days and just running in circles
[php]<?php
include_once (‘includes/db_config.php’);
include “includes/header.php”;
include “includes/footer.php”;
if (isset($_POST[‘submit’])) {
$email = $_POST['email'];
$email_confirmation = $_POST['email_confirmation'];
$soldier_name = $_POST['soldier_name'];
$birthdate = $_POST['birthdate'];
$country = $_POST['country'];
$date = date("Y-m-d H:i:s");
$emailErr = $confirmemailErr = $soldierErr = $birthdateErr = $countryErr = "";
function check_input($data, $problem = '')
{
$data = trim($data);
$data = stripslashes($data);
$data = htmlspecialchars($data);
if ($problem && strlen($data) == 0) {
die($problem);
}
return $data;
}
if (empty($_POST["email"])) {
$emailErr = "Email is required";
} else {
$email = check_input($_POST["email"]);
if (! filter_var($email, FILTER_VALIDATE_EMAIL)) {
$emailErr = "Invalid email format";
}
}
if (empty($_POST["email_confirmation"])) {
$confirmemailErr = "email confirmation is required";
if (isset($email, $email_confirmation) && $email != $email_confirmation)
$confirmemailErr = "email confirmation dont match";
} else {
$email_confirmation = check_input($_POST["email_confirmation"]);
}
if (empty($_POST["soldier_name"])) {
$soldierErr = "Soldier Name is required";
} else {
$soldier_name = check_input($_POST["soldier_name"]);
}
if (empty($_POST["birthdate"])) {
$birthdateErr = "birthdate is required";
} else {
$birthdate = check_input($_POST["birthdate"]);
}
if (empty($_POST["country"])) {
$countryErr = "country is required";
} else {
$country = check_input($_POST["country"]);
}
$email = mysqli_real_escape_string($connection, $email);
$soldier_name = mysqli_real_escape_string($connection, $soldier_name);
$birthdate = mysqli_real_escape_string($connection, $birthdate);
$country = mysqli_real_escape_string($connection, $country);
$query = mysqli_query($connection, "SELECT * FROM soldiers WHERE soldier_email='" . $email . "'");
if (mysqli_num_rows($query) > 0) {
$emailErr = "email is in use";
$query = mysqli_query($connection, "SELECT * FROM soldiers WHERE soldier='" . $soldier_name . "'");
if (mysqli_num_rows($query) > 0) {
$soldierErr = "soldier name is taken";
}
}
$query = "INSERT INTO soldiers (soldier_email, soldier, soldier_birthdate, soldier_country, soldier_regdate)";
$query .= "VALUES('{$email}','{$soldier_name}', '{$birthdate}', '{$country}', '{$date}')";
}
?>
Register Your Soldier Name
<input class="form-control" type="text" id="email" name="email" value="<?php echo $email;?>"><span class="error" ><?php echo $emailErr;?></span>
</div>
<div class="form-group">
<label>Confirm Email</label>
<input class="form-control" type="text" id="email_confirmation" name="email_confirmation"><span class="error" ><?php echo $confirmemailErr;?></span>
</div>
<div class="form-group"><span class="status"></span>
<label>Soldier Name</label><span id="soldier_status"></span>
<input class="form-control" type="text" id="soldier_name" name="soldier_name" value="<?php echo $soldier_name;?>"><span class="error"><?php echo $soldierErr;?></span>
</div>
<div class="form-group">
<label>Birthdate</label>
<input class="form-control" type="text" id="birthdate" name="birthdate"><span class="error"><?php echo $birthdateErr;?></span>
</div>
<div class="form-group">
<label>Country</label>
<select class="form-control" id="country" name="country">
<option selected value="">Please select your country</option>
<option value="1">Afghanistan</option>
<option value="2">Albania</option>
<option value="3">Algeria</option>
<option value="4">American Samoa</option>
<option value="5">Andorra</option>
<option value="6">Antarctica</option>
<option value="7">Argentina</option>
<option value="8">Armenia</option>
<option value="9">Aruba</option>
<option value="10">Australia</option>
<option value="11">Austria</option>
<option value="12">Bahamas</option>
<option value="13">Barbados</option>
<option value="14">Belgium</option>
<option value="15">Bermuda</option>
<option value="16">Bolivia</option>
<option value="17">Bosnia</option>
<option value="18">Brazil</option>
<option value="20">Cambodia</option>
<option value="21">Canada</option>
<option value="22">Cayman Islands</option>
<option value="23">Chile</option>
<option value="24">China</option>
<option value="25">Colombia</option>
<option value="26">Costa Rica</option>
<option value="27">Cuba</option>
<option value="28">Czech Republic</option>
<option value="29">Denmark</option>
<option value="30">Dominica</option>
<option value="31">Dominican Republic</option>
<option value="32">Ecuador</option>
<option value="33">Egypt</option>
<option value="34">El Salvador</option>
<option value="35">England</option>
<option value="36">Europe</option>
<option value="37">Finland</option>
<option value="38">France</option>
<option value="39">Georgia</option>
<option value="40">Germany</option>
<option value="41">Gibraltar</option>
<option value="42">Greece</option>
<option value="43">Greenland</option>
<option value="44">Hong Kong</option>
<option value="45">Hungary</option>
<option value="46">Iceland</option>
<option value="47">India</option>
<option value="48">Iran</option>
<option value="49">Iraq</option>
<option value="50">Ireland</option>
<option value="51">Israel</option>
<option value="52">Italy</option>
<option value="53">Jamaica</option>
<option value="54">Japan</option>
<option value="55">Jordan</option>
<option value="56">Kenya</option>
<option value="57">Kuwait</option>
<option value="58">Lebanon</option>
<option value="59">Liberia</option>
<option value="60">Libya</option>
<option value="61">Malaysia</option>
<option value="62">Mexico</option>
<option value="63">Morocco</option>
<option value="64">Netherlands</option>
<option value="65">New Zealand</option>
<option value="66">Nigeria</option>
<option value="67">Norway</option>
<option value="68">Pakistan</option>
<option value="69">Palestine</option>
<option value="70">Panama</option>
<option value="71">Peru</option>
<option value="72">Poland</option>
<option value="73">Portugal</option>
<option value="74">Puerto Rico</option>
<option value="75">Qatar</option>
<option value="76">Romania</option>
<option value="77">Russia</option>
<option value="78">Saudi arabia</option>
<option value="79">Scotland</option>
<option value="80">Slovakia</option>
<option value="81">Slovenia</option>
<option value="82">Somalia</option>
<option value="83">South Africa</option>
<option value="84">South Georgia</option>
<option value="85">Spain</option>
<option value="86">Sudan</option>
<option value="87">Swaziland</option>
<option value="88">Sweden</option>
<option value="89">Switzerland</option>
<option value="90">Syria</option>
<option value="91">Taiwan</option>
<option value="92">Thailand</option>
<option value="93">Trinidad</option>
<option value="94">Turkey</option>
<option value="95">Ukraine</option>
<option value="96">United Arab Emirates</option>
<option value="97">United Kingdom</option>
<option value="98">United States</option>
<option value="99">Virgin Islands (British)</option>
<option value="100">Virgin Islands (U.S.)</option>
</select><span class="error"><?php echo $countryErr;?></span>
</div>
<input type="submit" name="submit" id="btn-login" class="btn btn-custom btn-lg btn-block" value="submit">
</form>
</div>