代码语言
.
CSharp
.
JS
Java
Asp.Net
C
MSSQL
PHP
Css
PLSQL
Python
Shell
EBS
ASP
Perl
ObjC
VB.Net
VBS
MYSQL
GO
Delphi
AS
DB2
Domino
Rails
ActionScript
Scala
代码分类
文件
系统
字符串
数据库
网络相关
图形/GUI
多媒体
算法
游戏
Jquery
Extjs
Android
HTML5
菜单
网页交互
WinForm
控件
企业应用
安全与加密
脚本/批处理
开放平台
其它
【
PHP
】
php还原mysql数据库
作者:
/ 发布于
2011/1/4
/
593
<div> <table style="font-family: monospace" class="php codes"> <tbody> <tr class="li1"> <td style="line-height: 150%; font-family: Verdana, Monospace; font-size: 12px; font-weight: bold; margin-right: 10px"> <pre style="line-height: 150%; font-family: Verdana, Monospace; font-size: 12px; font-weight: bold; margin-right: 10px"><span style="color: #0000ff"><?php</span> <span style="color: blue">define</span><span style="color: #009900">(</span><span style="color: #0000ff">'MSR_VERSION'</span><span style="color: #339933">,</span> <span style="color: #0000ff">'1.0.0'</span><span style="color: #009900">)</span><span style="color: #339933">;</span> <span style="color: blue">define</span><span style="color: #009900">(</span><span style="color: #0000ff">'__SEP__'</span><span style="color: #339933">,</span> <span style="color: #0000ff">"/*sep*/"</span> <span style="color: #009900">)</span><span style="color: #339933">;</span> <span style="color: blue">define</span><span style="color: #009900">(</span><span style="color: #0000ff">'MSR_STRING'</span><span style="color: #339933">,</span> <span style="color: #cc66cc">0</span><span style="color: #009900">)</span><span style="color: #339933">;</span> <span style="color: blue">define</span><span style="color: #009900">(</span><span style="color: #0000ff">'MSR_FILE'</span><span style="color: #339933">,</span> <span style="color: #cc66cc">1</span><span style="color: #009900">)</span><span style="color: #339933">;</span> <span style="color: blue">set_time_limit</span><span style="color: #009900">(</span> <span style="color: #cc66cc">600</span> <span style="color: #009900">)</span><span style="color: #339933">;</span> <span style="color: #0000ff">class</span> MySQL_Restore <span style="color: #009900">{</span> <span style="color: #0000ff">var</span> <span style="color: #000088">$server</span> <span style="color: #339933">=</span> <span style="color: #0000ff">'localhost'</span><span style="color: #339933">;</span> <span style="color: #0000ff">var</span> <span style="color: #000088">$port</span> <span style="color: #339933">=</span> <span style="color: #cc66cc">3306</span><span style="color: #339933">;</span> <span style="color: #0000ff">var</span> <span style="color: #000088">$username</span> <span style="color: #339933">=</span> <span style="color: #0000ff">'root'</span><span style="color: #339933">;</span> <span style="color: #0000ff">var</span> <span style="color: #000088">$password</span> <span style="color: #339933">=</span> <span style="color: #0000ff">''</span><span style="color: #339933">;</span> <span style="color: #0000ff">var</span> <span style="color: #000088">$database</span> <span style="color: #339933">=</span> <span style="color: #0000ff">''</span><span style="color: #339933">;</span> <span style="color: #0000ff">var</span> <span style="color: #000088">$link_id</span> <span style="color: #339933">=</span> <span style="color: #339933">-</span><span style="color: #cc66cc">1</span><span style="color: #339933">;</span> <span style="color: #0000ff">var</span> <span style="color: #000088">$connected</span> <span style="color: #339933">=</span> <span style="color: #009900; font-weight: bold">false</span><span style="color: #339933">;</span> <span style="color: #0000ff">var</span> <span style="color: #000088">$queries</span> <span style="color: #339933">=</span> <span style="color: blue">array</span><span style="color: #009900">(</span><span style="color: #009900">)</span><span style="color: #339933">;</span> <span style="color: #0000ff">var</span> <span style="color: #000088">$error</span> <span style="color: #339933">=</span> <span style="color: #0000ff">''</span><span style="color: #339933">;</span> <span style="color: #0000ff">var</span> <span style="color: #000088">$debug</span> <span style="color: #339933">=</span> <span style="color: #009900; font-weight: bold">false</span><span style="color: #339933">;</span> <span style="color: #0000ff">var</span> <span style="color: #000088">$log_folder</span> <span style="color: #339933">=</span> <span style="color: #0000ff">""</span><span style="color: #339933">;</span> <span style="color: #0000ff">var</span> <span style="color: #000088">$log_file_name</span> <span style="color: #339933">=</span> <span style="color: #0000ff">""</span><span style="color: #339933">;</span> <span style="color: #0000ff">function</span> MySQL_Restore<span style="color: #009900">(</span><span style="color: #009900">)</span> <span style="color: #009900">{</span> <span style="color: #000088">$this</span><span style="color: #339933">-></span><span style="color: #004000">log_file_name</span> <span style="color: #339933">=</span> <span style="color: #0000ff">"restore_"</span> <span style="color: #339933">.</span> <span style="color: blue">date</span><span style="color: #009900">(</span> <span style="color: #0000ff">"Ymd_his"</span> <span style="color: #009900">)</span> <span style="color: #339933">.</span> <span style="color: #0000ff">".log"</span><span style="color: #339933">;</span> <span style="color: #009900">}</span> <span style="color: #0000ff">function</span> Execute<span style="color: #009900">(</span> <span style="color: #000088">$param</span><span style="color: #339933">,</span> <span style="color: #000088">$mode</span> <span style="color: #339933">=</span> MSR_STRING<span style="color: #339933">,</span> <span style="color: #000088">$is_compressed</span> <span style="color: #339933">=</span> <span style="color: #009900; font-weight: bold">false</span><span style="color: #339933">,</span> <span style="color: #000088">$split_only</span> <span style="color: #339933">=</span> <span style="color: #009900; font-weight: bold">false</span> <span style="color: #009900">)</span> <span style="color: #009900">{</span> <span style="color: #0099cc">if</span> <span style="color: #009900">(</span> <span style="color: #000088">$this</span><span style="color: #339933">-></span><span style="color: #004000">debug</span> <span style="color: #009900">)</span> <span style="color: #009900">{</span> <span style="color: #000088">$this</span><span style="color: #339933">-></span><span style="color: #004000">saveLog</span><span style="color: #009900">(</span> <span style="color: #0000ff">"[start reading file]"</span> <span style="color: #009900">)</span><span style="color: #339933">;</span> <span style="color: #009900">}</span> <span style="color: #0099cc">if</span> <span style="color: #009900">(</span> <span style="color: #000088">$mode</span> <span style="color: #339933">==</span> MSR_FILE <span style="color: #009900">)</span> <span style="color: #009900">{</span> <span style="color: #0099cc">if</span> <span style="color: #009900">(</span><span style="color: #339933">!</span><span style="color: #009900">(</span><span style="color: #000088">$sql</span> <span style="color: #339933">=</span> <span style="color: #000088">$this</span><span style="color: #339933">-></span>_ReadFromFile<span style="color: #009900">(</span><span style="color: #000088">$param</span><span style="color: #339933">,</span> <span style="color: #000088">$is_compressed</span><span style="color: #009900">)</span><span style="color: #009900">)</span><span style="color: #009900">)</span> <span style="color: #009900">{</span> <span style="color: #000088">$this</span><span style="color: #339933">-></span><span style="color: #004000">error</span> <span style="color: #339933">=</span> <span style="color: #0000ff">'Can\'t read backup file.'</span><span style="color: #339933">;</span> <span style="color: #0099cc">return</span> <span style="color: #009900; font-weight: bold">false</span><span style="color: #339933">;</span> <span style="color: #009900">}</span> <span style="color: #009900">}</span> <span style="color: #0099cc">else</span> <span style="color: #009900">{</span> <span style="color: #000088">$sql</span> <span style="color: #339933">=</span> <span style="color: #009900">(</span><span style="color: #000088">$is_compressed</span> ? <span style="color: blue">gzuncompress</span><span style="color: #009900">(</span><span style="color: #000088">$param</span><span style="color: #009900">)</span> <span style="color: #339933">:</span> <span style="color: #000088">$param</span><span style="color: #009900">)</span><span style="color: #339933">;</span> <span style="color: #009900">}</span> <span style="color: #0099cc">if</span> <span style="color: #009900">(</span> <span style="color: #000088">$this</span><span style="color: #339933">-></span><span style="color: #004000">debug</span> <span style="color: #009900">)</span> <span style="color: #009900">{</span> <span style="color: #000088">$this</span><span style="color: #339933">-></span><span style="color: #004000">saveLog</span><span style="color: #009900">(</span> <span style="color: #0000ff">"[file readed]"</span> <span style="color: #009900">)</span><span style="color: #339933">;</span> <span style="color: #009900">}</span> <span style="color: #0099cc">return</span> <span style="color: #000088">$this</span><span style="color: #339933">-></span>_Restore<span style="color: #009900">(</span> <span style="color: #000088">$sql</span><span style="color: #339933">,</span> <span style="color: #000088">$split_only</span> <span style="color: #009900">)</span><span style="color: #339933">;</span> <span style="color: #009900">}</span> <span style="color: #0000ff">function</span> _Connect<span style="color: #009900">(</span><span style="color: #009900">)</span> <span style="color: #009900">{</span> <span style="color: #000088">$value</span> <span style="color: #339933">=</span> <span style="color: #009900; font-weight: bold">false</span><span style="color: #339933">;</span> <span style="color: #0099cc">if</span> <span style="color: #009900">(</span> <span style="color: #339933">!</span><span style="color: #000088">$this</span><span style="color: #339933">-></span><span style="color: #004000">connected</span> <span style="color: #009900">)</span> <span style="color: #009900">{</span> <span style="color: #000088">$host</span> <span style="color: #339933">=</span> <span style="color: #000088">$this</span><span style="color: #339933">-></span><span style="color: #004000">server</span> <span style="color: #339933">.</span> <span style="color: #0000ff">':'</span> <span style="color: #339933">.</span> <span style="color: #000088">$this</span><span style="color: #339933">-></span><span style="color: #004000">port</span><span style="color: #339933">;</span> <span style="color: #000088">$this</span><span style="color: #339933">-></span><span style="color: #004000">link_id</span> <span style="color: #339933">=</span> <span style="color: blue">mysql_pconnect</span><span style="color: #009900">(</span> <span style="color: #000088">$host</span><span style="color: #339933">,</span> <span style="color: #000088">$this</span><span style="color: #339933">-></span><span style="color: #004000">username</span><span style="color: #339933">,</span> <span style="color: #000088">$this</span><span style="color: #339933">-></span><span style="color: #004000">password</span> <span style="color: #009900">)</span><span style="color: #339933">;</span> <span style="color: #009900">}</span> <span style="color: #0099cc">if</span> <span style="color: #009900">(</span> <span style="color: #000088">$this</span><span style="color: #339933">-></span><span style="color: #004000">link_id</span> <span style="color: #009900">)</span> <span style="color: #009900">{</span> <span style="color: #0099cc">if</span> <span style="color: #009900">(</span> <span style="color: blue">empty</span><span style="color: #009900">(</span> <span style="color: #000088">$this</span><span style="color: #339933">-></span><span style="color: #004000">database</span> <span style="color: #009900">)</span> <span style="color: #009900">)</span> <span style="color: #009900">{</span> <span style="color: #000088">$value</span> <span style="color: #339933">=</span> <span style="color: #009900; font-weight: bold">true</span><span style="color: #339933">;</span> <span style="color: #009900">}</span> <span style="color: #0099cc">elseif</span> <span style="color: #009900">(</span> <span style="color: #000088">$this</span><span style="color: #339933">-></span><span style="color: #004000">link_id</span> <span style="color: #339933">!==</span> <span style="color: #339933">-</span><span style="color: #cc66cc">1</span> <span style="color: #009900">)</span> <span style="color: #009900">{</span> <span style="color: #000088">$value</span> <span style="color: #339933">=</span> <span style="color: blue">mysql_select_db</span><span style="color: #009900">(</span><span style="color: #000088">$this</span><span style="color: #339933">-></span><span style="color: #004000">database</span><span style="color: #339933">,</span> <span style="color: #000088">$this</span><span style="color: #339933">-></span><span style="color: #004000">link_id</span><span style="color: #009900">)</span><span style="color: #339933">;</span> <span style="color: #009900">}</span> <span style="color: #0099cc">else</span> <span style="color: #009900">{</span> <span style="color: #000088">$value</span> <span style="color: #339933">=</span> <span style="color: blue">mysql_select_db</span><span style="color: #009900">(</span><span style="color: #000088">$this</span><span style="color: #339933">-></span><span style="color: #004000">database</span><span style="color: #009900">)</span><span style="color: #339933">;</span> <span style="color: #009900">}</span> <span style="color: #009900">}</span> <span style="color: #0099cc">if</span> <span style="color: #009900">(</span><span style="color: #339933">!</span><span style="color: #000088">$value</span><span style="color: #009900">)</span> <span style="color: #009900">{</span> <span style="color: #000088">$this</span><span style="color: #339933">-></span><span style="color: #004000">error</span> <span style="color: #339933">=</span> <span style="color: blue">mysql_error</span><span style="color: #009900">(</span><span style="color: #009900">)</span><span style="color: #339933">;</span> <span style="color: #009900">}</span> <span style="color: #0099cc">return</span> <span style="color: #000088">$value</span><span style="color: #339933">;</span> <span style="color: #009900">}</span> <span style="color: #0000ff">function</span> _Disconnect<span style="color: #009900">(</span><span style="color: #009900">)</span> <span style="color: #009900">{</span> <span style="color: #0099cc">if</span> <span style="color: #009900">(</span> <span style="color: #000088">$this</span><span style="color: #339933">-></span><span style="color: #004000">link_id</span> <span style="color: #009900">)</span> <span style="color: #009900">{</span> <span style="color: blue">mysql_close</span><span style="color: #009900">(</span> <span style="color: #000088">$this</span><span style="color: #339933">-></span><span style="color: #004000">link_id</span> <span style="color: #009900">)</span><span style="color: #339933">;</span> <span style="color: #009900">}</span> <span style="color: #009900">}</span> <span style="color: #0000ff">function</span> _Query<span style="color: #009900">(</span> <span style="color: #000088">$sql</span> <span style="color: #009900">)</span> <span style="color: #009900">{</span> <span style="color: #0099cc">if</span> <span style="color: #009900">(</span> <span style="color: #000088">$this</span><span style="color: #339933">-></span><span style="color: #004000">link_id</span> <span style="color: #339933">!==</span> <span style="color: #339933">-</span><span style="color: #cc66cc">1</span> <span style="color: #009900">)</span> <span style="color: #009900">{</span> <span style="color: #000088">$result</span> <span style="color: #339933">=</span> <span style="color: blue">mysql_query</span><span style="color: #009900">(</span> <span style="color: #000088">$sql</span><span style="color: #339933">,</span> <span style="color: #000088">$this</span><span style="color: #339933">-></span><span style="color: #004000">link_id</span> <span style="color: #009900">)</span><span style="color: #339933">;</span> <span style="color: #009900">}</span> <span style="color: #0099cc">else</span> <span style="color: #009900">{</span> <span style="color: #000088">$result</span> <span style="color: #339933">=</span> <span style="color: blue">mysql_query</span><span style="color: #009900">(</span> <span style="color: #000088">$sql</span> <span style="color: #009900">)</span><span style="color: #339933">;</span> <span style="color: #009900">}</span> <span style="color: #0099cc">if</span> <span style="color: #009900">(</span> <span style="color: #339933">!</span><span style="color: #000088">$result</span> <span style="color: #009900">)</span> <span style="color: #009900">{</span> <span style="color: #000088">$this</span><span style="color: #339933">-></span><span style="color: #004000">error</span> <span style="color: #339933">=</span> <span style="color: blue">mysql_error</span><span style="color: #009900">(</span><span style="color: #009900">)</span><span style="color: #339933">;</span> <span style="color: #009900">}</span> <span style="color: #0099cc">return</span> <span style="color: #000088">$result</span><span style="color: #339933">;</span> <span style="color: #009900">}</span> <span style="font-style: italic; color: #666666">// The logic from phpMyAdmin source</span> <span style="color: #0000ff">function</span> _Decompose<span style="color: #009900">(</span> <span style="color: #339933">&</span><span style="color: #000088">$ret</span><span style="color: #339933">,</span> <span style="color: #000088">$sql</span> <span style="color: #009900">)</span> <span style="color: #009900">{</span> <span style="color: #000088">$sql</span> <span style="color: #339933">=</span> <span style="color: blue">rtrim</span><span style="color: #009900">(</span> <span style="color: #000088">$sql</span><span style="color: #339933">,</span> <span style="color: #0000ff">"<span style="color: #000099; font-weight: bold">\n</span><span style="color: #000099; font-weight: bold">\r</span>"</span> <span style="color: #009900">)</span><span style="color: #339933">;</span> <span style="color: #000088">$sql_len</span> <span style="color: #339933">=</span> <span style="color: blue">strlen</span><span style="color: #009900">(</span> <span style="color: #000088">$sql</span> <span style="color: #009900">)</span><span style="color: #339933">;</span> <span style="color: #000088">$char</span> <span style="color: #339933">=</span> <span style="color: #0000ff">''</span><span style="color: #339933">;</span> <span style="color: #000088">$string_start</span> <span style="color: #339933">=</span> <span style="color: #0000ff">''</span><span style="color: #339933">;</span> <span style="color: #000088">$in_string</span> <span style="color: #339933">=</span> <span style="color: #009900; font-weight: bold">false</span><span style="color: #339933">;</span> <span style="color: #000088">$nothing</span> <span style="color: #339933">=</span> <span style="color: #009900; font-weight: bold">true</span><span style="color: #339933">;</span> <span style="color: #000088">$time0</span> <span style="color: #339933">=</span> <span style="color: blue">time</span><span style="color: #009900">(</span><span style="color: #009900">)</span><span style="color: #339933">;</span> <span style="color: #0099cc">for</span> <span style="color: #009900">(</span> <span style="color: #000088">$i</span> <span style="color: #339933">=</span> <span style="color: #cc66cc">0</span><span style="color: #339933">;</span> <span style="color: #000088">$i</span> <span style="color: #339933"><</span> <span style="color: #000088">$sql_len</span><span style="color: #339933">;</span> <span style="color: #339933">++</span><span style="color: #000088">$i</span> <span style="color: #009900">)</span> <span style="color: #009900">{</span> <span style="color: #000088">$char</span> <span style="color: #339933">=</span> <span style="color: #000088">$sql</span><span style="color: #009900">[</span><span style="color: #000088">$i</span><span style="color: #009900">]</span><span style="color: #339933">;</span> <span style="color: #0099cc">if</span> <span style="color: #009900">(</span> <span style="color: #000088">$in_string</span> <span style="color: #009900">)</span> <span style="color: #009900">{</span> <span style="color: #0099cc">for</span> <span style="color: #009900">(</span><span style="color: #339933">;;</span><span style="color: #009900">)</span> <span style="color: #009900">{</span> <span style="color: #000088">$i</span> <span style="color: #339933">=</span> <span style="color: blue">strpos</span><span style="color: #009900">(</span> <span style="color: #000088">$sql</span><span style="color: #339933">,</span> <span style="color: #000088">$string_start</span><span style="color: #339933">,</span> <span style="color: #000088">$i</span> <span style="color: #009900">)</span><span style="color: #339933">;</span> <span style="color: #0099cc">if</span> <span style="color: #009900">(</span> <span style="color: #339933">!</span><span style="color: #000088">$i</span> <span style="color: #009900">)</span> <span style="color: #009900">{</span> <span style="color: #000088">$ret</span><span style="color: #009900">[</span><span style="color: #009900">]</span> <span style="color: #339933">=</span> <span style="color: #000088">$sql</span><span style="color: #339933">;</span> <span style="color: #0099cc">return</span> <span style="color: #009900; font-weight: bold">true</span><span style="color: #339933">;</span> <span style="color: #009900">}</span> <span style="color: #0099cc">elseif</span> <span style="color: #009900">(</span> <span style="color: #000088">$string_start</span> <span style="color: #339933">==</span> <span style="color: #0000ff">'`'</span> <span style="color: #339933">||</span> <span style="color: #000088">$sql</span><span style="color: #009900">[</span><span style="color: #000088">$i</span> <span style="color: #339933">-</span> <span style="color: #cc66cc">1</span><span style="color: #009900">]</span> <span style="color: #339933">!=</span> <span style="color: #0000ff">'\\'</span> <span style="color: #009900">)</span> <span style="color: #009900">{</span> <span style="color: #000088">$string_start</span> <span style="color: #339933">=</span> <span style="color: #0000ff">''</span><span style="color: #339933">;</span> <span style="color: #000088">$in_string</span> <span style="color: #339933">=</span> <span style="color: #009900; font-weight: bold">false</span><span style="color: #339933">;</span> <span style="color: #0099cc">break</span><span style="color: #339933">;</span> <span style="color: #009900">}</span> <span style="color: #0099cc">else</span> <span style="color: #009900">{</span> <span style="color: #000088">$j</span> <span style="color: #339933">=</span> <span style="color: #cc66cc">2</span><span style="color: #339933">;</span> <span style="color: #000088">$escaped_backslash</span> <span style="color: #339933">=</span> <span style="color: #009900; font-weight: bold">false</span><span style="color: #339933">;</span> <span style="color: #0099cc">while</span> <span style="color: #009900">(</span> <span style="color: #000088">$i</span> <span style="color: #339933">-</span> <span style="color: #000088">$j</span> <span style="color: #339933">></span> <span style="color: #cc66cc">0</span> <span style="color: #339933">&&</span> <span style="color: #000088">$sql</span><span style="color: #009900">[</span><span style="color: #000088">$i</span> <span style="color: #339933">-</span> <span style="color: #000088">$j</span><span style="color: #009900">]</span> <span style="color: #339933">==</span> <span style="color: #0000ff">'\\'</span> <span style="color: #009900">)</span> <span style="color: #009900">{</span> <span style="color: #000088">$escaped_backslash</span> <span style="color: #339933">=</span> <span style="color: #339933">!</span><span style="color: #000088">$escaped_backslash</span><span style="color: #339933">;</span> <span style="color: #000088">$j</span><span style="color: #339933">++;</span> <span style="color: #009900">}</span> <span style="color: #0099cc">if</span> <span style="color: #009900">(</span> <span style="color: #000088">$escaped_backslash</span> <span style="color: #009900">)</span> <span style="color: #009900">{</span> <span style="color: #000088">$string_start</span> <span style="color: #339933">=</span> <span style="color: #0000ff">''</span><span style="color: #339933">;</span> <span style="color: #000088">$in_string</span> <span style="color: #339933">=</span> <span style="color: #009900; font-weight: bold">false</span><span style="color: #339933">;</span> <span style="color: #0099cc">break</span><span style="color: #339933">;</span> <span style="color: #009900">}</span> <span style="color: #0099cc">else</span> <span style="color: #009900">{</span> <span style="color: #000088">$i</span><span style="color: #339933">++;</span> <span style="color: #009900">}</span> <span style="color: #009900">}</span> <span style="color: #009900">}</span> <span style="color: #009900">}</span> <span style="color: #0099cc">else</span> <span style="color: #0099cc">if</span> <span style="color: #009900">(</span> <span style="color: #009900">(</span><span style="color: #000088">$char</span> <span style="color: #339933">==</span> <span style="color: #0000ff">'-'</span> <span style="color: #339933">&&</span> <span style="color: #000088">$sql_len</span> <span style="color: #339933">></span> <span style="color: #000088">$i</span> <span style="color: #339933">+</span> <span style="color: #cc66cc">2</span> <span style="color: #339933">&&</span> <span style="color: #000088">$sql</span><span style="color: #009900">[</span><span style="color: #000088">$i</span> <span style="color: #339933">+</span> <span style="color: #cc66cc">1</span><span style="color: #009900">]</span> <span style="color: #339933">==</span> <span style="color: #0000ff">'-'</span> <span style="color: #339933">&&</span> <span style="color: #000088">$sql</span><span style="color: #009900">[</span><span style="color: #000088">$i</span> <span style="color: #339933">+</span> <span style="color: #cc66cc">2</span><span style="color: #009900">]</span> <span style="color: #339933"><=</span> <span style="color: #0000ff">' '</span><span style="color: #009900">)</span> <span style="color: #339933">||</span> <span style="color: #000088">$char</span> <span style="color: #339933">==</span> <span style="color: #0000ff">'#'</span> <span style="color: #339933">||</span> <span style="color: #009900">(</span><span style="color: #000088">$char</span> <span style="color: #339933">==</span> <span style="color: #0000ff">'/'</span> <span style="color: #339933">&&</span> <span style="color: #000088">$sql_len</span> <span style="color: #339933">></span> <span style="color: #000088">$i</span> <span style="color: #339933">+</span> <span style="color: #cc66cc">1</span> <span style="color: #339933">&&</span> <span style="color: #000088">$sql</span><span style="color: #009900">[</span><span style="color: #000088">$i</span> <span style="color: #339933">+</span> <span style="color: #cc66cc">1</span><span style="color: #009900">]</span> <span style="color: #339933">==</span> <span style="color: #0000ff">'*'</span><span style="color: #009900">)</span> <span style="color: #009900">)</span> <span style="color: #009900">{</span> <span style="color: #000088">$comm_end</span> <span style="color: #339933">=</span> <span style="color: #009900">(</span><span style="color: #000088">$char</span> <span style="color: #339933">==</span> <span style="color: #0000ff">'/'</span> ? <span style="color: #0000ff">'*/'</span> <span style="color: #339933">:</span> <span style="color: #0000ff">"<span style="color: #000099; font-weight: bold">\n</span>"</span><span style="color: #009900">)</span><span style="color: #339933">;</span> <span style="color: #000088">$i</span> <span style="color: #339933">=</span> <span style="color: blue">strpos</span><span style="color: #009900">(</span><span style="color: #000088">$sql</span><span style="color: #339933">,</span> <span style="color: #000088">$comm_end</span><span style="color: #339933">,</span> <span style="color: #000088">$i</span><span style="color: #009900">)</span><span style="color: #339933">;</span> <span style="color: #0099cc">if</span> <span style="color: #009900">(</span> <span style="color: #000088">$i</span> <span style="color: #339933">===</span> <span style="color: #009900; font-weight: bold">false</span> <span style="color: #009900">)</span> <span style="color: #009900">{</span> <span style="color: #0099cc">break</span><span style="color: #339933">;</span> <span style="color: #009900">}</span> <span style="color: #0099cc">if</span> <span style="color: #009900">(</span><span style="color: #000088">$char</span> <span style="color: #339933">==</span> <span style="color: #0000ff">'/'</span><span style="color: #009900">)</span> <span style="color: #009900">{</span> <span style="color: #000088">$i</span><span style="color: #339933">++;</span> <span style="color: #009900">}</span> <span style="color: #009900">}</span> <span style="color: #0099cc">else</span> <span style="color: #0099cc">if</span> <span style="color: #009900">(</span><span style="color: #000088">$char</span> <span style="color: #339933">==</span> <span style="color: #0000ff">';'</span><span style="color: #009900">)</span> <span style="color: #009900">{</span> <span style="color: #000088">$ret</span><span style="color: #009900">[</span><span style="color: #009900">]</span> <span style="color: #339933">=</span> <span style="color: blue">array</span><span style="color: #009900">(</span> <span style="color: #0000ff">'query'</span> <span style="color: #339933">=></span> <span style="color: blue">substr</span><span style="color: #009900">(</span> <span style="color: #000088">$sql</span><span style="color: #339933">,</span> <span style="color: #cc66cc">0</span><span style="color: #339933">,</span> <span style="color: #000088">$i</span> <span style="color: #009900">)</span><span style="color: #339933">,</span> <span style="color: #0000ff">'empty'</span> <span style="color: #339933">=></span> <span style="color: #000088">$nothing</span> <span style="color: #009900">)</span><span style="color: #339933">;</span> <span style="color: #000088">$nothing</span> <span style="color: #339933">=</span> <span style="color: #009900; font-weight: bold">true</span><span style="color: #339933">;</span> <span style="color: #000088">$sql</span> <span style="color: #339933">=</span> <span style="color: blue">ltrim</span><span style="color: #009900">(</span><span style="color: blue">substr</span><span style="color: #009900">(</span><span style="color: #000088">$sql</span><span style="color: #339933">,</span> <span style="color: blue">min</span><span style="color: #009900">(</span><span style="color: #000088">$i</span> <span style="color: #339933">+</span> <span style="color: #cc66cc">1</span><span style="color: #339933">,</span> <span style="color: #000088">$sql_len</span><span style="color: #009900">)</span><span style="color: #009900">)</span><span style="color: #009900">)</span><span style="color: #339933">;</span> <span style="color: #000088">$sql_len</span> <span style="color: #339933">=</span> <span style="color: blue">strlen</span><span style="color: #009900">(</span><span style="color: #000088">$sql</span><span style="color: #009900">)</span><span style="color: #339933">;</span> <span style="color: #0099cc">if</span> <span style="color: #009900">(</span> <span style="color: #000088">$sql_len</span> <span style="color: #009900">)</span> <span style="color: #009900">{</span> <span style="color: #000088">$i</span> <span style="color: #339933">=</span> <span style="color: #339933">-</span><span style="color: #cc66cc">1</span><span style="color: #339933">;</span> <span style="color: #009900">}</span> <span style="color: #0099cc">else</span> <span style="color: #009900">{</span> <span style="color: #0099cc">return</span> <span style="color: #009900; font-weight: bold">true</span><span style="color: #339933">;</span> <span style="color: #009900">}</span> <span style="color: #009900">}</span> <span style="color: #0099cc">else</span> <span style="color: #0099cc">if</span> <span style="color: #009900">(</span><span style="color: #009900">(</span><span style="color: #000088">$char</span> <span style="color: #339933">==</span> <span style="color: #0000ff">'"'</span><span style="color: #009900">)</span> <span style="color: #339933">||</span> <span style="color: #009900">(</span><span style="color: #000088">$char</span> <span style="color: #339933">==</span> <span style="color: #0000ff">'\''</span><span style="color: #009900">)</span> <span style="color: #339933">||</span> <span style="color: #009900">(</span><span style="color: #000088">$char</span> <span style="color: #339933">==</span> <span style="color: #0000ff">'`'</span><span style="color: #009900">)</span><span style="color: #009900">)</span> <span style="color: #009900">{</span> <span style="color: #000088">$in_string</span> <span style="color: #339933">=</span> <span style="color: #009900; font-weight: bold">true</span><span style="color: #339933">;</span> <span style="color: #000088">$nothing</span> <span style="color: #339933">=</span> <span style="color: #009900; font-weight: bold">false</span><span style="color: #339933">;</span> <span style="color: #000088">$string_start</span> <span style="color: #339933">=</span> <span style="color: #000088">$char</span><span style="color: #339933">;</span> <span style="color: #009900">}</span> <span style="color: #0099cc">elseif</span> <span style="color: #009900">(</span><span style="color: #000088">$nothing</span><span style="color: #009900">)</span> <span style="color: #009900">{</span> <span style="color: #000088">$nothing</span> <span style="color: #339933">=</span> <span style="color: #009900; font-weight: bold">false</span><span style="color: #339933">;</span> <span style="color: #009900">}</span> <span style="color: #000088">$time1</span> <span style="color: #339933">=</span> <span style="color: blue">time</span><span style="color: #009900">(</span><span style="color: #009900">)</span><span style="color: #339933">;</span> <span style="color: #0099cc">if</span> <span style="color: #009900">(</span><span style="color: #000088">$time1</span> <span style="color: #339933">>=</span> <span style="color: #000088">$time0</span> <span style="color: #339933">+</span> <span style="color: #cc66cc">30</span><span style="color: #009900">)</span> <span style="color: #009900">{</span> <span style="color: #000088">$time0</span> <span style="color: #339933">=</span> <span style="color: #000088">$time1</span><span style="color: #339933">;</span> <span style="color: #339933">@</span><span style="color: blue">header</span><span style="color: #009900">(</span><span style="color: #0000ff">'X-pmaPing: Pong'</span><span style="color: #009900">)</span><span style="color: #339933">;</span> <span style="color: #009900">}</span> <span style="color: #009900">}</span> <span style="color: #0099cc">if</span> <span style="color: #009900">(</span><span style="color: #339933">!</span><span style="color: blue">empty</span><span style="color: #009900">(</span><span style="color: #000088">$sql</span><span style="color: #009900">)</span> <span style="color: #339933">&&</span> <span style="color: blue">preg_match</span><span style="color: #009900">(</span><span style="color: #0000ff">'@[^[:space:]]+@'</span><span style="color: #339933">,</span> <span style="color: #000088">$sql</span><span style="color: #009900">)</span><span style="color: #009900">)</span> <span style="color: #009900">{</span> <span style="color: #000088">$ret</span><span style="color: #009900">[</span><span style="color: #009900">]</span> <span style="color: #339933">=</span> <span style="color: blue">array</span><span style="color: #009900">(</span><span style="color: #0000ff">'query'</span> <span style="color: #339933">=></span> <span style="color: #000088">$sql</span><span style="color: #339933">,</span> <span style="color: #0000ff">'empty'</span> <span style="color: #339933">=></span> <span style="color: #000088">$nothing</span><span style="color: #009900">)</span><span style="color: #339933">;</span> <span style="color: #009900">}</span> <span style="color: #0099cc">return</span> <span style="color: #009900; font-weight: bold">true</span><span style="color: #339933">;</span> <span style="color: #009900">}</span> <span style="color: #0000ff">function</span> _Restore<span style="color: #009900">(</span><span style="color: #000088">$sql</span><span style="color: #339933">,</span> <span style="color: #000088">$split_only</span><span style="color: #009900">)</span> <span style="color: #009900">{</span> <span style="color: #0099cc">if</span> <span style="color: #009900">(</span> <span style="color: #000088">$this</span><span style="color: #339933">-></span><span style="color: #004000">debug</span> <span style="color: #009900">)</span> <span style="color: #009900">{</span> <span style="color: #000088">$this</span><span style="color: #339933">-></span><span style="color: #004000">saveLog</span><span style="color: #009900">(</span> <span style="color: #0000ff">"[start restoring]"</span> <span style="color: #009900">)</span><span style="color: #339933">;</span> <span style="color: #009900">}</span> <span style="color: #0099cc">if</span> <span style="color: #009900">(</span> <span style="color: #000088">$this</span><span style="color: #339933">-></span><span style="color: #004000">debug</span> <span style="color: #009900">)</span> <span style="color: #009900">{</span> <span style="color: #000088">$this</span><span style="color: #339933">-></span><span style="color: #004000">saveLog</span><span style="color: #009900">(</span> <span style="color: #0000ff">"[connecting to DB...]"</span> <span style="color: #009900">)</span><span style="color: #339933">;</span> <span style="color: #009900">}</span> <span style="color: #0099cc">if</span> <span style="color: #009900">(</span><span style="color: #339933">!</span><span style="color: #000088">$this</span><span style="color: #339933">-></span>_Connect<span style="color: #009900">(</span><span style="color: #009900">)</span><span style="color: #009900">)</span> <span style="color: #009900">{</span> <span style="color: #0099cc">return</span> <span style="color: #009900; font-weight: bold">false</span><span style="color: #339933">;</span> <span style="color: #009900">}</span> <span style="color: #0099cc">if</span> <span style="color: #009900">(</span> <span style="color: #000088">$this</span><span style="color: #339933">-></span><span style="color: #004000">debug</span> <span style="color: #009900">)</span> <span style="color: #009900">{</span> <span style="color: #000088">$this</span><span style="color: #339933">-></span><span style="color: #004000">saveLog</span><span style="color: #009900">(</span> <span style="color: #0000ff">"[connected to DB]"</span> <span style="color: #009900">)</span><span style="color: #339933">;</span> <span style="color: #009900">}</span> <span style="color: #0099cc">if</span> <span style="color: #009900">(</span> <span style="color: #000088">$this</span><span style="color: #339933">-></span><span style="color: #004000">debug</span> <span style="color: #009900">)</span> <span style="color: #009900">{</span> <span style="color: #000088">$this</span><span style="color: #339933">-></span><span style="color: #004000">saveLog</span><span style="color: #009900">(</span> <span style="color: #0000ff">"[decomposing...]"</span> <span style="color: #009900">)</span><span style="color: #339933">;</span> <span style="color: #009900">}</span> <span style="color: #000088">$queries</span> <span style="color: #339933">=</span> <span style="color: blue">array</span><span style="color: #009900">(</span><span style="color: #009900">)</span><span style="color: #339933">;</span> <span style="color: #000088">$errors</span> <span style="color: #339933">=</span> <span style="color: #0000ff">''</span><span style="color: #339933">;</span> <span style="font-style: italic; color: #666666">// check if is this our backup</span> <span style="color: #0099cc">if</span> <span style="color: #009900">(</span> <span style="color: blue">strpos</span><span style="color: #009900">(</span> <span style="color: #000088">$sql</span><span style="color: #339933">,</span> __SEP__ <span style="color: #009900">)</span> <span style="color: #339933">!==</span> <span style="color: #009900; font-weight: bold">false</span> <span style="color: #009900">)</span> <span style="color: #009900">{</span> <span style="color: #0099cc">if</span> <span style="color: #009900">(</span> <span style="color: #000088">$this</span><span style="color: #339933">-></span><span style="color: #004000">debug</span> <span style="color: #009900">)</span> <span style="color: #009900">{</span> <span style="color: #000088">$this</span><span style="color: #339933">-></span><span style="color: #004000">saveLog</span><span style="color: #009900">(</span> <span style="color: #0000ff">"[founding our backup file]"</span> <span style="color: #009900">)</span><span style="color: #339933">;</span> <span style="color: #009900">}</span> <span style="color: #000088">$queries</span> <span style="color: #339933">=</span> <span style="color: blue">explode</span><span style="color: #009900">(</span> __SEP__<span style="color: #339933">,</span> <span style="color: #000088">$sql</span> <span style="color: #009900">)</span><span style="color: #339933">;</span> <span style="color: #0099cc">if</span> <span style="color: #009900">(</span> <span style="color: blue">count</span><span style="color: #009900">(</span> <span style="color: #000088">$queries</span> <span style="color: #009900">)</span> <span style="color: #009900">)</span> <span style="color: #009900">{</span> <span style="color: #0099cc">if</span> <span style="color: #009900">(</span> <span style="color: #000088">$this</span><span style="color: #339933">-></span><span style="color: #004000">debug</span> <span style="color: #009900">)</span> <span style="color: #009900">{</span> <span style="color: #000088">$this</span><span style="color: #339933">-></span><span style="color: #004000">saveLog</span><span style="color: #009900">(</span> <span style="color: #0000ff">"[decomposed]"</span> <span style="color: #009900">)</span><span style="color: #339933">;</span> <span style="color: #009900">}</span> <span style="color: #0099cc">if</span> <span style="color: #009900">(</span><span style="color: #339933">!</span><span style="color: #000088">$split_only</span><span style="color: #009900">)</span> <span style="color: #009900">{</span> <span style="color: #0099cc">foreach</span> <span style="color: #009900">(</span><span style="color: #000088">$queries</span> <span style="color: #0099cc">as</span> <span style="color: #000088">$query</span><span style="color: #009900">)</span> <span style="color: #009900">{</span> <span style="color: #000088">$query</span> <span style="color: #339933">=</span> <span style="color: blue">trim</span><span style="color: #009900">(</span> <span style="color: #000088">$query</span> <span style="color: #009900">)</span><span style="color: #339933">;</span> <span style="color: #0099cc">if</span> <span style="color: #009900">(</span> <span style="color: #339933">!</span><span style="color: blue">empty</span><span style="color: #009900">(</span> <span style="color: #000088">$query</span> <span style="color: #009900">)</span> <span style="color: #009900">)</span> <span style="color: #009900">{</span> <span style="color: #0099cc">if</span> <span style="color: #009900">(</span><span style="color: #339933">!</span><span style="color: #000088">$this</span><span style="color: #339933">-></span>_Query<span style="color: #009900">(</span> <span style="color: #000088">$query</span> <span style="color: #009900">)</span> <span style="color: #009900">)</span> <span style="color: #009900">{</span> <span style="color: #000088">$errors</span> <span style="color: #339933">.=</span> <span style="color: #000088">$this</span><span style="color: #339933">-></span><span style="color: #004000">error</span> <span style="color: #339933">.</span> <span style="color: #0000ff">''</span><span style="color: #339933">;</span> <span style="color: #009900">}</span> <span style="color: #0099cc">if</span> <span style="color: #009900">(</span> <span style="color: #000088">$this</span><span style="color: #339933">-></span><span style="color: #004000">debug</span> <span style="color: #009900">)</span> <span style="color: #009900">{</span> <span style="color: #000088">$this</span><span style="color: #339933">-></span><span style="color: #004000">saveLog</span><span style="color: #009900">(</span> <span style="color: #000088">$query</span> <span style="color: #009900">)</span><span style="color: #339933">;</span> <span style="color: #009900">}</span> <span style="color: #009900">}</span> <span style="color: #009900">}</span> <span style="color: #009900">}</span> <span style="color: #009900">}</span> <span style="color: #009900">}</span> <span style="color: #0099cc">else</span> <span style="color: #009900">{</span> <span style="color: #0099cc">if</span> <span style="color: #009900">(</span> <span style="color: #000088">$this</span><span style="color: #339933">-></span><span style="color: #004000">debug</span> <span style="color: #009900">)</span> <span style="color: #009900">{</span> <span style="color: #000088">$this</span><span style="color: #339933">-></span><span style="color: #004000">saveLog</span><span style="color: #009900">(</span> <span style="color: #0000ff">"[common sql file founded]"</span> <span style="color: #009900">)</span><span style="color: #339933">;</span> <span style="color: #009900">}</span> <span style="color: #0099cc">if</span> <span style="color: #009900">(</span><span style="color: #339933">!</span><span style="color: #000088">$this</span><span style="color: #339933">-></span>_Decompose<span style="color: #009900">(</span> <span style="color: #000088">$queries</span><span style="color: #339933">,</span> <span style="color: #000088">$sql</span> <span style="color: #009900">)</span> <span style="color: #009900">)</span> <span style="color: #009900">{</span> <span style="color: #0099cc">return</span> <span style="color: #009900; font-weight: bold">false</span><span style="color: #339933">;</span> <span style="color: #009900">}</span> <span style="color: #0099cc">if</span> <span style="color: #009900">(</span> <span style="color: #000088">$this</span><span style="color: #339933">-></span><span style="color: #004000">debug</span> <span style="color: #009900">)</span> <span style="color: #009900">{</span> <span style="color: #000088">$this</span><span style="color: #339933">-></span><span style="color: #004000">saveLog</span><span style="color: #009900">(</span> <span style="color: #0000ff">"[decomposed]"</span> <span style="color: #009900">)</span><span style="color: #339933">;</span> <span style="color: #009900">}</span> <span style="color: #0099cc">foreach</span> <span style="color: #009900">(</span><span style="color: #000088">$queries</span> <span style="color: #0099cc">as</span> <span style="color: #000088">$query</span><span style="color: #009900">)</span> <span style="color: #009900">{</span> <span style="color: #0099cc">if</span> <span style="color: #009900">(</span><span style="color: #339933">!</span><span style="color: #000088">$split_only</span><span style="color: #009900">)</span> <span style="color: #009900">{</span> <span style="color: #0099cc">if</span> <span style="color: #009900">(</span><span style="color: #339933">!</span><span style="color: #000088">$this</span><span style="color: #339933">-></span>_Query<span style="color: #009900">(</span> <span style="color: blue">trim</span><span style="color: #009900">(</span> <span style="color: #000088">$query</span><span style="color: #009900">[</span><span style="color: #0000ff">'query'</span><span style="color: #009900">]</span> <span style="color: #009900">)</span> <span style="color: #009900">)</span> <span style="color: #009900">)</span> <span style="color: #009900">{</span> <span style="color: #000088">$errors</span> <span style="color: #339933">.=</span> <span style="color: #000088">$this</span><span style="color: #339933">-></span><span style="color: #004000">error</span> <span style="color: #339933">.</span> <span style="color: #0000ff">''</span><span style="color: #339933">;</span> <span style="color: #009900">}</span> <span style="color: #009900">}</span> <span style="color: #0099cc">if</span> <span style="color: #009900">(</span> <span style="color: #000088">$this</span><span style="color: #339933">-></span><span style="color: #004000">debug</span> <span style="color: #009900">)</span> <span style="color: #009900">{</span> <span style="color: #000088">$this</span><span style="color: #339933">-></span><span style="color: #004000">saveLog</span><span style="color: #009900">(</span> <span style="color: #000088">$query</span><span style="color: #009900">[</span><span style="color: #0000ff">'query'</span><span style="color: #009900">]</span> <span style="color: #009900">)</span><span style="color: #339933">;</span> <span style="color: #009900">}</span> <span style="color: #009900">}</span> <span style="color: #009900">}</span> <span style="color: #0099cc">if</span> <span style="color: #009900">(</span> <span style="color: #000088">$this</span><span style="color: #339933">-></span><span style="color: #004000">debug</span> <span style="color: #009900">)</span> <span style="color: #009900">{</span> <span style="color: #000088">$this</span><span style="color: #339933">-></span><span style="color: #004000">saveLog</span><span style="color: #009900">(</span> <span style="color: #0000ff">"[finished restoring]"</span> <span style="color: #009900">)</span><span style="color: #339933">;</span> <span style="color: #009900">}</span> <span style="color: #000088">$this</span><span style="color: #339933">-></span>_Disconnect<span style="color: #009900">(</span><span style="color: #009900">)</span><span style="color: #339933">;</span> <span style="color: #0099cc">if</span> <span style="color: #009900">(</span> <span style="color: #339933">!</span><span style="color: blue">empty</span><span style="color: #009900">(</span> <span style="color: #000088">$errors</span> <span style="color: #009900">)</span> <span style="color: #009900">)</span> <span style="color: #009900">{</span> <span style="color: #000088">$this</span><span style="color: #339933">-></span><span style="color: #004000">error</span> <span style="color: #339933">=</span> <span style="color: #000088">$errors</span><span style="color: #339933">;</span> <span style="color: #0099cc">return</span> <span style="color: #009900; font-weight: bold">false</span><span style="color: #339933">;</span> <span style="color: #009900">}</span> <span style="color: #0099cc">return</span> <span style="color: #009900; font-weight: bold">true</span><span style="color: #339933">;</span> <span style="color: #009900">}</span> <span style="color: #0000ff">function</span> _ReadFromFile<span style="color: #009900">(</span><span style="color: #000088">$fname</span><span style="color: #339933">,</span> <span style="color: #000088">$is_compressed</span><span style="color: #009900">)</span> <span style="color: #009900">{</span> <span style="color: #0099cc">if</span> <span style="color: #009900">(</span><span style="color: #000088">$is_compressed</span><span style="color: #009900">)</span> <span style="color: #009900">{</span> <span style="color: #000088">$sql</span> <span style="color: #339933">=</span> <span style="color: blue">gzfile</span><span style="color: #009900">(</span><span style="color: #000088">$fname</span><span style="color: #009900">)</span><span style="color: #339933">;</span> <span style="color: #009900">}</span> <span style="color: #0099cc">else</span> <span style="color: #009900">{</span> <span style="color: #000088">$sql</span> <span style="color: #339933">=</span> <span style="color: blue">file</span><span style="color: #009900">(</span><span style="color: #000088">$fname</span><span style="color: #009900">)</span><span style="color: #339933">;</span> <span style="color: #009900">}</span> <span style="color: #0099cc">if</span> <span style="color: #009900">(</span><span style="color: #000088">$sql</span> <span style="color: #339933">===</span> <span style="color: #009900; font-weight: bold">false</span><span style="color: #009900">)</span> <span style="color: #009900">{</span> <span style="color: #0099cc">return</span> <span style="color: #009900; font-weight: bold">false</span><span style="color: #339933">;</span> <span style="color: #009900">}</span> <span style="color: #0099cc">return</span> <span style="color: blue">implode</span><span style="color: #009900">(</span><span style="color: #0000ff">''</span><span style="color: #339933">,</span> <span style="color: #000088">$sql</span><span style="color: #009900">)</span><span style="color: #339933">;</span> <span style="color: #009900">}</span> <span style="color: #0000ff">function</span> saveLog<span style="color: #009900">(</span> <span style="color: #000088">$str</span> <span style="color: #009900">)</span> <span style="color: #009900">{</span> <span style="color: #000088">$f</span> <span style="color: #339933">=</span> <span style="color: #339933">@</span><span style="color: blue">fopen</span><span style="color: #009900">(</span> <span style="color: #000088">$this</span><span style="color: #339933">-></span><span style="color: #004000">log_folder</span> <span style="color: #339933">.</span> <span style="color: #000088">$this</span><span style="color: #339933">-></span><span style="color: #004000">log_file_name</span><span style="color: #339933">,</span> <span style="color: #0000ff">"a"</span> <span style="color: #009900">)</span><span style="color: #339933">;</span> <span style="color: #339933">@</span><span style="color: blue">fwrite</span><span style="color: #009900">(</span> <span style="color: #000088">$f</span><span style="color: #339933">,</span> <span style="color: #0000ff">"["</span> <span style="color: #339933">.</span> <span style="color: blue">date</span><span style="color: #009900">(</span> <span style="color: #0000ff">"H:i:s"</span> <span style="color: #009900">)</span><span style="color: #339933">.</span> <span style="color: #0000ff">"] "</span> <span style="color: #339933">.</span> <span style="color: #000088">$str</span> <span style="color: #339933">.</span> <span style="color: #0000ff">"<span style="color: #000099; font-weight: bold">\n</span>"</span> <span style="color: #009900">)</span><span style="color: #339933">;</span> <span style="color: #339933">@</span><span style="color: blue">fclose</span><span style="color: #009900">(</span> <span style="color: #000088">$f</span> <span style="color: #009900">)</span><span style="color: #339933">;</span> <span style="color: #009900">}</span> <span style="color: #009900">}</span> <span style="color: #000000; font-weight: bold">?></span></pre> </td> </tr> </tbody> </table> </div>
试试其它关键字
还原mysql
同语言下
.
用net匹配并替换iOS标准的emoji表情符号
.
处理带Emoji表情的的字符串
.
获取微信昵称时 过滤特殊字符
.
通过判断上传文件的头字符来判断文件的类型
.
模拟百度URL加密解密算法
.
以太坊检查地址是否合法
.
实现crontab解析类
.
获取每个月的开始和结束时间
.
图片上传工具类
.
APP手机应用信息采集
可能有用的
.
C#实现的html内容截取
.
List 切割成几份 工具类
.
SQL查询 多列合并成一行用逗号隔开
.
一行一行读取txt的内容
.
C#动态修改文件夹名称(FSO实现，不移动文件)
.
c# 移动文件或文件夹
.
c#图片添加水印
.
Java PDF转换成图片并输出给前台展示
.
网站后台修改图片尺寸代码
.
处理大图片在缩略图时的展示
贡献的其它代码
Label
Copyright © 2004 - 2024 dezai.cn. All Rights Reserved
站长博客
粤ICP备13059550号-3