Consider the following entities and their relationships

Movie (movie_no, movie_name, release_year)

Actor (actor_no, name)

Relationship between movie and actor is many – many with attribute rate in Rs. Create a RDB in 3NF for the above and solve following Using above database, write PHP scripts for the following:(Hint: Create HTML form having three radio buttons)

a) Accept actor name and display the names of the movies in which he has acted.

b) Insert new movie information.

c) Update the release year of a movie. (Accept the movie name from user)

Relationship between movie and actor is many – many with attribute rate in Rs. Create a RDB in 3NF for the above and solve following Using above database, write PHP scripts for the following:(Hint: Create HTML form having three radio buttons)

Answer :

<html> <link rel="stylesheet" href="style.css"> <body> <div class="container"> <div class="row"> <div class="col-sm-4 py-4"> <form action="#" method="post"> <h2>New Movie Information</h3><hr> <input type="radio" name=ch1 value= 1 class="from-check-input"> a) Accept actor name and display the names of the movies in which he has acted. <br> <input type="radio" name=ch1 value= 2 class="from-check-input"> b) Insert new movie information <br> <input type="radio" name=ch1 value= 3 class="from-check-input"> c) Update the release year of a movie. <br><br> <input type="submit" value="Submit" class="btn-sm btn-outline-success"> <input type="reset" value="Clear" class="btn-sm btn-outline-danger"> </form> </div> <div class="col-sm-6 offset-sm-1"> <table class='table table-bordered'> <thead class='table-dark'> <tr> <th>SR.NO</th> <th>Movie Name </th> <th>Actor Name </th> <th>Movie Rate</th> <th>Release Year</th> </tr> </thead> </div> </div> </div> </div> </body> </html> <?php $conn = mysqli_connect("localhost","root","","slip29_db") or die("Connection Unsuccessful."); $sql = "SELECT * FROM movie m ,actor a , Amovie am WHERE m.movie_no=am.movie_no1 AND a.actor_no=am.actor_no1"; $result = mysqli_query($conn,$sql) or die("Query Unsuccessful."); if(mysqli_num_rows($result)>0){ while($row= mysqli_fetch_assoc($result)){ echo "<tbody> <tr> <td>".$row['movie_no']."</td> <td>".$row['movie_name']."</td> <td>".$row['name']."</td> <td>".$row['rate']."</td> <td>".$row['release_year']."</td> </tr>"; } echo " </tbody> </table> </div> </div>"; } if(isset($_POST['ch1'])){ switch ($_POST['ch1']){ case 1 : echo "<script> location.href='1.php' </script>"; break; case 2 : echo "<script> location.href='2.php' </script>"; break; case 3 : echo "<script> location.href='3.php' </script>"; break; } } ?>

a) Accept actor name and display the names of the movies in which he has acted.

Answer :

<html> <link rel="stylesheet" href="style.css"> <body> <div id='login' class="container"> <div class="row"> <div class="col"> <form action="#" method="post" class="form py-3"> Actor Name : <input type="text" name="str"> <input type="submit" value="Submit" class="btn btn-outline-primary"> <input type="reset" value="Clear" class="btn btn-outline-danger"> </form> </div> </div> </div> <?php if(isset($_POST['str'])){ $conn = mysqli_connect("localhost","root","","slip29_db"); $sql = "SELECT * FROM movie m ,actor a , Amovie am WHERE m.movie_no=am.movie_no1 AND a.actor_no=am.actor_no1"; $res = mysqli_query($conn,$sql); echo " <div class='container'> <div class='col'> <table class='table table-bordered'> <thead class='table-dark'> <tr> <th>SR.NO</th> <th>Movie Name </th> <th>Actor Name </th> <th>Movie Rate</th> <th>Release Year</th> </tr> </thead>"; if(mysqli_num_rows($res)>0){ while($row = mysqli_fetch_assoc($res)){ if($row['name']==$_POST['str']){ echo "<tr> <td>".$row['movie_no']."</td> <td>".$row['movie_name']."</td> <td>".$row['name']."</td> <td>".$row['rate']."</td> <td>".$row['release_year']."</td> </tr>"; } } echo "</table></div></body></html>"; } } ?> </html> </body>

b) Insert new movie information.

Answer :

<html> <link rel="stylesheet" href="style.css"> <body> <div class="container"> <div class="row"> <div class="col-sm-4 py-4"> <form action="" method="post"> <div class="from-group"> <label for="Movie_no"> Movie No</label> <input type="text" name="mno" id="mno" class="form-control"> <label for="mname"> Movie Name</label> <input type="text" name="mname" id="mname" class="form-control"> <label for="mname">Relese Year</label> <input type="date" name="mdate" id="mname" class="form-control"> </div> <br> <input type="submit" value="Submit" name="submit" class="btn btn-outline-primary"> <input type="reset" value="Clear" class="btn btn-outline-danger"> </form> </div> <div class="col-sm-6 offset-sm-1"> <table class='table table-bordered'> <thead class='table-dark'> <tr> <th>SR.NO</th> <th>Movie Name </th> <th>Release Year</th> </tr> </thead> </div> </div> </div> </body> </html> <?php $conn = mysqli_connect("localhost","root","","slip29_db") or die("Connection Unsuccessful."); $sql = "SELECT * FROM movie "; $result = mysqli_query($conn,$sql) or die("Query Unsuccessful."); if(mysqli_num_rows($result)>0){ while($row= mysqli_fetch_assoc($result)){ echo "<tbody> <tr> <td>".$row['movie_no']."</td> <td>".$row['movie_name']."</td> <td>".$row['release_year']."</td> </tr>"; } echo " </tbody> </table> </div> </div>"; } ?> <?php if(isset($_POST['submit'])){ if($_POST['mno']==""||$_POST['mname']==""||$_POST['mdate']==""){ echo "All Fields Are Required"; }else{ $no = $_REQUEST['mno']; $name =$_REQUEST['mname']; $date = $_REQUEST['mdate']; $sql = "INSERT INTO movie VALUE($no,'$name','$date')"; if(mysqli_query($conn,$sql)){ echo "<hr>New Record Insert Successfully...!"; } } } ?> </html>

c) Update the release year of a movie. (Accept the movie name from user)

Answer :

<html> <head> <link rel="stylesheet" href="style.css"> </head> <div class="container"> <div class="row"> <div class="col-sm-4"> <form action="<?php $_SERVER['PHP_SELF']?>" method="POST"> <label for="id" > Movie Name </label> <input type="text" name="str" id="id" class="form-control"> <input type="submit" value="Submit" name="submit" class=" mt-4 btn btn-primary"> </form> <?php if(isset($_POST['submit'])){ $conn = mysqli_connect("localhost","root","","slip29_db") or die("connection Failed"); $str = $_POST['str']; $sql ="SELECT * FROM movie WHERE movie_name = '{$str}'"; $result = mysqli_query($conn,$sql) or die("Query Unsuccessful."); if(mysqli_num_rows($result)>0){ while($row = mysqli_fetch_assoc($result)){ ?> <form class="post-form" action="" method="POST"> <label for="no" > Movie NO</label> <input type="text" name="str" id="no" class="form-control" value="<?php echo $row['movie_no']?>" disabled='disabled'/> <input type="hidden" name="mstr" value="<?php echo $row['movie_no']?>"/> <label for="name">Movie Name</label> <input type="text" name="name" id="name" class="form-control" value="<?php echo $row['movie_name']?>" disabled='disabled'/> <label for="Release Year">Release Year</label> <input type="date" name="mry" id="mry" class="form-control" value="<?php echo $row['release_year']?>"/> <input type="submit" value="Update" class="btn btn-success" name="update"/> </form> <?php } } } if(isset($_REQUEST['update'])){ $mstr= $_POST['mstr']; $mname = $_POST['name']; $mry = $_POST['mry']; $conn = mysqli_connect("localhost","root","","slip29_db") or die("connection Failed"); $sql = "UPDATE movie SET movie_name ='{$mname}', release_year ='{$mry}' WHERE movie_no ={$mstr}"; $result = mysqli_query($conn,$sql) or die("Query Unsuccessful."); } ?>

Team Analytics

PHP Solved Slip

Consider the following entities and their relationships

Movie (movie_no, movie_name, release_year)

Actor (actor_no, name)

Relationship between movie and actor is many – many with attribute rate in Rs. Create a RDB in 3NF for the above and solve following Using above database, write PHP scripts for the following:(Hint: Create HTML form having three radio buttons)

a) Accept actor name and display the names of the movies in which he has acted.

b) Insert new movie information.

c) Update the release year of a movie. (Accept the movie name from user)

a) Accept actor name and display the names of the movies in which he has acted.

b) Insert new movie information.

c) Update the release year of a movie. (Accept the movie name from user)

No comments:

Search This Blog

Pages

Popular Posts

Labels