Re: [PHP-DB] Limiting # of connections to remote Oracle

2001-05-23 Thread John Lim
Hi Larry, See http://marc.theaimsgroup.com/?l=php-devm=98193543028899w=2 I would create a special web server listening at port 81 to perform Oracle queries. Your main web servers call the port 81 server using fopen(http://proxyserver:81/updatemail.php?params=...;); to update the Oracle

Re: [PHP-DB] Return Row count with OCI

2001-05-23 Thread Philippe Saladin
ocifetchstatement() should do the trick. It returns the number of rows. See example at : http://dev.nexen.net/docs/php/annotee/manuel_function.ocifetchstatement.php Best regards, Philippe Worawisut Pinyoyang [EMAIL PROTECTED] a écrit dans le message news: [EMAIL PROTECTED] To all PHP-db guruz!

[PHP-DB] Need a Quick help!!!!!!!!!!!!!!!!!!!

2001-05-23 Thread Ariunbold Gerelt-Od
But after installing OpenSSL,Php,Apache,when I give command - /usr/local/apachessl/bin/httpsd , I am suddenly informed by the folllowing error: Cannot load /usr/local/apachessl/libexec/apache_ssl.so into server: /usr/local/apachessl/libexec/apache_ssl.so: cannot open shared object file: No such

[PHP-DB] Need help again with num rows

2001-05-23 Thread Worawisut Pinyoyang
I try to get number of row by using OCIFetchStatement() .It returns the number of selected rows. But problem was still. The Statements in while loop (see my code below) was not execute and the word Hello don't print out. Can anyone help me please? My Code: ?php

[PHP-DB] PHP-Javascript

2001-05-23 Thread vipin chandran
Hi, Is there any method by which I can attach a javascript variable to a query string.See the following.. script language=javascript var id; uid = prompt(Enter your ID,Your ID); /script ? print header(Location: index.php?id=.this is where I should have the js variable uid); ? Please solve this.

RE: [PHP-DB] PHP-Javascript

2001-05-23 Thread Beau Lebens
you are trying to use a php header to redirect... there is no need, just do it via javscript, and keep your variables where they belong :) script language=javascript var id; uid = prompt(Enter your ID,Your ID); document.location.href = 'ndex.php?uid=' + uid; /script easy :) // -Original

[PHP-DB] NEW Quality Lead Services

2001-05-23 Thread Qualityleadservices_2348
Dear Fellow Network Marketer, Recently you requested information on our Full Questionnarre Network Marketing Leads. Our Leads are exclusive to your opportunity. We guarantee results and have a no questions asked replacement policy for any bad leads. Bottomline. Our Leads create residual

Re: Fwd: Re: [PHP-DB] OCIFetch performance problem with more rows

2001-05-23 Thread Thies C. Arntzen
On Tue, May 22, 2001 at 09:03:45PM +0200, snpe wrote: -- Forwarded Message -- Subject: Re: [PHP-DB] OCIFetch performance problem with more rows Date: Tue, 22 May 2001 21:02:42 +0200 From: snpe [EMAIL PROTECTED] To: Brian S. Dunworth [EMAIL PROTECTED] On Tuesday 22

Re: Fwd: Re: [PHP-DB] OCIFetch performance problem with more rows

2001-05-23 Thread Thies C. Arntzen
On Wed, May 23, 2001 at 12:21:08PM +0200, Remigiusz Sokolowski wrote: Hello, I have performance problem with OCIFetch (and OCIFetchInto, too) when query return more rows.Same query from sqlplus is more fastest (more rows is worse then less rows) Are the

Re: Fwd: Re: [PHP-DB] OCIFetch performance problem with more rows

2001-05-23 Thread Adi Wibowo
On Wed, 23 May 2001, Thies C. Arntzen wrote: I have performance problem with OCIFetch (and OCIFetchInto, too) when query return more rows.Same query from sqlplus is more fastest (more rows is worse then less rows) Indexes aren't problem.I use php and sqlplus with same tables.

Re: [PHP-DB] Return Row count with OCI

2001-05-23 Thread Manuel Lemos
Hello, Worawisut Pinyoyang wrote: To all PHP-db guruz! I'm novice on Oracle(OCI).In mysql has mysql_num_rows(). When i try to find OCI function about num rows i see OCIRowCount(). But in the manual told me that it cannot use with select statement. How can i know the number of

[PHP-DB] Help With Getting Values Please!

2001-05-23 Thread DanielW
Greetings. I'm trying to get a value for a single cell out of a table and into a variable. I receive the following error message: Warning: Supplied argument is not a valid MySQL result resource in /home/etc My code (abbreviated) is as follows: $sql2 = SELECT ServiceDes FROM ServiceTypes

[PHP-DB] Pages not displaying?

2001-05-23 Thread BD
Have what I think is kind of a weird situation going on... I have a survey that's dynamically built from a mysql database. The basic logic of the program is to create a table based on user name, then read 10 questions from the master table, and insert them into the user table once the user

Re: Fwd: Re: [PHP-DB] OCIFetch performance problem with more rows

2001-05-23 Thread snpe
On Wednesday 23 May 2001 12:21, you wrote: Hello, I have performance problem with OCIFetch (and OCIFetchInto, too) when query return more rows.Same query from sqlplus is more fastest (more rows is worse then less rows) Are the columns you're fetching included

Re: Fwd: Re: [PHP-DB] OCIFetch performance problem with more rows

2001-05-23 Thread snpe
On Wednesday 23 May 2001 13:13, Adi Wibowo wrote: On Wed, 23 May 2001, Thies C. Arntzen wrote: I have performance problem with OCIFetch (and OCIFetchInto, too) when query return more rows.Same query from sqlplus is more fastest (more rows is worse then less rows) Indexes

[PHP-DB] Error message

2001-05-23 Thread Anderson Sone
What it means?? I see it in a SQL Query from MSSQL 2000 Server: Msg 8152, Level 16, State 9, Line 1 String or binary data would be truncated. The statement has been terminated. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional

Re: [PHP-DB] Help With Getting Values Please!

2001-05-23 Thread Johannes Janson
Hi, $sql2 = SELECT ServiceDes FROM ServiceTypes WHERE ServiceID = $serviceid; put single quotes around $serviceid. $service_type = mysql_result($sql2, 1); I might be perpetuating the spreading of rumors but I've heard and read somewhere that mysql_query() is supposed to be better in the

Re: [PHP-DB] error

2001-05-23 Thread Johannes Janson
Hi, Warning: MySQL Connection Failed: Unknown MySQL Server Host '0f2scom' (2) in /web/sites/139/gamie/www.game-boy-advance.f2s.com/addartikel.php on line 22 Unable toconnect to database [...snip...] mysql_connect(db.game-boy-advance.f2s.com,*,**) or die(Unable toconnect to

[PHP-DB] security in PHP under Apache

2001-05-23 Thread Simon R Jones
hi there does anyone know how to make PHP run as a different user than the default one (nobody i believe). I have many users with websites and would like them to be able to run PHP under their usernames so as to ensure security. Though I'm not sure this is possible unless I install PHP as a CGI

RE: [PHP-DB] security in PHP under Apache

2001-05-23 Thread Jonathan Hilgeman
PHP runs via Apache, so it adopts the user that Apache uses, essentially. You can use a program like sudo to allow them to run certain commands on the server. Jonathan -Original Message- From: Simon R Jones [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 23, 2001 10:31 AM To: [EMAIL

[PHP-DB] User Permissions

2001-05-23 Thread Adv. Systems Design
Hello *: I have to code an app that must enforce user permissions in terms of data entry and editing (only certain records may be edited by certain people). I realize that each situation is unique, but does anyone have a starting place they recommend? TIA Luis

Re: [PHP-DB] security in PHP under Apache

2001-05-23 Thread Terry Romine
But how do you set it so a webuser would run sudo? That sounds pretty dangerous, to me. I have a similar situation where I want PHP to create a subdirectory and set privileges to it based on the login user. I end up having to create the directory by hand via SSH and then run the php script.

Re: [PHP-DB] security in PHP under Apache

2001-05-23 Thread Zak Greant
Check out suExec on the Apache website. Also, Apache 2 allows each virtual host to run as a different user - this alleviates some security issues. --zak - Original Message - From: Terry Romine [EMAIL PROTECTED] To: Jonathan Hilgeman [EMAIL PROTECTED] Cc: 'Simon R Jones' [EMAIL

[PHP-DB] Cookie Values being Displayed

2001-05-23 Thread James McLaughlin
Does anyone know what would cause a cookie value to be printed on a web page. Here is my cookie code if ($access_level == 5) $region5 = PYou have Level 5 Access/p; $cookie_name = acc5; $cookie_value = true; $cookie_expire = ; setcookie($cookie_name,

[PHP-DB] PHP and Access

2001-05-23 Thread Terry Romine
I normally work PHP/MySQL but now I have a customer that is adamant about keeping their data in an Access DB. I tried to use ADODB to do generic access scripts, but that doesn't seem to work out for me. I get an unsupported function just trying to make a connection. One problem is that my