PHP Laravel Inline CRUD Using jQuery and AJAX – Technology
In this post we will give you information about PHP Laravel Inline CRUD Using jQuery and AJAX – Technology. Hear we will give you detail about PHP Laravel Inline CRUD Using jQuery and AJAX – TechnologyAnd how to use it also give you demo for it if it is necessary.
Today, We want to share with you PHP Laravel Inline CRUD Using jQuery and AJAX.In this post we will show you Create Inline CRUD Using PHP, Laravel, jQuery and AJAX, hear for HTML5 Inline Editing with Laravel 5.7, MYSQL & jQuery Ajax we will give you demo and example for implement.In this post, we will learn about Inline Table Editing using jQuery Ajax Laravel and MySQL with an example.
PHP Laravel Inline CRUD Using jQuery and AJAX
There are the Following The simple About PHP Laravel Inline CRUD Using jQuery and AJAX Full Information With Example and source code.
As I will cover this Post with live Working example to develop jQuery AJAX Inline CRUD with PHP Laravel, so the jQuery AJAX Inline CRUD using PHP Laravel MySQL for this example is following below.
Phase 1 : Install Laravel Application
Simple HTML5 Inline Editing with Laravel 5.7, MYSQL & jQuery Ajax
Laravel 5.7 version application using bellow composer command
composer create-project --prefer-dist laravel/laravel system_project
Phase 2: MySQL .env files Database Configuration
database configuration in Laravel env files
.env
DB_CONNECTION=mysql DB_HOST=127.0.0.1 DB_PORT=3306 DB_DATABASE=MyDBNAme DB_USERNAME=DATABASE_USERNAME DB_PASSWORD=MY_DATABASE_PASSWORD
Phase 3: Make a productlist Table and Model
make a Laravel migration for productlist table using Laravel 5.7
Table Name : productlist
php artisan make:migration create_productlist_table
List of all Google Adsense, VueJS, AngularJS, PHP, Laravel Examples.
database/migrations
<?php
use IlluminateSupportFacadesSchema;
use IlluminateDatabaseSchemaBlueprint;
use IlluminateDatabaseMigrationsMigration;
class CreateTagslistTable extends Migration
{
public function up()
{
Schema::create('productlist', function (Blueprint $table) {
$table->increments('id');
$table->string('name');
$table->timestamps();
});
}
public function down()
{
Schema::dropIfExists('productlist');
}
}
run simple Laravel commands migration
Make a Laravel 5.7 migration and Model
php artisan migrate php artisan make:model ProductList
app/ProductList.php
<?php
namespace App;
use IlluminateDatabaseEloquentModel;
class ProductList extends Model
{
public $table = "productlist";
public $fillable = ['name'];
}
Phase 4: Define Laravel Routes
routes/web.php
Route::get("multipleInptFrm","[email protected]");
Route::post("multipleInptFrm","[email protected]");
Phase 5: Create ProductController
create new controller as ProductController
php artisan make:controller ProductController
app/Http/Controllers/ProductController.php
<?php
namespace AppHttpControllers;
use IlluminateHttpRequest;
use AppProductList;
use Validator;
class ProductController extends Controller
{
public function moreAddData()
{
return view("moreAddData");
}
public function moreAddDataPost(Request $request)
{
$rules = [];
foreach($request->input('name') as $key => $value) {
$rules["name.{$key}"] = 'required';
}
$validator = Validator::make($request->all(), $rules);
if ($validator->passes()) {
foreach($request->input('name') as $key => $value) {
ProductList::create(['name'=>$value]);
}
return response()->json(['success'=>'done']);
}
return response()->json(['error'=>$validator->errors()->all()]);
}
}
Phase 6: Make a Laravel Blade File
resources/views/moreAddData.blade.php
<!DOCTYPE html>
<html>
<head>
<title>Inline Table Editing using jQuery Ajax Laravel and MySQL - onlinecode</title>
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" />
<script src="//ajax.googleapis.com/ajax/libs/jquery/1.12.4/jquery.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js"></script>
<meta name="csrf-token" content="{{ csrf_token() }}">
</head>
<body>
<div >
<h2 align="center">Laravel - HTML5 Inline Editing with Laravel 5.7, MYSQL & jQuery Ajax</h2>
<div >
<form name="product_name_add" id="product_name_add">
<div style="display:none">
<ul></ul>
</div>
<div style="display:none">
<ul></ul>
</div>
<div >
<table id="dynamic_field">
<tr>
<td><input type="text" name="name[]" placeholder="Enter your Name" /></td>
<td><button type="button" name="add" id="add" >Add More</button></td>
</tr>
</table>
<input type="button" name="submit" id="submit" value="Submit" />
</div>
</form>
</div>
</div>
<script type="text/javascript">
$(document).ready(function(){
var postURL = "<?php echo url('multipleInptFrm'); ?>";
var i=1;
$('#add').click(function(){
i++;
$('#dynamic_field').append('<tr id="row'+i+'" ><td><input type="text" name="name[]" placeholder="Enter your Name" /></td><td><button type="button" name="remove" id="'+i+'" >X</button></td></tr>');
});
$(document).on('click', '.btn_remove', function(){
var button_id = $(this).attr("id");
$('#row'+button_id+'').remove();
});
$.ajaxSetup({
headers: {
'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
}
});
$('#submit').click(function(){
$.ajax({
url:postURL,
method:"POST",
data:$('#product_name_add').serialize(),
type:'json',
success:function(data)
{
if(data.error){
displayMessageError(data.error);
}else{
i=1;
$('.dynamic-added').remove();
$('#product_name_add')[0].reset();
$(".message-display").find("ul").html('');
$(".message-display").css('display','block');
$(".message-errors-display").css('display','none');
$(".message-display").find("ul").append('<li>Record Inserted Successfully.</li>');
}
}
});
});
function displayMessageError (msg) {
$(".message-errors-display").find("ul").html('');
$(".message-errors-display").css('display','block');
$(".message-display").css('display','none');
$.each( msg, function( key, value ) {
$(".message-errors-display").find("ul").append('<li>'+value+'</li>');
});
}
});
</script>
</body>
</html>
run command
php artisan serve // open bellow URL http://localhost:8000/multipleInptFrm
Angular 6 CRUD Operations Application Tutorials
Read :
- Technology
- Google Adsense
- Programming
Summary
You can also read about AngularJS, ASP.NET, VueJs, PHP.
I hope you get an idea about PHP Laravel Inline CRUD Using jQuery and AJAX.
I would like to have feedback on my onlinecode blog.
Your valuable feedback, question, or comments about this article are always welcome.
If you enjoyed and liked this post, don’t forget to share.
Hope this code and post will helped you for implement PHP Laravel Inline CRUD Using jQuery and AJAX – Technology. if you need any help or any feedback give it in comment section or you have good idea about this post you can give it comment section. Your comment will help us for help you more and improve us. we will give you this type of more interesting post in featured also so, For more interesting post and code Keep reading our blogs