CRUD Operation using PHP, MySQL and Bootstrap
Steps:1. Create a database named php_crud and a table named `employee_basics` by running following SQL, CREATE TABLE `employee_basics` (`id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(100)…
Learn PHP with MySQL basics in an hour
PHP is a popular server-side programming language. The basics of the PHP programming with MySQL database have been shown in this tutorial by using XAMPP…
How to install XAMPP server on Windows
XAMPP is a popular software for learning web programming. All necessary tools to implement a web application are included in this software, such as Apache,…
Create procedure in Oracle
Procedure is used to execute the block of SQL statements multiple times in the database server. It works similar to the function or procedure of…
Create View in Oracle
View is a virtual table that is created from an existing database table. The way of creating, updating, and deleting view has been shown in…
Create auto-increment or auto-generated field in Oracle
The auto-increment attribute is used in the primary key field of the database table to increment the field automatically when any new record is inserted…
Third Normal Form (3NF) in Oracle
The concept of the third normal form (2NF) has been explained in this tutorial by using the Oracle database tables. Run the SQL Developer application…
Second Normal Form (2NF) in Oracle
The concept of the second normal form (2NF) has been explained in this tutorial by using the Oracle database tables. Run the SQL Developer application…
First Normal Form (1NF) in Oracle
The concept of the first normal form (1NF) has been explained in this tutorial by creating the tables in the Oracle database. Run the SQL…
How to send email using Gmail account
It is a common requirement to send email using any scripting language for the web application. The SMTP server of the Gmail account is commonly…