DaniWeb Forum Index > Web Development > PHP

make link from a variable.

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: Jun 2009

Posts: 68

Reputation: djjjozsi is an unknown quantity at this point

Solved Threads: 10

djjjozsi

Offline

Junior Poster in Training

Re: make link from a variable.

#11

Jun 10th, 2009

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
echo "<tr>
<td><a href='details.php?lessonID=$lessonID'>Details</a></td>
<td>$subject</td>
<td>$learningArea</td>
<td>$noofstudents</td>
<td>$minutes</td>
<td>$class</td>
<td> $ability</td>
</tr>" ;
echo "<tr>
<td><a href='details.php?lessonID=$lessonID'>Details</a></td>
<td>$subject</td>
<td>$learningArea</td>
<td>$noofstudents</td>
<td>$minutes</td>
<td>$class</td>
<td> $ability</td>
</tr>" ;

•

Join Date: Jun 2009

Posts: 68

Reputation: djjjozsi is an unknown quantity at this point

Solved Threads: 10

djjjozsi

Offline

Junior Poster in Training

Re: make link from a variable.

#12

Jun 10th, 2009

this is a typo error in your SQL query then

•

Originally Posted by navi17

..........
it should be:
Help with Code Tags

PHP Syntax (Toggle Plain Text)
$myquery = "select * from lesson where subject like '%'.$q.'%' AND learningArea like '%'.$r.'%' AND ability like '%'.$s.'%'";
$myquery = "select * from lesson where subject like '%'.$q.'%' AND learningArea like '%'.$r.'%' AND ability like '%'.$s.'%'";
........

and,
the SQL save version is this:

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
$q = isset($_GET['q'])? mysql_real_escape_string($_GET['q']):'';
$r = isset($_GET['r'])? mysql_real_escape_string($_GET['r']):'';
$s = isset($_GET['s'])? mysql_real_escape_string($_GET['s']):'';
 
// Build SQL Query
$myquery = "select * from lesson where subject like '%{$q}%' AND learningArea like '%{$r}%'
 AND ability like '%{$s}%'";
$q = isset($_GET['q'])? mysql_real_escape_string($_GET['q']):'';
$r = isset($_GET['r'])? mysql_real_escape_string($_GET['r']):'';
$s = isset($_GET['s'])? mysql_real_escape_string($_GET['s']):'';

// Build SQL Query
$myquery = "select * from lesson where subject like '%{$q}%' AND learningArea like '%{$r}%'
 AND ability like '%{$s}%'";

•

Join Date: Oct 2007

Posts: 78

Reputation: navi17 is an unknown quantity at this point

Solved Threads: 5

navi17

Offline

Junior Poster in Training

Re: make link from a variable.

#13

Jun 10th, 2009

try this:

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
while ($row= mysql_fetch_array($result))
{
$lessonID = $row["lessonID"];
$subject = $row["subject"];
$learningArea= $row["learningArea"];
$noofstudent= $row["noofstudents"];
$minutes= $row["minutes"];
$class= $row["class"];
$ability= $row["ability"];
 
?>
//display the row
 
<tr>
<td><a href="details.php?lessonID=<?php echo $lessonID; ?>"> Details</a></td>
<td><?php echo $subject; ?></td>
<td><?php echo $learningArea; ?></td>
<td><?php echo $noofstudents; ?></td>
<td><?php echo $minutes; ?></td>
<td><?php echo $class; ?></td>
<td><?php echo $ability; ?> </td>
</tr>
<?php  } ?>
</table>
while ($row= mysql_fetch_array($result))
{
$lessonID = $row["lessonID"];
$subject = $row["subject"];
$learningArea= $row["learningArea"];
$noofstudent= $row["noofstudents"];
$minutes= $row["minutes"];
$class= $row["class"];
$ability= $row["ability"];

?>
//display the row

<tr>
<td><a href="details.php?lessonID=<?php echo $lessonID; ?>"> Details</a></td>
<td><?php echo $subject; ?></td>
<td><?php echo $learningArea; ?></td>
<td><?php echo $noofstudents; ?></td>
<td><?php echo $minutes; ?></td>
<td><?php echo $class; ?></td>
<td><?php echo $ability; ?> </td>
</tr>
<?php  } ?>
</table>

i am sure it works.

Last edited by navi17; Jun 10th, 2009 at 9:18 am.

•

Join Date: Jun 2009

Posts: 68

Reputation: djjjozsi is an unknown quantity at this point

Solved Threads: 10

djjjozsi

Offline

Junior Poster in Training

Re: make link from a variable.

#14

Jun 10th, 2009

but its not printing the data from the database... you will see $minutes and other stuffs in the output...
.....
the shortest is the better...

Last edited by djjjozsi; Jun 10th, 2009 at 9:24 am.

•

Join Date: Oct 2007

Posts: 78

Reputation: navi17 is an unknown quantity at this point

Solved Threads: 5

navi17

Offline

Junior Poster in Training

Re: make link from a variable.

#15

Jun 10th, 2009

it will print the data from the database.
i am sure.

•

Join Date: Jun 2009

Posts: 68

Reputation: djjjozsi is an unknown quantity at this point

Solved Threads: 10

djjjozsi

Offline

Junior Poster in Training

Re: make link from a variable.

#16

Jun 10th, 2009

•

Originally Posted by navi17

it will print the data from the database.
i am sure.

i've seen your first version, and in that post i did not see the <?php echo $field... ; ?>
which needed to print the values.

if i saw it wrong then sorry about it.

Last edited by djjjozsi; Jun 10th, 2009 at 9:36 am.

•

Join Date: May 2009

Posts: 81

Reputation: tulipputih is an unknown quantity at this point

Solved Threads: 0

tulipputih tulipputih is offline

Offline

Junior Poster in Training

Re: make link from a variable.

#17

Jun 10th, 2009

I have tried that as well..
please anyone who can identify the error...

thanks.

•

Join Date: May 2009

Posts: 81

Reputation: tulipputih is an unknown quantity at this point

Solved Threads: 0

tulipputih tulipputih is offline

Offline

Junior Poster in Training

Re: make link from a variable.

#18

Jun 10th, 2009

•

Originally Posted by navi17

try this:
Help with Code Tags

PHP Syntax (Toggle Plain Text)
while ($row= mysql_fetch_array($result))
{
$lessonID = $row["lessonID"];
$subject = $row["subject"];
$learningArea= $row["learningArea"];
$noofstudent= $row["noofstudents"];
$minutes= $row["minutes"];
$class= $row["class"];
$ability= $row["ability"];
 
?>
//display the row
 
<tr>
<td><a href="details.php?lessonID=<?php echo $lessonID; ?>"> Details</a></td>
<td><?php echo $subject; ?></td>
<td><?php echo $learningArea; ?></td>
<td><?php echo $noofstudents; ?></td>
<td><?php echo $minutes; ?></td>
<td><?php echo $class; ?></td>
<td><?php echo $ability; ?> </td>
</tr>
<?php  } ?>
</table>
while ($row= mysql_fetch_array($result)) { $lessonID = $row["lessonID"]; $subject = $row["subject"]; $learningArea= $row["learningArea"]; $noofstudent= $row["noofstudents"]; $minutes= $row["minutes"]; $class= $row["class"]; $ability= $row["ability"]; ?> //display the row <tr> <td><a href="details.php?lessonID=<?php echo $lessonID; ?>"> Details</a></td> <td><?php echo $subject; ?></td> <td><?php echo $learningArea; ?></td> <td><?php echo $noofstudents; ?></td> <td><?php echo $minutes; ?></td> <td><?php echo $class; ?></td> <td><?php echo $ability; ?> </td> </tr> <?php } ?> </table>
i am sure it works.

Hi Navi17.
thanks a lot..can be linked to details page.
however, the Id number is not shown in the result..
all show the same string..details..but the lesson Id that sent to details page is correct (the lessonID)
just the Id is not displayed in the table.
any idea to correct it?

thanks

•

Join Date: May 2009

Posts: 81

Reputation: tulipputih is an unknown quantity at this point

Solved Threads: 0

tulipputih tulipputih is offline

Offline

Junior Poster in Training

Re: make link from a variable.

#19

Jun 10th, 2009

•

Originally Posted by djjjozsi

i've seen your first version, and in that post i did not see the <?php echo $field... ; ?>
which needed to print the values.

if i saw it wrong then sorry about it.

djjjozsi, it does work for me..I mean the link.
the code that I posted before also print data from the database..
The problem is to make a link to the details page.
now, Navi17 has solved that problem..however the ID is not printed here..but the value is passed to the details page... I need both..the lessonID printed & the value passed.
ANy solution. Mny thanks for your respond