Advertisement
Guest User

edit-profile.php issue

a guest
Jun 30th, 2015
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.82 KB | None | 0 0
  1. <?php
  2. ini_set('display_startup_errors',1);
  3. ini_set('display_errors',1);
  4. error_reporting(-1);
  5. ?>
  6.  
  7. <?php
  8. require_once("functions.php");
  9. require_once("db-const.php");
  10. ?>
  11.  
  12. <?php
  13. $title = "Edit My Account Profile - The Tax Elephants";
  14.  
  15. $pgDesc="";
  16.  
  17. $pgKeywords="";
  18.  
  19. include ( 'includes/header.php' );
  20. ?>
  21. <!--CONTENT-->
  22.  
  23. <div id="column-whole">
  24.  
  25. <?php
  26.  
  27. if (logged_in() == false) {
  28. redirect_to("login.php");
  29. } else {
  30. if (isset($_GET['id']) && $_GET['id'] != "") {
  31. $id = $_GET['id'];
  32. } else {
  33. $id = $_SESSION['user_id'];
  34. }
  35.  
  36. $db = mysqli_connect("" , "", "") or die("Check connection parameters!");
  37. // Optionally skip select_db and use: mysqli_connect(host,user,pass,dbname)
  38. mysqli_select_db($db,"") or die(mysqli_error($db));
  39.  
  40. if (mysqli_connect_error()) {
  41. die ('Failed to connect to MySQL');
  42. } else {
  43. echo '';
  44. }
  45.  
  46. // get value of id that sent from address bar
  47. $id=$_GET['id'];
  48.  
  49. $sql = "SELECT
  50. u.id
  51. , name
  52. , email
  53. , address1
  54. , address2
  55. , town
  56. , county
  57. , postcode
  58. , telnumber
  59. , mobnumber
  60. , model
  61. , numplate
  62. , DATE_FORMAT(renewal_date, '%e %M %Y') as datedue
  63. FROM users u
  64. INNER JOIN renewal USING (id)
  65. INNER JOIN item USING (item_id)
  66. WHERE id='$id'";
  67.  
  68. $query = mysqli_query($db, $sql) or die (mysqli_error($db));
  69.  
  70. var_dump ($sql);
  71.  
  72. $row = mysqli_fetch_array($query);
  73.  
  74. $name = $row['name'];
  75. $email = $row['email'];
  76. $address1 = $row['address1'];
  77. $address2 = $row['address2'];
  78. $town = $row['town'];
  79. $county = $row['county'];
  80. $postcode = $row['postcode'];
  81. $telnumber = $row['telnumber'];
  82. $mobnumber = $row['mobnumber'];
  83. $model = $row['model'];
  84. $numplate = $row['numplate'];
  85. $insurance = $row['datedue'];
  86. $tax = $row['datedue'];
  87. $mot = $row['datedue'];
  88.  
  89.  
  90. var_dump ($name);
  91. var_dump ($tax);
  92.  
  93. ?>
  94.  
  95. <form method="post" action="edit-data.php">
  96. <input type="hidden" name="id" value="<?php echo $row['id']; ?>">
  97. <label>Name :</label>
  98. <input type="text" name="name" required="required" placeholder="Please Enter Name" value="<?php echo $row['name']; ?>" />
  99. <br /><br />
  100. <label>Email :</label>
  101. <input type="email" name="email" required="required" placeholder="Please Enter Email" value="<?php echo $row['email']; ?>" />
  102. <br /><br />
  103. <label>Address Line 1 :</label>
  104. <input type="text" name="address1" required="required" placeholder="Please Enter Address Line 1" value="<?php echo $row['address1'];?>" />
  105. <br /><br />
  106. <label>Address Line 2 :</label>
  107. <input type="text" name="address2" required="required" placeholder="Please Enter Address Line 2" value="<?php echo $row['address2'];?>" />
  108. <br /><br />
  109. <label>Town :</label>
  110. <input type="text" name="town" required="required" placeholder="Please Enter Town" value="<?php echo $row['town'];?>" />
  111. <br /><br />
  112. <label>Copunty :</label>
  113. <input type="text" name="county" required="required" placeholder="Please Enter County" value="<?php echo $row['county'];?>" />
  114. <br /><br />
  115. <label>Postcode :</label>
  116. <input type="text" name="postcode" required="required" placeholder="Please Enter Postcode" value="<?php echo $row['postcode'];?>" />
  117. <br /><br />
  118. <label>Telephone Number :</label>
  119. <input type="text" name="telnumber" required="required" placeholder="Please Enter Telephone Number" value="<?php echo $row['telnumber'];?>" />
  120. <br /><br />
  121. <label>Mobile Number :</label>
  122. <input type="text" name="mobnumber" required="required" placeholder="Please Enter Mobile Number" value="<?php echo $row['mobnumber'];?>" />
  123. <br /><br />
  124. <label>Model of Car/Van :</label>
  125. <input type="text" name="model" required="required" placeholder="Please Enter Model of Car/Van" value="<?php echo $row['model'];?>" />
  126. <br /><br />
  127. <label>Car Tax Renewal Date :</label>
  128. <input type="text" id="datepicker" name="tax" required="required" placeholder="Please Enter your Car Tax Renewal Date" value="<?php echo $row['datedue'];?>" />
  129. <br /><br />
  130. <label>MOT Renewal Date :</label>
  131. <input type="text" id="datepicker2" name="mot" required="required" placeholder="Please Enter your Car MOT Renewal Date" value="<?php echo $row['datedue'];?>" />
  132. <br /><br />
  133. <label>Insurance Renewal Date :</label>
  134. <input type="text" id="datepicker3" name="insurance" required="required" placeholder="Please Enter your Car Insurance Renewal Date" value="<?php echo $row['datedue'];?>" />
  135. <br />
  136. <input type="submit" name="submit value" value="Update">
  137. </form>
  138.  
  139. <?php
  140. }
  141. ?>
  142.  
  143. <?php
  144.  
  145. //close the connection
  146. mysqli_close($db);
  147. ?>
  148.  
  149. </div>
  150.  
  151. <!--CONTENT-->
  152.  
  153. <?php include( 'includes/footer.php' ); ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement