Mysql Hexadecimal color code store in binary datatype.
If you have thousands of record store, that time database size would be large. but you can some field can save your number of bites in the database.you have color field then most of you choose string(6) data type and you wast 6 bites on every record, but you can save number of bites data b...
Which MySQL datatype use for store an IP address?
If you want to store IP address in mysql database then don’t mistake to use varchar datatype because you can use INT UNSIGNED 4(BYTE) datatype. using integer datatype you can save more space in database.when you fire insert query at that time use INET_ATON() and select query at that time I...
How to count unique domains from email address field in MySQL ?
you want to count domain from your email address field in mysql. if you are working on PHP then you could do easily by using explode function and counting domains, but that way is a very bad logic and it take max time on execution when you have lot of data. But we can do easily in MySQL by using...
How to copy one table data into another table using Mysql Query?
If you are working on php or any php framwork and you want to copy one table into other table by using sql query, so you could do it using simple SELECT and INSERT statement. just you need to think how you can use.In Following lesson you can see how to fetch data from "post" table a...
How to check empty or null in Mysql Query?
If you want to check empty or null value with conditional statement like case when and if in table row with Mysql database. you like to check empty or null value form table then you have multiple way check that. first we check empty value with case when statement then following lesson....
How to fetch this week records in MySql ?
If you require to get all the records of current week using mysql query. for lesson you have one table "items" and columns are id, title, description, created_at and update_at, Now you want to get all records of this week. so you can fetch fields value using DATE_SUB and INTERVAL of mysql. In fol...
How to get current month data in MySql PHP ?
If you require to get all the records of current month using mysql query. for lesson you have one table "items" and columns are id, title, description, created_at and update_at, Now you want to get all records of this month. so you can fetch fields value using DATE_SUB and INTERVAL of mysql. In f...
How to get last 2 days records from table using Mysql Query?
We may sometimes require to get few days ago records from table like last 2 days, last 3 days, last 10 days or last 15 days etc. Most of developer choose other logic but we can easily get using mysql query(using CURDATE and INTERVAL).In this lesson mysql query i have one table "elem...
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...
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 lesson 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, item...
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, c...
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 lesson through we understand how to work dependent dropdown in core PHP even if you beginner. I also posted for php laravel framework
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 lesson from scratch so it will be easy to get full script lesson.Sometimes, we almost require to create image gallery or insert update and delete module for...
PHP MySQL contact us form with validation using Bootstrap
Hello Brother, 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 t...
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 lesson I will implement login with Gmail account on your website.In today's world a...
Column Sorting using PHP and MySQL
In this lesson i will show you simple way to create table column sorting from database using php mysql. we will do it sorting column by clicking column header with php and mysql in table.It is a very basic lesson for php starter to create column sort ascending descending order by cl...
Create Dynamic Treeview Example using JQuery Ajax in PHP MySQL
Hello Brother,If you are looking for tutorial on how to create dynamic treeview for menu or category using php mysql, then you are a right place. In this lesson we will build step by step dynamic tree view from database in php.If you want to create treeview in your website ap...
Mysql procedure with pagination in laravel?
You are working on laravel with mysql database. you had created mysql procedure for get data and you want to call procedure with pagination in laravel 5 then you can not directly make pagination as laravel document.If you are using directly MySQL stored Procedure in your controller, model or repo...
How to get last executed mysql query in Laravel?
If you are working on laravel framwork and you use query builder of laravel 5. but you want to get last executed mysql query from laravel. If you are working on laravel 5 then you have to first enable query log that way it can be store query log. At last getQueryLog() through you can get last exe...
GROUP_CONCAT with different SEPARATOR in laravel Example
Whenever, you need to use GROUP_CONCAT with differente separator(I mean default separator is ',', But you want to change '@','#','&' etc as you want). then you have to use use SEPARATOR keyword in GROUP_CONCAT(). If you are working on laravel then you have to also use DB::raw() for write GROU...
Laravel Query Builder Where Exists Example
you use sql where exists clause in laravel. whereExists through you can use sql where exists clause in your laravel project. It is very easy to use and you can easily undestand. You can give SELECT statment in where condition. you can see bellow lesson and you can learn how to use whereExists in...
How to add mysql trigger from migrations in Laravel 5?
Sometimes you require to add trigger in your mysql database of laravel 5. but you think how to create trigger using laravel migration because laravel not provide special function like insertTrigger and something so it problem to create direclty, But laravel DB::unprepared() through we can create...
How to get latitude longitude from mysql in Laravel?
Whenever you need to get nearest posts from lat and long and if you are working on laravel query builder. then you can get distance easily using DB::raw(), so you can learn from following lesson how to get nearest value from mysql laravel.Example:
Laravel Where Clause with Mysql Function Example
When you are working on laravel projects and you need to use mysql function in where clause then you can easily use that using DB::raw() and whereRaw(). In this lesson you can show how to i use mysql function in where clause. In this lesson i want to compare with year of created_at field but not...
Laravel - How to make subquery in select statement?
Sometimes we require to make subquery inside the select statement in Laravel. At that time we are thinking how to select from subquery using in Laravel Query Builder.In this post i will give you lesson of subquery in select statement in laravel 5, laravel 6, laravel 7 and laravel 8...
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 lesson 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...
Laravel - 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...
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 applicat...
Simple Tags System Example in Laravel
If you are writing article for your blog or your personal website then you must need to implement taggable system in your website. If you write article or post for food then you have to create tags like on foods name, foods type etc. You also maybe see on there are several blog or website availab...
Laravel - Column Sorting with Pagination Example
Hello Brother, Guys i always try to find something new article for laravel developer so that can be help for his development. So Today i will share with you amazing tutorial of laravel sortable table lesson you can can sort your table field with pagination. We will do it column sorting using kysl...
Laravel 5.6 CRUD Application for Starter
Hello Brother, 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....
Laravel 5.7 CRUD (Create Read Update Delete) Tutorial Example
Hello Brother, I want to describe step by step crud operation with laravel 5.7 application. In this tutorial, you will learn simple insert update delete operation with laravel 5.7 from scratch. You need to follow few step and you will get basic crud stuff using controller, model, ro...
How to use if condition in laravel select query?
We will learn how to use if condition in laravel select query. we can use mysql case when statement with db raw in laravel. If you want to use mysql function then you must have to use db raw function. in this lesson i will show you laravel select query with if condition.In minor cas...
- React JS
- Typeahead JS
- Facebook API
- Amazon API
- Twitter API
- Instagram API
- Google API
- Node JS
- Mailchimp API
- Linkedin API
- Dropbox API
- Mailgun API
- Chart JS
- Parsley JS
- Rakuten Marketing API
- Behance API
- Google Map
- Mediafire API
- Ionic Framework
- React Native