3. Write a PHP script to accept product number from the user. Update the price of the product and display an appropriate message.

Assignment: Q.3 Solution

Write a PHP script to accept product number from the user. Update the price of the product and display an appropriate message.

Index.html


          <html>
  <body>
    <form action="backend.php" method="post">
      <input type="number" name="pno" placeholder="Product number">
      <br><br>
      <input type="number" name="pprice" placeholder="Price">
      <br><br>
      <input type="submit" value="Update">
    </form>
  </body>
</html>

Backend.php


          <?php
  $pno=$_POST['pno'];
  $pprice=$_POST['pprice'];

  $conn=mysql_connect("localhost","root","");

  $sd=mysql_select_db("seta");

  $query=mysql_query("update product set pprice='$pprice' where pno='$pno';");
  if (!$query) {
    echo"Update Failed ";
  } else {
    echo"UPADTED $pprice in $pno";
  }
  
?>

Post a Comment

0 Comments