I have a directory of resource suppliers that was created using only html. For more efficient content management, I need to create a MySql database, transfer all the existing data to it, and create an html form for future entries.

The database table and the html form need to include the following fields:
– name of company
– website URL/link
– street address
– email address
– phone number
– toll-free phone number
– description of products and services

The listings are currently formatted one per paragraph (<p>listing</p>).
There is a <br> for each line of the paragraph (not <br/>).
The name of the company is in a <b></b> tag (sometimes the closing </b> is after the <br> instead of before it).
The rest of the information is not always in the same order, except that the description is always last and preceded by either a double hypen (–) or an em dash (html code —).
The email address is separated as in the following example:
<a href="mailto:example@?body=(add%20example.com%20to%20complete%20the%20email%20address">example@</a> (add <b>example.com</b> to complete the email address)
Sometimes there is a word and colon at the beginning of a line; for example, a phone number might just be the phone number or it might be preceded by "Phone: "

Since there is some inconsistency, it might be tricky to create a script that could successfully transfer all the info into the new format. However, there are enough patterns to be able to extract the following with a script:

– name of company (delimiters being <b> and <b/>)
– website URL/link (delimiters being <a and </a>)
– email address (using the elements common to all the email addresses, like mailto, @, and the repeated phrase in parentheses)
– phone numbers (looking for several variations of the pattern, as sometimes they have all hyphens and sometimes the area code is in parentheses)
– the description because of it being preceded by one or the other type of dash pattern.

Whatever is left after the above are extracted might need to be put into the address field and then adjusted manually.

The html form for adding future entries needs to include php processing to transfer the input into the database in a secure way (sanitizing input). I will also need to have the new db entries moderated, so the processing will need to include a notification email to the administrator, with a malicious-code-free copy of all the data that was input.

There are about 100 listings so far.

I hope Ive given you all the information you need to know how long this might take you and how much you would need to charge for it. Thanks!

Tags: address, database, email, HTML, phone, sometimes, transfer