-
Notifications
You must be signed in to change notification settings - Fork 0
/
rotas.php
74 lines (60 loc) · 2.49 KB
/
rotas.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
<?php
require_once("conexao.php");
$knownRoutes = [
"" => "index.php",
"home" => "index.php",
"empresa" => "empresa.php",
"produtos" => "produtos.php",
"servicos" => "servicos.php",
"contato" => "contato.php",
];
function curRoute() {
return str_replace(".php", "", substr($_SERVER["REQUEST_URI"],strrpos($_SERVER["REQUEST_URI"],"/")+1));
}
$routeExists = function($route) use ($knownRoutes) {
return array_key_exists($route, $knownRoutes);
};
if (preg_match('/\.(?:png|jpg|jpeg|gif|css|js)$/', $_SERVER["REQUEST_URI"])) {
return false;
} elseif ($routeExists(curRoute())) {
$pageName = $knownRoutes[curRoute()];
if (isset($_POST["_contato"]) && $_POST["_contato"] == 1) {
$getPageContent = function() {
echo '<div class="container"><div class="row"><div class="page-header"><h1>Contato</h1></div>'.
'<div class="col-sm-offset-3 col-sm-6">'.
'<h3>Dados enviados com sucesso!</h3><hr />'.
'<p>'.$_POST["_nome"].'<br />'.$_POST["_email"].'<br />'.$_POST["_assunto"].'<br />'.
$_POST["_mensagem"].'</div></div></div>';
};
} elseif (isset($_POST["_searchForm"]) && $_POST["_searchForm"] == 1) {
$query = "%{$_POST['_pesquisa']}%";
$getPageContent = function() use ($conn, $query) {
$sql = "SELECT * FROM pages WHERE pageContent LIKE :query";
$stmt = $conn->prepare($sql);
$stmt->bindParam("query", $query);
$stmt->execute();
$result = $stmt->fetchAll(\PDO::FETCH_ASSOC);
echo '<div class="container"><div class="row"><div class="page-header"><h1>Pesquisa</h1></div>'.
'<div class="col-sm-12">';
if (count($result)) {
foreach ($result as $page) {
echo "<a href=\"{$page['slug']}\">{$_POST['_pesquisa']} -> ".strtoupper($page['slug'])."</a><br />";
}
} else {
echo "<h3>Termo pesquisado não foi encontrado.</h3>";
}
echo "</div></div></div>";
};
} else {
$getPageContent = function () use ($conn, $pageName) {
$sql = "SELECT pageContent FROM pages WHERE pageName = :pageName";
$stmt = $conn->prepare($sql);
$stmt->bindParam("pageName", $pageName);
$stmt->execute();
$result = $stmt->fetch(\PDO::FETCH_ASSOC);
echo $result["pageContent"];
};
}
} else {
include "404.php";
}