Tag : Data


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

In this post, i am going to share with you 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 records from this way. It is not any predefine function for getting records this way but we can do it by using following MySQL pre-define function. <strong>1) date()</strong> <strong>2) now()</strong>.....

By Hardik Savani | March 24, 2017 | | 352 Viewer | Category : PHP MySql SQL
READ MORE

Laravel 5 - Example of Database Seeder with insert sample data

We should know what is database seeder in laravel and why we should use before start example of database seeding. Laravel provides a tool to add sample or dummy data to our databases automatically. that is call it database seeding. Laravel database seeder through we can add simply testing data on our database table. Database seed is extremely useful because testing with various data allows you to likely detect bugs you otherwise would have overlooked. We have to simple make one time seeder with some dummy data, that way we can simply reuse when you deploy project first time. We can make seede.....

By Hardik Savani | February 23, 2017 | | 3354 Viewer | Category : Laravel
READ MORE

JQuery - how to get attribute value example

If you are new and you want to get attribute value then you can get easily. sometime maybe we also need to get custom attribute value, i mean data attribute value. In following example i give you three way to get custom attribute value in jquery. <strong class="example">Example:</strong> <pre class="prettyprint lang-html"> <html lang="en"> <head> <title>Get Custom Attribute Value</title> <script src="http://cdnjs.cloudflare.com/ajax/libs/jquery/2.1.3/jquery.min.js"></script> </head> <body> <a href="example.com" data-id="1" myname="hd">Ex.....

By Hardik Savani | April 14, 2016 | | 493 Viewer | Category : Javascript jQuery
READ MORE

How to get current month data in MySql PHP ?

If you require to get all the records of current month using mysql query. for example 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 following example you can see how to select data of current month. <strong class="example">Example:</strong> <pre class="language-mysql">SELECT * FROM items WHERE created_at > DATE_SUB(NOW(), INTERVAL 1 MONTH);</pre>

By Hardik Savani | March 17, 2016 | | 2299 Viewer | Category : PHP MySql
READ MORE

    Dynamic Autocomplete search using Bootstrap Typeahead JS Example

    Dynamic Autocomplete search using Bootstrap Typeahead JS Example

    Open Post

    Laravel 5 Facebook authentication using Socialite Package

    Laravel 5 Facebook authentication using Socialite Package

    Open Post

    Laravel 5 - elasticsearch with pagination example

    Laravel 5 - elasticsearch with pagination example

    Open Post

    How to integrate paypal payment gateway with laravel 5.4

    How to integrate paypal payment gateway with laravel 5.4

    Open Post

    Codeigniter 3 - select2 ajax autocomplete from database example with demo

    Codeigniter 3 - select2 ajax autocomplete from database example with demo

    Open Post

    Laravel guzzle http client POST request example

    Laravel guzzle http client POST request example

    Open Post