-
Notifications
You must be signed in to change notification settings - Fork 0
/
just_do_it.php
80 lines (55 loc) · 1.24 KB
/
just_do_it.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
<html>
<head>
<title>just do it!!!</title>
<style>
input{
width:95%;
}
</style>
</head>
<body style="background-color:grey;">
<font color="white">
<br><br>
<center>
<form method="POST" action="just_do_it.php">
<label>Digite a Query</label><br><br><input type="text" name="here">
</form>
</font>
<br><br>
<?php
$servername = "localhost";
$username = "root";
$password = "";
$lines = 0;
try {
$conn = new PDO('mysql:host=localhost;dbname=compubras', $username, $password);
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch(PDOException $e) {
echo 'ERROR: ' . $e->getMessage();
}
//$sql = "SELECT * FROM cliente Where cliente.nome LIKE \"A%\"";
$sql = $_POST["here"];
//$sql = "Select Cliente.*, Pedido.PrazoEntrega From Cliente INNER JOIN Pedido ON Pedido.CodCliente = Cliente.CodCliente Order by Pedido.PrazoEntrega DESC";
// $resultado = $conn->query($sql);
$stmt = $conn->query($sql);
while($row = $stmt->fetch()) {
$lines++;
}
?>
<font size="70px">
<?php
echo $lines."<br><br>";
?>
</font>
</center>
<?php
$stmt = $conn->query($sql);
while($row = $stmt->fetch()) {
print_r($row);
?>
<hr align="center" width="100%" size="10" color=black>
<?php
}
?>
</body>
</html>