[PHP-DB] oracle (oci8) intro

[Cynic]

Hi there,

I'm in a situation where I need to produce a small app
on top of an Oracle server really quickly. I'm quite a
seasoned developer, but have only experience with MySQL
so far. It's my understanding that Oracle lacks the 
MySQL's "LIMIT" feature. Looking at the OCI section of 
the PHP manual, it also looks like there's no 
OCIDataSeek() or some equivalent. Since the app I need
to build will be a standard report builder with paging,
I need this functionality. What is the common way to 
achieve this? Always fetch all rows, cycling through the
resultset, discarding the records that preceed the one
I want to start displaying with, and quit when I reach
the one where the page should end?

Is there a PHP + OCI tutorial somewhere?

I need an intro to Oracle, and I need it now. :(

TIA


[EMAIL PROTECTED]
-
And the eyes of them both were opened and they saw that their files
were world readable and writable, so they chmoded 600 their files.
- Book of Installation chapt 3 sec 7 


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] getting ID

[Cynic]

At 19:19 8/19/2001, CrossWalkCentral wrote the following:
-- 
>I have a script where I submit user data to the database in my script I need
>to get the id  # how can I do this w/o creating a query that does the
>following considering that user could have 10 other entires.

mysql_query("insert into ...");
$id = mysql_insert_id();


>// Request info
>$result = mysql_query(
>"SELECT * FROM supportsys WHERE email = $email");
>if (!$result) {
>echo("Error performing query: " .
>mysql_error() . "");
>exit();
>}
>
>
>I basicly need to get the id$ of the record just entered
>--
>Cross Walk Central
>www.crosswalkcentral.net
>Support Center
>Your Web Hosting Community!
>
>
>
>
>-- 
>PHP Database Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]
--end of quote-- 


[EMAIL PROTECTED]
-
And the eyes of them both were opened and they saw that their files
were world readable and writable, so they chmoded 600 their files.
- Book of Installation chapt 3 sec 7 


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] backdoor in InterBase

[Cynic]

* Borland Interbase Server Contains Backdoor Account 
http://www.windowsitsecurity.com/articles/index.cfm?articleID=16566

fixes for Windows, Linux, Solaris, HP-UX and SCO available at
http://www.borland.com/interbase/downloads/patches.html




Cynic:

A member of a group of ancient Greek philosophers who taught
that virtue constitutes happiness and that self control is
the essential part of virtue.

[EMAIL PROTECTED]



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]