Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- session_start();
- //initialize variables
- $name = "";
- $address = "";
- $id = 0;
- $update = false;
- // Connect to database
- $db = mysqli_connect('localhost', 'root', '','crud');
- // if save button is clicked
- if (isset($_POST['save'])) {
- $name = $_POST['NAME'];
- $address = $_POST['ADDRESS'];
- mysqli_query($db, "INSERT INTO info (name, address) VALUES ('$name', 'address')");
- $_SESSION['message'] = "Address saved";
- header('location: index.php');
- }
- // update records
- if (isset($_POST['update'])) {
- $id = $_POST['id'];
- $name = $_POST['name'];
- $address = $_POST['address'];
- mysqli_query($db, "UPDATE info SET name='$name', address='$address' WHERE id=$id");
- $_SESSION['message'] = "Address updated!";
- header('location: index.php');
- }
- // delete records
- if (isset($_GET['del'])) {
- $id = $_GET['del'];
- mysqli_query($db, "DELETE FROM info WHERE id=$id");
- $_SESSION['message'] = "Address deleted!";
- header('location: index.php');
- }
- // retrieve records
- $results = mysqli_query($db, "SELECT * FROM info");
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement