Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- ini_set('display_startup_errors',1);
- ini_set('display_errors',1);
- error_reporting(-1);
- ?>
- <?php
- require_once("functions.php");
- require_once("db-const.php");
- ?>
- <?php
- $title = "Edit My Account Profile - The Tax Elephants";
- $pgDesc="";
- $pgKeywords="";
- include ( 'includes/header.php' );
- ?>
- <!--CONTENT-->
- <div id="column-whole">
- <?php
- if (logged_in() == false) {
- redirect_to("login.php");
- } else {
- if (isset($_GET['id']) && $_GET['id'] != "") {
- $id = $_GET['id'];
- } else {
- $id = $_SESSION['user_id'];
- }
- $db = mysqli_connect("" , "", "") or die("Check connection parameters!");
- // Optionally skip select_db and use: mysqli_connect(host,user,pass,dbname)
- mysqli_select_db($db,"") or die(mysqli_error($db));
- if (mysqli_connect_error()) {
- die ('Failed to connect to MySQL');
- } else {
- echo '';
- }
- // get value of id that sent from address bar
- $id=$_GET['id'];
- $sql = "SELECT
- u.id
- , name
- , email
- , address1
- , address2
- , town
- , county
- , postcode
- , telnumber
- , mobnumber
- , model
- , numplate
- , DATE_FORMAT(renewal_date, '%e %M %Y') as datedue
- FROM users u
- INNER JOIN renewal USING (id)
- INNER JOIN item USING (item_id)
- WHERE id='$id'";
- $query = mysqli_query($db, $sql) or die (mysqli_error($db));
- var_dump ($sql);
- $row = mysqli_fetch_array($query);
- $name = $row['name'];
- $email = $row['email'];
- $address1 = $row['address1'];
- $address2 = $row['address2'];
- $town = $row['town'];
- $county = $row['county'];
- $postcode = $row['postcode'];
- $telnumber = $row['telnumber'];
- $mobnumber = $row['mobnumber'];
- $model = $row['model'];
- $numplate = $row['numplate'];
- $insurance = $row['datedue'];
- $tax = $row['datedue'];
- $mot = $row['datedue'];
- var_dump ($name);
- var_dump ($tax);
- ?>
- <form method="post" action="edit-data.php">
- <input type="hidden" name="id" value="<?php echo $row['id']; ?>">
- <label>Name :</label>
- <input type="text" name="name" required="required" placeholder="Please Enter Name" value="<?php echo $row['name']; ?>" />
- <br /><br />
- <label>Email :</label>
- <input type="email" name="email" required="required" placeholder="Please Enter Email" value="<?php echo $row['email']; ?>" />
- <br /><br />
- <label>Address Line 1 :</label>
- <input type="text" name="address1" required="required" placeholder="Please Enter Address Line 1" value="<?php echo $row['address1'];?>" />
- <br /><br />
- <label>Address Line 2 :</label>
- <input type="text" name="address2" required="required" placeholder="Please Enter Address Line 2" value="<?php echo $row['address2'];?>" />
- <br /><br />
- <label>Town :</label>
- <input type="text" name="town" required="required" placeholder="Please Enter Town" value="<?php echo $row['town'];?>" />
- <br /><br />
- <label>Copunty :</label>
- <input type="text" name="county" required="required" placeholder="Please Enter County" value="<?php echo $row['county'];?>" />
- <br /><br />
- <label>Postcode :</label>
- <input type="text" name="postcode" required="required" placeholder="Please Enter Postcode" value="<?php echo $row['postcode'];?>" />
- <br /><br />
- <label>Telephone Number :</label>
- <input type="text" name="telnumber" required="required" placeholder="Please Enter Telephone Number" value="<?php echo $row['telnumber'];?>" />
- <br /><br />
- <label>Mobile Number :</label>
- <input type="text" name="mobnumber" required="required" placeholder="Please Enter Mobile Number" value="<?php echo $row['mobnumber'];?>" />
- <br /><br />
- <label>Model of Car/Van :</label>
- <input type="text" name="model" required="required" placeholder="Please Enter Model of Car/Van" value="<?php echo $row['model'];?>" />
- <br /><br />
- <label>Car Tax Renewal Date :</label>
- <input type="text" id="datepicker" name="tax" required="required" placeholder="Please Enter your Car Tax Renewal Date" value="<?php echo $row['datedue'];?>" />
- <br /><br />
- <label>MOT Renewal Date :</label>
- <input type="text" id="datepicker2" name="mot" required="required" placeholder="Please Enter your Car MOT Renewal Date" value="<?php echo $row['datedue'];?>" />
- <br /><br />
- <label>Insurance Renewal Date :</label>
- <input type="text" id="datepicker3" name="insurance" required="required" placeholder="Please Enter your Car Insurance Renewal Date" value="<?php echo $row['datedue'];?>" />
- <br />
- <input type="submit" name="submit value" value="Update">
- </form>
- <?php
- }
- ?>
- <?php
- //close the connection
- mysqli_close($db);
- ?>
- </div>
- <!--CONTENT-->
- <?php include( 'includes/footer.php' ); ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement