Ankündigung
Einklappen
Keine Ankündigung bisher.
Abspeichern funktioniert nicht
Einklappen
Neue Werbung 2019
Einklappen
X
-
PHP-Code:<?php
mysqli_report(MYSQLI_REPORT_ALL);
$db = new mysqli("localhost","cook-user","123","cook");
if($db->connect_error)
echo "<b>Critical Error: </b> $db->connect_error";
if(isset($_POST['absenden'])) {
$firstname = $_POST['firstname'];
$lastname = $_POST['lastname'];
$username = $_POST['username'];
$email = $_POST['email'];
$password = $_POST['password'];
$search_user = $db->query("SELECT ID FROM daten WHERE username = $username");
$search_result = $search_user->get_result();
if($search_result->num_rows == 0) {
$password = md5($password);
$insert = $db->prepare("INSERT INTO daten (Firstname,Lastname,Username,Email,Password,Registered,Last_Login) VALUES (?,?,?,?,?,NOW(),NOW())");
$insert->bind_param('sssss',$firstname,$lastname,$username,$email,$password);
$insert->execute();
echo "Your Account was created successfully.";
}
else
echo "This username is already used.";
}
?>
Auch der PDO-Code gibt keine Fehlermeldung und speichert keine Daten...
Kommentar
-
PHP-Code:<?php
class DB {
private static $_db_username = "cook-user";
private static $_db_password = "123";
private static $_db_host = "localhost";
private static $_db_name = "cook";
private static $_db;
function __construct() {
try {
self::$_db = new PDO("mysql:host=" . self::$_db_host . ";dbname=" . self::$_db_name, self::$_db_username, self::$_db_password);
} catch(PDOException $e) {
echo "The connection to the Database failed.";
die();
}
}
function saveData() {
$stmt = self::$_db->prepare("INSERT INTO daten (Firstname,Lastname,Username,Email,Password,Registered) VALUES (?,?,?,?,NOW(),NOW())");
$stmt->bind_param("ssss","example","example","example","example");
$stmt->execute;
echo "Die Daten wurden gespeichert.";
}
}
?>
Das hier ist der PDO Code.
Bild der Struktur:
https://picload.org/view/dagcoppl/2.png.html
Kommentar
-
Zitat von co worker Beitrag anzeigenBild der Struktur:
https://picload.org/view/dagcoppl/2.png.html
Kommentar
-
Code:UPDATE `daten` SET `ID`=[value-1],`Firstname`=[value-2],`Lastname`=[value-3],`Username`=[value-4],`Email`=[value-5],`Password`=[value-6],`Registered`=[value-7],`Last_Login`=[value-8],`Loggedin`=[value-9],`Email_Confirmed`=[value-10],`number_ingredients`=[value-11],`number_recipes`=[value-12],`PB`=[value-13],`Color`=[value-14] WHERE 1
Kommentar
Kommentar