php中實現資料儲存在excel

bluepeach發表於2021-09-09
PHPExcel

index.php為入口，為一個表單，結構比較簡單。只貼上js程式碼部分：


 function onext(){    var isMobile=/^(?:13d|15d|18d)d{5}(d{3}|*{3})$/;      var isPhone=/^((0d{2,3})-)?(d{7,8})(-(d{3,}))?$/;    var iname=$('input[name=iname]').val();    var phone=$('input[name=phone]').val();    var wp=$('input[name=workplace]').val();    if(iname=='' || phone=='' || wp==''){        showDialog('alert', '請檢查姓名、電話號碼或者工作單位有沒有填寫', "線上登記", "430");        return false;    }    if(phone!='' && !isMobile.test(phone) && !isPhone.test(phone)){        showDialog('alert', '你填寫的電話號碼格式不正確。', "線上登記", "430");        return false;    }    document.ad.submit();}

引用了一個jquery.showdialog的函式


 function detectMacXFF() {    var userAgent = navigator.userAgent.toLowerCase();    if(userAgent.indexOf("mac") != -1 && userAgent.indexOf("firefox") != -1) {        return true;    }}function in_array(needle, haystack) {    if(typeof needle == "string" || typeof needle == "number") {        for(var i in haystack) {            if(haystack[i] == needle) {                return true;            }        }    }    return false;}function sd_load(sd_width) {    if(sd_width) {        $("#SD_window").css("width", sd_width + "px");    }    var sd_top = ($(window).height() - $("#SD_window").height()) / 2 + $(document).scrollTop();    if(sd_top         sd_top = 0;    }    var sd_left = ($(window).width() - $("#SD_window").width()) / 2;    if(sd_left         sd_left = 0;    }    $("#SD_window").css("top", sd_top);    $("#SD_window").css("left", sd_left);}function sd_remove() {    $("#SD_close,#SD_cancel,#SD_confirm").unbind("click");    $("#SD_window,#SD_overlay,#SD_HideSelect").remove();    if(typeof document.body.style.maxHeight == "undefined") {        $("body","html").css({height: "auto", width: "auto"});    }}function showDialog(mode, msg, t, sd_width) {    var sd_width = sd_width ? sd_width : 400;    var mode = in_array(mode, ['confirm', 'window', 'info', 'loading']) ? mode : 'alert';    var t = t ? t : "提示資訊";    var msg = msg ? msg : "";    var confirmtxt = confirmtxt ? confirmtxt : "確定";    var canceltxt = canceltxt ? canceltxt : "取消";    sd_remove();    try {        if(typeof document.body.style.maxHeight === "undefined") {            $("body","html").css({height: "100%", width: "100%"});            if(document.getElementById("SD_HideSelect") === null) {                $("body").append("
");            }        } else {            if(document.getElementById("SD_overlay") === null) {                $("body").append("
");            }        }        if(mode == "alert") {            if(detectMacXFF()) {                $("#SD_overlay").addClass("SD_overlayMacFFBGHack");            } else {                $("#SD_overlay").addClass("SD_overlayBG");            }        } else {            if(detectMacXFF()) {                $("#SD_overlay").addClass("SD_overlayMacFFBGHack2");            } else {                $("#SD_overlay").addClass("SD_overlayBG2");            }        }        $("body").append("
");        var SD_html;        SD_html = "";        SD_html += "";        SD_html += "";        SD_html += "";        SD_html += "";        SD_html += "
";        SD_html += "

"

 + t + "";        SD_html += "
" + msg + "
";        SD_html += "
";        SD_html += " + confirmtxt + "";        SD_html += " + canceltxt + "";        SD_html += "
";        SD_html += "";        SD_html += "
";        $("#SD_window").append(SD_html);        $("#SD_confirm,#SD_cancel,#SD_close").bind("click", function(){            sd_remove();        });        if(mode == "info" || mode == "alert") {            $("#SD_cancel").hide();            $("#SD_button").show();        }        if(mode == "window") {            $("#SD_close").show();        }        if(mode == "confirm") {            $("#SD_button").show();        }        var sd_move = false;        var sd_x, sd_y;        $("#SD_container > h3").click(function(){}).mousedown(function(e){            sd_move = true;            sd_x = e.pageX - parseInt($("#SD_window").css("left"));            sd_y = e.pageY - parseInt($("#SD_window").css("top"));        });        $(document).mousemove(function(e){            if(sd_move){                var x = e.pageX - sd_x;                var y = e.pageY - sd_y;                $("#SD_window").css({left:x, top:y});            }        }).mouseup(function(){            sd_move = false;        });        $("#SD_body").width(sd_width - 50);        sd_load(sd_width);        $("#SD_window").show();        $("#SD_window").focus();    } catch(e) {        alert("System Error !");    }}function showInfo(msg, fn, timeout) {    showDialog("info", msg);    $("#SD_confirm").unbind("click");    if(fn && timeout) {        st = setTimeout(function(){            sd_remove();            fn();        }, timeout * 1000);    }    $("#SD_confirm").bind("click", function(){        if(timeout) {            clearTimeout(st);        }        sd_remove();        if(fn) {            fn();        }    });}function showWindow(title, the_url, sd_width) {    var sd_width = sd_width ? sd_width : 400;    $.ajax({        type        : "GET",        dataType    : "html",        cache       : false,        timeout     : 10000,        url         : the_url,        data        : "isajax=1",        success     : function(data){            showDialog("window", data, title, sd_width);        },        error       : function(data){            showDialog("alert", "讀取資料失敗");        },        beforeSend  : function(data){            showDialog("loading", "正在讀取資料...");        }    });}function showConfirm(msg, fn) {    showDialog("confirm", msg);    $("#SD_confirm").unbind("click");    $("#SD_confirm").bind("click", function(){        if(fn) {            fn();        }    });}

提交後的處理程式i.php


 //dataheader('Content-Type:text/html;charset=utf-8');$iname=iconv("UTF-8","gbk",trim($_POST['iname']));$phone=iconv("UTF-8","gbk",trim($_POST['phone']));$workplace=iconv("UTF-8","gbk",trim($_POST['workplace']));$ksobject=iconv("UTF-8","gbk",$_POST['ksobject']);//date_default_timezone_set('Etc/GMT-8');     //這裡設定了時區$time= date("Y-m-d H:i:s");$fp = fopen("ksdata.csv","a"); //開啟csv檔案，如果不存在則建立//$data_1 = array($name,$cartype,$buycar,$phone,$email,$time,$carnumber);$data_1=array($iname,$phone,$workplace,$ksobject);$data_1 = implode(",",$data_1); // 用 ' 分割成字串$data_str =$data_1."rn"; //加入換行符$p=fwrite($fp,$data_str); // 寫入資料//echo $p;if($p!=null&&$p!=""){    //echo "ok...";}else{    echo ";}fclose($fp); //關閉檔案控制程式碼// echo "提交成功";echo ";  ?>


來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/2558/viewspace-2804935/，如需轉載，請註明出處，否則將追究法律責任。

相關文章