Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <form action="" method="post">
- First name: <input type="text" name="first"><br />
- Last name: <input type="text" name="last"><br />
- Address: <input type="text" name="address"><br />
- Age (must be number): <input type="text" name="age">
- <input type="submit" name="submit" value="submit">
- </form>
- <?php
- $hostname="localhost";
- $username="root";
- $password="zRx181962";
- $link = mysqli_connect ($hostname,$username,$password);
- mysqli_select_db($link, "bethcustomers");
- if(isset($_POST["first"])){
- $first = mysqli_real_escape_string($link,$_POST["first"]);
- $last = mysqli_real_escape_string($link,$_POST["last"]);
- $address = mysqli_real_escape_string($link,$_POST["address"]);
- $age = mysqli_real_escape_string($link,$_POST["age"]);
- $query = "INSERT INTO customers(first,last,address,age) VALUES('$first','$last','$address',$age)";
- $result = mysqli_query($link,$query);
- }
- ?>
- <table cellspacing=1 cellpadding=3 border=1>
- <tr><th><a href="?sort=first">First</a></th><th><a href="?sort=last">Last</a></th><th><a href="?sort=address">Address</a></th><th><a href="?sort=age">Age</a></th></tr>
- <?php
- $query = "SELECT * FROM customers ORDER BY last";
- $result = mysqli_query($link,$query);
- while($r=mysqli_fetch_array($result,MYSQLI_ASSOC)){
- echo "<tr><td>".$r["first"]."</td><td>".$r["last"]."</td><td>".$r["address"]."</td><td>".$r["age"]."</td></tr>\n";
- }
- ?>
- </table>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement