Using A HREF in a while loop to send data from my database to another page

Question

I need to make a movie rater website and on the front page it has the ten most recently added movies. Whenever you click on the movie title its supposed to take you to another page where you can see more info on the movie. I cant seem to get my a href to properly send any of the data to the other page.

code for displaying my homepage

while($row = $result->fetch()){

$MovieName = $row['name'];
$MoviePic = $row['picture'];


echo "<div align=center>";
if($i==1){
    echo '<tr>';
}
$id = $row['MovieId'];
echo '<td><a href = "MovieInfo.php?id = $id"> <img src="data:image/jpeg;base64,'.base64_encode( $MoviePic).'"width = 115 height = 150 name = $MovieName/>';

echo "<br>";
echo $MovieName, '</td>';
echo "</a href>";
echo "<br>";

$i = $i + 1;  
if($i==4){
    echo '</tr>';
    $i=1;
    }
}

code from the second webpage

<?php
require('DBConnect.php');
echo "<div align=center>";
if(isset($_GET['id'])){
    $Name = $_GET['id'];
}
else{
    $Name = 'no';
}
echo $Name;

currently, I'm just testing with the movie's id but no data is being sent to the new page.

Did any of the answers below answers solve your question? If so, please mark the one that you find most helpful as accepted by clicking the check mark icon next to it (you can only accept one answer). If not, you can use the comments to request more information. — Sarah Groß
– Sarah Groß, Commented Nov 13, 2019 at 8:12

Sarah Groß · Accepted Answer · 2019-11-11 14:30:01Z

3

There are several issues with your code:

remove the spaces before and after the equal sign in your URL (you also don't need them in your HTML attribute/value pairs, and while it may not be invalid, it's not common to have those)
PHP variables are not resolved in single quote strings. You need to concatenate the variable into your single quote string like this: '<td><a href = "MovieInfo.php?id=' . $id . '"> <img...' (and the same with name = $MovieName, where you should also add double quotes around the attribute value)
echo "</a href>"; - you cannot have any attributes on a closing HTML tag. </a> is enough to close the opened tag.
You are closing the <td> before the <a>, but the <a> was opened inside the <td>, so you'll have to close it in reverse order as well.

edited Nov 11, 2019 at 14:30

answered Nov 11, 2019 at 14:23

Sarah Groß

10.9k4 gold badges30 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

FunkyMonk91 · Accepted Answer · 2019-11-11 14:24:06Z

0

You will need to do an additional query on the page load for your movie page. Something like SELECT * FROM movies WHERE id = MOVIE_ID. I strongly suggest you use PDO to do your queries with prepared statements to avoid SQL injection.

answered Nov 11, 2019 at 14:24

FunkyMonk91

1,4811 gold badge17 silver badges30 bronze badges

1 Comment

a_dam12 Over a year ago

Thank you for the feedback. I had another SQL query on that page but I have it commented out till I can get everything else to work but thank you for the advice!

Cody Gray · Accepted Answer · 2019-11-12 02:44:10Z

0

Issue is with proper concatenation of id in href. $id is being read as string rather than PHP variable. Replace href with the following line:

href = "MovieInfo.php?id='.$id.'

edited Nov 12, 2019 at 2:44

Cody Gray♦

246k53 gold badges512 silver badges591 bronze badges

answered Nov 11, 2019 at 14:26

webmatrix

1221 silver badge2 bronze badges

Collectives™ on Stack Overflow

Using A HREF in a while loop to send data from my database to another page

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related