<?xml version="1.0"?>
<feed xmlns="http://www.w3.org/2005/Atom" xml:lang="zh-Hant-TW">
	<id>http://tskds213.synology.me/mediawiki/api.php?action=feedcontributions&amp;feedformat=atom&amp;user=192.168.1.96</id>
	<title>TSK WIKI - 使用者貢獻 [zh-tw]</title>
	<link rel="self" type="application/atom+xml" href="http://tskds213.synology.me/mediawiki/api.php?action=feedcontributions&amp;feedformat=atom&amp;user=192.168.1.96"/>
	<link rel="alternate" type="text/html" href="http://tskds213.synology.me/mediawiki/index.php?title=%E7%89%B9%E6%AE%8A:%E4%BD%BF%E7%94%A8%E8%80%85%E8%B2%A2%E7%8D%BB/192.168.1.96"/>
	<updated>2026-11-17T00:04:00Z</updated>
	<subtitle>使用者貢獻</subtitle>
	<generator>MediaWiki 1.43.5</generator>
	<entry>
		<id>http://tskds213.synology.me/mediawiki/index.php?title=PHP%E6%8A%80%E5%B7%A7&amp;diff=4011</id>
		<title>PHP技巧</title>
		<link rel="alternate" type="text/html" href="http://tskds213.synology.me/mediawiki/index.php?title=PHP%E6%8A%80%E5%B7%A7&amp;diff=4011"/>
		<updated>2024-10-30T01:32:39Z</updated>

		<summary type="html">&lt;p&gt;192.168.1.96：​/* SQL語法 */&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;==SQL語法==&lt;br /&gt;
&amp;lt;syntaxhighlight lang=&amp;quot;php&amp;quot;&amp;gt;&lt;br /&gt;
  $str=&amp;quot;MA001,MA002,TD001,TD002,TD003,TD004,TD005,TD006,TD008,TD009,TD020,TA002,TA006,TA015,TA017,TD016,TD021,TA011,TA013&amp;quot;;&lt;br /&gt;
  $r=explode(&#039;,&#039;,$str);&lt;br /&gt;
  for($i=0;$i&amp;lt;count($ar);$i++){&lt;br /&gt;
      $ar1[]=&#039;\&#039;&amp;quot;.$r[$i][\&#039;&#039;.$r[$i].&#039;\&#039;].&amp;quot;\&#039;&#039;;&lt;br /&gt;
      $ar2[]= $r[$i].&#039;=\&#039;&amp;quot;.$r[$i][\&#039;&#039;.$r[$i].&#039;\&#039;].&amp;quot;\&#039;&#039;;&lt;br /&gt;
  }&lt;br /&gt;
  echo  implode($ar1,&#039;,&#039;).&amp;quot;&amp;lt;BR&amp;gt;&amp;quot;;&lt;br /&gt;
  echo  implode($ar2,&#039;,&#039;).&amp;quot;&amp;lt;BR&amp;gt;&amp;quot;;&lt;br /&gt;
&amp;lt;/syntaxhighlight&amp;gt;&lt;br /&gt;
&lt;br /&gt;
==將連續數字短縮==&lt;br /&gt;
&amp;lt;php&amp;gt;&lt;br /&gt;
$pp=&#039;180911001,180911002,180911003,180911007,180911008,1809110015,1809110016,1809110017,1809110019,1809120023,1809120025&#039;;&lt;br /&gt;
$st=explode(&#039;,&#039;, $pp);&lt;br /&gt;
$i=$st[0];&lt;br /&gt;
$j=$m=$ix=$a=&#039;&#039;;&lt;br /&gt;
$iy=&#039;abc&#039;;&lt;br /&gt;
foreach ($st as $key=&amp;gt;$var){&lt;br /&gt;
    if ($i==$var) {&lt;br /&gt;
        continue;&lt;br /&gt;
    }&lt;br /&gt;
    $n=$key-1;&lt;br /&gt;
    if (($var-$st[$n])==1) {&lt;br /&gt;
        $m=$var;&lt;br /&gt;
        continue;&lt;br /&gt;
    }&lt;br /&gt;
    if ($i!=$st[$n]){&lt;br /&gt;
        $ix=substr($i,0,6);&lt;br /&gt;
        $a=($ix!=$iy)? $i : substr($i,-3);&lt;br /&gt;
        $j.=$a.&#039;~&#039;.substr($st[$n],-3).&#039;,&#039;;&lt;br /&gt;
        $iy=substr($i,0,6);&lt;br /&gt;
    }else{&lt;br /&gt;
    	$ix=substr($i,0,6);&lt;br /&gt;
    	$a=($ix!=$iy)? $i : substr($i,-3);&lt;br /&gt;
        $j.=$a.&#039;,&#039;;&lt;br /&gt;
        $iy=substr($i,0,6);&lt;br /&gt;
    }&lt;br /&gt;
    $i=$var;&lt;br /&gt;
}&lt;br /&gt;
&lt;br /&gt;
if ($i&amp;gt;$m){&lt;br /&gt;
	$ix=substr($i,0,6);&lt;br /&gt;
	$a=($ix!=$iy)? $i : substr($i,-3);&lt;br /&gt;
    $j.=$a;&lt;br /&gt;
    $iy=substr($i,0,6);&lt;br /&gt;
}else{&lt;br /&gt;
	$ix=substr($i,0,6);&lt;br /&gt;
	$a=($ix!=$iy)? $i : substr($i,-3);&lt;br /&gt;
    $j.=$a.&#039;~&#039;.substr($m,-3);&lt;br /&gt;
    $iy=substr($i,0,6);&lt;br /&gt;
 }	&lt;br /&gt;
echo $j;&lt;br /&gt;
//180911001~003,007~008,015~017,019,1809120023,025&lt;br /&gt;
//180911001,180911002,180911003,180911007,180911008,1809110015,1809110016,1809110017,1809110019,1809120023,1809120025&lt;br /&gt;
&lt;br /&gt;
&amp;lt;/php&amp;gt;&lt;/div&gt;</summary>
		<author><name>192.168.1.96</name></author>
	</entry>
</feed>