API tools faq
paste
Advertisement
Guest User

Untitled

a guest
May 25th, 2019
109
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 20.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.  
  6.  
  7.  
  8. ?>
  9.  
  10.  
  11.  
  12.  
  13. <?php
  14. if (isset($_POST["titulo"])) {
  15.  
  16. $titulo = $_POST["titulo"];
  17. $tema = $_POST["tema"];
  18. $pequenaDesc = $_POST["pequenaDesc"];
  19. $grandeDesc = $_POST["grandeDesc"];
  20. // We need the function!
  21. require_once("../../../../Connections/connections.php");
  22.  
  23. // Create a new DB connection
  24. $link = new_db_connection();
  25.  
  26. /* create a prepared statement */
  27. $stmt = mysqli_stmt_init($link);
  28.  
  29. $query = "INSERT INTO noticias
  30. VALUES (?, ?, ?, ?)";
  31.  
  32. if (mysqli_stmt_prepare($stmt, $query)) {
  33.  
  34. mysqli_stmt_bind_param($stmt, 's',$titulo );
  35.  
  36. /* execute the prepared statement */
  37. if (!mysqli_stmt_execute($stmt)){
  38. echo "Error: " . mysqli_stmt_error($stmt);
  39. }
  40.  
  41. /* close statement */
  42. mysqli_stmt_close($stmt);
  43. }
  44.  
  45. /* close connection */
  46. mysqli_close($link);
  47. }
  48.  
  49.  
  50. ?>
  51.  
  52.  
  53. <!DOCTYPE html>
  54. <html lang="en">
  55.  
  56. <head>
  57.  
  58. <meta charset="utf-8">
  59. <meta http-equiv="X-UA-Compatible" content="IE=edge">
  60. <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
  61. <meta name="description" content="">
  62. <meta name="author" content="">
  63.  
  64. <title>Administração - Notícias</title>
  65.  
  66. <!-- Custom fonts for this template -->
  67. <link href="../../../vendor/fontawesome-free/css/all.min.css" rel="stylesheet" type="text/css">
  68. <link
  69. href="https://fonts.googleapis.com/css?family=Nunito:200,200i,300,300i,400,400i,600,600i,700,700i,800,800i,900,900i"
  70. rel="stylesheet">
  71.  
  72. <!-- Custom styles for this template -->
  73. <link href="../../../css/sb-admin-2.min.css" rel="stylesheet">
  74.  
  75. <!-- Custom styles for this page -->
  76. <link href="../../../vendor/datatables/dataTables.bootstrap4.min.css" rel="stylesheet">
  77. <link href="../../../EstilosAdmin/EstilosAdmin.css" rel="stylesheet">
  78.  
  79. </head>
  80.  
  81. <body id="page-top">
  82.  
  83. <!-- Page Wrapper -->
  84. <div id="wrapper">
  85.  
  86. <!-- Sidebar -->
  87. <ul class="navbar-nav bg-gradient-primary sidebar sidebar-dark accordion colorSideBar" id="accordionSidebar">
  88.  
  89. <!-- Sidebar - Brand -->
  90. <a class="sidebar-brand d-flex align-items-center justify-content-center" href="index.html">
  91. <div class="sidebar-brand-icon rotate-n-15">
  92. <i class="fas fa-laugh-wink"></i>
  93. </div>
  94. <div class="sidebar-brand-text mx-3">Administração<sup></sup></div>
  95. </a>
  96.  
  97. <!-- Divider -->
  98. <hr class="sidebar-divider my-0">
  99.  
  100. <!-- Nav Item - Dashboard -->
  101. <li class="nav-item">
  102. <a class="nav-link " href="../../../index.html">
  103. <i class="fas fa-fw fa-tachometer-alt"></i>
  104. <span>Dashboard</span></a>
  105. </li>
  106.  
  107. <!-- Divider -->
  108. <hr class="sidebar-divider">
  109.  
  110. <!-- Heading -->
  111. <div class="sidebar-heading">
  112. GESTÃO
  113. </div>
  114.  
  115. <!-- Nav Item - Pages Collapse Menu -->
  116. <li class="nav-item">
  117. <a class="nav-link collapsed " href="#" data-toggle="collapse" data-target="#collapseTwo" aria-expanded="true"
  118. aria-controls="collapseTwo">
  119. <i class="fas fa-fw fa-cog"></i>
  120. <span>Utilizadores</span>
  121. </a>
  122. <div id="collapseTwo" class="collapse" aria-labelledby="headingTwo" data-parent="#accordionSidebar">
  123. <div class="bg-white py-2 collapse-inner rounded">
  124. <h6 class="collapse-header">Editar Utilizadores :</h6>
  125. <a class="collapse-item" href="../../../Gestao/Utilizadores/Alunos/index.html">Alunos</a>
  126. <a class="collapse-item" href="../../../Gestao/Utilizadores/EscarregadosEducacao/index.html">Encarregados de
  127. Educação</a>
  128. <a class="collapse-item" href="../../../Gestao/Utilizadores/Professores/index.html">Professores</a>
  129. <a class="collapse-item" href="../../../Gestao/Utilizadores/Administradores/index.html">Administradores</a>
  130. </div>
  131. </div>
  132. </li>
  133.  
  134. <!-- Nav Item - Utilities Collapse Menu -->
  135. <li class="nav-item ">
  136. <a class="nav-link collapsed " href="#" data-toggle="collapse" data-target="#collapseUtilities"
  137. aria-expanded="true" aria-controls="collapseUtilities">
  138. <i class="fas fa-fw fa-wrench"></i>
  139. <span>Escolas</span>
  140. </a>
  141. <div id="collapseUtilities" class="collapse " aria-labelledby="headingUtilities"
  142. data-parent="#accordionSidebar">
  143. <div class="bg-white py-2 collapse-inner rounded">
  144. <h6 class="collapse-header">Editar :</h6>
  145. <a class="collapse-item" href="../../../Gestao/Escolas/Escolas/index.html">Escolas</a>
  146. <a class="collapse-item" href="../../../Gestao/Escolas/Turmas/index.html">Turmas</a>
  147. <a class="collapse-item" href="../../../Gestao/Escolas/Funcionarios/index.html">Funcionários</a>
  148.  
  149. </div>
  150. </div>
  151. </li>
  152.  
  153. <!-- Divider -->
  154. <hr class="sidebar-divider">
  155.  
  156. <!-- Heading -->
  157. <div class="sidebar-heading">
  158. WEBSITE
  159. </div>
  160.  
  161. <!-- Nav Item - Pages Collapse Menu -->
  162. <li class="nav-item">
  163. <a class="nav-link collapsed active" href="#" data-toggle="collapse" data-target="#collapsePages"
  164. aria-expanded="true" aria-controls="collapsePages">
  165. <i class="fas fa-fw fa-folder"></i>
  166. <span>Pages</span>
  167. </a>
  168. <div id="collapsePages" class="collapse" aria-labelledby="headingPages" data-parent="#accordionSidebar">
  169. <div class="bg-white py-2 collapse-inner rounded">
  170. <h6 class="collapse-header">Páginas</h6>
  171. <a class="collapse-item" href="">Homepage</a>
  172. <a class="collapse-item" href="../Historia/index.html">História</a>
  173. <a class="collapse-item" href="../Documentos/index.html">Documentos</a>
  174. <a class="collapse-item" href="../Eventos/index.html">Eventos</a>
  175. <a class="collapse-item" href="../Ementas/index.html">Ementas</a>
  176. <a class="collapse-item" href="../OfertaFormativa/index.html">Oferta Formativa</a>
  177. <a class="collapse-item" href="../Servicos/index.html">Serviços</a>
  178. <a class="collapse-item" href="../Atividades/index.html">Atividades</a>
  179. </div>
  180. </div>
  181. </li>
  182.  
  183. <!-- Nav Item - Charts
  184. <li class="nav-item">
  185. <a class="nav-link" href="charts.html">
  186. <i class="fas fa-fw fa-chart-area"></i>
  187. <span>Charts</span></a>
  188. </li>
  189. -->
  190. <!-- Nav Item - Tables -->
  191. <li class="nav-item">
  192. <a class="nav-link" href="../../Mensagens/index.html">
  193. <i class="fas fa-fw fa-table"></i>
  194. <span>Mensagem</span></a>
  195. </li>
  196.  
  197. <!-- Divider -->
  198. <hr class="sidebar-divider d-none d-md-block">
  199.  
  200. <!-- Sidebar Toggler (Sidebar) -->
  201. <div class="text-center d-none d-md-inline">
  202. <button class="rounded-circle border-0" id="sidebarToggle"></button>
  203. </div>
  204.  
  205. </ul>
  206. <!-- End of Sidebar -->
  207. <!-- End of Sidebar -->
  208.  
  209. <!-- Content Wrapper -->
  210. <div id="content-wrapper" class="d-flex flex-column">
  211.  
  212. <!-- Main Content -->
  213. <div id="content">
  214.  
  215. <!-- Topbar -->
  216. <nav class="navbar navbar-expand navbar-light bg-white topbar mb-4 static-top shadow">
  217.  
  218. <!-- Sidebar Toggle (Topbar) -->
  219. <button id="sidebarToggleTop" class="btn btn-link d-md-none rounded-circle mr-3">
  220. <i class="fa fa-bars"></i>
  221. </button>
  222.  
  223. <!-- Topbar Search -->
  224. <form class="d-none d-sm-inline-block form-inline mr-auto ml-md-3 my-2 my-md-0 mw-100 navbar-search">
  225. <div class="input-group">
  226. <input type="text" class="form-control bg-light border-0 small" placeholder="Search for..."
  227. aria-label="Search" aria-describedby="basic-addon2">
  228. <div class="input-group-append">
  229. <button class="btn btn-primary btnCustom" type="button">
  230. <i class="fas fa-search fa-sm"></i>
  231. </button>
  232. </div>
  233. </div>
  234. </form>
  235. <!-- Topbar Navbar -->
  236. <ul class="navbar-nav ml-auto">
  237. <!-- Nav Item - Search Dropdown (Visible Only XS) -->
  238. <li class="nav-item dropdown no-arrow d-sm-none">
  239. <a class="nav-link dropdown-toggle" href="#" id="searchDropdown" role="button" data-toggle="dropdown"
  240. aria-haspopup="true" aria-expanded="false">
  241. <i class="fas fa-search fa-fw"></i>
  242. </a>
  243. <!-- Dropdown - Messages -->
  244. <div class="dropdown-menu dropdown-menu-right p-3 shadow animated--grow-in"
  245. aria-labelledby="searchDropdown">
  246. <form class="form-inline mr-auto w-100 navbar-search">
  247. <div class="input-group">
  248. <input type="text" class="form-control bg-light border-0 small" placeholder="Search for..."
  249. aria-label="Search" aria-describedby="basic-addon2">
  250. <div class="input-group-append">
  251. <button class="btn btn-primary btnCustom" type="button">
  252. <i class="fas fa-search fa-sm"></i>
  253. </button>
  254. </div>
  255. </div>
  256. </form>
  257. </div>
  258. </li>
  259.  
  260. <!-- Nav Item - Alerts -->
  261. <li class="nav-item dropdown no-arrow mx-1">
  262. <a class="nav-link dropdown-toggle" href="#" id="alertsDropdown" role="button" data-toggle="dropdown"
  263. aria-haspopup="true" aria-expanded="false">
  264. <i class="fas fa-bell fa-fw"></i>
  265. <!-- Counter - Alerts -->
  266. <span class="badge badge-danger badge-counter">3+</span>
  267. </a>
  268. <!-- Dropdown - Alerts -->
  269. <div class="dropdown-list dropdown-menu dropdown-menu-right shadow animated--grow-in"
  270. aria-labelledby="alertsDropdown">
  271. <h6 class="dropdown-header CustomHeader">
  272. Alertas Atividade
  273. </h6>
  274. <a class="dropdown-item d-flex align-items-center" href="#">
  275. <div class="mr-3">
  276. <div class="icon-circle bg-primary customCircle">
  277. <i class="fas fa-file-alt text-white"></i>
  278. </div>
  279. </div>
  280. <div>
  281. <div class="small text-gray-500">December 12, 2019</div>
  282. <span class="font-weight-bold">A new monthly report is ready to download!</span>
  283. </div>
  284. </a>
  285. <a class="dropdown-item text-center small text-gray-500" href="#">Show All Alerts</a>
  286. </div>
  287. </li>
  288.  
  289. <!-- Nav Item - Messages -->
  290. <li class="nav-item dropdown no-arrow mx-1">
  291. <a class="nav-link dropdown-toggle" href="#" id="messagesDropdown" role="button" data-toggle="dropdown"
  292. aria-haspopup="true" aria-expanded="false">
  293. <i class="fas fa-envelope fa-fw"></i>
  294. <!-- Counter - Messages -->
  295. <span class="badge badge-danger badge-counter">7</span>
  296. </a>
  297. <!-- Dropdown - Messages -->
  298. <div class="dropdown-list dropdown-menu dropdown-menu-right shadow animated--grow-in"
  299. aria-labelledby="messagesDropdown">
  300. <h6 class="dropdown-header CustomHeader">
  301. Mensagens Recebidas
  302. </h6>
  303. <a class="dropdown-item d-flex align-items-center" href="#">
  304. <div class="dropdown-list-image mr-3">
  305. <img class="rounded-circle" src="https://source.unsplash.com/fn_BT9fwg_E/60x60" alt="">
  306. <div class="status-indicator bg-success"></div>
  307. </div>
  308. <div class="font-weight-bold">
  309. <div class="text-truncate">Hi there! I am wondering if you can help me with a problem I've been
  310. having.</div>
  311. <div class="small text-gray-500">Emily Fowler · 58m</div>
  312. </div>
  313. </a>
  314. <a class="dropdown-item text-center small text-gray-500" href="#">Read More Messages</a>
  315. </div>
  316. </li>
  317.  
  318. <div class="topbar-divider d-none d-sm-block"></div>
  319.  
  320. <!-- Nav Item - User Information -->
  321. <li class="nav-item dropdown no-arrow">
  322. <a class="nav-link dropdown-toggle" href="#" id="userDropdown" role="button" data-toggle="dropdown"
  323. aria-haspopup="true" aria-expanded="false">
  324. <span class="mr-2 d-none d-lg-inline text-gray-600 small">Álvaro Magalhães</span>
  325. <img class="img-profile rounded-circle" src="../../../img/ALV.jpg">
  326. </a>
  327. <!-- Dropdown - User Information -->
  328. <div class="dropdown-menu dropdown-menu-right shadow animated--grow-in" aria-labelledby="userDropdown">
  329. <a class="dropdown-item" href="#">
  330. <i class="fas fa-user fa-sm fa-fw mr-2 text-gray-400"></i>
  331. Profile
  332. </a>
  333. <a class="dropdown-item" href="#">
  334. <i class="fas fa-cogs fa-sm fa-fw mr-2 text-gray-400"></i>
  335. Settings
  336. </a>
  337. <a class="dropdown-item" href="#">
  338. <i class="fas fa-list fa-sm fa-fw mr-2 text-gray-400"></i>
  339. Activity Log
  340. </a>
  341. <div class="dropdown-divider"></div>
  342. <a class="dropdown-item" href="#" data-toggle="modal" data-target="#logoutModal">
  343. <i class="fas fa-sign-out-alt fa-sm fa-fw mr-2 text-gray-400"></i>
  344. Logout
  345. </a>
  346. </div>
  347. </li>
  348.  
  349. </ul>
  350.  
  351. </nav>
  352. <!-- End of Topbar -->
  353.  
  354. <!-- Begin Page Content -->
  355.  
  356. <div class="container-fluid">
  357. <h1 class="h3 mb-2 text-gray-800">Notícias</h1>
  358. <p class="mb-4">Colocar aqui uma descrição do Mambo.</p>
  359. <div class="row">
  360. <div class="col-xl-12">
  361.  
  362. <form method = "post" action = "#">
  363. <div class="form-group">
  364. <label for="formGroupExampleInput">Título</label>
  365. <input type="text" class="form-control" name="titulo" placeholder="Indique o título">
  366. </div>
  367. <div class="form-group">
  368. <label for="formGroupExampleInput">Tema</label>
  369. <input type="text" class="form-control" name="tema" placeholder="Indique o tema">
  370. </div>
  371. <!--
  372. <div class="form-group">
  373. <label for="formGroupExampleInput">Imagem</label>
  374. <div class="file-upload-wrapper">
  375. <input type="file" id="input-file-now" class="file-upload" />
  376. </div>
  377. </div>
  378. -->
  379. <div class="form-group">
  380. <label for="formGroupExampleInput2">Pequena Descrição da notícia</label>
  381. <textarea type="text" class="form-control" name="pequenaDesc"
  382. placeholder="Insira aqui o corpo da sua notícia"></textarea>
  383. </div>
  384.  
  385. <div class="form-group">
  386. <label for="formGroupExampleInput2">Grande Descrição da notícia</label>
  387. <textarea type="text" class="form-control" name="grandeDesc"
  388. placeholder="Insira aqui o corpo da sua notícia"></textarea>
  389. </div>
  390. <div class="form-group">
  391. <input type = "submit" value = "Criar" class="buttonCustomise">
  392. </div>
  393. </form>
  394. </div>
  395. </div>
  396. <div class="card-header py-3">
  397. <h6 class="m-0 font-weight-bold text-primary textCustom">Notícias do Agrupamento</h6>
  398. </div>
  399. <div class="card-body">
  400. <div class="table-responsive">
  401. <table class="table table-bordered" id="dataTable" width="100%" cellspacing="0">
  402. <thead>
  403. <tr>
  404. <th>Título</th>
  405. <th>Tema</th>
  406. <th>ID</th>
  407. <th>Ação</th>
  408. </tr>
  409. </thead>
  410. <tfoot>
  411. <tr>
  412. <th>Título</th>
  413. <th>Tema</th>
  414. <th>ID</th>
  415. <th>Ação</th>
  416. </tr>
  417. </tfoot>
  418. <tbody>
  419. <?php
  420. $query = "SELECT * FROM noticias";
  421. if (mysqli_stmt_prepare($stmt, $query)) {
  422.  
  423. /* execute the prepared statement */
  424. mysqli_stmt_execute($stmt);
  425.  
  426. /* bind result variables */
  427. mysqli_stmt_bind_result($stmt, $id_noticias, $titulo, $imagem, $grande_desc, $tema, $pequena_desc);
  428.  
  429. /* fetch values */
  430. while (mysqli_stmt_fetch($stmt)) {
  431.  
  432.  
  433. echo '
  434. <tr>
  435.  
  436.  
  437. <td>'.$titulo.'</td>
  438. <td>'.$tema.'</td>
  439. <td>'.$id_noticias.'</td>
  440. <td>
  441. <i class="fas fa-trash"></i>
  442. <a href="../Homepage/editar.php?id='.$id_noticias.'"><i class="fas fa-edit"></i> </a></td>
  443. </tr>
  444. ';}
  445.  
  446. echo' </tbody>
  447. </table>
  448. </div>
  449. </div>
  450.  
  451.  
  452.  
  453.  
  454.  
  455. </div>';
  456.  
  457.  
  458.  
  459. /* close statement */
  460. mysqli_stmt_close($stmt);
  461. } else {
  462. echo("Error description: " . mysqli_error($link));
  463. }
  464.  
  465. /* close connection */
  466. mysqli_close($link);
  467. ?>
  468. <!-- End of Page Wrapper -->
  469.  
  470. <!-- Scroll to Top Button-->
  471. <a class="scroll-to-top rounded" href="#page-top">
  472. <i class="fas fa-angle-up"></i>
  473. </a>
  474.  
  475. <!-- Logout Modal-->
  476. <div class="modal fade" id="logoutModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel"
  477. aria-hidden="true">
  478. <div class="modal-dialog" role="document">
  479. <div class="modal-content">
  480. <div class="modal-header">
  481. <h5 class="modal-title" id="exampleModalLabel">Ready to Leave?</h5>
  482. <button class="close" type="button" data-dismiss="modal" aria-label="Close">
  483. <span aria-hidden="true">×</span>
  484. </button>
  485. </div>
  486. <div class="modal-body">Select "Logout" below if you are ready to end your current session.</div>
  487. <div class="modal-footer">
  488. <button class="btn btn-secondary" type="button" data-dismiss="modal">Cancel</button>
  489. <a class="btn btn-primary" href="login.html">Logout</a>
  490. </div>
  491. </div>
  492. </div>
  493. </div>
  494.  
  495. <!-- Bootstrap core JavaScript-->
  496. <script src="../../../vendor/jquery/jquery.min.js"></script>
  497. <script src="../../../vendor/bootstrap/js/bootstrap.bundle.min.js"></script>
  498.  
  499. <!-- Core plugin JavaScript-->
  500. <script src="../../../vendor/jquery-easing/jquery.easing.min.js"></script>
  501.  
  502. <!-- Custom scripts for all pages-->
  503. <script src="../../../js/sb-admin-2.min.js"></script>
  504. <!-- Page level plugins -->
  505. <script src="../../../vendor/chart.js/Chart.min.js"></script>
  506.  
  507. <!-- Page level custom scripts -->
  508. <script src="../../../js/demo/chart-area-demo.js"></script>
  509. <script src="../../../js/demo/chart-pie-demo.js"></script>
  510.  
  511. <!-- Page level plugins -->
  512. <script src="../../../vendor/datatables/jquery.dataTables.min.js"></script>
  513. <script src="../../../vendor/datatables/dataTables.bootstrap4.min.js"></script>
  514.  
  515. <!-- Page level custom scripts -->
  516. <script src="../../../js/demo/datatables-demo.js"></script>
  517.  
  518. </body>
  519.  
  520. </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!