/extremedating/trunk

To get this branch, use:
bzr branch http://gegoxaren.bato24.eu/bzr/extremedating/trunk

« back to all changes in this revision

Viewing changes to php/planlunch.php

  • Committer: Daniel Johansson
  • Date: 2013-04-14 00:53:51 UTC
  • mfrom: (45.1.2 extremedating)
  • Revision ID: maila@danieljohansson.nu-20130414005351-vneeyc7yu507gel2
merge

Show diffs side-by-side

added added

removed removed

Lines of Context:
php/planlunch.php
1
 
<?php ?>
2
 
<form method="POST" action="">
3
 
  <div id="datetimepicker" class="input-append date">
4
 
    <input data-format="yyyy-MM-dd hh:mm:ss" type="datetime" name="date"> </input>
5
 
    <span class="add-on">
6
 
      <i data-time-icon="icon-time" data-date-icon="icon-calendar"></i>
7
 
    </span>
8
 
  </div>
9
 
  </script>
10
 
    <script type="text/javascript">
11
 
      $('#datetimepicker').datetimepicker({
12
 
     });
13
 
  </script>
14
 
  </body>
15
 
  <input type="text" name="message">
16
 
  <button type="Submit" name="SuggestLunch">Föreslå lunch</button>
17
 
        </form>
18
 
        <?php
19
 
        $user2 = htmlspecialchars($_GET['uid']);
20
 
        if (isset($_POST['SuggestLunch'])) {
21
 
                $query = "INSERT INTO planLunch (
22
 
                user1,
23
 
                user2,
24
 
                message,
25
 
                date,
26
 
                accepted
27
 
                )
28
 
        
29
 
                VALUES(
30
 
                '{$username}',
31
 
                '{$user2}',
32
 
                '{$_POST['message']}',
33
 
                '{$_POST['date']}',
34
 
                'false'
35
 
                );";
36
 
                
37
 
                try {
38
 
                $lunchinfo = $db->query("SELECT * from planLunch WHERE(user1='$username' AND user2='$user2')");
39
 
                        $lunchquery = $lunchinfo->fetchAll();
40
 
                        if($lunchquery == array()) {
41
 
                                $db->exec($query);
42
 
                        }
43
 
                } catch (PDOException $err) {
44
 
                        var_dump($err);
45
 
                }
46
 
        }
47
 
?>