[PHP-DB] guidance for a rooky on a database class

2003-07-03 Thread jsWalter
I borrowed the database class definition (see below) from the PHP docs [http://www.php.net/mysql_close]. I've been reading (and reading, and reading) about '.htaccess' and 'mysql.default_host' and what to set and how to set; or at least I'm trying to read and understand. It is my understanding

[PHP-DB] Any one can help me dump XML into MySQL??

2003-07-03 Thread Nabil
Dear All ; I have an XML files like the following and i want to make an PHP code to insert it into my MySQL how can i read the nodes ot tages??? by the way i can export like this file from PhpMyAdmin but i cann't dump it back... Thanks in advance Nabil ?xml version=1.0 encoding=windows-1252 ? -

[PHP-DB] Re: XML to MySQL

2003-07-03 Thread Nabil
any one ?? Nabil [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Dear All ; I have an XML files like the following and i want to make an PHP code to insert it into my MySQL how can i read the nodes ot tages??? by the way i can export like this file from PhpMyAdmin but i cann't

[PHP-DB] How to get PHP to download web contents

2003-07-03 Thread Steve B.
How would you get PHP to download a file such as a web page and put it in a string? What keywords would relate to this (besides php download) I need a user to be able to put in a name and pass and have PHP go to a cetain site. The site can take the user/pass in the url so I do not need a form

[PHP-DB] Re: How to get PHP to download web contents

2003-07-03 Thread Nadim Attari
How would you get PHP to download a file such as a web page and put it in a string? From the manual: $html = implode ('', file ('http://www.example.com/')); Note: As of PHP 4.3.0 you can use file_get_contents() to return the contents of a file as a string. -- PHP Database Mailing List

[PHP-DB] Buenos dias - Pregunta Oracle

2003-07-03 Thread Quique NoTeLoDigo
Buenos dias Estoy empezando a trabajar con Oracle y php. Ya he trabajado con Postgres y PHP. Solo tengo una pregunta, muy concreta: Tengo Oracle en una máquina distinta al servidor Linux con Apache+PHP ¿Puedo desde PHP acceder a Oracle? He leido en php.net que hay que compilar PHP para tener

Re: [PHP-DB] Problem with select-tag within a php-script

2003-07-03 Thread - Edwin -
Hi, Ruprecht Helms [EMAIL PROTECTED] wrote: [snip] while($row = mysql_fetch_object($result)) { echo option value=\'.$row-ID.\'; [/snip] Should be: echo option value=' .$row-ID. '; ? - E - __ Do You Yahoo!? Yahoo! BB is Broadband by

[PHP-DB] Query fails after changing column name using Mascon

2003-07-03 Thread Dillon, John
When I change the name of a field the mysql query fails (using the new field name). It works if I change to an existing field. If I change that field name query doesn't work (having amended the query). Sounds like my table is not being updated to new field name, so query doesn't find the new

[PHP-DB] Acceso a Oracle (Replanteo mi pregunta)

2003-07-03 Thread Quique NoTeLoDigo
Tengo Oracle en una máquina NT Tengo Apache+php en una máquina Linux Quiero acceder desde la máquina linux al oracle de NT, pero no tengo CDs ni nada de Oracle en Linux (para instalar un cliente de oracle en la máquina Linux) ¿Puedo obtener de alguna parte un cliente de oracle para linux?

[PHP-DB] Re: Acceso a Oracle (Replanteo mi pregunta)

2003-07-03 Thread Cristian MARIN
OK, and what is your problem ? :)) -- - Cristian MARIN - Developer InterAKT Online (www.interakt.ro) Tel: +4021 312.53.12 Tel/Fax: +4021 312.51.91 [EMAIL PROTECTED] Quique Notelodigo [EMAIL PROTECTED] wrote in message news:[EMAIL

Re: [PHP-DB] Acceso a Oracle (Replanteo mi pregunta)

2003-07-03 Thread Alberto Grájeda C.
If you compile php with oracle you need at least an oracle client installed in server (where php resides). Another solution is the connection via odbc (you need compile and test odbc in your web server). In the other side, normally when you install oracle in nt you have an odbc driver (Check

[PHP-DB] Re: Acceso a Oracle (Replanteo mi pregunta)

2003-07-03 Thread Pete Morganic
Cristian Marin wrote: OK, and what is your problem ? :)) Y trwbwl iw ti dim yn diach dim iaithg on english - twpsin twp -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Database question

2003-07-03 Thread Jadiel Flores
This is right, maybe you can assign the db link to a session variable but this will work only for one specific user, but what would happen if you have around 100 users at the same time?? you will have 100 different connections to the db, and that will be slower. So, maybe you should try to

Re: [PHP-DB] should each php-script clean up it's mysql connections

2003-07-03 Thread Becoming Digital
Therefore I wonder: Is it a good behavior to end connections or let every php-script clean up after it self in some way? Actually, it's much better practice to use the correct variable names. :P Cleaning up won't help you if the script is incorrect, so the benefit of unsetting variables is

Re: [PHP-DB] Re: XML to MySQL

2003-07-03 Thread Becoming Digital
Search, please. http://marc.theaimsgroup.com/?l=php-dbw=2r=1s=XML+MySQLq=b Edward Dudlik Becoming Digital www.becomingdigital.com Did I help you? Want to show your thanks? www.amazon.com/o/registry/EGDXEBBWTYUU - Original Message - From: Nabil [EMAIL PROTECTED] To: [EMAIL

Re: [PHP-DB] Testing code

2003-07-03 Thread Becoming Digital
It's not complicated at all! MySQL and Apache both have install packages, saving you any major work, and the PHP install in a breeze if you just follow the instructions. Here's a Google search to start you off: http://www.google.com/search?q=Installing+MySQL+PHP+Apache+Windows Here's an

[PHP-DB] sqlite_udf_encode_binary and sqlite_escape_string

2003-07-03 Thread jan groot
What is the difference between sqlite_udf_encode_binary and sqlite_escape_string ? Is sqlite_escape_string the same as sqlite_udf_encode_binary, except that sqlite_escape_string is also doubling up single-quote characters (') ? Is this because a User Defined Function (UDF) automatically doubles

Re: [PHP-DB] converting function to class and function (object)

2003-07-03 Thread Becoming Digital
You shouldn't have a semicolon at the end of your class declaration/closing bracket. Also, I'm not sure if it would cause a problem, but try using standard file extensions instead of things like .cls. Lastly, just for sake of readability, you might want to simplify your naming scheme; this was a

[PHP-DB] fatal error with DB.php

2003-07-03 Thread jsWalter
I am trying to use DB.php, but I am getting htis error... Fatal error: main(): Failed opening required 'DB.php' (include_path='.;c:\php4\pear') I can't find this path defined *anywhere* I don't have PHP installed there. How can I fix this include path issue. [besides placing the PEARS

[PHP-DB] A complex query problem

2003-07-03 Thread Jason Givhan
I have 3 tables: 1. school (sID, school_name) 2. highlights (hID,highlight) 3. school_highlight_details (dID,sid,hid). I have set up a search to allow the user to submit a school name OR highlights(highlights is set up in an array of checkboxes), and then displaying any school name that

[PHP-DB] Re: A complex query problem

2003-07-03 Thread Jason Givhan
Im sorry, let me clarify the problem: I have some schools with multiple highlights. I want to search for a school that has BOTH highlights Sports AND Graduation. I can search for a school that has EITHER Sports OR Graduation using this query: SELECT schools.school_name, schools.sID FROM

[PHP-DB] Database question

2003-07-03 Thread Hardik Doshi
Hi Group, Currently i am connecting the underlying database server from every php page. To reduce the connection overhead i am thinking to store the PEAR DB object into the registry (session) at the time of user login. Here i am connecting the Database only one time and rest of the time i am

[PHP-DB] Re: Database question

2003-07-03 Thread Pete Morganic
definately do NOT recommend this path- Just make an include file at the top of each page pete Hardik Doshi wrote: Hi Group, Currently i am connecting the underlying database server from every php page. To reduce the connection overhead i am thinking to store the PEAR DB object into the registry

Re: [PHP-DB] Database question

2003-07-03 Thread Paul Chvostek
On Thu, Jul 03, 2003 at 07:00:17AM -0700, Hardik Doshi wrote: Currently i am connecting the underlying database server from every php page. To reduce the connection overhead i am thinking to store the PEAR DB object into the registry (session) at the time of user login. Here i am connecting

[PHP-DB] Re: Oracle query returning values in sqlplus, but not php.

2003-07-03 Thread Lang Sharpe
Upon further investigation, I've found that this was a permissions problem. In oracle, a user can see everybody's 'PACKAGE', but only their own 'PACKAGE BODY'. Lang Lang Sharpe wrote: Hi all Here is a test version of my script. It queries the data dictionary view ALL_SOURCE. In sqlplus

Re: [PHP-DB] Re: How to get PHP to download web contents

2003-07-03 Thread Steve B.
Hi Nadim, It works but not for sites with password window that pops up. It is not the html based password but the browser window kind. Do you know what this kind is called? I've been searching 'php get html password' etc... Thanks Just a note the other example posted causes my computer to

Re: [PHP-DB] No MySQL Support in PHP5 - Uh oh!

2003-07-03 Thread Adam Lundrigan
Exactly how would one go about installing the MySQL extension, as a workaround to the removal of the builtin MySQL library? Thanks, -Adam Lundrigan Rasmus Lerdorf [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] On Sun, 29 Jun 2003, Ben Lake wrote: Anyone have an input on the

Re: [PHP-DB] No MySQL Support in PHP5 - Uh oh!

2003-07-03 Thread Lester Caine
Exactly how would one go about installing the MySQL extension, as a workaround to the removal of the builtin MySQL library? Just select it in the php.ini list of extensions? That is how I get Firebird(Interbase) instead. Leaving sections of the code to user choice is much better than building in

[PHP-DB] Re: Connect Active Directory using LDAP... please help :)

2003-07-03 Thread sven
hi vince, Vince C wrote: ?php $ldaphost= company.com; if(!($ldap = ldap_connect($ldaphost,389))){ die(ldap server cannot be reached); } else { $oudc = dc=company, dc=com; $dn2 = ; $password = ; did you define your user and password? afaik win ad isn't searchable by anonymous. ciao

[PHP-DB] Re: Connect Active Directory using LDAP... please help :)

2003-07-03 Thread Vince C
Hi Sven, I have tried to put the my login username in that place. But it showed Invalid Credental. Since I am new to this AD and LDAP, would it be the format of my username? Should I just put my login username, or should I put the whole bunch of line such as CN=my name, DN= something like