|
|
Posted by shimmyshack on 04/29/07 18:18
On Apr 29, 3:38 pm, MIUSS <m...@seznam.cz> wrote:
> I tried many things for several hours to repair this code but I didn't
> get success:-(
> The code below is from some learning site which is little old. I
> didn't change anything in there, I know it's old-style. Could somebody
> copy and repair just only the short part of that code just the
> function mysql_query(...); to the new style to let me see the
> difference between new-style and old-style?
>
> In addition, I tried it like this:
> $sql = mysql_query("SELECT * FROM autori
> WHERE login = \"".
> $_SERVER['PHP_AUTH_USER']."\"
> AND pass =
> \"".md5($_SERVER['PHP_AUTH_PW'])."\"
> AND stav = \"a\";");
> Without success:-(
>
> And this is the code from the learning site (unchanged, I only marked
> the problem part):
>
> <?
>
> if (!IsSet($PHP_AUTH_USER))
> {
> Header("HTTP/1.0 401 Unauthorized");
> Header("WWW-Authenticate: Basic realm=\"RS - Admin Center\"");
> echo "Neautorizovaný pøístup";
> exit;
>
> }
>
> // pokud u¾ivatel vyplnil formuláø pokraèujeme ovìøením dat v databázi
> else
> {
> // pøipojíme se k databázi
> include "../conn.php";
> // hledáme záznam s loginem a heslem zadaným v autorizaèním
> // formuláøi. Hledáme jen aktivní u¾ivatele.
>
> /////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
> @$sql = mysql_query("SELECT * FROM
> autori //problem part//
> WHERE login LIKE
> '$PHP_AUTH_USER' //problem part//
> AND pass =
> '".md5($PHP_AUTH_PW)."' //problem part//
> AND stav =
> 'a'"); //problem part//
> /////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
>
> // pokud ¾ádného takového u¾ivatele nenajdeme
> // rozlouèíme se s ním
> if (mysql_num_rows($sql) == 0)
> {
> Header("HTTP/1.0 401 Unauthorized");
> Header("WWW-Authenticate: Basic realm=\"RS - Admin Center\"");
> echo "Neautorizovaný pøístup";
> mysql_close($conn);
> exit;
> }
> // spojení s databází ji¾ nepotøebujeme, proto jej uzavøeme
> mysql_close($conn);}
>
> // následuje rozdìlení okna prohlí¾eèe na rámy
> ?>
> <HTML>
> <HEAD>
> <TITLE>RS - Admin Center</TITLE>
> </HEAD>
>
> <FRAMESET COLS="180,*">
> <FRAME SRC="menu.php" NAME="menu" SCROLLING=AUTO>
> <FRAME SRC="main.php" NAME="main" SCROLLING=AUTO>
> </FRAMESET>
>
> <NOFRAMES>
> <BODY>
> K pou¾ití administraèní sekce potøebujete prohlí¾eè s podporou
> rámù.
> </BODY>
> </NOFRAMES>
>
> </HTML>
>
> Thanks in advance!
>
> Ragards Michael
if (!IsSet($PHP_AUTH_USER))
--->
if ( !isset($_SERVER['PHP_AUTH_USER']) )
[Back to original message]
|