Library-Management/updation.php at master · yakiu50/Library-Management · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
<?php
 $size= sizeof($_POST);
 $records=$size/4;

 for($i=1;$i<=$records;$i++)
 {
   $index1="bookid".$i;
   $bookid[$i]=$_POST[$index1];
   $index2="title".$i;
   $title[$i]=$_POST[$index2];
   $index3="price".$i;
   $price[$i]=$_POST[$index3];
   $index4="author".$i;
   $author[$i]=$_POST[$index4];
 }
 $con=mysqli_connect('localhost','root');
 mysqli_select_db($con,'brm_db');

 for($i=1;$i<=$records;$i++)
 {
 $q="update book SET title='$title[$i]', price=$price[$i], author='$author[$i]' where bookid=$bookid[$i]";
  mysqli_query($con,$q);
 }
 mysqli_close($con);
?>
<!DOCTYPE html>
<html>
 <head>
 <link rel="stylesheet" type="text/css" href="homeStyle.css" />
  <title> Updation </title>
 </head>
 <body>
  <h1> Book Record Management </h1>
  <p><?php
			echo " Records updated";
	  ?>
   </p>
   Go back to home page<a href="home.php">Click here</a>
 </body>
</html>