RE: Somewhat Dynamic HTML
RE: Somewhat Dynamic HTML
- Subject: RE: Somewhat Dynamic HTML
- From: email@hidden
- Date: Thu, 7 Mar 2002 09:56:34 -0600
I don't have all the facts, but I would recommend using PHP and MySQL for
your website. I'm a big user of FileMaker but getting it on the web (without
a ten user limit) is expensive and I thought rather difficult, especially
out of OS X - no ODBC drivers. It was going to be cost prohibitive to make a
company wide Help Desk site in FileMaker.
I started researching other means and turned to PHP and MySQL. PHP is just
another scripting language like AppleScript except it is "intertwined" with
HTML. I use BBEDIT to write mine. MySQL is a powerhouse database system -
and it's Open Source (very inexpensive, if not free). Both can be easily run
off of OS X, Windows, or Linux. For an ISP that runs both and allows you
access to the database checkout
http://www.westhost.com/packages.html
Pricing starts at $8.95 a month.
There are plenty of resources on the web and in print about both. Good
places to begin are www.peachpitpress.com for PHP books and
www.samspublishing.com for MySQL and SQL books.
Programs I use are
1. BBEDIT (www.barebones.com) for tons of uses and AppleScriptable.
2. JaneBuilder (www.seejanecode) for quick PHP/MySQL page building that is
later tweaked in BBEDIT.
3. MacSQL Monitor Lite (www.rtlabs.com) to transfer data to and from MySQL
databases. It's AppleScriptable and great for moving data to and from
FileMaker. It comes with an example script for syncing data in a FileMaker
database to a MySQL database. (Think user entered data that you want to move
to an easy use front end).
4. FileMaker (www.FileMaker.com)
5. Of course I use Script Debugger (www.latenightsw.com) for my AppleScript
work - it puts the "smack down" on AppleScript!
A great all-in-one package is the OpenWeb collection from Open OSX
(www.OpenOSX.com) that quickly and easily installs and configures PHP and
MySQL (plus several other programs and utilities that make my life easier)
on OS X. It runs $60 and some people complain that you could get all it's
software free off the web, but you'll easily save that much in time and
frustration in the first 5 minutes.
There's a learning curve to all this, but not anymore difficult than
AppleScript and FileMaker. You work with the same concepts - loops, if
statements, fields, field definitions, etc., etc....
I guess that's it....
Good Luck,
Ron Bishop
Macintosh Systems Administrator
The Kansas City Star
1729 Grand Blvd.
Kansas City, MO 64108
816/234-4943
-----Original Message-----
From: Landis [
mailto:email@hidden]
Sent: Wednesday, March 06, 2002 11:11 PM
To: email@hidden
Subject: Somewhat Dynamic HTML
I've got an Excel spreadsheet that I'm thinking of turning into a
Filemaker Pro database. But either way it's got data in it that I'm
hoping to put on the web.
I have a website that has many pages that are almost identical with
pictures from different area of North America. So in my spreadsheet
(for example) I've got a region, a state, an area:
West, California, San Francisco Bay Area
But I need to make relative links to all the other areas, and all the
other states and regions. And I'd like to be able to easily add more
pages to it later, or be able to easily change the template and
remake the whole site.
I don't have access to the server so I need to create static HTML
pages. No running Filemaker Pro Server, or Cold Fusion. Is this
possible in AppleScript? Am I in over my head? Is there something
out there that can do this already? Would I be reinventing the wheel?
As usual, thanks for the wonderful help and interesting topics.
Landis
_______________________________________________
applescript-users mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/applescript-users
Do not post admin requests to the list. They will be ignored.
_______________________________________________
applescript-users mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/applescript-users
Do not post admin requests to the list. They will be ignored.