[PHP] Generating Static files

2002-03-19 Thread Tony Crockford
Hi what's the best way to generate static files using PHP/MySQL? I've read a couple of tutorials and got a bit lost. What I'd like to do is use PHP to generate static pages in the way that GDIdb pro does (run a script/template combination, output html files all linked up) this is where I'm

RE: [PHP] which php book 2 buy ?

2002-03-26 Thread Tony Crockford
I wanna buy a book from amazon . . .but don't know which one.. Do you know where I will find examples of shopping carts ? (which book ?) MySQL/PHP Database applications by Greenspan and Bulger ISBN 0764535374 Good book. Also has a 40 page chapter on how to build a shopping cart complete

RE: [PHP] which php book 2 buy ?

2002-03-26 Thread Tony Crockford
I thought this would have been a great book if it weren't for the numerous errors in the code sections. I highly recommend it if you know PHP well enough to bang out a few forms and if you know MySQL well enough to write some INSERT and SELECT statements -- if this is the case then you will

[PHP] FW: Generating Static files

2002-04-01 Thread Tony Crockford
Hi what's the best way to generate static files using PHP/MySQL? I've read a couple of tutorials and got a bit lost. What I'd like to do is use PHP to generate static pages in the way that GDIdb pro does (run a script/template combination, output html files all linked up) this is where I'm

[PHP] Is this possible?

2003-07-23 Thread Tony Crockford
Hi Thanks for the help on previous questions, I now have an in principle type question. I have a MySQL database - items in one table and descriptions in another with a common key: item_ref It is used to create a sort of categorised directory of the items. (http://www.torbytes.co.uk) each

RE: [PHP] Is this possible?

2003-07-23 Thread Tony Crockford
Umm, you mean like: select i.id,d.description from items i, descriptions d where d.itemid = i.id; ? Of course I do! How stupid am I? No, don't answer that - it's been a long week working on the wrong stuff! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit:

[PHP] PHP/MySQL best practice tutorial

2003-07-29 Thread Tony Crockford
I have a mySQL database containing items that are categorised four levels deep. when I'm getting the data out (in a tree structure) I'm nesting SQL queries inside array traversing loops (select distinct category, while $row= echo stuff select distinct subcat, while $row= echo stuff etc) I'm sure

RE: [PHP] Re: Using register_globals

2003-06-05 Thread Tony Crockford
On this topic, could anyone point me to a good tutorial on how to convert from sloppy code that assumes register_globals is on to good, secure code that assumes register_globals is off. something that covers what to look for and what to change it to would be a great help. I've been learning by

[PHP] condensing a list from MySQL

2003-06-09 Thread Tony Crockford
Hi all, not sure where to start with this. I have a keywords field in a mysql database - allows up to 100 characters of words seperated by spaces. at a late stage in the development process the client would now like a summary list of keywords that they've entered. I guess what I need to do is

[PHP] Newbie lost in array

2003-07-22 Thread Tony Crockford
I've got brain fade today and am in need of a clue, please accept apologies if this is obvious. I have a data table: P_ref P_code P_Value I want to read the data out where P_ref='somevalue' and create variables for the content of P_Code with a value of P_Value what should I be looking for in

RE: [PHP] Re: Newbie lost in array

2003-07-22 Thread Tony Crockford
hi tony, how is your table structured? is is a csv-file, a database, a html-table, ...? ciao SVEN Ooops! MySQL sorry -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] changing the name of a variable by another variable.

2003-07-22 Thread Tony Crockford
I really am having a difficult day. I want to do an incrementing while loop that will echo out the values of $variable1 , $variable2, $variable3 which exist previously. so how do I get the incrementing number onto the word variable? to make a new variable that matches thename of the existing

RE: [PHP] File handling

2003-02-13 Thread Tony Crockford
How do i delete all file in a directory??? You could use a function like this: (html code at end) function delFiles($filter, $sDir) { $cDirectory = includeTrailingSlash($sDir); $handle = opendir($cDirectory); while ($file = readdir($handle)) { if ($file == '.' ||

[PHP] File manipulation tutorials / helpful resources

2003-03-24 Thread Tony Crockford
Hi What I'd like to do is open an html file, strip out the content between the body/body tags so that I can insert it into my own template. Has anyone got any good resources or tutorials I could read to help me accomplish this simple sounding task. I have no idea where to start! ;o) Thanks

[PHP] document_root

2002-10-01 Thread Tony Crockford
Hi what exactly does document_root do? Does it give to path to the file from the server root? or does it give the path to the server root? has something changed in 4.2.2 If I want the path to the document I'm in how do I get it? looked everywhere (manual, books and archive), but the answer

RE: [PHP] document_root

2002-10-01 Thread Tony Crockford
Check out: http://www.php.net/manual/en/function.getcwd.php HTH -Brad Certainly does, thanks. I suppose if I'd thought to look at the manual contents rather than trying to construct a *search* I might have found that Oh well, so much to learn so little time. Thanks Tony -- PHP

RE: [PHP] formatting / beautifying PHP code

2002-10-07 Thread Tony Crockford
Is there a utility that formats / beautifies PHP code like indent does for C code? something like this? http://tools.phpedit.net/phpCodeBeautifier/ HTH Tony -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Script optimisation

2002-10-16 Thread Tony Crockford
Hi, I'm sure this is an RTFM, but I'm not sure where I should be looking. is it quicker for PHP to execute ? echo $var ? in blocks of html or to echo all of the html and only have one ? and ? I'm using a PHP script to write a lot of html files to hard disk and the script execution time is

RE: [PHP] Re: Script optimisation

2002-10-16 Thread Tony Crockford
As I said at the start, it very much depends on what is required for a particular script... Here's an area I'm struggling with: (it's a breadcrumb trail building a href from variables according to which page I'm creating): ?php //index echo a href=\, $urltoitem, /tm, $cat1_ref, /lv,

RE: [PHP] Error?

2002-10-27 Thread Tony Crockford
if($new) { $details = get_product_details($new); if($details[catid]) $target = show_cat.php?catid=.$details[catid]; //line 55 is the bracket below. } $path = $PHP_SELF; $path = str_replace(show_cart.php, , $path); Error: Warning: Can only count STRING and

[PHP] Logic headache, please help.

2002-11-11 Thread Tony Crockford
Hi all, brief explanation: I'm building a select list, to exclude certain directories from a search (with Ht://dig). The structure is like this: select name=exclude option value=All levels/option option value=/lv2/|/lv3/|/lv4/Level 1/option option value=/lv1/|/lv3/|/lv4/Level 2/option option

RE: [PHP] Logic headache, please help.

2002-11-11 Thread Tony Crockford
-Original Message- From: Marco Tabini [mailto:marcot;tabini.ca] Sent: 11 November 2002 14:46 To: Tony Crockford Cc: Php-GeneralLists. Php. Net Subject: Re: [PHP] Logic headache, please help. How about building an array of all the levels: $a = array(); for ($i = 1; $i

RE: [PHP] PHP Trouble-Ticket-Systems?

2002-12-01 Thread Tony Crockford
So the question is, does anyone know any good troubleticket/helpdesk-systems written in PHP? Thanks, Thomas This would seem to fit the bill: (I've used it and can recommend it) http://helpdesk.oneorzero.com/ HTH Tony -- PHP General Mailing List (http://www.php.net/) To

[PHP] Locking mysql tables with PHP

2003-11-25 Thread Tony Crockford
Hi bit confused! here's what I want to do: get a numeric value from a MySQL table, do a calculation, then on another PHPpage update the numeric value in the table. what I don't want is anyone else getting the same number from the table before I've updated it. what PHP would you use to do

Re: [PHP] Locking mysql tables with PHP

2003-11-25 Thread Tony Crockford
On Tue, 25 Nov 2003 13:50:36 +0100, Marek Kilimajer [EMAIL PROTECTED] wrote: Tony Crockford wrote: get a numeric value from a MySQL table, do a calculation, then on another PHPpage update the numeric value in the table. what I don't want is anyone else getting the same number from the table

Re: [PHP] Locking mysql tables with PHP

2003-11-25 Thread Tony Crockford
On Tue, 25 Nov 2003 07:15:10 -0600, Jay Blanchard [EMAIL PROTECTED] wrote: [snip] is there a way I can get a number and increment it all in one query then? [/snip] UPDATE tblFoo SET value = (value+1) WHERE conditions Hmm.. my bad - I get that bit, but can I do: SELECT value WHERE conditions

Re: [PHP] Locking mysql tables with PHP

2003-11-25 Thread Tony Crockford
On Tue, 25 Nov 2003 07:47:58 -0600, Jay Blanchard [EMAIL PROTECTED] wrote: [snip] [snip] is there a way I can get a number and increment it all in one query then? [/snip] UPDATE tblFoo SET value = (value+1) WHERE conditions Hmm.. my bad - I get that bit, but can I do: SELECT value WHERE

[PHP] Losing Sessions.

2003-12-04 Thread Tony Crockford
I hope someone can help. I have a simple login process that someone wrote for me. It uses two stored variables which it checks on each new page, if it can't get them it assumes you should login first and sends you to a login page. Everything was okay. I used the same script on a different

Re: [PHP] session / garbage collection problem

2003-12-19 Thread Tony Crockford
On Fri, 19 Dec 2003 13:37:06 -0800, Anthony Kaufman wrote: PHP Version 4.2.2 Apache 2 RH 9 The problem is that session files in the /tmp directory are completely cleared out at random intervals of time. We assume that the randomness is due to our session.gc_probability setting of 1 causing it