Re: [PHP-DB] can i create an Access table or mdb with PHP?
Building on John idea with a few of my own (from a real word system I've developed...) Creating a blank MDB from scratch is particularly painful - so, like John said - start with a ready made template. Next make a copy with a unique name (there are loads of ways of doing this, timestamps, uniqid()...) and populate the copy. Send the copy to your user You will end up with copies littering your site, so at the start of the population phase, run some 'tidy up code' which deletes any old databases (older than a day say). Hope this helps. -- Richard Allsebrook Applications and Web Development Anthony [EMAIL PROTECTED] wrote in message news:3DD2A538.8090502;attechcomputer.com... You could use ODBC to do it. Create a template access DB, poulate it with ODBC, then read the file and send it to the user. After it's downloaded clear the table. the downside to this is that you would only be able to haev one user ata time get an access database. I'm sure there are better ideas, but this would work. - Anthony John A Davis wrote: I'm trying to supply our Contract Counties with mailing labels, already formatted. They log on to our website and PHP will hit our SQL Server and return a list of Public Water Systems for the County chosen. I would like a link on this page that says something like Send me an Access .mdb with mailing labels for these systems. PHP would delete whatever is in stock Access .mdb table somewhere on our system and replace the rows with newer, current ones, specific to the County chosen(same query that displays the systems in HTML). The Access .mdb that gets downloaded will have a report formatted for Avery 5160 labels, bound to the newer table that was filled. All they have to do is adjust their printer settings. Does anyone have an easier way of supplying data formatted for mailing labels? If they do, I'm all ears(eyes). Since this is a bonus service, we don't want to have to have people involved providing this stuff to our counties. tia John Davis IIS State of Oregon Drinking Water Program [EMAIL PROTECTED] 11/12/02 09:12PM On Tue, 12 Nov 2002, John A DAVIS wrote: Want to give the user the ability to download a dynamic Access.mdb file that has a table and linked report formatted for Avery 5160 labels. Know how to create all this stuff in VBA code, but not using PHP. It is better to give too much information than not enough. You are trying to generate a dynamic Access.mdb file on the fly, using PHP? Or you are trying to deliver this already existing file that changes sometimes with PHP? Or you are trying to do something else? If the first option, where is your data coming from? If the second, why are you trying to use PHP instead of just linking to the Access.mdb file via the web server? Peter -- - Peter BeckmanSystems Engineer, Fairfax Cable Access Corporation [EMAIL PROTECTED] http://www.purplecow.com/ -- - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[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 - so long as the pconnect happens before you select in the program 'flow' :) Bob Lockie [EMAIL PROTECTED] wrote in message news:3DC7039E.1060309;lockie.ca... I'm using mysql_pconnect(...) at the beginning of a PHP page. Can I safely use mysql_select_db(...) later on the page? I thought I read somewhere that you can't rely on HTML to be rendered from top to bottom. Can I rely on PHP to be interpreted from top to bottom? From Mozilla and GNU/Linux -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Re:Re: [PHP-DB] Print data
This isn't a PHP problem - its you browser. ie has an option in its print dialog (option tab) to print framed sites out properly - don't know how the other browsers manage it... [EMAIL PROTECTED] wrote in message news:E184aOC-0002vK-00;mail.idilis.net... hy, i'm having a problem with printing the data from a html or php page... how can i solve this problem ? I mean when i'm using frames they appear or like a view with scrollbar or there is an option to print them singulary. I want to print in a format that i want..like a report ... thanks From: 1LT John W. Holmes [EMAIL PROTECTED] Date: 2002/10/23 Wed PM 02:20:35 GMT+03:00 To: José Moreira [EMAIL PROTECTED], Php Windows [EMAIL PROTECTED], Php-Db [EMAIL PROTECTED] Subject: Re: [PHP-DB] Print data hello, at my company we have several network printers and i was was wondering if it's possible to print directly to them using PHP, instead of showing on the screen or both ... to gain more control on what is printed, because of the nasty browsers header and footer ... whom i now how to remove ... i know that the printer IP is 192.192.1.100 and the port is 9005 ... The printer functions in the manual only work in windows and only work for the printer attached directly to the server. Hmm..I wonder, though, if you have a network printer that's set up to print from the server, can you use the printer functions to print to that? I'm sure the answer is in the manual. If not, maybe you can open a connection directly to the printer and send it the raw data, if you know the format. ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php Free Email Account at www.flash.ro -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: PHP and databases? ...without MySQL and such
You can use the Microsoft ODBC Text driver to access flat files and perform SQL Queries on it - can be REALLY slow on big files though (no indexes) :( Alternatively - write a script that pulls the flat file into a proper database table :) Hope this helps -- Richard Allsebrook Applications and Web Development John Negretti [EMAIL PROTECTED] wrote in message news:47D4D382C169C84AADDC68C0600917992FDD1A;CSAN0MS01.corp.cox.com... Hello All, I am somewhat new to PHP and I have a question relating to FLAT FILE databases. First let me give an introduction to my question. I used to work at a company (www.miva.com) where we developed our own scripting language Miva Script, so my only experience with PHP was for comparison and such. The company was not doing so good and was barley afloat, so I left. In my efforts to find a new scripting language I choose PHP over ColdFusion, even though Miva Script was so similar to ColdFusion. I am loving PHP, I never realized just how extensive PHP is. Now I am at a big company where red tape has to be dealt with before I could get access to a database server. With the Miva Script language it has it's own built-in database (dBASE-DBF), so databases were never a problem with web development. So, I am stuck with either using PHP and finding a solution or reverting to Miva Script, which I do NOT want to do, of course I want to stay with PHP. I have been doing some research on google.com and such and have not found too much information on PHP with Flat File or DBF databases. I did find some PHP scripts working with Flat File databases, but not really what I need. Does anyone have any suggestions, or is PHP mostly just for MySQL and such. I am developing some PHP classes/functions that are utilizing file() and array() to read and edit my flat files. It's not perfected yet and I am running into difficulties here and there and this is why am I asking for any opinions or comments on available resources. When I get done with it I'll post it for free at www.ideablue.com (my personal site). Well, I do give thanks in advance for any help. NOTE: I think PHP is a great language and I do hope to stick with it. There are many great resources like www.phpbuilder.com, www.phpbeginner.com and the extensive documentation at www.php.net. Thanks to all that help us new PHP developers. John Negretti Web Applications Developer Cox Communications www.cox.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php