anyone have any thoughts
Thanks for any help,
Paul
___
Paul Miller
System-Wise
pmillerATsystemDASHwiseDOTcom
AT = @
DASH = -
DOT = .
if the emails are in a CSV file, you can also use fgetcsv
?php
$handle = fopen (test.csv,r);
while ($data = fgetcsv ($handle, 1000, ,)) {
$num = count ($data);
for ($c=0; $c $num; $c++) {
print $data[$c] . br\n;
}
}
fclose ($handle);
?
- Paul
-Original Message-
: [PHP-DB] Re: Oracle/PHP Issue
I'm using the descriptor type of connection and it looks a bit different
than yours. Try changing your CONNECT_DATA setion to:
(CONNECT_DATA = (SID = BDB1) (GLOBAL_NAME = BDB1.world))
Paul Miller wrote:
Hello,
I am having a strange issue with Oracle and PHP. I am
Does anyone know how to make this work???
$sql = select TEAM_SEQ.NEXTVAL as \nextval\ from sys.dual;
I get the following error in PHP:
ociexecute(): OCIStmtExecute: ORA-00903: invalid table name
But when I use my SQL tool to hit the DB will all the same parameters, it
works just fine.
I have
All,
I am considering moving to a true 3-tier structure where the web server
does not have direct access to the database server - many times a government
requirement. I want to keep the PHP front end and use an application server
(middle tier) to handle all the DB calls and sessions. I
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Re: Architecture Question - Opinion
Paul Miller wrote:
All,
I am considering moving to a true 3-tier structure where the web
server
does not have direct access to the database server - many times a
government
requirement. I want to keep the PHP front
You might want to use single quotes
FirstName='$fname'
$sqlupdate=UPDATE UserInfo
SET ZNum='112763', FirstName='$fname', LastName='Short', TA='00',
Building='1197', Room='112', Div='FWO', Grp='IIM'
WHERE ZNum='112763';
- Paul
-Original
There are a couple of products out there that I am about to start testing,
starting first with:
- SQL Relay
http://sqlrelay.sourceforge.net/
This product uses its on C interfaces to interact with DBs and different
programming languages. It addresses a bunch of items in the PHP DB calls.
Oh ya, one more thing, I am going to integrate SQL Relay with the PHP
abstraction layer:
http://sourceforge.net/projects/sqlalphp
to give the functions a more PHP feel to them. Plus, I will be able to
retain DB specific calls if I want with this layer. I have used this layer
with a great deal
you for you sql picks:)
But what do you guys think aabout Pear :: DB? Is it as effective as these
Paul's picks?
Thank you.
Muhammed Mamedov
- Original Message -
From: Paul Miller [EMAIL PROTECTED]
To: phpdb [EMAIL PROTECTED]
Sent: Wednesday, January 21, 2004 5:44 PM
Subject: RE: [PHP-DB
One thing that is not a huge issue, just something to be aware of is the
default 2mb limit in the php.ini file. It is easily changed if you want
to upload bigger files.
- Paul
-Original Message-
From: John [mailto:[EMAIL PROTECTED]
Sent: Friday, January 23, 2004 10:04 PM
To: [EMAIL
While I totally agree with Ryan, there are instances where I have found
that people do not follow best practices, namely Oracle (Oracle File
Storage) and many MySQL/PHP programs out there (OPT and Help Center
Live). So here is some code addressing both.
You would probably need an interpreter
You probably need to specify the path in the filesize call also. It
looks like you are just pushing the filename.
Like
$filepath = /home/www/nortonway/photos/$filename;
$fd = fopen($filepath, rb);
$filedata = fread ($fd, filesize($filepath));
$zipfile - add_file($filedata, $filename);
I love this one...
extract($_REQUEST);
but it undermines the whole reason PHP moved to the new default
parameter specification. Be careful with you coding. I use it, and it
makes things much like the pre 4.3.2 release without changing the ini
files. You just have to specify the default
Also, many legacy applications use the non $_POST variable definitions.
A problem that I ran into.
- Paul
-Original Message-
From: Mignon Hunter [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 27, 2004 1:47 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] php-db
How would you extract variables from arrays?
before I was doing
$prod[] = $_POST['prod'];
$choice[] = $_POST['choice'];
then I could iterate through $prod[], $choice[]
Mignon Hunter
Webmaster
Toshiba International Corporation
(713) 466-0277 x 3461
(800) 466-0277 x 3461
Paul Miller [EMAIL
the way I do it is with http://www.ytztech.com product SQL_AL.PHP which
has a switch that will say all values are upper or lower. You can also
create a simple wrapper function that will do the lower conversion.
- Paul
-Original Message-
From: William Cheung [mailto:[EMAIL PROTECTED]
function.
Hope that is a bit clearer.
- Paul
-Original Message-
From: John W. Holmes [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 28, 2004 2:21 PM
To: [EMAIL PROTECTED]
Cc: 'Mignon Hunter'; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] php-db globals turned off
Paul Miller wrote:
Also, many
Need some quotes
input name=link TYPE=TEXT cols=40 value=\.$query_data[4].\
Output will look like
input name=link TYPE=TEXT cols=40 value=Look Here
Instead of
input name=link TYPE=TEXT cols=40 value=Look Here\
Which it probably looks like now.
- Paul
-Original Message-
From: Georg
Hi All,
Got a question for everyone. Does anyone know of a Red Hat (Fedora would
be even better) package that does the following:
- Load Balancing
- Proxying
- Host Name Redirects
- Server Heartbeat monitoring
I know IP Tables can do it with some help from some other programs, but
I am
php script.php %1 %2 %3 %4
And it is referenced as $argv[arg number]
... I think. To be sure, here is the link to that info:
http://www.php.net/manual/en/features.commandline.php
- Paul
-Original Message-
From: Ryan Jameson (USA) [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 29,
I guess I did not pay attention that day in class, but that is cool.
- Paul
-Original Message-
From: Ignatius Reilly [mailto:[EMAIL PROTECTED]
Sent: Friday, February 06, 2004 9:14 AM
To: DB list PHP; John
Subject: Re: [PHP-DB] Rules in a database
A bit of algebra first:
any
I am using OCI-8 with Oracle 9i just fine.
- Paul
-Original Message-
From: Adam Williams [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 12, 2004 9:13 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] compiling oracle support
How do I compile PHP on Unix to have oracle 9 support. Looking
In no way I am trying start some long thread here. But I have always
heard it was bad to store that much data in a session array? I could
just be really off here and not understanding what I have read. I know
PHP stores the sessions as text files. The only reason I can come up
with why one
: Robert Twitty [mailto:[EMAIL PROTECTED]
Sent: Friday, February 13, 2004 1:59 PM
To: Paul Miller
Cc: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Paging large recordsets
If you are not opearating in a stateless environment, then you could use
a cursor. The web is a stateless environment, and therefore
That means you send some output before the headers were sent. That is a
no no.
For instance, this will not work:
?php
Echo hello world;
header(Location:http://www.yahoo.com/;);
?
But this will
?php
header(Location:http://www.yahoo.com/;);
Echo hello world;
?
- Paul
-Original
I might be reading this wrong, but I do not think you should put your
meta refresh request in the png creation script. It should be in the
html body script.
Index.php
Meta-refresh to call itself in 30 secs
Call to img src=php_radio_image_creation_script.php
This JS script is awesome. I work with Oracle Portal and a guy modified
it to read portal hierarchies so I know it can read dynamic data with
modification.
http://www.destroydrop.com/javascripts/tree/
I believe you just have to be able to create the parent child
relationships and display them
Ya it has - that is a great script!
-Original Message-
From: Galbreath, Mark A [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 30, 2004 7:15 AM
To: '-{ Rene Brehmer }-'; '[EMAIL PROTECTED]'
Subject: RE: [PHP-DB] Tree structure - how to show only current branch
??
Already been done:
29 matches
Mail list logo