Errore phpmyadmin

Salve. Premesso di aver importato nel database "my_yodalessandra" (l'unico di default) la tabella che mi interessa.
Premesso di aver modificato il file relativo alla connessione al database nel seguente modo:
1 <?php
2 $con = mysqli_connect('localhost', 'root', '', 'my_yodalessandra');
3 ?>

Mi esce il seguente errore:
Warning: mysqli_connect(): (HY000/1049): Unknown database 'my_yodalessandra' in C:\xampp\htdocs\login\connection.php on line 2

Fatal error: Uncaught TypeError: mysqli_real_escape_string(): Argument #1 ($mysql) must be of type mysqli, bool given in C:\xampp\htdocs\login\controllerUserData.php:10 Stack trace: #0 C:\xampp\htdocs\login\controllerUserData.php(10): mysqli_real_escape_string(false, 'ciccio') #1 C:\xampp\htdocs\login\signup-user.php(1): require_once('C:\\xampp\\htdocs...') #2 {main} thrown in C:\xampp\htdocs\login\controllerUserData.php on line 10

La line 2 di connection.php è quella copiata sopra.
La line 10 di controllerUserData.php è ---> $name = mysqli_real_escape_string($con, $_POST['name']);

Dove sto sbagliando? Grazie
P.S.: Premesso che (ovviamente) in locale funziona tutto

Citazione:

---

Originalmente inviato da yodalessandra

Unknown database 'my_yodalessandra' in C:\xampp\htdocs\login\connection.php

---

Vedo che l'errore fa riferimento ad una tua cartella locale: "C:\xampp\htdocs\login\connection.php". Hai modificato il path?

Comunque, tornando all'errore, prova anche a sostituire "root" con il tuo username.

Ciao!

Citazione:

---

Originalmente inviato da alemoppo

Vedo che l'errore fa riferimento ad una tua cartella locale: "C:\xampp\htdocs\login\connection.php". Hai modificato il path?

Comunque, tornando all'errore, prova anche a sostituire "root" con il tuo username.

Ciao!

---

Provato, ma....
Warning: mysqli_connect(): (HY000/1045): Access denied for user 'yodalessandra'@'localhost' (using password: NO) in C:\xampp\htdocs\login\connection.php on line 2

Fatal error: Uncaught TypeError: mysqli_real_escape_string(): Argument #1 ($mysql) must be of type mysqli, bool given in C:\xampp\htdocs\login\controllerUserData.php:10 Stack trace: #0 C:\xampp\htdocs\login\controllerUserData.php(10): mysqli_real_escape_string(false, 'ciccio') #1 C:\xampp\htdocs\login\signup-user.php(1): require_once('C:\\xampp\\htdocs...') #2 {main} thrown in C:\xampp\htdocs\login\controllerUserData.php on line 10

Il file connection.php completo è:

Codice PHP:

---

<?php
$con = mysqli_connect('localhost', 'yodalessandra', '', 'my_yodalessandra');
?>

---

Il file controllerUserData.php:

Codice PHP:

---

<?php
session_start();
require "connection.php";
$email = "";
$name = "";
$errors = array();

//if user signup button
if(isset($_POST['signup'])){
$name = mysqli_real_escape_string($con, $_POST['name']);
$email = mysqli_real_escape_string($con, $_POST['email']);
$password = mysqli_real_escape_string($con, $_POST['password']);
$cpassword = mysqli_real_escape_string($con, $_POST['cpassword']);
if($password !== $cpassword){
$errors['password'] = "Confirm password not matched!";
}
$email_check = "SELECT * FROM usertable WHERE email = '$email'";
$res = mysqli_query($con, $email_check);
if(mysqli_num_rows($res) > 0){
$errors['email'] = "Email that you have entered is already exist!";
}
if(count($errors) === 0){
$encpass = password_hash($password, PASSWORD_BCRYPT);
$code = rand(999999, 111111);
$status = "notverified";
$insert_data = "INSERT INTO usertable (name, email, password, code, status)
values('$name', '$email', '$encpass', '$code', '$status')";
$data_check = mysqli_query($con, $insert_data);
if($data_check){
$subject = "Email Verification Code";
$message = "Your verification code is $code";
$sender = "From: emule.yoda@gmail.com";
if(mail($email, $subject, $message, $sender)){
$info = "We've sent a verification code to your email - $email";
$_SESSION['info'] = $info;
$_SESSION['email'] = $email;
$_SESSION['password'] = $password;
header('location: user-otp.php');
exit();
}else{
$errors['otp-error'] = "Failed while sending code!";
}
}else{
$errors['db-error'] = "Failed while inserting data into database!";
}
}

}
//if user click verification code submit button
if(isset($_POST['check'])){
$_SESSION['info'] = "";
$otp_code = mysqli_real_escape_string($con, $_POST['otp']);
$check_code = "SELECT * FROM usertable WHERE code = $otp_code";
$code_res = mysqli_query($con, $check_code);
if(mysqli_num_rows($code_res) > 0){
$fetch_data = mysqli_fetch_assoc($code_res);
$fetch_code = $fetch_data['code'];
$email = $fetch_data['email'];
$code = 0;
$status = 'verified';
$update_otp = "UPDATE usertable SET code = $code, status = '$status' WHERE code = $fetch_code";
$update_res = mysqli_query($con, $update_otp);
if($update_res){
$_SESSION['name'] = $name;
$_SESSION['email'] = $email;
header('location: home.php');
exit();
}else{
$errors['otp-error'] = "Failed while updating code!";
}
}else{
$errors['otp-error'] = "You've entered incorrect code!";
}
}

//if user click login button
if(isset($_POST['login'])){
$email = mysqli_real_escape_string($con, $_POST['email']);
$password = mysqli_real_escape_string($con, $_POST['password']);
$check_email = "SELECT * FROM usertable WHERE email = '$email'";
$res = mysqli_query($con, $check_email);
if(mysqli_num_rows($res) > 0){
$fetch = mysqli_fetch_assoc($res);
$fetch_pass = $fetch['password'];
if(password_verify($password, $fetch_pass)){
$_SESSION['email'] = $email;
$status = $fetch['status'];
if($status == 'verified'){
$_SESSION['email'] = $email;
$_SESSION['password'] = $password;
header('location: home.php');
}else{
$info = "It's look like you haven't still verify your email - $email";
$_SESSION['info'] = $info;
header('location: user-otp.php');
}
}else{
$errors['email'] = "Incorrect email or password!";
}
}else{
$errors['email'] = "You're not yet a member!";
}
}

//if user click continue button in forgot password form
if(isset($_POST['check-email'])){
$email = mysqli_real_escape_string($con, $_POST['email']);
$check_email = "SELECT * FROM usertable WHERE email='$email'";
$run_sql = mysqli_query($con, $check_email);
if(mysqli_num_rows($run_sql) > 0){
$code = rand(999999, 111111);
$insert_code = "UPDATE usertable SET code = $code WHERE email = '$email'";
$run_query = mysqli_query($con, $insert_code);
if($run_query){
$subject = "Password Reset Code";
$message = "Your password reset code is $code";
$sender = "From: emule.yoda@gmail.com";
if(mail($email, $subject, $message, $sender)){
$info = "We've sent a passwrod reset otp to your email - $email";
$_SESSION['info'] = $info;
$_SESSION['email'] = $email;
header('location: reset-code.php');
exit();
}else{
$errors['otp-error'] = "Failed while sending code!";
}
}else{
$errors['db-error'] = "Something went wrong!";
}
}else{
$errors['email'] = "This email address does not exist!";
}
}

//if user click check reset otp button
if(isset($_POST['check-reset-otp'])){
$_SESSION['info'] = "";
$otp_code = mysqli_real_escape_string($con, $_POST['otp']);
$check_code = "SELECT * FROM usertable WHERE code = $otp_code";
$code_res = mysqli_query($con, $check_code);
if(mysqli_num_rows($code_res) > 0){
$fetch_data = mysqli_fetch_assoc($code_res);
$email = $fetch_data['email'];
$_SESSION['email'] = $email;
$info = "Please create a new password that you don't use on any other site.";
$_SESSION['info'] = $info;
header('location: new-password.php');
exit();
}else{
$errors['otp-error'] = "You've entered incorrect code!";
}
}

//if user click change password button
if(isset($_POST['change-password'])){
$_SESSION['info'] = "";
$password = mysqli_real_escape_string($con, $_POST['password']);
$cpassword = mysqli_real_escape_string($con, $_POST['cpassword']);
if($password !== $cpassword){
$errors['password'] = "Confirm password not matched!";
}else{
$code = 0;
$email = $_SESSION['email']; //getting this email using session
$encpass = password_hash($password, PASSWORD_BCRYPT);
$update_pass = "UPDATE usertable SET code = $code, password = '$encpass' WHERE email = '$email'";
$run_query = mysqli_query($con, $update_pass);
if($run_query){
$info = "Your password changed. Now you can login with your new password.";
$_SESSION['info'] = $info;
header('Location: password-changed.php');
}else{
$errors['db-error'] = "Failed to change your password!";
}
}
}

//if login now button click
if(isset($_POST['login-now'])){
header('Location: login-user.php');
}
?>

---

Puoi connetterti al database solamente se carichi i file su AlterVista. Non c'è modo di connettersi "da esterno".

Carica quindi i file php sul tuo account AlterVista (puoi usare FTP o la gestione file sul pannello di controllo).

Ciao!