PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!
$rs = mysql_query("SELECT * FROM Members WHERE Name = '$username' AND Password = '$password' ");
//if the user exists
if (($rs)>0)
{
//make a cookie for the user
setcookie("loginname",$username);
}
{
echo("welcome. you're in");
}
if (else);
{
echo("failed login");
}
$rs = mysql_query("SELECT * FROM Members WHERE Name = '$username' AND Password = '$password' ");
//if the user exists
if (mysql_num_rows($rs)>0){
//make a cookie for the user
setcookie("loginname",$username);
echo("welcome. you're in");
}else{
echo("failed login");
}
<?php
//if the user exists
if (($rs)>0)
{
//make a cookie for the user
setcookie("loginname",$username);
}
{
echo("welcome. you're in");
}
if (else);
{
echo("failed login");
}
?>
<?php
//if the user exists
if (($rs)>0)
{
//make a cookie for the user
if(setcookie("loginname",$username))
{
echo("welcome. you're in");
}
else
{
echo "Error setting cookie.";
}
}
else
{
echo("failed login");
}
?>
/Edit... me too... sorry...
Last edited by Goowe on Wed Mar 17, 2004 9:26 pm, edited 1 time in total.
<?php
$host = "localhost";
$dbusername = "user";
$password = "pass";
$database = "db";
// Connect to mysql and database
$link = mysql_connect($host, $dbusername, $password)
or die("<P>Could not connect: ".mysql_error()."</P>");
mysql_select_db($database)
or die("<P>Could not select database</P>");
$username = $HTTP_POST_VARS['txtName'];
$password = $HTTP_POST_VARS['txtPassword'];
$query = "SELECT * FROM Members WHERE Name = '".$username."' AND Password = '".$password."'";
$result = mysql_query($query) or die("<P>Query failed: ".mysql_error()."</P>");
// Check to see if user exists
if(mysql_num_rows($result) > 0)
{
// Make cookie for user
if(setcookie("loginname", $username))
{
echo "Welcome";
}
else
{
echo "Error setting cookie.";
}
}
else
{
echo "Failed login.";
}
?>