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.



How to delete multiple records using checkbox in Laravel 5 ?

It's almost need to give feature for remove multiple records using checkbox, if you are developing e-commerce application or any big web application then you must give feature to delete multiple records. So in this post, i will let you know how to delete multiple records with checkbox in laravel 5 application. here i also give multiple delete and you can also delete single records. Few days ago i posted for confirmation before delete record, so you can read from here : <a href="http://itsolutionstuff.com/post/laravel-5-confirmation-before-delete-record-from-database-exampleexample.html" targ.....

By Hardik Savani | July 18, 2017 | | 68169 Viewer | Category : MySql
READ MORE

PHP MySQL contact us form with validation using Bootstrap

Today, i am going to share with you how to create custom contact form in PHP and store in mysql database. You can simply create enquiry form or feedback form with validation using bootstrap design. Contact US Or Feedback form is a very basic feature of every website because that way customer can contact to website administrator for enquiry or give feedback about the website. So if you are beginner of php language then it's become more useful to you and also if you want to make quick contact us form in your core php project then you are a right place. So, now you have to simply follow some fe.....

By Hardik Savani | July 16, 2017 | | 31035 Viewer | Category : MySql
READ MORE

Laravel 5 - Confirmation before delete record from database example

Hi Guys, In this post we will learn how to open confirm model box before deleting item in laravel 5 application. As we know very well delete operation is very command and basic feature of every web application. Also delete operation is very important part because if you remove item, post, product, category etc then it will remove from your browser. So we should always prefer to confirmation before remove item. There are several options available to use confirm like jquery ui confirm, sweetalert, bootbox, bootstrap confirmation etc jquery plugin. So we almost use bootstrap theme so it would al.....

By Hardik Savani | June 29, 2017 | | 76660 Viewer | Category : MySql
READ MORE

jQuery Ajax X-editable bootstrap plugin to update records in PHP Example

X-editable is jquery powerful plugin and it's allows you to create editable elements on your page using jquery ajax. X-editable library you can use with only bootstrap, jquery-ui and jquery. X-editable provide us edit inline element using text box, textarea, select, date, datetime, dateui, wysihtml5, select2, typeahead etc. X-editable plugin also provide client side validation. X-editable is giving you good layout if you are using with bootstrap. In this example we will use X-editable with bootstrap plugin. In this post, i will share with you how to update records using jquery ajax with PHP .....

By Hardik Savani | June 27, 2017 | | 42106 Viewer | Category : MySql
READ MORE

How to integrate jQuery Fullcalendar using Bootstrap, PHP and MySQL ?

Today, i would like to share with you integration of jquery full calendar events crud operation using bootstrap, php & mysql example. Fullcalendar is jquery library that provide us to display calendar with events and more. Fullcalendar js provide year, month, week and day calendar for displaying and it amazing with drag & drop events management. If you are working on event management, task management or any thing that related date to date, at that time if you use event calendar like fullcalendar then it's better. In this example we will create "events" table in mysql database and create cru.....

By Hardik Savani | June 16, 2017 | | 129392 Viewer | Category : MySql
READ MORE

How to create ban/revoke user functionality in Laravel 5 example ?

In this tutorial, i am going to share with you how to create user block and unblock feature in your laravel 5 application using laravel-ban composer package. It will mostly require to create user ban and revoke functionality for security reason. If you are developing big web application then it must be require to enable and disabled user when admin user want. Because some user make in-activity on our website then we could ban that user. So basicaly it is good if you are give user ban and revoke functionality to client on your laravel 5 application. In this article, we will learn how to make .....

By Hardik Savani | June 14, 2017 | | 26868 Viewer | Category : MySql
READ MORE

PHP MySQL - Simple Image Gallery CRUD example from scratch

Today we will learn how to create simple image gallery crud using bootstrap, mysql database, fancy box and PHP. We will create example from scratch so it will be easy to get full script example. Sometimes, we almost require to create image gallery or insert update and delete module for user, employee, admin, students etc. Photo album will help to easily upload image and remove that with proper validation. So we always want to built good bootstrap layout with image gallery. However in this tutorial, we will make photo gallery from scratch with good layout that way you can simply built it with .....

By Hardik Savani | June 2, 2017 | | 64509 Viewer | Category : MySql
READ MORE

Laravel 5 - whereIn and whereNotIn with subquery example using query builder

As you know laravel is very popular php framework in today. So every point will be require for database related and that important. In this post i would like to share with you how to use subquery with whereIn and whereNotIn clause from scratch. We may sometimes require to use select query with where in or where not in clause. we can simply make query using MySQL. But we don't know how to use it on laravel query builder. However, In this example we will learn how to convert mysql query into laravel query builder of wherein with subquery. This example is from scratch, so i will give you first m.....

By Hardik Savani | March 23, 2017 | | 65070 Viewer | Category : 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 | | 69077 Viewer | Category : MySql
READ MORE

How to get last record from MySQL table in Codeigniter?

In this post we are going to learn how to get last single record from MySQl database table using Codeigniter database library. We sometime require to get only single row result in our Codeigniter application. In this post you can see how to get whole last record using Codeigniter db query. Few day ago i posted <a href="http://itsolutionstuff.com/post/how-to-get-last-inserted-id-in-codeigniterexample.html" target="_blank">"How to get last inserted id in Codeigniter?"</a>, in that post we can simply get last inserted id from Codeigniter db query. In this database query i used order_by(), limit.....

By Hardik Savani | March 9, 2017 | | 33868 Viewer | Category : MySql
READ MORE