Category : MySql

ItSolutionStuff.com have tutorials for MySql, here you can study articles of MySql, MySql posts collection, most popular and useful tutorials of MySql, here you can find list of all relevant posts and example about MySql, we have lists of tutorials and examples about MySql.very simple and quick example collection of Latest MySql category.



PHP Codeigniter 3 Ajax Pagination using Jquery Example

Are you looking for ajax pagination in codeigniter 3 app?, If yes then here i write step by step tutorial about php codeigniter ajax pagination from starch. As we know, we love jquery and everyone wants to add jquery ajax code on his site. Because it saves time and ignores too much loading. without jquery ajax you have to load every time page, but if you use jquery ajax then it just loads data without loading the whole page. So in this example, I created the "posts" table and then add some dummy records on it. Then display all the data using ajax pagination. You have to just follow a few s.....

By Hardik Savani | August 2, 2018 | | 1872 Viewer | Category : MySql
READ MORE

How to Delete Multiple Rows using Checkbox in Codeigniter 3?

In this post, I would like to share with you how to delete multiple records using a checkbox in Codeigniter application. we will jquery ajax for remove multiple rows in CodeIgniter. we always add delete button our listing page, but if you have thousands of records and you added some wrong rows data then it can take time to remove one by one row from a database table. So at that time if you add delete multiple records using checkbox then you have to just select checkboxes and remove at a time. In this example, we will create "items" table with title and description column. Then we will simply.....

By Hardik Savani | July 14, 2018 | | 2754 Viewer | Category : MySql MySql
READ MORE

Dynamic Dependent Dropdown using VueJS and PHP

Generally, Dynamic Dependent Select Box is used for auto-populate a dropdown list on Dependant data. When you select one drop-down box value it will retrieve new Dependant data from database table. mostly you see for a country, state and city table. When you select country then the state will fill on select box option of the selected country. Same as for city. As we know this task can perform using jquery ajax, without jquery ajax we cannot perform because we have to update select box value on based on change event. So, in this post we will create Dynamic Dependent Dropdown using vue js and .....

By Hardik Savani | July 14, 2018 | | 3131 Viewer | Category : MySql
READ MORE

Laravel Multi Language Translation using lang() Helper Tutorial

We almost project require to add multi-language support like we can change the language in our blog or website on the front end. Laravel also provide localization helper like trans(), lang() etc for multiple language support. So if you require basic translation like label changes and title etc then you should have to use laravel default localization. Laravel also provide to manage with json. you can easily change language using language code. So, in this tutorial, i would like to show you how we can manage in back-end side in laravel 5.6 and how you can use it. i will create languages table .....

By Hardik Savani | June 29, 2018 | | 3965 Viewer | Category : MySql
READ MORE

PHP - Dynamic Drag and Drop table rows using JQuery Ajax

As we know, dynamic sorting or drag and drop list items or div or table rows, it's amazing things for client or any user to understand flow. If you create sorting with drag and drop able table rows or div for your product then it's awesome. So, in this post. i would like to share with you how to create drag and drop table rows using jquery ui and also we will make it dynamic using php. so basically we will save data into database using jquery ajax. In this example we will use bootstrap for just make it better layout. we require to use jquery ui for make sortable table row. we will use cdn js.....

By Hardik Savani | June 23, 2018 | | 6473 Viewer | Category : MySql
READ MORE

Laravel 5 - Follow Unfollow System Example

Hi Guys, Today I have a special tutorial for you developer, I would like to share with you how to implement a follow and unfollow system with PHP Laravel and MySQLi like Twitter and Facebook. So basically, a user can follow unfollow another user and you can see which users following you and how many followers you have. So, in this post. I will explain you step by step create follow system in laravel 5.6 application. we will use "overture/laravel-follow" composer package for following a system. we will create users table and user authentication using laravel auth. then a user can log in and se.....

By Hardik Savani | June 16, 2018 | | 7383 Viewer | Category : MySql
READ MORE

PHP Codeigniter 3 - Jquery Ajax Autocomplete Search using Typeahead

In this post. i will explain how to create step by step dynamic autocomplete using typeahead js ajax in codeigniter application. we will take simple bootstrap text box and make it dynamic real time search using typeahead jquery ajax in codeigniter application. As we know, codeigniter is famous framework of php. Also typeahead.js a flexible javascript library that provides a strong foundation for autocomplete search. so if you require to create autocomplete from database then you have to use typeahead library that make better ui too. Also you can simply customize easily. For this example, we .....

By Hardik Savani | June 13, 2018 | | 9011 Viewer | Category : MySql
READ MORE

PHP Laravel 5 - Like Dislike System Tutorial

we may sometime require to create like and dislike functionality for your posts, tutorials, articles, products etc in your laravel 5.6 application like on facebook, twitter, google etc. here i will show you how to build ajax realtime like unlike system in laravel 5.6 application. In this tutorial, we will integrate like system from scratch and step by step so you can understand and learn how it works. it is very simple and easy way to create like a system in laravel. we will use overtrue/laravel-follow composer package for like dislike system in laravel. So basically here we will create use.....

By Hardik Savani | May 29, 2018 | | 10386 Viewer | Category : MySql
READ MORE

JQuery Ajax Request Example in Codeigniter

In this post, i would like to share with you how to send ajax post request with data to codeigniter controller example. Here in full example we will also check for ajax request using is_ajax_request and send post request using jquery. jQuery Ajax methods really made easy to post or get a data and return that data without refreshing the page. it's really amazing. We will apply this jQuery Ajax post in CodeIgniter 3 project. So it will help you to make better codeigniter project. So, in this article we will create new table "items" and then we simple list out that column in view file. then wi.....

By Hardik Savani | May 9, 2018 | | 12491 Viewer | Category : MySql
READ MORE

Laravel 5 - MongoDB CRUD Tutorial

today, most of the developer choose mongodb as database, because it takes less memory to store data and the very simple way we can use it. Laravel is also more popular in today's market. So in this tutorial, I would like to share with you Laravel 5.6 with MongoDB CRUD operation. here we will use mongodb as database and create insert update delete and view of books with Laravel 5.6. We will use "jenssegers/laravel-mongodb" composer package for creating CRUD(create read update and delete). using this package we can use collection, where, first, all, get, take, orWhere, whereIn, whereBetween, w.....

By Hardik Savani | May 4, 2018 | | 13563 Viewer | Category : MySql
READ MORE