[PHP-DB] Re: Connecting to mysql from another host

joefazee wrote: > > I want to connect to a database hosted on another server like from > www.sample.com i want to connect to www.example2.com.what did i need to > do? > > Thanks. First up you need to ensure that www.example2.com a) allows remote connections and b) has privileges for [EMAIL PROT

[PHP-DB] Store more than 1 piece of information in a single variable

ok, firstly here's my script... Now, the script's task is to select loginnames from one database1, compare them to database2, select the user_id associated with the loginnames in database2 and send a private message to each of those loginnames. Just now, the script selects only the last logi

Re: [PHP-DB] Store more than 1 piece of information in a single variable

First.. You're using mysql_fetch_array when you wanted mysql_fetch_assoc.. .. select user_id from whatever .. and then $row = mysql_fetch_array($res) .. youd have a $row[0].. mysql_fetch_assoc would allow $row['user_id'] Secondly.. You can use one query to select all the info.. select e107.user_i

RE: [PHP-DB] Store more than 1 piece of information in a single variable

(see below) -Original Message- From: Arena Servers [mailto:[EMAIL PROTECTED] Sent: Friday, August 03, 2007 10:44 AM To: php-db@lists.php.net Subject: [PHP-DB] Store more than 1 piece of information in a single variable ok, firstly here's my script... Now, the script's task is to sel

Re: [PHP-DB] Connecting to mysql from another host

Well you it depends on what method you use to access mysql. If for instance if you use PDO you could do something like that to connect and query: $db_handler = new PDO('mysql:host='.$dbhost.';dbname='.$db, $dbuser, $dbpass); $query = "SELECT id, fname, lname FROM users WHERE id>'1'"; $st_h

[PHP-DB] Re: PHP ORACLE SSL ?

Narasimha Gangaiah wrote: > Greetings, > > I am writing a web application using PHP. I want to use PEAR::DB to connect > to user database. > I want the connection to be secured using SSL. > > Does oci8.sl (php oracle dblibrary) support SSL connection to Oracle Server > ? > > I know we can secur

Re: [PHP-DB] Store more than 1 piece of information in a single variable

> First.. You're using mysql_fetch_array when you wanted > mysql_fetch_assoc.. .. select user_id from whatever .. and then $row = > mysql_fetch_array($res) .. youd have a $row[0].. mysql_fetch_assoc > would allow $row['user_id'] mysql_fetch_array($res) will fetch both associative and numerical in

Re: Re: [PHP-DB] Store more than 1 piece of information in a single variable

El mensaje ha llegado correctamente pero... estoy de vacaciones hasta el próximo 20 de Agosto. Atenderé tu correo a la vuelta. Si por el motivo que fuere necesitas ponerte en contacto con ADIMEDIA puedes hacerlo en [EMAIL PROTECTED] o en el Telf. 934 63 57 37. -- PHP Database Mailing List (htt

Re: [PHP-DB] PHP ORACLE SSL ?

Narasimha Gangaiah wrote: > Greetings, > > I am writing a web application using PHP. I want to use PEAR::DB to connect > to user database. > I want the connection to be secured using SSL. > > Does oci8.sl (php oracle dblibrary) support SSL connection to Oracle Server > ? > > I know we can securel

[PHP-DB] How to test PHP form for proper input

I've got a mail form that automatically pulls in the addressee from a MySQL db, and lets the sender fill in his/her own info before sending. I figured out how to set up tests for legal input in the different fields, but I don't know how to incorporate the test results into my form submission cod

Re: [PHP-DB] PHP ORACLE SSL ?

Thanks all for your replies. So to secure the connection between oracle server and PHP oci8 client, we have to modify the sqlnet.ora shipped with oracle product ,as suggested by christopher in his reply, and no API or interface is avaialble to do the same via PHP . In the same manual suggested