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)…
Category: Database
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…
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…
Run Oracle 21c Home Page from the browser
Some settings need to configure to run oracle 21c home page from the browser. After completing the installation of oracle 21c, do the followings tasks…
How to make HTML template dynamic using Reactjs, PHP and MySQL
Steps:1. Before starting this tutorial, you have to complete the previous tutorial that converts any HTML template into reactJS project. How you can make a…