Let Us Share

 Greetings, I had run an e-learning platform between Aug 2020 and Aug 2021. The courses provided in my platform are now converted to e-books and are available for sale. Click here to know more details and buy these ebooks E-Book: 1 Title: Learning Web Design - HTML5 (A Practical Handbook) ISBN:  978-93-5607-098-1 E-Book: 2 Title:  Learning Relational Database (A Comprehensive Book on SQL) ISBN:  978-93-5607-713-3 E-Book: 3 Title:  Learning Server-Side Scripting (An Implementation Book on PHP-MySQL) ISBN:  978-93-5620-360-0 I have authored 2 Fiction novelettes. They are published in Tamil language. You can see my other blog's post for details: https://sanliya.blogspot.com/2022/10/my-fiction-novelette-in-tamil.html

When you want to learn a specific programming language, you need to install the compiler / software in your system. Learning syntax will not help you in mastering a language. Rather, coding what you learn will improve your skill in many aspects. If you are in the run to learn Python, then make use of this post to know how to install it. The post is specific to Windows Operation System. This post will cover: Steps to Install Python How to start working with Python? How to Uninstall? Steps to Install Python: 1. Download python installer for windows from https://www.python.org/downloads/     Make sure you download the version which is compatible with your OS version. 2. Double-click the installer 3. Check Add Python 3.9 to Path  4. You have two options: Install Now and Custom Installation      Choose Custom Installation (if you wish to change install location) 5. Click Next and you can change install location 6. You can check the advanced options as to your pr...

In order to work with PHP, we will need the PHP application. But in order to test the PHP content, we will need a server in our system. We will use AMPPS solution stack to install both PHP and Apache Server in our system. What is a solution stack? A solution stack is set of applications bundled together. Those applications need not be installed separately but as a whole through the installer provided. Additionally, you will have MySQL service also installed to develop applications connecting to the database. Why choose AMPSS? Installers for Windows, MAC and Linux are available Where to download?   https://www.ampps.com/downloads Installation: 1. Download the installer file concerned to the OS of your system 2. Run the installer 3. You will now see a list of screenshots to proceed  4. The installation done above is in the path - F:\Ampss 5. Once you click Finish, Ampps stack starts and you will see a pop-up win...

This post will describe how to install MySQL Server in Ubuntu platform. This installation is general irrespective of Ubuntu version. (It has been tested in Ubuntu 18.04.2) 1. Open terminal window in Ubuntu 2. Enter the following commands one by one:    Command-1: sudo apt-get update    Command-2: sudo apt-get install mysql-server    Command-3: sudo systemctl status mysql   ( type 'q' to quit )  (This command varies with version)    Command-4: sudo mysql_secure_installation    Follow the steps and supply password when asked for. 3. Installation is complete. Open MySQL Server using the command:     If you have not provided password for the root account during the previous step, use:      sudo mysql -u root -p         If you have set a password, use:         sudo mysql -u root -p  password_you_provided You are now read...

This post will describe how to install the latest version of MySQL Server on Windows platform. Download: 1. Go to  https://dev.mysql.com/downloads/mysql/ 2. Click Go to Download Page in MySQL Installer for Windows (Recommended Download part)     You will be taken to  https://dev.mysql.com/downloads/windows/installer/8.0.html 3. Download the second file  mysql-installer-community-8.0.19.0.msi  Installation: MySQL provides a single installer for windows with multiple set up options. 1. Double-click the msi installer file. 2. After installation of MySQL Installer - Community, a pop-up shows up as below: 3. Choose Server only set up type. We are going to work with mysql terminal window. Click Next. 4. Click Execute 5. Once the status is complete, click Next 6. Click Next to get inside Product configuration 7. Choose Standalone MySQL Server and click Next 8. Make sure the Config Type is Deve...

Greetings, This post is about adding / displaying / deleting records from MySQL using PHP scripting. It doesn't use client side scripting language. Database: Create a database in the name of 'sample'. Use the following code to create table: CREATE TABLE IF NOT EXISTS `sample_data` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(50) NOT NULL, `emailid` varchar(50) NOT NULL, `address` varchar(200) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; PHP file: index.php Configure your database username and password accordingly. It displays from latest insertion. 6 records can be viewed  as such and the rest can be viewed using the scroll bar. For easy understanding i have not used any css. <html> <head> <title>Add and Delete DB record from single page</title> </head> <body> <?php $dbcon = mysql_connect('localhost','roo...