help with a login synax for this exampel

Chrysanthus

Hi i wanna make a login to this exampel and i made it sow fira

Username:<br>
<input class="inputSidebar" type="text" name="nickname"<br>
<br>
Password:<br>
<input class="inputSidebar" type="password" name="password1"><br>
<input class="button" type="submit" name="submit" value="Log in">
</form>

<br>
<a href="/login/register.php">Register!</a><br>
<a href="#">Lost password?</a>

</div>

chinni_77

Chrysanthus,

Please dont cross post.It does'nt mean that your thread will receive lots of attention or somebody will help you immediately if you post it in different sections of the forum.I'm sure the persons who are monitoring the board will lock this thread.I'll see if i can help with this thread in the other section

Chrysanthus

I did not know where to put it .. if its a hard related or not...

to put it in newbee forum was not maby sow good idé...
the ide was two put in the right place...

chinni_77

OK.seems that you have deleted your thread in the newbies section,good.

Couple of questions:

1.Are you trying to check for the user name and password?
2.Do you have many users or do you have only one user and password where you hard-code them in the script?

Read this Thread.It might help you

Chrysanthus

yeap im trying to check username and password..

i have like 10-100 users that intime will login.

is this the singel user login way?

but i have problem when i come to

$result = mysql_query($sql) or die("Query failed");

and then after i do not know what is the problem...

$nickname=$POST["nickname"];
$password=$POST["password"];

$host = "localhost";
$username = "xxxx";
$password = "xxxx";
$connect = mysql_connect($host, "$username", "$password")
or die("Could not connect to MySQL!");

$db = mysql_select_db("flameline") or die("Could not select database");

$sql = "select * from reg_info where nickname = '$nickname' and password = '$password';";
$result = mysql_query($sql) or die("Query failed");

if (mysql_num_rows($result) > 1) {
print "<p><center><big><big>Welcome $nickname Please click <a href=\"index.html\"> here to continue</big></big></center></p>";
}
else
{
print "<p><center><big><big>Sorry, credentials supplied are incorrect.</big></big></center></p>";
}

?>
You are in

DeltaRho2K

Change this:

if (mysql_num_rows($result) > 1) {

To something this:

if (mysql_num_rows($result) == '1') {

In theory, you should not expect to get anything higher than a 1, since you would be using unique user names anyhow... (in theory)

Chrysanthus

Thanks it works now.. but i wounder if i wanna place mysqlcon.php in another folder how should i point to its Directroy

$nickname=$POST["nickname"];
$password=$POST["password"];

include 'mysqlcon.php';

$sql = "select * from reg_info where nickname = '$nickname' and password = '$password';";
$result = mysql_query($sql) or die("Query failed");

if (mysql_num_rows($result) == '1') {
print "<p><center><big><big>Welcome $nickname Please click <a href=\"index.html\"> here to continue</big></big></center></p>";
}
else
{
print "<p><center><big><big>Sorry, credentials supplied are incorrect.</big></big></center></p>";
}

?>
You are loged in

cassius

If your mysqlcon.php is located in a subdirectory type

 include('subdirectoryname/mysqlcon.php');

If your con-file is located in a directory "abowe" working directory you should type

../

for EACH directory that you have to move up before you end up in the rigth directory.

The idea is to use relative adressing, NOT absolute adressing like http://www.something.com/cons/mysqlcon.php...relative adressing also makes it easier to move sites and update changes later.

if my con-file is located two directories above working directory you type

include('../../mysqlcon.php');

NOTICE that if you use include-sentences you will experience that the paths in the included file are relative to the file that includes the mysqlcon.php not relative to mysqlcon.php.

Chrysanthus

Thanks man it works finne.....

😃