Re: [PHP-DB] Re: textarea with multiple rows and mysql insert

2003-10-15 Thread Jason End
dunno if this made it: Here's an example. In the first textbox of the form I write in the following link: http:///x/servlet/xAuthGW/wt.enterprise.URLProcessor/URLTemplateAction?u8oid=OR%3Awt.folder.SubFolder%3A492999action=ObjProps And in the second box: These are comments

Re: [PHP-DB] ODBC

2003-10-15 Thread Luis M Morales C
Hello Ricardo, I have see an litle class on phpclasses.org that open dbase files. Now on your main problem to connect foxpro data base with php via ODBC you must be made the next step: 1) Check if your Foxpro data base have ODBC drivers installed 2) Made the ODBC connex to create the DSN

[PHP-DB] Querying tables on multiple hosts in a single query

2003-10-15 Thread Rory McKinley
All The situation is thus: We are building an application (using a PHP frontend - 4.3.3 ) that processes large amounts of customer data (in some cases GB). During the processing we run queries where we compare the customer data to a number of rules tables (in a number of rules databases), e.g

Re: [PHP-DB] ODBC

2003-10-15 Thread Ricardo C. Fernandez de C.
Hi, The only stuff i have found about foxpro and PHP is this: hertz:~# apt-cache search foxpro libphp-adodb - The 'adodb' database abstraction layer for php or do you mean something else? thanks for the help. On Wed, 2003-10-15 at 08:20, Luis M Morales C wrote: Hello Ricardo, I have see

RE: [PHP-DB] ODBC

2003-10-15 Thread Robert Twitty
Take a look at ODBTP, which is located at http://odbtp.sourceforge.net. ODBTP allows you to remotely connect to Win32-based ODBC from any machine, including Linux/UNIX. -- bob On Wed, 15 Oct 2003, Ricardo C. Fernandez de C. wrote: Hi, The sad part is that there is 0 documentation about how to

Re: [PHP-DB] Querying tables on multiple hosts in a single query

2003-10-15 Thread Lester Caine
Added to this I would have a seperate connection for each of the customer db and the rules db. Currently, I have no idea how to achieve the above query given the new situation - mysql_query only accepts a single connection link. Does anyone know if there is anyway that I can perform the above

[PHP-DB] problem - query inside a function

2003-10-15 Thread Kirk Babb
Hi, I'm having trouble with a query inside a function. I thought I'd written this so that the function would fail if email and zipcode supplied were not in the same row (trying to use those two things to identify the user), but I don't think that is what is happening because I can enter the wrong

RE: [PHP-DB] problem - query inside a function

2003-10-15 Thread Hutchins, Richard
Kirk, First, I'd recommend troubleshooting this function by doing the following: [code snippet] function getEditData($email,$zipcode) { $sql = SELECT * FROM contact_info WHERE zipcode='$zipcode' AND email=\{$email}\; echo $sql; //ADD THIS LINE //$query = mysql_query($sql);

[PHP-DB] [SOLVED] Re: problem - query inside a function

2003-10-15 Thread Kirk Babb
Thanks to Karen and Richard for your help! I removed the quotes around 0 in the comparison for mysql_affected_rows. That was definitely important. I then added the echo $sql; statement Richard recommended, and saw the following: (save some time and just look at the end of the string) SELECT *

[PHP-DB] [CLARIFICATION on SOLUTION] Re: problem - query inside a function

2003-10-15 Thread Kirk Babb
Lines 7-11 should actually read as the following and then what I was saying makes sense 7} else { 8 //a bunch of variables declared here so I pulled them out for space 9} 10$this-sendResult(Edit,$varsToEdit); 11 } I had accidentally erased the curly bracket on line 9. This

[PHP-DB] db list problem

2003-10-15 Thread Kirk Babb
I keep getting this message in Italian every time I post to php.db, does anyone else have this problem? when I click on the link provided in the msg, it takes me to some page and asks for my email address so that my email could be sent to the user fsoto. I didn't do it. Can we get rid of this

[PHP-DB] inserting date from text file

2003-10-15 Thread Aleks @ USA.net
Hi all, I have a large text file that I am inserting into a mysql db and seem to have a problem with the date format. The data is currently in the mm/dd/ format. The command I am using is INSERT INTO TABLE (QID,REV,DATE) VALUES (619 , 12 , 1/4/2001); I am using phpMyAdmin with the above

Re: [PHP-DB] inserting date from text file

2003-10-15 Thread CPT John W. Holmes
From: Aleks @ USA.net [EMAIL PROTECTED] I have a large text file that I am inserting into a mysql db and seem to have a problem with the date format. The data is currently in the mm/dd/ format. MySQL expects a MMDD or -MM-DD format (the delimiter for the string version can be any

RE: [PHP-DB] inserting date from text file

2003-10-15 Thread Aleks @ USA.net
Thanks John for the idea... will use php to extract and reparse the values in the correct order... -Original Message- From: CPT John W. Holmes [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 15, 2003 5:11 PM To: Aleks @ USA.net; [EMAIL PROTECTED] Subject: Re: [PHP-DB] inserting date

[PHP-DB] Re: db list problem

2003-10-15 Thread Kirk Babb
Thanks for hijacking my thread - I guess nobody else is having this problem? I don't understand how I can post to php.db and receive notices and autoresponders from Italy (2 different guys now). -Kirk -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

[PHP-DB] Re: db list problem

2003-10-15 Thread Kirk Babb
Ah, I just read Richards note on the same problem. Let's get rid of these guys, please. -Kirk -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Querying tables on multiple hosts in a single query1

2003-10-15 Thread Neil Smth
I found this http://www.inspireonsoftware.com/Products-MyPQuery.htm Does it look like a workable solution (paritioning by customer was one of the applications mentioned). The 30 day trial looks worth a shot, they calm licensing of $450 per host. Cheers - Neil Smith. Message-ID: [EMAIL

[PHP-DB] query for multiple values

2003-10-15 Thread Robbie Staufer
Hi, Is there a way to construct a mysql query that will select * for multiple values in the same column? For example: SELECT * FROM table WHERE column = 'this' and 'that' and 'theother' Thanks, Robbie -- -*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* Robbie Staufer NCAR/SCD 1850 Table

Re: [PHP-DB] query for multiple values

2003-10-15 Thread Ignatius Reilly
SELECT * FROM table WHERE column IN ( 'this', 'that', 'theother' ) Ignatius _ - Original Message - From: Robbie Staufer [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 16, 2003 12:10 AM Subject: [PHP-DB] query for multiple values

[PHP-DB] Emailing data

2003-10-15 Thread Shiloh Madsen
Ok, im making a page that should email someone a bunch of text and trying to figure out the best way to do it. I have in my head to have the page set up as a form with an email address feild, and when you click the send button it calls up a page that emails the appropriate data to the person in

[PHP-DB] Variables not working within Functions

2003-10-15 Thread Adam Symonds
Hi, I am starting to us functions with my work but I am having troubles With the variables in the functions.. If I have the following function called from my page it will work but the variable won’t ($username) but if I put this code straight on the page then it works fine.. Any reason for the

Re: [PHP-DB] Variables not working within Functions

2003-10-15 Thread Chris Wanstrath
You are using a variable outside of the function's scope. In the function, do this: global $username; Visit www.php.net/man to get a better understanding of globals and scope. On Wed, 2003-10-15 at 22:10, Adam Symonds wrote: Hi, I am starting to us functions with my work but I am having

[PHP-DB] Help with file upload

2003-10-15 Thread Bunmi Akinmboni
Pls Help. I have done a lot of reading prior to this yet I just can't seem make it work. I wrote an upload program as seen below but the response I got was: Possible file upload attack. Filename: ayservenet.jpg Array ( [ufile1] = Array ( [name] = ayservenet.jpg [type] = image/pjpeg [tmp_name] =

[PHP-DB] subscribe me

2003-10-15 Thread Bunmi Akinmboni
-- 'Bunmi Akinmboni 5, Aibu Street, Off Bode Thomas Street, P.O. Box 6235, Surulere, Lagos, NIGERIA. Tel: (234) 1-813-3335 Fax: (234) 1-583-2585 (Nigeria Only) Fax: 1 (309) 285-2383 (International) Email: [EMAIL PROTECTED] Web site: http://www.budelak.com http://www.ayserve.net Web

Re: [PHP-DB] Help with file upload

2003-10-15 Thread John W. Holmes
Bunmi Akinmboni wrote: Pls Help. I have done a lot of reading prior to this yet I just can't seem make it work. I wrote an upload program as seen below but the response I got was: Possible file upload attack. Filename: ayservenet.jpg Array ( [ufile1] = Array ( [name] = ayservenet.jpg [type] =

Re: [PHP-DB] Help with file upload

2003-10-15 Thread Bunmi Akinmboni
His is the new code: ?php if (is_uploaded_file($_FILES['ufile1']['tmp_name'])) { copy($_FILES['ufile1']['tmp_name'], .); echo $ufile1_name ; echo DONE; echo ; print_r($_FILES); } else { echo Possible file upload attack. Filename: . $_FILES['ufile1']['name']; echo ;

Re: [PHP-DB] Help with file upload

2003-10-15 Thread John W. Holmes
Bunmi Akinmboni wrote: His is the new code: ?php if (is_uploaded_file($_FILES['ufile1']['tmp_name'])) { copy($_FILES['ufile1']['tmp_name'], .); You should be using move_uploaded_file() instead of copy(), first of all. Next, the two arguments passed to either copy() or move_uploaded_file()

Re: [PHP-DB] Help with file upload

2003-10-15 Thread George Patterson
This in in the php manual (http://www.php.net/manual/en/features.file-upload.php) but anyway... The value contained in $_FILES['ufile1']['name'] is not the name of the temporary file on the server. Try $_FILES['ufile1']['tmp_name'] instead Hence the lines if

Re: [PHP-DB] Help with file upload

2003-10-15 Thread Bunmi Akinmboni
This is reply I got: Warning: move_uploaded_file(./ayservenet.jpg): failed to open stream: Permission denied in /home/ayserve/public_html/fu/fuprocess.php on line 6 Warning: move_uploaded_file(): Unable to move '/tmp/phpfJyDSw' to './ayservenet.jpg' in

Re: [PHP-DB] Help with file upload

2003-10-15 Thread Bunmi Akinmboni
I used this code now: if (is_uploaded_file($_FILES['ufile1']['tmp_name'])) { move_uploaded_file($_FILES['ufile1']['tmp_name'],'./' . $_FILES['ufile1']['name']); This is the reply I got: Warning: move_uploaded_file(./ayservenet.jpg): failed to open stream: Permission denied in

Re: [PHP-DB] Help with file upload

2003-10-15 Thread John W. Holmes
Bunmi Akinmboni wrote: Warning: move_uploaded_file(./ayservenet.jpg): failed to open stream: Permission denied in /home/ayserve/public_html/fu/fuprocess.php on line 6 PHP runs as the web server and it does not have permission to write to the current directory. If you're using IIS, PHP runs as

Re: [PHP-DB] Help with file upload

2003-10-15 Thread Bunmi Akinmboni
So what could be the problem? I reaaly don't know. Bunmi John W. Holmes wrote: Bunmi Akinmboni wrote: Warning: move_uploaded_file(./ayservenet.jpg): failed to open stream: Permission denied in /home/ayserve/public_html/fu/fuprocess.php on line 6 PHP runs as the web server and it does not have