Advertisement
JakubVlcek

kontakt2.php

Nov 1st, 2016
248
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 4.29 KB | None | 0 0
  1. <?php
  2. require_once('class/form.php');
  3. $atts = array('jmeno' => null,'email' => null, 'predmet' =>null, 'zprava' => null);
  4.  
  5. if (isset($_POST['napiste'])) {
  6.     if (empty($_POST['jmeno']) || empty($_POST['email']) || empty($_POST['predmet']) || empty($_POST['zprava'])) {
  7.  
  8.         if (!empty($_POST['jmeno']))
  9.             $jmeno = $_POST['jmeno'];
  10.         else {
  11.             $atts['jmeno'] = array("style" => "color:red" );
  12.         }
  13.  
  14.         if (!empty($_POST['email']))
  15.             $email = $_POST['email'];
  16.         else {
  17.           $atts['email'] = array("style" => "color:red" );
  18.         }
  19.  
  20.         if (!empty($_POST['predmet']))
  21.             $predmet = $_POST['predmet'];
  22.         else {
  23.             $atts['premdet'] = array("style" => "color:red" );
  24.         }
  25.  
  26.         if (!empty($_POST['zprava']))
  27.             $zprava = $_POST['zprava'];
  28.         else {
  29.             $atts['zprava'] = array("style" => "color:red" );
  30.         }
  31.  
  32.         $messageNapiste = 'Vyplňte všechna povinná pole.';
  33.     } else {
  34.       $username = 'st46660';
  35.       $password = '***';
  36.       $host = 'fei-sql1.upceucebny.cz';
  37.       $port = '1521';
  38.       $sid = 'ee11';
  39.  
  40.       $charset = 'UTF8';
  41.       $c = oci_connect($username, $password,
  42.           '(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)
  43.          (HOST = '.$host.')
  44.          (PORT = '.$port.'))
  45.          (CONNECT_DATA =  (SID = '.$sid.')))');
  46.       if (!$c) {
  47.           $e = oci_error();
  48.           var_dump($e);
  49.       }
  50.  
  51.         $date = Date('DD/MM/YYYY');
  52.       $stid = oci_parse($c, "insert into WWW_EMAILS(name, subject, email, message, created)
  53.      values
  54.      (
  55.      '".$_POST['jmeno']."',
  56.      '".$_POST['predmet']."',
  57.      '".$_POST['email']."',
  58.      '".$_POST['zprava']."',
  59.      TO_DATE('".$date."'), 'DD.MM.RRRR'))
  60.    return id into :id");
  61.  
  62.     oci_bind_by_name($stid, ":id", $id, 20, SQLT_INT);
  63.     oci_execute($stid);
  64.     oci_close($c);
  65.  
  66.         $messageNapiste = 'Zpráva byla uložena pod číslem:'.$id.'.';
  67.     }
  68. }
  69. ?>
  70.  
  71. <?php
  72. $f = new Form();
  73. $form = $f->startForm($_SERVER['SCRIPT_NAME'] . '?' . $_SERVER['QUERY_STRING']);
  74. $form .= $f->addLabel('Jmeno: ', $atts['jmeno']);
  75. $form .= $f->addInput('text','jmeno',$jmeno);
  76. $form .= $f->addLabel('Emailova adresa: ', $atts['email']);
  77. $form .= $f->addInput('text','email', $email);
  78. $form .= $f->addLabel('Predmet: ', $atts['predmet']);
  79. $form .= $f->addInput('text','predmet', $predmet);
  80. $form .= $f->addLabel('Zprava: ', $atts['zprava']);
  81. $form .= $f->addTextarea('zprava',$zprava);
  82. $form .= $f->addInput('submit', 'napiste', 'Odeslat');
  83. $form .= $f->addInput('reset', 'reset', 'Vymazat');
  84. $form .= $f->endForm();
  85. ?>
  86.  
  87. <section id="section_kontakt">
  88.     <div>
  89.         <div id="kontakt">
  90.             <h2>Kontakt</h2>
  91.             <p>
  92.                 Booking studio, s. r. o. <br />
  93.                 Náměstí Čs. legií  555 <br />
  94.                 530 02 Paradubice
  95.                 Poloha: N 50°2'2.256'', E 15°46'2.172''<br />
  96.             <ul>
  97.                 <li>telefon: +420 123 456 789</li>
  98.                 <li>email: info@booking-studio.cz</li>
  99.             </ul>
  100.             </p>
  101.             <h2 style="margin-top: 60px">Napištete nám</h2>
  102.             <?php
  103.                 echo $form;
  104.             ?>
  105.  
  106.         </div>
  107.         <div id=""mapa>
  108.             <iframe width="480" height="250" frameborder="0" scrolling="no" marginheight="0" marginwidth="0" src="http://maps.google.cz/maps?f=q&amp;source=s_q&amp;hl=cs&amp;geocode=&amp;q=n%C3%A1m.+%C4%8Ds.+legi%C3%AD+pardubice&amp;aq=&amp;sll=49.930008,15.369873&amp;sspn=5.842636,14.27124&amp;vpsrc=0&amp;brcurrent=5,0,0&amp;ie=UTF8&amp;hq=&amp;hnear=n%C3%A1m%C4%9Bst%C3%AD+%C4%8Ceskoslovensk%C3%BDch+legi%C3%AD,+530+02+Pardubice&amp;t=m&amp;z=14&amp;ll=50.034308,15.76707&amp;output=embed"></iframe><br /><small><a href="http://maps.google.cz/maps?f=q&amp;source=embed&amp;hl=cs&amp;geocode=&amp;q=n%C3%A1m.+%C4%8Ds.+legi%C3%AD+pardubice&amp;aq=&amp;sll=49.930008,15.369873&amp;sspn=5.842636,14.27124&amp;vpsrc=0&amp;brcurrent=5,0,0&amp;ie=UTF8&amp;hq=&amp;hnear=n%C3%A1m%C4%9Bst%C3%AD+%C4%8Ceskoslovensk%C3%BDch+legi%C3%AD,+530+02+Pardubice&amp;t=m&amp;z=14&amp;ll=50.034308,15.76707" style="color:#0000FF;text-align:left">Zvětšit mapu</a></small>
  109.         </div>
  110.         <div style="clear: both;"></div>
  111.     </div>
  112. </section>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement