Tag : MySql


MySQL Query - How to select records of today to next Sunday ?

In this post, i am going to share with you how to get records of today to weekend by using mysql query. This is MySQL Query that you can easily use in your core PHP and PHP framework like Laravel, Codeigniter, cakephp etc project. If you require to get records this way, today is Tuesday and you need to get data from today to next Sunday that means Tuesday to Sunday. sometimes we require to fetch records from this way. It is not any predefine function for getting records this way but we can do it by using following MySQL pre-define function. <strong>1) date()</strong> <strong>2) now()</strong>.....

By Hardik Savani | March 24, 2017 | | 352 Viewer | Category : PHP MySql SQL
READ MORE

How to use Select with MySQL DATE_FORMAT() in Laravel?

We sometimes require to use MySQL pre-define function like sum(), date_format(), year(), month(), group_concat() etc. But laravel query builder not provide to directly use with select statement. However, we can use all the pre-define function of Mysql using DB::raw(). So, In this post i am going to share with you how to use date_format() in Laravel 5 Query Builder. date_formt() help us to change date format. We may sometimes require to change date format using mysql date_format(). In this example i have simple "users" table and there are some dummy users with created_at row with current time.....

By Hardik Savani | March 16, 2017 | | 2905 Viewer | Category : Laravel MySql
READ MORE

PHP - How to make dependent dropdown list using jquery Ajax?

In this post, i am going to share with you how to make dynamic dependent dropdown list using jquery ajax with php MySQL. In this simple example through we understand how to work dependent dropdown in core PHP even if you beginner. I also posted for php laravel framework <a href="http://itsolutionstuff.com/post/how-to-make-simple-dependent-dropdown-using-jquery-ajax-in-laravel-5example.html" target="_blank">How to make simple dependent dropdown using jquery ajax in Laravel 5?</a>. We sometimes require to make dependent dropdown like when state select at that time bellow city drop down list sho.....

By Hardik Savani | March 15, 2017 | | 2769 Viewer | Category : PHP Javascript Bootstrap HTML jQuery MySql
READ MORE

Laravel - How to search with comma separated values using Query Builder ?

Sometimes, we require to manage to take single column for multiple integer ids, for example if we have "posts" table and require to set multiple tags on each post, so at that time we can take just single column and store selected tags ids. this way will use less memory. It is simple to store data into row, but as you think how we can search or find specific tag id data from comma separated column value using laravel query builder. However, It is possible using <strong class="path">"find_in_set()"</strong> of MySql predefine function, We can use find_in_set() using whereRow() of laravel query .....

By Hardik Savani | March 2, 2017 | | 1523 Viewer | Category : Laravel MySql
READ MORE

Codeigniter 3 - CRUD(Create, Read, Update and Delete) using JQuery Ajax, Bootstrap, Models and MySQL

Today, i am going to share with you how to create CRUD Application with pagination using JQuery Ajax in Codeigniter 3. CRUD is a basic step of any Core Language or framework. CRUD stand for Create Read Update and Delete. So in this post we will learn insert update delete in codeigniter using jquery Ajax. I gave you example from scratch so if you don't know about Codeigniter 3 then no issue. You have to just follow simple step. There are listed bellow step you have to follow: <strong>1)Download Fresh Codeigniter 3</strong> <strong>2)Create Database and Configuration</strong> <strong>3)Add Ro.....

By Hardik Savani | February 19, 2017 | | 31630 Viewer | Category : PHP Bootstrap HTML jQuery MySql Codeigniter
READ MORE

PHP - Input multiple tags with dynamic autocomplete example

In this post i am going to give you the example of Add Multiple input tags with autocomplete from MySQL database table using typeahead bootstrap JS and tagmanager JS. Sometimes we require to make multiple input tags on our form. At that time we require to use jquery plugin for input multiple tags. But here we are going to use tagmanager.js plugin for add multiple input tags. I already added one simple tutorial for tagmanager.js here : <a href="http://itsolutionstuff.com/post/bootstrap-input-multiple-tags-example-using-tag-manager-jquery-pluginexample.html" target="_blank">Bootstrap - Input mu.....

By Hardik Savani | January 24, 2017 | | 7583 Viewer | Category : PHP Bootstrap HTML jQuery MySql Ajax
READ MORE

Laravel 5 - Dynamic Dependant Select Box using JQuery Ajax Example - Part 1

In this Tutorial, I am going to share with you how to make dynamic dependent dropdown box using Ajax like When i select category, then sub category select box value should be change. We can't do this stuff without ajax. So, in this Post i am going to give you full and very simple example of dynamic select box using change event of jquery. This article written in two parts, so it can be easy to understand and if you are beginner then also you can simply perform because this tutorial is from scratch. In this example i created two tables as listed bellow: <strong>1)countries</strong> <strong>2).....

By Hardik Savani | January 8, 2017 | | 6260 Viewer | Category : PHP Laravel Bootstrap jQuery MySql Ajax
READ MORE

Laravel 5 - Dynamic Dependant Select Box using JQuery Ajax Example - Part 2

<br/> After complete our fist part of Laravel 5 - Dynamic Dependant Select Box using JQuery Ajax Example, Now we have to do main task for Dynamic select box value. In this part we follow two step for create Controller File and Laravel Blade File. In this part we write code for how to manage controller method and how to give response them. So let's follow this bellow remaining two step of change drop down options on change of parent dropdown. So let's follow: <strong class="step">Step 5: Create Controller</strong> In this point, now we should create new controller as AjaxDemoController in th.....

By Hardik Savani | January 8, 2017 | | 6171 Viewer | Category : PHP Laravel Bootstrap jQuery MySql Ajax
READ MORE

MySql comma separated column join in PHP Laravel 5

If we work in big application or project of Laravel Framework, sometimes we require to manage column value into comma separated because we can save memory of database. But if we store comma separated value in column with ids then it's difficult to inner join or left join and get records from another tables. However, SQL provide FIND_IN_SET() for checking value one by one, that way we can also search from comma separated value. FIND_IN_SET() will help to join with tables and we can simply get data. In this post, I will give you full example of how to get data from comma separated column table.....

By Hardik Savani | January 7, 2017 | | 2725 Viewer | Category : PHP Laravel MySql SQL
READ MORE

Ajax Image Upload Example with Validation in PHP Laravel Framework

Today, I am going to show you How to image or file upload using jquery Ajax in our Laravel application. In this tutorial i explain step by step example code of ajax image upload using jquery form JS. As you know today, we have basic feature image or file uploading(<a href="http://itsolutionstuff.com/post/laravel-53-image-upload-with-validation-exampleexample.html" target="_blank">Laravel 5.3 Image Upload with Validation example</a>) on our PHP Project Or Laravel application. Client always want to store image for profile, products, items, users etc. Laravel provide very simple way to store tha.....

By Hardik Savani | December 28, 2016 | | 20483 Viewer | Category : PHP Laravel Javascript Bootstrap jQuery MySql Ajax
READ MORE

    CRUD (Create Read Update Delete) Example in Laravel 5.2 from Scratch

    CRUD (Create Read Update Delete) Example in Laravel 5.2 from Scratch

    Open Post

    Simple Example of Bootstrap Lightbox Plugin with demo

    Simple Example of Bootstrap Lightbox Plugin with demo

    Open Post

    Simple Add remove input fields dynamically using jquery with Bootstrap

    Simple Add remove input fields dynamically using jquery with Bootstrap

    Open Post

    Laravel 5 - Bootstrap Admin Theme Integration example from scratch

    Laravel 5 - Bootstrap Admin Theme Integration example from scratch

    Open Post

    Laravel 5 - Custom Helper Facade Class Example from scratch

    Laravel 5 - Custom Helper Facade Class Example from scratch

    Open Post

    Laravel 5 dynamic autocomplete search using select2 JS Ajax - Part 1

    Laravel 5 dynamic autocomplete search using select2 JS Ajax - Part 1

    Open Post