Toggle sidebar Toggle sidebar
Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

PHP/MySQL user/login script needed. Ideas?

Dimwhit

Dimwhit

macrumors 68020
Original poster
Hey all,

I'm going to be setting up a new website for my company, and I'm going to be needed a site-wide user registration/login system. I have one that I found online and modified a bit for my current site, but it's not particularly robust. I could probably adapt it. But I'm wondering if anyone knows of a good, reasonably-easy to install system. I don't mind paying a little bit if needed, either.

Any ideas or suggestions?
 
Try this :

<?php
session_start();
include('coor.php');
$username=$_POST['user'];
$passw=$_POST['password'];
$query="SELECT * FROM login WHERE user='$username' AND password='$passw'";
$result=mysql_query($query, $connect) or die('error making query');
$affected_rows = mysql_num_rows($result);
if($affected_rows == 1) {
$_SESSION['user']=$username;
header('location:index.php');
}
else {
header('location:loginAdmin.php?erreur=erreur');
}
?>
 
nomade said:
Try this :

<?php
session_start();
include('coor.php');
$username=$_POST['user'];
$passw=$_POST['password'];
$query="SELECT * FROM login WHERE user='$username' AND password='$passw'";
$result=mysql_query($query, $connect) or die('error making query');
$affected_rows = mysql_num_rows($result);
if($affected_rows == 1) {
$_SESSION['user']=$username;
header('location:index.php');
}
else {
header('location:loginAdmin.php?erreur=erreur');
}
?>
Click to expand...

Login script, say hello to SQL injection.
 
You must log in or register to reply here.
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.
Top Bottom
Back