FahmidasClassroom

AngularJS CRUD Operations using PHP and MySQL

The tutorial will help you to learn angularjs crud operation using php and mysql database. Steps: 1. Create a database named angularjs and table named users CREATE TABLE `users` ( `id` int (11) NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL, `email` varchar(100) NOT NULL, `phone` varchar(15) NOT NULL, `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `modified` […]

How to create one-to-one relationship in the database using Laravel

Create one-to-one relationship in the database using Laravel Steps: 1. Create a migration file for adding a new table profile php artisan make:migration create_table_profile 2. Add the following code in the up function Schema::create(‘profiles’, function(Blueprint $table) { $table->increments(‘id’); $table->integer(‘user_id’)->unsigned(); $table->foreign(‘user_id’)->references(‘id’)->on(‘users’)->onDelete(‘cascade’); $table->string(‘telephone’); $table->timestamps(); }); 3. Run the migrate command php artisan migrate 4. Add User Model […]

How to create one-to-many relation in database using Laravel

Applying one-to-many relationship in the database using Laravel Steps 1. Create a migration file for adding a new table students php artisan make:migration create_table_students 2. Add the following code in the up function Schema::create(‘students’, function(Blueprint $table) { $table->integer(‘id’)->primary(); $table->string(‘name’); $table->text(’email’); $table->string(‘course’); $table->boolean(‘done’)->default(false); $table->timestamps(); }); 3. Create a migration file for adding a new table subjects […]

Responsive Website Design using Bootstrap

Steps: Create Link for all necessary css and js files. <link href=”bootstrap.min.css” rel=”stylesheet”> <link href=”fonts.css” rel=”stylesheet”> <link href=”style.css” rel=”stylesheet”> <script src=”jquery.js”></script> <script src=”bootstrap.min.js”></script> You can get the script for fonts.css and style.css files from the following link. Fonts.css Style.css 2. Create the top menu <div class=”navbar navbar-fixed-top” role=”navigation” style=”background-color:white”> <div class=”container”> <div class=”navbar-header”> <button type=”button” […]

How to work with database in Laravel

Steps: 1. Create a MySQL database 2. Open the .env file and set the database connection 3. Run the following command to set project namespace php artisan app:name todoparrot 4. Create a model named todolist using the following command php artisan make:model Todolist 5. Open the migration folder and delete all existing file 6. Run […]

Create CRUD operation using Laravel

Steps: 1. Create a new Laravel Project 2. Install html package using Laravel composer require laravelcollective/html 3. Change app.php file Collective\Html\HtmlServiceProvider::class, ‘Form’ => Collective\Html\FormFacade::class, ‘Html’ => Collective\Html\HtmlFacade::class 4. Create a new view file welcome2.blade.php by Copying default welcome.blade.php file. 5. Replace the code of body with the following code, <div class=”flex-center position-ref full-height”> <div class=”content”> […]

CRUD Operation using PHP, MySQL and Bootstrap

Steps: 1. Create a table named `employee_basics` by running following SQL, CREATE TABLE `employee_basics` (`id` int(11) NOT NULL, `name` varchar(100) NOT NULL, `gender` varchar(6) NOT NULL, `address` varchar(255) NOT NULL, `phone` varchar(50) NOT NULL, `post` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`)); 2. Create a folder named phpCRUD in htdocs folder. 3. Download the following files […]

How to setup print option in Laravel

Steps: 1. Select any table with data from the database that you want use for printing. Here students table is selected from the database. 2. Create a controller named PrintController php artisan make:controller PrintController 3. Create a Course model for courses table php artisan make:model Student You can download or use the jquery print plugin from the following […]

ReactJS Installation

ReactJS is a popular JavaScript library that is used to build a single page website. Reusable UI component can be created by using reactjs. It creates a virtual DOM in the memory that makes the application faster. It changes the changes the content of the browser automatically when any modification is done. It is developed […]