MAMP and XAMPPMAMP, WAMP, and XAMPP are the three best known general AMP installer packages. They respectively stand for "Macintosh Apache, MySQL & PHP", "Windows Apache, MySQL & PHP", and "Cross Platform (X) Apache, MariaDB, PHP & Perl". Both MAMP and XAMPP are cross-platform products, but XAMPP seems to be better suited for the Windows environment, and is generally easier to work with than WAMP. MAMP is still recommended for the Mac platform.
Both products are free and will install Apache, PHP, and MySQL (or MariaDB) on your machine. You will be able to use the installed Apache instance to view your webpages, run PHP scripts, and work with your database. Both products install phpMyAdmin, a PHP web application that provides a graphic user interface for MySQL or MariaDB. phpMyAdmin will allow you to create databases and tables, insert data, and run SQL scripts.
If you don't have one of these products installed on your computer, follow the link for your preferred platform. If you are already set up, proceed to the JAMS!