I've been working on a Trek-related database for nearly seven years now. I've used FileMaker Pro, which is the program that my father purchased for his business originally. I've hoped to be able to publish my work (eventually) on the web, but FileMaker database hosting has proven far too expensive.
However, I recently changed hosting services, and my new hosting package includes MySQL databases. I figured, why not create a new framework based on a made-for-the-web program, and get my work out there that way? It can't be that difficult...
Ha!
Although my hosting account has this control panel and some management pages, it's turning out to be a hell of a lot more complex than I ever thought it would be.
I've taken a look around at sites like mysql.com and phpmyadmin.net (the web interface for MySQL), but their documentation is obscenely long-winded, complicated, and apparently is based around command-line control of the whole thing. I've had a little bit of UNIX experience, but not nearly enough for something like this. And all the documentation I've found seems to be meant for direct manipulation of the databases, not through host-provided interfaces.
So what I'm hoping is, that someone here has a little bit of experience and can point me to a decent source for documentation, tutorials, and so on. I can purchase some books if I need to, but I frankly have no idea what I'm looking for or where to start... and I don't want to have to buy books that I don't need.
Please?
-------------------- “Those people who think they know everything are a great annoyance to those of us who do.” — Isaac Asimov Star Trek Minutiae | Memory Alpha
Registered: Nov 2000
| IP: Logged
Cartman
just made by the Presbyterian Church
Member # 256
posted
Well, SQL is rather like a carriage to PHP's horse: the latter usually serves as a front-end for the former, so you'll need to learn both if you want to get the most out of either language.
SQL tutorials can be found all over the 'net - covering everything from thebasics to more advancedtopics.
The best source of documentation, by the way, is SQL's official page.
Registered: Nov 1999
| IP: Logged