Tag : Current


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 | | 184 Viewer | Category : PHP MySql SQL
READ MORE

How to get current url with query string in codeigniter?

If you require to get current URL with parameters in your codeigniter project then you can get easily using "url" helper. Codeigniter provide url helper library that way we can get existing page url or base url etc. you can also get only parameters without URL using "input" as like bellow. <pre> $parameters = $this->input->get(); </pre> But, we are getting full path using "url" helper and $_SERVER variable. So, you can see how to get full path using both as bellow: <strong>Example:</strong> <pre class="prettyprint lang-php"> $this->load->helper('url'); <br/> $currentURL = current_url(); $pa.....

By Hardik Savani | August 29, 2016 | | 2209 Viewer | Category : Codeigniter
READ MORE

How to get current url with parameters in Laravel 5?

We sometimes require to get full url path with query string parameters that way we can perform on it. So we can get current url with also all parameter using several method of laravel. There are several option to get full url with query string as listed bellow: <ul> <li><strong>URL Facade</strong></li> <li><strong>Request Facade</strong></li> <li><strong>$request Object</strong></li> </ul> I give you three way to get full path with parameters, so you can see as bellow: <strong>Example 1:</strong> <pre class="prettyprint lang-php"> public function index() { $fullURL = \URL::full(); p.....

By Hardik Savani | August 8, 2016 | | 1647 Viewer | Category : Laravel
READ MORE

How to get current month records in Laravel 5?

In this post, i give you example query of how to fetch current month records from table using Laravel query builder. We sometimes require to get records that created on current month. i.e if current month is august and we need display records of august month on out admin dashboard. In this example you can see how can get you current month records and i used whereRaw() of laravel query builder with MONTH() mysql that way we can get month and compare with current month. I have one created items table that structure as bellow you can see. <strong>items table</strong> <img src="/upload/laravel-.....

By Hardik Savani | August 7, 2016 | | 2192 Viewer | Category : Laravel
READ MORE

Codeigniter - How to get current url in controller or view ?

Sometimes, we need to get current URL path in your controller file or view file. So, we can get simply using "url" helper. Codeigniter provide url helper library that way we can get existing page url or base url etc. current_url() through we can get current url in your Codeigniter application. But, you should load "url" helper before use current_url(). you can load url helper as bellow: <pre> $this->load->helper('url'); </pre> In bellow example, you can see code how can i get current url in your controller file. So, let's see. <pre class="prettyprint lang-php"> $this->load->helper('url'); <b.....

By Hardik Savani | August 2, 2016 | | 900 Viewer | Category : Codeigniter
READ MORE

How to get current url path example in Jquery?

Sometimes we need to get current URL in jquery file, we can get current URL or path of our current page in javascript using "window.location". In this post i give you three way to get current url in your js file as there are bellow listed: <strong>1.window.location.href</strong> <strong>2.$(location).attr("href")</strong> <strong>3.window.location</strong> Ok, so you can check bellow example code and run in your system. <strong>Example:</strong> <pre class="prettyprint lang-html"> <html lang="en"> <br/> <head> <title>JQuery - get current URL Example</title> &l.....

By Hardik Savani | July 27, 2016 | | 770 Viewer | Category : Javascript jQuery
READ MORE

How to get current controller name in view Laravel 5?

If you require to get current controller name in your view file or in your middleware or your serviceprovider etc. you can get your controller details from current route like UserController, HomeController ect. you can also get full path of controller file. Laravel getAction() through we can get whole array of current route details, in this example i get current controller in my auth middleware, if you require on your view file or other place then you can simply get. So, let's see example how you can get controller name in auth middleware. <strong>Example: app/Http/Middleware/Authenticate.p.....

By Hardik Savani | July 27, 2016 | | 1877 Viewer | Category : Laravel
READ MORE

Laravel - How to get current URL in controller or view?

We always require to get current URL path when work on ajax pagination or something, at that we require to get current page URL on Controller or blade file. So, you can get current url easily. Laravel provide URL facade that way we can get current URL anywhere, as bellow you can see i use current() of URL facade. URL facade through you can get your current page url from every where. So you can check your current url this way: <strong>Example:</strong> <pre class="prettyprint lang-php"> $currentURL = URL::current(); dd($currentURL); </pre>

By Hardik Savani | July 20, 2016 | | 2292 Viewer | Category : Laravel
READ MORE

How to get current year rows using MySql Query PHP?

If you require to get all the records of current year 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 year. 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 year. <strong>Example:</strong> <pre> SELECT * FROM items WHERE created_at > DATE_SUB(NOW(), INTERVAL 1 YEAR); </pre>

By Hardik Savani | June 14, 2016 | | 627 Viewer | Category : MySql
READ MORE

How to get url segment in Laravel 5?

Whenever you need to get current url segment then you can get using Request facade. I give you example one for using Request facade. so you can get segment from url and how you can see both example. <strong>Example:</strong> <pre class="prettyprint lang-php"> @extends('layouts.app') @section('content') {{ Request::segment(1) }} @endsection </pre>

By Hardik Savani | April 10, 2016 | | 2672 Viewer | Category : Laravel
READ MORE

    Ajax Image Upload Example with Validation in PHP Laravel Framework

    Ajax Image Upload Example with Validation in PHP Laravel Framework

    Open Post

    AngularJS - simple image upload with preview example in PHP

    AngularJS - simple image upload with preview example in PHP

    Open Post

    Laravel 5 - line chart example code using google charts API

    Laravel 5 - line chart example code using google charts API

    Open Post

    Laravel 5.2 chat message module using socket.io, redis, express and nodejs from from scratch.

    Laravel 5.2 chat message module using socket.io, redis, express and nodejs from from scratch.

    Open Post

    Solved - Access Not Configured. Google+ API (truncated...) on google console developer

    Solved - Access Not Configured. Google+ API (truncated...) on google console developer

    Open Post

    How to get filename from file path in MySQL?

    How to get filename from file path in MySQL?

    Open Post