Convert data from DB to hyperlink

boldorus

I grab id, perso, perso_url from a database. But I need to convert the perso_url information in a hyperlink on the web page.
I use html template to adjust the HTML page.

Here is the profil.php page and after I am showing a portion of the html pages. Is there a way to convert my perso_url data into an URL, so it become clickable 🙂

<?php

include "template.inc";

$db = mysql_connect('HOST','USER','PASS');

mysql_select_db('DATABASE',$db);

$sql = 'SELECT id,perso,perso_url FROM flq_tbl';

$req = mysql_query($sql) or die('Erreur SQL ! '.$sql.' '.mysql_error());

//3

$tpl = new template("gabarits");

$tpl->set_file("gliste","profil1.html");

//4

$tpl->set_block('gliste','liste_clients','liste_bloc');

//5

while($data = mysql_fetch_array($req)) {

//6

$tpl->set_var("id", $data['id']);

$tpl->set_var("perso", $data['perso']);

$tpl->set_var("perso_url", $data['perso_url']);

//7

$tpl->parse('liste_bloc','liste_clients',true);

}

//8

mysql_close();

//9

$tpl->pparse("affichage","gliste");

?>

Codes form the HTML page ( template )
<tr>

<td width="51">Numero</td>

<td width="153">Perso</td>

<td width="354">page perso</td>
</tr>

<tr>

<td width="51">{id}</td>

<td width="153">{perso}</td>

<td width="354">{perso_url}</td>

</tr>

Thank you

kevinsequeira

what format is perso_url in ??
ie what happens when u echo $data['perso_url'];

reg
kevin

boldorus

The perso_url with echo is showing as :

id=1http://www.../perso.php?
id=2http://www.../perso.php?
...

kevinsequeira

shouldnt it be the reverse

id=1http://www.../perso.php?

should be

http://www.../perso.php?id=1

???

reg
kevin

boldorus

Echo produce the following

http://www.../perso.php?id=1
http://www.../perso.php?id=2

Sorry, My mistake

kevinsequeira

ok, so try this

echo '<a href='.$data['perso_url'].'>this is a link</a>';

reg
kevin

boldorus

I have those line of codes. Can i add something before or after so it react like an hyperlink. This is from profil.php

$tpl->set_var("id", $data['id']);
$tpl->set_var("perso", $data['perso']);
$tpl->set_var("perso_url", $data['perso_url']);

And the other part is in HTML ( template ) from profil.html


<tr>

<td width="51">{id}</td>

<td width="153">{perso}</td>

<td width="354">{perso_url}</td>

</tr>

I don't know where to put an echo.

boldorus

If you wish to see the page in process

You can see profil.php at
http://www.concept13.com/flq/profil.php

It is on the profil.php page that I wish that the links in the column
were active

And you can see the template HTML that is linked to the php page at
http://www.concept13.com/flq/gabarits/profil1.html

boldorus

I have created a data base with MYSQL.

I have in my first column <id> data
In another column i have <perso_url> data

What is the way to make the <perso_url>data link to <id>

because <perso_url> is an URL corresponding to the <id>
example,
if id=1 , http://www.../perso.php?id=1

I have writen all the <perso_url> data in plain text so i need to convert the static data to dynamic data. My perso_url must become http://www.../perso.php?id=(NUMBER in the id column )

I use phpmyadmin

Thanks

kevinsequeira

try this

<td width="354">

<a href={perso_url}>{perso_url}</a>

</td>

reg
kevin

boldorus

Problem solve !!!

On my profil.php page, the links are active.

Thank you so much.

The last thing I need to solve is a way to make the data in
<perso_url> (column in my DATABASE) "linked" to the <id> column.

So i don't have to update, manually, the <perso_url> field
everytime the id change in my database.

kevinsequeira

to have perso_url change dynamically have this

$perso_url = $data['perso_url']."?id=".$data['id'];

and in the database for perso_url store only the url value not the url value with the id hardcoded

ie let all perso_url column values be only

http://www.../perso.php

not

http://www.../perso.php?id=1

reg
kevin

boldorus

You are very handy.

Thanks for your help.

I will learn more about PHP programming so I can help beginners as you are doing. It was a pleasure learning a few tricks from you.

Keep the good work.

And have nice day

PS I'm going outside, taking a little sunshine, thanks to you

kevinsequeira

have fun, im stuck at work🙁
reg
kevin