Menggy's programming trick

PHP extract HTML content between two markups

2012-04-03T00:31:00.005-07:00

PHP extracts HTML content between two markups.

//the content string will be returned, NOTE: This can be used for extracting the content for once only.
function extractContent($html, $startPattern, $endPattern){

$start = strpos($html, $startPattern);
$end = strpos($html, $endPattern, $start + strlen($startPattern) + 1);
return substr($html, $start + strlen($startPattern), $end - $start - strlen($startPattern));
}

e.g,, <h1>content value that you want to extract...</h1>:

you can call:

$html = '<h1>content value that you want to extract...</h1>';
$startPattern = '<h1>';
$endPattern = '</h1>';

extractContent($html, $startPattern, $endPattern);

Other tricks:

//an array will be returned. each element stands for a content value.

function extractAllContents($html, $startPattern, $endPattern){
$array_index = 0;
$index = 0;
$contents = array();
while (true){
if ($index > strlen($html)) break;
$start = strpos ( $html, $startPattern, $index);
if ($start !== false){
$end = strpos ( $html, $endPattern, $start + strlen ( $startPattern ) + 1 );
$content = dataCleasing(substr ( $html, $start + strlen ( $startPattern ), $end - $start - strlen ( $startPattern ) ));
$contents[$array_index++] = $content;
$index = $end + strlen($endPattern) + 1;
}
else{
break;
}
}
return $contents;
}

PHP Auto get web page using curl.

2012-04-03T00:22:00.004-07:00

//$url is in its valid URL format
static function get_web_page($url) {
$curl = curl_init ();
curl_setopt ( $curl, CURLOPT_FOLLOWLOCATION, 1 );
curl_setopt ( $curl, CURLOPT_RETURNTRANSFER, 1 );
curl_setopt ( $curl, CURLOPT_ENCODING, "" );
curl_setopt ( $curl, CURLOPT_USERAGENT, "Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.2) Gecko/20100115 Firefox/3.7 (.NET CLR 3.5.30729)" );
curl_setopt($curl, CURLOPT_ENCODING, "utf-8");
curl_setopt ( $curl, CURLOPT_FOLLOWLOCATION, 1 );
curl_setopt ( $curl, CURLOPT_RETURNTRANSFER, 1 );
curl_setopt ( $curl, CURLOPT_POST, 1 );
curl_setopt ( $curl, CURLOPT_SSL_VERIFYPEER, false );
curl_setopt($curl, CURLOPT_URL, $url);
$content = curl_exec ( $curl );
curl_close ( $curl );
return $content;
}

PHP Generate unique id

2012-04-03T00:21:00.000-07:00

//uid with md5 function
echo md5( uniqid() );

Sample output: 0021228154ffc7fdc49390e5f131a3f8

PHP auto login Facebook using curl.

2012-04-03T00:19:00.006-07:00

// your facebook credentials
$username = "xxxxxx";
$password = "xxxxxxxx";

// access to facebook home page (to get the cookies)
$curl = curl_init();
curl_setopt($curl, CURLOPT_URL, "http://www.facebook.com");
curl_setopt($curl, CURLOPT_FOLLOWLOCATION, 1);
curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($curl, CURLOPT_ENCODING, "");
curl_setopt($curl, CURLOPT_COOKIEJAR, getcwd() . '/cookies_facebook.cookie');
curl_setopt($curl, CURLOPT_USERAGENT, "Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.2) Gecko/20100115 Firefox/3.6 (.NET CLR 3.5.30729)");
$curlData = curl_exec($curl);
curl_close($curl);

// do get some parameters for login to facebook
$charsetTest = substr($curlData, strpos($curlData, "name=\"charset_test\""));
$charsetTest = substr($charsetTest, strpos($charsetTest, "value=") + 7);
$charsetTest = substr($charsetTest, 0, strpos($charsetTest, "\""));

$locale = substr($curlData, strpos($curlData, "name=\"locale\""));
$locale = substr($locale, strpos($locale, "value=") + 7);
$locale = substr($locale, 0, strpos($locale, "\""));

$lsd = substr($curlData, strpos($curlData, "name=\"locale\""));
$lsd = substr($lsd, strpos($lsd, "value=") + 7);
$lsd = substr($lsd, 0, strpos($lsd, "\""));

// do login to facebook
$curl = curl_init();
curl_setopt($curl, CURLOPT_URL, "https://login.facebook.com/login.php?login_attempt=1");
curl_setopt($curl, CURLOPT_FOLLOWLOCATION, 1);
curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($curl, CURLOPT_POST, 1);
curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, false);
curl_setopt($curl, CURLOPT_POSTFIELDS, "charset_test=" . $charsetTest . "&locale=" . $locale . "&non_com_login=&email=" . $username . "&pass=" . $password . "&charset_test=" . $charsetTest . "&lsd=" . $lsd);
curl_setopt($curl, CURLOPT_ENCODING, "");
curl_setopt($curl, CURLOPT_COOKIEFILE, getcwd() . '/cookies_facebook.cookie');
curl_setopt($curl, CURLOPT_COOKIEJAR, getcwd() . '/cookies_facebook.cookie');
curl_setopt($curl, CURLOPT_USERAGENT, "Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.2) Gecko/20100115 Firefox/3.6 (.NET CLR 3.5.30729)");
$curlData = curl_exec($curl);

PHP Remove js, css, head, obj elements...

2012-04-03T00:17:00.003-07:00

//remove js,css,head.....
static function cleanElements($html){

$search = array (
"'<script[^>]*?>.*?</script>'si", //remove js
"'<style[^>]*?>.*?</style>'si", //remove css
"'<head[^>]*?>.*?</head>'si", //remove head
"'<link[^>]*?>.*?</link>'si", //remove link
"'<object[^>]*?>.*?</object>'si"
);
$replace = array (
"",
"",
"",
"",
""
);
return preg_replace ($search, $replace, $html);
}

PHP Date Calculation (Substraction...)

2012-04-03T00:15:00.000-07:00

For PHP date calculations:

Get previous date for a given date
Get No. of days between two given dates
Get previous Monday's date for a given date

//$date is in its Date format:e.g., 2001-11-30

function PreviousDate($date) {
return date('Y-m-d', strtotime($date . " -1 Day"));
}

//day = date1 - date2
function NoOfDays($date1, $date2) {
$Date_List_a1 = explode ( "-", $date1 );
$Date_List_a2 = explode ( "-", $date2 );
$d1 = mktime ( 0, 0, 0, $Date_List_a1 [1], $Date_List_a1 [2], $Date_List_a1 [0] );
$d2 = mktime ( 0, 0, 0, $Date_List_a2 [1], $Date_List_a2 [2], $Date_List_a2 [0] );
$Days = round ( ($d1 - $d2) / 3600 / 24 );
return $Days;
}

//Get Previous Monday for a Given date
function Get_Previous_Monday_Date($date1) {

$week = date('l',strtotime($date1));
if ($week == "Monday")
return null;
for ($i = -1; $i > -8; $i --){
$date = date('Y-m-d', strtotime($date1 . " $i Day"));
$week = date('l',strtotime($date));
if ($week == "Monday")
return $date;
}
}

Yii Framework: Using SQL without touching ActiveRecord/ORM

2012-04-02T21:02:00.003-07:00

For Yii Framework:

$connection=Yii::app()->db;

$sql = "SELECT *****" ;
$command=$connection->createCommand($sql);
$dataReader=$command->query();

foreach($dataReader as $row){
echo $row['key'];
}

For more:
http://www.yiiframework.com/doc/guide/1.1/en/database.dao

Yii framework: Generate RadioButtonList

2012-04-01T21:19:00.002-07:00

The following code:

echo CHtml::RadioButtonList('id', '', array('Male'=>'Male','Female'=>'Female'));

will generate:

<input value="Male" id="id_0" type="radio" name="id">
<label for="id_0">Male</label>
<br>
<input value="Female" id="id_1" type="radio" name="id">
<label for="id_1">Female</label>

Other tricks:

Display them inline without '<br>' separator:

echo CHtml::RadioButtonList('id', '', array('Male'=>'Male','Female'=>'Female'),
array('labelOptions'=>array('style'=>'display:inline'), separator'=>''));

Yii framework: difference between radioButtonList and activeRadioButtonList

2012-04-01T21:12:00.001-07:00

In Yii there is a "regular" and "active" version of (almost?) every CHtml form field helper/widget. With the "active" version you pass in the ActiveRecord Model and the Attribute you want to make a form field for. This ties the ActiveRecord model more closely to the form field which helps with a few things like:

applying the model->attribute's validation rules (especially ajax validation)
building the proper form $_POST structure for model->attribute assignments
getting the proper field label
etc

Use activeRadioButtonList if you are building a form for an ActiveRecord model, and use radioButtonListif you are building a regular form (for a CFormModel model).

YII Framework model findAllByAttributes()

2012-03-31T20:13:00.002-07:00

For Yii Framework findAllByAttributes():

Obj::model()->findAllByAttributes($filterArr, $conditionArr);

$filterArr: For generating the SQL conditions (filters) in WHERE clause.
e.g., array('filter1'=>'v1', 'filter2'=>'v2'...)
$conditionArr: For generating the SQL other conditions (order by, limit...)
e.g., array('order'=>'v1 DESC', 'limit'=>'10',...)

YII Framework href - absolute path

2012-03-31T19:07:00.000-07:00

For YII framework. In Views, href can be either a relative or absolute path.

For absolute path settings: Just add a prefix - http://

e.g., http://www.google.com directs you to google's website.
www.google.com directs you to yourwebroot/www.google.com

MySQL Generates random integer

2012-03-22T00:43:00.001-07:00

FLOOR(0 + (RAND() * 1000))

from 0 to 1000!

MySQL Generates random date

2012-03-22T00:32:00.003-07:00

A random date in 2009

mysql> SELECT FROM_UNIXTIME(RAND() * (1262246400 - 1230796800) + 1230796800) AS `the_date`;

+---------------------+
| the_date            |
+---------------------+
| 2009-04-27 05:01:04 |
+---------------------+
1 row in set (0.00 sec)