Buon pomeriggio a tutti.
Sto creando uan login page e ho un errore che non riesco a risolvere.
Al momento sto provando tutto in locale prima di andare in linea.
COsa uso in ambiente di test:
XAMPP v3.2.2
di seguito il codice usato in php:
LOGINPAGE
DBCONNECTIONCodice PHP:<?php
if (isset($_POST['submit'])) {
include_once 'dbh.inc.php';
$first = mysqli_real_escape_string($conn, $_POST['first']);
$last = mysqli_real_escape_string($conn, $_POST['last']);
$email = mysqli_real_escape_string($conn, $_POST['email']);
$uid = mysqli_real_escape_string($conn, $_POST['uid']);
$pwd = mysqli_real_escape_string($conn, $_POST['pwd']);
//Error handlers
//Check for empty fields
if (empty($first) || empty($last) || empty($email) || empty($uid) || empty(
$pwd)) {
header("Location: ../signup.php?signup=empty");
exit();
} else {
//Check if input characters are valid
if (!preg_match("/^[a-zA-Z]*$/", $first) || !preg_match("/^[a-zA-Z]*$/"
,$last)) {
header("Location: ../signup.php?signup=invalid");
exit();
} else {
// Check if email is valid
if (!filter_var($email, FILTER_VALIDATE_EMAIL)) {
header("Location: ../signup.php?signup=email");
exit();
} else {
$sql = "SELECT * FROM users WHERE user_uid='$uid'";
$result = mysqli_query($conn, $sql);
$resultCheck = mysqli_num_rows($result);
if ($resultCheck > 0){
header("Location: ../signup.php?signup=usertaken");
exit();
} else {
//Hashing the password
$hashedPwd = password_hash($pwd, PASSWORD_DEFAULT);
//Insert the user into database
$sql = "INSERT INTO users (user_first, user_last,
user_email, user_uid, user_pwd) VALUES ('$first', '$
last',' $email', '$uid', '$hashPwd');";
mysqli_query($conn, $sql);
header("Location: ../signup.php?signup=success");
exit();
}
}
}
}
} else{
header("Location: ../signup.php");
exit();
}
Ecco invece l'errore che ricevo quando vado a riempire il modulo e invio:Codice PHP:<?php
$dbServername "localhost";
$dbUsername "root";
$dbPassword "";
$dbName "loginsystem";
$conn = mysqli_connect($dbServername, $dbUsername, $dbPassword, $dbName);
?>
Parse error: syntax error, unexpected '"localhost"' (T_CONSTANT_ENCAPSED_STRING) in C:\xampp\htdocs\LOGIN\includes\dbh.inc.php on line 3
GRAZIE
