Advertisement
brunopedretti

Untitled

Aug 3rd, 2017
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.51 KB | None | 0 0
  1. <html lang="pt-br">
  2. <head>
  3. <meta charset="UTF-8"/>
  4. <title></title>
  5. <link href="../css/style.css" rel="stylesheet" />
  6. <script type="../text/javascript" src="js/script.js"></script>
  7. </head>
  8. <body>
  9. <div class="menu">
  10. <div class="menuint">
  11. <img src="images/house-menu.png" border="0" width="40" height="40" class="menumobile" onclick="toggleMenu()" />
  12. <ul id="menu">
  13. <li><a href="../index.php">home</a></li>
  14. <li>
  15. <a href="../">Crediário</a>
  16. <img src="../images/sortdown.png" border="0" width="10" />
  17. <div class="submenu">
  18. <a href="opencrediario.php"><div class="submenuitem">Abrir Crediário</div></a>
  19. <a href="../"><div class="submen/uitem">Sub menu 2</div></a>
  20. <a href="../"><div class="submenuitem">Sub menu 3</div></a>
  21. <a href="../"><div class="submenuitem">Sub menu 4</div></a>
  22. <a href="../"><div class="submenuitem">Sub menu 5</div></a>
  23. </div>
  24. </li>
  25. <li>
  26. <a href="../">Cadastro</a>
  27. <img src="../images/sortdown.png" border="0" width="10" />
  28. <div class="submenu">
  29. <a href="../cadastropessoas/cadastropessoas.php"><div class="submenuitem">pessoas</div></a>
  30. <a href="../"><div class="submen/uitem">Sub menu 2</div></a>
  31. <a href="../"><div class="submenuitem">Sub menu 3</div></a>
  32. <a href="../"><div class="submenuitem">Sub menu 4</div></a>
  33. <a href="../"><div class="submenuitem">Sub menu 5</div></a>
  34. </div>
  35. </li>
  36. <li><a href="./">Esportes</a></li>
  37. <li><a href="./">Gerak</a></li>
  38. <li><a href="./">Noticias</a></li>
  39. <li><a href="./">policia</a></li>
  40. <li><a href="./">videos</a></li>
  41. </ul>
  42. </div>
  43. <h1 style="text-align:center;">Abrertura de Crediário</h1>
  44. <div class="formcadastro">
  45. <?php
  46. if(isset($_POST['nome']) && !empty($_POST['nome'])) {
  47. if(isset($_POST['valordebito']) && !empty($_POST['valordebito'])) {
  48. if(isset($_POST['qtdparcela']) && !empty($_POST['qtdparcela'])) {
  49. if(isset($_POST['valorparcela']) && !empty($_POST['valorparcela'])) {
  50. if(isset($_POST['datavencimento']) && !empty($_POST['datavencimento'])) {
  51. //projeto ante f5, para não enviar formulario duas vezes
  52. header("Location: crediario/opnecrediario.php");
  53. }
  54. }
  55. }
  56. }
  57. }
  58. ?>
  59. <form name="form2" method="POST" >
  60. <?php
  61. $dsn = "mysql:dbname=projetobruno;host=localhost";
  62. $dbuser = "root";
  63. $dbpass = "";
  64.  
  65. try {
  66. $pdo = new PDO($dsn, $dbuser, $dbpass);
  67.  
  68. $sql = "SELECT * FROM cadpessoas";
  69. $sql = $pdo->query($sql);
  70.  
  71. } catch(PDOException $e) {
  72. echo "Falhou: ".$e->getMessage();
  73. }
  74. ?>
  75. Nome do consignatário: <br/>
  76. <select name="nome" style="width: 173px" required>
  77. <?php
  78. if($sql->rowCount() > 0) {
  79.  
  80. foreach ($sql->fetchAll() as $cadpessoas) {
  81. ?>
  82. <option value="Nome">
  83. <?php echo $cadpessoas["nome"] ?>
  84. </option>
  85. <?php
  86. }
  87.  
  88. } else {
  89. echo "Não há pessoas cadastradas";
  90. }
  91. ?>
  92. </select><br/>
  93. </form>
  94.  
  95.  
  96.  
  97.  
  98.  
  99.  
  100. <form action="crediario.php">
  101. Valor do débito: <br/>
  102. <input type="text" name="valordebito" required /><br/><br/>
  103. <!--
  104. Quantia de parcelas: <br/>
  105. <select name="qtdparcela" style="width: 173px" required>
  106. <option>1</option>
  107. <option>2</option>
  108. <option>3</option>
  109. <option>4</option>
  110. </select><br/><br/>
  111.  
  112. Valor da parcela: <br/>
  113. <input type="text" name="valorparcela" required/><br/><br/>
  114. Data de vencimento:<br/>
  115. <input type="date" name="datavencimento" required><br/><br/>
  116. -->
  117. <input type="submit" value="Enviar" onclick="return validarcred()"/><br/><br/>
  118. </form>
  119. </div>
  120. </body>
  121. </html>
  122.  
  123. -----------------------------------------
  124. crediario.php arquivo da action.
  125.  
  126. <?php
  127.  
  128. $dsn = "mysql:dbname=projetobruno;host=localhost";
  129. $dbuser = "root";
  130. $dbpass= "";
  131.  
  132. try {
  133. $pdo = new PDO($dsn, $dbuser, $dbpass);
  134.  
  135. $saldodevedor = $_POST['valordebito'];
  136.  
  137. /*
  138. $datavencimento = $_POST['datavencimento'];
  139. , datavencimento = '$datavencimento'
  140. $qtdparcela = $_POST['qtdparcela'];
  141. , quantia_parcela = '$qtdparcela'
  142. */
  143. $sql = "INSERT INTO crediario SET saldo_devedor = '$saldodevedor'";
  144. $sql = $pdo->query($sql);
  145.  
  146. header("Location: opencrediario.php");
  147.  
  148. } catch(PDOException $e) {
  149. echo "Falhou: ".$e->getMessage();
  150. }
  151. ?>
  152. --------------------------------------------------
  153. style.css
  154.  
  155. body {
  156. margin:0;
  157. }
  158. .menu {
  159. height:40px;
  160. background-color:#FFFFFF;
  161. border:1px solid #b2b2b2;
  162. }
  163. .menuint {
  164. width:100%;
  165. max-width:1040px;
  166. height:40px;
  167. margin:auto;
  168. }
  169. .menu ul {
  170. margin:0;
  171. padding:0;
  172. list-style:none;
  173. }
  174. .menu li {
  175. float:left;
  176. height:40px;
  177. line-height:40px;
  178. padding-left:8px;
  179. padding-right:8px;
  180. }
  181. .menu li:hover .submenu {
  182. display:block;
  183. }
  184. .menu a {
  185. color:#000000;
  186. text-decoration:none;
  187. }
  188. .submenu{
  189. width:150px;
  190. height:150px;
  191. background-color:#FFFFFF;
  192. position:absolute;
  193. display:none;
  194. }
  195. .submenuitem {
  196. width:140px;
  197. height:30px;
  198. line-height:30px;
  199. }
  200. .submenuitem:hover {
  201. background-color:#DCDCDC;
  202. }
  203. .menumobile {
  204. display:none;
  205. }
  206. .formcadastro {
  207. background-color:#DCDCDC;
  208. width:360px;
  209. margin-left:30%;
  210. margin-top:40px;
  211. padding-top:10px;
  212. padding-left:170px;
  213. }
  214. input {
  215. margin:auto;
  216. }
  217. table {
  218. font-family: arial, sans-serif;
  219. border-collapse: collapse;
  220. width: 80%;
  221. margin:auto;
  222. }
  223.  
  224. td, th {
  225. border: 1px solid #dddddd;
  226. text-align: left;
  227. padding: 8px;
  228. }
  229.  
  230. tr:nth-child(even) {
  231. background-color: #dddddd;
  232. }
  233. @media only screen and (min-width:906px) and (max-width:1057px) {
  234. .menuint {
  235. max-width:890px;
  236. }
  237. .formcadastro {
  238. background-color:#DCDCDC;
  239. width:360px;
  240. margin-left:25%;
  241. margin-top:40px;
  242. padding-top:10px;
  243. padding-left:170px;
  244. }
  245. }
  246. @media only screen and (min-width:783px) and (max-width:906px) {
  247. .menuint {
  248. max-width:768px;
  249. }
  250. .formcadastro {
  251. background-color:#DCDCDC;
  252. width:360px;
  253. margin-left:25%;
  254. margin-top:40px;
  255. padding-top:10px;
  256. padding-left:170px;
  257. }
  258. }
  259. @media only screen and (max-width:783px) {
  260. .menuint {
  261. max-width:320px;
  262. }
  263. .menu ul {
  264. position:absolute;
  265. background-color:#FFFFFF;
  266. z-index:10;
  267. display:none;
  268. }
  269. .menu li {
  270. float:none;
  271. height:auto;
  272. }
  273. .menu li img {
  274. display:none;
  275. }
  276. .submenu {
  277. position:static;
  278. display:block;
  279. }
  280. .menumobile {
  281. display:block;
  282. }
  283. .submenuitem:hover {
  284. background-color:#FFFFFF;
  285. }
  286. .formcadastro {
  287. background-color:#DCDCDC;
  288. width:360px;
  289. margin-left:15%;
  290. margin-top:40px;
  291. padding-top:10px;
  292. padding-left:170px;
  293. }
  294. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement