So all you need to do, is read the file in, line by line (see the php manual) and then break up each line into an array to be added to the db.
This is fairly basic stuff, you just need to look in the php manual, it sounds like you don't really have a problem as such, you just want someone to tell you what the code would be? chris kranz fatcuban.com -----Original Message----- From: George Pitcher [mailto:[EMAIL PROTECTED]] Sent: 11 February 2003 11:59 To: Svensson, B.A.T. (HKG); [EMAIL PROTECTED] Subject: RE: [PHP-WIN] reading lines from a file Yes, I suppose I do. I want to be able to take my file, work out a complete of fieldnames and then create an array which could then be used to, initially, create a table in MySQL. I'm not using MySQL for my main system which is based on FileMaker, but will be moving later this year to MySQL, so it's not a wasted effort. I know that I can export the MySQL data and push that into FileMaker. Below (in between ==== lines, is a sample record for parsing. This may help you understand the problem I have. ======================================================= NEWRC -T&F eBook data rec.1534 |@ 27/01/2003 VISBN 0203445570 OSBN 0-203-44557-0 EBK1 0203548310 EBK2 0203651057 EBK3 020375381X EBK4 0203273567 OTOP OTART OTI Creative Mathematics OSUB USAU Upitis |f Rena |u Queens University |c Kingston, Ontario |x Canada USAU Phillips |f Eileen |u Teacher |c Vancover |x Canada USAU Higginson |f William |u Queens University |c Kingston |x Canada EDIT INTRO FORWD Pimm |f David |u The Open University x| UK TRANS 2BIND 0415164621 |P 70.00 |U 100.00 |B Hb |A |M 1 |T Creative Mathematics VPR 11.99 USPRI 17.99 OTBPR 19.99 |U 25.95 |D 17/07/1997 USBDG MFDT ERT GB US CA AU NZ ZA IE ORT NRT TTY OBIND eB PDUE 11/03/2002 VIZE VEXT 192 OILLS 40 illustrations LEVEL OSER OIMP RoutledgeFalmer LIBPR OALT OPPQ OCATL This book shows how creative maths can <I>really</I> work. Exploring the ways in which maths skills can be learned through cross-curricular activities based on visual arts and music, the book presents maths as a meaningful and exciting subject which holds no fears for children.<BR> The authors recognise that while maths-phobia prevails in our increasingly mathematicised world, attitudes and approaches to teaching the subject need to be reviewed, and issues such as gender stereotyping, which encourage maths-apathy, need to be tackled at an early stage.<BR> Within this collection of classroom-based stories are detailed examples of integrative mathematic projects; these will give teachers the confidence to try out cross-curricular activities in their classes. The book also provides support with difficult areas such as assessment, planning and development.<BR> Fascinating to read in its own right this book will appeal to the specialist and non-specialist alike.<BR> OCONC This book shows how creative maths can <I>really</I> work. Exploring the ways in which maths skills can be learned through cross-curricular activities based on visual arts and music, the book presents maths as a meaningful and exciting subject which holds no fears for children.<BR> The authors recognise that while maths-phobia prevails in our increasingly mathematicised world, attitudes and approaches to teaching the subject need to be reviewed, and issues such as gender stereotyping, which encourage maths-apathy, need to be tackled at an early stage.<BR> Within this collection of classroom-based stories are detailed examples of integrative mathematic projects; these will give teachers the confidence to try out cross-curricular activities in their classes. The book also provides support with difficult areas such as assessment, planning and development.<BR> Fascinating to read in its own right this book will appeal to the specialist and non-specialist alike.<BR> OCATS Exploring the ways in which maths skills can be learned through cross-curricular projects on arts and music, this book presents maths as a meaningful and exciting subject which holds no fear for children. OQUO 'This is a fascinating book ... which gives detailed case studies.' |I Infant Equipment OCNT FCONT OWRIT VEDIT 1 BICAC U BSUB1 J BSUB2 JD BSUB3 BICAV RF SUBJ1 SB150000 SUBJ2 SUBJ3 VPROD EB VACDE WEB CREAT MFK - AUTO |D 2002 07 19 ================================================================ the use of '|' denotes a subfield. My plan is to name the subfield by the name of the field followed by '_' and the subfield identifier, so that the one on the last line would appear as 'CREAT_D, and that way I'll be sure to properly tag those that are belonging to the 'counter-affected' fields. All help is appreciated. Cheers George > -----Original Message----- > From: Svensson, B.A.T. (HKG) [mailto:[EMAIL PROTECTED]] > Sent: 11 February 2003 11:03 am > To: George Pitcher; [EMAIL PROTECTED] > Subject: RE: [PHP-WIN] reading lines from a file > > > Then you need to write a parser. What's the basic problem then? > > > -----Original Message----- > > From: George Pitcher [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, February 11, 2003 11:59 AM > > To: Svensson, B.A.T. (HKG); [EMAIL PROTECTED] > > Subject: RE: [PHP-WIN] reading lines from a file > > > > > > Yes, eventually. I want to come up with a good method because > this file is > > going to be supplied to me on a fairly regular basis. > > > > George > > > > > -----Original Message----- > > > From: Svensson, B.A.T. (HKG) [mailto:[EMAIL PROTECTED]] > > > Sent: 11 February 2003 10:56 am > > > To: George Pitcher; [EMAIL PROTECTED] > > > Subject: RE: [PHP-WIN] reading lines from a file > > > > > > > > > What do you want to do? Parse the file into tab-delimited data > > > in order to bulk load it into the database? > > > > > > > -----Original Message----- > > > > From: George Pitcher [mailto:[EMAIL PROTECTED]] > > > > Sent: Tuesday, February 11, 2003 11:41 AM > > > > To: [EMAIL PROTECTED] > > > > Subject: [PHP-WIN] reading lines from a file > > > > > > > > > > > > Hi, > > > > > > > > I have a huge file that I want to get into a db format. > > > > > > > > There are over 5000 records and I need to create fieldnames > on the fly. > > > > > > > > Each record comprises a number of lines (fields) containing > 2 elements > > > > (fieldname [first 5 chars (which need rtrimming)], value [rest > > > of line, some > > > > with lots of text]). > > > > > > > > Some fieldnames are duplicated within a record so I need to > > > rename these by > > > > using a counter which is reset for each record (there are at least 5 > > > > fieldnames that are affected this way - so 5 counters). > > > > > > > > Some values contain subfields so I need to be able to handle > > > these, but this > > > > doesn't look frightening. > > > > > > > > And I would like to end up with an array with keys (fieldnames) > > > and values. > > > > > > > > But I'm stuck at the first hurdle because I can't find out how > > > to put a line > > > > into a string. > > > > > > > > Any pointers? > > > > > > > > George in Oxford > > > > > > > > > > > > === > > > > > > > > George Pitcher > > > > HERON Technical Manager > > > > Ingenta plc > > > > 23-38 Hythe Bridge Street, Oxford, OX1 2ET > > > > T +44 (0)1865 799137 direct > > > > T +44 (0)1865 799000 switchboard > > > > F +44 (0)1865 799134 > > > > E [EMAIL PROTECTED] > > > > > > > > www.ingenta.com > > > > Ingenta: Empowering the exchange of academic and > professional content > > > > online. > > > > > > > > > > > > -- > > > > PHP Windows Mailing List (http://www.php.net/) > > > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > > > > -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
