[Resolved] Simple Php/MySQL login script with cookies
- Thread starter rcep
- Start date
The views expressed on this page by users and staff are their own, not those of NamePros.
What about with session?
login.php :
----- BREAK -----
home.php
----- BREAK -----
logout.php
login.php :
PHP:
<?php
// get input
$u=$_POST['u'];
$p=$_POST['p'];
// Database check
$q=sprintf(" SELECT id FROM user WHERE username='%s' AND password='%s' ",$u,$p);
$q=mysql_query($q);
if (mysql_num_rows($q)>0) {
// matched data
$r = mysql_fetch_row($q);
$id = $r[0];
session_start();
$_SESSION['user_id'] = $id;
header("Location: home.php");
die('');
exit;
}
?>home.php
PHP:
<?php
if (!isset($_SESSION['user_id']) || $_SESSION['user_id']=='') {
header("Location: login.php");
die('');
exit;
}
// display your main "home.php" from below
?>
<html>
<h1>Welcome, our lovely member</h1>logout.php
PHP:
<?php
$_SESSION['user_id']='';
header("Location: index.php");
?>
Last edited:
At least sanitize the data before using it in a mySQL query. With what you have provided I could circumvent it within seconds.
What sort of login script do you need? And is there a reason you are specifically wanting to use cookies (although this is the default method for PHP's sessions).
What sort of login script do you need? And is there a reason you are specifically wanting to use cookies (although this is the default method for PHP's sessions).
Similar threads
New posts ➔
-
.now showcase and discussion- 166 posters
- Future Sensors
Polls of interest ➔
-
What are your strengths as an investor?- 188 voters
- 27 replies
-
What's your domain portfolio size?
- 472 voters
- 139 replies
-
How do you think a potential buyer first checks if your domain is for sale?- 527 voters
- 52 replies
Hot this week ➔
-
[SOLVED] Domain Resolution Mystery Turns Out To Be Domain Misspelling!- 40 replies
- 11 points
-
Stop chasing buyers — make them come to you.- 32 replies
- 3 points
-
Afternic Fast Transfer | Request Price Lander- 35 replies
- 3 points
-
Has anyone actually made a sale on namePros?- 19 replies
- 15 posters
-
Is Sedo still worth it?
- 19 replies
- 7 posters
Hot this month ➔
-
The $99 Experiment Is Teaching Me More About Domain Liquidity Than Appraisal Tools Ever Did- 156 comments
- 63 points
-
Feedback on DM offers- 119 replies
- 17 posters
-
AI vs. SI- 50 replies
- 19 points
