Witam,
Na podstawie tutoriala, przepisałem z filmu skrypt, który działa lecz na 15 linijke wskazuje błąd.
O to skrypt:
<?php
if(isset($_POST['submit'])) {
$db = new mysqli('localhost', 'root', 'vertrigo', 'minicms');
$db->query ('set character set utf8');
if (mysqli_connect_errno()) {
printf("Brak połączenia z bazą danych !", mysqli_connect_error());
exit();
}
$fname = $_POST['fname'];
$lname = $_POST['lname'];
$username = $_POST['username'];
$password = $_POST['password'];
$email = $_POST['email'];
**$userCheck = $db->query("SELECT * FROM members WHERE username ='".username."'");**
if(empty($fname) || empty($lname) || empty($username) || empty($password) || empty($email)) {
if(empty($fname)) {
$errors[] = "Missing first name";
}
if(empty($lname)) {
$errors[] = "Missing last name";
}
if(empty($username)) {
$errors[] = "Missing username";
}
if(empty($password)) {
$errors[] = "Missing password";
}
if(empty($email)) {
$errors[] = "Missing email address";
}
}else if(!filter_var($email, FILTER_VALIDATE_EMAIL)) {
$errors[] ="Not a valid email adress";
}else if ($username == $password) {
$errors[] ="Username i password nie są takie same! ";
}else if ($userCheck->num_rows>0) {
$errors[] = "username is already in use";
}else {
$fname = strip_tags($fname);
$fname = stripslashes($fname);
$fname = trim($fname);
$lname = strip_tags($lname);
$lname = stripslashes($lname);
$lname = trim($lname);
$username = strip_tags($username);
$username = stripslashes($username);
$username = trim($username);
$password = strip_tags($password);
$password = stripslashes($password);
$password = trim($password);
$password = md5($password);
$email = strip_tags($email);
$email = stripslashes($email);
$email = trim($email);
$sql = "INSERT INTO members (first_name, last_name, username, password, email) VALUES (?,?,?,?,?)";
if($query = $db->prepare($sql)) {
$query->bind_param('sssss', $fname, $lname, $username, $password, $email);
$query->execute();
$msg = "Twój profil został utworzony!";
}else {
$errors[] = "Sorry error with database at is time";
}
}
}
?>
To co pogrubione to linia błedu,która zaraz po wysłaniu pojawia się a na tutorialu nie było.
A linia błedu mówi tak:
Notice: Use of undefined constant username - assumed 'username' in C:\Program Files\VertrigoServ\www\Members System\register.php on line 15
Wiem, że chodzi o nazwę użytkownika, że istnieje ale czemu błąd a nie info że użytkownik jest?