随缘

CREATE TABLE taoistong 
(id int identity(1,1)
,snumber char(3)
,sname nvarchar(4)
,gtime smalldatetime
,level float )
INSERT INTO taoistong SELECT 
'023',  N'测站1', '2009-12-17 10:00:00', 50.12 
INSERT INTO taoistong SELECT 
 '058', N'测站2', '2009-12-17 10:00:00', 30.24 
INSERT INTO taoistong SELECT 
 '018', N'测站3', '2009-12-17 10:00:00', 83.01 
INSERT INTO taoistong SELECT 
 '018', N'测站3', '2009-12-17 09:54:00', 50.12 
INSERT INTO taoistong SELECT 
 '058', N'测站2', '2009-12-17 09:54:00', 30.24 
INSERT INTO taoistong SELECT 
 '023', N'测站1', '2009-12-17 09:54:00', 83.01 
 
SELECT (SELECT count(1) FROM taoistong b WHERE a.gtime=b.gtime AND a.snumber>=b.snumber)
,snumber,sname,gtime,level  
FROM taoistong a ORDER BY gtime DESC,snumber

$foo = 'hello';
echo $foo.' world!<br />';
echo "$foo world!<br />";
echo '$foo world!<br />';

$foo = 'foo';
$Foo = 'Foo';
echo "$foo<br />";
echo "$Foo<br />";
echo bar()."<br />";
echo Bar()."<br />";
 
function bar() {
	echo 'bar';
}

$a = 5;
$b = $a;
$a = 7; // 此时$a=7, 而$b仍然等于5

$a = 5;
$b = &$a;
$a = 7; // 此时$a和$b都等于7

$out = `dir c:` // windows, Linux为 `ls -la`
echo $out;

// 例如以下的代码将创建一个1~10的数字数组
$numbers = range(1, 10);
//range()函数具有一个可选的第三个参数, 这个参数允许设定值之间的步幅. 例如创建一个1~10之间的奇数数组
$odds = range(1, 10, 2);
//range()函数也可以对字符进行操作, 如下
$letters = range('a', 'z');

 $products = array('Tires', 'Oil', 'Spark Plugs');
 sort($products);
 $prices = array(100, 10, 4);
 sort($prices);

 // 这是一个普通的二维数组, 存储了3种产品的代码,说明和价格.
 $products = array(array('TLR', 'Tires', 100),
		array('OIL', 'Oil', 10),
		array('SPK', 'Spark Plugs', 4));
 
 // 以下代码对订单数组中的第二列(说明)按字母进行排序
 function compare($x, $y) {
	if ($x[1] == $y[1])
		return 0;
	else if ($x[1] < $y[1])
		return -1;
	else
		return 1;
 }
 
 usort($products, 'compare')
 
 // 同时实现反向排序
 function reverse_compare($x, $y) {
	if ($x[1] == $y[1])
		returnn 0;
	else if ($x[1] < $y[1])
		return 1;
	else
		return -1;
 }
 
 usort($products, 'reverse_compare');

                                p.StartInfo.FileName = "cmd.exe";
                                p.StartInfo.UseShellExecute = false;
                                p.StartInfo.RedirectStandardInput = true;
                                p.StartInfo.RedirectStandardOutput = true;
                                p.StartInfo.RedirectStandardError = true;
                                p.StartInfo.CreateNoWindow = true;
                                p.Start();
                                p.StandardInput.WriteLine(_command);
                                p.StandardInput.WriteLine("exit");
                                //string command = "cscript.exe";
                                //p.StartInfo.Arguments = command + " c:\\windows\\system32\\iisapp.vbs /a \"www.xxx.net\" ";
 
                                //p.WaitForExit();
                                string s = p.StandardOutput.ReadToEnd();
                                p.Close();
                                LogEvent(s, LogType.normal);

<add key="Command" value="cscript.exe c:\\windows\\system32\\iisapp.vbs /a www.xxx.net" />

class MySQL {
	private $dbhost = 'localhost';
	private $dbuser = 'root';
	private $dbpass = '123';
	private $db	    = 'test';
 
	public $guid;
 
	//======================================
	// 函数: connect()
	// 功能: 连接数据库
	// 返回:
	//======================================
	public function __construct()
	{
		$this->link_id = mysql_connect($this->dbhost, $this->dbuser, $this->dbpass);
		$this->guid = md5(uniqid());
		if (!$this->link_id)
		{
			$this->halt("数据库连接失败.请检查连接参数.");
			return;
		}
 
		if (!mysql_select_db($this->db, $this->link_id))
		{
			$this->halt("选择数据库".$this->db."失败.");
			return;
		}
		mysql_query("SET NAMES 'utf8'");
	}
}

<?php
class Singleton {
	private $_db;
	private static $_single = null;
 
	public static function getInstance() {
		if (self::$_single === null)
			self::$_single = new Singleton();
		return self::$_single;
	}
 
	function __construct() {
		$this->_db = new MySQL();
	}
 
	public function db() {
		return $this->_db;
	}
}
 
/* End of file */
/* Location: */

<?PHP
require_once ('MySQL.php');
require_once ('Singleton.php');
header('content-type:text/html; charset=utf-8');
 
echo '单件模式____________________________<br />';
$s1 = Singleton::getInstance()->db();
$s2 = Singleton::getInstance()->db();
echo '$s1->guid:'.$s1->guid.'<br />';
echo '$s1->guid:'.$s2->guid.'<br />';
echo ($s1 === $s2) ? 'true' : 'false';
echo '<br />';
 
echo '直接实例化对象________________________________<br />';
$d1 = new MySQL();
echo '$d->guid:'.$d1->guid.'<br />';
$d2 = new MySQL();
echo '$d1->guid:'.$d2->guid.'<br />';
echo ($d1 === $d2) ? 'true' : 'false';
?>

        #region 报警
        [DllImport("winmm.dll", EntryPoint = "PlaySound")]
        private static extern bool Win32_PlaySound(string pszSound, IntPtr hmod, uint fdwSound);   
 
        /// <summary>
        /// 播放一个wav音频文件
        /// </summary>
        /// <param name="path"></param>
        /// <param name="asynchronous"></param>
        /// <param name="loop"></param>
        /// <param name="doNotStopPlay"></param>
        public static void PlaySound(string path, bool asynchronous, bool loop, bool doNotStopPlay)
        {
            Win32_PlaySound(path, IntPtr.Zero, (uint)((asynchronous ?
          PlaySoundMessage.SND_ASYNC : PlaySoundMessage.SND_SYNC) | (loop ?
          PlaySoundMessage.SND_LOOP : 0) | (doNotStopPlay ?
          PlaySoundMessage.SND_NOSTOP : 0) | PlaySoundMessage.SND_FILENAME));
        }
 
        /// <summary>
        /// 停止播放
        /// </summary> 
        public static void StopSound()
        {
            Win32_PlaySound(null, IntPtr.Zero, 0);
        }
 
        [Flags()]
        internal enum PlaySoundMessage
        {
            SND_SYNC = 0x0000,
            SND_ASYNC = 0x0001,
            SND_LOOP = 0x0008,
            SND_NOSTOP = 0x0010,
            SND_FILENAME = 0x00020000
        }
        #endregion