quando acesso logar.php não aparece erro.. porem quando coloco usario e senha ... aparece esse erro
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in c:\arquivos de programas\easyphp\www\foto\modules\users\logar.php on line 38
e o endereco aparece sem o final do GAL
linha 38
$fetch_gal = mysql_fetch_array($Fetch_query);
olhem o codigo
<?php require_once('Connections/loguin.php'); ?><?php
// *** Validate request to login to this site.
session_start();
$loginFormAction = $_SERVER['PHP_SELF'];
if (isset($accesscheck)) {
$GLOBALS['PrevUrl'] = $accesscheck;
session_register('PrevUrl');
}
if (isset($_POST['USER'])) {
$loginUsername=$_POST['USER'];
$password=$_POST['SENHA'];
$MM_fldUserAuthorization = "";
$MM_redirectLoginSuccess = "ola.php";
$MM_redirectLoginFailed = "erro.php";
$MM_redirecttoReferrer = false;
mysql_select_db($database_loguin, $loguin);
$LoginRS__query=sprintf("SELECT * FROM usuarios WHERE USER='%s' AND SENHA='%s'",
get_magic_quotes_gpc() ? $loginUsername : addslashes($loginUsername), get_magic_quotes_gpc() ? $password : addslashes($password));
$LoginRS = mysql_query($LoginRS__query, $loguin) or die(mysql_error());
$loginFoundUser = mysql_num_rows($LoginRS);
if ($loginFoundUser) {
$loginStrGroup = "";
//declare two session variables and assign them
$GLOBALS['MM_Username'] = $loginUsername;
$GLOBALS['MM_UserGroup'] = $loginStrGroup;
//register the session variables
session_register("MM_Username");
session_register("MM_UserGroup");
if (isset($_SESSION['PrevUrl']) && false)
$Fetch_query= "SELECT USER, SENHA FROM usuarios WHERE USER='$loginUsername' AND SENHA='$password'";
$fetch_gal = mysql_fetch_array($Fetch_query);
echo '<meta http-equiv="refresh" content="2;url=dll.php?pp=0,3&do=mostragal&gid='.$fetch_gal['GAL'].'">';
}
else {
header("Location: ". $MM_redirectLoginFailed );
}
}
?><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>kikoweb.com</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
.style1 {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-weight: bold;
font-style: italic;
font-size: small;
}
.style3 {color: #FF0000}
-->
</style>
</head>
<body>
<form action="<?php echo $loginFormAction; ?>" method="POST" name="logar" id="logar">
<p class="style1"><a href="index.php">Pagina inicial </a><br>
<br>
Digite sua senha para entrar. <br>
</p>
<blockquote>
<p>
<input name="USER" type="text" id="USER" size="25">
<br>
<input name="SENHA" type="password" id="SENHA" size="25">
<br>
<input type="submit" value="Logar">
</p>
</blockquote>
</form>
</body>
</html>
Pergunta
keruba
tipowww
quando acesso logar.php não aparece erro.. porem quando coloco usario e senha ... aparece esse erro
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in c:\arquivos de programas\easyphp\www\foto\modules\users\logar.php on line 38
e o endereco aparece sem o final do GAL
linha 38
$fetch_gal = mysql_fetch_array($Fetch_query);
olhem o codigo
<?php require_once('Connections/loguin.php'); ?><?php // *** Validate request to login to this site. session_start(); $loginFormAction = $_SERVER['PHP_SELF']; if (isset($accesscheck)) { $GLOBALS['PrevUrl'] = $accesscheck; session_register('PrevUrl'); } if (isset($_POST['USER'])) { $loginUsername=$_POST['USER']; $password=$_POST['SENHA']; $MM_fldUserAuthorization = ""; $MM_redirectLoginSuccess = "ola.php"; $MM_redirectLoginFailed = "erro.php"; $MM_redirecttoReferrer = false; mysql_select_db($database_loguin, $loguin); $LoginRS__query=sprintf("SELECT * FROM usuarios WHERE USER='%s' AND SENHA='%s'", get_magic_quotes_gpc() ? $loginUsername : addslashes($loginUsername), get_magic_quotes_gpc() ? $password : addslashes($password)); $LoginRS = mysql_query($LoginRS__query, $loguin) or die(mysql_error()); $loginFoundUser = mysql_num_rows($LoginRS); if ($loginFoundUser) { $loginStrGroup = ""; //declare two session variables and assign them $GLOBALS['MM_Username'] = $loginUsername; $GLOBALS['MM_UserGroup'] = $loginStrGroup; //register the session variables session_register("MM_Username"); session_register("MM_UserGroup"); if (isset($_SESSION['PrevUrl']) && false) $Fetch_query= "SELECT USER, SENHA FROM usuarios WHERE USER='$loginUsername' AND SENHA='$password'"; $fetch_gal = mysql_fetch_array($Fetch_query); echo '<meta http-equiv="refresh" content="2;url=dll.php?pp=0,3&do=mostragal&gid='.$fetch_gal['GAL'].'">'; } else { header("Location: ". $MM_redirectLoginFailed ); } } ?><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <title>kikoweb.com</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <style type="text/css"> <!-- .style1 { font-family: Verdana, Arial, Helvetica, sans-serif; font-weight: bold; font-style: italic; font-size: small; } .style3 {color: #FF0000} --> </style> </head> <body> <form action="<?php echo $loginFormAction; ?>" method="POST" name="logar" id="logar"> <p class="style1"><a href="index.php">Pagina inicial </a><br> <br> Digite sua senha para entrar. <br> </p> <blockquote> <p> <input name="USER" type="text" id="USER" size="25"> <br> <input name="SENHA" type="password" id="SENHA" size="25"> <br> <input type="submit" value="Logar"> </p> </blockquote> </form> </body> </html>Link para o comentário
Compartilhar em outros sites
1 resposta a esta questão
Posts Recomendados
Participe da discussão
Você pode postar agora e se registrar depois. Se você já tem uma conta, acesse agora para postar com sua conta.