[PHP-DB] Re: Newbie needs help with multiple MySQL databases

2004-10-04 Thread Tim Van Wassenhove
In article [EMAIL PROTECTED], Matthew wrote: Hi, im fairly new to php and mysql and need a little help. im running a forum community and would like to have it run on multiple databases because of performance issues others have encountered using the same software on on database. My question is

Re: [PHP-DB] PHP 4.3.8/Oracle 9i OCI call question for BLOBs

2004-10-04 Thread Christopher Jones
[EMAIL PROTECTED] wrote: I'm trying to write text to a BLOB. I got a valid return code but it did not write the BLOB. I was able to use similar code writing to a CLOB. Any examples I've seen for BLOBs are reading from Binary files. Here's how I did the CLOB, but it would not work for

Re: [PHP-DB] Multiple Oracle connections

2004-10-04 Thread Christopher Jones
Chris Back wrote: Hi, I am hoping that someone can help diagnose this issue. I am able to successfully connect to and query a remote Oracle 9.2 database from apache2/php5. However, when I have multiple clients hitting my php scripts, all of which require a connection to the database, problems

Re: [PHP-DB] Arabic characters displayed as garbage !!

2004-10-04 Thread Dre
Thanks I will take a look at it BR [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] By default, MySQL uses the ISO-8859-1 (Latin1) character set. I guess you need to set this parameter to something suitable for Arabic (if it is supported by MySQL). I suggest you read The Character

Re: [PHP-DB] Multiple Oracle connections

2004-10-04 Thread Bastien Koert
Have you talked to the dba to see if the Oracle DB will accept more than one thread from the apache server? Bastien From: Christopher Jones [EMAIL PROTECTED] To: Chris Back [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Multiple Oracle connections Date: Mon, 04 Oct 2004 16:44:10

[PHP-DB] Postgres Trigger

2004-10-04 Thread Norma Ramirez
Hi! Does any one know the way to execute a Postgres trigger every day? I mean, the event for the trigger execution must be a moment in time. Thank's Norma Ramirez -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Arabic characters displayed as garbage !!

2004-10-04 Thread Han
Hi, I might be able to help. I've done a website that uses Chinese characters. I have to store the data in a BLOP mysql field. Then use the correct ISO for the webpage display. Try that. Han - Original Message - From: [EMAIL PROTECTED] To: Dre [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]

Re: [PHP-DB] Arabic characters displayed as garbage !!

2004-10-04 Thread Han
Sorry, I meant BLOB, not BLOP. Han. - Original Message - From: Han [EMAIL PROTECTED] To: [EMAIL PROTECTED]; Dre [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, October 04, 2004 3:24 PM Subject: Re: [PHP-DB] Arabic characters displayed as garbage !! Hi, I might be able to help.

[PHP-DB] Help needed

2004-10-04 Thread Manoj Japher
hi, I am new to PHP and I am not sure if this is the right forum. I am trying to run PHP thro webmin using CGI scripts. PHP runs fine except that when I am trying to read variables coming thro' a form after hitting the submit button, I get NULL values. I can read and write to the database

[PHP-DB] PHP Oracle Authentication using UNIX user account

2004-10-04 Thread Ben Gill
Hi, My DBA's preferred authentication method is to set up a UNIX user account (i.e. userA) and let them login without using plaintext password authentication, ie. The user has to be logged in, they can then run (for example) sqlplus / and that will log them into the correct database. This

RE: [PHP-DB] PHP Oracle Authentication using UNIX user account

2004-10-04 Thread Ben Gill
Hi Roy, - Yes the web server is on a different machine - I think remote OS auth is allowed as when I login to the DB from another host using / it works fine. (obviously logged in as userA still) My DBA suggested I might have to use SSH in some way but I have not

Re: [PHP-DB] Arabic characters displayed as garbage !!

2004-10-04 Thread M Saleh EG
The whole thing doesnt have to do anything with the DB. Because what matters is the client or the gateway character-set ( browser in your case ) so if ur on windows u're probably posting data through charset=windows-1256 so if ur using HTML then use this encoding or if ur using XHTML u could put

Re: [PHP-DB] Re: String handling

2004-10-04 Thread M Saleh EG
As I understand, you're trying to check if the passed value is an integer or not and then check it's value right? Use the TYPECASTING technique. example: $var = (int) $var; In this case you're converting ur $var to integer before processing it. Typecasting is a very well known technique in any

[PHP-DB] Opinions wanted - Multi select lists , implode explode

2004-10-04 Thread Stuart Felenstein
I was just told that having an array pulling multiple selections from a user out of a list box is a bad practice. Can this be true ? I was under the assumption it was perfectly effective. Thank you, Stuart -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

RE: [PHP-DB] Help needed

2004-10-04 Thread Gary Every
Check to see if your register_globals is set to off in php.ini. If so (likely, since it defaults to that value) you'll need to access your POST and GET variables like this: GET vars: $var = $_GET['var']; POST vars: $var = $_POST['var']; Gary Every Sr. UNIX Administrator Ingram Entertainment

RE: [PHP-DB] Opinions wanted - Multi select lists , implode explode

2004-10-04 Thread Bastien Koert
I've used it sucessfully many times. It may the other person's unfamiliarity with arrays and variables I created the below function which will handle both single choice and multiple choice drop down values and mark them as selected when the user views that drop down again. bastien ? function

RE: [PHP-DB] Postgres Trigger

2004-10-04 Thread Bastien Koert
Write a small script that runs the sp, then create a cron job that fires off that page/script at whatever your set time requirements are bastien From: Norma Ramirez [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [PHP-DB] Postgres Trigger Date: Mon, 4 Oct 2004 08:41:50 -0500 Hi! Does any one

RE: [PHP-DB] dropdown list - help

2004-10-04 Thread Bastien Koert
I created the below function which will handle both single choice and multiple choice drop down values and mark them as selected when the user views that drop down again. bastien ? function my_select($name,$rows,$multiple,$array_list,$match) { //this select box takes the above 5 arguements to

RE: [PHP-DB] Opinions wanted - Multi select lists , implode explode

2004-10-04 Thread Stuart Felenstein
Okay, well a couple of questions. If you don't mind. Right below is the code I have , and the multiple list box is filled with values and labels from a table. So may I ask: 1-Can I replace the array_list and match if I use a table instead of manual values ? 2-Also - curious to know how people

Re: [PHP-DB] Re: Convert plain text to HTML tagged text

2004-10-04 Thread Andrew Kreps
On Fri, 1 Oct 2004 23:33:46 -0400, GH [EMAIL PROTECTED] wrote: I have a question along this line... is it possible to have PHP do more than one str_replace at the same time? Have a look at the man page, it shows you how to use arrays to accomplish what you're trying to do.

Re: [PHP-DB] Re: Convert plain text to HTML tagged text

2004-10-04 Thread M Saleh EG
I think this should be posted somewhere else. Maybe the php-general list ?! This is no chemistry nor physics ! it's PHP-DB related issues right? no arrays or strings probs. Plz keep the consistancy of our good lists that are valuable for users who are us! On Mon, 4 Oct 2004 12:51:52 -0700,

[PHP-DB] Multi Page Form

2004-10-04 Thread Stuart Felenstein
Not sure if I posted about this yesterday, anyway new question. I'm building a multi page form. So Im using hidden fields and echoing them to the next page in the loop. Now someone tells me this is dangerous. because someone can save the final page (with most of the hidden values) locally,

[PHP-DB] Session Objects, Dynamic Parameters

2004-10-04 Thread Joseph Crawford
Guys can anyone explain why this is returning odd results? function getObject($class, $params=NULL) { if (!is_array($_SESSION['objects'])) { $_SESSION['objects'] = array(); } if (!isset($_SESSION['objects'][$class])) { if

RE: [PHP-DB] Opinions wanted - Multi select lists , implode explode

2004-10-04 Thread Bastien Koert
sure, you can use a table set of values...if they change often its worthwhile doing it that way. if they chang einfrequently, then why do another db call? expensive in a high volume production environment... you can create a simalar array...as long as you pass the array formated in that

RE: [PHP-DB] which DB to use?

2004-10-04 Thread Frank Hamersley
Matthew, Take a close look at Sybase 12.5.2 Express Edition - http://www.sybase.com/linuxpromo They have released the latest version of their flagship database as a royalty free Linux implementation. There are constraints being 1 CPU*, 2 Gb RAM and 5 Gb Data. If your application can live

Re: [PHP-DB] Multi Page Form

2004-10-04 Thread Frank Flynn
Using hidden fields is not less secure than using visible fields - or session variables which were filled out by end user input. Hidden fields can be modified but so can any other field and you need to check that the values you receive are expected and proper before you process them. There