PHP: passing parameters in the URL dynamically

Question

I want to display data in database in table form. I wrote the following code

while($row = mysql_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['EmpID'] . "</td>";
echo "<td>" . $row['EmpName'] . "</td>";
echo "<td>" . $row['Designation'] . "</td>";
echo "<td>" . $row['Salary'] . "</td>";
echo "<td><a href='upasg3.php?empid='". $row['EmpID'] .">Edit</a ></td>";
echo "<td><a href='upasg3.php?empid='". $row['EmpID'] .">Delete</a ></td>"; 
echo "</tr>";
}

But i dont get the value of $row['EmpID'] concatenated with the value of href. It redirects to the upasg3.php with empid= blank. how to fix this? Please help

Is this line blank as well: echo "<td>" . $row['EmpID'] . "</td>"; ? — Jeroen
– Jeroen, Commented May 17, 2012 at 9:51

ShaaD · Accepted Answer · 2012-05-17 09:54:16Z

4

while($row = mysql_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['EmpID'] . "</td>";
echo "<td>" . $row['EmpName'] . "</td>";
echo "<td>" . $row['Designation'] . "</td>";
echo "<td>" . $row['Salary'] . "</td>";
echo "<td><a href='upasg3.php?empid=". $row['EmpID'] ."'>Edit</a ></td>";
echo "<td><a href='upasg3.php?empid=". $row['EmpID'] ."'>Delete</a ></td>"; 
echo "</tr>";
}

quotes.

answered May 17, 2012 at 9:54

ShaaD

6263 silver badges10 bronze badges

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

Comments

IsisCode · Accepted Answer · 2012-05-17 09:53:50Z

2

Try removing the single quotes after empid=

And putting them here like this:

echo "<td><a href='upasg3.php?empid=". $row['EmpID'] ."'>Edit</a ></td>";
echo "<td><a href='upasg3.php?empid=". $row['EmpID'] ."'>Delete</a ></td>";

This will give you an output like:

<a href='upasg3.php?empid=100'>

answered May 17, 2012 at 9:53

IsisCode

2,49018 silver badges20 bronze badges

Comments

heyanshukla · Accepted Answer · 2012-05-17 09:56:27Z

1

Try

echo "<td><a href='upasg3.php?empid=". $row['EmpID']."'>Edit</a ></td>";
                                    ^                 ^

answered May 17, 2012 at 9:56

heyanshukla

6698 silver badges17 bronze badges

Comments

Sandy Fark · Accepted Answer · 2012-05-17 10:01:08Z

1

 <table width="100%" border="1">
  <tr>
 <td>ID</td>
<td>NAME</td>
<td>Designation</td>
<td>Salary</td>
<td>Edit</td>
  <td>Delete</td>
</tr>
<tr>
  <td><?=$row['EmpID']?></td>
<td><?=$row['EmpName']?></td>
<td><?=$row['Designation']?></td>
<td><?=$row['Salary']?></td>
<td><a href="upasg3.php?empid=<?=$row['EmpID']?>">Edit</a></td>
 <td><a href="upasg3.php?empid=<?=$row['EmpID']?>">Delete</a></td>
 </tr>

answered May 17, 2012 at 10:01

Sandy Fark

1735 silver badges14 bronze badges

Comments

itachi · Accepted Answer · 2012-05-17 09:59:55Z

-1

try this

echo "<td><a href='upasg3.php?empid=". $row['EmpID'] ."'>Edit</a ></td>";
echo "<td><a href='upasg3.php?empid=". $row['EmpID'] ."'>Delete</a ></td>";

Your quotes were in wrong place.

answered May 17, 2012 at 9:59

itachi

6,3933 gold badges33 silver badges41 bronze badges

Collectives™ on Stack Overflow

PHP: passing parameters in the URL dynamically

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Related