-
Notifications
You must be signed in to change notification settings - Fork 0
/
display.php
123 lines (109 loc) · 2.76 KB
/
display.php
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
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
<!DOCTYPE html>
<html>
<head>
<title>STORED PROCEDURE</title>
<link rel="stylesheet" href="css/table.css" type="text/css" />
<style type="text/css">
form {
border: 3px solid #f1f1f1;
}
/* Full-width inputs */
input[type=text], input[type=password] {
width: 100%;
padding: 12px 20px;
margin: 8px 0;
display: inline-block;
border: 1px solid #ccc;
box-sizing: border-box;
}
/* Set a style for all buttons */
button {
background-color: #82172B;
padding: 14px 20px;
margin: 8px 0;
border: none;
cursor: pointer;
width: 100%;
}
/* Add a hover effect for buttons */
button:hover {
opacity: 0.8;
}
/* Extra style for the cancel button (red) */
.cancelbtn {
width: auto;
padding: 10px 18px;
background-color: #D9D9F3;
}
/* Center the avatar image inside this container */
.imgcontainer {
text-align: center;
margin: 24px 0 12px 0;
}
/* Avatar image */
img.avatar {
width: 20%;
border-radius: 20%;
float: center;
}
/* Add padding to containers */
.container {
padding: 6px;
float: center;
}
/* The "Forgot password" text */
span.psw {
float: left;
padding-top: 16px;
}
/* Change styles for span and cancel button on extra small screens */
@media screen and (max-width: 300px) {
span.psw {
display: block;
float: none;
}
.cancelbtn {
width: 100%;
}
}
h2{
font-family: "Snell Roundhand", cursive;}
body{
color:#cc0066;
font-size: 250%;
}
</style>
</head>
<body background="ct.jpg" >
<?php
require_once 'config.php';
try {
$pdo = new PDO("mysql:host=localhost;dbname=movie", "root", "");
// execute the stored procedure
$sql = 'CALL moviedetail()';
// call the stored procedure
$q = $pdo->query($sql);
$q->setFetchMode(PDO::FETCH_ASSOC);
} catch (PDOException $e) {
die("Error occurred:" . $e->getMessage());
}
?>
<center>
<table>
<tr>
<h1> <th>Actor </th>
<h1><th>Director </th>
<h1><th>Movie name</th>
</tr>
<?php while ($r = $q->fetch()): ?>
<tr>
<h1><td style='width:350px;border:3px solid #800000;'><?php echo $r['actor'] ?></td></h1>
<h1><td style='width:350px;border:3px solid #800000;'><?php echo $r['director'] ?></td></h1>
<h1><td style='width:350px;border:3px solid #800000;'><?php echo $r['description'] ?></td></h1>
</td>
</tr>
<?php endwhile; ?>
</table>
</center>
</body>
</html>