SQL _Queries Resource: https://balanced-quince-db1.notion.site/SQL-7347f5956fe347f887b4132c716cd236#17bc403a1add453db519621da47c1de3 Database queries CREATE DATABASE LOGICFIRST; -- creates a new database -- TO DELETE A DATABASE DROP DATABASE LOGICFIRST; DROP SCHEMA LOGICFIRST; -- same as above. u can use DATABASE Or SCHEMA DROP SCHEMA IF EXISTS LOGICFIRST; -- prevents error if db not found SHOW DATABASES; -- shows all the databases SHOW SCHEMAS; -- same as above. shows schemas/db USE SYS; -- uses this database for all further commands SHOW TABLES;-- shows all tables in the database being used Table - Create,Delete,Alter primary key - uniquely identifies a row in a table //creating a table CREATE TABLE student( id INT PRIMARY KEY, name VARCHAR(30), gpa DECIMAL(3,2) ); -- ----or----- CREATE ...
This part shows how to create authentication of web application using composer Jetstream. Step 1 : Install composer - JetStream CMD: composer require laravel/Jetstream Step 2: Install livewire for jetstream composer CMD: php artisan jetstream:install livewire Note: I nstall this cmd itself once the above process completed Step 3: Migration process Setup auth DB for admin and user identification in the User table define as utype will be ADM for admin and USR for customer and users. Step 4: Migrate table to SQL Database CMD: php artisan migrate Step 5: Run the project CMD:php artisan serve Step 6: Check the Authentication part to route correspondent user or admin login credential. Step 7: Setup middleware CMD: p hp artisan make:middleware AuthAdmin Note: Start Setup below code in c...
Comments
Post a Comment