New To Mac-Forums?

Welcome to our community! Join the discussion today by registering your FREE account. If you have any problems with the registration process, please contact us!

Get your questions answered by community gurus Advice and insight from world-class Apple enthusiasts Exclusive access to members-only contests, giveaways and deals

Join today!

 
Start a Discussion
 

Mac-Forums Brief

Subscribe to Mac-Forums Brief to receive special offers from Mac-Forums partners and sponsors

Join the conversation RSS
Web Design and Hosting Creating sites, scripting, and hosting discussions.

mac osx server. (php/mysql)


Post Reply New Thread Subscribe

 
Thread Tools
design2
Guest
 
Posts: n/a

Hi guys

This is what im upto i've created http://www.axiscomm.co.nz
the front-end design however now im looking to integrate php/mysql
and make it database-driven so they can login and edit the site themselves.

Basically i've had problems with dreamweaver wizard accessing the database
even though i setup the tables in phpmyadmin.

So I thought it might be easier to setup the site using a local/network testing server. Im using mac osx 10.3.9 and am not sure how to go about it i know apache server is installed and if i turn on web file sharing i can access my computer via the net. My question is how do i setup a local testing server and create a database/tables.

After all that all i will need to do is upload the site once dreamweaver has written all the php/sql like user authentication and add a connections file with the database details i have.

Thanks in advance.
Design2
QUOTE Thanks
muso

 
muso's Avatar
 
Member Since: Jan 15, 2003
Location: Whangarei, New Zealand
Posts: 2
muso has a reputation beyond reputemuso has a reputation beyond reputemuso has a reputation beyond reputemuso has a reputation beyond reputemuso has a reputation beyond reputemuso has a reputation beyond reputemuso has a reputation beyond reputemuso has a reputation beyond reputemuso has a reputation beyond reputemuso has a reputation beyond reputemuso has a reputation beyond repute
Mac Specs: Pwnt

muso is offline
I'm going to assume you've got 10.3.9 client not server, since the server comes with mySQL preinstalled I'm pretty sure. You'll need to download and install the latest version (or maybe not the very latest, depending on what the setup on your webhost is) of mySQL from http://dev.mysql.com/downloads/mysql/4.1.html. Download the installer package and it's got detailed instructions on how to start, stop and configure the mySQL server from Terminal.

PHP is already installed on your machine. You'll find a lot of good articles on how to install/update/activate PHP here: http://www.phpmac.com/

A couple of things to remember once you're done: you'll have to manually start up mySQL (as well as Apache) every time you want to view your local sites that use mySQL. I think there's instructions in the mySQL manual on how to start the daemon every time you log in, but I can't recite them from memory, sorry. Also make sure you give the mySQL root user account a password before you do anything. PHP, once enabled, is on for good.

I'm in your forums, writing sentences in a grammatically acceptable manner.
QUOTE Thanks
muso

 
muso's Avatar
 
Member Since: Jan 15, 2003
Location: Whangarei, New Zealand
Posts: 2
muso has a reputation beyond reputemuso has a reputation beyond reputemuso has a reputation beyond reputemuso has a reputation beyond reputemuso has a reputation beyond reputemuso has a reputation beyond reputemuso has a reputation beyond reputemuso has a reputation beyond reputemuso has a reputation beyond reputemuso has a reputation beyond reputemuso has a reputation beyond repute
Mac Specs: Pwnt

muso is offline
Sorry I forgot you asked about creating databases and tables. I could explain it to you but I'd pretty much just be copying and pasting excerpts from the tutorial section in the mySQL manual. So I'll just link to the relevant section: http://dev.mysql.com/doc/mysql/en/database-use.html

I'm in your forums, writing sentences in a grammatically acceptable manner.
QUOTE Thanks
design2
Guest
 
Posts: n/a

when i say create tables i dont really want to hand code.
so i will have to install mysql, is this easy for mac?

what do you know about mambo CMS ?
have you used it?

would it be easier to setup a testing server on my comp then upload once i have everything sorted?

i tried turning on web sharing then going to the given address and opening php pages but they dont show up - just code.

thanks for your help so far..
but its important that i get into some sort of CMS to provide clients with
so what ever is the most common or easiest should suit.
QUOTE Thanks
design2
Guest
 
Posts: n/a

ok im installing the mac mysql package.
i also have found out i have Apache HTTP Server Version 1.3 on my mac.
however when i go to phpmac to update/activate it doesnt seem to have my os 10.3.9
but it does has Building and Installing Apache 2.0.54 and PHP 5.0.4 on Mac OS X 10.3.8
should i follow this?
QUOTE Thanks
muso

 
muso's Avatar
 
Member Since: Jan 15, 2003
Location: Whangarei, New Zealand
Posts: 2
muso has a reputation beyond reputemuso has a reputation beyond reputemuso has a reputation beyond reputemuso has a reputation beyond reputemuso has a reputation beyond reputemuso has a reputation beyond reputemuso has a reputation beyond reputemuso has a reputation beyond reputemuso has a reputation beyond reputemuso has a reputation beyond reputemuso has a reputation beyond repute
Mac Specs: Pwnt

muso is offline
Yes, the package for 10.3.8 should work on your system too.

I'm not sure how far you'll get if you want to avoid doing any command line stuff with mySQL... Chances are you'll have to if you want to install a web-based GUI for it like PHPmyAdmin. You could download a normal application for interfacing with the mySQL server I guess (I think there are a couple out there, check versiontracker).

However, if all you want to do is set up a CMS for your clients, it's probably better to install it directly onto your webserver and not bother installing it on your local machine - that'll just be a hassle. Assuming you have something like CPanel to administrate your server, there should be an option to create databases, add users, and grant users permissions to certain databases, all from a web based control panel. Then all that's usually needed is for you to upload the CMS script to your webserver and start the installation (most large PHP applications will provide you with an automated install script).

To make PHP work, you'll need to name all your files with the .php extension. To make sure whether it's working or not, just create a plain text file with the only contents as:

Code:
<?
   phpinfo();
?>
And save it as something like "phpinfo.php" in your /Library/WebServer/Documents folder. Then navigate to "http://localhost/phpinfo.php" and if you get a page of interesting information then PHP is working. If not, then it's not turned on.

I'm in your forums, writing sentences in a grammatically acceptable manner.
QUOTE Thanks

Post Reply New Thread Subscribe


« Movie control buttons in flash? | How to run MySQL Databases off Mac? »
Thread Tools

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off
Forum Jump

Similar Threads
Thread
Thread Starter
Forum
Replies
Last Post
Power Mac G4 (QuickSilver or MDD) vs Mac Mini pcjabber Apple Desktops 5 04-04-2005 04:50 PM
MAC OSX 10.3 and ORiNOCO Classic Gold LkBurn OS X - Operating System 0 01-26-2005 05:02 PM
Files Disappearing on 2k3 Server Mac Share btalon OS X - Operating System 0 09-07-2004 09:34 AM
Using a server on OSX Marbles OS X - Operating System 0 03-19-2004 08:35 AM
Mac Users Get More ISP Choices schweb Apple Rumors and Reports 1 03-06-2003 10:57 AM

All times are GMT -4. The time now is 12:08 PM.

Powered by vBulletin
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
X

Welcome to Mac-Forums.com

Create your username to jump into the discussion!

New members like you have made this community the ultimate source for your Mac since 2003!


(4 digit year)

Already a member?