RE: [PHP-DB] Abstraction layer or not?

Yeah, and what is a DB wrapper but a type of abstraction layer, right?? I'd prefer that people use one that's already developed and documented then trying to write their own. Of course, if you never share your code, then do what you want. ---John Holmes. -Original Message- From

Re: [PHP-DB] Abstraction layer or not?

True, but a DB wrapper can do the error reporting as well. John W. Holmes wrote: I'm working on a new site, and I'm wondering whether to use an abstraction layer or not. I don't have any plans to switch DB system, but you never know what the future holds. I figure that there's no reason not to

RE: [PHP-DB] Abstraction layer or not?

> I'm working on a new site, and I'm wondering whether to use an > abstraction layer or not. I don't have any plans to switch DB system, > but you never know what the future holds. I figure that there's no > reason not to, but are there any down sides? Which abstraction layers > are good? ADOdb

[PHP-DB] Re: Abstraction layer or not?

Hello, On 11/05/2002 11:21 PM, Leif K-Brooks wrote: I'm working on a new site, and I'm wondering whether to use an abstraction layer or not. I don't have any plans to switch DB system, but you never know what the future holds. I figure that there's no reason not to, but are there any down si

[PHP-DB] Abstraction layer or not?

I'm working on a new site, and I'm wondering whether to use an abstraction layer or not. I don't have any plans to switch DB system, but you never know what the future holds. I figure that there's no reason not to, but are there any down sides? Which abstraction layers are good? -- The abov

[PHP-DB] Date and time issues

> Subject: Re: [PHP-DB] Date and time issues > > If you are using MySQL, you may profitably investigate the function > DATE_ADD( date, INTERVAL ) > > Ignatius J. Reilly Thanks Ignatius! Fred. This did it: $interval="1 HOUR"; $subscr_text="1 sessie"; } else if ($subscr_type==3)

Re: [PHP-DB] uploading

Hello... ... ... ... $pat = array("#", "@", "*", "#", "@", "$","'", "`"); $w= '_'; $pic_name2 = str_replace ($pat, $w, stripslashes($pic_name)); $query = "INSERT INTO Travel_Design (Travel_Design_Num, Season, Date, name, filesize, filetype ) VALUES ( '$Travel_Design_Num', '$Season', '$Da

RE: [PHP-DB] uploading

I have been trying to get this to work as well, where I am lost is what is the upload.php file supposed to contain, other than the below lines that Edward was mentioning Just lost Thanks Ryan -Original Message- From: Edward Peloke [mailto:epeloke@;echoman.com] Sent: Tuesday, November 05,

RE: [PHP-DB] uploading

Thanks Jeff, I will give that a shot. I am developing on windows but the server that will host the site is linux. Eddie -Original Message- From: [EMAIL PROTECTED] [mailto:Jeffrey_N_Dyke@;Keane.com] Sent: Tuesday, November 05, 2002 3:32 PM To: Edward Peloke Cc: [EMAIL PROTECTED] Subject: R

Re: [PHP-DB] uploading

You're close, from what i can see just remove teh [ ] after the userfile or account for the fact that it is an array, but if you only have one file then you don't need it...and secondly, you're not calling your file anythign...you need to provide it a nameunless it defautls to the tmp_name

[PHP-DB] uploading

I am playing with uploading files. The names will then be stored in the db. I have a simple form: Send these files: Which calls a php file that just contains this: copy($_FILES['userfile']['tmp_name'], "\ufiles\"); This ufiles folder is under my htdocs folder in apache. I have look

Re: [PHP-DB] Re: persistant database connections

Richard Allsebrook wrote: There's a whole world of difference between 'rendered' and 'processed - the page is processed top to bottom (baring any branching in your php) - and generally rendered from top to bottom - some parts being rendered after as the missing components (images etc) are loaded

RE: [PHP-DB] need help with SHOW COLUMNS

I think you may want to loop over $row=mysql_fetch_array($result), each row should have the name of the field, and some additional info about it (I just ran a SHOW COLUMNS query on my log tables in my last post, that should give you an idea of what the output is), try executing the query in the mys

[PHP-DB] need help with SHOW COLUMNS

I am tryin to create a DBMS, the part of my code that is currently causing a problem is mysql_select_db("filterseveuk") or die(mysql_error()); $query = "SHOW COLUMNS FROM " .$table. ""; $result = mysql_query ( $query ) or die( mysql_error () ); $numrows = mysql_num_rows ($result); $r

Re: [PHP-DB] Idea as to why this query won't work as expected?

Dave Smith [mailto:DavidSmith@;byu.net] wrote: > > I can never remember whether SQL is left-to-right, right-to-left, or > some other deviant. Using parens is a sure way to guarantee that your > statements are processed in the order you desire. > > --Dave > It's easy if you remember: AND is equ

RE: [PHP-DB] Idea as to why this query won't work as expected?

Hi there, This worked perfectly for me! Thanks for the tip - I shall remember this :) To all who replied - thanks for your help as well. Regards, Aaron > -Original Message- > From: Ignatius Reilly [mailto:ignatius.reilly@;free.fr] > Sent: Tuesday, November 05, 2002 9:15 AM > To: [E

RE: [PHP-DB] Idea as to why this query won't work as expected?

The or part should be in parens. Your bascialy saying grab everything that has order_status='Shipped' and your date requirements, OR everything where order_status is equal to 'Not Shipped'... -- Josh -Original Message- From: Aaron Wolski [mailto:aaronjw@;martekbiz.com] Sent: Tuesday, Nov

Re: [PHP-DB] Idea as to why this query won't work as expected?

Try grouping your WHERE clauses with parentheses like so: select * FROM OrderTable WHERE ( submitted=1 AND dateinserted>='1036386000' AND dateinserted<='1036502796' AND order_status='Shipped' ) OR order_status='Not Shipped' I can never remember whether SQL is left-to-right, right-to-left, or som

Re: [PHP-DB] Idea as to why this query won't work as expected?

AND/ OR precedence mistake. Your query will return all the rows for which order_status='Not Shipped' Probably what you want is: select * FROM OrderTable WHERE submitted=1 AND dateinserted>='1036386000' AND dateinserted<='1036502796' AND ( order_status='Shipped' OR order_status='Not Shipped' ) H

[PHP-DB] Idea as to why this query won't work as expected?

Hi All, I have a query like: select * FROM OrderTable WHERE submitted=1 AND dateinserted>='1036386000' AND dateinserted<='1036502796' AND order_status='Shipped' OR order_status='Not Shipped' Now.. if I omit the "AND order_status='Shipped' OR order_status='Not Shipped'" part the query works

[PHP-DB] Query Help

I've implemented the scheme I briefly outlined in my last post (locking for data integrity), and now I'm writing queries to get totals from my logs, and I think I might be over-complicating things, and I'd like some alternative views on the subject. My "grandiose scheme" works like this: Problem:

[PHP-DB] Re: persistant database connections

There's a whole world of difference between 'rendered' and 'processed - the page is processed top to bottom (baring any branching in your php) - and generally rendered from top to bottom - some parts being rendered after as the missing components (images etc) are loaded. - in short - yes you can

Re: [PHP-DB] OCIBindByName with Oracle 8i17 problem ?!

Thies C. Arntzen wrote: On Mon, Nov 04, 2002 at 06:16:04PM +0100, Fabien JOSEPH wrote: I discovered recently that it was impossible to bind an output placeholder plsql (an input work only). Configuration 1 : Suse + Oracle 8i17 + oci (oracle) + PHP4.2.3 Configuration 2 : HPUX11 + Oracle 8i17 +

[PHP-DB] Pausing a script

Instead of exiting the following script after "Use your Browser Back Button to choose another" I would like to simply pause it until some clicks a link to allow them to upload the file even if it already on the server. I have been playing about with "break" but I can't seem to get that to do what I