Show/hide PHP results in layers

Louie Cypher · Louie Cypher

I am working on a site (not uploaded yet) and have come across the following
glitch. Im using PHP to recall information from a database and display in a
table which is placed in a layer DIV When the page loads the layer is not
visible, when the appropriate button is clicked the layer appears (using
autolayers from Project 7) The records are displyed ok but I have given the
repeat region a maximum number of 5 and Im using <<previous & next>>
buttons. When I use the next button to show the next 5 results the layer
refreshes but it resets to not visible, it appers again (with the next 5
results) if I hit the button again I need the layer to stay visible when I ask
for the next/previous records but to hide when I select another layer. PLEASE
HELP ME Louie

Louie Cypher · Louie Cypher

Can nobody help me? :(

Alexandro Colorado · Alexandro Colorado

On Mon, 7 Mar 2005 09:19:40 +0000 (UTC), Louie Cypher
<webforumsuser@macromedia.com> wrote:

> Can nobody help me? :(

You might need a boolean condition on the layer atribute that will
dynamically set it as a visible or hidden.

--
Alexandro Colorado
------------------------------
Support Engineer
InterAKT Online
[url]http://www.interaktonline.com[/url]
Tel: 40(21) 312.5312

Louie Cypher · Louie Cypher

I have no Idea how to do that?

Any pointers?

louie

Alexandro Colorado · Alexandro Colorado

On Mon, 7 Mar 2005 10:28:40 +0000 (UTC), Louie Cypher
<webforumsuser@macromedia.com> wrote:

> I have no Idea how to do that?
>
> Any pointers?
>
> louie

Show your current code.

--
Alexandro Colorado
------------------------------
Support Engineer
InterAKT Online
[url]http://www.interaktonline.com[/url]
Tel: 40(21) 312.5312

Alexandro Colorado · Alexandro Colorado

Actually can you better explain what you want to do. Is there anything
triggering the layer to show or hide?

On Mon, 7 Mar 2005 10:28:40 +0000 (UTC), Louie Cypher
<webforumsuser@macromedia.com> wrote:

> I have no Idea how to do that?
>
> Any pointers?
>
> louie

--
Alexandro Colorado
------------------------------
Support Engineer
InterAKT Online
[url]http://www.interaktonline.com[/url]
Tel: 40(21) 312.5312

Louie Cypher · Louie Cypher

Yes, a text menu ( about 6 topics, each with its own layer) When I click on
the first link I want layer 1, containing results, to appear. Layer 1 will
show the php generated results in chunks of 5 at a time. but when I ask for the
next 5 results this layer defaults to NOT VISIBLE and only appears if I click
on the first link again? I have attached code from a test I am trying to get
working before takling the main page:

<?php require_once('Connections/cd_conn.php'); ?>
<?php
$currentPage = $_SERVER["PHP_SELF"];

$maxRows_rs_cd = 5;
$pageNum_rs_cd = 0;
if (isset($_GET['pageNum_rs_cd'])) {
$pageNum_rs_cd = $_GET['pageNum_rs_cd'];
}
$startRow_rs_cd = $pageNum_rs_cd * $maxRows_rs_cd;

mysql_select_db($database_cd_conn, $cd_conn);
$query_rs_cd = "SELECT artist.artist_key, artist.artist_name, cd.cd_key,
cd.cd_name FROM cd, artist WHERE cd.cd_artist = artist.artist_key ORDER BY
artist.artist_name, cd.cd_name";
$query_limit_rs_cd = sprintf("%s LIMIT %d, %d", $query_rs_cd, $startRow_rs_cd,
$maxRows_rs_cd);
$rs_cd = mysql_query($query_limit_rs_cd, $cd_conn) or die(mysql_error());
$row_rs_cd = mysql_fetch_assoc($rs_cd);

if (isset($_GET['totalRows_rs_cd'])) {
$totalRows_rs_cd = $_GET['totalRows_rs_cd'];
} else {
$all_rs_cd = mysql_query($query_rs_cd);
$totalRows_rs_cd = mysql_num_rows($all_rs_cd);
}
$totalPages_rs_cd = ceil($totalRows_rs_cd/$maxRows_rs_cd)-1;

$queryString_rs_cd = "";
if (!empty($_SERVER['QUERY_STRING'])) {
$params = explode("&", $_SERVER['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_rs_cd") == false &&
stristr($param, "totalRows_rs_cd") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_rs_cd = "&" . htmlentities(implode("&", $newParams));
}
}
$queryString_rs_cd = sprintf("&totalRows_rs_cd=%d%s", $totalRows_rs_cd,
$queryString_rs_cd);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Untitled Document</title>
<script language="JavaScript" type="text/JavaScript">

</script>
</head>

<body>
<div id="results" style="position:absolute; left:204px; top:68px; width:357px;
height:274px; z-index:1; visibility: hidden;">
<table width="400" border="0" cellspacing="4" cellpadding="4">
<tr>
<td><strong>Artist</strong></td>
<td><strong>Title</strong></td>
</tr>
<?php do { ?>
<tr>
<td><?php echo $row_rs_cd['artist_name']; ?></td>
<td><?php echo $row_rs_cd['cd_name']; ?></td>
</tr>
<?php } while ($row_rs_cd = mysql_fetch_assoc($rs_cd)); ?>
<tr>
<td><?php if ($pageNum_rs_cd > 0) { // Show if not first page ?>
<a href="<?php printf("%s?pageNum_rs_cd=%d%s", $currentPage, max(0,
$pageNum_rs_cd - 1), $queryString_rs_cd); ?>"><< Previous</a>
<?php } // Show if not first page ?>
</td>
<td><div align="right">
<?php if ($pageNum_rs_cd < $totalPages_rs_cd) { // Show if not last
page ?>
<a href="<?php printf("%s?pageNum_rs_cd=%d%s", $currentPage,
min($totalPages_rs_cd, $pageNum_rs_cd + 1), $queryString_rs_cd); ?>">Next
>></a>
<?php } // Show if not last page ?>
</div></td>
</tr>
</table>
</div>
<p><a href="#" onClick="P7_autoLayers(0,'results')">show</a></p>
</body>
</html>
<?php
mysql_free_result($rs_cd);
?>

Alexandro Colorado · Alexandro Colorado

I think you need javascript for the OnClick behavior to happen, this is a
good tutorial for this:
[url]http://www.chunkysoup.net/basic/js3step/js_3step.4.html[/url]

On Mon, 7 Mar 2005 11:54:06 +0000 (UTC), Louie Cypher
<webforumsuser@macromedia.com> wrote:

> Yes, a text menu ( about 6 topics, each with its own layer) When I
> click on
> the first link I want layer 1, containing results, to appear. Layer 1
> will
> show the php generated results in chunks of 5 at a time. but when I ask
> for the
> next 5 results this layer defaults to NOT VISIBLE and only appears if I
> click
> on the first link again? I have attached code from a test I am trying
> to get
> working before takling the main page:
>
> <?php require_once('Connections/cd_conn.php'); ?>
> <?php
> $currentPage = $_SERVER["PHP_SELF"];
>
> $maxRows_rs_cd = 5;
> $pageNum_rs_cd = 0;
> if (isset($_GET['pageNum_rs_cd'])) {
> $pageNum_rs_cd = $_GET['pageNum_rs_cd'];
> }
> $startRow_rs_cd = $pageNum_rs_cd * $maxRows_rs_cd;
>
> mysql_select_db($database_cd_conn, $cd_conn);
> $query_rs_cd = "SELECT artist.artist_key, artist.artist_name, cd.cd_key,
> cd.cd_name FROM cd, artist WHERE cd.cd_artist = artist.artist_key ORDER
> BY
> artist.artist_name, cd.cd_name";
> $query_limit_rs_cd = sprintf("%s LIMIT %d, %d", $query_rs_cd,
> $startRow_rs_cd,
> $maxRows_rs_cd);
> $rs_cd = mysql_query($query_limit_rs_cd, $cd_conn) or
> die(mysql_error());
> $row_rs_cd = mysql_fetch_assoc($rs_cd);
>
> if (isset($_GET['totalRows_rs_cd'])) {
> $totalRows_rs_cd = $_GET['totalRows_rs_cd'];
> } else {
> $all_rs_cd = mysql_query($query_rs_cd);
> $totalRows_rs_cd = mysql_num_rows($all_rs_cd);
> }
> $totalPages_rs_cd = ceil($totalRows_rs_cd/$maxRows_rs_cd)-1;
>
> $queryString_rs_cd = "";
> if (!empty($_SERVER['QUERY_STRING'])) {
> $params = explode("&", $_SERVER['QUERY_STRING']);
> $newParams = array();
> foreach ($params as $param) {
> if (stristr($param, "pageNum_rs_cd") == false &&
> stristr($param, "totalRows_rs_cd") == false) {
> array_push($newParams, $param);
> }
> }
> if (count($newParams) != 0) {
> $queryString_rs_cd = "&" . htmlentities(implode("&", $newParams));
> }
> }
> $queryString_rs_cd = sprintf("&totalRows_rs_cd=%d%s", $totalRows_rs_cd,
> $queryString_rs_cd);
> ?>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
> "http://www.w3.org/TR/html4/loose.dtd">
> <html>
> <head>
> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
> <title>Untitled Document</title>
> <script language="JavaScript" type="text/JavaScript">
> 
> </script>
> </head>
>
> <body>
> <div id="results" style="position:absolute; left:204px; top:68px;
> width:357px;
> height:274px; z-index:1; visibility: hidden;">
> <table width="400" border="0" cellspacing="4" cellpadding="4">
> <tr>
> <td><strong>Artist</strong></td>
> <td><strong>Title</strong></td>
> </tr>
> <?php do { ?>
> <tr>
> <td><?php echo $row_rs_cd['artist_name']; ?></td>
> <td><?php echo $row_rs_cd['cd_name']; ?></td>
> </tr>
> <?php } while ($row_rs_cd = mysql_fetch_assoc($rs_cd)); ?>
> <tr>
> <td><?php if ($pageNum_rs_cd > 0) { // Show if not first page ?>
> <a href="<?php printf("%s?pageNum_rs_cd=%d%s", $currentPage,
> max(0,
> $pageNum_rs_cd - 1), $queryString_rs_cd); ?>"><< Previous</a>
> <?php } // Show if not first page ?>
> </td>
> <td><div align="right">
> <?php if ($pageNum_rs_cd < $totalPages_rs_cd) { // Show if
> not last
> page ?>
> <a href="<?php printf("%s?pageNum_rs_cd=%d%s", $currentPage,
> min($totalPages_rs_cd, $pageNum_rs_cd + 1), $queryString_rs_cd); ?>">Next
> >></a>
> <?php } // Show if not last page ?>
> </div></td>
> </tr>
> </table>
> </div>
> <p><a href="#" onClick="P7_autoLayers(0,'results')">show</a></p>
> </body>
> </html>
> <?php
> mysql_free_result($rs_cd);
> ?>
>

--
Alexandro Colorado
------------------------------
Support Engineer
InterAKT Online
[url]http://www.interaktonline.com[/url]
Tel: 40(21) 312.5312

Murray *TMM* · Murray *TMM*

I must admit, I am a bit stumped by the question, but I really don't see how
this generic tutorial is going to do anything for the poster, Alexandro.
Can you say more about what this would do?

--
Murray --- ICQ 71997575
Team Macromedia Volunteer for Dreamweaver
(If you *MUST* email me, don't LAUGH when you do so!)
==================
[url]http://www.dreamweavermx-templates.com[/url] - Template Triage!
[url]http://www.projectseven.com/go[/url] - DW FAQs, Tutorials & Resources
[url]http://www.dwfaq.com[/url] - DW FAQs, Tutorials & Resources
[url]http://www.macromedia.com/support/search/[/url] - Macromedia (MM) Technotes
==================

"Alexandro Colorado" <acolorado@interaktonline.com> wrote in message
news:opsm9qowjtrohbc4@acolorado...

>I think you need javascript for the OnClick behavior to happen, this is a
>good tutorial for this:
> [url]http://www.chunkysoup.net/basic/js3step/js_3step.4.html[/url]
>
> On Mon, 7 Mar 2005 11:54:06 +0000 (UTC), Louie Cypher
> <webforumsuser@macromedia.com> wrote:
>

>> Yes, a text menu ( about 6 topics, each with its own layer) When I
>> click on
>> the first link I want layer 1, containing results, to appear. Layer 1
>> will
>> show the php generated results in chunks of 5 at a time. but when I ask
>> for the
>> next 5 results this layer defaults to NOT VISIBLE and only appears if I
>> click
>> on the first link again? I have attached code from a test I am trying
>> to get
>> working before takling the main page:
>>
>> <?php require_once('Connections/cd_conn.php'); ?>
>> <?php
>> $currentPage = $_SERVER["PHP_SELF"];
>>
>> $maxRows_rs_cd = 5;
>> $pageNum_rs_cd = 0;
>> if (isset($_GET['pageNum_rs_cd'])) {
>> $pageNum_rs_cd = $_GET['pageNum_rs_cd'];
>> }
>> $startRow_rs_cd = $pageNum_rs_cd * $maxRows_rs_cd;
>>
>> mysql_select_db($database_cd_conn, $cd_conn);
>> $query_rs_cd = "SELECT artist.artist_key, artist.artist_name, cd.cd_key,
>> cd.cd_name FROM cd, artist WHERE cd.cd_artist = artist.artist_key ORDER
>> BY
>> artist.artist_name, cd.cd_name";
>> $query_limit_rs_cd = sprintf("%s LIMIT %d, %d", $query_rs_cd,
>> $startRow_rs_cd,
>> $maxRows_rs_cd);
>> $rs_cd = mysql_query($query_limit_rs_cd, $cd_conn) or
>> die(mysql_error());
>> $row_rs_cd = mysql_fetch_assoc($rs_cd);
>>
>> if (isset($_GET['totalRows_rs_cd'])) {
>> $totalRows_rs_cd = $_GET['totalRows_rs_cd'];
>> } else {
>> $all_rs_cd = mysql_query($query_rs_cd);
>> $totalRows_rs_cd = mysql_num_rows($all_rs_cd);
>> }
>> $totalPages_rs_cd = ceil($totalRows_rs_cd/$maxRows_rs_cd)-1;
>>
>> $queryString_rs_cd = "";
>> if (!empty($_SERVER['QUERY_STRING'])) {
>> $params = explode("&", $_SERVER['QUERY_STRING']);
>> $newParams = array();
>> foreach ($params as $param) {
>> if (stristr($param, "pageNum_rs_cd") == false &&
>> stristr($param, "totalRows_rs_cd") == false) {
>> array_push($newParams, $param);
>> }
>> }
>> if (count($newParams) != 0) {
>> $queryString_rs_cd = "&" . htmlentities(implode("&", $newParams));
>> }
>> }
>> $queryString_rs_cd = sprintf("&totalRows_rs_cd=%d%s", $totalRows_rs_cd,
>> $queryString_rs_cd);
>> ?>
>> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
>> "http://www.w3.org/TR/html4/loose.dtd">
>> <html>
>> <head>
>> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
>> <title>Untitled Document</title>
>> <script language="JavaScript" type="text/JavaScript">
>> 
>> </script>
>> </head>
>>
>> <body>
>> <div id="results" style="position:absolute; left:204px; top:68px;
>> width:357px;
>> height:274px; z-index:1; visibility: hidden;">
>> <table width="400" border="0" cellspacing="4" cellpadding="4">
>> <tr>
>> <td><strong>Artist</strong></td>
>> <td><strong>Title</strong></td>
>> </tr>
>> <?php do { ?>
>> <tr>
>> <td><?php echo $row_rs_cd['artist_name']; ?></td>
>> <td><?php echo $row_rs_cd['cd_name']; ?></td>
>> </tr>
>> <?php } while ($row_rs_cd = mysql_fetch_assoc($rs_cd)); ?>
>> <tr>
>> <td><?php if ($pageNum_rs_cd > 0) { // Show if not first page ?>
>> <a href="<?php printf("%s?pageNum_rs_cd=%d%s", $currentPage,
>> max(0,
>> $pageNum_rs_cd - 1), $queryString_rs_cd); ?>"><< Previous</a>
>> <?php } // Show if not first page ?>
>> </td>
>> <td><div align="right">
>> <?php if ($pageNum_rs_cd < $totalPages_rs_cd) { // Show if
>> not last
>> page ?>
>> <a href="<?php printf("%s?pageNum_rs_cd=%d%s", $currentPage,
>> min($totalPages_rs_cd, $pageNum_rs_cd + 1), $queryString_rs_cd); ?>">Next
>> >></a>
>> <?php } // Show if not last page ?>
>> </div></td>
>> </tr>
>> </table>
>> </div>
>> <p><a href="#" onClick="P7_autoLayers(0,'results')">show</a></p>
>> </body>
>> </html>
>> <?php
>> mysql_free_result($rs_cd);
>> ?>
>>

>
>
>
> --
> Alexandro Colorado
> ------------------------------
> Support Engineer
> InterAKT Online
> [url]http://www.interaktonline.com[/url]
> Tel: 40(21) 312.5312

Louie Cypher · Louie Cypher

'I must admit, I am a bit stumped by the question,' Let me try to explain the
situation. When the page loads I have a menu showing several topics on the
left. each of these menu topics is a link for a hidden layer (one layer for
each topic ) When topic 1 is clicked layer 1 appears. Layer 1 contains a
table with my php data inserted. The first 5 (of 20) results are shown and
underneath these, still on layer 1, is a 'next' button (used to obtain the
next 5 results). when i hit the 'next' button layer 1 vanishes and to make it
appear again i have to use the original topic link from the menu (this has the
show\hide behaviour attached). When the layer reappears it does contain the
next five results. I would like the layer to remain visible when i use either
the 'next' or 'previous' buttons so people can have uninterupted access to my
live data. Any ideas? Louie

Murray *TMM* · Murray *TMM*

I understand the context of the question. I don't understand Alexandro's
link.

Obviously, your page is refreshing when the new data is loaded. This is
causing the layer to revert to its loaded state, i.e., hidden. Given this
complexity, the only way I can think of to get around it would be to either
use cookies, or a session variable for client-side, or server-side control
of the visibility of the layer. Neither of these would involve manually
re-creating the client-side javascript for show/hide layer as far as I can
see.

Must you do it with a hidden layer? Why not in a pop-up?

--
Murray --- ICQ 71997575
Team Macromedia Volunteer for Dreamweaver
(If you *MUST* email me, don't LAUGH when you do so!)
==================
[url]http://www.dreamweavermx-templates.com[/url] - Template Triage!
[url]http://www.projectseven.com/go[/url] - DW FAQs, Tutorials & Resources
[url]http://www.dwfaq.com[/url] - DW FAQs, Tutorials & Resources
[url]http://www.macromedia.com/support/search/[/url] - Macromedia (MM) Technotes
==================

"Louie Cypher" <webforumsuser@macromedia.com> wrote in message
news:d0hobu$59b$1@forums.macromedia.com...

> 'I must admit, I am a bit stumped by the question,' Let me try to explain
> the
> situation. When the page loads I have a menu showing several topics on
> the
> left. each of these menu topics is a link for a hidden layer (one layer
> for
> each topic ) When topic 1 is clicked layer 1 appears. Layer 1 contains a
> table with my php data inserted. The first 5 (of 20) results are shown and
> underneath these, still on layer 1, is a 'next' button (used to obtain
> the
> next 5 results). when i hit the 'next' button layer 1 vanishes and to
> make it
> appear again i have to use the original topic link from the menu (this has
> the
> show\hide behaviour attached). When the layer reappears it does contain
> the
> next five results. I would like the layer to remain visible when i use
> either
> the 'next' or 'previous' buttons so people can have uninterupted access to
> my
> live data. Any ideas? Louie
>

Louie Cypher · Louie Cypher

Well a hidden layer is in keeping with the rest of the site, but as this is the
only section of the site that uses dynamic data I may have to look for another
way around it. Thank you for advice and answers to my problem. Regards Louie

Murray *TMM* · Murray *TMM*

Sorry I couldn't be more help.

--
Murray --- ICQ 71997575
Team Macromedia Volunteer for Dreamweaver
(If you *MUST* email me, don't LAUGH when you do so!)
==================
[url]http://www.dreamweavermx-templates.com[/url] - Template Triage!
[url]http://www.projectseven.com/go[/url] - DW FAQs, Tutorials & Resources
[url]http://www.dwfaq.com[/url] - DW FAQs, Tutorials & Resources
[url]http://www.macromedia.com/support/search/[/url] - Macromedia (MM) Technotes
==================

"Louie Cypher" <webforumsuser@macromedia.com> wrote in message
news:d0hste$dgl$1@forums.macromedia.com...

> Well a hidden layer is in keeping with the rest of the site, but as this
> is the
> only section of the site that uses dynamic data I may have to look for
> another
> way around it. Thank you for advice and answers to my problem. Regards
> Louie
>

Show/hide PHP results in layers

Thread Tools

Display

Show/hide PHP results in layers

Similar Questions and Discussions

Show and Hide Layers

popup menus won't hide - PVII show/hide layers behaviour

Can't Show/Hide Layers in Firefox

show/hide layers

Hide/show layers

Re: Show/hide PHP results in layers

Re: Show/hide PHP results in layers

Re: Show/hide PHP results in layers

Re: Show/hide PHP results in layers

Re: Show/hide PHP results in layers

Re: Show/hide PHP results in layers

Re: Show/hide PHP results in layers

Re: Show/hide PHP results in layers

Re: Show/hide PHP results in layers

Re: Show/hide PHP results in layers

Re: Show/hide PHP results in layers

Re: Show/hide PHP results in layers

Posting Permissions