Trying to connect a database in php, but get syntax error

Question

I am trying to make a login page using a database I created in PHPMyAdmin, but everytime I run it, I get a syntax error on line 2 of login.php, and I do not know why it will not work. I am sure I entered the code correctly. When I run it, I get an error:

Parse error: syntax error, unexpected ':' in login.php on line 2

login.php

<?php
    $dsn = 'mysql:host=localhost;dbname=dbase';
    $username = 'user1';
    $password = 'pass';

    $error = "";

    try{
        $db = new PDO ($dsn, $username, $password);
    }

    catch (PDOException $e){
        $error = $e->getMessage();
    }
// end of database connect

    $user = $_POST['user'];
    $pass = $_POST['pass'];

    $query = 'SELECT * FROM users WHERE user = :user AND pass = :pass';

    $statement = $db->prepare($query);
    $statement->bindValue(':user', $user);
    $statement->bindValue(':pass', $pass);
    $statement->execute();
    $valid = ($statement->rowCount() == 1);
    $result = $statement->fetch();
    $statement->closeCursor();

    if ($valid){
        $greeting = $result['email'];
        $permit = ", login success";
    }

    else{
        $greeting = $user;
        $permit = ", invalid credentials";
    }

?>
<!DOCTYPE html>

<html>
    <head>
        <title>Scheduler</title>
    </head>

    <body>
        <h1><?php echo $greeting.$permit; ?></h1>
    </body>
</html>

loginpage.php

<html>
    <head>
        <title>Scheduler</title>
    </head>

    <body>
        <form action = 'login.php' method = "post">
            <h1>EZ-Scheduler</h1>

            <h2>Please login to view rosters</h2>

            <table>
                <tr>
                    <td>Username:</td>
                    <td><input name = "user" type = "text" size = "25"></td>    
                </tr>
                <tr>
                </tr>   
                <tr>
                    <td>Password:</td>
                    <td><input name = "pass" type = "password" size = "25"></td>
                </tr>
            </table>    
                <p><input type = "submit" name = "button" value = "Login"></p>
            </table>
        </form>
    </body>
</html>

please refer to : https://stackoverflow.com/questions/18050071/php-parse-syntax-errors-and-how-to-solve-them — spencer7593, May 06 '20 at 22:21
o can't see qany error in your code,t first gnace but never storeoasswords in databases use hashing see https://www.php.net/manual/en/book.password.php — nbk, May 06 '20 at 22:30
line 2 appears to be the assignment of a string literal to a variable; doesn't seem at all reasonable that php would think a colon character in a single quoted string literal would be a syntax error. just guessing here, but my guess is that the code block posted here is different from the code being read by the PHP interpreter. — spencer7593, May 06 '20 at 22:30

score -2 · Accepted Answer · answered May 06 '20 at 22:24

-2

try this stuff and see

<?php
    $username = 'user1';
    $password = 'pass';

    $error = "";

    try{
        $db = new PDO ('mysql:host=localhost;dbname=dbase', $username, $password);
    }

    catch (PDOException $e){
        $error = $e->getMessage();
    }
// end of database connect

answered May 06 '20 at 22:24

Clarance Liberiste Ntwari

3,361
2
25
37

I fixed my problem. Thank you. – davidc1194 May 06 '20 at 22:31

Trying to connect a database in php, but get syntax error

1 Answers1