Create a PHP script to insert, retrieve, update, and delete records from a MySQL table.

-

 

Source Code:


<?php


$connection=mysqli_connect("localhost","root","","phpdb"); $query="create table student(sid int,sname varchar(30).marks float)"; if(mysqli_query($connection, $query)) { echo "Table creation Successfull!!";)


else{


echo "Error creating table:" mysqli_error(Sconnection). "<br>";} $query1="insert into student values(101, 'Sreejith',99);"; $queryl.="insert into student values(102, 'Meera', 79);"; Squery1.="insert into student values(103,'Anu',69);"; if(mysqli_multi_query($connection.Squery1)){ echo "Insertion Successfull!!";}


else


echo "Error insertion:"mysqli_error($connection). "<br>";) $query2="update student set marks=100 where sid=101"; $con2=mysqli_query($connection, $query2); if($con2)( echo "Updation Successfull!!";)


else{ echo "Error creating table:" mysqli_error($connection). "<br>";} $query3="delete from student where sid=103"; $con3=mysqli_query($connection, Squery3); if($con3){ echo "Deletion Successfull!!";}


else{ echo "Error creating table:" mysqli_error($connection). "<br>";) $query4 = "SELECT * FROM student"; $con1 = mysqli_query($connection, $query4); if (mysqli_num_rows($con1) > 0) { while ($row = mysqli_fetch_assoc($con1)) { echo "ID:". Srow["sid"]."<br>"; echo "Name:". $row["sname"]."<br>"; echo "Marks: ".$row["marks"]."<br><br>";}} else ( echo "Error retrieving data:" mysqli_error($connection). "<br>"; }


?>

Comments

Post a Comment

Popular posts from this blog

Calculate Factorial using While loop in JavaScript.

-
 AIM:  Source Code: <!DOCTYPE html> <html lang="en"> <head>  <meta charset="UTF-8">  <meta name="viewport" content="width=device-width, initial-scale=1.0">  <title>Document</title> </head> <body>  <input type="button" onclick="multi_3n5()" value="click here">  <script>  function multi_3n5() {  var n = parseInt(prompt("Number : "));  var i=1,f=1;  while(i<=n){  f=f*i;  i++;  }  document.write("factorial of the number = "+f);}  </script> </body> </html>
Read more

Calculator

-
 <!DOCTYPE html> <html lang="en"> <head>     <meta charset="UTF-8">     <meta name="viewport" content="width=device-width, initial-scale=1.0">     <title>Document</title> </head> <body>     Enter a Number 1:<input type="text" id="number1" ><br>     Enter a Number 2:<input type="text" id="number2" ><br>     Result:<input type="text" id="result" ><br>     <input type="button" value="+" onclick="calc('+')">     <input type="button" value="-" onclick="calc('-')">     <input type="button" value="/" onclick="calc('/')">     <input type="button" value="x" onclick="calc('x')"> </body> <script> function calc(operator){     ...
Read more

Simple calculator

-
 <!DOCTYPE html> <html lang="en"> <head>     <meta charset="UTF-8">     <meta name="viewport" content="width=device-width, initial-scale=1.0">     <title>Document</title> </head> <body>     Enter a Number 1:<input type="text" id="number1" ><br>     Enter a Number 2:<input type="text" id="number2" ><br>     Result:<input type="text" id="result" ><br>     <input type="button" value="+" onclick="calc('+')">     <input type="button" value="-" onclick="calc('-')">     <input type="button" value="/" onclick="calc('/')">     <input type="button" value="x" onclick="calc('x')"> </body> <script> function calc(operator){     ...
Read more