API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jun 12th, 2019
74
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 18.49 KB | None | 0 0
raw download clone embed print report
  1. <?php require "../../Connections/connections.php";
  2.  
  3. $link = new_db_connection();
  4. $stmt = mysqli_stmt_init($link);
  5. $link2 = new_db_connection();
  6. $stmt2 = mysqli_stmt_init($link2);
  7.  
  8. $link6 = new_db_connection();
  9. $stmt6 = mysqli_stmt_init($link6);
  10. $data_1 = date("Y/m/d" );
  11. $data_2 = date("Y/m/d" , strtotime("+1 day"));
  12. $data_3 = date("Y/m/d" , strtotime("+2 day"));
  13. $data_4 = date("Y/m/d" , strtotime("+3 day"));
  14. $data_5 = date("Y/m/d" , strtotime("+4 day"));
  15. $diasemana = array('DOMINGO', 'SEGUNDA-FEIRA', 'TERÇA-FEIRA', 'QUARTA-FEIRA', 'QUINTA-FEIRA', 'SEXTA-FEIRA', 'SABADO');
  16. $diasemana_numero = date('w', strtotime($data_1));
  17.  
  18.  
  19.  
  20.  
  21.  
  22. ?>
  23.  
  24. <!doctype html>
  25. <html lang="en">
  26. <head>
  27. <!-- Required meta tags -->
  28. <meta charset="utf-8">
  29. <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
  30.  
  31. <link rel="shortcut icon" type="image/png" href="../Imagens/logo.png"/>
  32.  
  33. <!-- Bootstrap CSS -->
  34. <link href="../../Bootstrap/css/bootstrap.css" rel="stylesheet">
  35. <link href="../../Bootstrap/css/bootstrap-grid.css" rel="stylesheet">
  36. <link href="../../Bootstrap/css/bootstrap-reboot.css" rel="stylesheet">
  37. <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css"
  38. integrity="sha384-ggOyR0iXCbMQv3Xipma34MD+dH/1fQ784/j6cY/iJTQUOhcWr7x9JvoRxT2MZw1T" crossorigin="anonymous">
  39. <link rel="stylesheet" href="../Estilos/Navbar_Rodape.css">
  40. <link rel="stylesheet" href="../Estilos/Estilos_Bea.css">
  41. <link href="https://fonts.googleapis.com/css?family=CustomFontName" rel="stylesheet">
  42. <title>Ementa</title>
  43. <script src="//code.jquery.com/jquery-1.11.1.min.js"></script>
  44. <script src="../../Bootstrap/js/bootstrap.js"></script>
  45. <script src="../Scripts/fonte.js"></script>
  46. </head>
  47. <body id="body">
  48. <div class="contente">
  49. <?php include_once '../Componentes/menu_flutuante.php' ?>
  50. <!-- NAVBAR -->
  51.  
  52. <?php include_once "../Componentes/navbar.php" ?>
  53.  
  54. <!-- EMENTAS -->
  55.  
  56.  
  57. <div class="container">
  58. <div class="row justify-content-center">
  59. <div class="col-11 col-sm-12">
  60. <h1>Ementa</h1>
  61. <hr>
  62. </div>
  63. </div>
  64. <div class="row justify-content-center">
  65. <div class="col-11 col-sm-12">
  66. <form action = "#" method = "post">
  67. <label for="formGroupExampleInput">Escolas</label>
  68. <br>
  69.  
  70. <select name = "escola" type="button" class="btn rita">
  71. <option value="">Escolas</option>
  72. <?php
  73. $query6 = "SELECT idescolas, nome FROM escolas";
  74. if (mysqli_stmt_prepare($stmt6, $query6)) {
  75.  
  76. /* execute the prepared statement */
  77. if (!mysqli_stmt_execute($stmt6)){
  78. echo "erro;" . mysqli_stmt_error($stmt6);
  79. }
  80.  
  81. /* bind result variables */
  82.  
  83. mysqli_stmt_bind_result($stmt6, $idescolas, $nome);
  84.  
  85. /* fetch values */
  86. while (mysqli_stmt_fetch($stmt6)) {
  87.  
  88. echo'
  89.  
  90. <option value="'.$idescolas.'">'.$nome.'</option>
  91.  
  92. ';
  93.  
  94.  
  95. }
  96.  
  97. /* close statement */
  98. mysqli_stmt_close($stmt6);
  99. } else {
  100. echo "Error: " . mysqli_error($link6);
  101. }
  102.  
  103. /* close connection */
  104. mysqli_close($link6);
  105.  
  106. ?>
  107. </select>
  108. <div class="form-group">
  109. <br>
  110. <button type = "submit" class="ready-btn"> Filtrar </button>
  111. </div>
  112. </form>
  113.  
  114.  
  115.  
  116.  
  117.  
  118.  
  119.  
  120.  
  121.  
  122.  
  123.  
  124.  
  125. <?php
  126.  
  127. if(isset ($_POST['escola'])){
  128. $escola = $_POST['escola'];
  129.  
  130. $query_ementa = "SELECT idementas, ementas.data, sopa_idsopa, salada_idsalada, prato_idprato, sobremesa_idsobremesa, pao_idpao, sopa.nome, salada.nome, prato.nome, sobremesa.nome, pao.nome, sopa.energetico, sopa.lipidos, sopa.acidos, sopa.hidratos, sopa.proteinas, sopa.sal, sopa.acucar, salada.energetico, salada.lipidos, salada.acidos, salada.hidratos, salada.proteinas, salada.sal, salada.acucar, prato.energetico, prato.lipidos, prato.acidos, prato.hidratos, prato.proteinas, prato.sal, prato.acucar, sobremesa.energetico, sobremesa.lipidos, sobremesa.acidos, sobremesa.hidratos, sobremesa.proteinas, sobremesa.sal, sobremesa.acucar, pao.energetico, pao.lipidos, pao.acidos, pao.hidratos, pao.proteinas, pao.sal, pao.acucar FROM ementas
  131. INNER JOIN sopa On ementas.sopa_idsopa = sopa.idsopa
  132. INNER JOIN salada On ementas.salada_idsalada = salada.idsalada
  133. INNER JOIN prato On ementas.prato_idprato = prato.idprato
  134. INNER JOIN sobremesa On ementas.sobremesa_idsobremesa = sobremesa.idsobremesa
  135. INNER JOIN pao On ementas.pao_idpao = pao.idpao
  136. WHERE escolas_idescolas = $escola AND (ementas.data='".$data_1."' OR ementas.data='".$data_2."' OR ementas.data='".$data_3."' OR ementas.data='".$data_4."' OR ementas.data='".$data_5."') ORDER BY ementas.data ";
  137. $query2 = "SELECT idementas, ementas.data, sopa_idsopa, salada_idsalada, prato_idprato, sobremesa_idsobremesa, pao_idpao, sopa.nome, salada.nome, prato.nome, sobremesa.nome, pao.nome, sopa.energetico, sopa.lipidos, sopa.acidos, sopa.hidratos, sopa.proteinas, sopa.sal, sopa.acucar, salada.energetico, salada.lipidos, salada.acidos, salada.hidratos, salada.proteinas, salada.sal, salada.acucar, prato.energetico, prato.lipidos, prato.acidos, prato.hidratos, prato.proteinas, prato.sal, prato.acucar, sobremesa.energetico, sobremesa.lipidos, sobremesa.acidos, sobremesa.hidratos, sobremesa.proteinas, sobremesa.sal, sobremesa.acucar, pao.energetico, pao.lipidos, pao.acidos, pao.hidratos, pao.proteinas, pao.sal, pao.acucar FROM ementas
  138. INNER JOIN sopa On ementas.sopa_idsopa = sopa.idsopa
  139. INNER JOIN salada On ementas.salada_idsalada = salada.idsalada
  140. INNER JOIN prato On ementas.prato_idprato = prato.idprato
  141. INNER JOIN sobremesa On ementas.sobremesa_idsobremesa = sobremesa.idsobremesa
  142. INNER JOIN pao On ementas.pao_idpao = pao.idpao
  143. WHERE idementas = ?";
  144.  
  145.  
  146.  
  147.  
  148.  
  149. if (mysqli_stmt_prepare($stmt, $query_ementa)) {
  150.  
  151. /* execute the prepared statement */
  152. mysqli_stmt_execute($stmt);
  153.  
  154. /* bind result variables */
  155. mysqli_stmt_bind_result($stmt, $idementas, $data, $idsopa, $idsalada, $idprato, $idsobremesa, $idpao, $sopa, $salada, $prato, $sobremesa, $pao, $sopaenergetico, $sopalipidos, $sopaacidos, $sopahidratos, $sopaproteinas, $sopasal, $sopaacucar, $saladaenergetico, $saladalipidos, $saladaacidos, $saladahidratos, $saladaproteinas, $saladasal, $saladaacucar, $pratoenergetico, $pratolipidos, $pratoacidos, $pratohidratos, $pratoproteinas, $pratosal, $pratoacucar, $sobremesaenergetico, $sobremesalipidos, $sobremesaacidos, $sobremesahidratos, $sobremesaproteinas, $sobremesasal, $sobremesaacucar, $paoenergetico, $paolipidos, $paoacidos, $paohidratos, $paoproteinas, $paosal, $paoacucar );
  156.  
  157. /* fetch values */
  158.  
  159. while (mysqli_stmt_fetch($stmt)) {
  160. $diasemana_numero = date('w', strtotime($data));
  161. if((($diasemana[$diasemana_numero]) == "SABADO") || (($diasemana[$diasemana_numero]) == "DOMINGO")) {
  162.  
  163. } else{
  164.  
  165.  
  166.  
  167. echo '
  168.  
  169.  
  170.  
  171. <h3 class="acessibilidadeh3 mt-5">Dia: <a id="data_semana_ementa">
  172. ' . $data.'
  173. </h3>
  174. <br>
  175. <h6 class="acessibilidadeh6"><b><p style="color: darkred"> ' . $diasemana[$diasemana_numero] . '
  176. </p></b></h6>
  177. <table class="table acessibilidade">
  178.  
  179. <tbody>
  180. <tr>
  181.  
  182.  
  183. <td><b>Sopa</b></td>
  184. <td id="sopa">' . $sopa . '</td>
  185. </tr>
  186. <tr>
  187. <td><b>Prato</b></td>
  188. <td id="prato">' . $salada . '</td>
  189. </tr>
  190. <tr>
  191. <td><b>Salada</b></td>
  192. <td id="salada">' . $prato . '</td>
  193. </tr>
  194. <tr>
  195. <td><b>Sobremesa</b></td>
  196. <td id="sobremesa">' . $sobremesa . '</td>
  197. </tr>
  198. <tr>
  199. <td><b>Pão</b></td>
  200. <td id="pao">' . $pao . '</td>
  201. </tr>
  202. <tr>
  203.  
  204. </tr>
  205.  
  206.  
  207.  
  208.  
  209. <td colspan="2">
  210. <!-- Botão da modal -->
  211.  
  212. <button type="button" data-toggle="modal" data-target="#myModal'.$idementas.'" class="ready-btn ml-lg-5"
  213. style="margin-left: 0 !important; padding-left: 20px !important; padding-right: 20px !important">
  214. Valores Nutricionais
  215. </button>
  216. <div class="modal" id="myModal'.$idementas.'">
  217. <div class="modal-dialog">';
  218. if (mysqli_stmt_prepare($stmt2, $query2)) {
  219. mysqli_stmt_bind_param($stmt2, 'i', $idementas);
  220. /* execute the prepared statement */
  221. mysqli_stmt_execute($stmt2);
  222. /* bind result variables */
  223. mysqli_stmt_bind_result($stmt2, $idementas, $data, $idsopa, $idsalada, $idprato, $idsobremesa, $idpao, $sopa, $salada, $prato, $sobremesa, $pao, $sopaenergetico, $sopalipidos, $sopaacidos, $sopahidratos, $sopaproteinas, $sopasal, $sopaacucar, $saladaenergetico, $saladalipidos, $saladaacidos, $saladahidratos, $saladaproteinas, $saladasal, $saladaacucar, $pratoenergetico, $pratolipidos, $pratoacidos, $pratohidratos, $pratoproteinas, $pratosal, $pratoacucar, $sobremesaenergetico, $sobremesalipidos, $sobremesaacidos, $sobremesahidratos, $sobremesaproteinas, $sobremesasal, $sobremesaacucar, $paoenergetico, $paolipidos, $paoacidos, $paohidratos, $paoproteinas, $paosal, $paoacucar );
  224.  
  225. /* resultados da store */
  226. mysqli_stmt_store_result($stmt2);
  227. while (mysqli_stmt_fetch($stmt2)) {
  228. echo 'rrr ';
  229. }
  230. }
  231.  
  232. echo'
  233.  
  234.  
  235.  
  236.  
  237.  
  238. <div class="modal-content">
  239.  
  240. <!-- Modal Header -->
  241. <div class="modal-header">
  242. <h4 class="modal-title"><b>Valores nutricionais</b></h4>
  243. <button type="button" class="close" data-dismiss="modal">&times;</button>
  244. </div>
  245.  
  246. <!-- Modal body -->
  247. <div class="modal-body">
  248. <table class="table-responsive">
  249. <tr>
  250. <th></th>
  251. <th>Energético</th>
  252. <th>Lípidos</th>
  253. <th>Acidos</th>
  254. <th>Hidratos</th>
  255. <th>Proteínas</th>
  256. <th>Sal</th>
  257. <th>Açucar</th>
  258. <th></th>
  259. </tr>
  260. <tr>
  261. <td><b>Sopa</b></td>
  262. <td>' . $sopaenergetico . '</td>
  263. <td>' . $sopalipidos . '</td>
  264. <td>' . $sopaacidos . '</td>
  265. <td>' . $sopahidratos . '</td>
  266. <td>' . $sopaproteinas . '</td>
  267. <td>' . $sopasal . '</td>
  268. <td>' . $sopaacucar . '</td>
  269. </tr>
  270. <tr>
  271. <th>Prato</th>
  272. <td>' . $saladaenergetico . '</td>
  273. <td>' . $saladalipidos . '</td>
  274. <td>' . $saladaacidos . '</td>
  275. <td>' . $saladahidratos . '</td>
  276. <td>' . $saladaproteinas . '</td>
  277. <td>' . $saladasal . '</td>
  278. <td>' . $saladaacucar . '</td>
  279. </tr>
  280. <tr>
  281. <th>Salada</th>
  282. <td>' . $pratoenergetico . '</td>
  283. <td>' . $pratolipidos . '</td>
  284. <td>' . $pratoacidos . '</td>
  285. <td>' . $pratohidratos . '</td>
  286. <td>' . $pratoproteinas . '</td>
  287. <td>' . $pratosal . '</td>
  288. <td>' . $pratoacucar . '</td>
  289. </tr>
  290. <tr>
  291. <th>Sobremesa</th>
  292. <td>' . $sobremesaenergetico . '</td>
  293. <td>' . $sobremesalipidos . '</td>
  294. <td>' . $sobremesaacidos . '</td>
  295. <td>' . $sobremesahidratos . '</td>
  296. <td>' . $sobremesaproteinas . '</td>
  297. <td>' . $sobremesasal . '</td>
  298. <td>' . $sobremesaacucar . '</td>
  299. </tr>
  300. <tr>
  301. <th>Pão</th>
  302. <td>' . $paoenergetico . '</td>
  303. <td>' . $paolipidos . '</td>
  304. <td>' . $paoacidos . '</td>
  305. <td>' . $paohidratos . '</td>
  306. <td>' . $paoproteinas . '</td>
  307. <td>' . $paosal . '</td>
  308. <td>' . $paoacucar . '</td>
  309. </tr>
  310.  
  311. </table>
  312. </div>
  313.  
  314. <!-- Modal footer -->
  315. <div class="modal-footer">
  316. <button type="button" class="btn btn-danger" data-dismiss="modal">Fechar
  317. </button>
  318.  
  319. </div>
  320.  
  321. </div>
  322. </div>
  323. </div>
  324. </td>
  325. </tbody>
  326. </table>
  327.  
  328. <br>
  329.  
  330.  
  331. ';
  332.  
  333. }
  334.  
  335. }
  336. /* close statement */
  337. mysqli_stmt_close($stmt);
  338.  
  339. } else {
  340. echo("Error description: " . mysqli_error($link));
  341. }
  342. } else {
  343. echo 'yyy';
  344. }
  345. ?>
  346. </div></div></div></div>
  347. <br>
  348.  
  349. <a href="#" id="scroll"><span></span></a>
  350. <!-- Footer -->
  351.  
  352. <?php include_once "../Componentes/footer.php"?>
  353.  
  354. <!-- Optional JavaScript -->
  355. <!-- jQuery first, then Popper.js, then Bootstrap JS -->
  356. <script src="../Scripts/NavbarPesquisa.js"></script>
  357.  
  358.  
  359. <script src="https://code.jquery.com/jquery-3.3.1.slim.min.js"
  360. integrity="sha384-q8i/X+965DzO0rT7abK41JStQIAqVgRVzpbzo5smXKp4YfRvH+8abtTE1Pi6jizo"
  361. crossorigin="anonymous"></script>
  362. <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.7/umd/popper.min.js"
  363. integrity="sha384-UO2eT0CpHqdSJQ6hJty5KVphtPhzWj9WO1clHTMGa3JDZwrnQq4sF86dIHNDz0W1"
  364. crossorigin="anonymous"></script>
  365. <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.min.js"
  366. integrity="sha384-JjSmVgyd0p3pXB1rRibZUAYoIIy6OrQ6VrjIEaFf/nJGzIxFDsf4x0xIM+B07jRM"
  367. crossorigin="anonymous"></script>
  368. <script></script>
  369. </body>
  370. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!