define('HOSTNAME', 'BITTY-NOTEBOOK\SQLEXPRESS'); define('USERNAME', 'sa'); define('PASSWORD', '4785735'); define('DATABASE', 'Gold'); class DB{ private $dbLink; private $result; public function __construct() { $this->connect(); } protected function connect() { $this->dbLink = mssql_connect(HOSTNAME, USERNAME, PASSWORD) or die("Couldn't connect to SQL Server"); if (!$this->dbLink || !mssql_select_db(DATABASE, $this->dbLink)) { die('Unable to connect or select database!'); } } public function query($sql) { $this->result = mssql_query($sql, $this->dbLink); } public function fetch() { return mssql_fetch_array($this->result); } public function close() { mssql_close($this->dbLink); } } $db = new DB(); $sql = "INSERT INTO [Gold].[dbo].[Prices] ([Buy] ,[Sell] ,[Time]) VALUES (".$buy." ,".$sell." ,'".$time."')"; $db->query($sql); $db->close();
PHP ~ MsSQL DB Class
訂閱:
發佈留言 (Atom)
沒有留言:
發佈留言