Viewing Merge database to webpage template
Merge database to webpage template
|
User: Terry M. 10 years ago
|
|
|
What would it take to merge a database I have to create a webpage for each record using a standard format for each page? The pages do not need to be dynamic as the data doesn't change often. When there are updates to the data, I don't mind manually re-plublishing. I'm thinking along the lines of a mail merge between a database and a word processing document but this would be a web page instead. Any thought or ideas? Anyone already doing this who could coach me on this? |
|
|
User: Jumbo T. 10 years ago
|
|
|
To create webpages from a database, you need php or similar scripts running on the server. EW cannot do that, unless you configure the server to execute php scripts in html files. The database is usually MySQL, but there are also textbased databases. So whatever it is, specify what you have. |
|
|
User: Terry M. 10 years ago
|
|
|
From my limited understanding, there are two types of "database-driven" webpages: dynamic, which requires PHP and MySQL and static, which do not. As I do not need the advanced technology of dynamic webpages - the data in my database does't change often - static pages will do. Also, static pages do not require the "live" querying of PHP. Having done a fairly exhaustive web search, there are seem to be two commercial possibilities: (a) spend the $400 for Filemaker Pro, which will publish static webpages without the need for PHP, or (b) spend $100 for Fourth World Web Merge (http://www.fourthworld.com/products/webmerge/). The coding can't be too difficult (replacing formatted placeholders with data), but it's beyond my abilities. I'm cheap, so I'm looking for a free solution as it's a website I'm not making money from, it's more of a public service. |
|
|
User: Jumbo T. 10 years ago
|
|
|
What is your database? How do you create/edit it? Provide facts. |
|
|
User: Jumbo T. 10 years ago
|
|
|
Here's an EW page that displays a list of names generated with PHP from a text file. http://tahafut.hol.es/members/members.html Links to a sample table file and the PHP source files are on the page. To execute PHP in a html file, I used this in a htaccess file : <FilesMatch members.html> AddHandler fcgid-script .html </FilesMatch> Alternative is to create a table in an application and paste the result in TextEdit. Save the file as html and display it in an iframe. Or copy the <style> and <body> content of that file and paste it in a HTML snippet. Here's the same table (copy/pasted from the webpage) in TextEdit : http://tahafut.hol.es/members/members_textedit.html Imagine the possibilities. |
|
| Post Reply |
| You must login or signup to post. |