Creating a VAMP (Vista, Apache, MySQL, PHP) Setup - Configuring
(Page 5 of 5 )
Now we need to configure PHP to use MySQL. Reopen php.ini in your text editor and find the Dynamic Extensions section (line 628). There should be a list of the different extensions currently in the ext folder. Find the line that reads ;extension=php_mysql.dll and remove the semi-colon from the start of the line. Save the file and restart your computer.
The output of the phpinfo() file will tell us whether PHP can see MySQL; just open up phpinfo.html in your browser again (requesting it properly from the server) and use "find on this page" to search for MySQL. You should see something like this:
To really test it we can create a file that will attempt to read data from the table we created earlier. In a blank page in your text editor add the following code:
<?php
mysql_connect("localhost", "root", "yourMySQLpassword") or die(mysql_error());
mysql_select_db("test") or die(mysql_error());
$query = mysql_query("SELECT * FROM people") or die(mysql_error());
while($data = mysql_fetch_array( $query )) {
Print "<p>Name: ".$data['name'] ."<br>" ."Likes: ".$data['likes'] . " </p>";
}
?>
Save this as mysqltest.php in the apache site folder and request the file from the server. The results should be something like the following page:
If you see the page correctly then everything works together as it should and everything is done. You can now enjoy the benefits of having your very own development web server. You should note however that this basic installation has not covered any security or optimization configuring, so you should absolutely not use this guide as a method to set up a live, publicly accessible web server.
| DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware. |
|
| · | | | · | | | · | | | · | | | · | | | · | | | · | | | · | | | · | | | · | | | · | | | · | | | · | | | · | | | · | | | · | | | · | | | · | | | · | | | · | | | · | | | · | | | · | | | · | | | · | | | · | | | · | | | · | | | | |
|
