build link using postgresql and php

Question

) I have a question:

I have a databse with the following information: Name of report [name] Link to report [link]

The various reports are displayed in tables in my page (using db_tables filed with static, month, week etc)

But i want to generate a link to the report based on "link" and "name"

so i set up a pgsql query :

result = select name, link from db where type = 'week'

This works fine.

To display the above i have:

echo "<div id=\"selMaand\">" ;
    echo "<table id = \"t2\">\n ";
    echo "\t<tr class=\"head\">\n";
    echo "<th colspan=\"2\">Select Maand</th>";
        while ($line = pg_fetch_array($result5, null, PGSQL_ASSOC)) {
    echo "\t<tr>\n";
    foreach ($line as $col_value) {
        echo "\t\t<td width=\"100%\">$col_value</td>\n";
    }
    echo "\t</tr>\n";
}
    echo "</table>\n";
    echo "</div>";

which works fine to.

Now, the link from database is http://192.168.178.1:8080/etc/etc/page.html"onclick humptydumpty>name each time i want to adjust something in either the onlclick or address, i have to change all my links.

What can i insert in my querys so i will be able to build a link like;

echo "<a href = "http://192.168.178.1:8080/etc/etc/**$link**"onlclick humptydumpyu>**$name**</a>

I cant figure out how to break down my array!

Thanks in advance

Sjoerd

Answer 1

If you just need a portion of your URL in the database (i.e. only a portion of it would change for each record), then only store that portion of the URL in the database. You can then generate the remaining portion of the URL (call it the URL base) in your code.

So something like this:

define('URL_BASE', 'http://some.url.base/that/you/can/change/globally/');

Then you get the remaining piece of the URL from the database for each item. So you would have something like this inside your query loop to build the full URL.

$link = $line['link'];
$final_url = URL_BASE . $link;

As far as the onclick stuff goes, I would have that set sepearately as well, since I assume the onclick behavior is not dependent on the individual link (if it is you can make a separate DB column for it).

define('LINK_ONCLICK', 'onclick="some_onclick_function()"');

And in your query loop you can put this together like this:

$name = $line['name'];
$link = $line['link'];
$final_url = URL_BASE . $link;
echo '<a href="' . $final_url . '" ' . LINK_ONCLICK . '>' . $name . '</a>';

Note that it is not really necessary to define the strings for the url base and onclick behavior as constants. I just showed it this way as it is common practice to set globally defined values that do not need to change at run-time ion such a manner.