Why Can't I Open PHP Files on My New Mac?

Devious_Designs

I can open them fine in Firefox on both my PC and my iMac, but on my new Mac G5 it prompts me to save the file.

Most disturbing...

duckduckgoose

Do you mean you can't access .php files in the browser, or you can't open them in a text editor?

If it's the latter, then maybe there's an option that allows you to associate php files with a text editor or something.

Devious_Designs

A file like this should open in Firefox and display some links at the top of the page.

I cannot even open html pages with the .php extention.

Blulagoon

Can you view this forum using the new G5 ?

If you can, then it is handling remote PHP files fine.

Blu

Weedpacket

The question has to be asked: what do you mean by "open"? Directly from the local file system? From a web site? From a web server installed locally?

Devious_Designs

[INDENT]

RETURN OF THE PHP PROBLEM II

Okay, I first started this discussion at sitepoint in This thread

After posting on 5 different forums, including Apple, the issue... Is still there.

In my initial post, I talked about how php files do not display in my fireFox browser. I still have the problem, but I have moved on and concluded that this is because A) I do not have OSX Server installed and/or 😎 My php + MySql isn't installed correctly, which is the real problem.

In a nutshell: I am trying to set up Dreamweaver MX for PHP. And I need some really clear instructions, from the begging to end.

I have OS 10.4
Dreamweaver MX 2004
PHP 5.1.2 for Apache 1.3 (Like a normal person, I downloaded the NEWEST version)
MySql 5.0.19 (Like any normal person, I dl'd the newest version)

The first problem I have is with the installations of PHP and MySql. I cannot find their folders. I do not have a /usr/local/mysql directory like Dreameaver says. The Terminal tells me "Command Not Found" (that's all the Terminal have EVER told me. :rolleyes: )

Dreamweaver...

Look, I am not a the village idiot and I am convinced that this so called "super mac G5" is the village idiot. I have installed hundreds of php scripts on Cpanel running Apache. Why do I need to open terminal? I hate the Terminal, I am scared shitless of it. All the Terminal commands that Dreamweaver tells me to do ALWAYS FAIL.

WHY do you ask? am I listening to Dreamweaver? Because unlike the MORONS at Apple Computers, they actualy supplied me with some PHP/MySql documentation.

Everything that everyone has told me to download has not worked. and the worst part about all of this all is that I only get ONE MORE CHANCE to do it right.

Bonus Questions:
1) It should say it in the system profiler but it doesn't. So how the hell do I know if server is installed? [/INDENT]

Rodney_H_

The simplest, most EASIEST way to resolve this issue is to download and install: MAMP

In five minutes you will be up and running.

(Take it from me, one up from the village idiot, this is easy-peasy for a newbie mac user. At home and in my previous jobs I used PCs but now use a MAC in the office...)

Houdini

I see posts all the time about difficulty installing Apache PHP MySQL and after watching those with the difficulty explaining all the things they have done and all that I do wonder why they don't just download MAMP or WAMP (for windows) or XAMPP or something along those lines. I mean if all you want to do is create a web server on your local PC or MAC or whatever then why go through all the trouble?

I did install Apache PHP and MySQL a few years ago and I think I was using Apache 1.2 or 1.3 then I wanted to put Apache 2.0 on or at least a newer version and I found XAMPP as well a Triad. I used XAMPP and have upgraded with XAMPP to this very day.

I had reference material to make the install myself but with XAMPP or WAMP hey it is too easy and within an hour updownload I am actually working on PHP or MySQL and not trying to see why my new install doesn't work Kudos Rodney H.

Rodney_H_

Thanks, Houdini!

Devious_Designs

Houdini wrote:
I see posts all the time about difficulty installing Apache PHP MySQL and after watching those with the difficulty explaining all the things they have done and all that I do wonder why they don't just download MAMP or WAMP (for windows) or XAMPP or something along those lines. I mean if all you want to do is create a web server on your local PC or MAC or whatever then why go through all the trouble?

I did install Apache PHP and MySQL a few years ago and I think I was using Apache 1.2 or 1.3 then I wanted to put Apache 2.0 on or at least a newer version and I found XAMPP as well a Triad. I used XAMPP and have upgraded with XAMPP to this very day.

I had reference material to make the install myself but with XAMPP or WAMP hey it is too easy and within an hour updownload I am actually working on PHP or MySQL and not trying to see why my new install doesn't work Kudos Rodney H.

What IS Wamp? An alternative to apache?
See, this stuff drives me nuts. I follow step by step directions and they don't work.
Then people tell me to download all this software... They might as well recall MySQL because it doesn't work very proficiently.

macromedia help files wrote:
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;

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. :-/

macromedia help files wrote:
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.)

Blulagoon

www.mamp.info

Rodney_H_

@: It would appear that Devious Designs is not listening or heeding our advice??

Devious_Designs

I downloaded mamp, but I'd like to know what's up with access denied.

Houdini

Wamp is Windows Apache MySQL and PHP, will not work with MAC 'cause it is a different OS.

Rodney_H_

Devious Designs wrote:
I downloaded mamp, but I'd like to know what's up with access denied.

OK:

1) Open up the MAMP application.

2) When it is open, click the OPEN START PAGE button

3) Click PhpMyAdmin link at the top

4) Click priveledges

5) Add A New User

6) Create a new user, and assign a USERNAME and PASSWORD

7) Assign what tasks you would like that user to be allowed to perform...

And bob's your uncle, you should be able to do whatever you want.........

THEN, you can create the database and tables within PhpMyAdmin, or you can write PHP scripts to do it. If you are more comfortable with SQL, you can click the SQL link after the db has been created and run your lines / scripts from there.

Hope that helps.

Houdini

Doesn't a new default MySQL install come with a default of username 'root' and password '' or nothing? Maybe it is the MAMP way of doing it I guess, I'm a Wimmers user.

Rodney_H_

Houdini, yes, it does have the default "root". You are 100% correct.

I was just trying to elimate that as a possible problem for him.

Hopefully, what I said above will help..................

khendar

Guys...this dude has posted the same thing on at least 2 other forums, probably more. And isn't heeding the advice given in any of them.

He's caught up in mysql not working - using dreamweaver's help to try all this stuff which is irrelevant.

I doubt he even has a webserver installed. He stated himself he doesn't have OSX Server installed (I'm assuming thats a webserver? ) and I doubt he even attempted to install MAMP. That would explain

He should try a simple phpinfo() script and load it from his browser aimed at localhost.

Addionally I know of NO operating system which will allow you to double click on a php file and have it open in the browser displaying its output. The "Save file as" message is a dead give away - he doesn't have a webserver installed.

Rodney_H_

Yeah, something is fishy...

Reading the DW help files for a PHP / MySQL problem is like reading a cook book, when there is a problem with the stove....

Devious_Designs

Rodney,

I tried Mamp and it's throwing me off, for I am intentively following a Deamweaver tutorial and I'm not sure how to incorporate Mamp with Dreamweaver MX.
On one hand the Mamp Read Me file tells me to put HTML files in their folder, while Dreamweaver is telling me to put my files on another.
Then I have this SITES folder on my Mac that Apple specified to use and I think I need to connect to my database through Dreamweaver.

Understand that everyone (on other forums too) is telling me to "go download this" but no one tells me why.