Re: selecting a specific record from database
| From: | Pedro M. S. Oliveira | Date: | Sat, 18 Nov 2000 00:14:55 +0000 |
| Subject: | Re: selecting a specific record from database | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-4527@lists.php.net to get a copy of this message | ||
use this example
the func you will look with attention is mysql_query()
---------------------------------------------------------------
$host = "123.123.133.123";
$mysqluser = "ccccccccc";
$mysqlpass = "zzzzzzzzzzz";
$database = "*****";
if (!$user=="" || !$pass=="")
{
$db = mysql_connect ($host,$mysqluser,$mysqlpass);
mysql_select_db ($database,$db);
$query="select pass from user where user like \"$user\"";
$passwd = mysql_query ( $query,$db);
$dbpass = mysql_fetch_array ($passwd);
if ($dbpass[pass]==$pass)
{
print "<p align=center><big><b>\"Bemvindo
$user\"</b></big></p>";
print $tabela2;
}
else
{
print "Password ou username errada/o";
}
}
else
print "<p align=center><big><big><b>O Login é
Obrigatório!</p>";