API tools faq
paste
Guest User

Untitled

a guest
Jan 7th, 2017
48
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 18.75 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. $odkdy = "";
  3. $pocet = "";
  4. $trida = "";
  5.  
  6.  
  7.  
  8. $atts = array('odkdy' => null, 'pocet' => null, 'trida' => null);
  9. if (isset($_POST['napiste2']) && isset($_POST['odkud']) && isset($_POST['kam'])) {
  10.  
  11. if (empty($_POST['odkdy']) || empty($_POST['pocet']) || empty($_POST['trida'])) {
  12.  
  13.  
  14. if (!empty($_POST['odkdy']))
  15. $odkdy = $_POST['odkdy'];
  16. else
  17. $atts['odkdy'] = array("style" => "color:red");
  18.  
  19.  
  20. if (!empty($_POST['pocet']))
  21. $pocet = $_POST['pocet'];
  22. else
  23. $atts['pocet'] = array("style" => "color:red");
  24.  
  25. if (!empty($_POST['trida']))
  26. $trida = $_POST['trida'];
  27. else
  28. $atts['trida'] = array("style" => "color:red");
  29.  
  30. $messageNapiste = 'Vyplňte všechna povinná pole.';
  31. } else {
  32.  
  33.  
  34.  
  35. $odkdy = Date('yyyy-mm-dd');
  36. $db = new Oracle();
  37. $db->connect();
  38. echo $db->doSql("insert into JEDNOSMERNA (ODKUD,KAM, ODKDY,POCETOSOB,TRIDA)"
  39. . " values ('"
  40. . $_POST['odkud']
  41. . "','"
  42. . $_POST['kam']
  43. . "','"
  44. . $_POST['odkdy']
  45. . "','"
  46. . $_POST['pocet']
  47. . "','"
  48. . $_POST['trida']
  49. . "') ");
  50. }
  51. }
  52.  
  53.  
  54. $jmeno = "";
  55. $heslo = "";
  56. $email = "";
  57. $real = "";
  58. $admin = "";
  59.  
  60. $atts = array('jmeno' => null, 'heslo' => null, 'email' => null, 'real' => null);
  61. if (isset($_POST['registrovat'])) {
  62.  
  63.  
  64.  
  65. if (empty($_POST['jmeno']) || empty($_POST['heslo']) || empty($_POST['email']) || empty($_POST['real'])) {
  66. if (!empty($_POST['jmeno']))
  67. $jmeno = $_POST['jmeno'];
  68. else
  69. $atts['jmeno'] = array("style" => "color:red");
  70.  
  71. if (!empty($_POST['heslo']))
  72. $heslo = $_POST['heslo'];
  73. else
  74. $atts['heslo'] = array("style" => "color:red");
  75.  
  76. if (!empty($_POST['email']))
  77. $email = $_POST['email'];
  78. else
  79. $atts['email'] = array("style" => "color:red");
  80.  
  81. if (!empty($_POST['real']))
  82. $real = $_POST['real'];
  83. else
  84. $atts['real'] = array("style" => "color:red");
  85.  
  86.  
  87.  
  88. $messageNapiste = 'Vyplňte všechna povinná pole.';
  89. } else {
  90.  
  91. $date = Date('d.m.y');
  92. $db = new Oracle();
  93. $db->connect();
  94.  
  95. echo $db->insert("insert into USERSS (USERNAME,PASSWORD,EMAIL,REALNAME,CREATED,ADMIN) values "
  96. . "('"
  97. . $_POST['jmeno']
  98. . "','"
  99. . $_POST['heslo']
  100. . "','"
  101. . $_POST['email']
  102. . "','"
  103. . $_POST['real']
  104. . "',TO_DATE('"
  105. . $date
  106. . "', 'DD.MM.RR')"
  107. . ","
  108. . "'no')");
  109. }
  110. }
  111.  
  112.  
  113. include 'class/Form.php';
  114. $f = new Form();
  115. $form = $f->startForm($_SERVER['SCRIPT_NAME'] . '?' . $_SERVER['QUERY_STRING']);
  116. //$additionalAtt = array_merge(
  117. // array("class" => "dumb", "id" => "dumpId"), $atts['jmeno']);
  118. //var_dump($additionalAtt);
  119. $form .= $f->addLabel('Uživatelské jmeno:', $atts['jmeno']);
  120. $form .= $f->addInput('text', 'jmeno', $jmeno);
  121.  
  122. $form .= $f->addLabel('Heslo:', $atts['heslo']);
  123. $form .= $f->addInput('text', 'heslo', $heslo);
  124.  
  125. $form .= $f->addLabel('Emailova adresa:', $atts['email']);
  126. $form .= $f->addInput('text', 'email', $email);
  127.  
  128. $form .= $f->addLabel('Skutečné jméno:', $atts['real']);
  129. $form .= $f->addInput('text', 'real', $real);
  130.  
  131. $form .= $f->addInput('submit', 'registrovat', 'Odeslat');
  132. $form .= $f->addInput('reset', 'reset', 'Vymazat');
  133. $form .= $f->endForm();
  134.  
  135.  
  136.  
  137.  
  138. $odkud = "";
  139. $kam = "";
  140. $odkdy = "";
  141. $dokdy = "";
  142. $pocet = "";
  143. $trida = "";
  144. $id_os = "";
  145. $os = array("Praha", "Londyn");
  146.  
  147.  
  148.  
  149.  
  150. $atts = array('odkud' => null, 'kam' => null, 'odkdy' => null, 'dokdy' => null, 'pocet' => null, 'trida' => null);
  151. if (isset($_POST['napiste'])) {
  152. if (empty($_POST['odkud']) || empty($_POST['kam']) || empty($_POST['odkdy']) || empty($_POST['dokdy']) || empty($_POST['pocet']) || empty($_POST['trida'])) {
  153. if (!empty($_POST['odkud']))
  154. $odkud = $_POST['odkud'];
  155. else
  156. $atts['odkud'] = array("style" => "color:red");
  157.  
  158.  
  159. if (!empty($_POST['kam']))
  160. $kam = $_POST['kam'];
  161. else
  162. $atts['kam'] = array("style" => "color:red");
  163.  
  164. if (!empty($_POST['odkdy']))
  165. $odkdy = $_POST['odkdy'];
  166. else
  167. $atts['odkdy'] = array("style" => "color:red");
  168.  
  169. if (!empty($_POST['dokdy']))
  170. $dokdy = $_POST['dokdy'];
  171. else
  172. $atts['dokdy'] = array("style" => "color:red");
  173.  
  174. if (!empty($_POST['pocet']))
  175. $pocet = $_POST['pocet'];
  176. else
  177. $atts['pocet'] = array("style" => "color:red");
  178.  
  179. if (!empty($_POST['trida']))
  180. $trida = $_POST['trida'];
  181. else
  182. $atts['trida'] = array("style" => "color:red");
  183.  
  184. if (!empty($_POST['id_os']))
  185. $id_os = $_POST['id_os'];
  186. else
  187. $atts['id_os'] = array("style" => "color:red");
  188.  
  189. $messageNapiste = 'Vyplňte všechna povinná pole.';
  190. } else {
  191.  
  192. $odkdy = Date('yyyy-mm-dd');
  193. $dokdy = Date('yyyy-mm-dd');
  194. $db = new Oracle();
  195. $db->connect();
  196. echo $db->doSql("insert into ZPATECNI (ODKUD,KAM, ODKDY,DOKDY,POCETOSOB,TRIDA, ID_OSOBA) values "
  197. . "('"
  198. . $_POST['odkud']
  199. . "','"
  200. . $_POST['kam']
  201. . "','"
  202. . $_POST['odkdy']
  203. . "','"
  204. . $_POST['dokdy']
  205. . "','"
  206. . $_POST['pocet']
  207. . "','"
  208. . $_POST['trida']
  209. . "','"
  210. . $_POST['id_os']
  211. . "') ");
  212. }
  213. }
  214. ?>
  215.  
  216.  
  217. <aside id="section_top">
  218. <article>
  219.  
  220. <hgroup>
  221. <h2> <span>Letenky za kačku</span></h2>
  222. </hgroup>
  223. </article>
  224. </aside>
  225.  
  226.  
  227. <section id="section_middle">
  228. <div>
  229.  
  230. <?php
  231. $message_login = "";
  232. $auth = new Auth();
  233. $auth = Auth::getInstance();
  234. if ($auth->hasIdentity()) {
  235. ?>
  236. <div>Jste přihlášen/a, pro odhlášení klikněte níže.</div><br><br>
  237. <div><a href="<?php echo $_SERVER['SCRIPT_NAME'] . '?co=logout'; ?>">Odhlaš mě, děkuji.</a></div><br><br>
  238. <?php
  239. $db = new Oracle();
  240. $db->connect();
  241. //require_once("class/admin.php");
  242. } else {
  243. ?>
  244. <h2>Máte u nás účet? Přihlašte se!</h2>
  245.  
  246. <form method="post" action="<?php echo $_SERVER['SCRIPT_NAME'] . '?' . $_SERVER['QUERY_STRING']; ?>">
  247. <input type="text" name="username" value="Vaše jméno" onfocus="if (this.value == 'Vaše jméno') {
  248. this.value = ''
  249. }" onblur="if (this.value == '') {
  250. this.value = 'Vaše jméno'
  251. }"/><br/>
  252. <input type="password" name="password" value="Vaše heslo" onfocus="if (this.value == 'Vaše heslo') {
  253. this.value = ''
  254. }" onblur="if (this.value == '') {
  255. this.value = 'Vaše heslo'
  256. }"/><br/>
  257.  
  258. <input type="submit" name="login" value="Přihlásit se"/><br/><br/>
  259.  
  260. </form>
  261.  
  262.  
  263.  
  264.  
  265.  
  266. <h2>Nemáte účet? Zaregistrujte se!</h2>
  267.  
  268.  
  269. <?php
  270. echo $form;
  271. if (isset($messageNapiste))
  272. echo '<div style="color:red;">' . $messageNapiste . '</div>';
  273. ?>
  274.  
  275. </div><br><br>
  276. <?php
  277. }
  278. ?>
  279.  
  280.  
  281.  
  282. <?php
  283. error_reporting(E_ERROR);
  284. session_start();
  285. require_once("class/Oracle.php");
  286.  
  287. $atts = array('username' => "", 'password' => null);
  288.  
  289. if (isset($_POST['login'])) {
  290.  
  291. if (!empty($_POST['username']) && !empty($_POST['password'])) {
  292. $jmeno = $_POST['username'];
  293. $heslo = $_POST['password'];
  294. //echo $_POST['username'];
  295.  
  296. $st = $db->parseAndExecute("SELECT * FROM USERSS WHERE USERNAME ='" . $_POST['username']
  297. . "' AND PASSWORD =('" . $_POST['password'] . "')");
  298.  
  299. //var_dump($st);
  300. while (($row = oci_fetch_array($st, OCI_ASSOC + OCI_RETURN_LOBS)) != NULL) {
  301. //echo 'aaa';
  302. if (count($row) > 0) {
  303. $dbusername = $row['USERNAME'];
  304. $dbpassword = $row['PASSWORD'];
  305. $dbgroup_id = $row['ADMIN'];
  306. $dbemail = $row['EMAIL'];
  307. //echo $dbusername;
  308. }
  309. }
  310.  
  311.  
  312. if ($jmeno == $dbusername) {
  313. session_start();
  314. $_SESSION['admin'] = $dbgroup_id;
  315. $_SESSION['session_username'] = $username;
  316. $_SESSION['user_email'] = $dbemail;
  317. //echo $username;
  318. } else {
  319. $messageLogin = 'Uzivatel s takovym jmenem neexistuje';
  320. }
  321. } else {
  322. $message = "All fields are required!";
  323. }
  324. }
  325.  
  326.  
  327. if (isset($_POST['reset'])) {
  328. unset($atts['username']);
  329. unset($atts['password']);
  330. $atts['username'] = "";
  331. $atts['password'] = "";
  332. }
  333.  
  334. if ($_SESSION['admin'] == 'yes') {
  335. echo 'jsi admin';
  336.  
  337.  
  338. $r = $db->parseAndExecute("SELECT * FROM USERSS where admin = 'no'");
  339. while (($row = oci_fetch_array($r, OCI_ASSOC + OCI_RETURN_LOBS)) != false) {
  340. ?>
  341.  
  342. <form method="post" action="<?php echo $_SERVER['SCRIPT_NAME'] . '?' . $_SERVER['QUERY_STRING']; ?>">
  343. <label for="id2">Id:</label>
  344. <input type="text" name="id2" value="<?php echo $row['ID'] ?>" onfocus="if (this.value ==<?php echo $row['ID'] ?>) {
  345. this.value = ''
  346. }" onblur="if (this.value == '') {
  347. this.value = 'Vaše id'
  348. }"/><br/>
  349. <label for="user2">Jméno:</label>
  350. <input type="text" name="user2" value="<?php echo $row['USERNAME'] ?>" onfocus="if (this.value ==<?php echo $row['USERNAME'] ?>) {
  351. this.value = ''
  352. }" onblur="if (this.value == '') {
  353. this.value = 'Vaše jméno'
  354. }"/><br/>
  355. <label for="pass2">Přijmení:</label>
  356. <input type="text" name="pass2" value="<?php echo $row['PASSWORD'] ?>" onfocus="if (this.value == <?php echo $row['PASSWORD'] ?>) {
  357. this.value = ''
  358. }" onblur="if (this.value == '') {
  359. this.value = 'Vaše heslo'
  360. }"/><br/>
  361.  
  362. <input type="submit" value="Smazat uživatele" name="drop"/><br/>
  363. <input type="submit" value="Změnit uživatelské údaje" name="zmen"/><br/>
  364. </form><br/>
  365. <?php
  366. }
  367. } else {
  368. echo 'jsi user';
  369. ?>
  370. <?php
  371. session_start();
  372.  
  373. $_SESSION['username'] = $user;
  374. $_SESSION['password'] = $pa;
  375. //echo $_SESSION['session_username'];
  376.  
  377. $t = $db->parseAndExecute("SELECT * FROM USERSS WHERE USERNAME ='" . $_POST['username']
  378. . "' AND PASSWORD ='" . $_POST['password'] . "'");
  379.  
  380. while (($row = oci_fetch_array($t, OCI_ASSOC + OCI_RETURN_LOBS)) != false) {
  381. ?>
  382.  
  383. <form method="post" action="<?php echo $_SERVER['SCRIPT_NAME'] . '?' . $_SERVER['QUERY_STRING']; ?>">
  384. <label for="id">Id:</label>
  385. <input type="text" name="id_zmen2" value="<?php echo $row['ID'] ?>" onfocus="if (this.value ==<?php echo $row['ID'] ?>) {
  386. this.value = ''
  387. }" onblur="if (this.value == '') {
  388. this.value = 'Vaše id'
  389. }" /><br/>
  390. <label for="user">Jméno: </label>
  391. <input type="text" name="user" value="<?php echo $row['USERNAME'] ?>" onfocus="if (this.value ==<?php echo $row['USERNAME'] ?>) {
  392. this.value = ''
  393. }" onblur="if (this.value == '') {
  394. this.value = 'Vaše jméno'
  395. }"/><br/>
  396. <label for="pass">Heslo: </label>
  397. <input type="text" name="pass" value="<?php echo $row['PASSWORD'] ?>" onfocus="if (this.value == <?php echo $row['PASSWORD'] ?>) {
  398. this.value = ''
  399. }" onblur="if (this.value == '') {
  400. this.value = 'Vaše heslo'
  401. }"/><br/>
  402.  
  403. <input type="submit" value="Změnit uživatelské údaje" name="zmen2"/><br/>
  404. </form><br/>
  405. <?php
  406. }
  407. ?>
  408.  
  409.  
  410. <form action="" method="post">
  411.  
  412. <input type="submit" name="jednosmerna" value="Jednosměrná" >
  413. <input type="submit" name="zpatecni" value="Zpáteční"> </form><br><br>
  414.  
  415. <?php
  416. if (isset($_POST['jednosmerna'])) {
  417. echo 'jednosmerna';
  418. ?>
  419. <form action='' method='post'>
  420. <label for="odkud">Odkud: </label>
  421. <select name="odkud">
  422. <option value="Atlanta">Atlanta</option>
  423. <option value="Chicago">Chicago</option>
  424. <option value="LA">Los Angeles</option>
  425. <option value="Dallas">Dallas</option>
  426. <option value="London">Londýn</option>
  427. <option value="Franfurkt">Frankfurt nad Mohanem</option>
  428. <option value="Pariz">Paříž</option>
  429. <option value="Rim">Řím</option>
  430. <option value="Tokyo">Tokyo</option>
  431. <option value="Peking">Peking</option>
  432. </select>
  433. <label for="kam">Kam: </label>
  434. <select name="kam">
  435. <option value="Chicago">Chicago</option>
  436. <option value="Atlanta">Atlanta</option>
  437. <option value="LA">Los Angeles</option>
  438. <option value="Dallas">Dallas</option>
  439. <option value="London">Londýn</option>
  440. <option value="Franfurkt">Frankfurt nad Mohanem</option>
  441. <option value="Pariz">Paříž</option>
  442. <option value="Rim">Řím</option>
  443. <option value="Tokyo">Tokyo</option>
  444. <option value="Peking">Peking</option>
  445. </select>
  446.  
  447. <label for="odkdy">Odkdy: </label>
  448. <input type="date" name="odkdy" value="<?php $odkdy ?>"/>
  449. <label for="pocet">Počet osob: </label>
  450. <input type="number" name="pocet" value="<?php $pocet ?>" min="1" max="10"/>
  451. <label for="trida">Třída: </label>
  452. <input type="text" name="trida" value="<?php $trida ?>"/>
  453. <label for="id">Id osoby: </label>
  454. <input type="text" name="id" value="<?php $id ?>"/>
  455. <input type="submit" name="napiste2" value="Odeslat"/>
  456. </form>
  457.  
  458. <?php
  459. } else {
  460. echo 'zpatecni';
  461. ?>
  462. <form action='' method='post'>
  463. <label for="odkud">Odkud: </label>
  464. <select name="odkud">
  465. <option value="Atlanta">Atlanta</option>
  466. <option value="Chicago">Chicago</option>
  467. <option value="LA">Los Angeles</option>
  468. <option value="Dallas">Dallas</option>
  469. <option value="London">Londýn</option>
  470. <option value="Franfurkt">Frankfurt nad Mohanem</option>
  471. <option value="Pariz">Paříž</option>
  472. <option value="Rim">Řím</option>
  473. <option value="Tokyo">Tokyo</option>
  474. <option value="Peking">Peking</option>
  475. </select>
  476. <label for="kam">Kam: </label>
  477. <select name="kam">
  478. <option value="Chicago">Chicago</option>
  479. <option value="Atlanta">Atlanta</option>
  480. <option value="LA">Los Angeles</option>
  481. <option value="Dallas">Dallas</option>
  482. <option value="London">Londýn</option>
  483. <option value="Franfurkt">Frankfurt nad Mohanem</option>
  484. <option value="Pariz">Paříž</option>
  485. <option value="Rim">Řím</option>
  486. <option value="Tokyo">Tokyo</option>
  487. <option value="Peking">Peking</option>
  488. </select>
  489.  
  490. <label for="odkdy">Odkdy: </label>
  491. <input type="date" name="odkdy" value="<?php $odkdy ?>" />
  492. <label for="dokdy">Dokdy: </label>
  493. <input type="date" name="dokdy" value="<?php $dokdy ?>" />
  494. <label for="pocet">Počet osob: </label>
  495. <input type="number" name="pocet" value="<?php $pocet ?>" min="1" max="10" />
  496. <label for="trida">Třída: </label>
  497. <input type="text" name="trida" value="<?php $trida ?>" />
  498. <label for="id">Id osoby: </label>
  499. <input type="text" name="id_os" value="<?php $id_os ?>" />
  500. <input type="submit" name="napiste" value="Odeslat" /><br><br>
  501. </form>
  502.  
  503.  
  504.  
  505.  
  506.  
  507. <?php
  508. }
  509. }
  510. ?>
  511.  
  512.  
  513. <?php
  514. if (isset($_POST['drop'])) {
  515. $db = new Oracle();
  516. $db->connect();
  517.  
  518. $db->insert("delete from USERSS WHERE username='" . $_POST['user2'] . "'");
  519. }
  520. ?>
  521.  
  522. <?php
  523. //echo "ahojky";
  524. if (isset($_POST['zmen'])) {
  525. $db = new Oracle();
  526. $db->connect();
  527. $db->insert("update USERSS set username='" . $_POST['user2'] . "' where id=" . $_POST['id2']);
  528. }
  529.  
  530. if (isset($_POST['zmen2'])) {
  531. $db = new Oracle();
  532. $db->connect();
  533. $db->insert("update USERSS set username='" . $_POST['user'] . "' where id=" . $_POST['id_zmen2']);
  534. }
  535. ?>
  536.  
  537.  
  538.  
  539. </div>
  540. </section>
Add Comment
Please, Sign In to add comment
Public Pastes
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!