Advertisement
Guest User

PHP Code - Antertain

a guest
Jun 3rd, 2016
122
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.95 KB | None | 0 0
  1. <?php
  2.     $servername = "95.85.44.216";
  3.     $username = "[REDACTED]";
  4.     $password = "[REDACTED]";
  5.     $dbname = "[REDACTED]";
  6.  
  7.     // Create connection
  8.     $con = mysqli_connect($servername, $username, $password, $dbname);
  9.     if (!$con) {
  10.         echo mysqli_connect_error() . " " . mysqli_connect_errno();
  11.         die('Could not connect: ' . mysqli_error($con));
  12.     } else {
  13.         echo('Database Antertain connected.');
  14.     }
  15.  
  16.     $tableValue = $_POST["name"];
  17.     $tableFood = $_POST["food"];
  18.  
  19.     $newSQL = "INSERT INTO potluck (name, food)  VALUES ('" . $tableValue . " ', '" . $tableFood . " ')";
  20.     $result = $con->query($newSQL);
  21.  
  22.     $sql = "SELECT name FROM potluck";
  23.     $result = $con->query($sql);
  24.  
  25.     if ($result->num_rows > 0)
  26.     {
  27.         while($row = $result->fetch_assoc())
  28.         {
  29.             echo "name: " . $row["name"] . " ";
  30.         }
  31.     } else {
  32.         echo "0 results";
  33.     }  
  34.  
  35.     $con->close();
  36. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement