|
|
|
> $conn_id = ora_logon("user","password");
After this line add:
ora_CommitOn($conn_id);
this turns on auto-commit.
> $cur = ora_open($conn_id);
> ora_parse($cur,"insert into dbadmin.db_sessions
> (session_id,language) values (`$sessionid`,`$language`)");
> ora_exec($cur);
That should do it.
You should probably add some error checking here. For example, your
ora_parse call should look something like:
if(ora_parse(...) < 0) {
if (ora_errorcode($conn_id))
echo ora_errorcode($conn_id).":".ora_error($conn_id)."<P>\n";
}
and your ora_exec() should be:
ora_exec(...);
if(ora_errorcode($conn_id))
echo ora_errorcode($conn_id).":".ora_error($conn_id)."<P>\n";
|
|
| normalize fields and strings used in where (command's Sql)
Categories : PHP, Databases, Oracle, Functions | | | StoredProcedure, Stored Procedure, Oracle, OCI8, OCI8i
Categories : OCI8, Oracle, Databases, PHP | | | Logs hits to any page which includes it. Automatically utilises page access information left behind by PHP/FI2.0.
Categories : Databases, PHP, mSQL, Databases | | | Simple class for accessing databases like MSSql Server, Oracle etc by Raju
Categories : PHP, MS SQL Server, Databases, PHP Classes, Oracle | | | PHP CLASS for ORACLE (database connectivity)
Categories : PHP, PHP Classes, Classes and Objects, Databases, Oracle | | | This program allows you to upload an ODBC ressource - i.e. an MS-Access database to a MySQL server.
Categories : Databases, MySQL, Complete Programs, PHP, Databases | | | A database abstraction layer for the PHP Oracle 8 module (available from PHP 3.0.5). It supports persistent connections, fetching rows into arrays, prepare/execute (variable binding) and has a new and improved error interface.
Categories : Databases, Oracle, PHP, Arrays, Variables | | | Oracle BIND
Categories : Oracle, PHP, Databases | | | This is Yet Another Sql Abstraction Library. Include it in your script and you can use the most important SQL functions without worrying about the SQL backend.
Categories : Databases, PHP, ODBC, MySQL, PostgreSQL | | | simple script to send emails via a html-form to different users
Categories : Email, MySQL, PHP, Databases | | | Point and Click Interface ala MS Access for creating SQL statements.
Categories : MySQL, Complete Programs, General SQL, PHP, Databases | | | email new items in db
Categories : PHP, Email, Databases, MySQL, Beginner Guides | | | Alternating background color for HTML table rows
Categories : PHP, Databases, MySQL, HTML and PHP | | | color codes for positive and negative numbers
Categories : PHP, MySQL, Databases, HTML | | | A very simple way to build and do a hierarchical html categories browser without javascript , just using html php and mySql
Categories : HTML and PHP, Databases, Algorithms, PHP, MySQL | |
|
|
|
