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

[Devious_Designs]

My friend,

Threads are like timelimes and you have jumped WAY into the future.

I am right here.

Last login: Wed Mar 29 02:50:49 on ttyp1
Welcome to Darwin!
mac:~ albert$ /Applications/MAMP/bin/mysql4/bin/mysqladmin -u root -p password albert
Enter password:
/Applications/MAMP/bin/mysql4/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'
mac:~ albert$

That is where I am.
Don't tell me I cannot run software. I know this. But I can follow step by step manuals. and the Mamp manal told me to type exactly that. And when the steps don't work, that opens me up to say that the company made a crappy manual.

[Rodney_H_]

After you download MAMP, you have to put any PHP file into the MAMP/htdocs directory

SO, if you are working on a site called "test", appropriately enough, then create a new folder and drop it into:

MAMP/htdocs/test

Then, put a file into it called "info.php" and write the following lines of code:

<?php
phpinfo();
?>

That is it, just THREE lines of code. Nothing else. Save it as "info.php"

Now, open up dreamweaver and define your site as usual.
BUT, make sure you set up the testing server, too. This tells dreamweaver not to open it as the file, but to let it be parsed from the server and PHP engine, if need be... OK? Understand that?

1) If you do not set up the TEST server in Dreamweaver, you won't see squat.
2) If you don not set up your web site folders in MAMP/htdocs you won't see squat.
3) If MAMP servers are not on, you won't see squat
4) see 1 & 2 & 3 above ^

NOTE: It may take a bit of tinkering at first to figure out what to set the testing location to be. Don't give up. Just experiment. Open the MAMP opening page to help you figure it out...

[Devious_Designs]

Rodney H. wrote:

After you download MAMP, you have to put any PHP file into the MAMP/htdocs directory

SO, if you are working on a site called "test", appropriately enough, then create a new folder and drop it into:

MAMP/htdocs/test

Then, put a file into it called "info.php" and write the following lines of code:

<?php
phpinfo();
?>

That is it, just THREE lines of code. Nothing else. Save it as "info.php"

Now, open up dreamweaver and define your site as usual.
BUT, make sure you set up the testing server, too. This tells dreamweaver not to open it as the file, but to let it be parsed from the server and PHP engine, if need be... OK? Understand that?

1) If you do not set up the TEST server in Dreamweaver, you won't see squat.
2) If you don not set up your web site folders in MAMP/htdocs you won't see squat.
3) If MAMP servers are not on, you won't see squat
4) see 1 & 2 & 3 above ^

NOTE: It may take a bit of tinkering at first to figure out what to set the testing location to be. Don't give up. Just experiment. Open the MAMP opening page to help you figure it out...

Thanks, that helped a lot, but I still have a few problems configuring. 😃

Dreamweaver keeps giving me this message in the site configuration: "This site's testing and remote servers are different"

I don't know where all the files and folders should point to. (See attachment)
Sometimes I save a file, but it does not change when I preview. And I still do not know how to connect to a MySql database through dreamweaver.

[Rodney_H_]

Devious Designs wrote:

Thanks, that helped a lot, but I still have a few problems configuring. 😃

Dreamweaver keeps giving me this message in the site configuration: "This site's testing and remote servers are different"

I don't know where all the files and folders should point to. (See attachment)
Sometimes I save a file, but it does not change when I preview. And I still do not know how to connect to a MySql database through dreamweaver.

Well, your TESTING and REMOTE servers SHOULD be different.

Also, it doesn't look like you are saving your website in the correct directory. It should be something like:

[INDENT]
Testing Sever Folder: Macintosh HD:Applications:MAMP:htdocs:lYour-Folder-Name-Here:
[/INDENT]

And, your URL prefix should be something like this:

[INDENT]
http://localhost:8888/lYour-Folder-Name-Here/
[/INDENT]

MAMP runs on port 8888 so as not to interfere with the other servers that OS-X has installed already. Also allows you to easily start and stop the MYSQL and APACHE servers as needed...

PS: When defining a site in Dreamweaver I always use the Advanced TAB.

[Houdini]

Copy this code name it mysql.php then put it into your htdocs folder or if you have a test folder there then put it into htdocs/test. Then open your browser, not Dreamweaver and type either http://localhost/mysql.php or if you put it into the test folder then type http://localhost/test/mysql.php and you will know if you are connecting to MySQL because it will print a table of all sorts of the server

data.
<html>
<head>
<title>Test MySQL</title>
<body>
<!-- mysql_up.php -->
<?php
$host="localhost";
$user="root";
$pass="";
mysql_connect($host,$user,$pass);
$sql="show status";
$result=mysql_query($sql);
if($result==0)
  echo("<b>Error ".mysql_errno().":" . mysql_error() ."</b>"); 
elseif(mysql_num_rows($result)==0)
  echo("<b>Query executed sucessfully!</b>");
else{
?>
<!-- Table that displays the results -->
<table border ="1">
  <tr><td><b>Variable name</b></td><td><b>Value</b></td></tr>
  <?php
    for($i=0;$i < mysql_num_rows($result);$i++){
	  echo("<tr>");
	  $row_array = mysql_fetch_row($result);
	  for($j=0;$j < mysql_num_fields($result); $j++){
	    echo("<td>".$row_array[$j]."</td>");
	}
	echo("</tr>");
  } 
?>
</table>
<?php
} 
?>
</body>

[Devious_Designs]

Houdini, The G5 is at home. I'll have the results tomorrow.

Rodney H,
That covers TESTING and REMOTE, but what about LOCAL?
And which mode am I supposed to be working in?

[dalecosp]

Way OT (or back topic) here. If you use "root" and "albert" to log into the mysql shell, it will deny access, because root's passwd isn't "albert", and you've not yet been inside to set it up as such. So, forget the password, and try again:

#mysql -u root
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2411 to server version: 4.0.26

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

HTH,

[Rodney_H_]

Devious Designs wrote:

Rodney H,
That covers TESTING and REMOTE, but what about LOCAL?
And which mode am I supposed to be working in?

Local is the folder where your files are stored while building them. So, they should be somehwhere withing the MAMP/htdocs/ folder...

[Houdini]

Is this not a record if not near record Post which is now going on 4 pages? I don't know but I though that the MAC was a really great system, and I am aware that it is fantastic for graphics or video applications but I can't even draw a stick man so don't really care too much for all that, you would have thought that this would be an easily solved problem, but it seems to live forever with more nuances all the time. Of course this is just my opinion maybe I need to keep my Winderz OS.

[Rodney_H_]

Houdini wrote:

Is this not a record if not near record Post which is now going on 4 pages? I don't know but I though that the MAC was a really great system, and I am aware that it is fantastic for graphics or video applications but I can't even draw a stick man so don't really care too much for all that, you would have thought that this would be an easily solved problem, but it seems to live forever with more nuances all the time. Of course this is just my opinion maybe I need to keep my Winderz OS.

You know, I hadn't used a MAC for about eight years until I got my new job recently at a small design firm. I wanted to set up a testing server on my G5, and did a little research. Was going to try EAsy PHP or WAMP, but those were just for Windows, so... I did a little more reading, and in about five minutes, downloaded the MAMP server. Another five minutes, after reading the FAQs, I was up and running. total time of install and research: 1/2 hour at the most.

Now, I have a PowerBook, a G5, and my Windows network at nome. The MAC makes everything look so lovely. It is like when Dorothy left Kansas for OZ and the film went from B&W to color.... You can even smell things better on a MAC, did you know that, Houdini?

😉

[Blulagoon]

Rodney H. wrote:

Now, I have a PowerBook, a G5, and my Windows network at nome. The MAC makes everything look so lovely. It is like when Dorothy left Kansas for OZ and the film went from B&W to color.... You can even smell things better on a MAC, did you know that, Houdini?
😉

@

You really need to get out more. I think most of DD's problems would be solved if he just uninstalled Dreamweaver !! :evilgrin:

Blu.

[Rodney_H_]

Blulagoon wrote:

@

You really need to get out more. I think most of DD's problems would be solved if he just uninstalled Dreamweaver !! :evilgrin:

Blu.

Ahhhhhhhhhhhhhhh yes. 'Tis true, Blue.

:p

[dalecosp]

Houdini wrote:

you would have thought that this would be an easily solved problem, but it seems to live forever with more nuances all the time.

It's compounded by not being narrowed down in the first place.

Of course this is just my opinion maybe I need to keep my Winderz OS.

To each his own. A bit of community involvement and a lot of RTFM and most people should be able to run just about anything out there these days (with the possible exception of 397 archiaic, quaint, OSes that we shant't talk about [OK, then, anyone ever deal with THEOS?]).

[Rodney_H_]

dalecosp wrote:

[OK, then, anyone ever deal with THEOS?]).

Sure, Theo and I used to be on the same soccer team.... 😉

[Blulagoon]

dalecosp wrote:

the possible exception of 397 archiaic, quaint, OSes that we shant't talk about [OK, then, anyone ever deal with THEOS?]).

No, but I did work with GEOS ...

Blu

[Devious_Designs]

[INDENT]

Rodney H. wrote:

Local is the folder where your files are stored while building them. So, they should be somehwhere withing the MAMP/htdocs/ folder...

[INDENT]Having 3 folders is becoming a real hastle.
I'm having the problem where I'm overwriting my new files with the old ones. That's why I set all the folders to the same directory. Can I delete the local folder or set it to the same directory as the remote? What folder should I be working from?

By the way, I've used Apple for 20 years. I used to code by line.
And this has nothing to do with the topic.
Apple's problem is not with the hardware, it's the company. I watched them progress over the years, as the lies unfold. They don't care about developers or artists anymore- only iPod sales and new customers. Once your a customer- screw you.[/INDENT][/INDENT]

[dalecosp]

Rodney H. wrote:

Sure, Theo and I used to be on the same soccer team.... 😉

If you're referring to Mr. De Raadt, I was referring to the other people in the famed, um lawsuit, or whatever (don't think it actually got that far, did it?) ... ah, back to Goog...

[Devious_Designs]

So can I set two folders to the same path?

Also, which 'view' should I work from?

Thanks. 🙂

[dalecosp]

Devious Designs wrote:

So can I set two folders to the same path?

If I understand what you are asking, you should be able to make a 'link' --- either a hard link (linked file) or a symbolic link (pointer).

Also, which 'view' should I work from?

I don't know what you're asking about there; I assume something in DW?

Tempted, of course, to say, which ever you prefer?

[Rodney_H_]

In the folder / directory : MAMP/htdocs/

You can have several web sites:

MAMP/htdocs/
- site1
- site2
- site3
- etc...

Each folder in "MAMP/htdocs/" should consist of a separate entity, or an entire project or web site, that you would then, in turn, define as a site in DW.

Make sure you carefully select the correct folder when defining the site.

Make sure you carefully specify the "path" which will become the URL for testing the site.

I am not sure why you are over-writing new files with old files. Just the opposite should be occurring: You should be overwriting OLD files with NEW files when you save them... (??)

Do yourself a flavor:

1) Read the HELP files in dreamweaver.

HELP
Dreamweaver Help
Tutorials: Working with Dreamweaver Sites
Tutorials: Setting up your site and project files (make sure the "contents" tab is selected)

THEN, read the FAQs on the MAMP Web site.

If you put in a half-hour by reading the help files, you should be able to answer these questions yourself.