Re: Links in a table in mysql



Luigi Donatello Asero wrote:
I wonder whether I could write links within a table at mysql as text so that
the user could follow  these links which would be displayed on the table on
the webpage.


I think you should try thinking for yourself and read some manuals before
asking questions on usenet, cause your questions are getting a bit annoying.

What is the difference between plain text (which you know that can be stored
in MySQL database) and URL or HTML? URL and HTML are also text, so they can
be stored in any SQL database. The difference is the way you use the text
stored in the DB.

<?php

$math_formula_from_DB = 'x + 2y <= z';
$url_from_DB = 'http://some.domain.com/some/file.php?some=param&and=other';
$html_from_DB = 'Some <b>HTML</b> formatted <i>text</i>.';

echo 'formula: ' . htmlspecialchars( $math_formula_from_DB ) . "<br />\n";
echo 'URL: <a href="' . htmlspecialchars( $url_from_DB ) . '">'
   . htmlspecialchars( $url_from_DB ) . "</a><br />\n";
echo 'HTML: ' . $html_from_DB . "<br />\n";

?>

Try exchanging values between $math_formula_from_DB and $html_from_DB and
rerun the script and you'll see the difference.


Hilarion .



Relevant Pages

  • Re: Private ILS server substitute
    ... >manually change the HTML overview page with another table line every ... >time when new friends joining (although this is quite simply with "Copy ... >be generated from a MySQL database. ... No need to upload .cnf files (in fact the site can ...
    (microsoft.public.internet.netmeeting)
  • Capturing form input
    ... I will try to be short and to the point.(good Luck) I have a form ... written in HTML. ... I have a Mysql database. ... I know I must be missing something since I've been to the w3 ...
    (php.general)
  • Capturing form input
    ... I will try to be short and to the point.(good Luck) I have a form ... written in HTML. ... I have a Mysql database. ... I know I must be missing something since I've been to the w3 ...
    (alt.php)
  • Capturing form input
    ... I will try to be short and to the point.(good Luck) I have a form ... written in HTML. ... I have a Mysql database. ... I know I must be missing something since I've been to the w3 ...
    (comp.lang.php)
  • Re: Can Either of These be Legal HTML?
    ... Guy Macon wrote: ... When asking questions in alt.html, provide a URL to an entire page, not just a small snippet of HTML. ... He isn't even claiming to have a page. ...
    (alt.html)