HDTuto.com

MySQL


Codeigniter 3 - Order by random records from mysql database example

If you are finding way to how to get random records from mysql table in codeigniter project then you are a right place. You can easily get random rows using codeigniter query builder order_by. here you will see the example of getting random result using order_by in codeigniter 3. In order_by(), we have to pass two argument parameter, one is a column name and another is a 'RANDOM' then codeigniter.....

Posted On July 19, 2018

How to use multiple where condition in Codeigniter?

Hi Guys, Here, i will show you how to write multiple condition in where clause using codeigniter 3 Query Builder class. Codeigniter provide set class function for each mysql function like where clause, join etc. So same for where clause, they provide "$this->db->where($array);", so we can use easily. In this tutorial, you can see two way to add multiple where condition in your codeigniter applica.....

Posted On July 19, 2018

How to insert multiple rows in Codeigniter?

In this tutorial, we will learn how to insert multiple records into a MySQL table using CI's active records library. Sometime, We may require to insert multiple rows instead of single records. It also takes a few time and adds multiple rows in a database table. Codeigniter 3 have an active records library and they provide insert_batch() to create multiple records at a time. So I also added a smal.....

Posted On July 19, 2018

PHP Laravel 5.6 - How to delete multiple row with checkbox using Ajax?

As we know, It's a very important to time consuming task to delete records one by one when there are too many records in the MySQL database table. So in this tutorial i will show you how to remove ro delete multiple rows or records with select checkboxes using jquery ajax in laravel 5.6 application. so basically, in this example, we will create "categories" table and model. Also you need to add s.....

Posted On June 17, 2018

PHP Ajax Autocomplete Search from Database Example

in this article, we will create ajax search autocomplete using php mysql and jquery. we will use jquery ajax for autocomplete with textbox. As we know in today. ajax is more use in php development and also other language project. ajax make quick response without page refresh. so in this example we will create free script of ajax autocomplete search with php mysql database. so basically. you nee.....

Posted On May 16, 2018

Pagination Searching and Sorting of data table using Angularjs PHP MySQL

Hi Guys, In this tutorial, you will learn how to build search sort and pagination of data table in Angularjs app using php mysql. i will help to make simple app with dynamic data get from database and do it searching table data, sorting table fields and pagination table data. here we will use dirPagination.js for pagination. In this tutorial, we require to create index file and write code for la.....

Posted On April 27, 2018

Laravel - Where null and Where not null eloquent query example

if you are a starter or learner laravel then you have in mind how to check where null or where not null condition using laravel eloquent model when you are writing eloquent query. if you write query for SQL then it is very easy syntax and families with where null and not null condition. In this small tutorial i will let you know how you can write query for where null and where not null conditio.....

Posted On April 2, 2018

Laravel select with count(*) using db raw example

Hi Guys, In this small article. i will let you know how to use select with count aggregate and group by using db raw in Laravel application. Here i gave you simple query example for join with count(*) as aggregate in select statement, i convert it into laravel db query builder. If you want to use count aggregate function in select statement then you require to use db::raw in eloquent select func.....

Posted On January 2, 2018

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

In this tutorial, i will let you know 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 recor.....

Posted On December 18, 2017

MySQL - select first word from string using SUBSTR

In this small article, i would like to share with you how to extract the first word of string in sql query. i did that using SUBSTR, LOCATE and If statement. Yesterday, i was working on my laravel project and i require to get first name from fulname column like as example: "Hardik Savani" Hardik Savani is a full name but i just need to get first work "Hardik" from fullname of users table in phpm.....

Posted On December 2, 2017