Hi bobdohse!

02 Jan 2003, [EMAIL PROTECTED] wrote:

 b> HTML-DBMS interface
Grab linux ...
install apache, mysql or postgre, a scripiting language of yopur choice (php,
perl .....) and ready.

Where is the problem ??

it is as easy as: (with php/mysql ... other combinations are also not harder to
do) it will read data from the database and print it into a table.
=== Begin file ===
<HTML>
<HEAD>
<TITLE>MySQL Example</TITLE>
</HEAD>
<BODY>
<?php
  $link = mysql_connect("localhost", "ricsi", "")
    or die ("Could not connect");

  mysql_select_db ("test")
    or die ("Could not select database");
  print ("<h1>MySQL example<br></h1>\n");

  $query = "SELECT * FROM test";
  $result = mysql_query ($query)
    or die ("Query failed");

  print "<table border=5>\n<tr><td>id</td>\n<td>name</td></tr>\n";
  while ($row = mysql_fetch_array ($result)) {
    echo "<tr><td>".$row[0]."</td>\n";
    echo "<td>".$row[1]."</td></tr>\n";
  }
  print "</table>\n";

  mysql_close($link);
?>
</BODY>
</HTML>
===  End file  ===

If you only want to search/insert manually, you could even use phpmyadmin, and
have online www access to your database.

 b> Bob

CU, Ricsi

--
|~)o _ _o  Richard Menedetter <[EMAIL PROTECTED]> {ICQ: 7659421} (PGP)
|~\|(__\|  -=> Time is the dressmaker specializing in alterations <=-

Reply via email to