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

My eBooks on Amazon.com



Subscribe to our mail list to receive free code examples.

Comments

No comments yet.

Add Comment

* Required information
(never displayed)
 
Smile Sad Huh Laugh Mad Tongue Crying Grin Wink Scared Cool Sleep Blush Unsure Shocked
 
1000
Enter the last letter of the word satellite.
 
Enter answer:
Captcha
Refresh
 
Enter code:
 
Notify me of new comments via email.
 
Remember my form inputs on this computer.
 
I have read and understand the privacy policy. *
 
I have read and agree to the terms and conditions. *
 
 
Powered by Commentics