By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,846 Members | 1,211 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,846 IT Pros & Developers. It's quick & easy.

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

P: n/a
Hi,

I'm a newbie in php/mysql programming,really 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($url)
{ // This calls javascript
$redir = "<script language=\"javascript\">location.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($query) or die
(RedirectURL('http://xxx.xxx.xxx.xxx:XXXX/ / /page2.html'));
$numentries = mysql_numrows($result); //Numero de filas
returned. mysql_close($link);

$correct_username = $loginID;
$correct_password = mysql_result($result,0,"password"); //assumming
there is only one match...
if (strcasecmp($correct_username,$loginID) ||
strcasecmp($correct_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
Jul 17 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
da******@hotmail.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*****@agricoreunited.com>
comp.lang.javascript FAQ - http://jibbering.com/faq

Jul 17 '05 #2

P: n/a
["Followup-To:" header set to comp.lang.php.]
da******@hotmail.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. |
Jul 17 '05 #3

P: n/a
.oO(da******@hotmail.com)
function RedirectURL($url)
{ // This calls javascript
$redir = "<script language=\"javascript\">location.href=\"$url\"</script>\n";
return $redir;
}


header("Location: $url");

http://www.php.net/header

Micha
Jul 17 '05 #4

P: n/a
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/
Jul 17 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.