logon page with or without mysql

hi, i have installed php onto my IIS 6 server (windows server 2003) and i now have mysql installed on it. i would like to make a logon page in php that can use mysql because i now have it installed on my server. how can i do this. i am still learning php at the moment.
thanks, dandono

It is possible to use MS Access but I would not recommend it, as it does not function well as a database server. There are two ways you could achieve this:

1. If you are using PHP 5 then you can make use of the SqlLite extension. This is a lite weight database engine which has been built into PHP.
2. Keep a list of user names/passwords in a CSV file on the server.

There is a link in my signature to a tutorial on installing MySql and PHP so I would advise you give it a go if you want to use a proper database server. ;)

Or you could just read and write from a plain text file...
It's good enough if you're just doing this for a small project with only a few users and don't have too high demands on security...
Just make sure you store the text file in a directory not accessible from the internet and that you encrypt atleast the passwords. (you should do that in a regular database as well...)

Hi,

Why not use mysql ? If you have mysql then use it..it would be more safer, faster and friendlier.

Thanks

im downloading mysql from the website not. how can i make a login page using php and mysql. also when it connects to mysql can it use the server name that the page is hosted on so if the page was something like http://somehost/logon.php then it will use the server somehost and so on.

One simple php/mysql based login script ...stand alone with form:

PHP Code:

---

<?php
$dbhost = "localhost";
$dbname = "dbname";
$dbuser = "dbuser";
$dbpass = "dbpass";

$conn = mysql_connect($dbhost, $dbname, $dbpass) or die(mysql_error());
$db = mysql_select_db($dbname, $conn) or die(mysql_error());
session_start();

if (isset($_POST["login"]))
{
        $q1 = "SELECT * FROM users LIMIT 1";
        $r1 = mysql_query($q1) or die(mysql_error());
        $a1 = mysql_fetch_array($r1);

        $pass = 0;

        if($_POST["username"] == $a1["username"])
        {
                $pass++;
        }
        if($_POST["password"] == $a1["password"])
        {
                $pass++;
        }

        if ($pass == 2)
        {
                $_SESSION["isAdmin"] = "admin";
                header ("Location: manage.php");
                exit();
        }
        else
        {
                $pass = 0;
                echo "Invalid username / password.<br><br>\n";
        }
}
?>

<center>
<form method="post" action="login.php">
Username:<br>
<input type="text" name="username" value="<?=$_POST["username"]?>"><br>
Password:<br>
<input type="password" name="password" value="<?=$_POST["password"]?>"><br>
<br>
<input type="submit" value="Login" name="login">
</form>
</center>

---

Hope this helps.

i tried your code and i got the folowing error:
Fatal error: Call to undefined function mysql_connect() in D:\Inetpub\XPROOT\login.php on line 7
how can i get this to work. how do i use MySQL on a windows server. i have downlaoded and installed MySQL onto my windows server but i do not know how to set up my first database. how do i do that.

Quote:

---

Originally Posted by visualAd

There is a link in my signature to a tutorial on installing MySql and PHP so I would advise you give it a go if you want to use a proper database server. ;)

---

____?

i ran that and it returned:
ERROR 2017 <HY000>: Can't open named pipe to host: . pipe: MySQL <2>

Hi,

If you got error on line 7 it means you have not set something right like: db_host etc.

if you're using iis, mysql and php then it will be

host = "localhost"
username = the db you create in mysql
password = leave it blank
dbname = the db you create in mysql

try this and let me know if it works..but you will get error again when you run the script becuase you have not setupeed the table..

thanks

If you foollwoed the MySql setup in the tutorial you'll need to set the host $host = '.' as this forces connection through a named pipe.

how should i set up mysql if i wanted it to allow connections from the internet and network?

Hi

just put the ip in db_host where mysql is running
if its on a system on network has ip of 192.168.1.5 then use 192.168.1.5

Thanks

ok i think i have got mysql set up properly now. how can i get the login.php doc to work with it. i have changes the $dbhost to 192.168.0.1 to connect to it on my network but i get an error. i have tried it on the server and my workstation but same error. the error is:
Fatal error: Call to undefined function mysql_connect() in D:\Inetpub\XPROOT\login.php on line 7. i am able to create databases and delete them now but only from the server.

Hi,

Have you changed the other values like dbname etc. ? Also can i know how you created the database ? Did you set a password for it ? Also how many people you want to authenticate using this if its just 1 user then it will be better not to use mysql but if its more than 1 then u go for mysql else just make a simple config file and incldue it in the login script and

Thanks.

i set up my first database by using the command prompt (cmd.exe) and entered "mysql" and then "CREATE DATABASE [db1];"
i think at most it would be 10 people at a time but i dont know how popular my site is at school so it might be more.i set a password for the ROOT user if that is what you meen.my server will be dws05.ath.cx (the link in my sig is the website i would like to use)

Hi,

You create a new database like this just start mysql in command prompt and then copy paste the following code:

Code:

---

CREATE DATABASE users;

use users;

CREATE TABLE `users` (
  `id` mediumint(9) NOT NULL auto_increment,
  `username` varchar(15) default NULL,
  `password` varchar(15) default NULL,
  `email` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1;

---

This will create a db named users and a table within that db named users which has username, password and email field.

Hope this helps.

Thanks

ok i done what you said now how do i configure login.php to work with it?
how does this bit of code work?
$dbhost = "192.168.0.1";
$dbname = "user";
$dbuser = "dbuser";
$dbpass = "dbpass";
i run the php on a workstation so dbhost would be 192.168.0.1 but what would dbuser and dbpass be? i stil get an error. the error is:
Fatal error: Call to undefined function mysql_connect() in D:\Inetpub\XPROOT\login.php on line 7.

Hi,

I think there would be no password and the username would be "users" and dbname would be "users" also. Try this and let me know if it works. Leave the password blank.

Thanks!

Quote:

---

Originally Posted by dandono

i run the php on a workstation so dbhost would be 192.168.0.1 but what would dbuser and dbpass be? i stil get an error. the error is:
Fatal error: Call to undefined function mysql_connect() in D:\Inetpub\XPROOT\login.php on line 7.

---

That error is caused when you havn't got the MySql extension enabled or the MySql libraries are not present on your sustem.

If you want the MySql libraries without installing MySql you'll need to download the ZIp version of PHP and copy the file libmysql.dll to C:\winnt\

what if i have allready installed MySQL for windows? how do i enable the MySQL extension?

Copy the libmysql.dll file which should be in the bin directory of the MySql installation directory to C:\winnt\, then uncomment the lin in php.ini extension=php_mysql.dll.

where is php.ini?

found it in C:\WINDOWS\.
do i need to change the name of the file to php_mysql.dll?
i tried changing the name and then i went to login.php and i got an error on the server: Invalid Library(maybe not a php library)'php_mysql.dll'

You need to edit the php.ini file like I described in the above post. You need two files to turn on the MySql extension. libmysql.dll and php_mysql.dll and you also need to edit the php.ini file to turn on the MySql extension.

Find the line:

;extension = php_mysql.dll

And remove the semi colon so it looks like this:

extension = php_mysql.dll

do you have a copy of php_mysql.dll because i dont have it on my system.

Quote:

---

Originally Posted by visualAd

If you want the MySql libraries without installing MySql you'll need to download the ZIp version of PHP and copy the file libmysql.dll to C:\winnt\

---

:afrog:

i done that but on the server it had a message box saying "PHP Startup: Unable to load dynamic library './php_mysql.dll' - The specified module could not be found. i have copied libmysql.dll to C:\WINDOWS\ and changed php.ini. do i need to do anything else for it to work?

Do you have the file php_mysql.dll?

If so put a copy in C:\winnt\ or C:\php\

i have libmysql.dll but i do not have php_mysql.dll

It should be in the ext directory if you downloaded the zip version of PHP.

i cant find it. can you send me your copy of the file please?

ok i have got the right file and done what you said but i got this on login.php
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'users'@'host.ddodn.net' (using password: NO) in D:\Inetpub\XPROOT\login.php on line 7
Access denied for user 'users'@'host.ddodn.net' (using password: NO)
what do i need to change in mysql?

ok i have got the right file and done what you said but i got this on login.php
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'users'@'host.ddodn.net' (using password: NO) in D:\Inetpub\XPROOT\login.php on line 7
Access denied for user 'users'@'host.ddodn.net' (using password: NO)
what do i need to change in mysql?

You need to grant the use priviledges in MySql. It can be done like this:

Code:

---

USE mysql;

GRANT ALL ON dbname.* TO 'username'@'host' IDENTIFIED BY 'password';

---

when i run the command for creating the database and the tabel it appears with two arrows that look like this
-> ->
what do i do when that happens?

Hi,

If you have IIS and MS Access then why just not use that instead of using PHP and MySQL ???

Thanks

Quote:

---

Originally Posted by AvisSoft

If you have IIS and MS Access then why just not use that instead of using PHP and MySQL ??

---

Because MS Access is terrible as a database server. Once you have more than a couple of connections the whole thing has a tendancy of getting itself scrambled and crashing.

Dan - I do not understand your question. Are you referring to the command line client 'MySql', where you type the queries?

Hi visualAd,

Yes you're but dandono says that he earlier wanted it without mysql so if wihtout mysql it is then it would have been text files and we all know that MS Access is far better than text file :p

And also if IIS and MSAccess is already there then why waste resources on php and mysql...just using the IIS & MSAccess will save him time and resources.

Thanks

Quote:

---

Originally Posted by AvisSoft

Yes you're but dandono says that he earlier wanted it without mysql so if wihtout mysql it is then it would have been text files and we all know that MS Access is far better than text file

---

Access alone uses alot more resources then both PHP and MySql put together. So in my opinion text files are better :p. Whats more, if he is using PHP 5 then he doesn't even need MySql, he can just use the built in Sql module SqlLite.

Hi,

Yes you maybe are correct but if he's on Windows and using IIS then he has already got MSAccess support. He now just need an mdb file with desired fields. But anyways its his choice.

Thanks.

in my first post i thought that MySQL was only avalible on linux or whatever but now i have MySQL on my windows server and now would like to have a login page with or without mysql

i cant get mysql to work at all now so how do you make a login page that uses a text document? can the user change the password for only there user account?

Hi,

Why not use asp and access ?

Thanks

because i dont know much asp.

Hi,

Its been very long so here it is: The script looks for data in users.txt file in the following format:

Quote:

---

someuser, somepass
someuser1, somepass1
someuser2, somepass2
someuser3, somepass3
someuser4, somepass4

---

This is the script. Hope this will help you.

PHP Code:

---

<?php
$handle = fopen("users.txt", "r");

// Get username and password
$username = $_POST["username"];
$password = $_POST["password"];

while (!feof($handle))
{
        $buffer = fgets($handle);
        if ($buffer == $username . ", " . $password)
        {
                // If username and password matches then
                // set username in session variable for later use,
                // redirect the user to manage.php or where ever you
                // like, close the users.txt file and exit the script
                // so it does not keeps executing.
                $_SESSION["isLogged"] = "Y";
                $_SESSION["username"] = $username;
                header ("Location: manage.php");
                fclose($handle);
                exit();
        }

        // If loop is over and username and password did'nt matched then
        // we show the invalid login message, reset session variables for
        // tight security and close file exit the script.
        $_SESSION["isLogged"] = "Y";
        $_SESSION["username"] = $username;

}
fclose($handle);
?>

---

Thanks

i tried your code and made a page with a form with three things on it. a text box called password, a text box called username and a button names submit.
this is the code:

HTML Code:

---

<html>
<head>
<title>Dan's Web Server 2005!</title>
</head>
<body>
<form name="input" action="textlogin.php"
method="post">
Username:
<input type="text" name="username">
<br>
Password:
<input type="password" name="password">
<input type="submit" value="Login">
</form>
</body>
</html>

---

and textlogin.php is your code. according to the comments it is ment to forward to manage.php but it does not for some reason.i have made a simple script that prints a few words onto the page but it does not forward.