Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- require_once('class/form.php');
- $atts = array('jmeno' => null,'email' => null, 'predmet' =>null, 'zprava' => null);
- if (isset($_POST['napiste'])) {
- if (empty($_POST['jmeno']) || empty($_POST['email']) || empty($_POST['predmet']) || empty($_POST['zprava'])) {
- if (!empty($_POST['jmeno']))
- $jmeno = $_POST['jmeno'];
- else {
- $atts['jmeno'] = array("style" => "color:red" );
- }
- if (!empty($_POST['email']))
- $email = $_POST['email'];
- else {
- $atts['email'] = array("style" => "color:red" );
- }
- if (!empty($_POST['predmet']))
- $predmet = $_POST['predmet'];
- else {
- $atts['premdet'] = array("style" => "color:red" );
- }
- if (!empty($_POST['zprava']))
- $zprava = $_POST['zprava'];
- else {
- $atts['zprava'] = array("style" => "color:red" );
- }
- $messageNapiste = 'Vyplňte všechna povinná pole.';
- } else {
- $username = 'st46660';
- $password = '***';
- $host = 'fei-sql1.upceucebny.cz';
- $port = '1521';
- $sid = 'ee11';
- $charset = 'UTF8';
- $c = oci_connect($username, $password,
- '(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)
- (HOST = '.$host.')
- (PORT = '.$port.'))
- (CONNECT_DATA = (SID = '.$sid.')))');
- if (!$c) {
- $e = oci_error();
- var_dump($e);
- }
- $date = Date('DD/MM/YYYY');
- $stid = oci_parse($c, "insert into WWW_EMAILS(name, subject, email, message, created)
- values
- (
- '".$_POST['jmeno']."',
- '".$_POST['predmet']."',
- '".$_POST['email']."',
- '".$_POST['zprava']."',
- TO_DATE('".$date."'), 'DD.MM.RRRR'))
- return id into :id");
- oci_bind_by_name($stid, ":id", $id, 20, SQLT_INT);
- oci_execute($stid);
- oci_close($c);
- $messageNapiste = 'Zpráva byla uložena pod číslem:'.$id.'.';
- }
- }
- ?>
- <?php
- $f = new Form();
- $form = $f->startForm($_SERVER['SCRIPT_NAME'] . '?' . $_SERVER['QUERY_STRING']);
- $form .= $f->addLabel('Jmeno: ', $atts['jmeno']);
- $form .= $f->addInput('text','jmeno',$jmeno);
- $form .= $f->addLabel('Emailova adresa: ', $atts['email']);
- $form .= $f->addInput('text','email', $email);
- $form .= $f->addLabel('Predmet: ', $atts['predmet']);
- $form .= $f->addInput('text','predmet', $predmet);
- $form .= $f->addLabel('Zprava: ', $atts['zprava']);
- $form .= $f->addTextarea('zprava',$zprava);
- $form .= $f->addInput('submit', 'napiste', 'Odeslat');
- $form .= $f->addInput('reset', 'reset', 'Vymazat');
- $form .= $f->endForm();
- ?>
- <section id="section_kontakt">
- <div>
- <div id="kontakt">
- <h2>Kontakt</h2>
- <p>
- Booking studio, s. r. o. <br />
- Náměstí Čs. legií 555 <br />
- 530 02 Paradubice
- Poloha: N 50°2'2.256'', E 15°46'2.172''<br />
- <ul>
- <li>telefon: +420 123 456 789</li>
- <li>email: info@booking-studio.cz</li>
- </ul>
- </p>
- <h2 style="margin-top: 60px">Napištete nám</h2>
- <?php
- echo $form;
- ?>
- </div>
- <div id=""mapa>
- <iframe width="480" height="250" frameborder="0" scrolling="no" marginheight="0" marginwidth="0" src="http://maps.google.cz/maps?f=q&source=s_q&hl=cs&geocode=&q=n%C3%A1m.+%C4%8Ds.+legi%C3%AD+pardubice&aq=&sll=49.930008,15.369873&sspn=5.842636,14.27124&vpsrc=0&brcurrent=5,0,0&ie=UTF8&hq=&hnear=n%C3%A1m%C4%9Bst%C3%AD+%C4%8Ceskoslovensk%C3%BDch+legi%C3%AD,+530+02+Pardubice&t=m&z=14&ll=50.034308,15.76707&output=embed"></iframe><br /><small><a href="http://maps.google.cz/maps?f=q&source=embed&hl=cs&geocode=&q=n%C3%A1m.+%C4%8Ds.+legi%C3%AD+pardubice&aq=&sll=49.930008,15.369873&sspn=5.842636,14.27124&vpsrc=0&brcurrent=5,0,0&ie=UTF8&hq=&hnear=n%C3%A1m%C4%9Bst%C3%AD+%C4%8Ceskoslovensk%C3%BDch+legi%C3%AD,+530+02+Pardubice&t=m&z=14&ll=50.034308,15.76707" style="color:#0000FF;text-align:left">Zvětšit mapu</a></small>
- </div>
- <div style="clear: both;"></div>
- </div>
- </section>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement