1, PHPRead sql server varchar field data, the select result is incomplete
Mssql_query() reads varchar type by default and only takes 255 bytes of data. If the field exceeds this Range, use CONVERT(TEXT, table.comment) to convert the field type to TEXT.
$q = "SELECT CONVERT(TEXT, userinfo.inv) as te FROM userinfo where (1=1)";
Copy after login
2. Time
$shijianchuo = strtotime("$logintime");
$past_logintime = date("Y/m/d",$shijianchuo-24*60*60);
$today_time=date("Y-m-d");
$zh_time = strtotime("$today_time");
$yesterday_time= date("Y-m-d ",strtotime("-1 day","$zh_time")) ;
$tomorrow_time= date("Y-m-d ",strtotime("+1 day","$zh_time")) ;Copy after login
3. PHP time displays am and pm. Modify phpini
Modify php.ini, find;mssql.datetimeconvert = On, remove the previous points No., change on to off, restart apache or iis
4, pop-up box
<script language="javascript">
function check(form){
if(form.txt_user.value==""){
alert("请输入用户名");form.txt_user.focus();return false;
}
if(form.txt_pwd.value==""){
alert("请输入密码");form.txt_pwd.focus();return false;
}
}
</script>Copy after login
5, copy directory
$filecount=0;
$dircount=0;
function copydir($dirFrom,$dirTO)
{
global $filecount;
global $dircount;
if(is_file($dirTO))
{
die("目标不是目录，无法创建目录 $dirTO");
}
if(!file_exists(dirTO))
{
mkdir($dirTO);
$dircount++;
}
$handle=opendir($dirFrom);
while(($file=readdir($handle))!==false)
{
if($file !="." && $file !="..")
{
$fileFrom=$dirFrom.DIRECTORY_SEPARATOR.$file;
$fileTo=$dirTO.DIRECTORY_SEPARATOR.$file;
if(is_dir($fileFrom))
{
copydir($fileFrom,$fileTo);
}else{
copy($fileFrom,$fileTo);
$filecount++;
}
}
}
closedir($handle);
}
copydir(mail,mailbak);
echo "共拷贝".$filecount."文件，共拷贝目录".$dircount."个";Copy after login
6, calculate program execution time
<?php
//将获取当前时间的代码放在一个函数里
function runtime(){
$times = explode(" ",microtime());
$nowtime = $times[1]+$times[0];
return $nowtime;
}
//假设这里是页面开头
$start_time = runtime();
//这里开始是的页面代码
//your code goes here
//假设这里是页面顶部
$end_time = runtime();
$cost_time = $end_time - $start_time;
//处理输出执行时间
$cost_time = round($cost_time,4);
//输出页面的执行时间
echo "页面执行时间为：".$cost_time."秒";
?>Copy after login
7. Determine whether the date format is correct
<?php
/**
* 方法:isdate()
* 功能:判断日期格式是否正确
* 参数:$str 日期字符串 $format日期格式
* 返回:布尔值
*/
function isdate($str,$format="Y-m-d"){
$strArr = explode("-",$str);
if(empty($strArr)){
return false;
}
foreach($strArr as $val){
if(strlen($val)<2){
$val="0".$val;
}
$newArr[]=$val;
}
$str =implode("-",$newArr);
$unixTime=strtotime($str);
$checkDate= date($format,$unixTime);
if($checkDate==$str)
return true;
else
return false;
}
//实例
if(isdate("2010-1-1")){
echo "true";
}else{
echo "false";
}Copy after login
8.DeleteDirectory
<?php
$filecount=0;
$dircount=0;
$file="mail";
function deleteDir($pathName)
{
global $filecount;
global $dircount;
if(file_exists($pathName))
{
if($handle=opendir($pathName))
{
while(($file=readdir($handle)) !==false)
{
if($file !="." && $file !="..")
{
$file=$pathName.DIRECTORY_SEPARATOR.$file;
if( is_dir($file))
{
deleteDir($file);
}else{
if(unlink($file))
{
$filecount++;
echo "文件<b> $file</b>删除成功<br>";
}else{
echo "文件<b> $file</b>删除失败<br>";
}
}
}
}
}
closedir($handle);
if(rmdir($pathName))
{
$dircount++;
echo "目录<b> $pathName</b>删除成功<br>";
}else{
echo "目录<b> $pathName</b>删除失败<br>";
}
}
}
deleteDir($file);
echo "共删除".$filecount."文件，共删除目录".$dircount."个";
?>Copy after login
9. Submission cannot be empty
<input type=text onBlur="if (this.value.length==0) {alert('不能为空');this.focus();}">Copy after login
10.js Automatically jump to the specified page after n seconds
<js> 自动n秒后跳转到指定页面儿
2011-08-12 16:44:00
<script type="text/javascript">
var time =10; //时间,秒
function Redirect(){
window.location = "要跳去的url";
}
var i = 0;
function dis(){
document.all.s.innerHTML = "还剩" + (time - i) + "秒";
i++;
}
timer=setInterval('dis()', 1000); //显示时间
timer=setTimeout('Redirect()',time * 1000); //跳转
</script>
<span id="s"></span>Copy after login
11, Calendar
<?php
/**
* 日历
*/
$time = date('Y-m-d');
if (function_exists('date_default_timezone_set')) {
date_default_timezone_set('PRC');
}
$date = isset($_GET['date']) ? $_GET['date'] : $time;
$date = getdate(strtotime($date));
$end = getdate(mktime(0, 0, 0, $date['mon'] + 1, 1, $date['year']) - 1);
$start = getdate(mktime(0, 0, 0, $date['mon'], 1, $date['year']));
$pre = date('Y-m-d', $start[0] - 1);
$next = date('Y-m-d', $end[0] + 86400);
$html = '<table width="90%" border="1" cellspacing="0" cellpadding="0"
align="center" style="line-height:250%; font-family:Verdana; font-size: 12px;">';
$html .= '<tr>';
$html .= '<td align="center"><a href="' . $PHP_SELF . '?date=' . $pre . '">上个月</a></td>';
$html .= '<td colspan="5" align="center">' . $date['year'] . '-' . $date['mon'] . ' <a href=?date='.date('Y-m-d').'>今天</a></td>';
$html .= '<td align="center"><a href="' . $PHP_SELF . '?date=' . $next . '">下个月</a></td>';
$html .= '</tr>';
$html .= '<tr>';
$html .= '<td>星期日</td>';
$html .= '<td>星期一</td>';
$html .= '<td>星期二</td>';
$html .= '<td>星期三</td>';
$html .= '<td>星期四</td>';
$html .= '<td>星期五</td>';
$html .= '<td>星期六</td>';
$html .= '</tr>';
$arr_tpl = array(0 => '', 1 => '', 2 => '', 3 => '', 4 => '', 5 => '', 6 => '');
$date_arr = array();
$j = 0;
for ($i = 0; $i < $end['mday']; $i++) {
if (!isset($date_arr[$j])) {
$date_arr[$j] = $arr_tpl;
}
$date_arr[$j][($i+$start['wday'])%7] = $i+1;
if ($date_arr[$j][6]) {
$j++;
}
}
foreach ($date_arr as $value) {
$html .= '<tr>';
foreach ($value as $v) {
if ($v>9) {
$vvv=$v;
}else{
$vvv="0".$v;
}
$datemm=$date['year'].'-'.$date['mon'].'-'.$vvv;
if ($v) {
if ($v == $date['mday']) {
$html .= '<td><b>' . $vvv . '</b><br>'.$datemm.'</td>';
} else {
$html .= '<td>' . $vvv . '<br>'.$datemm.' </td>';
}
} else {
$html .= '<td> </td>';
}
}
$html .= '</tr>';
}
$html .= '</table>';
echo $html;
?>Copy after login
The above is the detailed content of Sample code sharing for implementing some small things in PHP. For more information, please follow other related articles on the PHP Chinese website!
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
