[PHP] Need help adding dBase support to PHP

2007-10-11 Thread Jon Westcot
Hi all: I'm not versed at all with Linux, and I need some help in configuring PHP to allow me to use the dBase-related functions. From what I read in the help files, it seems that I need to recompile PHP with the "--enable-dbase" command, but I don't know how to do this. Can someone o

Re: [PHP] Need help adding dBase support to PHP

2007-10-11 Thread Jon Westcot
Hi Nathan: I have no idea. Where would I look to find this out? Will phpinfo() give me this? And, if so, where would I find it? Jon - Original Message - From: Nathan Nobbe To: Jon Westcot Cc: PHP General Sent: Thursday, October 11, 2007 5:00 PM Subject: Re: [PHP] Need

Re: [PHP] Need help adding dBase support to PHP

2007-10-11 Thread Jon Westcot
p. Jon - Original Message - From: Nathan Nobbe To: Jon Westcot Cc: PHP General Sent: Thursday, October 11, 2007 5:08 PM Subject: Re: [PHP] Need help adding dBase support to PHP On 10/11/07, Jon Westcot <[EMAIL PROTECTED]> wrote: Hi Nathan: I have no idea. Where

Re: [PHP] Need help adding dBase support to PHP

2007-10-11 Thread Jon Westcot
: Jon Westcot Cc: PHP General Sent: Thursday, October 11, 2007 5:34 PM Subject: Re: [PHP] Need help adding dBase support to PHP On 10/11/07, Jon Westcot <[EMAIL PROTECTED]> wrote: Hi again, Nathan: I'm not certain how to get to a command line. The server is a shared server

Re: [PHP] Need help adding dBase support to PHP

2007-10-12 Thread Jon Westcot
ection in the output indicated any dBase settings whatsoever. I'm fearing that I'm going to have to find some other way to handle the extraction of data from DBF files if I can't get this to work. Thanks again for your help. Jon - Original Message - From: Nat

Re: [PHP] Need help adding dBase support to PHP

2007-10-12 Thread Jon Westcot
othing showed up. I appreciate the help you've given. I'll just have to wait and see if the person who owns the site is able to get anywhere with the GoDaddy tech support. Thanks again, Jon - Original Message - From: "Nathan Nobbe" <[EMAIL PROTECTE

[PHP] Can a PHP script process a file on a remote computer?

2007-10-24 Thread Jon Westcot
Hi all: I'm working on a project that requires frequent updating of a large amount of data to a MySQL database. Currently, I'm trying to transfer a CSV file to the server, have it process the file, and then delete it once the processing is complete. Rather than waste the up-front time of

Re: [PHP] Can a PHP script process a file on a remote computer?

2007-10-24 Thread Jon Westcot
sage - From: "Wolf" <[EMAIL PROTECTED]> To: "Jon Westcot" <[EMAIL PROTECTED]> Cc: "PHP General" Sent: Wednesday, October 24, 2007 1:16 PM Subject: Re: [PHP] Can a PHP script process a file on a remote computer? > Go into your php.ini file and incre

Re: [PHP] Can a PHP script process a file on a remote computer?

2007-10-24 Thread Jon Westcot
Hi Andrew: Thanks for the reply. If I use fopen() to open the remote file, how do I specify its location? Isn't it going to need to know not only the address of the computer I'm using but the path on that computer to the file? Does it get all that from the name I pass over to it? Al

Re: [PHP] Can a PHP script process a file on a remote computer?

2007-10-24 Thread Jon Westcot
n for your help, Jon - Original Message ----- From: "Jon Westcot" <[EMAIL PROTECTED]> To: "PHP General" Sent: Wednesday, October 24, 2007 1:22 PM Subject: Re: [PHP] Can a PHP script process a file on a remote computer? > Hi Andrew: > > Thanks for the

[PHP] How do I specify a local file for fopen()?

2007-11-04 Thread Jon Westcot
Hi all: I've been beating my head against a brick wall trying to figure this out and I'm still no closer than I was two weeks ago. How do I specify a local file on my computer to use with fopen() on the server? I've checked and the allow_url_fopen setting is set to On. I use the h

[PHP] Question about php.ini file

2007-11-04 Thread Jon Westcot
Hi all: I've learned, much to my pleasure, that I can place a php.ini file in the root directory of my shared domain to allow some customization of the php settings. However, when I do this, I keep getting weird results. Some of the values that I change appear as I've asked them to be. S

Re: [PHP] Question about php.ini file

2007-11-04 Thread Jon Westcot
might be the cause of the weird results. for example, if your limit > for uploaded files is 10M in php but the server is set to accept max 5M, > 5M will be the limit > > Jon Westcot wrote: > > Hi all: > > > > I've learned, much to my pleasure, that I can place

Re: [PHP] Question about php.ini file

2007-11-04 Thread Jon Westcot
Hi Nathan: I'm not certain if I have all of the items you've mentioned, but I'll look into it. And thanks for the link; I'll check that out, too. Jon - Original Message - From: Nathan Nobbe To: Jon Westcot Cc: PHP General Sent: Sunday, November 04, 2007

[PHP] Looking for ways to prevent timeout

2007-11-04 Thread Jon Westcot
Hi all: I'm hoping to find a solution to the problem I'm having with my script timing out while inserting records into a table. Overall, the process is pretty fast, which is impressive, but when it gets to the 22,000 to 23,000 record mark, it seems to time out. I've had it get up over

Re: [PHP] Question about php.ini file

2007-11-04 Thread Jon Westcot
need to place in the full value? Thanks again; this solution may be exactly what we need! Jon - Original Message - From: Nathan Nobbe To: Jon Westcot Cc: PHP General Sent: Sunday, November 04, 2007 5:05 PM Subject: Re: [PHP] Question about php.ini file On 11/4/07, Jon We

Re: [PHP] Looking for ways to prevent timeout

2007-11-05 Thread Jon Westcot
AIL PROTECTED]> To: "Jon Westcot" <[EMAIL PROTECTED]> Cc: "PHP General" Sent: Sunday, November 04, 2007 7:53 PM Subject: Re: [PHP] Looking for ways to prevent timeout > On 11/4/07, Jon Westcot <[EMAIL PROTECTED]> wrote: > > > > Hi all: > > >

Re: [PHP] Looking for ways to prevent timeout

2007-11-05 Thread Jon Westcot
ently, say every 100 records? I'm really struggling with this concept here, and I appreciate the help that everyone is giving me! Jon - Original Message - From: "Jochem Maas" <[EMAIL PROTECTED]> To: "Jon Westcot" <[EMAIL PROTECTED]> Cc: "PHP

[PHP] More info on timeout problem

2007-11-05 Thread Jon Westcot
Hi all: First, thanks for the multiple suggestions. I'm pretty new at PHP programming, so all suggestions are great learning opportunities. Now, some observations: I've tried placing the "ignore_user_abort(TRUE);" in the code. It seems to have made little, if any, impact -- the page s

Re: [PHP] More info on timeout problem

2007-11-05 Thread Jon Westcot
Hi Instruct ICC: > > I'm now wondering if some error is occurring that, for some reason, is > > silently ending the routine. I'm building what may be a very long SQL > > INSERT statement for each line in the CSV file that I'm reading; could > > I be hitting some upper limit for the length of

Re: [PHP] More info on timeout problem

2007-11-05 Thread Jon Westcot
file instead; at least I seem to have some control over that file. I'm really starting to hate shared servers. Jon - Original Message - From: "Wolf" <[EMAIL PROTECTED]> To: "Jon Westcot" <[EMAIL PROTECTED]> Cc: "PHP General" Sent:

Re: [PHP] More info on timeout problem

2007-11-05 Thread Jon Westcot
Hi Instruct ICC: > > How do I save the individual query statements to a file? That may give > > me a good option for checking a "log" of activity when the process fails > > again. > > I'm assuming you are building an $sql variable, so you would write that to > a file instead of executing it in a q

Re: [PHP] More info on timeout problem

2007-11-05 Thread Jon Westcot
Hi Kristen: > I'm jumping in here late, so I haven't seen previous posts. Another > possible place I have seen limiting post/upload sizes: > > There is an Apache directive called LimitRequestSize or somesuch which will > take precedence (silently) over any PHP max post size you set. I found this

[PHP] More info on timeout problem, with code

2007-11-05 Thread Jon Westcot
Hi all: As requested, here's the code: Session.gc_maxlifetime: " . ini_get("session.gc_maxlifetime") . "\n"; // shows 1800 echo "Max execution time: " . ini_get("max_execution_time") . "\n"; // shows 1800 echo "Max input time: " . ini_get("max_input_time") . "\n"; // shows -1

Re: [PHP] More info on timeout problem, with code

2007-11-06 Thread Jon Westcot
Hi David, et al.: Thanks for the comment. I removed the trailing semi-colon in the two areas where it was being sent to mysql_query() and tried the code again. I'm still getting the same basic problem -- it silently aborts somewhere around 22,000 to 26,000 records being processed out of just

Re: [PHP] More info on timeout problem, with code

2007-11-06 Thread Jon Westcot
Hi Chris: > What indexes are on this table? On the import table, there is only one index. And I probably don't even need an index on it since it will be processed sequentially into other tables after it's been imported. > When you do an insert, each one has to update the index > as well as

[PHP] What to do when flush() doesn't?

2007-11-11 Thread Jon Westcot
Hi all: I am trying to get information from a rather long-running PHP script to send out messages to the client as things are being processed. In reading the manual, it seemed that using flush() was the ideal command for this. Well, it doesn't seem to be working for me. I've even tried s

[PHP] Problem retrieving $_POST values

2007-11-12 Thread Jon Westcot
Hi all: I'm having problems retrieving an array value that should be in a $_POST setting. In fact, I'm having trouble with the code hanging with no warnings or errors whatsoever, so I've got no clue why it's not working. Working code: if(isset($_POST["mls"])) { if(strlen(t

Re: [PHP] Problem retrieving $_POST values

2007-11-13 Thread Jon Westcot
Hi Chris: > Exactly as you have there. > > print_r($_POST); > > will show you everything. Here's a section of what comes back when I do this: [mls] => 1234567 [property_address] => Main St [city_arr] => Array ( [0] => CHNDHT [1] => CHNDLR

Re: [PHP] Problem retrieving $_POST values

2007-11-13 Thread Jon Westcot
Hi Chris, et al.: > > Here's a section of what comes back when I do this: > > > > [mls] => 1234567 > > [property_address] => Main St > > [city_arr] => Array > > ( > > [0] => CHNDHT > > [1] => CHNDLR > > [2] => GILBER > > [3] =

[PHP] Quick questions -- how do I place the cursor (i.e., set focus) to a field on page load?

2007-11-13 Thread Jon Westcot
Hi all: This may or may not be a PHP-related question, but, since I'm coding with PHP, I thought I'd ask: When a form loads, such as a login form, I'd like to have the cursor placed automatically in the Username field. Right now, it requires me to click it with the mouse or to tab int

Re: [PHP] Quick questions -- how do I place the cursor (i.e., set focus) to a field on page load?

2007-11-13 Thread Jon Westcot
Hi Mike: > you want javascript. > > i'd recommend using jquery (jquery.com) I'll look into this. Thanks. > put an id="username" on the username box. > > then do > > > $(document).ready(function() { >$("#username").focus(); > }); > > > voila Hmmm. It didn't work for me. Do I nee

Re: [PHP] Quick questions -- how do I place the cursor (i.e., set focus) to a field on page load?

2007-11-13 Thread Jon Westcot
Hi Mike, Chris, et al.: Thanks for the info. I'm not certain if I'll be needing jquery, or what benefits it might afford me with my meager little project, but I will check it out. In the meantime, Chris's snippet worked like a charm! Thanks! Jon -- PHP General Mailing List (http:

Re: [PHP] Quick questions -- how do I place the cursor (i.e., set focus) to a field on page load?

2007-11-13 Thread Jon Westcot
Hi Tedd: > > Also, while I'm asking questions, let me ask another one: I've > >seen several pages (frequently, pages that come up after a login > >page has been filled out) that provide some user mollification (you > >know, the typical "Please be patient, don't get your nylons in a > >knot, we

Re: [PHP] Newbie question - current date - time

2007-11-14 Thread Jon Westcot
Hi: > > Hi Folks, > > > > Newbie question : > > > > - how do I get and display the current date? > > - how do I get and display the current time? > > > > I see the getdate function - but I'm not sure if this is the right > > function > > or how to display it > > > > http://www.php.net/manual/e

[PHP] I need help handling form posting

2007-11-15 Thread Jon Westcot
Hi all: In my quest to make things seem easier for the user to understand, I'm trying to retrieve the time that I start posting a very large file via a form post. The form action sends it back to itself, which is fine. It took me some time to figure out that NOTHING happens on the client

[PHP] Looking for a navigation recommendation

2007-11-17 Thread Jon Westcot
Hi all: I'm working on a project wherein I need to be able to navigate to previous and next sections of data. I'm wondering what the best way to code for this would be. When I enter the page, I'd like it to use something in the MySQL SELECT such as "LIMIT 0,25", but the "0" portion ne

Re: [PHP] Looking for a navigation recommendation

2007-11-17 Thread Jon Westcot
Hi Tedd: > >Hi all: > > > > I'm working on a project wherein I need to be able to navigate > >to previous and next sections of data. I'm wondering what the best > >way to code for this would be. > > > > When I enter the page, I'd like it to use something in the MySQL > >SELECT such as "LI

Re: [PHP] Looking for a navigation recommendation (SOLVED)

2007-11-17 Thread Jon Westcot
Hi Tedd: > > YES! Exactly! Something like that would be very nice to have. > > > > MUCH appreciated! > > > > Jon > > Jon: > > Here it is: > > http://webbytedd.com/bbb/paging > > I'm assuming that you know how to establish communication with your > database; how to set up your dat

[PHP] Performance question for table updating

2007-11-23 Thread Jon Westcot
Hi all: For those who've been following the saga, I'm working on an application that needs to load a data file consisting of approximately 29,000 to 35,000 records in it (and not short ones, either) into several tables. I'm using MySQL as the database. I've noticed a really horrible p

Re: [PHP] Performance question for table updating (SOLVED)

2007-11-24 Thread Jon Westcot
Hi Rob, et al.: - Original Message - From: "Andrés Robinet" <[EMAIL PROTECTED]> > > -Original Message- > > From: Jon Westcot [mailto:[EMAIL PROTECTED] > > > > :: gigantic snip here:: > > > > So, long story short (oops -- to

[PHP] Quick question on data formatting

2007-11-28 Thread Jon Westcot
Hi all: Since I'm relatively new to PHP, I'm not familiar with all of the shortcuts and efficient ways one could write a routine that handles converting data from one format into another, so I thought I'd ask here for recommendations on how to solve one particular issue I've got. I'm viewi

Re: [PHP] Quick question on data formatting [SOLVED]

2007-11-28 Thread Jon Westcot
Thanks, Rob! I can see that it's going to be important for me to get familiar with the POSIX regular expressions. Jon - Original Message - > On Wed, 2007-11-28 at 22:19 -0700, Jon Westcot wrote: > > Hi all: > > > > Since I'm relatively new to PHP, I

[PHP] One more data formatting question

2007-11-29 Thread Jon Westcot
Hi all: I'm trying to parse out some HTML code back into "regular" string values and I keep getting tripped up by the non-breaking space value ( ). I see that html_decode_entities() can be used to convert this back to a viewable space, but the documentation tells me that the space value it

Re: [PHP] One more data formatting question [SOLVED]

2007-11-29 Thread Jon Westcot
Hi: Thanks for the answer! That worked exactly as I needed it to work! Jon - Original Message - From: "T.Lensselink" <[EMAIL PROTECTED]> To: "Jon Westcot" <[EMAIL PROTECTED]> Cc: "PHP General" Sent: Thursday, November 29, 200

[PHP] Newbie question: need to transfer directory contents from my local machine to my website

2006-01-03 Thread Jon Westcot
Hi all: I'm really new at PHP and will probably embarrass myself many times over asking questions that have been asked gazillions of times before, so let this serve as a blanket apology. Now, to my question. Here's what I'm trying to do. I have a simple database on my website that I

Re: [PHP] Comparing of string

2006-01-03 Thread Jon Westcot
Hi JanBro: Quick guess: are the strings the same length? I've been bitten many times by string comparisons that appear to be identical but which fail due to trailing spaces, other "invisible" (i.e., non-printing) characters, and the like. Hope this helps. Jon - Original Me

Re: [PHP] Newbie question: need to transfer directory contents fr om my local machine to my website

2006-01-05 Thread Jon Westcot
Jochem: My most sincere apologies for not replying to your questions. I've been suffering with a rather dibilitating head cold the last few days and somehow glossed over your questions. > 1. what is the local machine? Just my local workstation. > 2. where does the DB live? (is it a dif