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.



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 | | 13724 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 | | 12558 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 | | 14762 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 | | 15984 Viewer | Category : MySql
READ MORE

Laravel 5.6 CRUD Application for Starter

Here, I would like to share with you basic crud(create, read, update and delete) application module in laravel 5.6 version. In this port i will show explain simple inert update delete application in laravel 5.6 project. You have to just follow bellow step to create CRUD app in laravel 5.6. Laravel is a popular open-source PHP MVC Framework with lots of advanced development features. Laravel released it's new version 5.6 as few days ago. If you are learner or beginner of crud example in laravel 5.6 application then you are a right place. It's always help to more understand or learn from crud a.....

By Hardik Savani | February 19, 2018 | | 55322 Viewer | Category : MySql
READ MORE

Codeigniter 3 Datatables Ajax Example From Scratch

Datatables is one of the best libraries for display data in tabular format and easily ajax search, sort, pagination etc. here I give you an example of CodeIgniter 3 with database ajax integration example. you can easily use jquery ajax datatables in your codeigniter project. This post is going to look at how you can implement datatables plugin into your CodeIgniter application. We will be grabbing some data from a database and then using Datatables' plugin to display it, allowing for ajax searching, sorting and pagination feature. I would like to give you very short and quick example, so you.....

By Hardik Savani | January 28, 2018 | | 22463 Viewer | Category : MySql
READ MORE

AngularJS - Add Remove Input Fields Dynamically with PHP MySQLi

today i would like to share with you how to implement add more add and remove textbox dynamically using angularjs with PHP. you can easily adding form fields dynamically and save in mysql database. If you require to add input fields dynamically in angular js using php mysql database then you are right place. here you will find full script for add remove input fields dynamically in angularjs and you can save it to mysql database. you have to just create following files. <span class="heads">1) index.php</strong> <span class="heads">2) main.js</strong> <span class="heads">3) get_data.php</strong.....

By Hardik Savani | January 14, 2018 | | 17936 Viewer | Category : MySql
READ MORE

Laravel 5 - Simple CRUD Application Using ReactJS - Part 1

In this post, i want to share with you how to create crud(Create Read Update Delete) application with react js in PHP Laravel framework. In this example you can learn how to built setup for laravel reactjs application, I also used axios post request, get request, put request and delete request for insert update delete application. we always would like to prefer make setup for any javascript framework like vuejs, angularjs, reactjs etc. here i share with you basic setup for react and laravel with crud application. You have to just follow following 9 step as listed bellow: <strong>1) Step 1 : I.....

By Hardik Savani | December 10, 2017 | | 54462 Viewer | Category : MySql
READ MORE

Laravel 5 - Simple CRUD Application Using ReactJS - Part 2

In the second link, we will follow rest of two step for react js crud tutorial application example. So let's start to follow 2 step in this tutorial page for laravel react native and here we will generate components file for react server side rendering. <strong class="step">Step 6 : Install Configuration For ReactJS</strong> First things is we need to configure our react app, So we need to run following bellow path for React Preset. <pre class="prettyprint lang-php"> php artisan preset react </pre> Next we need to run following command for install node js so let's run bellow command: <pre cl.....

By Hardik Savani | December 10, 2017 | | 38445 Viewer | Category : MySql
READ MORE

Laravel 5 - Simple CRUD Application Using ReactJS - Part 3

In last part, we will create view blade file and run our react js crud application, we used axios for run apis. So let's follow rest of two step. <strong class="step">Step 8 : Create Main Blade File</strong> in this step. In this step we have to create just one main blade. So mainly we have to create layout file. So finally you have to create following bellow blade file: <strong>resources/views/welcome.blade.php</strong> <pre class="prettyprint lang-html"> <!DOCTYPE html> <html> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" co.....

By Hardik Savani | December 10, 2017 | | 26913 Viewer | Category : MySql
READ MORE