function login_user() { global $connection; if (isset($_POST['submit'])) { $username = $_POST['username']; $password = $_POST['password']; //$query = "SELECT * FROM users WHERE username = '{$username}' AND password = '{$password}'"; $query = "SELECT * FROM users WHERE username = ? AND password = ?"; $send_query = $connection->prepare($query); //$send_query->execute(array()); $send_query->execute(array($username, $password)); $send_query->setFetchMode(PDO::FETCH_ASSOC); i f (($send_query->rowCount()== 0)) { set_message("Password or Username are wrong"); redirect("login.php"); } else { set_message("Welcome to Admin {$username}"); redirect("admin"); } } }
I'm tired but lucky. Let me say that I new in Laravel. When I saw that PHPMyAdmin uses Unix socket on Debian, so search your mysql.sock and put the explicit path in .env and config/database.php files. Hope php artisan migrate works!. This tip made my day.