Advertisement
Guest User

edit-profile.php issue

a guest
Jun 30th, 2015
278
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.46 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. $sql = "SELECT
  47. u.id
  48. , name
  49. , email
  50. , address1
  51. , address2
  52. , town
  53. , county
  54. , postcode
  55. , telnumber
  56. , mobnumber
  57. , model
  58. , numplate
  59. , DATE_FORMAT(renewal_date, '%e %M %Y') as datedue
  60. FROM users u
  61. INNER JOIN renewal USING (id)
  62. INNER JOIN item USING (item_id)
  63. WHERE id='".$id."'";
  64.  
  65. $query = mysqli_query($db, $sql) or die (mysqli_error($db));
  66.  
  67. var_dump ($sql);
  68.  
  69. while ($row = mysqli_fetch_array($query)) {
  70. $name=$row['name'];
  71. $email=$row['email'];
  72. $address1=$row['address1'];
  73. $address2=$row['address2'];
  74. $town=$row['town'];
  75. $county=$row['county'];
  76. $postcode=$row['postcode'];
  77. $telnumber=$row['telnumber'];
  78. $mobnumber=$row['mobnumber'];
  79. $model=$row['model'];
  80. $numplate=$row['numplate'];
  81. $insurance=$row['datedue'];
  82. $tax=$row['datedue'];
  83. $mot=$row['datedue'];
  84. }
  85.  
  86. var_dump ($name);
  87.  
  88. ?>
  89. <form method="post" action="edit-data.php">
  90. <input type="hidden" name="id" value="<?php echo $row['id']; ?>">
  91. <label>Name :</label>
  92. <input type="text" name="name" required="required" placeholder="Please Enter Name" value="<?php echo $row['name']; ?>" />
  93. <br /><br />
  94. <label>Email :</label>
  95. <input type="email" name="email" required="required" placeholder="Please Enter Email" value="<?php echo $row['email']; ?>" />
  96. <br /><br />
  97. <label>Address Line 1 :</label>
  98. <input type="text" name="address1" required="required" placeholder="Please Enter Address Line 1" value="<?php echo $row['address1'];?>" />
  99. <br /><br />
  100. <label>Address Line 2 :</label>
  101. <input type="text" name="address2" required="required" placeholder="Please Enter Address Line 2" value="<?php echo $row['address2'];?>" />
  102. <br /><br />
  103. <label>Town :</label>
  104. <input type="text" name="town" required="required" placeholder="Please Enter Town" value="<?php echo $row['town'];?>" />
  105. <br /><br />
  106. <label>Copunty :</label>
  107. <input type="text" name="county" required="required" placeholder="Please Enter County" value="<?php echo $row['county'];?>" />
  108. <br /><br />
  109. <label>Postcode :</label>
  110. <input type="text" name="postcode" required="required" placeholder="Please Enter Postcode" value="<?php echo $row['postcode'];?>" />
  111. <br /><br />
  112. <label>Telephone Number :</label>
  113. <input type="text" name="telnumber" required="required" placeholder="Please Enter Telephone Number" value="<?php echo $row['telnumber'];?>" />
  114. <br /><br />
  115. <label>Mobile Number :</label>
  116. <input type="text" name="mobnumber" required="required" placeholder="Please Enter Mobile Number" value="<?php echo $row['mobnumber'];?>" />
  117. <br /><br />
  118. <label>Model of Car/Van :</label>
  119. <input type="text" name="model" required="required" placeholder="Please Enter Model of Car/Van" value="<?php echo $row['model'];?>" />
  120. <br /><br />
  121. <label>Car Tax Renewal Date :</label>
  122. <input type="text" id="datepicker" name="tax" required="required" placeholder="Please Enter your Car Tax Renewal Date" value="<?php echo $row['datedue'];?>" />
  123. <br /><br />
  124. <label>MOT Renewal Date :</label>
  125. <input type="text" id="datepicker2" name="mot" required="required" placeholder="Please Enter your Car MOT Renewal Date" value="<?php echo $row['datedue'];?>" />
  126. <br /><br />
  127. <label>Insurance Renewal Date :</label>
  128. <input type="text" id="datepicker3" name="insurance" required="required" placeholder="Please Enter your Car Insurance Renewal Date" value="<?php echo $row['datedue'];?>" />
  129. <br />
  130. <input type="submit" name="submit value" value="Update">
  131. </form>
  132.  
  133. <?php
  134. }
  135. ?>
  136.  
  137. <?php
  138.  
  139. //close the connection
  140. mysqli_close($db);
  141. ?>
  142.  
  143. </div>
  144.  
  145. <!--CONTENT-->
  146.  
  147. <?php include( 'includes/footer.php' ); ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement