RE: [PHP-DB] How to make logout from database server (ORACLE for example) when user closes its session

2002-02-19 Thread Hunter, Ray
Do not use persistent connections to the database. Use non-persistent connections and make sure to close them. Persistent connections will linger around for a while then close. Also, check the documentation on oracle concerning persistent connections http://otn.oracle.com . Ray Hunter

RE: [PHP-DB] Problem with file() function

2002-02-19 Thread Hunter, Ray
If you are behind a firewall or proxy, you will not be able to connect to www.php.net. If you are not behind a firewall or proxy and you are getting php_hostconnect errors then you need to make sure that you can get to the php.net other than with your browser. You can also try using fopen() as

RE: [PHP-DB] A good tutorial

2002-02-19 Thread Hunter, Ray
It depends on the database that you are using. One of the best databases I have used for storing images has been with oracle. You need to look up the documentation on there web site. http://otn.oracle.com. As for the other databases, I have not used images with them. On oracle I have used

RE: [PHP-DB] How do I add multiple var to a if clause ?

2002-02-21 Thread Hunter, Ray
If you are looking for speed and efficiency in your code then Mat has touched on it. This example will execute the fastest... If( $var = 3 ) {} If you do or statements or and statements all of the if statement needs to be evaluated. So if you have an or or and all the statements in the if

RE: [PHP-DB] mysql connect, while and close big problem

2002-02-21 Thread Hunter, Ray
What type of connections are you making persistent or non-persistent? Ray Hunter Firmware Engineer ENTERASYS NETWORKS -Original Message- From: Killer Angel Clark [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 21, 2002 10:17 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] mysql

RE: [PHP-DB] Secure Encrypt/Decrypt Functions

2002-02-21 Thread Hunter, Ray
You can use the mcrypt functions of php. You can look in the php manual here: http://www.php.net/manual/en/ref.mcrypt.php . You will also need to compile php with mcrypt. I use mcrypt with no problems. Ray Hunter Firmware Engineer ENTERASYS NETWORKS -Original Message- From:

RE: [PHP-DB] PHP and big production database apps ?

2002-02-22 Thread Hunter, Ray
You can get a complicated as you want. I am running postgres and php for our Quality assurance department that has a web based front-end portal with the postgres and mysql backend. I use the postgres database for the sensitive database (testing, cvs, test-cases, etc.) while I use mysql for the

RE: [PHP-DB] optimization (another tack)

2002-03-04 Thread Hunter, Ray
If you are using php and a database you can add more memory to the script and optimize the database. I only use postgres databases for all my large data so I can let you know how to optimize postgres... Ray Hunter Firmware Engineer ENTERASYS NETWORKS -Original Message- From: Aron

RE: [PHP-DB] optimization (another tack)

2002-03-04 Thread Hunter, Ray
-Original Message-From: Aron Pilhofer [mailto:[EMAIL PROTECTED]] Sent: Monday, March 04, 2002 9:10 AMTo: Hunter, RaySubject: RE: [PHP-DB] optimization (another tack) That would be great! Thanks. [Aron Pilhofer] -Original Message-From: Hunter, Ray [mailto:[EMAIL

RE: [PHP-DB] textarea and mysql query

2002-03-18 Thread Hunter, Ray
Try this: form name=wel_area method=post action=index_confirm.php3 target=box ?php $record = mysql_fetch_array(@mysql_query(SELECT wel_area FROM cm_index,$dbh)); echo textarea name='wel_area' value='.$record['wel_area'].' cols='25' rows='8'/textareabrinput type='submit' name='save'

RE: [PHP-DB] textarea and mysql query

2002-03-18 Thread Hunter, Ray
What is the result of $record['wel_area']. If this is a multidimensional array then you will need to access it differently... Example: echo $record[0][0].\n; Try this is your text area and see if that comes out... Thank you, Ray Hunter Firmware Engineer ENTERASYS NETWORKS

RE: [PHP-DB] Relational database

2002-03-21 Thread Hunter, Ray
Try this: SELECT ccsd.Description, ccsd.Impact, ccsd.Isolation FROM ccsd, log WHERE ccsd.logccsd=log.logccsd; You cannot specify a database is = to a row... Thank you, Ray Hunter Firmware Engineer ENTERASYS NETWORKS -Original Message- From: Ron [mailto:[EMAIL PROTECTED]] Sent: