Jump to content

kessie

New Members
  • Content Count

    7
  • Joined

  • Last visited

Community Reputation

0 Neutral

About kessie

  • Rank
    Newbie
  1. at your table use the php echo function <tr> <th><?php echo $t; ?></th> <th><?php echo $p; ?></th> <th><?php echo $hum; ?></th> </tr>
  2. the code here looks okay, the problem could be at some other portion of the code. A thorough debugging could work. Take a time out to rest a bit and look into the code, I'm sure you'll find the problem.
  3. thank you guys, i have been able to fix the code. i guess i just had to do thorough debugging. And thanks a lot @psycho
  4. @psycho nothing is being inserted into the database and I'm only getting the custom error from the the if-else statement
  5. no errors, just the custom error message. all other fields are working, i guess, its just where i need to input the selected id
  6. Hey guys, I created a form which has both text fields and select fields. I am able to display the values in the dropdown select field but i'm having troubles getting the id when trying to insert it into the database. Here's the code <?php /* * assigning vars to fields */ if(isset($_POST['submit'])){ $surname = $_POST['surname']; $forenames = $_POST['forenames']; $dob = $_POST['dob']; $gender = $_POST['gender']; $domination = $_POST['domination']; $nationality = $_POST['nationality']; $address = $_POST['address']; $country = $_POST['country']; $accommodation = $_POST['accommodation']; $session = $_POST['session']; $connection = $_POST['connection']; $parent_name = $_POST['parent_name']; $profession = $_POST['profession']; $phone = $_POST['phone']; $email = $_POST['email']; /* * set error flag to false */ $error = false; /* * set validation checks */ if(!preg_match("/^['a-zA-Z ']+$/", $surname)){ $error = true; $surname_error = "surname should only contain alphabets!"; } if(!preg_match("/^['a-zA-Z ']+$/", $forenames)){ $error = true; $forenames_error = "forenames should only contain alphabets and space!"; } if(!preg_match("/^['a-zA-Z ']+$/", $domination)){ $error = true; $domination_error = "domination should only contain alphabets!"; }if(!preg_match("/^['a-zA-Z ']+$/", $parent_name)){ $error = true; $parent_name_error = "parent name should only contain alphabets!"; } if(!preg_match("/^['a-zA-Z ']+$/", $profession)){ $error = true; $profession_error = "profession should only contain alphabets!"; } if(strlen($phone)<11){ $error = true; $phone_error = "enter a valid phone number"; } if(!filter_var($email, FILTER_VALIDATE_EMAIL)){ $error = true; $email_error = "enter a valid email"; } /* * insert records into the database */ $query5 = "INSERT INTO candidate (surname,forenames,dob,gender_id,domination,nationality_id,address,country_id,accommodation_id,session,connection_id,) VALUES ('".$surname."','".$forenames."','".$dob."','".$gender."','".$domination."','".$nationality."','".$address."','".$country."','".$accommodation."','".$session."','".$connection."')" && " INSERT INTO `guardian` (parent_name,profession,phone,email) VALUES ('".$parent_name."','".$profession."','".$phone."','".$email."') "; if(!$error){ if($insert_record = $db->query($query5)){ $success_msg = "successfully inserted record"; }else{ $error_msg = "failed to insert record!"; } } } /* * Get gender from the database */ $query1 = "SELECT * FROM `gender`"; $stmt1 = $db->query($query1); /* * Get nationality from the database */ $query2 = "SELECT * FROM `nationality`"; $stmt2 = $db->query($query2); /* * Get accommodation type from the database */ $query3 = "SELECT * FROM `accommodation`"; $stmt3 = $db->query($query3); /* * Get connection from the database */ $query4 = "SELECT * FROM `connection`"; $stmt4 = $db->query($query4); /* * Get country from the database */ $query6 = "SELECT * FROM `country`"; $stmt6 = $db->query($query6); ?> <!-- form body --> <div class="container" style="margin-top: 5%;margin-bottom: 4%"> <form method="post" action="register.php" class="col-lg-5 col-lg-offset-3 well"> <span class="text-success"><?php if (isset($success_msg)) echo $success_msg;?></span> <span class="text-danger"><?php if (isset($error_msg)) echo $error_msg;?></span> <h1 style="text-align: center">Registeration Form</h1><br> <legend>Child's Details</legend> <div class="form-group"> <label for="surname">Surname</label> <input type="text" name="surname" placeholder="enter surname" class="form-control"> </div> <div class="form-group"> <label for="forenames">Forenames (in full)</label> <input type="text" name="forenames" placeholder="enter forenames" class="form-control"> </div> <div class="form-group"> <label for="dob">Date of Birth</label> <input type="Date" name="dob" class="form-control"> </div>urlogin info data <div class="form-group"> <label for="gender">Gender</label> <select name="gender" class="form-control"> <?php while($row1 = $stmt1->fetch(PDO::FETCH_ASSOC)): ?> <?php if($row1['gender_id'] == $_POST['gender']){ $selected = 'selected'; }else{ $selected = ''; } ?> <option <?php echo $selected; ?> value="<?php echo $row1['gender_id'];?>" ><?php echo $row1['gender_name'];?></option> <?php endwhile;?> </select> </div> <div class="form-group"> <label for="domination">Religious Domination</label> <input type="text" name="domination" placeholder="enter domination" class="form-control"> </div> <div class="form-group"> <label for="nationality">Nationality</label> <select name="nationality" class="form-control"> <?php while($row2 = $stmt2->fetch(PDO::FETCH_ASSOC)): ?> <?php if($row2['nationality_id'] == $_POST['nationality']){ $selected = 'selected'; }else{ $selected = ''; } ?> <option <?php echo $selected; ?> value="<?php echo $row2['nationality_id'];?>" ><?php echo $row2['nationality_name'];?></option> <?php endwhile;?> </select> </div> <div class="form-group"> <label for="address">Home Address</label> <textarea type="text" name="address" class="form-control"></textarea> </div> <div class="form-group"> <label for="country">Country of Birth</label> <select name="country" class="form-control"> <?php while($row6 = $stmt6->fetch(PDO::FETCH_ASSOC)): ?> <?php if($row6['country_id'] == $_POST['country']){ $selected = 'selected'; }else{ $selected = ''; } ?> <option <?php echo $selected; ?> value="<?php echo $row6['country_id'];?>" ><?php echo $row6['country_name'];?></option> <?php endwhile;?> </select> </div> <div class="form-group"> <label for="accommodation">Accommodation Type</label> <select name="accommodation" class="form-control"> <?php while($row3 = $stmt3->fetch(PDO::FETCH_ASSOC)): ?> <?php if($row3['accommodation_id'] == $_POST['accommodation']){ $selected = 'selected'; }else{ $selected = ''; } ?> <option <?php echo $selected; ?> value="<?php echo $row3['accommodation_id'];?>" ><?php echo $row3['accommodation_type'];?></option> <?php endwhile;?> </select> </div> <div class="form-group"> <label for="session">Proposed year and term of entry (e.g 2016, Summer)</label> <input type="text" name="session" placeholder="enter year and term" class="form-control"> </div> <div class="form-group"> <label for="connection">Have a Grange Connection?</label> <select name="connection" class="form-control"> <?php while($row4 = $stmt4->fetch(PDO::FETCH_ASSOC)): ?> <?php if($row4['connection_id'] == $_POST['connection']){ $selected = 'selected'; }else{ $selected = ' '; } ?> <option <?php echo $selected; ?> value="<?php echo $row4['connection_id'];?>" ><?php echo $row4['connection_name'];?></option> <?php endwhile;?> </select> </div> <br> <legend>Details of Parent/Guardians.</legend> <div class="form-group"> <label for="parent_name">Name of Parent/Legal Guardian</label> <input type="text" name="parent_name" placeholder="enter Parent's name" class="form-control"> </div> <div class="form-group"> <label for="profession">Profession</label> <input type="text" name="profession" placeholder="enter Parent's Profession" class="form-control"> </div> <div class="form-group"> <label for="phone">Mobile Telephone Number</label> <input type="Number" name="phone" placeholder="phone number" class="form-control"> </div> <div class="form-group"> <label for="email">Email Address</label> <input type="Email" name="email" placeholder="example@.com" class="form-control"> </div> <input type="submit" name="submit" value="Submit" class="btn btn-primary"> <input type="submit" name="cancel" value="Cancel" class="btn btn-default"> </form> </div> I want to be able to insert the id into the candidate table where gender_id, nationality_id, country_id, accommodation_id, connection_id are all foreign keys
  7. num_row is a php function() to get the total number of rows in a databse table. To achieve this in PDO, use the rowCount() function instead. $query = "SELECT * FROM database_table"; $result = $db->query($query); $total = $result->rowCount(); Hope this works for you
  8. kessie

    hello guys

    I'm Kessie and I'm new to php programming. I came across phpfreaks and was impressed about how willing and ready you guys are to help. I've been having issues with my project and really hope i can find the answers i need here. Thank you all for your help and advices in advance.
×
×
  • 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.