WAMP & LAMP
MySQL is an open-source Enterprise level Database Management System (DBMS). It's the most popular DBMS with many more installations than Oracle, Microsoft SQL Server, and other similar systems combined.
1. Steps to install PHP 5.x on Windows as a development machine
This article details how to install PHP 5 on Windows as part of a WAMP development environment.
2. How to install Apache 2.x web server on Windows
This article illustrates step-by-step how to install Apache 2 web server on Windows as a development computer.
3. How to connect two different versions of MySQL server on the same computer
This article shows you how to access multiple versions of MySQL server from MySQL client tool SQLyog as well as how to access them by PHP.
4. How to configure MySQL server 5.1 on Windows
This article provides step-by-step server configuration guide for MySQL 5.1 on Windows as a development box. Assumed that you don't already have another instance of MySQL server installed on your PC.
5. How to install MySQL server 5.1 on Windows with screenshots
This article provides step-by-step installation guide for MySQL 5.1 on Windows as a development machine.
6. How to upgrade from PHP4 to PHP5
A project that I was working on recently required the use of PHP5 XML Dom extension, but I still had PHP4 running on my Windows development box and I needed to upgrade it to PHP5. After battling with it for a couple of hours, I finally got it up and running.
7. How to load time zone data for MySQL on Windows
MySQL provides developers with a rich set of Date and Time functions. One of the functions is CONVERT_TZ which converts a datetime value from one time zone to another. This function can use named time zones such as 'MET' or 'Europe/Moscow' from the time zone information tables in system database called mysql.
8. How to use Apache Virtual Host to run multiple local websites on Windows
With a little bit modifications in Apache's configuration file httpd.conf and Windows hosts file, you can set up and run multiple local websites on one Apache server in a WAMP environment.
9. How to install PEAR on your shared web hosting account
After you install PEAR on Windows for development use, you will eventually need to install it on your web hosting account for production use. There are two choices when installing PEAR.
Inside this article:
How to install PEAR on Windows
PEAR stands for PHP Extension and Application Repository, which is a collection of PHP reusable classes. Using PEAR can save you great amount of time to code something that other people already coded, tested, and used. For example, if you need a HTML form validation routine, PEAR has it in its Validate Package.
11. How to use PHP and Microsoft SMTP Virtual Server to send emails on Windows
IIS has a built-in SMTP Virtual Server that can be used by PHP mail() function to send emails. If you are connected to Internet, emails will be sent out. If your computer doesn't have Internet connection, you can still use it to send emails but instead actually sending out emails, they will be stored in C:\Inetpub\mailroot\Queue folder...
12. How to install PHP on Windows as part of WAMP installation
PHP, which stands for "PHP: Hypertext Preprocessor" is a widely-used Open Source general-purpose scripting language that is especially suited for Web development. Its syntax draws upon C, Java, and Perl, and is easy to learn. The main goal of the language is to allow web developers to write dynamically generated webpages quickly, but you can do much more with PHP.
13. Step by step guide on how to install Apache web server on Windows
This article illustrates step by step guide on how to install Apache web server on Windows as a development computer. Apache 1.3 was used for installation. Detailed configurations are included.
14. How to install two different versions of MySQL server on the same PC
A computer can run more than one instance of MySQL server with different versions. This article provides a step-by-step server configuration guide for MySQL 4.1 (release 4.1.18) on Windows as a development box when there is already another instance of different version of MySQL server installed.
15. How to configure MySQL server 4.1 on Windows
This article provides step-by-step server configuration guide for MySQL 4.1 (release 4.1.18) on Windows as a development box. Assumed that you don't already have another instance of MySQL server installed on your PC.
16. How to install MySQL server 4.1 on Windows with screenshots
This article provides step-by-step installation guide for MySQL 4.1 (release 4.1.18) on Windows as a development machine. Other releases of MySQL which are higher than 4.1 should have similar installation process.
17. How to set up MySQL DSN in ODBC Data Source Administrator on Windows
You can use ODBC Data Sources to access data stored in a variety of DBMS such as MS SQL Server, Oracle, MySQL, and many others. To access data in a ODBC-compliant DBMS database, you must add software components called drivers to your system. ODBC Data Source Administrator helps you add and configure these drivers.
18. How to export Northwind Access database to MySQL
In this article, we are going to export the popular Microsoft Access Northwind database to MySQL database by using MySQL ODBC Driver. After the migration, you will be able to use MySQL Northwind to explore the rich functionalities of working with MySQL.
Inside this article:
Copyright © 2013 GeeksEngine.com. All Rights Reserved.
This website is hosted by LunarPages.
No portion may be reproduced without my written permission. Software and hardware names mentioned on this site are registered trademarks of their respective companies. Should any right be infringed, it is totally unintentional. Drop me an email and I will promptly and gladly rectify it.