How to Insert, Update and Delete Record in PHP MySQL

TechVidvan Team

2 years ago

Program 1

<html>
<body>
    <center>
<pre>

<?php
             $servername="localhost";
             $username="root";
             $password="";
             $dbname="Library";
             $mycon=mysqli_connect($servername,$username,$password,$dbname);
             if($mycon->connect_error)
             die("Connection failed....");
            else
           { 
             echo "Connection success......";
             $sql="insert into student values(105,'Ashok','Mtech');";
                  echo $mycon->query($sql);
                   echo ": Record inserted....";
           } 
             
               $mycon->close();
               echo "Connection closed..........";              
?>
</pre>
</center>
</body>
</html>

Program 2

<html>
<body>
    <center>
<pre>

<?php
             $servername="localhost";
             $username="root";
             $password="";
             $dbname="Library";
             $mycon=mysqli_connect($servername,$username,$password,$dbname);
             if($mycon->connect_error)
             die("Connection failed....");
            else
           { 
             echo "Connection success......";
             //$sql="delete from student where sid=102";
               $sql="update student set course='MCA' where sid=102";
                  echo $mycon->query($sql);
                   echo ": Record updated....";
           } 
             
               $mycon->close();
               echo "Connection closed..........";              
?>
</pre>
</center>
</body>
</html>