Exercises/data-service.php at master · TheAlgorithm/Exercises · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
<?php


if(isset($_POST["functionSelector"])){

  $functionName = $_POST["functionSelector"];
    switch($functionName){
      case "getData":
          getData();
          break;
      case "postData":
          postData();
          break;
      case "deleteData":
          deleteData();
          break;
    }
}


function getData(){
    require "conntest.php";

    $mysql_all_qry = "SELECT * FROM blogpost ORDER BY id";
    $result = mysqli_query( $conn, $mysql_all_qry);

    if(empty($result)){
      echo ("nothing posted yet");
    }else{
          while($row = mysqli_fetch_array($result, MYSQLI_ASSOC)){
                echo ("id:{$row['id']}<br>
                      name: {$row['name']}<br>
                      post: {$row['message']}<br>
                      <input type='submit' name='deleteBtn:{$row['id']}' value='Delete Post' onClick='javascript:ajaxDataDelete({$row['id']});'><br>
                      <br>");

         }
    }
  $conn->close();
}

function postData(){
    require "conntest.php";
      $errorMessage ="";


          if(empty($_POST['name']) OR empty($_POST['blogpost']) ){

              $errorMessage = "Please fill in both inputfields";

          }else{
                  $varName = $_POST['name'];
                  $varBlogpost = $_POST['blogpost'];

                 $mysql_qry = "INSERT INTO blogpost (name,message) VALUES ('$varName', '$varBlogpost')";

                  if($conn->query($mysql_qry) === TRUE){
                        echo "Insert Successful";
                  }else{
                        echo "Error: " . $mysql_qry . "<br>" . $conn->error;
                  }


          }

        if(!empty($errorMessage))
            {
              echo("there was an error with your form:\n");
              echo($errorMessage);
            }
     $conn->close();
}


function deleteData(){
      require "conntest.php";

            $errorMessage="";
            $indexVar = $_POST['deleteIndex'];

            if(!$indexVar){
              $errorMessage ="There is no such post. Please select another one.";
              echo($errorMessage);
            }else{
              $mysql_delete_qry = "DELETE FROM blogpost WHERE id=$indexVar";

              if($conn->query($mysql_delete_qry)===TRUE){
                  echo ("Blogpost #".$indexVar." deleted");
              }
            }


      $conn->close();
}
?>