Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $servername = "127.0.0.1";
- $username = "root";
- $password = "";
- $dbname = "station";
- // Create connection
- $conn = new mysqli($servername, $username, $password, $dbname);
- // Check connection
- if ($conn->connect_error) {
- die("Connection failed: " . $conn->connect_error);
- }
- $value = $_POST['name'];
- $value2 = $_POST['email'];
- $sql = "INSERT INTO data (name, email) VALUES ('$value', '$value2')";
- $result = $conn->query($sql);
- $sql1 = "SELECT name, email FROM data";
- $result1 = $conn->query($sql1);
- if ($result1->num_rows > 0) {
- // output data of each row
- while($row = $result1->fetch_assoc()) {
- echo "name:" . $row["name"]. " - email: " . $row["email"]. " "."<br>";
- }
- } else {
- echo "0 results";
- }
- $conn->close();
- ?>
Add Comment
Please, Sign In to add comment