PHP與mssql及oracle的連線方法??

各位大大:我是php的新手,只會用mysql的連線方式!請問各位高手有連線mssql及oracle的範例嗎?可否教教我...謝謝

Oracle 的話，是 oci_：

1. <?php
   
2. // Open the database connection
   
3. if (!($db = oci_connect('GUESTUSER', 'SECRET', 'SERVICE.NAME'))) {
   
4.   // handle errors
   
5.   die('SQL ERROR: Connection failed: ' . oci_error());
   
6. }
   
7. // Switch to the appropriate schema
   
8. $sql = 'alter schema set current_schema=SCHEMANAME';
   
9. // Parse & Execute this statement
   
10. $stmt = oci_parse($db,$sql) or die ('SQL ERROR: ' . oci_error($db));
    
11. oci_execute($stmt) or die ('SQL ERROR: ' . oci_error($stmt));
    
12. // prepare SQL insert
    
13. $desc = 'Product';
    
14. $escaped = str_replace("'","''", $desc);
    
15. $sql = "insert into MYPRODUCT (DESC, QTY) values ('{$escaped}', 0)";
    
16. // do the insertion, and make sure to commit!
    
17. $stmt = oci_parse($db,$sql) or die ("SQL ERROR: " . oci_error($db));
    
18. oci_execute($stmt) or die ("SQL ERROR: " . oci_error($stmt));
    
19. oci_commit($db) or die ("SQL ERROR: " . oci_error($db));
    
20. // Select data from the table:
    
21. $sql = 'select ID, DESC from MYPRODUCT order by ID asc';
    
22. $stmt = oci_parse($db, $sql) or die ("SQL ERROR: " . oci_error($db));
    
23. oci_execute($stmt) or die ("SQL ERROR: " . oci_error($stmt));
    
24. // Read all the data back as a hash:
    
25. while ($row = oci_fetch_assoc($stmt)) {
    
26.   echo "{$row['id'] . {$row['desc']}<br />\n";
    
27. }
    
28. //close the connection
    
29. oci_close($db);
    
30. ?>

複製代碼

Microsoft SQL server 的話，大致是 mssql_：

1. <?php
   
2. // Open the database connection
   
3. if (!($db = mssql_connect('SERVERNAME', 'GUEST_USER', 'SECRET'))) {
   
4.   // handle errors
   
5.   die('SQL ERROR: Connection failed: ' . mssql_get_last_message());
   
6. }
   
7. // Switch to the proper database:
   
8. if (!(mssql_select_db('dbname'))) {
   
9.   // handle errors
   
10.   die('SQL ERROR: Database Selection failed: ' . mssql_get_last_message());
    
11. }
    
12. // prepare SQL insert
    
13. $desc = 'Product';
    
14. $escaped = str_replace("'","''", $desc);
    
15. $sql = "insert into myproduct (desc, qty) values ('{$escaped}', 0)";
    
16. // do the insertion:
    
17. if (!(mssql_query($sql))) {
    
18.   // Give an error statement:
    
19.   die('SQL INSERT ERROR: ' . mssql_get_last_message() .
    
20.        " - Query was: {$sql}");
    
21. }
    
22. // Select data from the table:
    
23. $sql = 'select id, desc from myproduct order by id asc';
    
24. if (!($result = mssql_query($sql))) {
    
25.   // Give an error statement:
    
26.   die('SQL SELECT ERROR: ' . mssql_get_last_message() .
    
27.        " - Query was: {$sql}");
    
28. }
    
29. // Read all the data back as a hash:
    
30. while ($row = mssql_fetch_assoc($result)) {
    
31.   echo "{$row['id'] . {$row['desc']}<br />\n";
    
32. }
    
33. //close the connection
    
34. mssql_close($db);
    
35. ?>

複製代碼

...

瀏覽完整內容，請先 註冊 或 登入會員

或許你可以試試用 ADODB 的方式連資料庫

謝謝~~二位大大的協助喔
我試試看..!!

2009還是2010，微軟開始自己搞對php的支援，我就知道這是一場悲劇…XD

【SQL Server Driver for PHP Version 1.1 ─ PHP 連 SQL Server & UTF-8 的微軟官方解決方案】
參考連結：

下載: 訪客無法瀏覽下載點，請先 註冊 或 登入會員

...

瀏覽完整內容，請先 註冊 或 登入會員