creating simple login function using PHP and SQLite

Question

I am trying to create simple log-in function where I am using PHP and SQLite to make it work but every time I click log-in I get "Fatal error: Uncaught exception 'PDOException' with message 'could not find driver' in G:\wwwroot\login.php:3 Stack trace: #0 G:\wwwroot\login.php(3): PDO->__construct('sqlite:G:/wwwro...') #1 {main} thrown in G:\wwwroot\login.php on line 3" am I doing something wrong any advice will be GREAT :).

I have log-in code and saved it as index.php

<html>
    <body>
        <form action="login.php" method="POST">
        <p>Username</p><input type ="text" name="user"/>
        <p>password</p><input type="password" name="pass"/>
        <br />
        <input type="submit" value="login"/>
        </form>
    </body>
</html>

I have another php called login.php and will be activated when the user clicks login button

<?php
    $dir = 'sqlite:G:/wwwroot/SQLite/user_information.db';
    $dbh = new PDO($dir) or die ("cannot open");

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

    $myusername = stripslashes($myusername);
    $mypassword = stripslashes ($mypassword);

    $query = "SELECT * FROM user_information WHERE username='$myusername' AND password='$mypassword'";
    $result = mysql_query($query);
    $count = mysql_num_rows($result);

    if($count==1){
    echo'worked';
    }

?>

And at last I have user_information.db where I downloaded sqlite3 and using cmd program to create the database.

G:\wwwroot\SQLite>sqlite3 user_information.db
SQLite version 3.8.4.3 2014-04-03 16:53:12
Enter ".help" for usage hints.
sqlite> create table user_info(username varchar(20), password varchar(20));
sqlite> insert into user_info values('WESTKINz','password');
sqlite> insert into user_info values('LAME','123456');

Possible duplicate: http://stackoverflow.com/questions/8803728/pdo-sqlite-could-not-find-driver-php-file-not-processing — Misiur, Apr 11 '14 at 11:59
what?? i didnt create that but yhea he too have the same problem as me — WESTKINz, Apr 11 '14 at 12:00
i think my $dir is wrong and may be i am using wrong syntax to locate my path file — WESTKINz, Apr 11 '14 at 12:04
"Uncaught exception 'PDOException' with message 'could not find driver'" - are your sure you have enabled sqlite extension for pdo? — Misiur, Apr 11 '14 at 12:06
The question I've linked to has the answer. You need to put that in your php.ini (I'm guessing you're running apache, so you'll need to edit that config and restart your server) — Misiur, Apr 11 '14 at 12:08
Did you restart your apache service? Did you edit the right php.ini? Run a phpinfo() function, and check if you have sqlite there present — Misiur, Apr 11 '14 at 12:24
yes i tried all of it, yhea dont worry i will try something else but thanks :) — WESTKINz, Apr 11 '14 at 12:25

Joshua I. James · Answer 1 · 2014-04-11T12:14:16.037

0

Like the error says, it appears your server does not have the driver installed/loaded.

Check your phpinfo to see if you have the driver is registered. Make sure the sqlite extensions are uncommented in your php.ini. On Windows the php.ini file will probably be in C:\Windows\System32\PHP\php.ini. Phpinfo() should tell you where the config is located. See this post.

Also, a similar post with MySQL

edited Apr 11 '14 at 12:14

answered Apr 11 '14 at 12:08

Joshua I. James

143
1
8

Did you see [this](http://stackoverflow.com/a/2756950/3523577) comment, specifically: _PDO works only when I use the DSN prefix "sqlite2" which is not very surprising, since phpinfo() only lists the driver "sqlite2" under the section "PDO"_ What extensions does your phpinfo list under PDO? – Joshua I. James Apr 11 '14 at 12:27
don't worry about it, i ditch this project and doing something else but thanks :) – WESTKINz Apr 11 '14 at 12:35

creating simple login function using PHP and SQLite

1 Answers1