code help....

Anon

Please, check the following code, when i run it, i get the following warning msg:

Warning: Supplied argument is not a valid OCI8-Statement resource in d:\orbit-2002-i\connect.php on line 37
could not execute

seems the problem is in ociexecute statement

<?php
PutEnv("ORACLE_SID=ORACLE-P");

$connection = ocilogon("web_access","web_access","omnidemo")
or die ("Could not Logon");

//Create SQL Statement

$sql = "SELECT FIRST_NAME FROM customer WHERE MAIN_USER_NAME='$username' and MAIN_PASSWORD='$password'"
or die ("Could not run sql statement");

//Parse SQL statement

$statement = "ociparse($connection, $sql)"
or die ("Could not parse sql statement");

//Execute sql query

Ociexecute($statement, OCI_DEFAULT)
or die ("could not execute sql statement");

//get number of rows, if 0 then false, if 1, then execute

$num = OCIRowCount($statement)
or die ("Could not count rows");

//present results on validity

if ($num == 1) {echo "<p>Welcome $username</p>";
}
else if ($num == 0) {
echo "sorry Mr. $username , You are not authorized";
}
php?>

mattw

$statement = "ociparse($connection, $sql)"
or die ("Could not parse sql statement");

should be

$statement = ociparse($connection, $sql)
or die ("Could not parse sql statement");

Matt Wade
codewalkers.com

Anon

working on postgresql and php want to extract records successful but want to extract specific record getting struck please help me i would be very thankful to you. my code : pass your suggestions if possible code for solving this problem.

<body bgcolor="#BAC4FF">
<?php
include("header.php");
?>
<table BORDER=4 COLS=6 WIDTH="100%">
<td>
<form method=get action="Retrive1.php">
I/C : <? print $Uic; ?>
</form>
</td>
<td>
Name :

            <?php
            $conn=pg_pconnect("user=rakesh dbname=rakesh"); // connecting to Database
            if (!$conn) {
            echo pg_errormessage($conn);            // confermation of connection
            exit;
            }
            function site_header ($title) {
            return '
            <HEAD>
            <TITLE>'.$title.'</TITLE>
            </HEAD>
            <BODY>';
            }
                                    // Site Header
            function site_footer () {
            return '</BODY>';
            }                                       // End of Html
            function query($sql) {
            global $conn;
            return pg_exec($conn,$sql);
            }                                       // Query the Database


            function ret_rec($Uic)
            {
            global $conn,$tname,$feedback,$x;
            query("BEGIN WORK");
            $res=query("SELECT * FROM employee");
            print pg_result($res,0,1);
            //$x= pg_result($res,0,7);
            //print $x;

            // session_destroy();
            return true;
            }
            $res=ret_rec($ic);
            echo site_header('retrive data from Database PostgreSQL');
            echo '<P>'.$name;
            echo site_footer();
            ?>

    </td>

</table>
</body>

rocky

by the following function i am trying to get data from database sending $Uic as parameter but can not please help.

function ret_rec($Uic)
{
global $conn,$tname,$feedback,$x;
query("BEGIN WORK");
$res=query("SELECT emplooyee_name FROM employee where employee_ic_number=$Uic");

print pg_result($res,0,0);
return true;

}

error encountered :

Warning: Supplied argument is not a valid PostgreSQL

please help
thank you