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! I've been very impressed with how helpful the digital point community is.
For inputting and editing I suggest you make a simple form yourself. Do not get caught up in complicated code if you are a newbie. You can make a very simple form that populates itself with the poem you want to edit, then you can enter a username and/or password before saving it. This would require only a simple query to collect the data (which then...) populate(s) a form text area with the data (above) username and/or password fields username and/or password check simple query to save the edited content back to the database Also there are many great wysiwyg editors that work directly with PHP if you wish to save things as HTML rather than plain text in the database. Install google toolbar and turn spell checking in forms on as well.