Skip to content

Instantly share code, notes, and snippets.

Created May 22, 2018 18:01
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
Star You must be signed in to star a gist
What would you like to do?
$servername = "localhost";
$username = "root";
$password = "PROMENITI!";
$dbname = "test";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
if ($_POST["id"] !== null) {
$personid = $_POST["id"];
$firstname = $_POST["name"];
$lastname = $_POST["lastname"];
$stmt = $conn->prepare("insert into Persons(personid, firstname, lastname) values (?, ?, ?);");
$stmt->bind_param("iss", $personid, $firstname, $lastname);
$sql = "SELECT personid, firstname, lastname FROM Persons";
$result = $conn->query($sql);
<!doctype html>
<html lang="en">
<!-- Required meta tags -->
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<!-- Bootstrap CSS -->
<link rel="stylesheet" href="" integrity="sha384-Gn5384xqQ1aoWXA+058RXPxPg6fy4IWvTNh0E263XmFcJlSAwiGgFAW/dAiS6JXm" crossorigin="anonymous">
<div class="container" style="margin-top: 10%;">
<form action="index.php" method="post">
Id: <input type="text" name="id"><br>
First name: <input type="text" name="name"><br>
Last name: <input type="text" name="lastname"><br>
<input type="submit" class="btn btn-success">
<table class="table">
<th>First Name</th>
<th>Last Name</th>
while($row = $result->fetch_assoc()) {
echo("<td>" . $row["personid"] . "</td>");
echo("<td>" . $row["firstname"] . "</td>");
echo("<td>" . $row["lastname"] . "</td>");
<!-- Optional JavaScript -->
<!-- jQuery first, then Popper.js, then Bootstrap JS -->
<script src="" integrity="sha384-KJ3o2DKtIkvYIK3UENzmM7KCkRr/rE9/Qpg6aAZGJwFDMVNA/GpGFF93hXpG5KkN" crossorigin="anonymous"></script>
<script src="" integrity="sha384-ApNbgh9B+Y1QKtv3Rn7W3mgPxhU9K/ScQsAP7hUibX39j7fakFPskvXusvfa0b4Q" crossorigin="anonymous"></script>
<script src="" integrity="sha384-JZR6Spejh4U02d8jOt6vLEHfe/JQGiRRSQQxSfFWpi1MquVdAyjUar5+76PVCmYl" crossorigin="anonymous"></script>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment