7 replies to this topic

[TheExposedOne]

hi,
how do you make a login and use an already made mysql table

i have a script that makes tables in mysql but would like another script the same tables in that same mysql database

[Ad Bot]

[Eli L]

Moved to Web Dev

[Sharad D]

I didn't under stand the problem.... If you have username and passwords stored on server, just fetch entry from table and compare the passwords.

[TheExposedOne]

id like a script that would do that for me

[Sharad D]

Structure of database is needed for that... Without that script can not be prepared... Explaining database structure in public may compensate security on your site. SO its better if you code it your self.

Edited by System Sneaker, 16 July 2010 - 11:16 AM.

[seguy]

u need to include a database check in php and connect the database to provide a login.

[bossier330]

Here's a simple example for you to see basically how things work. Note that this is NOT a GOOD implementation. It is only meant to show you the basics.

$db_host = 'host site';
$db_user = 'user name';
$db_pass = 'password';
$db_name = 'database name';

// Connect to the MySQL database and save the link identifier (false if unsuccessfull).
$db_connection = mysql_connect($db_host, $db_user, $db_pass);

// Select the database, explicitly specifying the above link identifier.
mysql_select_db($db_name, $db_connection);

// Capture the user name depending on your needs.
$username = // Fill in here.

// Build the query.
$query = "SELECT * FROM `" . 'table name' . "` WHERE `" . 'user name column heading' . "` = '" . $username . "'";

// Perform the query.
$result = mysql_query($query);

// Check for success with $result.

// The following lines will return the stored password so that you can perform a check.
$row = mysql_fetch_assoc($result);
$row['password field name'];

// Process the login...

Untested, but it should work haha.

[Kiro R]

bossier330, on 15 December 2010 - 11:08 AM, said:

Here's a simple example for you to see basically how things work. Note that this is NOT a GOOD implementation. It is only meant to show you the basics.

$db_host = 'host site';
$db_user = 'user name';
$db_pass = 'password';
$db_name = 'database name';

// Connect to the MySQL database and save the link identifier (false if unsuccessfull).
$db_connection = mysql_connect($db_host, $db_user, $db_pass);

// Select the database, explicitly specifying the above link identifier.
mysql_select_db($db_name, $db_connection);

// Capture the user name depending on your needs.
$username = // Fill in here.

// Build the query.
$query = "SELECT * FROM `" . 'table name' . "` WHERE `" . 'user name column heading' . "` = '" . $username . "'";

// Perform the query.
$result = mysql_query($query);

// Check for success with $result.

// The following lines will return the stored password so that you can perform a check.
$row = mysql_fetch_assoc($result);
$row['password field name'];

// Process the login...

Untested, but it should work haha.

It wouldn't work.
Because you're not calling the actual form, which you can do two ways. A simple if statement or via isset(), which you didn't do at all.

include "config.php"; //Include your configs from a file, not differently on each page
if(isset($_POST['submitbutton'])){

$username = mysql_real_escape_string($_POST['username']);
$password = mysql_real_escape_string($_POST['password']);

$GettingUser = mysql_query("SELECT * FROM `table` WHERE `Username`='$username' && `Password`='$password'") or die(mysql_error());
$HasUser = mysql_fetch_assoc($GettingUser);

if(!$username && !$password){ die("<script>alert('Fill in all fields');history.back('');</script>"); }
if(mysql_num_rows($GettingUser) == 0){ die("<script>alert('Account doesn't exist');history.back('');</script>"); }

//This is where it is successful.
$_SESSION['user'] = $username;

//From hereon out if the login was successful you can note if the user is logged in by using the $_SESSION['user'] variable, but you must add session_start(); and session_end(); if those are right, lmao I can't remember to the top and bottom of your page.

}

That is the correct way.