How to redirect dynamic button based on DB ID onclick and retrieve record associated with same ID

Question

0.00/5 (No votes)

See more:

I have a dynamic button, when clicked (Course Outline), retrieves mysql db record ID and redirects to a page.

I want it to fetch all data associated the clicked ID and display on same page though different course outlines.
which is not working.

What I have tried:

//button_clicked.php:
<?php 
session_start();
?>
<!DOCTYPE html>
<html>
<body>
<?php
include('connect.php');

// Fetch course data from database
$query = "SELECT id, btn_label, title FROM course";
$result = mysqli_query($conn, $query);
// Generate buttons with course IDs as identifiers
while ($row = mysqli_fetch_assoc($result)) {
    $courseID = $row['id'];
    $courseName = $row['btn_label'];
 
    echo "<button class='courseButton' onclick='redirectToCourse($courseID)'>$courseName</button>";

}
mysqli_free_result($result);

?>
<script src="bttn_clicked.js"></script>
</body>
</html>

//button_clicked.js

function redirectToCourse(courseID) {
    window.location.href = "course_display.php?id=" + courseID;
 }

Posted 18-Dec-23 21:00pm

Ojazy Moi

Add a Solution

Comments

Chris Copeland 19-Dec-23 5:03am

Well it seems you've already built the code to redirect to a page with the course ID present, so what's stopping you from building the rest? You have $_GET['id'] containing the course ID.

Ojazy Moi 19-Dec-23 7:40am

How can fetch all DB records associated to this ID and display on the new page?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Andre Oosthuizen · Answer 1 · 2023-12-19T02:30:00

Your best and safest way is to make use of your session that you already declared in your 'button_clicked.php' page -

Quote:
Session variables works by storing user information to be used across multiple pages (e.g. username, course names, etc). By default, session variables last until the user closes the browser or the session is closed.

To set your variables -

PHP

<?php
//Set session variables...
$_SESSION["courseID"] = $courseID;
$_SESSION["courseName"] = $courseName;
?>

To use these values in your new page 'course_display.php' -

PHP

<?php
session_start(); // Always start the page with 'session_start()...

//Echo session variables that were set on your previous page...
echo "User ID is - " . $_SESSION["courseID"] . ".<br>";
echo "Course Name is - " . $_SESSION["courseName"] . ".";
?>

You can use these values on any page for as long as the session is open and valid.

To view all of the variables contained in a session -

PHP

<?php
print_r($_SESSION);
?>

ALWAYS destroy your session when you are done with it -

PHP

<?php
session_start();

//Remove all session variables...
session_unset();

//Destroy the session...
session_destroy();
?>

This is teh basics of session handling, there are much more to it which you will find by searching Google, it will however point yuou in the right direction. Also read more on this -
PHP Sessions [^]