transfer html listings into mysql database format

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 &#151;).

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!

Evner: Dataindførsel, Databehandling, HTML, MySQL, PHP

Se mere: data extracted html form database, transfer url, order processing services, needs of a suppliers, name transfer, name com transfer, mysql database for free, html website free to copy, html free code, how to create website by using html, how to create database using php, how to create company website and email address, how to create an website html free, how to create a directory using php, how to create a database using php, how much charge to create a website, free website html code, free code html website, format services, data input administrator

Om arbejdsgiveren:
( 0 bedømmelser ) London, Canada

Projekt ID: #970938

Tildelt til:


please see PM

$50 USD in 4 dage
(7 bedømmelser)

29 freelancere byder i gennemsnit $52 på dette job


Hi sir, Please check PM.

$70 USD in 2 dage
(348 bedømmelser)

Hello,We are php / mysql expert and ready to provide you required database for your site with required [login to view URL] check [login to view URL]

$90 USD in 3 dage
(375 bedømmelser)

Please see PM.

$100 USD på 1 dag
(53 bedømmelser)

i can do that for you.

$30 USD på 1 dag
(384 bedømmelser)

Lets Starts .......... Regards soNia

$75 USD på 1 dag
(170 bedømmelser)

No problem for me. Lets start

$30 USD på 1 dag
(55 bedømmelser)

I can start right now. Thanks

$40 USD på 1 dag
(79 bedømmelser)

Hello sir! I am ready to start your work right now. Please refer your pmb. Thanks.

$30 USD på 1 dag
(142 bedømmelser)

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.

$100 USD in 2 dage
(96 bedømmelser)

hi, let's start the project. check PM now.

$50 USD på 1 dag
(33 bedømmelser)

-=Quality and speed=- I can do it with high quality of work.

$30 USD på 1 dag
(28 bedømmelser)

Hi, I am very much interested in this project. please look at your PM. THanks

$50 USD in 0 dage
(6 bedømmelser)

Yes we look new but we have a pleasant surprise for you. Pls see PMB.

$50 USD på 1 dag
(58 bedømmelser)

please check pm

$50 USD på 1 dag
(23 bedømmelser)

Hi there I will finish this job. Please check your PMB.

$30 USD in 0 dage
(8 bedømmelser)

Web fetching is my passion. It will be very interesting to do this job for you.

$30 USD på 1 dag
(3 bedømmelser)

Hello, please check your PMB. Thanks.

$100 USD in 2 dage
(4 bedømmelser)

Not a work of more than 30$...

$30 USD på 1 dag
(3 bedømmelser)

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

$30 USD på 1 dag
(2 bedømmelser)

Hi. I can do this job. And import all data in mysql. Kindly provide me access to get started

$60 USD in 3 dage
(2 bedømmelser)