php-windows Digest 19 Jan 2001 21:36:09 -0000 Issue 405
Topics (messages 5112 through 5123):
Re: oracle+php4
5112 by: Jean-Christophe Le Brun
Re: Uploading files...Solved
5113 by: Per Nielsen
Howdy - Upload
5114 by: Warwick Chapman (Budgee)
Javascript
5115 by: Paul Mileham
session lifetime
5116 by: DATURA
Mail
5117 by: Leonard Harris
5118 by: Leonard Harris
newsletter mailing system
5119 by: afan
PHP4 / WinNT 4 / Oracle 7.3 via ODBC
5120 by: Carlos Correa Goncalves
libsasl.dll
5121 by: Dale Heil
htacces
5122 by: dulidel the programmer
Cache
5123 by: James Duncan
Administrivia:
To subscribe to the digest, e-mail:
[EMAIL PROTECTED]
To unsubscribe from the digest, e-mail:
[EMAIL PROTECTED]
To post to the list, e-mail:
[EMAIL PROTECTED]
----------------------------------------------------------------------
Hello !
> Hello: My name is Mike and I have little problem.How can I get a
connection
> to an ORACLE8i-database with php4?
> I can't find any documentation about it.
If you've a distant database you mut install Oracle client on your PHP
serveur.
For the connection the best solution is to use OCI fonctions, here is a
sample :
// You can find the connection string in the file tnsnames.ora, this is the
only solution i've find to connect to my distant database
$Connection="(DESCRIPTION = (ADDRESS = (PROTOCOL = ...)(HOST = ...)(PORT =
...))(CONNECT_DATA = (SID = ...)))";
// under Windows NT this file is under [Oracle
Client]\Net80\Admin\Tnsnames.ora
// This is a permanent connection
$Oracle=OCIPLogon(user, passowrd, $Connection);
// sample of query
$Requete=OCIParse($Oracle, "select ALTI from POSTE order by COMMUNE");
// the ALTI field is store in the $Alti variable
OCIDefineByName($Requete,"ALTI",&$Alti);
// execute the query
OCIExecute($Requete);
// read all the rows
while (OCIFetch($Requete))
{
echo $Alti
}
Don't forget the line
extention=php_oci8.dll in your PHP.ini if you work under Windows NT, with
LINUX you must make your PHP with the OCI8 librairie i think...
If you've other questions... i've tested PHP 4.04 with IIS 4, NT 4 and
Oracle 8 client with a database installed on a HP system, it works very well
!
Good luck
Jean-Christophe Le Brun
Météo-France
CMIRNE/DET
03-88-40-42-46
[EMAIL PROTECTED]
Well...
My problem uploading files is now solved. The problem was my restriction in
file size in my upload form and the size of the file I picked for uploading.
Well needless to say that I feel a bit more than ordinary stupid right now.
Not the first time though...
Per
----------------------------------------------------------
Web: www.CornerTechnology.com
E-Mail: [EMAIL PROTECTED]
----------------------------------------------------------
Per Nielsen Corner Technology ApS
Sanatorievej 75
Tel.: (+45) 75 11 74 82 6710 Esbjerg V.
Fax: (+45) 75 11 76 55 Denmark, Europe
----------------------------------------------------------
Howzit PPL
I unsubscribed while I was on holiday in Zimbabwe. I trust everyone
had a good break. I have some news about Zimbabwe on
www.boatrace.co.za (php powered) if anyone is interested.
Any ideas how I should go about enabling user to post images with
their text news snippets. Are there upload functions. How should
the images be stored. Currently they can only upload text. If
anyone has any suggestions, please let me know.
Regards
Warwick Chapman (Glenwood 1999)
http://www.boatrace.co.za
Assistant IT Manager
Glenwood High School, Durban, South Africa
031 2055241
083 7797094
http://www.glenwoodhighschool.co.za
Can anyone help with this? How do you get variables from Javascript into a
php function?
paul
___________________________________________________
Paul Mileham [EMAIL PROTECTED]
Administration Manager
Church Pastoral Aid Society
Athena Drive (home: [EMAIL PROTECTED])
Tachbrook Park
WARWICK
CV34 6NG
01926 458473 (home: 01926 426250)
___________________________________________________
I have the following settings in PHP.INI:
[Session]
session.save_handler = files
session.save_path = C:\temp
session.use_cookies = 1
session.name = PHPSESSID
session.auto_start = 1
session.cookie_lifetime = 0
session.cookie_path = /
session.cookie_domain =
session.serialize_handler = php
session.gc_probability = 1
session.gc_maxlifetime = 86400 ; 24 hours
session.referer_check =
session.entropy_length = 0
session.entropy_file =
; session.entropy_length = 16
; session.entropy_file = /dev/urandom
session.cache_limiter = nocache
session.cache_expire = 180
session.use_trans_sid = 1
url_rewriter.tags =
"a=href,area=href,frame=src,input=src,form=fakeentry"
I'm using PHP under Windows 2000 with Apache 1.3.12.
No matter what number is given in the line session.gc_maxlifetime the
session file is deleted after 24 minutes (1440 sec.)
Is 86400 a number too big or can someone tell me what there is to do, so I
can make my own garbage collection?
Thanks, Rolf.
Does php have a mail facility that allows one to name a specific smtp server
to be used for sending the mail?
Lenny Harris
Answering my own question:
I see that I can specify the smtp server in my php.ini file.
Next time I'll examine the docs a bit more carefully before asking the
question ;-(
Lenny
Hi to all,
Need to create a newsletter mailing system where we take all the emails in a readers
panels and email them a monthly newsletter. There will be around 50.000 subscribers.
Where can I find some information on what's the best way to do it.
Also, what's the better solution: to send 4000 emails (every subscriber one email)
or one email with 4000 email addresses in Bcc.
Thanks for any help.
Afan
Hi,
I´m using PHP 4.0.4pl1 with extension php_oracle.dll, Oracle client 7.3 with
the following products installed:
-------------------------
Call Interface 7.3.4.0.0
Objects for OLE 2.2.1.0.0
32 bit ODBC 2.5.3.1.0B
Support files 7.3.4.0.0
SQL*Net Client 2.3.4.0.0
... and others
------------------------------
I´m trying to connect to an Oracle 7.3 database with ODBC functions or
direct connection. Those are the code:
---------------
putenv("ORACLE_SID=badm");
putenv("ORACLE_HOME=C:\ORANT");
putenv("TNS_ADMIN=C:\ORANT\NETWORK\ADMIN");
$connect = ora_logon("usercons@badm","sylkds");
----------------
putenv("ORACLE_SID=badm");
putenv("ORACLE_HOME=C:\ORANT");
putenv("TNS_ADMIN=C:\ORANT\NETWORK\ADMIN");
$connect = odbc_connect("badm" ,"consulta","consulta");
---------------
Both are returning the following message from PHP:
Warning: Oracle: Connection Failed: ORA-12154: TNS:could not resolve service
name in oracle.php on line xxx
Any suggestion?
I'm using
WinNT4.0sp6a, apache 1.3.14, php 4.0.4pl1.
In order to run PHP
using the Server API, I had to copy libsasl.dll to my webserver root
(d:\apache) due to
getting an error
when starting apache. Why was that necessary? And why does apache
need libsasl.dll?
Under PHP CGI, it
would run without the libsasl.dll in webserver root.
Also, that copy was
not in apache's doc or php's doc.
Hi I wanna get acces to an htacces secured folder by using PHP Variables, so
that i can use the name of the users through the variable in other
situations, and i don't want a pop-up window with user and password request
please help
Any HTML pages that contain PHP code shouldn't be cache? Is this statement
true?
If you tell the browser NOT to cache a page then does that mean all objects
on that page are also not cached? GIF images for example? I only want the
code not to cache (so the PHP code executes on the server every time the
page is requested) but I would like the images to be cached because these
don't change. Can caching be set on a per page basis or per object basis?
Thanks
James
