SpellsBook

 +PHP
+ Adobe Flash 2 0 (0)
+ Arrays (4)
+ COM for Windows (2)
+ ADODB Connection
+ Word Document
+ Image (2)
+ LDAP (3)
+ MySQL (11)
+ Regular Expressions (2)
+ String Manipulation (12)
+ Time and Date (6)
 +Snippet Options
+   Printer Friendly
 +Library Options
+   View Other Library
Adobe_Flash_3_0
C_Plus_Plus
Debian_Install
Del_me_Soon
HTML_and_CSS
JavaScript
Linux_Commands
PHP
 +General Options
+   Library Home
+   PHP-CSL Credits
+   PHP-CSL License
+   Resource Links
+   Log in
Syntax for: COM for Windows / ADODB Connection

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:

<?php

$conn 
= new COM("ADODB.Connection") or die("Cannot start ADO");
$conn->Open("Provider=SQLOLEDB; Data Source=localhost;
Initial Catalog=database; User ID=user; Password=password"
);

$rs $conn->Execute("SELECT * FROM sometable");    // Recordset

$num_columns $rs->Fields->Count();
echo 
$num_columns "n";

for (
$i=0$i $num_columns$i++)
{
    
$fld[$i] = $rs->Fields($i);
}

$rowcount 0;
while (!
$rs->EOF)
{
    for (
$i=0$i $num_columns$i++)
    {
        echo 
$fld[$i]->value "t";
    }
    echo 
"n";
    
$rowcount  ;            // increments rowcount
    
$rs->MoveNext();
}

$rs->Close();
$conn->Close();

$rs->Release();
$conn->Release();

$rs null;
$conn null;
?>
 
Description for: COM for Windows / ADODB Connection
  Open an ADODB connection


 
Powered by: PHP-CSL V0.9