RE: [PHP-DB] Re: Making a txt file from db data, is it possible?

a little lateral thinking......... there are a number of email to fax services out there (www.j2.com is one). Last time I looked it was as cheap to use as a normal fax, and it saves much hassle. just email the order to their servers and it gets faxed. Might be worth a look Peter ----------------------------------------------- Excellence in internet and open source software ----------------------------------------------- Sunmaia www.sunmaia.net info@sunmaia.net tel. 0121-242-1473 ----------------------------------------------- > -----Original Message----- > From: Frank Flynn [mailto:frank@declan.com] > Sent: 08 April 2002 18:59 > To: Rick Emery; 'Raymond'; php-db@lists.php.net > Subject: Re: [PHP-DB] Re: Making a txt file from db data, is it > possible? > > > Yes, I'd say this is the way to go. As the customer submits the order > simply write out the file as you'd like it. It doesn't take > long and you > have all the data in the cart (I'm not sure how you're dealing with the > cart - saving it in the DB, cookies, session variables - but it doesn't > really matter). > > Otherwise you could save this in the DB and have a demon type thing > continuously poll the DB for orders not yet sent - but that's more of a > pain and more likely to break as the demon fails but customers don't > notice and think their orders are being processed. > > Even so you'd still have to write it the same way. The export or dump > features will only give you the rows of data in a tab delimited > format not a > formatted document as you probably want. > > Good Luck, > Frank > > On 4/8/02 10:40 AM, "Rick Emery" <remery@excel.com> wrote: > > > fopen() > > fwrite() > > fclose() > > > > -----Original Message----- > > From: Raymond [mailto:raymol@online.no] > > Sent: Monday, April 08, 2002 12:05 PM > > To: Frank Flynn; php-db@lists.php.net > > Subject: [PHP-DB] Re: Making a txt file from db data, is it possible? > > > > > > Hi! > > > > Ok, I think I maybe have to explain this a little better : ) > > > > I have this website that have a webshop that is driven by mysql and php. > > This is working fine, but when a customer puts something into > his cart and > > he is sending his order, I would like to send this order by fax > to the store > > nearest the customer. > > > > And I have this faxprogram that scan a directory for files and > send them as > > a fax. So I was thinking .... I'm not sure if it is possible, > but if it is > > possible to write all products in the customers cart into a > txtfile. Iwould > > make to send fax, or? > > > > Thankfull for all advices or help : ) > > > > Best regards Raymond > > ----- Original Message ----- > > From: "Frank Flynn" <frank@declan.com> > > To: <php-db@lists.php.net> > > Cc: <raymol@online.no> > > Sent: Sunday, April 07, 2002 6:02 AM > > Subject: Re: Making a txt file from db data, is it possible? > > > > > >> On 4/6/02 4:12 PM, "php-db-digest-help@lists.php.net" > >> <php-db-digest-help@lists.php.net> wrote: > >> > >>> From: "Raymond Lilleodegard" <raymol@online.no> > >>> Date: Sat, 6 Apr 2002 17:18:07 +0200 > >>> To: php-db@lists.php.net > >>> Subject: Re: Making a txt file from db data, is it possible? > >>> > >>> May I use this dump method with a query too? Or is this only > for making > > a > >>> hole table into a txt file? > >> > >> By the time I caught this thread there was no mention of the DBMS you > > were > >> using and they are different. Still one trick that usually works is to > >> create a view with the query you want and to dump that view. > >> > >>> Because I'm trying to get a website into a txt file and save it into a > >>> directory on the server to get a order sendt by fax. Or is > this a "long > > way" > >>> to go? > >> > >> Sounds like the long way to me. But like I said I just saw this am I'm > > not > >> sure what you're trying to do. I'd be happy to comment further if you > > like > >> just send more details of what you're trying to do. > >> > >> Good Luck, > >> Frank > >> > >>> Regards Raymond > >>> > >> > >> > > > > > -- > Frank Flynn > Poet, Artist & Mystic > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php >