Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $servername = "95.85.44.216";
- $username = "[REDACTED]";
- $password = "[REDACTED]";
- $dbname = "[REDACTED]";
- // Create connection
- $con = mysqli_connect($servername, $username, $password, $dbname);
- if (!$con) {
- echo mysqli_connect_error() . " " . mysqli_connect_errno();
- die('Could not connect: ' . mysqli_error($con));
- } else {
- echo('Database Antertain connected.');
- }
- $tableValue = $_POST["name"];
- $tableFood = $_POST["food"];
- $newSQL = "INSERT INTO potluck (name, food) VALUES ('" . $tableValue . " ', '" . $tableFood . " ')";
- $result = $con->query($newSQL);
- $sql = "SELECT name FROM potluck";
- $result = $con->query($sql);
- if ($result->num_rows > 0)
- {
- while($row = $result->fetch_assoc())
- {
- echo "name: " . $row["name"] . " ";
- }
- } else {
- echo "0 results";
- }
- $con->close();
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement