query($sql); $con->select_db("logindaten"); $sql = "CREATE TABLE IF NOT EXISTS benutzer" . " (id INT(11) NOT NULL AUTO_INCREMENT," . " name VARCHAR(50) NOT NULL," . " passwort VARCHAR(255) NOT NULL," . " PRIMARY KEY (id)" . " ) ENGINE=InnoDB DEFAULT CHARSET=UTF8"; $con->query($sql); $pw1 = password_hash("Marburg", PASSWORD_DEFAULT); $pw2 = password_hash("Dortmund", PASSWORD_DEFAULT); $sql = "INSERT INTO benutzer (name, passwort)" . " VALUES('Maier', '$pw1'),('Schmitz','$pw2')"; $con->query($sql); $con->close(); ?>