Code Snippets

<?php
require 'conn.php';

//get values
$vorname = $_POST["vorname"];
$nachname = $_POST["nachname"];
$email = $_POST["email"];


//insert data into mysql
$sql="INSERT INTO testtbl(vorname, nachname, email)VALUES('$vorname', '$nachname', '$email')";


if (mysqli_query($conn, $sql)){
echo "New record created";

//get values for the email headers
$empfaenger = "info@centifa.ch";
$betreff = "die Mail-Funktion";
$from = "From: $vorname $nachname < $email >";
$header = "$from\r\nReply-to: $email";
$text = "eine Kontaktanfrage ist gerade eingegangen";

//send the Email
mail($empfaenger, $betreff, $text, $header);

sleep(0);
header('location: http://centifa.cqt24.ch/db/');
exit;
}
else{
echo "error";
}

$conn->close();

?>

<?php
require 'conn.php';

//get values
$vorname = $_POST["vorname"];
$nachname = $_POST["nachname"];
$email = $_POST["email"];

//insert data into mysql
$sql="INSERT INTO testtbl(vorname, nachname, email)VALUES('$vorname', '$nachname', '$email')";

if (mysqli_query($conn, $sql)){
echo "New record created";

sleep(0);
header('location: http://centifa.cqt24.ch/db/');
exit;
}
else{
echo "error";
}

$conn->close();

?>

<form action="../insert.php" method="post">
vorname: 
<input name="vorname" required="" type="text" />

<input name="submit" type="submit" value="Absenden" />



<?php
?>

<?php
require 'conn.php';

//get values
$vorname = $_POST["vorname"];

//insert data into mysql
$sql="INSERT INTO testtbl(vorname)VALUES('$vorname')";

if (mysqli_query($conn, $sql)){
echo "New record created";

sleep(0);
header('location: http://centifa.cqt24.ch/db/');
exit;
}
else{
echo "error";
}

$conn->close();

?>

<?php

$serverbname = "Servername";
$dbname ="DB_usernamet";
$pw = "DB_Passwort";
$tbl = "tbl_name";

//create connection
$conn = new mysqli($serverbname, $usrename, $pw, $dbname);

//check connection
if ($conn->connect_error) {
 die("Connection failedd: " .$conn->connect_error);
}

echo "connection with DB";
?>