Use ExcelFileParser in PHP to process excel to obtain data (can be imported into the database in batches)_PHP tutorial

WBOY
Release: 2016-07-21 15:35:16
Original
1008 people have browsed it

Copy code The code is as follows:





Excel data acquisition demonstration< ;/title> <br><meta name="Keywords" content="TODO" /> <br><meta name="Description" content="TODO"/> <br></head> <br><body> <br><div> <br><div>Excel data acquisition demonstration</div> <br><div> <br><form method="POST" action= "/Index/parse" enctype="multipart/form-data"> <br><input type="file" name="excel" value="" /> <br><input type="submit " name="submit" value="Submit" /> <br></form> <br></div> <br></div> <br></body> <br>< ;/html> <br> </div> <br><div class="codetitle"> <span style="CURSOR: pointer" onclick="doCopy('code257')"><u>Copy code </u></span> The code is as follows: </div> <div class="codebody" id="code257"> <br><?php <BR>/ **<BR>* CopyRight (c) 2009, <BR>* All rights reserved. <BR>* File name: <BR>* Summary: <BR>* <BR>* @author Saturday [url=mailto:ixqbar@ hotmail.com]ixqbar@hotmail.com[/url] <BR>* @version <BR>*/ <br><br>public function parse() <BR>{ <BR>/**<BR>* $_FILES array description<BR>* array(n) { <BR>* ["form file box name"] => array(5) { <BR>* ["name"] => Submit File name <BR>* ["type"] => Submit file type Excel as "application/vnd.ms-excel" <BR>* ["tmp_name"] => Temporary file name <BR>* ["error "] => Error (0 Success 1 File too large exceeds upload_max_filesize 2 File too large exceeds MAX_FILE 3 Incomplete upload 4 No file uploaded) <BR>* ["size"] => File size (unit: KB) <BR> * } <BR>* } <BR>*/ <BR>$return=array(0,''); <BR> /**<BR>* Determine whether to submit <BR>* is_uploaded_file (file name) is used to determine whether the specified file is uploaded using the POST method to prevent illegal submission. It is usually used together with move_upload_file to save the uploaded file to the specified path <BR>*/ <BR>if(!isset($_FILES) || !is_uploaded_file($_FILES['excel']['tmp_name'])) <BR>{ <BR>$return=array( 1,'Submission is illegal'); <BR>} <BR>//Processing<BR>if(0 == $return[0]) <BR>{ <BR>import('@.Util.ExcelParser') ; <BR>$excel=new ExcelParser($_FILES['excel']['tmp_name']); <BR>$return=$excel->main(); <br>} <br>//Output processing <br>print_r($return); <br>?> <br> </div> <br><div class="codetitle"> <span style="CURSOR: pointer" onclick="doCopy('code78230')"><u>Copy code</u></span> The code is as follows:</div> <div class="codebody" id="code78230"> <br><?php <BR>/**<BR>* CopyRight (c) 2009, <BR>* All rights reserved. <BR>* File name: excel data acquisition<BR>* Summary: <BR>* <BR>* @author Monday [url=mailto :ixqbar@hotmail.com]ixqbar@hotmail.com[/url] <BR>* @version 0.1 <BR>*/ <BR>class ExcelParser <BR>{ <BR>private $_data=array(0,''); <BR>private $ _excel_handle; <BR>private $_excel=array(); <BR>/**<BR>* Constructor <BR>* @param <string> $filename Temporary file name of uploaded file <br>*/ <br>public function __construct($filename) <br>{ <br>/**<br>* Introduce excelparser class <br>* The common method is <br>* requires path.'excelparser.php'; <br>*/ <br>import('@.Util.PHPExcelParser.excelparser','','.php'); <br>$this->_excel_handle=new ExcelFileParser(); <br>//Error getting<br>$this ->checkErrors($filename); <br>} <br>/**<br>* Error checking <br>*/ <br>private function checkErrors($filename) <br>{ <br>/**<br>* Method 1 <br>*/ <br>$error_code=$this->_excel_handle->ParseFromFile($filename); <br>/**<br>* 方法二 <br>* $file_handle = fopen($this->_filename,'rb'); <br>* $content = fread($file_handle,filesize($this->_filename)); <br>* fclose($file_handle); <br>* $error_code = $this->_excel->ParseFromString($content); <br>* unset($content,$file_handle); <br>*/ <br>switch($error_code) <br>{ <br>case 0: <br>//No error, no processing<br>break; <br>case 1: <br>$this->_data=array(1,'File reading error (Linux pay attention to read and write permissions)'); <br>break; <br>case 2: <br>$this->_data=array(1,'File too small'); <br>break; <br>case 3: <br>$this->_data =array(1,'Failed to read Excel header'); <br>break; <br>case 4: <br>$this->_data=array(1,'File reading error'); <br>break; <br>case 5: <br>$this->_data=array(1,'The file may be empty'); <br>break; <br>case 6: <br>$this-> _data=array(1,'Incomplete file'); <br>break; <br>case 7: <br>$this->_data=array(1,'Error reading data'); <br>break ; <br>case 8: <br>$this->_data=array(1,'version error'); <br>break; <br>} <br>unset($error_code); <br>} <br>/**<br>* Excel information acquisition <br>*/ <br>private function getExcelInfo() <br>{ <br>if(1==$this->_data[0])return; <br>/**<br>* Get the number of sheets <br>* Get the rows and columns corresponding to the sheet unit <br>*/ <br>$this->_excel['sheet_number']=count($this->_excel_handle->worksheet['name']); <br>for($i=0;$i< $this->_excel['sheet_number'];$i++) <br>{ <br>/**<br>* rows in columns <br>* Note: counting starts from 0 <br>*/ <br>$row=$this->_excel_handle->worksheet['data' ][$i]['max_row']; <br>$col=$this->_excel_handle->worksheet['data'][$i]['max_col']; <br>$this-> _excel['row_number'][$i]=($row==NULL)?0:++$row; <br>$this->_excel['col_number'][$i]=($col== NULL)?0:++$col; <br>unset($row,$col); <br>} <br>} <br>/**<br>* Chinese processing function <br>* @return <string> <br>*/ <br>private function uc2html($str ) <br>{ <br>$ret = ''; <br>for( $i=0; $i<strlen($str)/2; $i++ ) <BR>{ <BR>$charcode = ord( $str[$i*2])+256*ord($str[$i*2+1]); <BR>$ret .= '&#'.$charcode.';'; <BR>} <BR>return mb_convert_encoding($ret,'UTF-8','HTML-ENTITIES'); <BR>} <BR>/**<BR>* Excel data acquisition <BR>*/ <BR>private function getExcelData() <BR>{ <BR>if(1==$this->_data[0])return; <br>//Modify mark<br>$this->_data[0]=1; <br>//Get data<br> for($i=0;$i<$this->_excel['sheet_number'];$i++) <br>{ <br>/**<br>* Loop over rows <br>*/ <br>for($j=0; $j<$this->_excel['row_number'][$i];$j++) <br>{ <br>/**<br>* Alignment loop <br>*/ <br>for($k=0;$k< $this->_excel['col_number'][$i];$k++) <br>{ <br>/**<br>* array(4) { <br>* ["type"] => Type [0 character type 1 integer 2 floating point number 3 date] <br>* ["font"] => Font <br> * ["data"] => data<br>* ... <br>* } <br>*/ <br>$data=$this->_excel_handle->worksheet ['data'][$i]['cell'][$j][$k]; <br>switch($data['type']) <br>{ <br>case 0: <br>/ /Character type<br>if($this->_excel_handle->sst['unicode'][$data['data']]) <br>{ <br>//Chinese processing<br>$data[ 'data'] = $this->uc2html($this->_excel_handle->sst['data'][$data['data']]); <br>} <br>else <br>{ <br>$data['data'] = $this->_excel_handle->sst['data'][$data['data']]; <br>} <br>break; <br>case 1 : <br>//Integer<br>//TODO <br>break; <br>case 2: <br>//Floating point<br>//TODO <br>break; <br>case 3: <br>//Date<br>//TODO <br>break; <br>} <br>$this->_data[1][$i][$j][$k]=$data['data' ]; <br>unset($data); <br>} <br>} <br>} <br>} <br>/**<br>* Main function <br>* @return <array> array(identifier, content s) <br>*/ <br>public function main() <br>{ <br>//Get Excel information<br>$this->getExcelInfo(); <br>//Get Excel data<br>$this->getExcelData(); <br>return $this->_data ; <br>} <br>} <br>?> <br> </div> <p align="left"></p> <div style="display:none;"> <span id="url" itemprop="url">http://www.bkjia.com/PHPjc/322271.html</span><span id="indexUrl" itemprop="indexUrl">www.bkjia.com</span><span id="isOriginal" itemprop="isOriginal">true</span><span id="isBasedOnUrl" itemprop="isBasedOnUrl">http: //www.bkjia.com/PHPjc/322271.html</span><span id="genre" itemprop="genre">TechArticle</span><span id="description" itemprop="description">Copy the code as follows: !DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd" html xmlns="http://www.w3.org/199...</span> </div> <div class="art_confoot"></div> </div> </div> <div style="height: 25px;"> <div class="wzconBq" style="display: inline-flex;"> <span>Related labels:</span> <div class="wzcbqd"> <a onclick="hits_log(2,'www',this);" href-data="http://www.php.cn/search?word=excel" target="_blank">excel</a> <a onclick="hits_log(2,'www',this);" href-data="http://www.php.cn/search?word=php" target="_blank">php</a> <a onclick="hits_log(2,'www',this);" href-data="http://www.php.cn/search?word=code" target="_blank">code</a> <a onclick="hits_log(2,'www',this);" href-data="http://www.php.cn/search?word=use" target="_blank">use</a> <a onclick="hits_log(2,'www',this);" href-data="http://www.php.cn/search?word=dealwith" target="_blank">deal with</a> <a onclick="hits_log(2,'www',this);" href-data="http://www.php.cn/search?word=copy" target="_blank">copy</a> <a onclick="hits_log(2,'www',this);" href-data="http://www.php.cn/search?word=import" target="_blank">import</a> <a onclick="hits_log(2,'www',this);" href-data="http://www.php.cn/search?word=batch" target="_blank">batch</a> <a onclick="hits_log(2,'www',this);" href-data="http://www.php.cn/search?word=data" target="_blank">data</a> <a onclick="hits_log(2,'www',this);" href-data="http://www.php.cn/search?word=database" target="_blank">database</a> <a onclick="hits_log(2,'www',this);" href-data="http://www.php.cn/search?word=get" target="_blank">get</a> </div> </div> <div style="display: inline-flex;float: right; color:#333333;">source:php.cn</div> </div> <div class="wzconOtherwz"> <a href="http://www.php.cn/faq/309728.html" title="How to set up graphics and text in php using Visual Studio_PHP tutorial"> <span>Previous article:How to set up graphics and text in php using Visual Studio_PHP tutorial</span> </a> <a href="http://www.php.cn/faq/309730.html" title="Ajax implements refresh-free paging (php)_PHP tutorial"> <span>Next article:Ajax implements refresh-free paging (php)_PHP tutorial</span> </a> </div> <div class="wzconShengming"> <div class="bzsmdiv">Statement of this Website</div> <div>The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn</div> </div> <div class="wwads-cn wwads-horizontal" data-id="156" style="max-width:955px"></div> <div class="wzconZzwz"> <div class="wzconZzwztitle">Latest Articles by Author</div> <ul> <li> <div class="wzczzwzli"> <span class="layui-badge-dots"></span> <a target="_blank" href="http://www.php.cn/faq/1796639331.html">What is a NullPointerException, and how do I fix it?</a> </div> <div>2024-10-22 09:46:29</div> </li> <li> <div class="wzczzwzli"> <span class="layui-badge-dots"></span> <a target="_blank" href="http://www.php.cn/faq/1796629482.html">From Novice to Coder: Your Journey Begins with C Fundamentals</a> </div> <div>2024-10-13 13:53:41</div> </li> <li> <div class="wzczzwzli"> <span class="layui-badge-dots"></span> <a target="_blank" href="http://www.php.cn/faq/1796628545.html">Unlocking Web Development with PHP: A Beginner's Guide</a> </div> <div>2024-10-12 12:15:51</div> </li> <li> <div class="wzczzwzli"> <span class="layui-badge-dots"></span> <a target="_blank" href="http://www.php.cn/faq/1796627928.html">Demystifying C: A Clear and Simple Path for New Programmers</a> </div> <div>2024-10-11 22:47:31</div> </li> <li> <div class="wzczzwzli"> <span class="layui-badge-dots"></span> <a target="_blank" href="http://www.php.cn/faq/1796627806.html">Unlock Your Coding Potential: C Programming for Absolute Beginners</a> </div> <div>2024-10-11 19:36:51</div> </li> <li> <div class="wzczzwzli"> <span class="layui-badge-dots"></span> <a target="_blank" href="http://www.php.cn/faq/1796627670.html">Unleash Your Inner Programmer: C for Absolute Beginners</a> </div> <div>2024-10-11 15:50:41</div> </li> <li> <div class="wzczzwzli"> <span class="layui-badge-dots"></span> <a target="_blank" href="http://www.php.cn/faq/1796627643.html">Automate Your Life with C: Scripts and Tools for Beginners</a> </div> <div>2024-10-11 15:07:41</div> </li> <li> <div class="wzczzwzli"> <span class="layui-badge-dots"></span> <a target="_blank" href="http://www.php.cn/faq/1796627620.html">PHP Made Easy: Your First Steps in Web Development</a> </div> <div>2024-10-11 14:21:21</div> </li> <li> <div class="wzczzwzli"> <span class="layui-badge-dots"></span> <a target="_blank" href="http://www.php.cn/faq/1796627574.html">Build Anything with Python: A Beginner's Guide to Unleashing Your Creativity</a> </div> <div>2024-10-11 12:59:11</div> </li> <li> <div class="wzczzwzli"> <span class="layui-badge-dots"></span> <a target="_blank" href="http://www.php.cn/faq/1796627539.html">The Key to Coding: Unlocking the Power of Python for Beginners</a> </div> <div>2024-10-11 12:17:31</div> </li> </ul> </div> <div class="wzconZzwz"> <div class="wzconZzwztitle">Latest Issues</div> <div class="wdsyContent"> <div class="wdsyConDiv flexRow wdsyConDiv1"> <div class="wdcdContent flexColumn"> <a href="http://www.php.cn/wenda/176400.html" target="_blank" title="PHP arrays obtained from URL parameters do not behave as expected" class="wdcdcTitle">PHP arrays obtained from URL parameters do not behave as expected</a> <a href="http://www.php.cn/wenda/176400.html" class="wdcdcCons">I have a URL parameter that contains the category ID and I want to treat it as an array li...</a> <div class="wdcdcInfo flexRow"> <div class="wdcdcileft"> <span class="wdcdciSpan"> From 2024-04-06 22:09:02</span> </div> <div class="wdcdciright flexRow"> <div class="wdcdcirdz flexRow ira"> <b class="wdcdcirdzi"></b>0 </div> <div class="wdcdcirpl flexRow ira"><b class="wdcdcirpli"></b>1</div> <div class="wdcdcirwatch flexRow ira"><b class="wdcdcirwatchi"></b>1428</div> </div> </div> </div> </div> <div class="wdsyConLine wdsyConLine2"></div> <div class="wdsyConDiv flexRow wdsyConDiv1"> <div class="wdcdContent flexColumn"> <a href="http://www.php.cn/wenda/176398.html" target="_blank" title="Where should I place CustomLog directive in apache" class="wdcdcTitle">Where should I place CustomLog directive in apache</a> <a href="http://www.php.cn/wenda/176398.html" class="wdcdcCons">I'm using php:7.2-apachedocker. I need to disable health check url login access log. Based...</a> <div class="wdcdcInfo flexRow"> <div class="wdcdcileft"> <span class="wdcdciSpan"> From 2024-04-06 22:03:59</span> </div> <div class="wdcdciright flexRow"> <div class="wdcdcirdz flexRow ira"> <b class="wdcdcirdzi"></b>0 </div> <div class="wdcdcirpl flexRow ira"><b class="wdcdcirpli"></b>1</div> <div class="wdcdcirwatch flexRow ira"><b class="wdcdcirwatchi"></b>990</div> </div> </div> </div> </div> <div class="wdsyConLine wdsyConLine2"></div> <div class="wdsyConDiv flexRow wdsyConDiv1"> <div class="wdcdContent flexColumn"> <a href="http://www.php.cn/wenda/176397.html" target="_blank" title="What is the format of the variables in the return value?" class="wdcdcTitle">What is the format of the variables in the return value?</a> <a href="http://www.php.cn/wenda/176397.html" class="wdcdcCons">I am a new learner of php. I found a piece of code: if($x<time()){return[false,'error']...</a> <div class="wdcdcInfo flexRow"> <div class="wdcdcileft"> <span class="wdcdciSpan"> From 2024-04-06 21:55:20</span> </div> <div class="wdcdciright flexRow"> <div class="wdcdcirdz flexRow ira"> <b class="wdcdcirdzi"></b>0 </div> <div class="wdcdcirpl flexRow ira"><b class="wdcdcirpli"></b>1</div> <div class="wdcdcirwatch flexRow ira"><b class="wdcdcirwatchi"></b>778</div> </div> </div> </div> </div> <div class="wdsyConLine wdsyConLine2"></div> <div class="wdsyConDiv flexRow wdsyConDiv1"> <div class="wdcdContent flexColumn"> <a href="http://www.php.cn/wenda/176382.html" target="_blank" title="Problems encountered when using opentbs to generate odt files: values ​​of the same key are displayed in the same row instead of separate columns." class="wdcdcTitle">Problems encountered when using opentbs to generate odt files: values ​​of the same key are displayed in the same row instead of separate columns.</a> <a href="http://www.php.cn/wenda/176382.html" class="wdcdcCons">I'm using a library called OpenTbs to create odt using PHP, I'm using it because columns a...</a> <div class="wdcdcInfo flexRow"> <div class="wdcdcileft"> <span class="wdcdciSpan"> From 2024-04-06 20:18:18</span> </div> <div class="wdcdciright flexRow"> <div class="wdcdcirdz flexRow ira"> <b class="wdcdcirdzi"></b>0 </div> <div class="wdcdcirpl flexRow ira"><b class="wdcdcirpli"></b>1</div> <div class="wdcdcirwatch flexRow ira"><b class="wdcdcirwatchi"></b>483</div> </div> </div> </div> </div> <div class="wdsyConLine wdsyConLine2"></div> <div class="wdsyConDiv flexRow wdsyConDiv1"> <div class="wdcdContent flexColumn"> <a href="http://www.php.cn/wenda/176363.html" target="_blank" title="Group MySQL results by ID for looping over" class="wdcdcTitle">Group MySQL results by ID for looping over</a> <a href="http://www.php.cn/wenda/176363.html" class="wdcdcCons">I have a table with flight data in mysql. I'm writing a php code that will group and displ...</a> <div class="wdcdcInfo flexRow"> <div class="wdcdcileft"> <span class="wdcdciSpan"> From 2024-04-06 17:27:56</span> </div> <div class="wdcdciright flexRow"> <div class="wdcdcirdz flexRow ira"> <b class="wdcdcirdzi"></b>0 </div> <div class="wdcdcirpl flexRow ira"><b class="wdcdcirpli"></b>1</div> <div class="wdcdcirwatch flexRow ira"><b class="wdcdcirwatchi"></b>406</div> </div> </div> </div> </div> <div class="wdsyConLine wdsyConLine2"></div> </div> </div> <div class="wzconZt" > <div class="wzczt-title"> <div>Related Topics</div> <a href="http://www.php.cn/faq/zt" target="_blank">More> </a> </div> <div class="wzcttlist"> <ul> <li class="ul-li"> <a target="_blank" href="http://www.php.cn/faq/shujksfs"><img src="https://img.php.cn/upload/subject/202407/22/2024072214381060018.jpg?x-oss-process=image/resize,m_fill,h_145,w_220" alt="Database three paradigms" /> </a> <a target="_blank" href="http://www.php.cn/faq/shujksfs" class="title-a-spanl" title="Database three paradigms"><span>Database three paradigms</span> </a> </li> <li class="ul-li"> <a target="_blank" href="http://www.php.cn/faq/exceldbllsj"><img src="https://img.php.cn/upload/subject/202407/22/2024072214295968820.jpg?x-oss-process=image/resize,m_fill,h_145,w_220" alt="Compare the similarities and differences between two columns of data in excel" /> </a> <a target="_blank" href="http://www.php.cn/faq/exceldbllsj" class="title-a-spanl" title="Compare the similarities and differences between two columns of data in excel"><span>Compare the similarities and differences between two columns of data in excel</span> </a> </li> <li class="ul-li"> <a target="_blank" href="http://www.php.cn/faq/excelcfx"><img src="https://img.php.cn/upload/subject/202407/22/2024072214280640743.jpg?x-oss-process=image/resize,m_fill,h_145,w_220" alt="excel duplicate item filter color" /> </a> <a target="_blank" href="http://www.php.cn/faq/excelcfx" class="title-a-spanl" title="excel duplicate item filter color"><span>excel duplicate item filter color</span> </a> </li> <li class="ul-li"> <a target="_blank" href="http://www.php.cn/faq/excelfzbg"><img src="https://img.php.cn/upload/subject/202407/22/2024072214264786547.jpg?x-oss-process=image/resize,m_fill,h_145,w_220" alt="How to copy an Excel table to make it the same size as the original" /> </a> <a target="_blank" href="http://www.php.cn/faq/excelfzbg" class="title-a-spanl" title="How to copy an Excel table to make it the same size as the original"><span>How to copy an Excel table to make it the same size as the original</span> </a> </li> <li class="ul-li"> <a target="_blank" href="http://www.php.cn/faq/excelbgxxyfwe"><img src="https://img.php.cn/upload/subject/202407/22/2024072214264258410.jpg?x-oss-process=image/resize,m_fill,h_145,w_220" alt="Excel table slash divided into two" /> </a> <a target="_blank" href="http://www.php.cn/faq/excelbgxxyfwe" class="title-a-spanl" title="Excel table slash divided into two"><span>Excel table slash divided into two</span> </a> </li> <li class="ul-li"> <a target="_blank" href="http://www.php.cn/faq/excelxxbtyfwe"><img src="https://img.php.cn/upload/subject/202407/22/2024072214263636026.jpg?x-oss-process=image/resize,m_fill,h_145,w_220" alt="Excel diagonal header is divided into two" /> </a> <a target="_blank" href="http://www.php.cn/faq/excelxxbtyfwe" class="title-a-spanl" title="Excel diagonal header is divided into two"><span>Excel diagonal header is divided into two</span> </a> </li> <li class="ul-li"> <a target="_blank" href="http://www.php.cn/faq/juedyydsr"><img src="https://img.php.cn/upload/subject/202407/22/2024072214223414868.jpg?x-oss-process=image/resize,m_fill,h_145,w_220" alt="Absolute reference input method" /> </a> <a target="_blank" href="http://www.php.cn/faq/juedyydsr" class="title-a-spanl" title="Absolute reference input method"><span>Absolute reference input method</span> </a> </li> <li class="ul-li"> <a target="_blank" href="http://www.php.cn/faq/rhscsjk"><img src="https://img.php.cn/upload/subject/202407/22/2024072214195694280.jpg?x-oss-process=image/resize,m_fill,h_145,w_220" alt="How to delete a database" /> </a> <a target="_blank" href="http://www.php.cn/faq/rhscsjk" class="title-a-spanl" title="How to delete a database"><span>How to delete a database</span> </a> </li> </ul> </div> </div> </div> </div> <div class="phpwzright"> <div class="wzrOne"> <div class="wzroTitle">Popular Recommendations</div> <div class="wzroList"> <ul> <li> <div class="wzczzwzli"> <span class="layui-badge-dots wzrolr"></span> <a style="height: auto;" title="How to set up hosts on Mac computer (steps with pictures and text)" href="http://www.php.cn/faq/448310.html">How to set up hosts on Mac computer (steps with pictures and text)</a> </div> </li> <li> <div class="wzczzwzli"> <span class="layui-badge-dots wzrolr"></span> <a style="height: auto;" title="Quickly build a simple QQ robot with PHP" href="http://www.php.cn/faq/448391.html">Quickly build a simple QQ robot with PHP</a> </div> </li> <li> <div class="wzczzwzli"> <span class="layui-badge-dots wzrolr"></span> <a style="height: auto;" title="API common signature verification methods (PHP implementation)" href="http://www.php.cn/faq/448286.html">API common signature verification methods (PHP implementation)</a> </div> </li> <li> <div class="wzczzwzli"> <span class="layui-badge-dots wzrolr"></span> <a style="height: auto;" title="Collection of common date and time operations in PHP" href="http://www.php.cn/faq/448309.html">Collection of common date and time operations in PHP</a> </div> </li> <li> <div class="wzczzwzli"> <span class="layui-badge-dots wzrolr"></span> <a style="height: auto;" title="PHP generates graphic verification code (enhanced interference type)" href="http://www.php.cn/faq/448308.html">PHP generates graphic verification code (enhanced interference type)</a> </div> </li> </ul> </div> </div> <script src="https://sw.php.cn/hezuo/cac1399ab368127f9b113b14eb3316d0.js" type="text/javascript"></script> <div class="wzrThree"> <div class="wzrthree-title"> <div>Popular Tutorials</div> <a target="_blank" href="http://www.php.cn/course.html">More> </a> </div> <div class="wzrthreelist swiper2"> <div class="wzrthreeTab swiper-wrapper"> <div class="check tabdiv swiper-slide" data-id="one">Related Tutorials <div></div></div> <div class="tabdiv swiper-slide" data-id="two">Popular Recommendations<div></div></div> <div class="tabdiv swiper-slide" data-id="three">Latest courses<div></div></div> </div> <ul class="one"> <li> <a target="_blank" href="http://www.php.cn/course/812.html" title="The latest ThinkPHP 5.1 world premiere video tutorial (60 days to become a PHP expert online training course)" class="wzrthreelaimg"> <img src="https://img.php.cn/upload/course/000/000/041/620debc3eab3f377.jpg" alt="The latest ThinkPHP 5.1 world premiere video tutorial (60 days to become a PHP expert online training course)"/> </a> <div class="wzrthree-right"> <a target="_blank" title="The latest ThinkPHP 5.1 world premiere video tutorial (60 days to become a PHP expert online training course)" href="http://www.php.cn/course/812.html">The latest ThinkPHP 5.1 world premiere video tutorial (60 days to become a PHP expert online training course)</a> <div class="wzrthreerb"> <div>1418666 <b class="kclbcollectb"></b></div> <div class="courseICollection" data-id="812"> <b class="nofollow small-nocollect"></b> </div> </div> </div> </li> <li> <a target="_blank" href="http://www.php.cn/course/74.html" title="PHP introductory tutorial one: Learn PHP in one week" class="wzrthreelaimg"> <img src="https://img.php.cn/upload/course/000/000/068/6253d1e28ef5c345.png" alt="PHP introductory tutorial one: Learn PHP in one week"/> </a> <div class="wzrthree-right"> <a target="_blank" title="PHP introductory tutorial one: Learn PHP in one week" href="http://www.php.cn/course/74.html">PHP introductory tutorial one: Learn PHP in one week</a> <div class="wzrthreerb"> <div>4260199 <b class="kclbcollectb"></b></div> <div class="courseICollection" data-id="74"> <b class="nofollow small-nocollect"></b> </div> </div> </div> </li> <li> <a target="_blank" href="http://www.php.cn/course/286.html" title="JAVA Beginner's Video Tutorial" class="wzrthreelaimg"> <img src="https://img.php.cn/upload/course/000/000/068/62590a2bacfd9379.png" alt="JAVA Beginner's Video Tutorial"/> </a> <div class="wzrthree-right"> <a target="_blank" title="JAVA Beginner's Video Tutorial" href="http://www.php.cn/course/286.html">JAVA Beginner's Video Tutorial</a> <div class="wzrthreerb"> <div>2495597 <b class="kclbcollectb"></b></div> <div class="courseICollection" data-id="286"> <b class="nofollow small-nocollect"></b> </div> </div> </div> </li> <li> <a target="_blank" href="http://www.php.cn/course/504.html" title="Little Turtle's zero-based introduction to learning Python video tutorial" class="wzrthreelaimg"> <img src="https://img.php.cn/upload/course/000/000/068/62590a67ce3a6655.png" alt="Little Turtle's zero-based introduction to learning Python video tutorial"/> </a> <div class="wzrthree-right"> <a target="_blank" title="Little Turtle's zero-based introduction to learning Python video tutorial" href="http://www.php.cn/course/504.html">Little Turtle's zero-based introduction to learning Python video tutorial</a> <div class="wzrthreerb"> <div>504733 <b class="kclbcollectb"></b></div> <div class="courseICollection" data-id="504"> <b class="nofollow small-nocollect"></b> </div> </div> </div> </li> <li> <a target="_blank" href="http://www.php.cn/course/2.html" title="PHP zero-based introductory tutorial" class="wzrthreelaimg"> <img src="https://img.php.cn/upload/course/000/000/068/6253de27bc161468.png" alt="PHP zero-based introductory tutorial"/> </a> <div class="wzrthree-right"> <a target="_blank" title="PHP zero-based introductory tutorial" href="http://www.php.cn/course/2.html">PHP zero-based introductory tutorial</a> <div class="wzrthreerb"> <div>859720 <b class="kclbcollectb"></b></div> <div class="courseICollection" data-id="2"> <b class="nofollow small-nocollect"></b> </div> </div> </div> </li> </ul> <ul class="two" style="display: none;"> <li> <a target="_blank" href="http://www.php.cn/course/812.html" title="The latest ThinkPHP 5.1 world premiere video tutorial (60 days to become a PHP expert online training course)" class="wzrthreelaimg"> <img src="https://img.php.cn/upload/course/000/000/041/620debc3eab3f377.jpg" alt="The latest ThinkPHP 5.1 world premiere video tutorial (60 days to become a PHP expert online training course)"/> </a> <div class="wzrthree-right"> <a target="_blank" title="The latest ThinkPHP 5.1 world premiere video tutorial (60 days to become a PHP expert online training course)" href="http://www.php.cn/course/812.html">The latest ThinkPHP 5.1 world premiere video tutorial (60 days to become a PHP expert online training course)</a> <div class="wzrthreerb"> <div >1418666 times of learning</div> <div class="courseICollection" data-id="812"> <b class="nofollow small-nocollect"></b> </div> </div> </div> </li> <li> <a target="_blank" href="http://www.php.cn/course/286.html" title="JAVA Beginner's Video Tutorial" class="wzrthreelaimg"> <img src="https://img.php.cn/upload/course/000/000/068/62590a2bacfd9379.png" alt="JAVA Beginner's Video Tutorial"/> </a> <div class="wzrthree-right"> <a target="_blank" title="JAVA Beginner's Video Tutorial" href="http://www.php.cn/course/286.html">JAVA Beginner's Video Tutorial</a> <div class="wzrthreerb"> <div >2495597 times of learning</div> <div class="courseICollection" data-id="286"> <b class="nofollow small-nocollect"></b> </div> </div> </div> </li> <li> <a target="_blank" href="http://www.php.cn/course/504.html" title="Little Turtle's zero-based introduction to learning Python video tutorial" class="wzrthreelaimg"> <img src="https://img.php.cn/upload/course/000/000/068/62590a67ce3a6655.png" alt="Little Turtle's zero-based introduction to learning Python video tutorial"/> </a> <div class="wzrthree-right"> <a target="_blank" title="Little Turtle's zero-based introduction to learning Python video tutorial" href="http://www.php.cn/course/504.html">Little Turtle's zero-based introduction to learning Python video tutorial</a> <div class="wzrthreerb"> <div >504733 times of learning</div> <div class="courseICollection" data-id="504"> <b class="nofollow small-nocollect"></b> </div> </div> </div> </li> <li> <a target="_blank" href="http://www.php.cn/course/901.html" title="Quick introduction to web front-end development" class="wzrthreelaimg"> <img src="https://img.php.cn/upload/course/000/000/067/64be28a53a4f6310.png" alt="Quick introduction to web front-end development"/> </a> <div class="wzrthree-right"> <a target="_blank" title="Quick introduction to web front-end development" href="http://www.php.cn/course/901.html">Quick introduction to web front-end development</a> <div class="wzrthreerb"> <div >215462 times of learning</div> <div class="courseICollection" data-id="901"> <b class="nofollow small-nocollect"></b> </div> </div> </div> </li> <li> <a target="_blank" href="http://www.php.cn/course/234.html" title="Master PS video tutorials from scratch" class="wzrthreelaimg"> <img src="https://img.php.cn/upload/course/000/000/068/62611f57ed0d4840.jpg" alt="Master PS video tutorials from scratch"/> </a> <div class="wzrthree-right"> <a target="_blank" title="Master PS video tutorials from scratch" href="http://www.php.cn/course/234.html">Master PS video tutorials from scratch</a> <div class="wzrthreerb"> <div >881892 times of learning</div> <div class="courseICollection" data-id="234"> <b class="nofollow small-nocollect"></b> </div> </div> </div> </li> </ul> <ul class="three" style="display: none;"> <li> <a target="_blank" href="http://www.php.cn/course/1648.html" title="[Web front-end] Node.js quick start" class="wzrthreelaimg"> <img src="https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png" alt="[Web front-end] Node.js quick start"/> </a> <div class="wzrthree-right"> <a target="_blank" title="[Web front-end] Node.js quick start" href="http://www.php.cn/course/1648.html">[Web front-end] Node.js quick start</a> <div class="wzrthreerb"> <div >6732 times of learning</div> <div class="courseICollection" data-id="1648"> <b class="nofollow small-nocollect"></b> </div> </div> </div> </li> <li> <a target="_blank" href="http://www.php.cn/course/1647.html" title="Complete collection of foreign web development full-stack courses" class="wzrthreelaimg"> <img src="https://img.php.cn/upload/course/000/000/067/6628cc96e310c937.png" alt="Complete collection of foreign web development full-stack courses"/> </a> <div class="wzrthree-right"> <a target="_blank" title="Complete collection of foreign web development full-stack courses" href="http://www.php.cn/course/1647.html">Complete collection of foreign web development full-stack courses</a> <div class="wzrthreerb"> <div >5246 times of learning</div> <div class="courseICollection" data-id="1647"> <b class="nofollow small-nocollect"></b> </div> </div> </div> </li> <li> <a target="_blank" href="http://www.php.cn/course/1646.html" title="Go language practical GraphQL" class="wzrthreelaimg"> <img src="https://img.php.cn/upload/course/000/000/067/662221173504a436.png" alt="Go language practical GraphQL"/> </a> <div class="wzrthree-right"> <a target="_blank" title="Go language practical GraphQL" href="http://www.php.cn/course/1646.html">Go language practical GraphQL</a> <div class="wzrthreerb"> <div >4387 times of learning</div> <div class="courseICollection" data-id="1646"> <b class="nofollow small-nocollect"></b> </div> </div> </div> </li> <li> <a target="_blank" href="http://www.php.cn/course/1645.html" title="550W fan master learns JavaScript from scratch step by step" class="wzrthreelaimg"> <img src="https://img.php.cn/upload/course/000/000/067/662077e163124646.png" alt="550W fan master learns JavaScript from scratch step by step"/> </a> <div class="wzrthree-right"> <a target="_blank" title="550W fan master learns JavaScript from scratch step by step" href="http://www.php.cn/course/1645.html">550W fan master learns JavaScript from scratch step by step</a> <div class="wzrthreerb"> <div >646 times of learning</div> <div class="courseICollection" data-id="1645"> <b class="nofollow small-nocollect"></b> </div> </div> </div> </li> <li> <a target="_blank" href="http://www.php.cn/course/1644.html" title="Python master Mosh, a beginner with zero basic knowledge can get started in 6 hours" class="wzrthreelaimg"> <img src="https://img.php.cn/upload/course/000/000/067/6616418ca80b8916.png" alt="Python master Mosh, a beginner with zero basic knowledge can get started in 6 hours"/> </a> <div class="wzrthree-right"> <a target="_blank" title="Python master Mosh, a beginner with zero basic knowledge can get started in 6 hours" href="http://www.php.cn/course/1644.html">Python master Mosh, a beginner with zero basic knowledge can get started in 6 hours</a> <div class="wzrthreerb"> <div >22346 times of learning</div> <div class="courseICollection" data-id="1644"> <b class="nofollow small-nocollect"></b> </div> </div> </div> </li> </ul> </div> <script> var mySwiper = new Swiper('.swiper2', { autoplay: false,//可选选项,自动滑动 slidesPerView : 'auto', }) $('.wzrthreeTab>div').click(function(e){ $('.wzrthreeTab>div').removeClass('check') $(this).addClass('check') $('.wzrthreelist>ul').css('display','none') $('.'+e.currentTarget.dataset.id).show() }) </script> </div> <div class="wzrFour"> <div class="wzrfour-title"> <div>Latest Downloads</div> <a href="http://www.php.cn/xiazai">More> </a> </div> <script> $(document).ready(function(){ var sjyx_banSwiper = new Swiper(".sjyx_banSwiperwz",{ speed:1000, autoplay:{ delay:3500, disableOnInteraction: false, }, pagination:{ el:'.sjyx_banSwiperwz .swiper-pagination', clickable :false, }, loop:true }) }) </script> <div class="wzrfourList swiper3"> <div class="wzrfourlTab swiper-wrapper"> <div class="check swiper-slide" data-id="onef">Web Effects <div></div></div> <div class="swiper-slide" data-id="twof">Website Source Code<div></div></div> <div class="swiper-slide" data-id="threef">Website Materials<div></div></div> <div class="swiper-slide" data-id="fourf">Front End Template<div></div></div> </div> <ul class="onef"> <li> <div class="wzrfourli"> <span class="layui-badge-dots wzrflr"></span> <a target="_blank" title="jQuery enterprise message form contact code" href="http://www.php.cn/toolset/js-special-effects/8071">[form button] jQuery enterprise message form contact code</a> </div> </li> <li> <div class="wzrfourli"> <span class="layui-badge-dots wzrflr"></span> <a target="_blank" title="HTML5 MP3 music box playback effects" href="http://www.php.cn/toolset/js-special-effects/8070">[Player special effects] HTML5 MP3 music box playback effects</a> </div> </li> <li> <div class="wzrfourli"> <span class="layui-badge-dots wzrflr"></span> <a target="_blank" title="HTML5 cool particle animation navigation menu special effects" href="http://www.php.cn/toolset/js-special-effects/8069">[Menu navigation] HTML5 cool particle animation navigation menu special effects</a> </div> </li> <li> <div class="wzrfourli"> <span class="layui-badge-dots wzrflr"></span> <a target="_blank" title="jQuery visual form drag and drop editing code" href="http://www.php.cn/toolset/js-special-effects/8068">[form button] jQuery visual form drag and drop editing code</a> </div> </li> <li> <div class="wzrfourli"> <span class="layui-badge-dots wzrflr"></span> <a target="_blank" title="VUE.JS imitation Kugou music player code" href="http://www.php.cn/toolset/js-special-effects/8067">[Player special effects] VUE.JS imitation Kugou music player code</a> </div> </li> <li> <div class="wzrfourli"> <span class="layui-badge-dots wzrflr"></span> <a target="_blank" title="Classic html5 pushing box game" href="http://www.php.cn/toolset/js-special-effects/8066">[html5 special effects] Classic html5 pushing box game</a> </div> </li> <li> <div class="wzrfourli"> <span class="layui-badge-dots wzrflr"></span> <a target="_blank" title="jQuery scrolling to add or reduce image effects" href="http://www.php.cn/toolset/js-special-effects/8065">[Picture special effects] jQuery scrolling to add or reduce image effects</a> </div> </li> <li> <div class="wzrfourli"> <span class="layui-badge-dots wzrflr"></span> <a target="_blank" title="CSS3 personal album cover hover zoom effect" href="http://www.php.cn/toolset/js-special-effects/8064">[Photo album effects] CSS3 personal album cover hover zoom effect</a> </div> </li> </ul> <ul class="twof" style="display:none"> <li> <div class="wzrfourli"> <span class="layui-badge-dots wzrflr"></span> <a href="http://www.php.cn/toolset/website-source-code/8328" title="Home Decor Cleaning and Repair Service Company Website Template" target="_blank">[Front-end template] Home Decor Cleaning and Repair Service Company Website Template</a> </div> </li> <li> <div class="wzrfourli"> <span class="layui-badge-dots wzrflr"></span> <a href="http://www.php.cn/toolset/website-source-code/8327" title="Fresh color personal resume guide page template" target="_blank">[Front-end template] Fresh color personal resume guide page template</a> </div> </li> <li> <div class="wzrfourli"> <span class="layui-badge-dots wzrflr"></span> <a href="http://www.php.cn/toolset/website-source-code/8326" title="Designer Creative Job Resume Web Template" target="_blank">[Front-end template] Designer Creative Job Resume Web Template</a> </div> </li> <li> <div class="wzrfourli"> <span class="layui-badge-dots wzrflr"></span> <a href="http://www.php.cn/toolset/website-source-code/8325" title="Modern engineering construction company website template" target="_blank">[Front-end template] Modern engineering construction company website template</a> </div> </li> <li> <div class="wzrfourli"> <span class="layui-badge-dots wzrflr"></span> <a href="http://www.php.cn/toolset/website-source-code/8324" title="Responsive HTML5 template for educational service institutions" target="_blank">[Front-end template] Responsive HTML5 template for educational service institutions</a> </div> </li> <li> <div class="wzrfourli"> <span class="layui-badge-dots wzrflr"></span> <a href="http://www.php.cn/toolset/website-source-code/8323" title="Online e-book store mall website template" target="_blank">[Front-end template] Online e-book store mall website template</a> </div> </li> <li> <div class="wzrfourli"> <span class="layui-badge-dots wzrflr"></span> <a href="http://www.php.cn/toolset/website-source-code/8322" title="IT technology solves Internet company website template" target="_blank">[Front-end template] IT technology solves Internet company website template</a> </div> </li> <li> <div class="wzrfourli"> <span class="layui-badge-dots wzrflr"></span> <a href="http://www.php.cn/toolset/website-source-code/8321" title="Purple style foreign exchange trading service website template" target="_blank">[Front-end template] Purple style foreign exchange trading service website template</a> </div> </li> </ul> <ul class="threef" style="display:none"> <li> <div class="wzrfourli"> <span class="layui-badge-dots wzrflr"></span> <a href="http://www.php.cn/toolset/website-materials/3078" target="_blank" title="Cute summer elements vector material (EPS PNG)">[PNG material] Cute summer elements vector material (EPS PNG)</a> </div> </li> <li> <div class="wzrfourli"> <span class="layui-badge-dots wzrflr"></span> <a href="http://www.php.cn/toolset/website-materials/3077" target="_blank" title="Four red 2023 graduation badges vector material (AI EPS PNG)">[PNG material] Four red 2023 graduation badges vector material (AI EPS PNG)</a> </div> </li> <li> <div class="wzrfourli"> <span class="layui-badge-dots wzrflr"></span> <a href="http://www.php.cn/toolset/website-materials/3076" target="_blank" title="Singing bird and cart filled with flowers design spring banner vector material (AI EPS)">[banner picture] Singing bird and cart filled with flowers design spring banner vector material (AI EPS)</a> </div> </li> <li> <div class="wzrfourli"> <span class="layui-badge-dots wzrflr"></span> <a href="http://www.php.cn/toolset/website-materials/3075" target="_blank" title="Golden graduation cap vector material (EPS PNG)">[PNG material] Golden graduation cap vector material (EPS PNG)</a> </div> </li> <li> <div class="wzrfourli"> <span class="layui-badge-dots wzrflr"></span> <a href="http://www.php.cn/toolset/website-materials/3074" target="_blank" title="Black and white style mountain icon vector material (EPS PNG)">[PNG material] Black and white style mountain icon vector material (EPS PNG)</a> </div> </li> <li> <div class="wzrfourli"> <span class="layui-badge-dots wzrflr"></span> <a href="http://www.php.cn/toolset/website-materials/3073" target="_blank" title="Superhero silhouette vector material (EPS PNG) with different color cloaks and different poses">[PNG material] Superhero silhouette vector material (EPS PNG) with different color cloaks and different poses</a> </div> </li> <li> <div class="wzrfourli"> <span class="layui-badge-dots wzrflr"></span> <a href="http://www.php.cn/toolset/website-materials/3072" target="_blank" title="Flat style Arbor Day banner vector material (AI+EPS)">[banner picture] Flat style Arbor Day banner vector material (AI+EPS)</a> </div> </li> <li> <div class="wzrfourli"> <span class="layui-badge-dots wzrflr"></span> <a href="http://www.php.cn/toolset/website-materials/3071" target="_blank" title="Nine comic-style exploding chat bubbles vector material (EPS+PNG)">[PNG material] Nine comic-style exploding chat bubbles vector material (EPS+PNG)</a> </div> </li> </ul> <ul class="fourf" style="display:none"> <li> <div class="wzrfourli"> <span class="layui-badge-dots wzrflr"></span> <a href="http://www.php.cn/toolset/website-source-code/8328" target="_blank" title="Home Decor Cleaning and Repair Service Company Website Template">[Front-end template] Home Decor Cleaning and Repair Service Company Website Template</a> </div> </li> <li> <div class="wzrfourli"> <span class="layui-badge-dots wzrflr"></span> <a href="http://www.php.cn/toolset/website-source-code/8327" target="_blank" title="Fresh color personal resume guide page template">[Front-end template] Fresh color personal resume guide page template</a> </div> </li> <li> <div class="wzrfourli"> <span class="layui-badge-dots wzrflr"></span> <a href="http://www.php.cn/toolset/website-source-code/8326" target="_blank" title="Designer Creative Job Resume Web Template">[Front-end template] Designer Creative Job Resume Web Template</a> </div> </li> <li> <div class="wzrfourli"> <span class="layui-badge-dots wzrflr"></span> <a href="http://www.php.cn/toolset/website-source-code/8325" target="_blank" title="Modern engineering construction company website template">[Front-end template] Modern engineering construction company website template</a> </div> </li> <li> <div class="wzrfourli"> <span class="layui-badge-dots wzrflr"></span> <a href="http://www.php.cn/toolset/website-source-code/8324" target="_blank" title="Responsive HTML5 template for educational service institutions">[Front-end template] Responsive HTML5 template for educational service institutions</a> </div> </li> <li> <div class="wzrfourli"> <span class="layui-badge-dots wzrflr"></span> <a href="http://www.php.cn/toolset/website-source-code/8323" target="_blank" title="Online e-book store mall website template">[Front-end template] Online e-book store mall website template</a> </div> </li> <li> <div class="wzrfourli"> <span class="layui-badge-dots wzrflr"></span> <a href="http://www.php.cn/toolset/website-source-code/8322" target="_blank" title="IT technology solves Internet company website template">[Front-end template] IT technology solves Internet company website template</a> </div> </li> <li> <div class="wzrfourli"> <span class="layui-badge-dots wzrflr"></span> <a href="http://www.php.cn/toolset/website-source-code/8321" target="_blank" title="Purple style foreign exchange trading service website template">[Front-end template] Purple style foreign exchange trading service website template</a> </div> </li> </ul> </div> <script> var mySwiper = new Swiper('.swiper3', { autoplay: false,//可选选项,自动滑动 slidesPerView : 'auto', }) $('.wzrfourlTab>div').click(function(e){ $('.wzrfourlTab>div').removeClass('check') $(this).addClass('check') $('.wzrfourList>ul').css('display','none') $('.'+e.currentTarget.dataset.id).show() }) </script> </div> </div> </div> <footer> <div class="footer"> <div class="footertop"> <img src="/static/imghw/logo.png" alt=""> <p>Public welfare online PHP training,Help PHP learners grow quickly!</p> </div> <div class="footermid"> <a href="http://www.php.cn/about/us.html">About us</a> <a href="http://www.php.cn/about/disclaimer.html">Disclaimer</a> <a href="http://www.php.cn/update/article_0_1.html">Sitemap</a> </div> <div class="footerbottom"> <p> © php.cn All rights reserved </p> </div> </div> </footer> <input type="hidden" id="verifycode" value="/captcha.html"> <script>layui.use(['element', 'carousel'], function () {var element = layui.element;$ = layui.jquery;var carousel = layui.carousel;carousel.render({elem: '#test1', width: '100%', height: '330px', arrow: 'always'});$.getScript('/static/js/jquery.lazyload.min.js', function () {$("img").lazyload({placeholder: "/static/images/load.jpg", effect: "fadeIn", threshold: 200, skip_invisible: false});});});</script> <script src="/static/js/common_new.js"></script> <script type="text/javascript" src="/static/js/jquery.cookie.js?1732051828"></script> <script src="https://vdse.bdstatic.com//search-video.v1.min.js"></script> <link rel='stylesheet' id='_main-css' href='/static/css/viewer.min.css?2' type='text/css' media='all'/> <script type='text/javascript' src='/static/js/viewer.min.js?1'></script> <script type='text/javascript' src='/static/js/jquery-viewer.min.js'></script> <script type="text/javascript" src="/static/js/global.min.js?5.5.53"></script> </body> </html>