notes of my days...

mySql: SELECT DATE_FORMAT(DATE_ADD(CURDATE(), INTERVAL 0 MONTH), '%Y-%m-01'); SELECT LAST_DAY(DATE_ADD(CURDATE(), INTERVAL 0 MONTH)); php : $first = date('Y-m-d', mktime(0, 0, 0, date('m'), 1, date('Y'))); $last = date('Y-m-t', mktime(0, 0, 0, date('m'), 1, date('Y')));

add php.ini with the below line and put it to the root of my website on my share hosting where the operating system used is linux. extension=pdo.so extension=pdo_sqlite.so extension=sqlite.so extension=pdo_mysql.so

echo getcwd(); ?>

List<int> test = new List<int>() { 1, 2, 4, 5, 6, 7, 9 }; foreach (int t in Enumerable.Reverse(test)) { Console.Write(t+","); } result : 9,7,6,5,4,2,1,

$date = date("Y-m-d", strtotime('2013-04-23')); echo $date; //2013-04-23

private int[] IsPrime(int upperLimit) { int sieveBound = (int)(upperLimit - 1) / 2; int upperSqrt = ((int)Math.Sqrt(upperLimit) - 1) / 2; BitArray PrimeBits = new BitArray(sieveBound + 1, true); for (int i = 1; i <= upperSqrt; i++) { if (PrimeBits.Get(i)) { for (int j = i * 2 * (i + 1); j <= sieveBound; j += 2 * i + 1) { PrimeBits.Set(j, false); } } } List<int> numbers = new List<int>((int)(upperLimit / (Math.Log(upperLimit) - 1.08366))); numbers.Add(2); for (int i = 1; i <= sieveBound; i++) { if (PrimeBits.Get(i)) { numbers.Add(2 * i + 1); } } return numbers.ToArray(); }

source : <input type="button" value="button name" onclick="window.open('http://www.dewatatech.com')" />

<?php $this->widget('zii.widgets.CMenu',array( 'items'=>array( ...... array('label'=>'Home', 'url'=>'http:../../menu/home.php'), array('label'=>'Home', 'url'=>'http://www.dewatatech.com'), ...... ), )); ?>

In the Controller / ActionAdmin: if (isset($_GET['pageSize'])) { Yii::app()->user->setState('pageSize',(int)$_GET['pageSize']); unset($_GET['pageSize']); } In the model / Search Function: return new CActiveDataProvider(get_class($this), array( 'pagination'=>array( 'pageSize'=> Yii::app()->user->getState('pageSize',Yii::app()->params['defaultPageSize']), ), 'criteria'=>$criteria, )); In the View Admin: <?php $pageSize=Yii::app()->user->getState('pageSize',Yii::app()->params['defaultPageSize']); $this->widget('zii.widgets.grid.CGridView', array( 'id'=>'file-grid', 'dataProvider'=>$model->search(), 'columns'=>array( ..., array( ...

public function search() { // Warning: Please modify the following code to remove attributes that // should not be searched. $criteria=new CDbCriteria; ... return new CActiveDataProvider('Client', array( 'criteria'=>$criteria, 'pagination'=>array( 'pageSize'=>50, ), )); }

/** * @return array validation rules for model attributes. */ public function rules() { // NOTE: you should only define rules for those attributes that // will receive user inputs. return array( ........ array('username','unique'), ........ ); }

selected 1 selected 2

Creating a parameterized LIKE query

yii Auto complete text field

'columns' => array (   array (     'name' => 'name' ,     'value' => 'asdf' ,     'htmlOptions' => array ( 'width' => '40px' ),   ),

Searching and sorting by related model in CGridView

this is open in new tab source : <a href="http://www.someurl.com" target="_blank">

add the following style to main.css   #page ul.yiiPager .first, #page ul.yiiPager .last {         display : inline ; }

copy and paste to cronjob the script below to remove the nasty code injected  in all my PHP files from public_html folder:     find -name "*.php" -exec sed -i '/<?.*eval(gzinflate(base64.*?>/ d' '{}' \; -print

follow this tutorial : http://sahanlm.blogspot.com/2012/12/netbeans-7-2-crash-on-start.html