Tag : MySql


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 | | 3527 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 | | 3499 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 | | 3273 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 | | 2072 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 | | 605 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 | | 6341 Viewer | Category : PHP Laravel Javascript Bootstrap jQuery MySql Ajax
READ MORE

Simple Highcharts Chart Example using PHP MySQL Database

Highcharts is a one type js library, that provide to populate bar chart, line chart, area chart, column chart etc. Highcharts library also provide several theme and graphic design that way you can make better layout. Highcharts is a very popular and simple library for php developer. We can simply use it in our code PHP project and other php framework like laravel(<a href="http://itsolutionstuff.com/post/how-to-add-charts-in-laravel-5-using-highcharts-example.html" target="_blank">How to add charts in Laravel 5 using Highcharts ?</a>), codeigniter, symfony, cakephp etc. In this post, we are le.....

By Hardik Savani | December 20, 2016 | | 3767 Viewer | Category : PHP Bootstrap MySql JSON Highcharts
READ MORE

How to get filename from file path in MySQL?

Sometimes we require to get filenames from path of table column in MySQL. If you are working on PHP then you can simply use basename() pre-define function of code PHP, But in MySQL you can't use basename() in select query. This mysql function you can use in code PHP, PHP framework like laravel, codeigniter etc. However, you can get simply filename or image name from path using SUBSTRING_INDEX() of MySQL. You can extract filename from path using substring_index(), substring_index() take three argument, first for column name, second for split string chat, and third get last element from split. .....

By Hardik Savani | November 30, 2016 | | 576 Viewer | Category : PHP MySql
READ MORE

PHP - import excel file into mysql database tutorial

In this post, i going to explain how to import excel file into mysql database using PHP. In this post i will give you full example of csv file, ods file, xls file, xlsx file import into database using phpexcel package. We always require to add data from admin panel like products, items, users, emails etc. If we have few records and require to add manually then it is ok, But if we have more data on excel file or csv file then it take long time to store data, At that time we can use direct import xls file or csv file into mysql database. So, In this tutorial i am using Spreadsheet_Excel_Reade.....

By Hardik Savani | November 27, 2016 | | 1931 Viewer | Category : PHP Bootstrap MySql
READ MORE

PHP Script - Login with Facebook using facebook-php-sdk and MySQL example with demo

In this post, I am going to share with you How to integrate login with facebook in PHP website using Facebook Graph API. In Website normally registration form for sign up, But users are not interested to filling the big registration forms. So you can implement login or register with facebook login, users don't require to fill big form. This tutorial will help to implement login with facebook in your PHP project. In this step by step post, i give you example of sign in with facebook account from scratch. In this example facebook account details will get and store it on MySQL database. After .....

By Hardik Savani | November 11, 2016 | | 2969 Viewer | Category : PHP Bootstrap MySql
READ MORE

    Solved - opencart this merchant is not enabled for auth/settle

    Solved - opencart this merchant is not enabled for auth/settle

    Open Post

    Laravel 5 - Multiple markers in google map using gmaps.js

    Laravel 5 - Multiple markers in google map using gmaps.js

    Open Post

    Laravel 5 - generate PDF from html view file and download using dompdf

    Laravel 5 - generate PDF from html view file and download using dompdf

    Open Post

    laravel 5.4 New Feature - Add eloquent whereKey method

    laravel 5.4 New Feature - Add eloquent whereKey method

    Open Post

    Laravel 5 - create quick backend admin panel tutorial

    Laravel 5 - create quick backend admin panel tutorial

    Open Post

    AngularJS - Display Default image if original image does not exists with example

    AngularJS - Display Default image if original image does not exists with example

    Open Post