PHP Install Help

adavis

All I want to do is be able to test my scripts before I upload them to the live server. I am running Windows XP on my computer. This is what I've done:

downloaded all the latest of Apache, mySQL, PHP4 appropriate for my computer.

Installed mySQL, tested it, it worked

Installed Apache, tested it by calling up http://localhost/ , it worked

Unzipped and followed instructions for PHP4, manual install instructions:

Extracted Zip to c:\PHP\

Moved php.ini-dist to c:\windows\

Renamed php.ini-dist to php.ini

changed these setting in php.ini:

extensiotn_dir = c:\PHP

document_root = c:\Program Files\Apache Group\Apache2\htdocs

I did not uncomment any extensions per advise in the installation documentation at this time.

Now when I try to go to http://localhost/, I get the "The page cannot be displayed" page.

Any ideas of suggestions as to what I did wrong???

Thanks,
Alisa

bernouli

Now when I try to go to http://localhost/, I get the "The page cannot be displayed" page.

try to restart the apache server

adavis

I do remember now that I forgot to turn Apache back on. I'll try it when I get home and let you know if that fixed it.

adavis

Okay, so starting Apache helps if you want to run something.

Now, which extensions do I need to activate? I have .inc header and footer and I want to build and test file written to/read from the a mySQL database. I've got it all installed and running, Apache, mySQL, and PHP.

So, I think I remember that mySQL is built in, so don't have to activate that one. There must be one for includes, because mine are not showing up. Do I set

"safe_mode_include_dir = "

and/or

;Windows: "\path1;\path2"
;include_path = ".;c:\php\includes"

for this???

Thanks,
Alisa

wigz01

As you said, MySQL support is built in. There are no extensions that need to be installed. How are you testing your connection?

Are Apache and PHP working without MySQL?

adavis

I installed mySQL first and checked it per my instructions through the command line. I haven't gotten any further than that with mySQL. I tested that Apache was running by typing in http://localhost/ and getting the customary default Apache page. Then after installing PHP, AND turning Apache back on... I tried localhost again. It worked. Then I tried my php site which I stored in the appropriate directory. It worked, sort of. I have 2 .inc files, a header and a footer, which didn't show up, but the "guts" of the page did, so I feel pretty certain that I just have to set something in the .ini file. Hopefully I can try it when/if I get home from work tonight. 🙂 . I would more than welcome any suggestions since I'm not the admin type. I am learning though.

Thanks,
Alisa

wigz01

What you need to do next is create a database in MySQL either through the command line or with PHP. Then you could use this generic script to connect to your DB with PHP:

<?php
/ Connecting, selecting database /
$link = mysql_connect("localhost", "mysql user", "mysql password")
or die("Could not connect");
print "<b>Connected successfully</b><br><br>";
mysql_select_db("your DB") or die("Could not select database");

/* Performing SQL query */
$query = "SELECT * FROM table in your DB";
$result = mysql_query($query) or die("Query failed");

/* Printing results in HTML */
print "<table bgcolor=#000000 border=0 cellpadding=0 cellspacing=0><tr><td>";
print "<table border=0 cellpadding=2 cellspacing=1>\n";
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
    print "\t<tr>\n";
    foreach ($line as $col_value) {
        print "\t\t<td bgcolor=#cccccc width=50px align=center>$col_value</td>\n";
    }
    print "\t</tr>\n";
}
print "</table>\n";
print "</td></tr></table>";

/* Free resultset */
mysql_free_result($result);

/* Closing connection */
mysql_close($link);