Send variable by pressing hyperlink?

[skuliaxe]

Hi, I´m completely stuck on this one.
I have a search that displays the search results like so:

1. Name
__Some short description for that name...

2. Name 2
__Some short description for that name...

3. etc....

or in PHP like so...

PHP: Select all

while ($row= mysql_fetch_array($result)) {
  $name = $row["Name"];
  $description = $row["Description"];

  echo "<p>$count.)&nbsp;<a href=\"http://xxxxxxxxxx/show_name.php (here is my problem)\"> $name </a> \n</p>";
  echo "<p>&nbsp;&nbsp;&nbsp;$description \n</p>";
  $count++ ; 

Now for my problem. The "show_name.php" displays informations from several fields in my database for a given 'ID' row in the database.
Where 'ID' is a integer, auto-increment and primary.

What I would like to do here is that when that LINK is clicked a pop-up window should open "show_name.php" and set the variable $id to the corresponding number where "NAME" is in my database.
So in show_name.php I can have this code:

PHP: Select all

$data = mysql_query("SELECT * FROM TABLE where id ='$id'")
or die(mysql_error()); 

Now the show_name.php knows what "name" it should look up in the database and can display all the correspondingly information.

How is this possible?
I hope this is understandable!

To round it up, "show_name.php" should get information from the search result page what NAME to display information about. Note that there are numerous results as shown in the text above.
This might be an easy one, i've just been looking at this for to long!

[alexgeek]

Can I see your query for the first page please?

[skuliaxe]

Originally Posted by alexgeek

Can I see your query for the first page please?

Here is my query from the Search Results page:

PHP: Select all

$query = "select * from TABLE where COLUMN like \"%$trimmed%\" order by COLUMN";

 $numresults=mysql_query($query);
 $numrows=mysql_num_rows($numresults);

...
...
// Then to display the search results
  while ($row= mysql_fetch_array($result)) {
  $name = $row["Name"];
  $Description = $row["Description"];
  $id = $row["id"];

  echo "<p>$count.)&nbsp;<a href=\"http://xxxx.com/show_name.php"> $name </a> n</p>";
  echo "<p>&nbsp;&nbsp;&nbsp;$Description n</p>";
  $count++ ; 

There I need to pass that $id variable to the next PHP page (show_name.php) via a HYPERLINK. That´s the only thing showing on the Search results page, a hyperlink to show_name.php

This all would be much easier if every entry in the database would have it´s unique page, but that´s a big waste of space and I plan on having huge numbers of entries.

I have also used something like this (to open the "show_name.php" as a pop-up with no menu and fixed size).

PHP: Select all

  while ($row= mysql_fetch_array($result)) {
  $name = $row["Name"];
  $Description = $row["Description"];
  $id = $row["id"];

  echo "<p>$count.)&nbsp;<a href=\"\" onClick='open_win()'> $name </a> \n</p>";
  echo "<p>&nbsp;&nbsp;&nbsp;$Description \n</p>";
  $count++ ; 

And in top of the page is this java function:

HTML: Select all

<script type="text/javascript">
function open_win() 
{
window.open('http://xxxxxxx.com/show_name.php?q=$id','height=900,width=850,toolbar=no,menubar=no,scrollbars=yes,resizable=yes,location=no,directories=no,status=no')
}

There I was hoping to be able to SET the search string as $id. But it seems as that´s not possible. Every time in the Search results that LINK doesn't have the $id but just the Search string that the user entered.

[alexgeek]

Try this:

PHP: Select all

echo "<p>$count.)&nbsp;<a href=\"http://xxxxxxxxxx/show_name.php?id=".$row["id"]."(here is my problem)\"> $name </a> \n</p>"; 

And then in show_name.php:

PHP: Select all

$id = $_GET['id'];
$data = mysql_query("SELECT * FROM TABLE where id ='$id'") 

[skuliaxe]

That did the trick, thank you so much for that

PHP: Select all

echo "<p>$count.)&nbsp;<a href=\"http://xxxxxx.com/show_name.php?id=".$row["id"]."\"> $name </a> \n</p>"; 

Only thing left is to have the Link open in a pop-up window with certain settings.
I would like to have the following setting on a pop-up window:

HTML: Select all

function open_win() 
 {
 window.open('http://xxxxxxx.com/show_name.php?id=".$row["id"]."','Page title','height=900,width=850,toolbar=no,menubar=no,scrollbars=yes,resizable=yes,location=no,directories=no,status=no')
 }

I know that now there is a PHP code in a Jave script. (".$row["id"].) That is just to illustrate what I would like.


In stead of the current link (in first code above) opening the page in the same window, I would like to open it in a pop-up window. Could a java script help here?

PHP: Select all

echo "<p>$count.)&nbsp;<a href=\"\" onClick='open_win()'> $name </a> \n</p>"; 

To call the script from the second code in this post?

[alexgeek]

Replace the echo with:

PHP: Select all

?>
function open_win() 
 {
 window.open('http://xxxxxxx.com/show_name.php?id=<?php echo $row["id"]; ?>','Page title','height=900,width=850,toolbar=no,menubar=no,scrollbars=yes,resizable=yes,location=no,directories=no,status=no')
}
<?php

[skuliaxe]

OK, i did something similar to what you suggested:

PHP: Select all

<?php
while ($row= mysql_fetch_array($result))
  {
      $name = $row["name"];
      $description = $row["Description"];
      $id = $row["id"];

  
      echo "<p>$count.)&nbsp;<a href=\"\" onClick='open_win()'> $name </a> \n</p>";
        ?>  <script type="text/javascript">
            function open_win() 
            {
            window.open('http://xxxxxx.com/show_name.php?id=<?php echo $id; ?>','Page title','height=900,width=850,toolbar=no,menubar=no,scrollbars=yes,resizable=yes,location=no,directories=no,status=no')
            }
            </script><br />
        <?php
      echo "This is id# $id \n"; //For testing purposes
      echo "<p>&nbsp;&nbsp;&nbsp;$Description \n</p>";
      $count++ ;
  }

This helped to fix the LINK. But only when there is ONE search result. When there are multiple search results, the value in $id displays correctly, but the LINK always acts as the value "1" in every link.

Here is what I see from the code above and my search results of the letter "a":

1. Name 1
__This is id# 3
__Description...........

2. Name 2
__This is id# 5
__Description...........

3. Name 3
__This is id# 1
__Description.............

4. etc.

But every link acts like the $id is "1". Even though the id is printed correctly below the name.

When I do a more accurate search like "Name X", and only get ONE result everything works great. No matter if it´s Name 1, 2, 3..... then the link always acts correctly.

Any ideas

[alexgeek]

That would be because you are creating the function in javascript many times, resulting in it being overridden.
try:

PHP: Select all

      echo "<p>$count.)&nbsp;<a href=\"\" onClick='open_win(".$row['id'].")'> $name </a> \n</p>";
        ?>  <script type="text/javascript">
            function open_win(id) 
            {
            window.open('http://xxxxxx.com/show_name.php?id='+id,'Page title','height=900,width=850,toolbar=no,menubar=no,scrollbars=yes,resizable=yes,location=no,directories=no,status=no')
            }
            </script><br /> 

[skuliaxe]

Thanks a million, you can mark this as SOLVED
Notice now that it was always the last $id that was being sent forward due to the overwriting, right?

P.s.: I´m not good in the programing department (beginner). But every time I get help then I most of the time know why something didn't work before. I hope these problems I was having aren't extremely stupid.

I would also like thank you for the extremely fast replies.

[alexgeek]

Btw you can remove this:

HTML: Select all

 <script type="text/javascript">
            function open_win(id) 
            {
            window.open('http://xxxxxx.com/show_name.php?id='+id,'Page title','height=900,width=850,toolbar=no,menubar=no,scrollbars=yes,resizable=yes,location=no,directories=no,status=no')
            }
            </script>

To the <head> of your page, otherwise it's in the loop and gets repeated.


Thread Sovlved has been disabled for now