Well, needless to say, it dodn't work.
Lone and behold, I do not have a httpd.conf file anywhere on my mac.
AND
On top of it all, I hardly understand what anyone is telling me or why they're telling me it. I understand step by step, and this is where it drives me nuts because I DO follow step by step directions and they don't work!
Then people tell me to download all this software... They might as well recall Apache or OS 10 because if step by step directions can't be executed... Well, then it's not very good software.
FROM MACROMEDIA HELP FILES
Setup for Sample PHP Site
Macromedia Dreamweaver MX 2004 comes with sample PHP pages to let you build a small web application. This chapter describes one way to set up the sample application using Microsoft Internet Information Server (IIS) or Personal Web Server (PWS). For more information on these web servers, see Installing a Web Server. If you're using a different web server, see "Setting Up a Web Application" in Using Dreamweaver Help.
If you're a Macintosh user, you can either connect to a remote PHP server or develop PHP sites locally using the Apache web server and PHP application server installed with your operating system. For setup information, see the following websites:
• developer.apple.com/internet/macosx/php.html
• www.entropy.ch/software/macosx/
Setting up a web application is a three-step process. First, configure your system. Second, define a Dreamweaver site. Third, connect the application to your database. This setup guide follows this three-step process.
Configuring your system (PHP)
You must configure your system before you can run PHP pages on it. Specifically, you must make sure a web server and a PHP application server are installed and running on your system, then you must create a root folder for your PHP files.
Configuring your Macintosh system (PHP)
If you're a Macintosh user, you can run PHP pages on your computer using the Apache web server and PHP application server installed with your operating system. Configuring your system consists of making sure the web server and PHP application server are working, then creating a root folder for your PHP files.
Testing the PHP installation (Macintosh)
You can test the Apache web server and PHP application server on your Macintosh by running a test page.
However, before you can use the web server to serve PHP pages and content from MySQL databases, you must configure the server to work with PHP and MySQL. For information on this process, see www.macromedia.com/devnet/mx/dreamweaver/articles/php_macintosh.html.
To test the Apache web server and PHP application server:
1. Configure the server as described in the article on the Macromedia website.
2. In Dreamweaver or any text editor, create a plain text file and name it timetest.php.
3. In the file, enter the following code:
4.
This page was created at
5. <?php echo date("h:i:s a", time()); ?>
6. on the computer running PHP.
7. This code displays the time the page was processed on the server.
8. Copy the file to the /Users/your
username/Sites folder on your Macintosh.
9. This Sites folder is your personal root folder for the Apache web server.
10. In your web browser, enter the following URL and press Return:
11.
http://localhost/~yourusername/timetest.php
The test page should open and display a time of day.
The specified time is known as dynamic content because it changes every time you request the page. Click your browser's Refresh button to generate a new page with a different time.
Note: Looking at the source code (View > View Source in Safari) will confirm that the page does not use any client-side JavaScript to achieve this effect.
If the page doesn't work as expected, check for the following possible errors:
• The file does not have a .php extension.
• The URL contains a typing mistake. Check for errors and make sure the filename is not followed by a slash, such as
http://localhost/~yourusername/timetest.php/. Also make sure you included the tilde (~) before your user name.
• The page code contains a typing mistake.
• The Apache server is not running. Look in System Preferences, in the Sharing category, to see whether Personal Web Sharing is enabled.
After testing and testing the server software, create a root folder for your web application. (See Creating a root folder (Macintosh).)
Creating a root folder (Macintosh)
After the server software is installed, create a root folder for your web application on the Macintosh.
To create a root folder for your web application:
• Create a folder called MySampleApp in the /Users/your
username/Sites folder.
• Apache will process any page in this folder or in any of its subfolders in response to an HTTP request from a web browser.
After configuring your system, you must define a Dreamweaver site. (See Defining a Dreamweaver site (PHP).)
Defining a Dreamweaver site (PHP)
After configuring your system, copy the sample files to a local folder and define a Dreamweaver site to manage the files.
Note: If you're a Macromedia HomeSite or ColdFusion Studio user, you may find it useful to think of a Dreamweaver site as being like a HomeSite or Studio project.
Copying the sample files
If you haven't already done so, copy the sample files from the Dreamweaver application folder to a folder on your hard disk.
To copy the sample files:
1. Create a new folder called Sites-Local in your user folder on your hard disk.
2. For example, create one of the following folders:
• C:\Documents and Setting\your
username\My Documents\Sites-Local (Windows)
• /Users/your
username/Documents/Sites-Local (Macintosh).
3. Note: On the Macintosh, there's a folder called Sites already in your user folder. Don't use that Sites folder as your local folder; the Sites folder is where you place your pages to make them publicly accessible when you're using the Macintosh as a web server.
4. Locate the GettingStarted folder in the Dreamweaver application folder on your hard disk.
5. If you installed Dreamweaver to its default location, the path to the folder is as follows:
• C:\Program Files\Macromedia\Dreamweaver MX 2004\Samples\GettingStarted\ (Windows)
• /Applications/Macromedia Dreamweaver MX 2004/Samples/GettingStarted (Macintosh)
6. Copy the GettingStarted folder into the Sites-Local folder.
After copying the GettingStarted folder, define the folder as a Dreamweaver local folder. (See Defining a local folder.)
Defining a local folder
After copying the GettingStarted folder, define the folder containing the PHP sample files as a Dreamweaver local folder.
To define the Dreamweaver local folder:
1. In Dreamweaver, select Site > Manage Sites. In the Manage Sites dialog box, click the New button, then select Site.
2. The Site Definition dialog box appears.
3. If the Basic tab is showing, click the Advanced tab.
4. In the Site Name text box, enter Trio-PHP.
5. The name identifies your site within Dreamweaver.
6. Click the folder icon next to the Local Root Folder text box, then browse to and select the folder (inside the GettingStarted folder) that contains the PHP sample files. The folder should be as follows:
• C:\Documents and Setting\your
username\My Documents\Sites-Local\GettingStarted\ 4-Develop\php (Windows)
• /Users/your
username/Documents/Sites-Local/GettingStarted/4-Develop/php (Macintosh)
Leave the Site Definition dialog box open. Next, define a web server folder as a Dreamweaver remote folder. (See Defining a remote folder.)
Defining a remote folder
After defining a local folder, define a web server folder as a Dreamweaver remote folder.
To define the Dreamweaver remote folder:
1. In the Advanced tab of the Site Definition dialog box, select Remote Info from the Category list.
2. The Remote Info screen appears.
3. In the Access pop-up menu, choose how you want to move your files to and from the server: across a local network (the Local/Network option) or using FTP.
4. Note: There are other options in the Access pop-up menu, but this chapter doesn't cover them. For information about them, see Using Dreamweaver Help.
5. Enter the path or FTP settings to the web server folder you created in Creating a root folder (Windows).
6. The folder may be on your hard disk or on a remote computer. Even if you created the folder on your hard disk, that folder is still considered to be the remote folder. The following example shows a possible Remote Folder path if you chose Local/Network access and your remote folder is on your Windows hard disk:
7. Remote Folder: C:\Inetpub\wwwroot\MySampleApp
8. On the Macintosh, the folder might be as follows:
9. Remote Folder: /Users/your
username/Sites/MySampleApp
10. For more information on FTP, see "Setting Remote Info options for FTP access" in Using Dreamweaver Help.
Leave the Site Definition dialog box open. Next, define a folder to process dynamic pages. (See Specifying where dynamic pages can be processed (PHP).)
Specifying where dynamic pages can be processed (PHP)
After defining the Dreamweaver remote folder, specify a folder to process dynamic pages. Dreamweaver uses this folder to display dynamic pages and connect to databases while you're developing your application.
To specify the folder to process dynamic pages:
1. In the advanced Site Definition dialog box, click Testing Server in the Category list.
2. The Testing Server screen appears. Dreamweaver needs the services of a testing server to generate and display dynamic content while you work. The testing server can be your local computer, a development server, a staging server, or a production server, as long as it can process PHP pages. In many situations, including setting up for the Trio site, you can use the same settings as the Remote Info category (see Defining a remote folder) because they point to a server capable of processing PHP pages.
3. Select PHP MySQL from the Server Model pop-up menu.
4. In the Access pop-up menu, select the same method (Local/Network or FTP) you specified for accessing your remote folder.
5. Dreamweaver enters the settings you specified in the Remote Info category. Leave the settings unchanged.
6. In the URL Prefix text box, enter the root URL you would enter in a web browser to request a page in your web application.
7. To display live data in your pages while you work, Dreamweaver creates a temporary file, copies it to the website's root folder, and attempts to request it using the URL prefix.
8. Dreamweaver makes a best guess at the URL prefix based on the information you provided in the Site Definition dialog box. However, the suggested URL prefix may be incorrect. Correct or enter a new URL prefix if the suggestion in Dreamweaver is incorrect. For more information, see "About the URL prefix" in Dreamweaver Help (Help > Using Dreamweaver).
9. For the PHP sample content in Windows, the prefix should be as follows:
10. URL Prefix:
http://localhost/MySampleApp/
11. On the Macintosh, the prefix should be as follows:
12. URL Prefix:
http://localhost/~yourusername/MySampleApp/
13. Tip: The URL prefix should always specify a directory, rather than a particular page on the site. Also, be sure to use the same capitalization you used when you created the folder.
14. Click OK to define the site and dismiss the Site Definition dialog box, then click Done to dismiss the Manage Sites dialog box.
After specifying a folder to process dynamic pages, upload the sample files to the web server. (See Uploading the sample files.)
Uploading the sample files
After specifying a folder to process dynamic pages, upload the sample files to the web server. You must upload the files even if the web server is running on your local computer.
If you don't upload the files, features such as Live Data view and Preview in Browser may not work properly with dynamic pages. For example, image links might be broken in Live Data view because the image files are not on the server yet. Similarly, clicking a link to a detail page while previewing a master page in a browser will cause an error if the detail page is missing from the server.
To upload the samples files to the web server:
1. In the Files panel (Window > Files), select the root folder of the site in the Local View pane.
2. The root folder is the first folder in the list.
3. Click the blue Put Files arrow icon in the Files panel toolbar, and confirm that you want to upload the entire site.
4. Dreamweaver copies all the files to the web server folder you defined in Defining a remote folder.
The Dreamweaver site is now defined. The next step is to connect to the sample database installed with Dreamweaver. (See Connecting to the sample database (PHP).)
Connecting to the sample database (PHP)
During installation, Dreamweaver copies a SQL script to your hard disk. You can use this script to automatically create a sample MySQL database. This section describes how to create a connection to the sample database.
This section assumes you have installed and configured MySQL on your local or remote computer. To download and install the database system, visit the MySQL website at www.mysql.com.
Creating the MySQL database
The sample files for Dreamweaver MX 2004 include a SQL script capable of creating and populating a sample MySQL database.
Before starting, make sure MySQL is installed and configured on your local or remote computer. You can download the latest version from the MySQL website at www.mysql.com.
To create the sample MySQL database:
1. Copy the SQL script file, insert.sql, to an appropriate folder on the computer that has MySQL installed.
2. If you installed Dreamweaver to its default location, the path to the script file is as follows:
• C:\Program Files\Macromedia\Dreamweaver MX 2004\Samples\Database\insert.sql (Windows)
• /Applications/Macromedia Dreamweaver MX 2004/Samples/Database/insert.sql (Macintosh)
3. If the computer running MySQL is a Windows computer, copy the insert.sql script to MySql\Bin. If the computer running MySQL is a Macintosh, copy the insert.sql script to your Documents folder in your home folder.
4. On the computer that has MySQL installed, open a command prompt window (Windows) or a Terminal window (Macintosh).
• In Windows, you can open the command prompt by selecting Start > Programs > Command Prompt or Start > Programs > Accessories > Command Prompt.
• On the Macintosh, you can open a Terminal window by going to the Applications folder, opening the Utilities folder, and double-clicking Terminal.
5. (Windows only) Change to the mysql\bin directory by entering the following commands at the command prompt:
6. cd \
7. cd mysql\bin
8. Note: On the Macintosh, you should be able to run mysql from any directory; it should have been added to your path during installation of MySQL. If the following step doesn't work on the Macintosh, though, try typing /usr/local/bin/mysql instead of mysql.
9. Start the MySQL client by entering the following command:
10. mysql -uUser -pPassword
11. For example, if your MySQL user name (also known as an account name) and password are Tara and Telly3, then enter the following command:
12. mysql -uTara -pTelly3
13. If you don't have a password, omit the -p argument as follows:
14. mysql -uTara
15. If you didn't define a user name while configuring your MySQL installation, enter root as the user name, as follows:
16. mysql -uroot
17. The MySQL client's command prompt appears, as follows:
18. mysql>
19. Create a new database by entering the following command at the MySQL prompt:
20. mysql>CREATE DATABASE TrioMotors;[/quote]
Last login: Mon Mar 27 23:05:38 on ttyp1
Welcome to Darwin!
mac:~ albert$ mysql -uMonaco
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 13 to server version: 4.1.18-standard
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> CREATE DATABASE TrioMotors;
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'triomotors'
mysql>
Needless to say, I can't get any further. :-/
[quote=macromedia help files]21. MySQL creates a new database, but it doesn't contain any tables or records yet.
22. Log out of the MySQL client by entering the following command at the prompt:
23. mysql>quit;
24. At the system command prompt, populate the new TrioMotors database in MySQL.
25. In Windows, use the following command:
26. mysql -uUser -pPassword TrioMotors < insert.sql
27. On the Macintosh, use the following command:
28. mysql -uUser -pPassword TrioMotors < ~/Documents/insert.sql
29. This command uses the insert.sql file to add tables and records to the TrioMotors database you created in step 5.
After creating the MySQL database, create a database connection to it in Dreamweaver. (See Creating a database connection.)[/quote]
G5 Mac OS X (10.4.4) It's ********
