PHP MYSQL - $_GET and Query Issue

Question

I have a page which contains a table. The 'change_id' field contains hyperlinks which direct the user to a different page with an overview of that change_id's details.

'<td><a href="home2.php?changeid=' . $row['change_id'] . '">' . $row['change_id'] . '</a></td>';

Now, just to test that the change_id is being received on the home2.php page, I used the following code:

<?php 
include 'config.php';
$change_id=$_GET['change_id'];
print_r($_GET);
?>

This test successfully displayed the correct change id's:

Array ( [changeid] => 1006 )

Now, when I go to query the SQL Database using the change_id it doesn't work as desired.

<?php 
include 'config.php';
$change_id=$_GET['change_id'];
$query1 = "SELECT * FROM `change_request_tbl` WHERE `change_id` = $change_id";
$result = mysqli_query($conn, $query1);

echo  "<fieldset><legend><strong>New Requests:</legend></strong>
<table border=4 bordercolor=black class=table>
<tr>
<th>Change ID:</th>
<th>Customer Name:</th>
<th>Change Requestor:</th>
<th>Date CR raised:</th>
<th>CPM/Ticket:</th>
<th>Out of Hours:</th>
<th>Change Category:</th>
</tr>";
while ($row = mysqli_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['change_id'] . "</td>";
echo "<td>" . $row['customer_name'] . "</td>";
echo "<td>" . $row['change_requestor'] . "</td>";
echo "<td>" . $row['date_cr_raised'] . "</td>";
echo "<td>" . $row['cpm_ticket'] . "</td>";
echo "<td>" . $row['out_of_hours'] . "</td>";
echo "<td>" . $row['category_of_change'] . "</td>";
echo "</tr>";
}  
echo "</table></fieldset><br><br><br>";
?>

The table are headers are shown without any data. Any ideas on how to fix? Thanks in advance

Is your change_id an int in the table?

gaganshera
– gaganshera

2017-04-20 10:31:50 +00:00
Commented Apr 20, 2017 at 10:31 — gaganshera
– gaganshera, Commented Apr 20, 2017 at 10:31
Auto Incremented INT

user7689729
– user7689729

2017-04-20 10:39:31 +00:00
Commented Apr 20, 2017 at 10:39 — user7689729
– user7689729, Commented Apr 20, 2017 at 10:39

RobFos · Accepted Answer · 2017-04-20 10:47:44Z

1

You are setting $change_id to $_GET['change_id']

However you are passing $_GET the parameter name of changeid

If you change

$change_id = $_GET['change_id'];

To

$change_id = $_GET['changeid'];

It should work as expected :)

edited Apr 20, 2017 at 10:47

answered Apr 20, 2017 at 10:31

RobFos

9716 silver badges24 bronze badges

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

2 Comments

user7689729 Over a year ago

its working now without the '_'. Why is this the case?

RobFos Over a year ago

Because as far as PHP is concerned they are two different variables/parameters. Make sure you keep an eye on the CaSe and any symbols you use in PHP :)

Collectives™ on Stack Overflow

PHP MYSQL - $_GET and Query Issue

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related