Tutorial: Install a PHP Development Environment with Eclipse PDT, Apache 2.2, PHP 5, MySQL 5, and phpMyAdmin Using XAMPP Lite

Good Luck!

Subscribe to my most-recent-items feed and know when new tutorials are posted:

My Other Tutorials:

How to Install Ruby on Rails with Instant Rails and Create a Website Using JEdit and the Ruby Plugin

How to Install the Android SDK on Windows XP and Create an Application that Runs in the Cell Phone Emulator

Install Java on Windows XP and Learn the Basics of Java 6 using the NetBeans IDE

How to Create a Website with Datapod

Install Fedora 6 in VMWare on Windows XP and connect it to your network

Install Perl 5 on Windows XP and Get a Perl Hello World Running

Install Ubuntu 7.04 in VMWare on Windows XP and connect it to your network

Setup a PHP Development Environment on Windows XP With Apache, PHP 5, MySQL 5, SQLite, Eclipse, Subversion, PHPMyAdmin, and Datapod

Install OpenSuse 10.2 in VMWare on Windows XP and connect it to your network

T U T O R I A L

Install a PHP Development Environment with Eclipse PDT, Apache 2.2, PHP 5, MySQL 5, and phpMyAdmin Using XAMPP Lite

1. Install 7-Zip 2. Install XAMPP Lite 3. Install Java 4. Install Eclipse 5. Make PHP Page 6. Use phpMyAdmin 7. Access MySQL from PHP 8. Make Font Smaller 9. Code Assist Features 10. Templates 11. Other Eclipse Features 12. Debugging 13. Make Your Development Environment Portable

7. Access MySQL from PHP

We will now create a PHP page that reads information out of our MySQL database.

Right-click on test, choose New and PHP File.

post comment or question

Type in testMysql.php and click Finish .

post comment or question

Cut and paste the following code:.

$db = new MySQLi('localhost', 'root', '', 'mysql');
$sql = 'SELECT * FROM help_topic';
$result = $db->query($sql);

while($row = $result->fetch_object()) {
	echo '<div>' . $row->name . '</div>';
}

$db->close();

Karl K: One needs to save the changes (Ctrl-S), of course, before proceeding to the next step.

Bret W: And, of course, its "Copy" and paste... :)

drw0303: Nit picker... ;)

post comment or question

In your browser, go to http://localhost/webs/test/testMysql.php and you will see the output from the MySQL table.

drw0303: At this step I also get a 404, "The requested URL was not found on this server. If you entered the URL manually please check your spelling and try again." I can open phpMyAdmin from localhost with no problem. reply

drw0303: Never mind. It works best if you install xampplite and follow xampplite instructions. It's not too functional installing xampp and following xampplite instructions. <oye vey!> reply

post comment or question

Go to the next section:

8. Make Font Smaller