❓ Help Help

Status
Not open for further replies.

Alieson09

Forum Guru
Parse error: syntax error, unexpected token "," in line 10
PHP:
<?php
session_start();
error_reporting(0);
include('connect.php');


if (isset($_POST['login'])) {
    $email = $_POST["email"];
    $password = $_POST["password"];
    $query = ($con,"SELECT * FROM login WHERE Email='$email' AND Password='$password'");
    $result = mysqli_query($query);
    $row = mysqli_fetch_array($result); {
        if ($row) {
        if ($row["usertype"] == "user") {
            $_SESSION["Email"] = $email;
            header("location:user/dashboarduser.php");
        } elseif ($row["usertype"] == "admin") {
            $_SESSION["Email"] = $email;
            header("location:admin/index.php");
        } else {
            echo "<script>alert('email or password incorrect');</script>";
        }
        } else {
    echo "<script>alert('email or password incorrect');</script>";
}
    }
}
?>
<!DOCTYPE html>
<html lang="en">

<head>

    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
    <meta name="description" content="">
    <meta name="author" content="">

    <title>BPMS - Login</title>

    <!-- Custom fonts for this template-->
    <link href="vendor/fontawesome-free/css/all.min.css" rel="stylesheet" type="text/css">
    <link
        href="https://fonts.googleapis.com/css?family=Nunito:200,200i,300,300i,400,400i,600,600i,700,700i,800,800i,900,900i"
        rel="stylesheet">

    <!-- Custom styles for this template-->
    <link href="css/sb-admin-2.css" rel="stylesheet">
    
</head>

<body class="bg-gradient-primary">
    <header>
        <div class="logo">
        <p>Bicycle Parking Management System</p>
              </div>
      <nav>
        <ul>
          <li><a href="#" class="navf">Home</a></li>
          <li><a href="#" class="navf">About</a></li>
          <li><a href="#" class="navf">Services</a></li>
            </ul>
          </nav>
        </header>
    <div class="container">

        <!-- Outer Row -->
        <div class="row justify-content-center">

            <div class="col-xl-10 col-lg-12 col-md-9">

                <div class="card o-hidden border-0 shadow-lg my-5">
                    <div class="card-body p-0">
                        <!-- Nested Row within Card Body -->
                        <div class="row">
                            <div class="col-lg-6 d-none d-lg-block bg-login-image"></div>
                            <div class="col-lg-6">
                                <div class="p-5">
                                    <div class="text-center">
                                        <h1 class="h4 text-gray-900 mb-4">Welcome To BPMS !</h1>
                                    </div>
                                    <form class="user" method="POST">
                                        <div class="form-group">
                                            <input type="email" class="form-control form-control-user"
                                                id="exampleInputEmail" aria-describedby="emailHelp" name="email"
                                                placeholder="Email Address..." required="true">
                                        </div>
                                        <div class="form-group">
                                            <input type="password" class="form-control form-control-user"
                                                id="exampleInputPassword" placeholder="Password" name="password" required="true">
                                        </div>
                                        <div class="form-group">
                                            <div class="custom-control custom-checkbox small">
                                                <input type="checkbox" class="custom-control-input" id="customCheck">
                                                <label class="custom-control-label" for="customCheck">Remember
                                                    Me</label>
                                            </div>
                                        </div>
                                        <button type="submit" name="login" class="btn btn-primary btn-user btn-block">
                                            Login
                                        </button>
                                        <hr>
                                    </form>
                                    <hr>
                                    <div class="text-center">
                                        <a class="small" href="forgotpassword.php">Forgot Password?</a>
                                    </div>
                                    <div class="text-center">
                                        <a class="small" href="signup.php">Create an Account!</a>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

            </div>

        </div>

    </div>

    <!-- Bootstrap core JavaScript-->
    <script src="vendor/jquery/jquery.min.js"></script>
    <script src="vendor/bootstrap/js/bootstrap.bundle.min.js"></script>

    <!-- Core plugin JavaScript-->
    <script src="vendor/jquery-easing/jquery.easing.min.js"></script>

    <!-- Custom scripts for all pages-->
    <script src="js/sb-admin-2.min.js"></script>

</body>

</html>
 
The error in line 10 is caused by a syntax error in the SQL query in the line above it. The mysqli_query() function requires two parameters: the database connection and the SQL query string. However, in line 9, the database connection parameter is enclosed in parentheses, causing the error. To fix the error, remove the parentheses around $con in the mysqli_query() function in line 9, like this:

Code:
$query = mysqli_query($con, "SELECT * FROM login WHERE Email='$email' AND Password='$password'");

This should resolve the syntax error and allow the code to execute properly.
 
Status
Not open for further replies.

About this Thread

  • 1
    Replies
  • 385
    Views
  • 1
    Participants
Last reply from:
Unknown user

Trending Topics

Online now

Members online
1,035
Guests online
1,257
Total visitors
2,292

Forum statistics

Threads
2,283,518
Posts
29,016,103
Members
1,221,502
Latest member
ghfghvch
Back
Top