transfer html listings into mysql database format
$30-250 USD
Paid on delivery
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%[login to view URL]%20to%20complete%20the%20email%20address">example@</a> (add <b>[login to view URL]</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 I've 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!
Project ID: #970938
About the project
Awarded to:
29 freelancers are bidding on average $52 for this job
Hello, I am ready to start the project. You are requested to check my PM for portfolio and client reviews to get an idea of my works & services. Thanks.
Hi, We have an excellent team of web developers and designers and we have lot of experience in dealing this type of projects so we are ready to handle this project. Please check PMB
Hi. I can do this job. And import all data in mysql. Kindly provide me access to get started
