I gang

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%[url removed, login to view]%20to%20complete%20the%20email%20address">example@</a> (add <b>[url removed, login to view]</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!

Færdigheder: 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, database administrator company, create mysql database using php, html transfer mysql, mysql free, html free

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

Projekt-ID: #970938

Tildelt til:

boblangdon

please see PM

$50 USD in 4 dage
(6 bedømmelser)
4.4

30 freelancere byder i gennemsnit $52 for dette job

tomydeveloper

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

$90 USD in 3 dage
(261 bedømmelser)
7.6
hamotig87

Please see PM.

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

i can do that for you.

$30 USD på 1 dag
(352 bedømmelser)
6.8
zeke

Ready to start immediately and finish within several hours.

$50 USD in 0 dage
(162 bedømmelser)
6.9
mantislin

Hi sir, Please check PM.

$70 USD in 2 dage
(168 bedømmelser)
6.8
hossionsumon

Hello sir,I'm [url removed, login to view] [url removed, login to view]

$60 USD in 0 dage
(145 bedømmelser)
6.7
soniamit

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

$75 USD på 1 dag
(168 bedømmelser)
6.4
tonykim100

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

$30 USD på 1 dag
(140 bedømmelser)
6.3
z115corporation

I can start right now. Thanks

$40 USD på 1 dag
(78 bedømmelser)
6.2
brtodi

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
(94 bedømmelser)
6.1
arusdevelopers

No problem for me. Lets start

$30 USD på 1 dag
(27 bedømmelser)
5.2
codemiracles

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

$50 USD på 1 dag
(57 bedømmelser)
5.1
persistent

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

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

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

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

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

$30 USD på 1 dag
(23 bedømmelser)
4.6
praph

please check pm

$50 USD på 1 dag
(16 bedømmelser)
4.1
binary01

Check PMB for Details.

$50 USD på 1 dag
(2 bedømmelser)
3.9
botzkobg

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

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

Hello, please check your PMB. Thanks.

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

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

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