Advertisement
Guest User

cloudnet server

a guest
Feb 8th, 2016
139
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.65 KB | None | 0 0
  1. <?php
  2.     $host = 'localhost';
  3.     $username = 'username';
  4.     $password = 'password';
  5.     $conn=mysqli_connect($host,$username,$password,'cloudnet') or die("Unable to Connect");
  6.     if(empty($_POST['key'])) {//get or remove
  7.         if(empty($_POST['get'])) {//remove
  8.             mysqli_query($conn, "DELETE FROM ".$_POST['remove']." WHERE ".$_POST['type']."='" . $_POST['filter']."'");
  9.             echo "success";
  10.         }else{//get
  11.             if(empty($_POST['filter'])) {//no filter
  12.                 $result = mysqli_query($conn, "SELECT * FROM ".$_POST['get']);
  13.                 echo "{";
  14.                 if(mysqli_num_rows($result) > 0){
  15.                     while($row = mysqli_fetch_assoc($result)){
  16.                         echo "{header='" . $row['header'] . "',message='" . $row['message'] . "',dummy='" . $row['dummy'] . "',},";
  17.                     }
  18.                 }
  19.                 echo "}";
  20.             }else{//filter
  21.                 $result = mysqli_query($conn, "SELECT * FROM ".$_POST['get']." WHERE ".$_POST['type']."='" . $_POST['filter']."'");
  22.                 echo "{";
  23.                 if(mysqli_num_rows($result) > 0){
  24.                     while($row = mysqli_fetch_assoc($result)){
  25.                         echo "{header='" . $row['header'] . "',message='" . $row['message'] . "',dummy='" . $row['dummy'] . "',},";
  26.                     }
  27.                 }
  28.                 echo "}";
  29.             }
  30.         }
  31.     }else{//create or store
  32.         if(empty($_POST['header'])) {//create
  33.             if(mysqli_num_rows(mysqli_query("SHOW TABLES LIKE '".$_POST['key']."'"))==0) {
  34.                 mysqli_query($conn, "CREATE TABLE ".$_POST['key']."(header VARCHAR(50) NOT NULL,message VARCHAR(360) NOT NULL,dummy VARCHAR(50) NOT NULL)");
  35.             }
  36.             echo "success";
  37.         }else{//store
  38.             mysqli_query($conn, "INSERT INTO ".$_POST['key']."(header,message,dummy) VALUES ('".$_POST['header']."','".$_POST['message']."','".$_POST['dummy']."')");
  39.             echo "success";
  40.         }
  41.     }
  42. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement