Book assembly script

I am creating a book made up of interspersed blocks of original text and quotations and want two scripts to help.

First, the quotes are already in a MySQL database.

Table quotes:

QID, AID, author, text, comments, source

There are also several fields that won't be involved here. QID is the key for the quotes table. AID is the key to the author table, but for simplicity we will ignore that relation for this project as there is nothing in that table that I really need. I may or may not choose to use the source field but will want it displayed during editing in the first script.

A chapter in the book will consist of a title and a set of text entries and quotations. I want the first script to allow me to choose one chapter and scroll through the existing pieces. At any point in the chapter (top, bottom, or between existing elements) I want to be able to either search the database for an additional quote to insert or insert a text block. I need to be able to move elements up or down (doesn't have to be fancy, maybe just a plus and minus button to move it up one slot). Editing doesn't need to be anything more than my browser's ability to edit a textfield.

The second script will need to step through the elements created by the first script and output the content, and it will need to do this two times. In each pass it will write some code to a file, write some code, write the chapter title, some code, then write the individual blocks, and end with the chapter-ending code. Each text object will be bracketed by consistent code. Each quotation will be code, [login to view URL], code, [login to view URL], code, [login to view URL], code.

The first time the second script steps through the book the codes will be those appropriate for InDesign for a print book. In the case of a text block it will be very simple, declare a new paragraph, output the text, declare the end of a paragraph. If it's a quote it will be more comlex: declare the new paragraph, output the text, insert the codes for a line break and an indent, output the author, if comments is not empty, output a comma and a space, insert code, output the comments, and then declare the end of hte paragraph.

The second time through it will do the exact same things but the codes will be appropriate for creating a text file to become an eBook.

The winning freelancer does not need to worry about what the codes are, just to create the mechanism for writing them to the file. I haven't designed the final output, for purposes of illustration let's assume that it's going to be HTML. For example, here's a quote that might be used:

QID: 5576

AID: 1823

author: Edith Wharton

text: I was never allowed to read the popular American children's books of my day because, as my mother said, the children spoke bad English without the author's knowing it.

comments: 1862 - 1937

source: <em>A Backward Glance</em> (1934)

This is what might be output:

<p class quotes><span class text>

I was never allowed to read the popular American children's books of my day because, as my mother said, the children spoke bad English without the author's knowing it.

</span><br /><span class credits><em>

Edith Wharton




Квалификация: MySQL, PHP

Показать больше assembly script books, writing in script, writing children's books, writing book help, writing block, writing a children's book, write me my book, write ebook freelancer, winning quote, what to do to become a freelancer, what is the illustration of a book, what is an illustration in a book, what is a illustration of a book, what i need to write a book, what do i need to write a book, what does freelancer do, want help in writing my ebook, use credits freelancer, things to do as freelancer, text em

О работодателе:
( 5 отзыв(-а, -ов) ) Freeland, United States

ID проекта: #1507558

12 фрилансеров(-а) в среднем готовы выполнить эту работу за $611


Check your PMB for details!!!

$635 USD за 12 дней(-я)
(98 отзывов(-а))

Hello. I have wide experience in php/mysql. Please check your PM.

$550 USD за 8 дней(-я)
(106 отзывов(-а))

I run European website design firm with years of design experience personally developing over 300+ websites. I can also provide a list of references from past customers if you'd like. I'm not the cheapest you'll find, Больше

$1777 USD за 15 дней(-я)
(54 отзывов(-а))

Can you please check your pmb.

$500 USD за 10 дней(-я)
(51 отзывов(-а))

We specialize in pure HTML/CSS websites, and we can get this done for you quickly. Check your PM for more details about our bid. Regards, the redAtom Team

$400 USD за 7 дней(-я)
(9 отзывов(-а))

Hi, PHP, MySQL is my best subject area. So i am very much interested on this project. Please see INBOX for more details BID. Thank you muthumuni

$450 USD за 3 дней(-я)
(7 отзывов(-а))

I will be happy to do this job for you. I'm experienced in PHP and MySQL. I'm looking forward to work with you and I assure you that you'll be satisfied with my work.

$300 USD за 5 дней(-я)
(1 отзыв)

Hello Sir, Please check PMB for listing and confident to complete the project with quality services.. Best Regards

$600 USD за 10 дней(-я)
(0 отзывов(-а))

Check PMB please.

$750 USD за 1 день
(0 отзывов(-а))

Thanks you for reviewing our Proposal for project! I read and understand your project description. We are a small, yet dedicated and enthusiastic web design and graphics design studio located in chennai, India. We l Больше

$525 USD за 10 дней(-я)
(0 отзывов(-а))

Hi, I am interested in working with you on your Book Creation project. I have had over 15 years experience with web programming and am a native English speaker. More in PMB

$600 USD за 6 дней(-я)
(0 отзывов(-а))

Hi, I have read your description. Looks like it is an easy, maybe tricky job. I think two scripts should not be more then 250$, so, lets here from you.

$250 USD за 10 дней(-я)
(0 отзывов(-а))