- 数据库连接
连接 MySQL 数据库
<?php
$DBNAME = 'koonk';
$HOST = 'localhost';
$DBUSER = 'root';
$DBPASS = 'koonk';
$CONNECT = mysql_connect($HOST,$DBUSER,$DBPASS);
if(!$CONNECT)
{
echo 'MySQL Error: '.mysql_error();
}
$SELECT = mysql_select_db($DBNAME);
if(!$SELECT)
{
echo 'MySQL Error: '.mysql_error();
}
?>
- 目录清单
使用下面的 PHP 代码片段可以在一个目录中列出所有文件和文件夹
function list_files($dir)
{
if(is_dir($dir))
{
if($handle = opendir($dir))
{
while(($file = readdir($handle)) !== false)
{
if($file != "." && $file != ".." && $file != "Thumbs.db"/*pesky windows, images..*/)
{
echo '<a target="_blank" href="'.$dir.$file.'"></a>'."\n";
}
}
closedir($handle);
}
}
}
语法:
<?php
list_files("images/"); //This will list all files of images folder
?>
- 检测用户语言
使用下面的 PHP 代码片段可以检测用户浏览器所使用的语言
function get_client_language($availableLanguages, $default='en'){
if (isset($_SERVER['HTTP_ACCEPT_LANGUAGE'])) {
$langs=explode(',',$_SERVER['HTTP_ACCEPT_LANGUAGE']);
foreach ($langs as $value){
$choice=substr($value,0,2);
if(in_array($choice, $availableLanguages)){
return $choice;
}
}
}
return $default;
}
查看 CSV 文件
function readCSV($csvFile){
$file_handle = fopen($csvFile, 'r');
while (!feof($file_handle) ) {
$line_of_text[] = fgetcsv($file_handle, 1024);
}
fclose($file_handle);
return $line_of_text;
}
语法:
<?php
$csvFile = "test.csv";
$csv = readCSV($csvFile);
$a = csv0; // This will get value of Column 1 & Row 1
?>
从 PHP 数据创建 CSV 文件
function generateCsv($data, $delimiter = ',', $enclosure = '"') {
$handle = fopen('php://temp', 'r+');
foreach ($data as $line) {
fputcsv($handle, $line, $delimiter, $enclosure);
}
rewind($handle);
while (!feof($handle)) {
$contents .= fread($handle, 8192);
}
fclose($handle);
return $contents;
}
语法:
<?php
$data[0] = "apple";
$data[1] = "oranges";
generateCsv($data, $delimiter = ',', $enclosure = '"');
?>
- 解析 XML 数据
$xml_string="<?xml version='1.0'?>
<molecule name='Benzine'>
<symbol>ben</symbol>
<code>A</code>
</molecule>
<molecule name='Water'>
<symbol>h2o</symbol>
<code>K</code>
</molecule>
";
//load the xml string using simplexml function
$xml = simplexml_load_string($xml_string);
//loop through the each node of molecule
foreach ($xml->molecule as $record)
{
//attribute are accessted by
echo $record['name'], ' ';
//node are accessted by -> operator
echo $record->symbol, ' ';
echo $record->code, '';
}
- 解析 JSON 数据
$json_string='{"id":1,"name":"rolf","country":"russia","office":["google","oracle"]} ';
$obj=json_decode($json_string);
//print the parsed data
echo $obj->name; //displays rolf
echo $obj->office[0]; //displays google
- 获取当前页面 URL
这个 PHP 片段可以帮助你让用户登录后直接跳转到之前浏览的页面
function current_url()
{
$url = "http://" . $_SERVER['HTTP_HOST'] . $_SERVER['REQUEST_URI'];
$validURL = str_replace("&", "&", $url);
return validURL;
}
语法:
<?php
echo "Currently you are on: ".current_url();
?>
- 从任意的 Twitter 账号获取最新的 Tweet
function my_twitter($username)
{
$no_of_tweets = 1;
$username . "&rpp=" . $no_of_tweets;
$xml = simplexml_load_file($feed);
foreach($xml->children() as $child) {
foreach ($child as $value) {
if($value->getName() == "link") $link = $value['href'];
if($value->getName() == "content") {
$content = $value . "";
echo '<p class="twit">'.$content.' <a class="twt" href="'.$link.'" title=""> </a></p>';
}
}
}
}
语法:
<?php
$handle = "koonktech";
my_twitter($handle);
?>
- 转发数量
使用这个 PHP 片段可以检测你的页面 URL 有多少转发数量
function tweetCount($url) {
$content = file_get_contents;
$element = new SimpleXmlElement($content);
$retweets = $element->story->url_count;
if($retweets){
return $retweets;
} else {
return 0;
}
}
语法:
<?php
$count = tweetCount($url);
return $count;
?>
- 计算两个日期的差
<?php
$date1 = date( 'Y-m-d' );
$date2 = "2015-12-04";
$diff = abs(strtotime($date2) - strtotime($date1));
$years = floor($diff / (3656060*24));
$months = floor(($diff - $years 365606024) / (306060*24));
$days = floor(($diff - $years * 365*60*60*24 - $months30606024)/ (606024));
printf("%d years, %d months, %d days\n", $years, $months, $days);
-------------------------------------------------------- OR
$date1 = new DateTime("2007-03-24");
$date2 = new DateTime("2009-06-26");
$interval = $date1->diff($date2);
echo "difference " . $interval->y . " years, " . $interval->m." months, ".$interval->d." days ";
// shows the total amount of days (not divided into years, months and days like above)
echo "difference " . $interval->days . " days ";
-------------------------------------------------------- OR
/**
- Calculate differences between two dates with precise semantics. Based on PHPs DateTime::diff()
- implementation by Derick Rethans. Ported to PHP by Emil H, 2011-05-02. No rights reserved.
- See here for original code:
function _date_range_limit($start, $end, $adj, $a, $b, $result)
{
if ($result[$a] < $start) {
$result[$b] -= intval(($start - $result[$a] - 1) / $adj) + 1;
$result[$a] += $adj * intval(($start - $result[$a] - 1) / $adj + 1);
}
if ($result[$a] >= $end) {
$result[$b] += intval($result[$a] / $adj);
$result[$a] -= $adj * intval($result[$a] / $adj);
}
return $result;
}
function _date_range_limit_days($base, $result)
{
$days_in_month_leap = array(31, 31, 29, 31, 30, 31, 30, 31, 31, 30, 31, 30, 31);
$days_in_month = array(31, 31, 28, 31, 30, 31, 30, 31, 31, 30, 31, 30, 31);
_date_range_limit(1, 13, 12, "m", "y", &$base);
$year = $base["y"];
$month = $base["m"];
if (!$result["invert"]) {
while ($result["d"] < 0) {
$month--;
if ($month < 1) {
$month += 12;
$year--;
}
$leapyear = $year %400==0||($year %100!=0&& $year %4==0);
$days = $leapyear ? $days_in_month_leap[$month]: $days_in_month[$month];
$result["d"]+= $days;
$result["m"]--;}}else{while($result["d"]<0){
$leapyear = $year %400==0||($year %100!=0&& $year %4==0);
$days = $leapyear ? $days_in_month_leap[$month]: $days_in_month[$month];
$result["d"]+= $days;
$result["m"]--;
$month++;if($month >12){
$month -=12;
$year++;}}}return $result;}function _date_normalize($base, $result){
$result = _date_range_limit(0,60,60,"s","i", $result);
$result = _date_range_limit(0,60,60,"i","h", $result);
$result = _date_range_limit(0,24,24,"h","d", $result);
$result = _date_range_limit(0,12,12,"m","y", $result);
$result = _date_range_limit_days(&$base,&$result);
$result = _date_range_limit(0,12,12,"m","y", $result);return $result;}/**
- Accepts two unix timestamps.
*/function _date_diff($one, $two){
$invert =false;if($one > $two){
list($one, $two)= array($two, $one);
$invert =true;}
$key = array("y","m","d","h","i","s");
$a = array_combine($key, array_map("intval", explode(" ", date("Y m d H i s", $one))));
$b = array_combine($key, array_map("intval", explode(" ", date("Y m d H i s", $two))));
$result = array();
$result["y"]= $b["y"]- $a["y"];
$result["m"]= $b["m"]- $a["m"];
$result["d"]= $b["d"]- $a["d"];
$result["h"]= $b["h"]- $a["h"];
$result["i"]= $b["i"]- $a["i"];
$result["s"]= $b["s"]- $a["s"];
$result["invert"]= $invert ?1:0;
$result["days"]= intval(abs(($one - $two)/86400));if($invert){
_date_normalize(&$a,&$result);}else{
_date_normalize(&$b,&$result);}return $result;}
$date ="2014-12-04 19:37:22";
echo '
';';?>
print_r( _date_diff( strtotime($date), time()));
echo '
- 删除文件夹内容
function Delete($path)
{
if (is_dir($path) === true)
{
$files = array_diff(scandir($path), array('.', '..'));
foreach ($files as $file)
{
Delete(realpath($path) . '/' . $file);
}
return rmdir($path);
}
else if (is_file($path) === true)
{
return unlink($path);
}
return false;
}
语法:
<?php
$path = "images/";
Delete($path); // This will delete images folder along with its contents.
?>
- 搜索和高亮字符串中的关键字
function highlighter_text($text, $words)
{
$split_words = explode( " " , $words );
foreach($split_words as $word)
{
$color = "#4285F4";
$text = preg_replace("|($word)|Ui" ,
"<span style=\"color:".$color.";\"><b>$1</b></span>" , $text );
}
return $text;
}
语法:
<?php
$string = "I like chocolates and I like apples";
$words = "apple";
echo highlighter_text($string ,$words);
?>
- 写入文件
<?
$filename = 'blog.csv';
$fp = fopen($filename, 'w');
$output = " Hello ";
$output .= " World! ";
$output .= "\r\n";
fputs($fp, $output);
fclose($fp);
?>
- 根据 URL 下载图片
function imagefromURL($image,$rename)
{
$ch = curl_init($image);
curl_setopt($ch, CURLOPT_HEADER, 0);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_BINARYTRANSFER,1);
$rawdata=curl_exec ($ch);
curl_close ($ch);
$fp = fopen("$rename",'w');
fwrite($fp, $rawdata);
fclose($fp);
}
语法:
<?php
$rename = "koonk.png";
imagefromURL($url,$rename);
?>
- 检测 URL 是否有效
function isvalidURL($url)
{
$check = 0;
if (filter_var($url, FILTER_VALIDATE_URL) !== false) {
$check = 1;
}
return $check;
}
语法:
<?php
$check = checkvalidURL($url);
echo $check; //if returns 1 then URL is valid.
?>