sigil88
8/14/2017 - 11:52 PM

simplest form mysqli post to db ever

simplest form mysqli post to db ever

<?php 
// php file that receives form POST

$mysqli = new mysqli("localhost", "root", "", "forms");

if ($mysqli->connect_error) :
	echo "Failed to connect to database.\n" ;
else :
	echo "Connected!\n";
endif; 

$form = $_POST;

$query = $mysqli->prepare("INSERT INTO name(name, age) VALUES (?, ?)");
$query->bind_param("si", $name, $age);

$name = $_POST['name'];
$age  = $_POST['age'];

$query->execute();

var_dump($form);

echo "sent to db!\n";

$mysqli->close();