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. | | Discuss Creating a VAMP (Vista, Apache, MySQL, PHP) Setup | | | | | | | The Official PHP Installer handles the PHP and Apache configuration automatically,... | | | | | | Unfortunately, the installer which works correctly and configures everything nicely... | | | | | | You can save a lot of time and install Apache, PHP, MySQL together in just a few... | | | | | | Absolutely, these can save hours. But where's the fun in using an automated... | | | | | | As noted, the automated installer does not work with Vista.Must be done... | | | | | | Thanks, I'm glad the article helped you get up and runningHappy coding =) | | | | | | A reader of the Article - Pamela - kindly pointed out several typo's on page 3 of... | | | | | | Hello I'm Doing This Article On Windows XP Home SP3(Upgrade), and I Can't Get MySQL... | | | | | | Never tried the installation on SP3 so hard to say if this is a factorMost of... | | | | | | While I wait on my registration email for this forum, I thought I would post a... | | | | | | Apologies for the delay in response, I just got back off vacation =)Did you use... | | | | | | This was my third attempt. After removing all evidence of the other attempts this... | | | | | | I'm glad the article was able to help, thanks for reading =) | | | | | | Hi,I have installed Apache 2.2, PHP 5 and MySQL 5 on Vista Ultimate. I have done... | | | | | | Are you using the correct password/user in your PHP page?Can you post your mySql... | | | | | | I created a testing table under the test db (which comes with mysql installation)... | | | | | | Hmmmm, if things weren't configured right, mysql wouldn't even show in... | | | | | | It works now. Thank you for your help very much. | | | | | | Hello sir,I found this tutorial best for vamp than others. i m trying to install... | | | | | | Did you try switching off your firewall, that seemed to help others (and I mean... | | | | | | hello everybody, I have already switched off firewall. then also... | | | | | | I tried for hours to install PHP so that it would work correctly with Apache &... | | | | | | Hi Vinay, ... | | | | | | Awesome! Glad the tutorial was able to help =) ... | | | | | | Yes i have used that directory for extension...even i m facing same problem...plz... | | | | | | Can you mail me your php.ini file so I can compare it to mine? danwellman @... | | | | | | Finally!! You have no idea how good it was to find out that "Name: Dan Likes: House... | | | | | | lol, awesome, well done for getting it going =)Thanks for the tips as well, it's... | | | | | | Thanks so much for the article. I ~was~ having a problem getting MySQL to speak to... | | | | | | Sorry, but I have 1 issiue with it, and I was hoping you can help me, ok, I have... | | | | | | Hi, sorry to hear you're having difficulties, the installation process can be... | | | | | | Thanks so much for this, I pulled it off without a hitch. Could you do a followup on... | | | | | | Excellent skills! Glad the article could help :DPHPMyAdmin would make a great... | | | | | | Thanks a bunch for posting all this useful info. This is exactly the configuration... | | | | | | Thanks Dan for such a clear set of instructions. I've struggled with my installation... | | | | | | I'm glad the article helped Jeff, well done for persevering and getting it working... | | | | | | Thanks very much for the article, it is very helpful. But one thing - can't the... | | | | | | I found this article very useful and followed the instructions right through and... | | | | | | This was an excellent article. For those people that have trouble with MySQL ensure... | | | | | | Dan the article was very informative been trying to get these three to work with my... | | | | | | Helen,Try turning off your firewall that's what did it for me during my... | | | | | | Hi Helen,Don;t worry, it can be tricky getting everything working correctly, but... | | | | | | Thanks again for reading everyone, I'm glad I could help you get things up and... | | | | | | Thanks for a great article, which has got me up and running in an evening!But, I... | | | | | | Hi,Many thanks for the article.I've been working to get MySQL support showing in... | | | | | | Hi. Thanks for the article you posted. Very informative. Unfortunately it does not... | | | | | | Ok, I have successfully installed Apache, PHP and MySQL. However, when i run... | | | | | | I followed your instructions exactly. I also have a Vista64. At the end could not... | | | | | | My VAMP install on Vista64 is working just fine. I now have the new Win7 64 upgrade... | | | | | | I'm not sure whether you will need to reinstall or not but I guess you would need... | | | | | | I need to know how to allow other computer on my LAN to access the database. I have... | | | | | | >>> Post your comment now! | | | | | |
|
 | |
| | | | | | | | |  | | | |