This script works on my localhost but not on my server
Posted: Wed Mar 03, 2004 7:55 am
can anyone help below i have been writing a script, it was an old login script i have used, not all i want it for is to put names into a database, no password or email but if i change the html it still works locally and adds the loginName to my database but when i put it online it doesnt.
the file containing the information about user,database is called dogs.inc and i was wandering if anyone can help me, below is the main script, ifnore the first case which is login becuase it is no longer a login script just used for adding names to a database.
if anyone has anything much more simple can they please help 
the file containing the information about user,database is called dogs.inc and i was wandering if anyone can help me, below is the main script, ifnore the first case which is login becuase it is no longer a login script just used for adding names to a database.
Code: Select all
<?php
session_start();
session_register('auth');
session_register('logname');
include("dogs.inc");
switch (@$do)
{
case "login";
$connection = mysql_connect($host ,$user,$password)
or die ("<font face='verdana' color='#e1e1e1' size='1'>Couldn't connect to server1.");
$db = mysql_select_db($database, $connection)
or die ("<font face='verdana' color='#e1e1e1' size='1'>Couldn't connect to server2.");
$sql = "SELECT loginName FROM member
WHERE loginName='$logname'";
$result = mysql_query($sql)
or die ("<font face='verdana' color='#e1e1e1' size='1'>Couldn't connect to server3.");
$num = mysql_num_rows($result);
if ($num == 1) // login name was found
{
$sql = "SELECT loginName FROM member
WHERE loginName='$fusername'
AND password=password('$fpassword')";
$result2 = mysql_query($sql)
or die("<font face='verdana' color='#e1e1e1' size='1'>Couldn't execute query4.");
$num2 = mysql_num_rows($result2);
if ($num2 > 0) // password is correct
{
$auth="yes";
$logname=$fusername;
$today = date("d-m-y h:m:s");
$sql = "INSERT INTO Login (loginName,loginTime)
VALUES ('$logname','$today')";
$message="<font face='verdana' color='#e1e1e1' size='1'>Thank you for loging in";
mysql_query($sql) or die("<font face='verdana' color='#e1e1e1' size='1'>Can't execute query.5");
$message = "<font face='verdana' color='#e1e1e1' size='1'>$fusername you are now being logged in. Thank You";
header("location: members_page.php");
}
else // password is not correct
{
unset($do);
$message="<font face='verdana' color='#e1e1e1' size='1'>The Login Name, '$fusername' exists,
but you have not entered the correct
password! Please try again.<br>";
include("login_form.inc");
}
}
elseif ($num == 0) //login name not found
{
unset($do);
$message = "<font face='verdana' color='#e1e1e1' size='1'>The login name you entered does not
exist!Please try again.<br>";
include("login_form.inc");
}
break;
case "new":
/*check to see is login name already exists*/
$connection = mysql_connect($host, $user,$password)
or die ("Couldn't connect to server1.");
$db = mysql_select_db($database, $connection)
or die ("Couldn't connect to database1.");
$sql = "SELECT loginName FROM member
WHERE loginName='$newname'";
$result = mysql_query($sql)
or die("Couldn't execute query6.");
$num = mysql_numrows($result);
if ($num > 0)
{
unset($do);
$message_new = "<font face='verdana' color='#e1e1e1' size='1'>$newname already used. Select another
Member ID.";
include("login_form.inc");
exit();
}
else
{
$today = time("Y-m-d");
$sql = "INSERT INTO member (loginName,password,
email) VALUES
('$newname',password('$newpass'),'$email')";
mysql_query($sql);
$auth="yes";
}
break;
default:
include("login_form.inc");
}
?>