fix a single php file, used to extract phone numbers script

This project was awarded to mkinternation for $50 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Skills Required
Project Budget
$30 - $250 USD
Total Bids
Project Description

1. I have a db table where we store profile information. A user
creates a profile and the information is stored on the db table called

2. These users 99% of the time put their phone number, So I have a single
php file that extracts the phone number from the database table field called
"text" and extracts the phone number to the same table called (phone)

Snapshot: [url removed, login to view] (file attached)
Snapshot: [url removed, login to view] (file attached)

3. This php file uses different algorhytims to figure out the phone
number.. It's a single file about 300 lines of code

4. The script (php file) will scan the db table (text) and extract the
phone number, and save the phone number in 10 digit format on the same
table called (phone) Now if the phone number cannot be extracted it
will then have phone field=0 or blank

Snapshot: [url removed, login to view] (means no phone can be extracted)

Problem: The script is pretty good, because a lot of users use text
and font combined with different characters, the script usually can figure out the phone number and extract it. But the script just stopped working for no reason ?? not sure why

What i need from you

1.. Only erase the fields that have "Phone" field, either blank or 0 from
2. fix the php file (analyze it) and modify the code. Really good and get it up and running again..
3. Create a better way so that it can better extract the phone numbers

Here is the link to the php file, and the db tables. One table is with phone numbers, and one is without. So your fixed script should be able to extract the field without phone numbers.. (check file "[url removed, login to view]") in the zip folder below

[url removed, login to view]

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online