Hello everybody! First time I've posted in the Database forum.
Here is my situation: I have designed and am in the process of creating a mid-sized website that will serve up a database of poems. (Eventually it will become fairly large) I've seen sites that do what I'm trying to do, but I'm planning on doing it much better than I've seen it done before.
I have created a MySql database and created the necessary tables which include an author, poem, and collection table. I also learned the basics of PHP and will be using that do connect to the database and work with the data.
My question(s):How do I import, manage and edit the poems in my database most efficiently?
I tried using the sql command LOAD DATA INFILE, and that works very well for most information but the poems table, because the field that contains the actual poem (a TEXT datatype) takes a long time to turn into a string and edit it onto one long, long line. It would also be a super big pain to edit (say if there was a typo) And to do this for say, 1000 poems would be awful. It would be so much easier to copy and past into .html files... (which I don't want to do, as I want to build a dynamic site)
So with the previous information in mind,
Is there any good software that other sites use to easily connect to their database and input and edit large amounts of text? Or do I have to program a admin-access-only php pages that will do that stuff?
Sorry the question is kinda long... hope I didn't scare anyone off! Thanks for your help in advance!