Codxplore Blog Collection

Latest news: New android application Islamic Video has been released. its a free islamic video application for android smartphone. Download now!

How to run foreach loop between 2 given dates ?

Date: September 13, 2017, 10:19 am Author: Akram Hossain

$begin = new DateTime( '2010-05-01' ); $end = new DateTime( '2010-05-10' ); $interval = DateInterval::createFromDateString('1 day'); $period = new DatePeriod($begin, $interval, $end); foreach ( $period as $dt ) echo $dt->format( "l Y-m-d H:i:s\n" ); This will output all days in the defined period between $start and $end. If you want to include the 10th, set $end to 11th. You can adjust format to your liking. See the PHP Manual for DatePeriod.

Views: 3341

Displaying the list of months using mktime for the year

Date: September 13, 2017, 8:17 am Author: Akram Hossain

Use this: for ($m=1; $m

Views: 3368

How to get the first and last days of a given month

Date: September 13, 2017, 7:17 am Author: Akram Hossain

You might want to look at the strtotime and date functions.

Views: 3108

php export csv utf 8

Date: February 1, 2016, 12:25 pm Author: Akram Hossain

If your generating a CSV with PHP you may have stumbled upon the same problem as me where any special character such as £ becomes ASCII in your CSV, this is because the encoding of your CSV is wrong and you will need to output your CSV in UTF8 to be able to use special ASCII characters in your document. Using my example below you can encode UTF8 your CSV file, you will notice a header with “Content-Encoding: UTF-8” and also in the “Content-Type” header you will see an extra parameter “; charset=UTF-8”. You will also notice the weird echo “xEFxBBxBF” – this is the BOM for the UTF-8 encoding, if your not sure what this is don't worry, it will not display in your document. Please Note! UTF-8 is not supported by Macinto....

Views: 3507

Yii2 - Get Current Action ID in main.php

Date: July 23, 2015, 5:07 pm Author: Akram Hossain

Answer In a layout you can access the current controller via $this->context, and so the current action id by $this->context->action->id For reference http://stackoverflow.com/questions/28769719/yii2-get-current-action-id-in-main-php

Views: 2798

Yii2 pagination

Date: July 22, 2015, 6:09 pm Author: Akram Hossain

Pagination represents information relevant to pagination of data items. When data needs to be rendered in multiple pages, Pagination can be used to represent information such as total item count, page size, current page, etc. These information can be passed to pagers to render pagination buttons or links. The following example shows how to create a pagination object and feed it to a pager. Controller action: public function actionSearch($q = '') { $this->layout = 'site_main'; $q = trim($q); $sql = "SELECT * FROM (select p.product_id as 'sid',p.name_en,p.name_ar,p.description_en,description_ar,p.imag....

Views: 3091

Yii2 leftJoin()

Date: July 20, 2015, 3:51 pm Author: Akram Hossain

leftJoin() $query = new Query; $query ->select(['tbl_user.username AS name', 'tbl_category.type as Category']) ->from('tbl_user') ->leftJoin('tbl_category', 'tbl_category.createdby = tbl_user.userid') ->limit(2); $command = $query->createCommand(); $data = $command->queryAll();

Views: 1841

Yii2 innerJoinWith()

Date: July 20, 2015, 3:51 pm Author: Akram Hossain

innerJoinWith() $model = User::find() ->innerJoinWith('comments', false) ->all(); // equivalent to the above $model = User::find() ->joinWith('comments', false, 'INNER JOIN') ->all(); SYNTAX: $query = new Query; $query ->select(['SELECT COLUMNS']) ->from('TABLE_NAME_1') ->join( 'JOIN_TYPE', 'TABLE_NAME_2', 'TABLE_NAME_2.COLUMN =TABLE....

Views: 2058

Yii2 joinWith()

Date: July 20, 2015, 3:49 pm Author: Akram Hossain

joinWith() Sample 1: $model = User::find() ->joinWith('comments') ->all(); Sample 2: $model = User::find() ->joinWith('comments') ->orderBy('tbl_comments_id.id, tbl_user.id') ->all();

Views: 1999

Yii2 Relation Model

Date: July 20, 2015, 3:48 pm Author: Akram Hossain

Relation Model $model = User::find() ->with('comments') ->all(); foreach ($model as $user) { // get data from relation model $comments = $user->comments; ...... foreach($comments as $comment){ ........ } }

Views: 1213

Yii2 GridView sorting and pagination using pajax

Date: July 20, 2015, 3:45 pm Author: Akram Hossain

<?php use yiiwidgetsPjax; ?> Add above line in the beginning of your view. <?php Pjax::begin(); ?> <?= GridView::widget([ 'dataProvider' => $dataProvider, 'filterModel' => $searchModel, 'columns' => [ ['class' => 'yiigridSerialColumn'], 'id', 'branch:ntext', 'version:ntext', 'release_date:ntext', [ 'class' => 'yiigridActionColumn', 'template' => '{view}', ], ], ]); ?> <?php Pjax::end(); ?>

Views: 1567

Yii2 Turning on Pretty URLs

Date: July 16, 2015, 12:09 am Author: Akram Hossain

First, let's enable Yii2's pretty URLs with mod_rewrite. On the Yii home page, if you click on the About menu option, the URL will be something like http://localhost/hello/web/index.php?r=site%2Fabout. We'd like to change that to http://localhost/hello/web/site/about. The config subdirectory includes environment configurations for your web and console applications as well as the future database settings. Edit /config/web.php to add urlManagement to the current web application. Add the following urlManager section within the components array: 1 2 3 4 5 6 7 8 &#....

Views: 1102

Codxplore.com