prepare($sql);
$stmt->execute();
$stmt->store_result();
$stmt->bind_result($jmeno, $prijmeni);
while($stmt -> fetch())
{
// fetch data
echo "
$jmeno $prijmeni";
}
if (isset($_POST["name"]))
{
$stmt = $conn->prepare("INSERT INTO Jmeno(jmeno) VALUES (?)");
$name = $_POST["name"];
$stmt->bind_param("s", $name);
$stmt->execute();
/*
$name = $_POST["name"];
$sql = "INSERT INTO Jmeno (jmeno) VALUES ('$name')";
mysqli_query($conn, $sql);
*/
}
?>
Práce s databází