Computer Programming web Web programming Tips



XAMPP Shell

By Sergey Skudaev


Using the XAMPP Shell

Download and install XAMPP, an easy to install Apache distribution containing MySQL, PHP, and Perl:

https://sourceforge.net/projects/xampp

Hover your mouse over an image to enlarge it. Click the image to make it small again.

xampp executable

Click the Shell button on the XAMPP control panel.

xampp shell show databases

Login to MySQL with the root user. View exiting databases with the "SHOW DATABASES" command.

xampp shell create user

Create a user "johns" with password "Password7@".

xampp shell grant permissions

Grant user with all privileges.

xampp shell grant permissions

Select a database with command "use " Show exiting tables.

xampp shell create table

Create a visitors table.

xampp shell insert

Insert a visitor´s record.

xampp shell update

Update the visitors record.

xampp executable

Display records from the visitord table.

xampp executable

Delete a visitor.

PHP links:

www.sitepoint.com

www.codetoad.com

www.phpfreaks.com

www.devx.com

www.phpbuilder.com

www.zend.com

Home