❓ 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
  • 378
    Views
  • 1
    Participants
Last reply from:
Unknown user

Trending Topics

Online now

Members online
666
Guests online
1,314
Total visitors
1,980

Forum statistics

Threads
2,273,541
Posts
28,950,272
Members
1,235,809
Latest member
NoritoshiKamoo
Back
Top