PHP MYSQL : Delete records

Example code on how to delete records using PHP in MYSQL database server.
<?php

// variables
$user = "localhost";
$username = "root";
$password = "password";

// connect to database
$db = new mysqli($user,$username,$password);
$db->select_db('your_databse');
        if (mysqli_connect_errno()) {
                die( "Connection failed..." );
        }

// updaterecords
$delete = "DELETE FROM `tbl_users` WHERE (`id`='1')";
if (mysqli_query($db, $delete) === TRUE) {
          $success = true;



?>

0 comments: