DELETE tutorial in php

 DELETE Syntax :

DELETE FROM table_name WHERE condition;


If we want to DELETE any particular record from table name "personal" using DELETE then we can use  below query : 

While performing DELETE query, there must be condition otherwise all records will be deleted.

DELETE FROM personal WHERE id = 30;

Comments

Post a Comment

Popular posts from this blog

Ajax Insert Records in Database Tutorial in PHP

Image
  <?php $servername = "localhost" ; $username = "root" ; $password = "" ; $dbname = "test" ; // Create Connection $conn = new mysqli ( $servername , $username , $password , $dbname ); // Check Connection if ( $conn -> connect_error ) {     die ( "Connection Failed : " . $conn -> connect_error ); } Above File is mysqli_conn.php File Below File is show-data.php File <! DOCTYPE html > < html lang = "en" > < head >     < meta charset = "UTF-8" >     < meta name = "viewport" content = "width=device-width, initial-scale=1.0, shrink-to-fit=no" >     < meta http-equiv = "X-UA-Compatible" content = "ie=edge" >     < title > Show Data </ title > </ head > < body >     < table id = "main" border = "0" cellspacing = "0" >         < tr >             < td id =...
Read more

Arithmetic Operators Tutorial in PHP

Image
  <?php $a = 10 ; $b = 4 ; $c = $a + $b ; echo $c . "<br>" ; $d = $a - $b ; echo $d . "<br>" ; $e = $a * $b ; echo $e . "<br>" ; $f = $a / $b ; echo $f . "<br>" ; $g = $a % $b ; echo $g . "<br>" ; $h = $a ** $b ; echo $h . "<br>" ; // $a++; // ++$a; // echo $a."<br>"; // $b--; // --$b; // echo $b."<br>"; $i = $a + $b * 2 ; echo $i . "<br>" ; $j = ( $a + $b ) * 2 ; echo $j . "<br>" ; ? >
Read more

Displaying Database data using Class, Object, Constructor, Destructor in PHP MySql

Image
  <?php class Employee {     private $conn ;     public function __construct ()     {         $this -> conn = new mysqli ( "localhost" , "root" , "" , "database_ci" );         if ( $this -> conn -> connect_error ) {             die ( "Connection Failed : " . $this -> conn -> connect_error );         }     }     public function __destruct ()     {         $this -> conn -> close ();     }     public function getAllEmployees ()     {         $data = [];         $sql = " SELECT * FROM register " ;         $result = $this -> conn -> query ( $sql );         if ( $result -> num_rows > 0 ) {             while ( $row = $result -...
Read more