Amiga database with HTML output?

[Hyperspeed]

I'm looking for a database that can output it's cells into a HTML
website. What I mean by this for example is a HTML page that when a
link is clicked will access data from a field defined in the database.

It could be live via Apache or just converted to seperate HTML pages
for offline reading.

Like an eBay system I suppose.

Any such examples on Amiga?

:-|

[MAD]

Hoya!

I cannot help you but FYI, Final Data can produce ASCII files. Maybe they would be easier to convert to HTML?

Be funky

M A D

[lorddef]

You mean you want to create a database driven site?

Most people use a MySQL, MS JET or something like that in conjunction with PHP or ASP.

I use PHP and MySQL

[Hyperspeed]

I think what lorddef is suggesting would be more what I'm looking for.
Is MySQL available for Amiga though?

Amiga.org is an impressive site but I bet it's made on a PC. I'm not
looking for my HTML style database to be online though, I just thought
it would be nice to present my database data in HTML format (for ease
of browsing) and with nice big 24-bit pictures embedded within it.

I love the way you can sort the order of entries on eBay like you can
do with MUI menus.

:-)

[Amiga1200PPC]

There are mySQL ports available for AmigaOS and MorphOS.

[ShadesOfGrey]

@Hyperseed

To clarify, are your looking for a database (or other application) that can output your tables as HTML? Or are you looking for a database to generate dynamic web content (ala Apache, MySQL, PHP)?

[Amiga1200PPC]

I don't know, if there is a database, that outputs html.

If you want to do it the Amiga way, you can do the somethink like this:

- use a database with ARexx access
- a http server with cgi/ARexx support
- query the database and generate the html ouput with an ARexx program

et voila, that's it.


Instead of ARexx, you could also use a compiler language like c, pascal, modula etc. if you like.

[Hyperspeed]

Yes, I think I'll investigate mySQL.

What I wanted to try for example is have a database of car
specifications and then a HTML document that when you click "Engine"
would arrange all the cars in order of engine capacity.

Then a user could click "Colour" and they'd all sort in order of
colour or "Top Speed" etc.

Like when MUI sorts a list with that black triangle icon, but as a
link.

:-D

[trochej]

   You are looking for a database that has an API for one of languages used to create dynamic pages. PHP (http://www.php.net) and perl (http://www.perl.org) would we the most widely used, I think (don't know how with asp). You can also try for some kind of compiled language, like C/C++ (database need to have an API for it). PHP and perl are IMHO better for this purpose than compiled languages. You could also try java. As for a database, as suggested, you should try mySQL. I know it runs on many platforms and can communicate with many languages.

--
trochej

[Hyperspeed]

Thanks trochej,
   I'll investigate each one for Amiga!

One thing I wondered about eBay though - when you enter a HTTP you are
not accessing a list of files but a CGI script running as a program on
a PC.

So with any database linked HTML document it would need a machine
responding i.e no offline browsing unless say AWeb spoke directly to
the Amiga port of mySQL.

I suppose there is AREXX stuff for this but that's getting too complex
for my hobbyist intention, I've never understood how to program and
execute an AREXX script. Maybe I need a book!

:-) :-D

[trochej]

   Don't know about eBay, but usually it works that way:
 - database engine (lets say mySQL),
 - http server (lets say Apache).

   You use a bunch of scripts to send queries to database engine and fetch answers. There is no problem is including php in html (although you have to say Apache to parse every HTML in search for php code, which can be a performance hit). It's no problem to run all of this on a single computer.
    I don't know if I understood your worries, but such a site with dynamic content would need a connection to database, so yes, it should be online. :-)
    http://www.freewebmasterhelp.com/tutorials/php - You will find a php tutorial here. PHP/mySQL tutorial is linked somwhere there.

--
trochej

[Hyperspeed]

Wow, that looks excellent!

I didn't really want to go that advanced as I just wanted to build an
offline web-page that would display database fields as HTML frames.

But this looks fascinating.

Thanks, I might play with it sometimes. I might need one of those
books though!

:-D

[trochej]

    If you don't need to keep many records, you could try with a flatfile database. PHP has facilities to use those. You would then eliminate mySQL and simplified the learning.

--
trochej