Insertion:
<?php
if(isset($_POST['btnSave']))
{
$MN = $_POST['txtA'];
$RD = $_POST['txtB'];
$RT = $_POST['Rating'];
$A = mysql_connect("LocalHost","root","") or die("Error in MySQL Connection"); //Step-1: Open Connection
mysql_select_db("MovieDB",$A) or die ("Error in Data Base"); //Step-2: Select Data Base.
mysql_query("Insert into tblMovies values ('','$MN','$RD','$RT')",$A) or die ("Error in Insert Query"); //Step-3: Run Query
mysql_close($A); //Step-4: Close DataBase.
echo "Data Saved.";
}
?>
Selection:
<?php
$A = mysql_connect("LocalHost","root","") or die("Error in MySQL Connection"); //Step-1: Open Connection
mysql_select_db("MovieDB",$A) or die ("Error in Data Base"); //Step-2: Select Data Base.
$B = mysql_query("Select * from tblMovies",$A) or die ("Error in Insert Query"); //Step-3: Run Query
$T = mysql_num_rows($B);
echo "Total Rows: $T <br>";
for($a=0; $a<$T; $a++)
{
$R = mysql_fetch_array($B);
echo "<tr>";
echo "<td>$R[0]</td>"; //MID
echo "<td>$R[1]</td>"; //MovieName
echo "<td>$R[2]</td>"; //ReleaseDate
echo "<td>$R[3]</td>"; //Rating
echo "<td align=center><font color=Blue><img src='Movies/$R[0].jpg' width=70 height=70 title='$R[1]' border=5></font></td>"; //Images
echo "</tr>";
}
mysql_close($A); //Step-4: Close DataBase.
?>
Form:
<h2><strong>Fill Movie Information</strong></h2>
<Form action="Index.php" Method="POST">
<table border=1 cellspacing=5 cellpadding=5>
<tr>
<td><input type=Text name=txtA PlaceHolder="Enter Movie Name" Required=Required></td>
</tr>
<tr>
<td><input type=Text name=txtB PlaceHolder="Enter Release Date" Required=Required></td>
</tr>
<tr>
<td><Select name=Rating Style=Width:145>
<option>Select Rating</option>
<option>1-Star</option>
<option>2-Star</option>
<option>3-Star</option>
<option>4-Star</option>
</Select></td>
</tr>
<tr>
<td align=right><input type=Submit name=btnSave Value=Save></td>
</tr>
</table>
</Form>
No comments:
Post a Comment