Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!doctype html>
- <html>
- <head>
- <meta charset="utf-8">
- <title>International Marketing Group</title>
- <link href="css/style.css" rel="stylesheet" type="text/css">
- <link href="css/navigation.css" rel="stylesheet" type="text/css">
- <script type="text/javascript" src="js/jquery-1.9.0.min.js"></script>
- <script type="text/javascript" src="js/move-top.js"></script>
- <script type="text/javascript">
- $(document).ready(function() {
- $().UItoTop({ easingType: 'easeOutQuart' });
- });
- </script>
- <a href="#" id="toTop"> </a>
- <script type="text/javascript" src="js/navigation.js"></script>
- </head>
- <body>
- <div>
- <img src="img/img.png" class="greatings" width="940" height="78">
- </div>
- <div class="navigation">
- <ul class="nav">
- <li><a href="home.php">Home</a></li>
- <li class="test"><a href="#">Membership Form</a>
- <ul>
- <li><a href="form.php">Add Member</a></li>
- <li><a href="editall.php">Edit Member</a></li>
- <li><a href="viewalldelete.php">Delete Member</a></li>
- </ul>
- </li>
- <li><a href="viewall.php">Show All Members</a></li>
- <li><a href="#">Contact Us</a></li>
- <li><a class="logout" href="logout.php">Logout</a></li>
- </ul>
- <span class="left-ribbon"> </span>
- <span class="right-ribbon"> </span>
- </div>
- <?php
- $con = mysql_connect("localhost","root","") or die("Cannot connect to server");
- mysql_select_db("form",$con) or die("Cannot connect to the database");
- $id = $_GET['id'];
- $sql1 = "SELECT * FROM personal_tbl WHERE no = $id"; $result1 = mysql_query($sql1, $con); $row1 = mysql_fetch_array($result1);
- $sql2 = "SELECT * FROM educ_tbl WHERE no = $id"; $result2 = mysql_query($sql2, $con); $row2 = mysql_fetch_array($result2);
- $sql3 = "SELECT * FROM employ_tbl WHERE no = $id"; $result3 = mysql_query($sql3, $con); $row3 = mysql_fetch_array($result3);
- $sql4 = "SELECT * FROM heirar_tbl WHERE no = $id"; $result4 = mysql_query($sql4, $con); $row4 = mysql_fetch_array($result4);
- $sql5 = "SELECT * FROM have_tbl WHERE no = $id"; $result5 = mysql_query($sql5, $con); $row5 = mysql_fetch_array($result5);
- $gender = $row['gender'];
- $cstatus = $row['cstatus'];
- $gender = $row['gender'];
- ?>
- <!--######################################################################################################################################-->
- <h2 class="add"><-------------------- Add Membership Form --------------------></h2>
- <div id="form">
- <img class="logo" src="img/img-logo.jpg" width="250px" height="100">
- <p id="toptext">APPLICATION FOR MEMBERSHIP WITH IMG</p>
- <form method="post">
- <div class="idnum">
- <label class="id">No.</label>
- <input class="id1" type="text" name="no" placeholder="ID Number Here" value='<?php echo $_GET['id']; ?>'>
- </div>
- <!--######################################################################################################################################-->
- <p class="midtext">PLEASE PRINT ALL ANSWERS</p>
- <fieldset id="personalbox">
- <legend class="personal"><b>PERSONAL INFORMATION</b></legend>
- <!--##-->
- <div class="lnfn">
- <label>LASTNAME</label> <label class="fnspace">FIRSTNAME</label>
- </div>
- <input class="lastname" type="text" name="lname" placeholder="Lastname" value='<?php echo $row1['lname']; ?>'> <input class="firstname" type="text" name="fname" placeholder="Firstname" value="<?php echo $row1['fname']; ?>"><br>
- <!--##-->
- <div class="mnnng">
- <label>MIDDLENAME</label> <label class="nnspace">NICKNAME</label> <label class="gspace">GENDER</label><br>
- <input class="middlename" type="text" name="mname" placeholder="Middlename" value="<?php echo $row1['mname']; ?>" required> <input class="nickname" type="text" name="nname" placeholder="Nickname" value="<?php echo $row1['nname']; ?>" required>
- <input class="gender" type="radio" name="gender"
- <?php if (isset($gender) && $gender=="female") echo "checked";?> value="female"> Female
- <input type="radio" name="gender"
- <?php if (isset($gender) && $gender=="male") echo "checked";?> value="male"> Male<br>
- </div>
- <!--##-->
- <div class="csnsdbc">
- <label>CIVIL STATUS</label> <label class="nsspace">NAME OF SPOUSE</label> <label class="dbspace">DATE OF BIRTH</label> <label class="ctspace">CITIZENSHIP</label><br>
- <select class="civilstatus" name="cstatus"><!--##PICKER-->
- <option value =""></option>
- <option value ="Single" <?php if($cstatus == "Single") echo "selected"; ?>>Single</option>
- <option value="Married" <?php if($cstatus == "Married") echo "selected"; ?>>Married</option>
- <option value ="Divorced or Separated" <?php if($cstatus == "Divorced or Separated") echo "selected"; ?>>Divorced or Separated</option>
- <option value ="Widowed" <?php if($cstatus == "Widowed") echo "selected"; ?>>Widowed</option>
- </select> <!--##END OF PICKER-->
- <input class="nameofspouse" type="text" name="nospouse" value="<?php echo $row1['nospouse']; ?>" placeholder="Name of spouse" required> <input class="dateofbirth" type="date" name="dobirth" placeholder="Date of Birth" value="<?php echo $row1['dobirth']; ?>" required> <input class="citizenship" type="text" name="citizenship" value="<?php echo $row1['citizenship']; ?>" placeholder="Citizenship" required><br>
- </div>
- <!--##-->
- <div class="rnas">
- <label>RESIDENCE NUMBER AND STREET</label><br>
- <input class="residencenas" type="text" name="residencens" placeholder="Residence Number and Street" value="<?php echo $row1['residencens']; ?>" required> <br>
- </div>
- <!--##-->
- <div class="b">
- <label>BARANGAY</label><br>
- <input class="barangay" type="text" name="barangay" placeholder="Barangay" value="<?php echo $row1['barangay']; ?>" required> <br>
- </div>
- <!--##-->
- <div class="cp">
- <label>CITY</label> <label class="pspace">PROVINCE</label>
- </div>
- <input class="city" type="text" name="city" placeholder="City" value="<?php echo $row1['city']; ?>" required> <input class="province" type="text" name="province" placeholder="Province" value="<?php echo $row1['province']; ?>"><br>
- <!--##-->
- <div class="zc">
- <label>ZIPCODE</label> <label class="cspace">COUNTRY</label>
- </div>
- <input class="zipcode" type="text" name="zipcode" placeholder="Zipcode" value="<?php echo $row1['zipcode']; ?>" required>
- <select class="country" name="country"><!--##PICKER-->
- <?php include "country.php" ?>
- </select><br><!--##END OF PICKER-->
- <!--##-->
- <div class="rtme">
- <label>RESIDENCE</label> <label class="tnspace">TEL-NUMBER</label> <label class="mnspace">MOBILE-NUMBER</label> <label class="easpace">EMAIL-ADDRESS</label>
- </div>
- <input class="residence" type="text" name="residence" placeholder="" value="<?php echo $row1['residence']; ?>" required> <input class="telnumber" type="text" name="telnumber" placeholder="" value="<?php echo $row1['telnumber']; ?>" required> <input class="mobnumber" type="text" name="mobnumber" placeholder="" value="<?php echo $row1['mobnumber']; ?>" required> <input class="email-add" type="email" name="email" placeholder="Email-Address" value="<?php echo $row1['email']; ?>" required><br>
- </fieldset>
- <br>
- <!--######################################################################################################################################-->
- <fieldset id="educationbox">
- <legend class="education"><b>EDUCATIONAL ATTAINMENT</b></legend>
- <!--##-->
- <div class="eleminput">
- <label>ELEMENTARY:</label>
- <input class="elementary" type="text" name="elementary" placeholder="Name of your School"
- value="<?php echo $row2['elementary']; ?>" required>
- <label>Year</label>
- <select class="schoolyear" name="e1"><!--##PICKER-->
- <?php include "year.php" ?>
- </select><!--##END OF PICKER-->
- <label> to Year</label>
- <select class="schoolyear" name="e2"><!--##PICKER-->
- <?php include "year.php" ?>
- </select><!--##END OF PICKER-->
- </div>
- <!--##-->
- <div class="highinput">
- <label>HIGHSCHOOL:</label>
- <input class="highschool" type="text" name="highschool" placeholder="Name of your School" value="<?php echo $row2['highschool']; ?>">
- <label>Year</label>
- <select class="schoolyear" name="h1"><!--##PICKER-->
- <?php include "year.php" ?>
- </select><!--##END OF PICKER-->
- <label> to Year</label>
- <select class="schoolyear" name="h2"><!--##PICKER-->
- <?php include "year.php" ?>
- </select><!--##END OF PICKER-->
- </div>
- <!--##-->
- <div class="collegeinput">
- <label class="colege">COLLEGE:</label>
- <input class="college" type="text" name="college" placeholder="Name of your School" value="<?php echo $row2['college']; ?>">
- <label>Year</label>
- <select class="schoolyear" name="c1"><!--##PICKER-->
- <?php include "year.php" ?>
- </select><!--##END OF PICKER-->
- <label> to Year</label>
- <select class="schoolyear" name="c2"><!--##PICKER-->
- <?php include "year.php" ?>
- </select><!--##END OF PICKER-->
- </div>
- <!--##-->
- <div class="degreeinput">
- <label class="degre">DEGREE<br> COMPLETED:</label>
- <input class="degree" type="text" name="degree" placeholder="The College Degree you Complete" value="<?php echo $row2['degree']; ?>" >
- </div>
- </fieldset>
- <br>
- <!--######################################################################################################################################-->
- <fieldset id="employmentbox">
- <legend class="employment"><b>EMPLOYMENT INFORMATION</b></legend>
- <!--##-->
- <div class="ept">
- <label>EMPLOYER</label> <label class="pospace">POSITION</label> <label class="tinspace">TAX IDENTIFICATION NUMBER</label><br>
- </div>
- <input class="employer" type="text" name="employer" placeholder="Employer Name" value="<?php echo $row3['employer']; ?>" required> <input class="position" type="text" name="position" placeholder="Employer Position" value="<?php echo $row3['position']; ?>"> <input class="tin" type="text" name="tin" placeholder="TIN Number" value="<?php echo $row3['tin']; ?>" required><br>
- <!--##-->
- <div class="otfe">
- <label>OFFICE</label> <label class="tnrspace">TEL-NUMBER</label> <label class="faspace">FACSIMILE</label> <label class="easspace">EMAIL-ADDRESS</label>
- </div>
- <input class="office" type="text" name="office" placeholder="" value="<?php echo $row3['office']; ?>"> <input class="employertelnumber" type="text" name="employertelnumber" value="<?php echo $row3['employertelnumber']; ?>" placeholder=""> <input class="facsimile" type="text" name="facsimile" placeholder="" value="<?php echo $row3['facsimile']; ?>"> <input class="employeremail-add" type="email" name="employeremail" placeholder="Email-Address" value="<?php echo $row3['employeremail']; ?>"><br>
- </fieldset>
- <br>
- <!--######################################################################################################################################-->
- <fieldset id="hierarchicalbox">
- <legend class="hierarchical"><b>HIERARCHICAL INFORMATION</b></legend>
- <div class="na">
- <label class="nspace">NAME</label> <label class="aspace">AGENT CODE</label>
- </div>
- <!--##-->
- <div class="recinput">
- <label class="respace">RECRUITER</label>
- <input class="recruiter" type="text" name="recruiter" placeholder="Recruiter Name" value="<?php echo $row4['recruiter']; ?>" >
- <input class="agentcode" type="text" name="ragentcode" value="<?php echo $row4['ragentcode']; ?>">
- </div>
- <!--##-->
- <div class="markdinput">
- <label>MARKETING DIRECTOR</label>
- <input class="marketing" type="text" name="marketing" placeholder="Marketing Director Name" value="<?php echo $row4['marketing']; ?>">
- <input class="agentcode" type="text" name="magentcode" value="<?php echo $row4['magentcode']; ?>">
- </div>
- <!--##-->
- <div class="coinput">
- <label>CO-LEADER</label>
- <label class="if">(IF APPLICABLE)</label>
- <input class="coleader" type="text" name="coleader" placeholder="Co-Leader Name" value="<?php echo $row4['coleader']; ?>">
- <input class="agentcode" type="text" name="cagentcode" value="<?php echo $row4['cagentcode']; ?>">
- </div>
- <!--##-->
- <div class="refinput">
- <label>REFERROR</label>
- <label class="if">(IF APPLICABLE)</label>
- <input class="referror" type="text" name="referror" placeholder="Referror Name" value="<?php echo $row4 ['referror']; ?>" required>
- <input class="agentcode" type="text" name="refagentcode" value="<?php echo $row4['refagentcode']; ?>">
- </div>
- </fieldset>
- <br>
- <!--######################################################################################################################################-->
- <img class="membership" src="img/4.jpg" width="405" height="158">
- <fieldset id="havebox">
- <legend class="have"><b>HAVE YOU EVER BEEN AN AGENT OF</b></legend>
- <!--##-->
- <div class="nyn">
- <label>No</label> <label class="y">Yes</label> <label>Name of Company</label>
- </div>
- <label class="lifefont">Life Insurance Co.?</label>
- <input class="life" type="radio" name="survey"
- <?php if (isset($life) && $life=="no") ;?> value="no">
- <input class="life2" type="radio" name="survey"
- <?php if (isset($life) && $life=="yes") ;?> value="yes">
- <input class="compname" type="text" name="compname" value="<?php echo $row5['compname']; ?>"><br><br>
- <!--##-->
- <label class="nonlifefont">Non-Life Insurance Co.?</label>
- <input class="life1" type="radio" name="survey1"
- <?php if (isset($life1) && $life1=="no") ;?> value="no">
- <input class="life2" type="radio" name="survey1"
- <?php if (isset($life1) && $life1=="yes") ;?> value="yes">
- <input class="compname1" type="text" name="compname1" value="<?php echo $row5['compname1']; ?>"><br><br>
- <!--##-->
- <label class="preneed">Pre-Need Co.?</label>
- <input class="life1" type="radio" name="survey2"
- <?php if (isset($life2) && $life2=="no") ;?> value="no">
- <input class="life2" type="radio" name="survey2"
- <?php if (isset($life2) && $life2=="yes") ;?> value="yes">
- <input class="compname2" type="text" name="compname2" value="<?php echo $row5['compname2']; ?>"><br><br>
- </fieldset>
- <br>
- <!--######################################################################################################################################-->
- <div class="button">
- <input id="submit" name="submit" value="Update" type="submit">
- </div>
- </form>
- </div>
- <?php
- function updateData()
- {
- // PERSONAL INFORMATION
- $no=$_POST['no'];
- $lname=$_POST['lname'];
- $fname=$_POST['fname'];
- $mname=$_POST['mname'];
- $nname=$_POST['nname'];
- $gender=$_POST['gender'];
- $cstatus=$_POST['cstatus'];
- $nospouse=$_POST['nospouse'];
- $dobirth=$_POST['dobirth'];
- $citizenship=$_POST['citizenship'];
- $residencens=$_POST['residencens'];
- $barangay=$_POST['barangay'];
- $city=$_POST['city'];
- $province=$_POST['province'];
- $zipcode=$_POST['zipcode'];
- $country=$_POST['country'];
- $residence=$_POST['residence'];
- $telnumber=$_POST['telnumber'];
- $mobnumber=$_POST['mobnumber'];
- $email=$_POST['email'];
- // END OF PERSONAL INFORMATION
- // EDUCATIONAL ATTAINMENT
- $elementary=$_POST['elementary'];
- $e1=$_POST['e1'];
- $e2=$_POST['e2'];
- $highschool=$_POST['highschool'];
- $h1=$_POST['h1'];
- $h2=$_POST['h2'];
- $college=$_POST['college'];
- $c1=$_POST['c1'];
- $c2=$_POST['c2'];
- $degree=$_POST['degree'];
- // END EDUCATIONAL ATTAINMENT
- // EMPLOYMENT INFORMATION
- $employer=$_POST['employer'];
- $position=$_POST['position'];
- $tin=$_POST['tin'];
- $office=$_POST['office'];
- $employertelnumber=$_POST['employertelnumber'];
- $facsimile=$_POST['facsimile'];
- $employeremail=$_POST['employeremail'];
- // END EMPLOYMENT INFORMATION
- // HEIRARCHICAL INFORMATION
- $recruiter=$_POST['recruiter'];
- $ragentcode=$_POST['ragentcode'];
- $marketing=$_POST['marketing'];
- $magentcode=$_POST['magentcode'];
- $coleader=$_POST['coleader'];
- $cagentcode=$_POST['cagentcode'];
- $referror=$_POST['referror'];
- $refagentcode=$_POST['refagentcode'];
- // END HEIRARCHICAL INFORMATION
- // HAVE YOU EVER BEEN AN AGENT?
- $survey=$_POST['survey'];
- $compname=$_POST['compname'];
- $survey1=$_POST['survey1'];
- $compname1=$_POST['compname1'];
- $survey2=$_POST['survey2'];
- $compname2=$_POST['compname2'];
- // END HAVE YOU EVER BEEN AN AGENT?
- //connects to server and select database for use
- $con=mysqli_connect("localhost","root","","form") or die (mysqli_error($link));
- $no = $_GET['id'];
- echo $sql1 = "UPDATE personal_tbl SET lname = $lname, fname=$fname, mname=$mname, nname= $nname, gender = $gender, cstatus= $cstatus, nospouse = $nospouse, dobirth = $dobirth, citizenship =$citizenship,
- residencens =$residencens, barangay = $barangay, city=$city, province = $province, zipcode = $zipcode, country = $country, residence= $residence,telnumber = $telnumber, mobnumber = $mobnumber,
- email = $email WHERE no = $no";
- $sql2 = "UPDATE educ_tbl SET elementary = $elementary, e1 = $e1, e2=$e2,
- highschool = $highschool, h1 = $h1, h2 = $h2,
- college = $college, c1 = $c1, c2 = $c2, degree = $degree WHERE no = $no";
- $sql3 = "UPDATE employ_tbl SET employer = $employer, position = $position, tin = $tin, office = $office,
- employertelnumber = $employertelnumber, facsimile = $facsimile,
- employeremail = $employeremail WHERE no = $no";
- $sql4 = "UPDATE heirar_tbl SET recruiter = $recruiter, ragentcode = $ragentcode,
- marketing = $marketing, magentcode = $magentcode, coleader = $coleader,
- cagentcode = $cagentcode, referror = $referror, refagentcode = $refagentcode WHERE no = $no";
- $sql5 = "UPDATE have_tbl SET survey = $survey, compname = $compnamep,
- survey1 = $survey1, compname1 = $compname1, survey2 = $survey2,
- compname2 = $compname2";
- if (!mysqli_query($con,$sql1)) {
- die('Error: ' . mysqli_error($con));
- }else if(!mysqli_query($con,$sql2)){
- die('Error:' . mysqli_error($con));
- }else if(!mysqli_query($con,$sql3)){
- die('Error:' . mysqli_error($con));
- }else if(!mysqli_query($con,$sql4)){
- die('Error:' . mysqli_error($con));
- }else if(!mysqli_query($con,$sql5)){
- die('Error:' . mysqli_error($con));
- }else{
- echo "<script>alert('1 Record Updated!');</script>";
- }
- // Close Connection
- mysqli_close($con);
- }
- ?>
- <?php
- if(isset($_POST['submit'])) {
- updateData();
- }
- ?>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement