monsho Posted January 18, 2008 Share Posted January 18, 2008 Hi All, Apologies in advance for my very limited knowledge We're creating a Live AV Installation which is going to run on a local network, using a webserver and MySQL, basically there will be a lot of text entries into a database from lots of users over the network. What we're aiming to do is take each of these text entries and create a folder of .txt files of each one, which we can then take and manipulate in our visual programmes. I have managed to produce the initial part and have text uploading into the database no problem, but can't figure out how each entry could be automatically exported to a .txt file on the webserver somewhere... If anyone would direct me in the right way I'd be really grateful php version 4.4.7 is used and I think it is MySQL 4.1.22 on the webserver I am testing this all on (will be building a local webserver if I need an updated version for anything) Many thanks in advance Andrew Quote Link to comment https://forums.phpfreaks.com/topic/86669-write-mysql-entries-to-txt-files/ Share on other sites More sharing options...
fenway Posted January 18, 2008 Share Posted January 18, 2008 I don't understand. Quote Link to comment https://forums.phpfreaks.com/topic/86669-write-mysql-entries-to-txt-files/#findComment-442994 Share on other sites More sharing options...
monsho Posted January 18, 2008 Author Share Posted January 18, 2008 ok sorry, let me try and explain the process better.... this installation will be set up in a gallery, with a group of people as an audience. There will be a load of computers set up in the room that are connected to the local network. People will be able to enter text into a browser, basically responding to initial prompts, and these passages of text are then sent to the MySQL database to store them. From this we then need to take these passages of text and manipulate them live (the end results will be projected as part of an audio visual show), and what we need is to take the text and have them exported as .txt files (which are then pulled into Apple Quartz Composer). basically, what we want is that each text entry is exported straight away from MySQL as a txt file into a folder (on the local server) that we can then pull out. The process that we don't know how to do is exporting the text entries from the DB as text files.... hope this helps? many thanks Quote Link to comment https://forums.phpfreaks.com/topic/86669-write-mysql-entries-to-txt-files/#findComment-443004 Share on other sites More sharing options...
fenway Posted January 18, 2008 Share Posted January 18, 2008 Well, you can SELECT INTO OUTFILE... Quote Link to comment https://forums.phpfreaks.com/topic/86669-write-mysql-entries-to-txt-files/#findComment-443019 Share on other sites More sharing options...
monsho Posted January 19, 2008 Author Share Posted January 19, 2008 thanks for this, am researching and trying to work it out ta Quote Link to comment https://forums.phpfreaks.com/topic/86669-write-mysql-entries-to-txt-files/#findComment-443402 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.