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 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133
|
case 'access_adodb' :
{
//definition
$database='D:\www\baseLink\cgi_bin\sgbd\bd_test_access.mdb';
$requete_test='SELECT * FROM salarie';
//connexion a la base
$conn = &ADONewConnection('access');
//$conn -> connect('MSACC');
$conn -> connect('bd_test_access');
//definition du $recordSet
$recordSet = &$conn -> Execute($requete_test);
//liberation de la memoire
$recordSet -> Close();
//fermeture de la connexion a la base
$conn -> Close();
break;
}
case 'access_odbc' :
{
//definition
$database='D:\www\baseLink\cgi_bin\sgbd\bd_test_access.mdb';
$dsn='MSACC';
$user='';
$pwd='';
$cursor_option=null; //parametre facultatif
$requete_test='SELECT * FROM salarie';
//connexion a la base
// cas avec tous les parametres
// $conn = odbc_connect($dsn,$user,$pwd,$cursor_option);
$conn = odbc_connect($dsn,$user,$pwd);
//definition du $recordSet
$recordSet = odbc_exec($conn,$requete_test);
if (!$recordSet)
{
//afficher un message d'erreur
echo $conn -> ErrorMsg();
}
else
{
//recupere les donnees
echo '<table border="1">
<tr>
<td>Nom</td>
<td>Fonction</td>
</tr>';
while(odbc_fetch_array($valeurs))
{
echo '<tr>
<td>';
echo odbc_result($valeurs,"nom").'</td>
<td>'.odbc_result($valeurs,"fonction").'</td></tr>';
$recordSet->MoveNext();
}
echo '</table>';
}
//liberation de la memoire
$recordSet -> Close();
//fermeture de la connexion a la base
$conn -> Close();
break;
}
case 'access_com_odbc' :
{
//definition
//$database='D:\www\baseLink\cgi_bin\sgbd\bd_test_access.mdb';
$database='bd_test_access.mdb';
$dsn='MSACC';
$user='';
$pwd='';
$cursor_option=null; //parametre facultatif
$requete_test='SELECT * FROM salarie';
//connexion a la base
$conn = new COM("ADODB.Connection") or die("Impossible de démarrer ADO");
//$conn->Open("Provider=MSACC; Data Source=localhost; Initial Catalog=database; User ID=user; Password=password");
// $conn = new COM('ADODB.Connection');
$conn -> open('<DRIVER={Microsoft Access Driver (*.mdb)};DBQ='.$database);
//definition du $recordSet
$recordSet = &$conn -> Execute($requete_test) or die('Erreur de requete.');
if (!$recordSet)
{
//afficher un message d'erreur
echo $conn -> ErrorMsg();
}
else
{
//recupere les donnees
echo '<table border="1">
<tr>
<td>Nom</td>
<td>Fonction</td>
</tr>';
//boucle sur tous les enregistrements
while (!$recordSet -> EOF)
{
echo '<tr>
<td>';
echo $recordSet ->fields[1].'</td>
<td>'.$recordSet ->fields[2].'</td></tr>';
$recordSet->MoveNext();
}
echo '</table>';
}
//liberation de la memoire
$recordSet -> Close();
//fermeture de la connexion a la base
$conn -> Close();
break;
} |
Partager