CPanel面板利用php实现自动备份网站文件

1 /usr/bin/php -q /home/yourname/backup/fullbackup.php

public static void main(String[] args) throws Exception {
    URL url = new URL("https://api.weixin.qq.com/cgi-bin
                                 /menu/create?access_token=TOKEN");
        String responeJsonStr = "{"+
                                     ""button":["+
                                     "{"name":"酒店预订","+
                                     ""sub_button":["+
                             "{"+
                                ""type":"click","+
                                ""name":"附近酒店","+
                                ""key":"jintoneinn488878-1""+
                            "},"+
                            "{"+
                                ""type":"click","+
                                ""name":"查找酒店","+
                                ""key":"jintoneinn488878-2""+
                            "}"+
                        "]"+
                    "}"
                "]"+
            "}";
        HttpURLConnection conn = (HttpURLConnection) url.openConnection();
        conn.setRequestMethod("POST");
        conn.setDoOutput(true);
        conn.connect();
        conn.getOutputStream().write(responeJsonStr.getBytes("utf-8"));
        InputStream is = conn.getInputStream();
        BufferedReader in = new BufferedReader(new InputStreamReader(is,"utf-8"));
        StringBuffer buffer = new StringBuffer();
        String line = "";
        while ((line = in.readLine()) != null) {
            buffer.append(line);
        }
        System.out.println(buffer.toString()); 
    }

{"menu":{"button":[{"type":"click","name":"今日歌曲","key":"V1001_TODAY_MUSIC","sub_button":[]},{"type":"click","name":"歌手简介","key":"V1001_TODAY_SINGER","sub_button":[]},{"name":"菜单","sub_button":[{"type":"click","name":"hello word","key":"V1001_HELLO_WORLD","sub_button":[]},{"type":"click","name":"赞一下我们","key":"V1001_GOOD","sub_button":[]}]}]}}

<script type="text/javascript" src="ckeditor/ckeditor.js"></script>
<script type="text/javascript">                                                                    window.onload = function()
　　      {
　      　 CKEDITOR.replace( "content" );
　　      };

</script>

<?php
require_once 'Excel/reader.php';
$data = new Spreadsheet_Excel_Reader();
$data->setOutputEncoding('gbk');
$data->read('test.xls');
for ($i = 1; $i <= $data->sheets[0]['numRows']; $i++) {
    for ($j = 1; $j <= $data->sheets[0]['numCols']; $j++) {
        echo """.$data->sheets[0]['cells'][$i][$j]."",";
    }
    echo "n";
}
?>

require_once 'reader.php';

// ExcelFile($filename, $encoding);
$data = new Spreadsheet_Excel_Reader();

// Set output Encoding.
$data->setOutputEncoding('gbk');

//”data.xls”是指要导入到mysql中的excel文件
$data->read('data.xls');

@ $db = mysql_connect('localhost', 'root', '123456') or
       die("Could not connect to database.");//连接数据库
mysql_query("set names 'gbk'");//输出中文
mysql_select_db('mydb');       //选择数据库
error_reporting(E_ALL ^ E_NOTICE);

for ($i = 1; $i <= $data->sheets[0]['numRows']; $i++) {
//以下注释的for循环打印excel表数据
/*
for ($j = 1; $j <= $data->sheets[0]['numCols']; $j++) {
            echo """.$data->sheets[0]['cells'][$i][$j]."",";
           }
           echo "n";
//PHP开源代码

*/
//以下代码是将excel表数据【3个字段】插入到mysql中，根据你的excel表字段的多少，改写以下代码吧！
    $sql = "INSERT INTO test VALUES('".
               $data->sheets[0]['cells'][$i][1]."','".
                 $data->sheets[0]['cells'][$i][2]."','".
                 $data->sheets[0]['cells'][$i][3]."')";
    echo $sql.'
';
       $res = mysql_query($sql);
}

?>

<?php
header("Content-type:application/vnd.ms-excel");
header("Content-Disposition:attachment;filename=Export_test.xls");
$tab="t"; $br="n";
$head="编号".$tab."备注".$br;
//输出内容如下： 
echo $head.$br;
echo  "test321318312".$tab; 
echo  "string1";
echo  $br;

echo  "330181199006061234".$tab;  //直接输出会被Excel识别为数字类型
echo  "number";
echo  $br;

echo  "="330181199006061234"".$tab;  //原样输出需要处理
echo  "string2";
echo  $br;
?>

header("Content-Type:   application/msword");       
header("Content-Disposition:   attachment;   filename=doc.doc"); 

<?php 

// 创建一对cURL资源 

$ch1 = curl_init(); 

$ch2 = curl_init(); 

// 设置URL和相应的选项 

curl_setopt($ch1, CURLOPT_URL, "http://lxr.php.net/"); 

curl_setopt($ch1, CURLOPT_HEADER, 0); 

curl_setopt($ch2, CURLOPT_URL, "http://www.php.net/"); 

curl_setopt($ch2, CURLOPT_HEADER, 0); 

// 创建批处理cURL句柄 

$mh = curl_multi_init(); 

// 增加2个句柄 

curl_multi_add_handle($mh,$ch1); 

curl_multi_add_handle($mh,$ch2); 

$active = null; 

// 执行批处理句柄 

do { 

    $mrc = curl_multi_exec($mh, $active); 

} while ($mrc == CURLM_CALL_MULTI_PERFORM); 

while ($active && $mrc == CURLM_OK) { 

    if (curl_multi_select($mh) != -1) { 

        do { 

            $mrc = curl_multi_exec($mh, $active); 

        } while ($mrc == CURLM_CALL_MULTI_PERFORM); 

    } 

} 

// 关闭全部句柄 

curl_multi_remove_handle($mh, $ch1); 

curl_multi_remove_handle($mh, $ch2); 

curl_multi_close($mh); 

?>

do { 

                        $mrc = curl_multi_exec($mh,$active); 

                 } while ($mrc == CURLM_CALL_MULTI_PERFORM); 

                while ($active and $mrc == CURLM_OK) { 

                        if (curl_multi_select($mh) != -1) { 

                                do { 

                                        $mrc = curl_multi_exec($mh, $active); 

                                 } while ($mrc == CURLM_CALL_MULTI_PERFORM); 

                         } 

                 }