php-windows Digest 13 Jul 2002 02:25:59 -0000 Issue 1238
Topics (messages 14729 through 14747):
Re: strange error
14729 by: milton thomas
formatted textareas
14730 by: milton thomas
14737 by: Scott Hurring
Re: Available PHP Whitepapers
14731 by: Tracker1
14733 by: Mikey
Fopen errors out when opening a URL
14732 by: Conover, Ryan
Final Year Computer Science Project involving PHP
14734 by: Serdar Sokmen
14736 by: Scott Hurring
PHP meetup [CROSS-POST] Meet other PHP Developers in Your Area
14735 by: Jay Blanchard
14747 by: C. Hendrie
DB2 ODBC Connections...
14738 by: Erik Ableson
Re: Calling Windows DLL Files
14739 by: Scott Hurring
Re: Returning values from function
14740 by: Scott Hurring
Re: ini_set
14741 by: Scott Hurring
Re: How to dectect if a file exist in specific Folder
14742 by: Scott Hurring
Re: IIS Bugs???
14743 by: Scott Hurring
out of office test
14744 by: Collins, Robert
Re: [PHP] out of office test
14745 by: Collins, Robert
PHPDiscuss.com
14746 by: Erich Kolb
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]
----------------------------------------------------------------------
--- Begin Message ---
It seems that your variables are not set as global.. check your php.ini file
and set global variables on.
"Fungi" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I have problem testing PHP on my own server setup with IIS5.
> I tested my server with
>
> <?php
> phpinfo();
> ?>
>
> and everything goes fine, but when i test another program such as
>
> <html>
> <body>
> <form>
> <input type="text" name="cisco">
> <input type="submit">
> </form>
> <?php
> echo("$cisco");
> ?>
> </html>
>
> it prints out
>
> Notice: Undefined variable: cisco in c:\inetpub\wwwroot\fungi.php3 on line
8
>
> but when i tested it on my schools' server, it runs fine..
>
> why is this happening?
>
> ps. i am using the latest PHP version
>
>
>
>
>
>
>
--- End Message ---
--- Begin Message ---
Does anyone know how to use the textarea to display formmated text.. such as
the output from html files or an exact copy from a word document.. similar
to how msn and yahoo does there thing when you are composing and email
--- End Message ---
--- Begin Message ---
An HTML textarea cannot show any formatting, AFAIK.
Yahoo and MSN use an ActiveX control...
--
Scott Hurring
Systems Programmer
EAC Corporation
scott (*) eac.com
--
"Milton Thomas" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Does anyone know how to use the textarea to display formmated text.. such as
> the output from html files or an exact copy from a word document.. similar
> to how msn and yahoo does there thing when you are composing and email
>
>
--- End Message ---
--- Begin Message ---
To: Brian McGarvie
The number one "good thing" that php will offer over asp, is that it
can be deployed on a free OS, and a free webserver.. proper licensing
on an iis server is generally several thousand.. using mysql, or postgre
over ms-sql/db2/oracle is also a big money saver.. of course there is
the flip side...
A larger company will see the cost of licensing compared to the talent
pool available, as well as the fact that you have "someone to call" when
you need support for 2K-Server/IIS/ASP/MS-SQL... that you won't quite
get any cheaper for Linux/Apache/PHP/mySQL.
There are trade offs... if you are tired of the licensing that ms is
using.. and moving towards.. this is the biggest factor.. the new windows
licensing will cost a large amount for windows, and office over the next
several years there won't even be a release.. the next estimated windows
release is going to be in 2005-2006, so that is 3-4 years of active
upgrades, with no REAL software updates, beyond what they have offered
free in the past.
I think that MS has been an okay company overall in the past, however
the new licensing system, imho goes too far... anti-piracy in windows,
okay... forcing people to pay for temporary licenses for their office
software, and operating system, without any benefit... that is too far.
--
=======================================================================
Michael J. Ryan - tracker1[*at*]theroughnecks.com
Roughneck BBS: http://www.theroughnecks.net telnet://theroughnecks.net
=======================================================================
Y!: aztracker1 - aim: azTracker1 - icq: 4935386 - msn: see email
One program for aim/icq/yahoo/msn/irc - http://www.trillian.cc/
" Brian McGarvie" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]...
> I hate replying with this answer...
>
> but use google for 'php vs asp' and you'll get too much info to present =
> ;)
>
> http://www.google.co.uk/search?q=3Dphp+vs+asp&ie=3DISO-8859-1&hl=3Den&met=
> a=3D
>
> > -----Original Message-----
> > From: R.S. Herhuth [mailto:[EMAIL PROTECTED]]
> > Sent: 11 July 2002 6:36 PM
> > To: [EMAIL PROTECTED]
> > Subject: [PHP-WIN] Available PHP Whitepapers
> >=20
> >=20
> >=20
> > My CIO is impressed with what I have been accomplishing using=20
> > PHP and is
> > considering updating a few of their aging ASP applications,=20
> > but he needs
> > textual ammunition to present to the management committee to=20
> > do so. So
> > I was wondering if anyone knows of any technical whitepapers on PHP
> > geared towards management that I could give him to salivate over.
> >=20
> > Thanks,
> > Ron
> >=20
> > --=20
> > PHP Windows Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >=20
> >=20
--- Synchronet NewsLink v1.00 Beta
* Roughneck BBS - www.theroughnecks.net - telnet://theroughnecks.net
--- End Message ---
--- Begin Message ---
> A larger company will see the cost of licensing compared to the talent
> pool available, as well as the fact that you have "someone to call" when
> you need support for 2K-Server/IIS/ASP/MS-SQL... that you won't quite
> get any cheaper for Linux/Apache/PHP/mySQL.
However, anyone that has worked for a large company who pays for this
"someone to call" facility will tell you that it isn't actally that good -
not when you need it to be... I have found these ng's to be a much better
source of help.
Just my 2c worth.
Mikey
--- End Message ---
--- Begin Message ---
I am trying to do a simple fopen("http://www.weather.com/index.html";, "r");
For some reason I cannot Open any URL's after trying several.
I get the following error
Warning: stat failed for Resource id #1 (errno=2 - No such file or
directory)
I checked my php.ini to make sure I set the fopen wrappers and they are set.
Any help would be appreciated.
Ryan Conover
[EMAIL PROTECTED]
[EMAIL PROTECTED]
http://www.pitt.edu/~rscst25/
--- End Message ---
--- Begin Message ---
Hi,
Please read the rest of this email if you're interested in helping final
year
Computer Science student (yes, that's me...) by giving him some ideas on his
final
year project very possible involving PHP and SQL...
I will start next autumn my third year of Computer Science studies. I have
to carry
out a large programming project in this final year. These projects are
supervised
and assessed via a dissertation and an oral presentation. The project alone
counts
for 20% of my whole degree, so it is quite important.
A variety of project proposals have been made available for our
consideration
already but they all look very dull and boring. We are also encouraged to
come up
with our own project ideas.
The onus is on us to define the problem boundaries, to investigate possible
solutions, and to present the results verbally, in writing and (possibly) to
demonstrate in action. They like having projects that find solutions (or
improve a
current sloution) real life problems.
This summer, I am doing an internship in a Swiss IT company, working on a
Content
Management System implemented with PHP and MySQL. This will obviously give
me some
valuable experience with these languages (I sort of already learn them quite
well...) and most of our tuition in Uni is based on Java.
If you can think of an interestin final year project involving hese
languages, it
would be very kind to share it with me... In order to obtain a very high
mark, the
project needs to be challenging. For example, having an e-commerce web-site
using a
Database is seen as a "weak", non-innovative project...
Many Thanks for your time
Serdar Sokmen
[EMAIL PROTECTED]
--- End Message ---
--- Begin Message ---
How about java<->PHP interoperability?
How about a SOAP PHP backend and a PHP-GTK front-end
that communicate with each other (or, for that matter, how
about a Java GUI front-end?)
--
Scott Hurring
Systems Programmer
EAC Corporation
scott (*) eac.com
--
"Serdar Sokmen" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hi,
>
> Please read the rest of this email if you're interested in helping final
> year
>
> Computer Science student (yes, that's me...) by giving him some ideas on his
> final
>
> year project very possible involving PHP and SQL...
>
> I will start next autumn my third year of Computer Science studies. I have
> to carry
>
> out a large programming project in this final year. These projects are
> supervised
>
> and assessed via a dissertation and an oral presentation. The project alone
> counts
>
> for 20% of my whole degree, so it is quite important.
>
> A variety of project proposals have been made available for our
> consideration
>
> already but they all look very dull and boring. We are also encouraged to
> come up
>
> with our own project ideas.
>
> The onus is on us to define the problem boundaries, to investigate possible
>
> solutions, and to present the results verbally, in writing and (possibly) to
>
> demonstrate in action. They like having projects that find solutions (or
> improve a
>
> current sloution) real life problems.
>
> This summer, I am doing an internship in a Swiss IT company, working on a
> Content
>
> Management System implemented with PHP and MySQL. This will obviously give
> me some
>
> valuable experience with these languages (I sort of already learn them quite
>
> well...) and most of our tuition in Uni is based on Java.
>
> If you can think of an interestin final year project involving hese
> languages, it
>
> would be very kind to share it with me... In order to obtain a very high
> mark, the
>
> project needs to be challenging. For example, having an e-commerce web-site
> using a
>
> Database is seen as a "weak", non-innovative project...
>
>
> Many Thanks for your time
>
> Serdar Sokmen
> [EMAIL PROTECTED]
>
>
>
>
>
--- End Message ---
--- Begin Message ---
No, it's not a dating service.... :)
Want to meet other PHP developers in your area? Check out:
http://php.meetup.com/
Pretty nifty idea... especially given the lack of user groups in the U.S.
[/snip]
I thought for others who had not seen this I would post this. There is
probably already a user group in your area if you live near a major city.
According to the PHPusergroups.org web site
[http://www.phpusergroups.org/groups.phtml?menu=groups] there 189 PHP user
groups in 52 countries.
Jay
"Chaos, panic & disorder…my work here is done!"
--- End Message ---
--- Begin Message ---
Tho, when you think about it, most PHP developers COULD use a dating
service. :)
Seriously tho, this is a good idea. Thanks for the info Jay.
~ Chris
D.O.D
-----Original Message-----
From: Jay Blanchard [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 12, 2002 12:24 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: [PHP-WIN] PHP meetup [CROSS-POST] Meet other PHP Developers in
Your Area
No, it's not a dating service.... :)
Want to meet other PHP developers in your area? Check out:
http://php.meetup.com/
Pretty nifty idea... especially given the lack of user groups in the
U.S.
[/snip]
I thought for others who had not seen this I would post this. There is
probably already a user group in your area if you live near a major
city.
According to the PHPusergroups.org web site
[http://www.phpusergroups.org/groups.phtml?menu=groups] there 189 PHP
user
groups in 52 countries.
Jay
"Chaos, panic & disorder.my work here is done!"
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
Well - here's an odd one:
PHP 4.2.1 (win32)
apache 1.3.26
W2K Workstation
Making an ODBC Connection to a DB2 database, everything is working with the
sole exception that it never ever returns any rows. The correct number of
fields are being returned each time, even when the query absolutely requires a
row to be returned.
Code
<?php
class fetch_object
{
function fetch( $re )
{
if( !$re )
return null;
$no_f = odbc_num_fields( $re );
if( odbc_fetch_row( $re ) )
{
for( $i = 1; $i <= $no_f; $i++ )
{
$fn = odbc_field_name( $re, $i );
$f_re = odbc_result( $re, $i );
$ff = "\$this->$fn = \"" . addslashes( $f_re ) .
"\";";
eval( $ff );
}
}
else
return null;
}
}
function odbc_fetch_object( $result )
{
$good = new fetch_object;
$good->fetch( $result );
return $good;
}
$dbconn = odbc_connect ( "DSN", "USER", "PASSWORD");
echo "Connected to: $dbconn<br>";
# $sqlresult = odbc_exec( $dbconn, "SELECT ATTR_NM, NEW_VALUE FROM RU99.RC548
WHERE SIGNONID = 'L6XJ'");
$sqlresult = odbc_exec( $dbconn, "SELECT COUNT(*) AS TOTAL FROM RU99.RC545
WHERE SIGNONID='L6XJ'");
echo $sqlresult . "<BR>";
$mycursor = odbc_cursor ( $sqlresult);
echo $mycursor . "<BR>";
echo "Fields: " . odbc_num_fields ($sqlresult);
echo "Rows: " . odbc_num_rows ($sqlresult);
while ($row = odbc_fetch_object ($sqlresult) ) {
echo $row->ATTR_NM . "<BR>" ;
echo $row->NEW_VALUE . "<BR>";
}
odbc_close($dbconn);
?>
Output:
Connected to: Resource id #1
Resource id #2
SQLLF0004
Fields: 1 Rows: 0
--- End Message ---
--- Begin Message ---
What could be a possible option is installing PHP/GTK on the
user's computer. Then, the GUI front-end could simply call
a windows application to scan in the document. Perhaps you
could control the scanner application via COM automation.
The PHP-GTK GUI would tag the image with a unique
ID and upload it to the server. The server would then thumbnail
it and put it into a "newly scanned dox" folder that could be
accessed thru a web-interface, and some human at the
office could then review it and put it into the appropriate
patient's file.
So, in total, the doctor would click a single button and an
office assistant would look at an image and decide which
patient's file to put it into.... pretty simple ;-)
--
Scott Hurring
Systems Programmer
EAC Corporation
scott (*) eac.com
--
"Dash McElroy" <[EMAIL PROTECTED]> wrote in message
ABA3F1F1A223D411BE6C006008A6F7E260446E@MSX1-PTON">news:ABA3F1F1A223D411BE6C006008A6F7E260446E@MSX1-PTON...
> I would think the only way to get the info automatically into the patient's
> file is if you had some kind of seriously accurate OCR software that knew
> where to look on the image and then used that for it's criteria of where to
> go. Knowing that OCR is periodically unreliable... you won't want to do
> that.
>
> Realistically, _someone_ will have to tell the document where to go. You'll
> also need to develop a process for auditing accuracy and other audits to
> make sure that the info is in the right spot. Here's an idea:
>
> 1. The document needs some sort of identification, be it a cover page or a
> sticky note in a strategic space
> 2. User scans document and tells it where to go (however you write this...)
> and PHP puts it in that patient's database entry (assuming you're using a
> database. You're using a database, right?).
> 3. At the end of the scanning, user audits their scanning to make sure all
> is well
> 4. Periodically (i.e. weekly, monthly, whatever the doc decides), someone
> does an audit to make sure that all the data is where it should be.
>
> I've worked on a system like this, and while it was a bit of a pain
> sometimes, the process is what makes the product usable. It _is_ a part of
> the product.
>
> Good luck (and don't say Visual Basic again :-> )
>
> -Dash
>
> -----Original Message-----
> From: Todd Williamsen [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, July 11, 2002 6:11 AM
> To: [EMAIL PROTECTED]
> Subject: Re: [PHP-WIN] Re: Calling Windows DLL Files
>
>
> Luis,
>
> That is fine and dandy for anybody, but this needs to be idiot proof;
> meaning he has a bunch of girls maybe high school kids working there doing
> this stuff and if the wrong information goes into the wrong patients files
> he could get his ass in a sling legally.
>
> You are right, re-writing a scanning program is the wrong way of doing it,
> but there is a way to do an API call which would call the TWAIN32.dll file,
> Photoshop does it, and most imaging applications do as well. Now, being
> able to tie in the scanning application with this application looks like the
> easy part, the hard part is getting those newly scanned files in a folder
> where they belong and being automatically tied into the patient's
> information is the hard part.
>
> I am thinking PHP isn't up to this task, and Visual Basic will be better
> suited, damn I hate saying that!
>
>
>
> "Luis Ferro" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > Hi there,
> >
> > For a complex task as such, and without needing to "rewrite" the wheel
> > (that means write a new scanning program) i would use:
> >
> > a) a scanner that works in a networked environment and as the ability to
> > send the scannings to emails (i remmeber that the network scanners from
> > HP can do it - even if they are a bit weird to configure...)
> > b) create either a global mail drop box to send all scanned documents to
> > it or create a mail box for each patient...
> > c) write a much simpler pop3/imap program to handle the archiving needs
> > with a web interface...
> >
> > For scanning, the good doctor would only need to go to the scanner,
> > place the document and press a button... in the scanner
> >
> > For archiving, he would just go to the site and place the newly scanned
> > documents in the patient file...
> >
> > Cheers,
> > Luis Ferro
> > TelaDigital
> >
> > P.S.- warning... the HP net scanners are weird to configure as they
> > require a domain to "distribute" the scannings and have some limitations
> > with regard of the ip network settings of the scanning server and the ip
> > of the scanners by themselfs. They must reside in the same net mask...
> > which in large distributed networks is a no-no... apart from that, they
> > work very well...
> >
>
>
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
Do it the opposite way... don't use "&" when passing vars to
functions, but do use it when receiving values in functions:
<?
function test (&$value) {
$value = "Hey";
}
test($x);
print $x;
?>
--
Scott Hurring
Systems Programmer
EAC Corporation
scott (*) eac.com
--
"Thomas Weidner" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hy...
>
> How can I get back an reference value from an function.
> I call an COM-function witch is described as followed :
>
> int GetCount(Value 1, Value 2, return Value 3)
>
> Well... 'till now it look like this
>
> $obj = new COM("comobject");
> $count = -1;
> $error = -1;
> $error = $obj -> GetCount(1,1,&$count);
>
> I get back the int value ob GetCount, thats OK.
> But how can I get back Value 3 ???
>
> Help would be appreciated...
>
> Thanks
> Thomas Weidner
>
>
--- End Message ---
--- Begin Message ---
ini_set() does work, i use it all the time with linux and win2k. :-)
Could you be more specific, and give an example of something
that's not working -- as Colin mentioned, some values are not
changeable and there might be other restrictions setup... if you're
on a shared server, perhaps the admin. turned off ini_set() for
security reasons (although it sounds like you're running this
locally)
--
Scott Hurring
Systems Programmer
EAC Corporation
scott (*) eac.com
--
"Robert" <[EMAIL PROTECTED]> wrote in message
015a01c22815$2bf5d2b0$1aacfe91@fatalerror">news:015a01c22815$2bf5d2b0$1aacfe91@fatalerror...
> hello list,
>
> ini_set
> and his alias ini_alter,
> seems not to work under win 2000 enviroment with php 4.2.1
>
> Any suggestions about fixing the problem.
> Parse the php.ini file with preg_match could be an idea,
> but ini_set is easy and fast.
>
> regards
> robert
>
>
>
--- End Message ---
--- Begin Message ---
or use google :-)
http://google.com/search?q=PHP+file+exists&ie=UTF-8&oe=UTF-8&hl=en&lr=
5th link down is a direct link to file_exists function specs on zend.com
--
Scott Hurring
Systems Programmer
EAC Corporation
scott (*) eac.com
--
"David Elliott" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Dear Piotr
>
> On 10 July 2002 at 02:53:04 -0700 (PDT) (which was 10:53 where I live) Piotr
> Pluciennik wrote and made these points
>
> > RTFM!!!
>
> It is like saying to some one who wants to spell a word correctly 'Look it
> up in a dictionary'.
>
> If you can not spell it how can you look it up!!
>
> --
> Regards, _______________________________________________
> David | David Elliott | Software Engineer |
> _________________________| [EMAIL PROTECTED] | PGP Key ID 0x650F4534 |
> | Redneck: if you go to the family reunion to pick up women. |
>
>
--- End Message ---
--- Begin Message ---
There's a problem with IIS and the rest of the world :-)
--
Scott Hurring
Systems Programmer
EAC Corporation
scott (*) eac.com
--
"Brian McGarvie" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
OK This is a followon from my Browser thread... on [EMAIL PROTECTED];
[EMAIL PROTECTED]
I have switched the application to run from Apache, and the Browsers that were
having trouble now seem (I think - will be doing more testing later) to have
dissapeared.
So, is there a problem with IIS or PHP or IIS with PHP?
[ http://www.the-local-guide.com :: http://www.mcgarvie.net ]
--- End Message ---
--- Begin Message ---
sorry to do this but need to make sure my out of office response isint going
to spam you guys.
Robert W. Collins II
Webmaster
New Orleans Regional Transit Authority
Phone : (504) 248-3826
Fax: (504) 248-3866
Email : [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
-----Original Message-----
From: Alberto Serra [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 12, 2002 11:25 AM
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP] PHP and ORACLE
ðÒÉ×ÅÔ!
I hope you are not really living in the early 70's, are you?
Ricardo Fitzgerald wrote:
> Hi,
>
> I started with PHP and MYSQL a while ago and now I've been involved in
> a huge database project with ORACLE.
Have the Oracle box do most of it. Make sure that:
1) there is a well defined API for external application (including your
PHP client) to access data. This *must* written an paper and documented.
No code writing prior to this.
2) all about referential integrity is done within Oracle
3) use triggers and SPs to enforce data consistency (handle with care,
they load the db server if used unproperly)
4) find a good DBA to maintain the system (Oracle can degrade quite
dramatically if not properly maintained)
5) interact very little with the DB, to avoid loading its server. (That
is, call an SP, get the result set from a tmp table)
6) avoid locking as much as you can
7) Prey the current Oracle bugs are not too evil.
8) get ready to say good bye to your vacations.
9) ask for a paycheck raise
ðÏËÁ
áÌØÂÅÒÔÏ
ëÉÅ×
@-_=}{=_-@-_=}{=_-@-_=}{=_-@-_=}{=_-@-_=}{=_-@-_=}{=_-@-_=}{=_-@
LoRd, CaN yOu HeAr Me, LiKe I'm HeArInG yOu?
lOrD i'M sHiNiNg...
YoU kNoW I AlMoSt LoSt My MiNd, BuT nOw I'm HoMe AnD fReE
tHe TeSt, YeS iT iS
ThE tEsT, yEs It Is
tHe TeSt, YeS iT iS
ThE tEsT, yEs It Is.......
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
Robert W. Collins II
Webmaster
New Orleans Regional Transit Authority
Phone : (504) 248-3826
Fax: (504) 248-3866
Email : [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
-----Original Message-----
From: Collins, Robert [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 12, 2002 5:24 PM
To: [EMAIL PROTECTED]; '[EMAIL PROTECTED]'
Subject: [PHP] out of office test
sorry to do this but need to make sure my out of office response isint going
to spam you guys.
Robert W. Collins II
Webmaster
New Orleans Regional Transit Authority
Phone : (504) 248-3826
Fax: (504) 248-3866
Email : [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
-----Original Message-----
From: Alberto Serra [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 12, 2002 11:25 AM
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP] PHP and ORACLE
ðÒÉ×ÅÔ!
I hope you are not really living in the early 70's, are you?
Ricardo Fitzgerald wrote:
> Hi,
>
> I started with PHP and MYSQL a while ago and now I've been involved in
> a huge database project with ORACLE.
Have the Oracle box do most of it. Make sure that:
1) there is a well defined API for external application (including your
PHP client) to access data. This *must* written an paper and documented.
No code writing prior to this.
2) all about referential integrity is done within Oracle
3) use triggers and SPs to enforce data consistency (handle with care,
they load the db server if used unproperly)
4) find a good DBA to maintain the system (Oracle can degrade quite
dramatically if not properly maintained)
5) interact very little with the DB, to avoid loading its server. (That
is, call an SP, get the result set from a tmp table)
6) avoid locking as much as you can
7) Prey the current Oracle bugs are not too evil.
8) get ready to say good bye to your vacations.
9) ask for a paycheck raise
ðÏËÁ
áÌØÂÅÒÔÏ
ëÉÅ×
@-_=}{=_-@-_=}{=_-@-_=}{=_-@-_=}{=_-@-_=}{=_-@-_=}{=_-@-_=}{=_-@
LoRd, CaN yOu HeAr Me, LiKe I'm HeArInG yOu?
lOrD i'M sHiNiNg...
YoU kNoW I AlMoSt LoSt My MiNd, BuT nOw I'm HoMe AnD fReE
tHe TeSt, YeS iT iS
ThE tEsT, yEs It Is
tHe TeSt, YeS iT iS
ThE tEsT, yEs It Is.......
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
I have started a new website devoted strictly to discussing development with
PHP. If anyone is interested, you can see it at http://www.phpdiscuss.com.
--- End Message ---
