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.



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 | | 2029 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 | | 3829 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 | | 5098 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 | | 7517 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 | | 8647 Viewer | Category : MySql
READ MORE

Laravel 5.6 - Dynamic Ajax Autocomplete using Vue.js

Today, we are going to learn ajax live search and autocomplete using vue js components in laravel 5.6 application. here we will create simple and nice example of autocomplete in vue.js using laravel api. we will use axios for getting records in vue js, so just follow this tutorial and get full example. As we know everybody is familiar with the concept of Ajax Live Search or Autocomplete for search. If you search on google, youtube or any other famous website, we can see like search with autocomplete. there are also available tools for autocomplete like jquery ui and Typeahead etc, but if you .....

By Hardik Savani | April 30, 2018 | | 69840 Viewer | Category : MySql
READ MORE

Confirm Box Before Delete Item in Codeigniter

We always require to add conformation box before delete mysql rows in our codeigniter 3 application. now what i will do, when user will click on delete button or link i want to pop up messages or jquery confirm box with message like "Are you sure want to remove this item ?" If user click Yes proceed to delete if click No nothing to do that's it. In this example we will create "items" table and two routes with GET and DELETE method. one route will list of all items and another for remove item. So basically we will also create one controller with two method. So it is very easy and simple to cre.....

By Hardik Savani | April 21, 2018 | | 9784 Viewer | Category : MySql
READ MORE

PHP AngularJS populate dynamic dropdown example

Sometime, we may need to create dynamic dropdown in our angular application using PHP or using API. here i will give you small example for populate dropdown dynamically from database using php mysql. you can simply create country state city drop down list using angular. Here, we will bind two select box state and city. so here we will create two tables called "demo_state" and "demo_cities". so here i will explain step by step. you need to just create two tables with bellow sql query and then add some dummy records. So let's follow bellow three step to complete full example. <strong class="s.....

By Hardik Savani | April 18, 2018 | | 8895 Viewer | Category : MySql
READ MORE

PHP and MySQL - Login with Google Account Example

In this post, i am going to share with you how to login / signin / signup with google account in PHP project. i will implement login with google account and store it in mysql database in PHP. in this example I will implement login with Gmail account on your website. In today's world as we know. social media is very important part of any website or blog. if you have a login with social media then it is more beneficial to get new users to your website. in this example, I will create one MySQL database with "users" table and then i will make login with google system using Google API library. So.....

By Hardik Savani | March 30, 2018 | | 11141 Viewer | Category : MySql
READ MORE

Multiple Database Connection in PHP Codeigniter 3

Today, I want to share with you how to connect multiple databases in PHP CodeIgniter 3 application. it is very easy to configure multiple databases in CodeIgniter app. you can simply add database query, join etc with multiple databases. As we know well, in today we may need to add multiple databases on our application. all then framework provides multiple database connections. Codeigniter also provide multiple database connections in a single app. We have to simply add database configuration array to database.php file. Then we can simple load specific database data by using "$this->load->dat.....

By Hardik Savani | February 27, 2018 | | 12475 Viewer | Category : MySql
READ MORE