Le serveur d’applications PHP (1/2)

<html><head><title>My First PHP-SQL script!</title></head>

<body>

<?php

$conn = Ora_Logon("login", "passwd") or die;

$curs = Ora_Open($conn);

$query = sprintf("select * from cat");

Ora_Parse($curs, $query) or die;

Ora_Exec($curs);

$ncols = Ora_Numcols($curs);

while (Ora_Fetch($curs)) {

for ($i=0; $i<$ncols; $i++) {

printf("%s = %s",ora_columnname($curs,$i),ora_getcolumn($curs,$i));

printf("

"); } }

Ora_Close($curs);

Ora_Logoff($conn);

</body>

</html>