How to transfer variables from a .php script to an .html page that will display the results.

[danubian]

Hi,

I'm a newbie in php/mysql programming,rea lly am.
I'm working on a web-site that allows registration and posterior
logging in. Already registered user logs in with valid username and
password. Username and password are validated against a MySQL database
of personal data that contains these fields among others.
This is done by means of a PHP script that redirects to a "page2.html "
(if user and password non-existent) OR it redirects to a
"page3.html ",if username and password exist and match in the database.
Following is part of the code:

<?php
function RedirectURL($ur l)
{ // This calls javascript
$redir = "<script language=\"java script\">locati on.href=\"$url\ "</script>\n";
return $redir;
}
?> // got this function from the groups. thanks.

<?php
..
..
..
$query = "SELECT password FROM all_pers_data WHERE username =
'$loginID' ";

$result = mysql_query($qu ery) or die
(RedirectURL('h ttp://xxx.xxx.xxx.xxx :XXXX/ / /page2.html'));
$numentries = mysql_numrows($ result); //Numero de filas
returned. mysql_close($li nk);

$correct_userna me = $loginID;
$correct_passwo rd = mysql_result($r esult,0,"passwo rd"); //assumming
there is only one match...
if (strcasecmp($co rrect_username, $loginID) ||
strcasecmp($cor rect_password,$ loginPW) ) {
die(RedirectURL ('http://xxx.xxx.xxx.xxx :XXXX/ / /page2.html'));
//loginID or password that do not match
}
else {
die(RedirectURL ('http://xxx.xxx.xxx.xxx :XXXX/ /
/page3.html'));//ASSERT, print out info in .html page.
}
..
..
..

?>

My question is: how can I transfer the variable "$result" from my PHP
to the .html pages, so that I'm able to print out the info for the
existent user through page3.html. In other words, i would like to
re-use "$result" from the php/mysql query; this, in order to display
information about the successfully logged in user.

Any help or suggestions i will appreciate a lot. Thanks.

Ivan

[Grant Wagner]

da******@hotmai l.com wrote:

My question is: how can I transfer the variable "$result" from my PHP
to the .html pages, so that I'm able to print out the info for the
existent user through page3.html. In other words, i would like to
re-use "$result" from the php/mysql query; this, in order to display
information about the successfully logged in user.

Any help or suggestions i will appreciate a lot. Thanks.

<url: http://jibbering.com/faq/#FAQ4_18 />

--
Grant Wagner <gw*****@agrico reunited.com>
comp.lang.javas cript FAQ - http://jibbering.com/faq

[Pedro Graca]

["Followup-To:" header set to comp.lang.php.]
da******@hotmai l.com wrote:
[snip]

My question is: how can I transfer the variable "$result" from my PHP
to the .html pages, so that I'm able to print out the info for the
existent user through page3.html. In other words, i would like to
re-use "$result" from the php/mysql query; this, in order to display
information about the successfully logged in user.

Any help or suggestions i will appreciate a lot. Thanks.

Use session variables: http://www.php.net/session

When you know the $result save it in a session variable

$_SESSION['SQLResult'] = $result;

and, afterwards, when you need the same result use the value saved in
the session variable

echo 'Saved result is: ', $_SESSION['SQLResult'];

Don't forget to start the session support in *every* page that uses the
$_SESSION array
--
USENET would be a better place if everybody read: | to mail me: simply |
http://www.catb.org/~esr/faqs/smart-questions.html | "reply" to this post, |
http://www.netmeister.org/news/learn2quote2.html | *NO* MIME, plain text |
http://www.expita.com/nomime.html | and *NO* attachments. |

[Michael Fesser]

.oO(da******@ho tmail.com)

function RedirectURL($ur l)
{ // This calls javascript
$redir = "<script language=\"java script\">locati on.href=\"$url\ "</script>\n";
return $redir;
}

header("Locatio n: $url");

http://www.php.net/header

Micha

[Geoff Berrow]

I noticed that Message-ID:
<sl************ *******@ID-203069.user.uni-berlin.de> from Pedro Graca
contained the following:

My question is: how can I transfer the variable "$result" from my PHP
to the .html pages, so that I'm able to print out the info for the
existent user through page3.html. In other words, i would like to
re-use "$result" from the php/mysql query; this, in order to display
information about the successfully logged in user.

Any help or suggestions i will appreciate a lot. Thanks.

Use session variables: http://www.php.net/session

But if the pages need to have a .php extension.
--
Geoff Berrow (put thecat out to email)
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs http://www.ckdog.co.uk/rfdmaker/