|
|
|
|
|
> $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";
|
|
| 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 | | | Simple class for accessing databases like MSSql Server, Oracle etc by Raju Categories : PHP, MS SQL Server, Databases, PHP Classes, Oracle | | | Oracle BIND Categories : Oracle, PHP, Databases | | | StoredProcedure, Stored Procedure, Oracle, OCI8, OCI8i Categories : OCI8, Oracle, Databases, PHP | | | normalize fields and strings used in where (command's Sql) Categories : PHP, Databases, Oracle, Functions | | | Logs hits to any page which includes it. Automatically utilises page access information left behind by PHP/FI2.0. Categories : Databases, PHP, mSQL, Databases | | | PHP CLASS for ORACLE (database connectivity) Categories : PHP, PHP Classes, Classes and Objects, Databases, Oracle | | | SQLite PHP Database Wrapper Categories : PHP, PHP Classes, Databases, SQLite, Beginner Guides | | | Implementing a Members ONLY area Categories : PHP, MySQL, Databases, Authentication | | | Checks Date-Input from HTML-Forms and converts to YYYY-MM-DD Format for MySQL Date-Fields Categories : MySQL, Date Time, PHP, Databases | | | EasySQL - connect to MySQL with just 1 php file Categories : PHP, To MySQL, Databases | | | Web Self Service Resource Scheduler Using Session Variables under php4 includes Calendar building code - requires MySQL Categories : PHP, Complete Programs, Calendar, MySQL, Databases | | | very cool guestbook that uses php, and mysql to store data. looks very nice. supports smilies / emoticons (SEG-Media V1.0) Categories : PHP, Databases, MySQL | | | Simple Mini Poll class library (SimPoll) Categories : PHP, PHP Classes, Databases, MySQL, Complete Programs | |
| |
| |
|