Posts

MVC directory and Database Structure in CRUD Project

Image
In this part, we will take a look at the project's directory structure and database structure. In the overall project, we are going to use Sublime Text 3 as an editor and Xampp server for the database and run the application. So I hope you have installed them in your system. As we have CodeIgniter running successfully in our system. We need to create the below files in the directory. You can see how many files we have in controllers, models, and views directory. Now we need to add a database table in MySQL. Open PHPMyAdmin and go inside the created database. Here you need to open SQL editor from your database. Create tables and insert values as given in the below query. Table structure for table product  CREATE TABLE product ( p_code varchar(255) NOT NULL, p_category varchar(255) DEFAULT NULL, p_party varchar(255) DEFAULT NULL, p_rate varchar(255) DEFAULT NULL, p_type int(11) NOT NULL, in_purchase float NOT NULL, in_sold float NOT NULL, ...

CRUD Application with Session in PHP Framework CodeIginter - 3

Image
Here we are going to develop an application with CRUD operation where we will maintain user login and logout session. Please go with end to end in all videos of the videos for the proper detailed application flow. Dashboard Snapshot as below for CRUD Application: Here we are going to this project in 11 parts, the same youtube videos link will be shared with you. Application Overview which we are going to develop. Download CodeIgniter 3 and Xampp Server. MVC Directory and Database structure. User Login and Logout with the session. Register user. Account Page with header user info. Add a new Product. Get all products on Account Page. Edit Product. Delete Product. Add logger in Application. Please find the Youtube video link below for Part 1 and Part 2. As we have only application Overview and Setup part in that. Part 1: Application Overview - CRUD Application with Session in CodeIgniter 3 Part 2: Download CodeIgniter 3 and Xampp Server

SQLite Database CRUD Operation in Ionic 4

Image
Student Management Application:  SQLite Database CRUD Operation in Ionic 4 Let's start with this project. Install node.js in your system Go to link -  https://nodejs.org/en/  and install the latest version of ndoe.js After installing,    Check npm is working properly using the Command Prompt -    C:\Users\admin> npm -version    6.10.2 Install Ionic in your system Open Command Prompt and run below command.   npm install -g ionic Run below command before going ahead.   ionic start sqlLiteExample sidemenu   cd sqlLiteExample   ionic g service services/database   ionic g page pages/students   ionic g page pages/student   npm install @ionic-native/sqlite @ionic-native/sqlite-porter   ionic cordova plugin add cordova-sqlite-storage   ionic cordova plugin add uk.co.workingedge.cordova.plugin.sqliteporter You need a SQL script file to create a database and t...