Unknown storage engine ‘InnoDB’ InnoDB报错请切换MyISAM引擎

   在phpmyadmin中执行下列语句:
CREATE TABLE `message` (
  `id` tinyint(1) NOT NULL auto_increment,
  `user` varchar(25) NOT NULL,
  `title` varchar(50) NOT NULL,
  `content` tinytext NOT NULL,
  `lastdate` date NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk AUTO_INCREMENT=1 ;

问题:phpmyadmin报错——Unknown storage engine 'InnoDB'

解决方法:解决方法:
             1.关闭MySQL数据库
        2.修改my.ini文件,把skip-innodb这行注释掉
        3.打开MySQL数据库
当然把innodb改成MyISAM也行

 

php判断设备是否手机

function is_mobile() {
  $user_agent = $_SERVER ['HTTP_USER_AGENT'];
  $mobile_browser = Array (
      "mqqbrowser", // 手机QQ浏览器
      "opera mobi", // 手机opera
      "juc",
      "iuc", // uc浏览器
      "fennec",
      "ios",
      "applewebKit/420",
      "applewebkit/525",
      "applewebkit/532",
      "ipad",
      "iphone",
      "ipaq",
      "ipod",
      "iemobile",
      "windows ce", // windows phone
      "240×320",
      "480×640",
      "acer",
      "android",
      "anywhereyougo.com",
      "asus",
      "audio",
      "blackberry",
      "blazer",
      "coolpad",
      "dopod",
      "etouch",
      "hitachi",
      "htc",
      "huawei",
      "jbrowser",
      "lenovo",
      "lg",
      "lg-",
      "lge-",
      "lge",
      "mobi",
      "moto",
      "nokia",
      "phone",
      "samsung",
      "sony",
      "symbian",
      "tablet",
      "tianyu",
      "wap",
      "xda",
      "xde",
      "zte"
  );
  $is_mobile = false;
  foreach ( $mobile_browser as $device ) {
    if (stristr ( $user_agent, $device )) {
      $is_mobile = true;
      break;
    }
  }
  return $is_mobile;
}

 

canvas创建/图片和base64互转

部分参考自http://blog.csdn.net/renfufei/article/details/9855519

创建canvas

var canvas = document.createElement('canvas'); 
canvas.id     = "CursorLayer"; 
canvas.width  = 1224; 
canvas.height = 768; 
canvas.style.zIndex   = 8; 
canvas.style.position = "absolute"; 
canvas.style.border   = "1px solid";
document.body.appendChild(canvas);

图片转base64

// 把image 转换为 canvas对象  
function convertImageToCanvas(image) {  
    // 创建canvas DOM元素,并设置其宽高和图片一样   
    var canvas = document.createElement("canvas");  
    canvas.width = image.width;  
    canvas.height = image.height;  
    // 坐标(0,0) 表示从此处开始绘制,相当于偏移。  
    canvas.getContext("2d").drawImage(image, 0, 0);  
  
    return canvas;  
}

 

base64转图片

var fin = new Image();
    fin.src =  canvas.toDataURL("image/jpg");
document.body.appendChild(fin);