Fix some PHP code on a website, and edit a MYSQL database.

The Please-Buy-My-Car dot com website collects info about a vehicle that is being sold.

Then it sends the info in an email to a potential car Buyer.

I hired a programmer to make some changes to the website several months ago.

Just recently, I found a bug in one part that he worked on.

Other than that, all of what he did was Terrific. I loved his work.

I just cannot contact him now. He seems to have disappeared. :(

The needed script changes...

1. After the vehicle information is entered, all of the fields are reset to Blank.

I want ONLY the Mileage, Price, Name, and Phone to be reset.

I want the Year, Make, Model, and City to remain as they were,

and Acceptable for the next record.

2. Many months ago, when I entered a phone number, it used to display "previously

entered" phone numbers that started with the same numbers.

Then, the programmer added the "___-___-____" formatting, so I now

don't need to enter the dashes.

And now, it doesn't display the "previously entered" phone numbers.

I want all of the phone numbers to be unique, or at least not Recently used.

As soon as an entire phone number has been entered, I'd like you to look it up in the Seller table.

See if that same phone number has been entered before.

IF the phone number has been used before, display (in that same little window,

next to the phone) the Date (MM/DD/YYYY) when it was most recently used.

The SELLERS table has that date when the info was entered.

In the PRIV folder, there are certain scripts that I use...

3. In the [url removed, login to view] script (which downloads data),

please format the fields to appear with Dashes and Commas, like...

Phone would be 111-333-5555, and both Miles and Price would be 11,222.

4. When I try the [url removed, login to view] script, it gets an error...

And, what is that script supposed to be doing?

5. Same thing with the [url removed, login to view] script. It gets an error.

Actually, I think that it is simply used by the [url removed, login to view] script.

6. The [url removed, login to view] script displays a map of Buyers and Sellers.

But it doesn't display any recently added records. Why is that?

Maybe the lines should be thinner, because there will be many records.

And... Can you make that a full-screen display?

7. The bug that I recently found is in [url removed, login to view] script.

It's supposed to add a new Buyer to the database. When I try that, it says:

SQL/DB Error -- [Unknown column 'BILLINGname' in 'field list']

Dealer Acme Honda saved

but the Buyer (Dealer) is Not saved into the database.

And please rename [url removed, login to view] to [url removed, login to view], just so I know what it does.

8. There also seems to be an error in the geographic coordinates.

When a Buyer's address is entered, his Latitude and Longitude are computed.

That part is not now working correctly.

It comes up with coordinates that are about a mile away.

Please fix that.

9. I think the emails are sent in the [url removed, login to view] script in the SCRIPTS folder.

Please change the outgoing emails. Right now, the last line is:

"After you buy the vehicle, please deliver the Seller to (city name, state, zip)."

Please remove the blank line before that, and change that line to:

Seller Location: (city name, state, zip). Note that ZIP might be blank. That's OK.

And capitalize the word "Phone" in the line above that.

I've done a complete backup of the website, via cPanel.

I could send any or all parts of that to you if you need to see the

existing scripts (that would need your changes).

After we agree on the price and payment method (Paypal?),

I'd like you to make the program/script/website changes,

then just email those parts that were changed to me,

so that I will then upload them to the server.

This is a temporary job, just to get some certain things done.

Of course, I will probably want to contact you again in the future,

when I eventually want other changes made to the website.

Let me know if you've got any questions.



Kemahiran: MySQL, PHP

Lihat lagi: zip car, what should i look for in a programmer, what should a website look like, what is a database programmer, what does a website need, what does a programmer need to know, what did you like most about your job, what did you like least about your last job, what a programmer should know, what a php programmer should know, we ve sent you an email, website buy programmer, want to buy a car, want a buyer, vehicle service data, temporary job, sql server price list, simply hired com, program to download full website, programmer on line

Tentang Majikan:
( 0 ulasan ) United States

ID Projek: #2608708

31 pekerja bebas membida secara purata $181 untuk pekerjaan ini


Hello Sir, we are ready to start and discuss this right away. Please check the message box. Thanks Ashwin

$225 USD dalam 3 hari
(191 Ulasan)

Hi I am ready to start work on your project. Please accept the bid.

$200 USD dalam 3 hari
(229 Ulasan)

Hi Have Gone through your requirement and understood, we are very sure that we can do your needs with your entire satisfaction. We have left a PMB for you plz feel free to have a look over there. Thnx Ram Webzin I Lagi

$250 USD dalam 7 hari
(52 Ulasan)

Consider these fixes done.... Right developer at your door...HIRE WITH CONFIDENCE...Hope to achieve next positive feedback from you !!! Please check you inbox. "Always willing to walk extra miles to achieve Excellen Lagi

$249 USD dalam 4 hari
(46 Ulasan)

Hello, I have gone through your project and well understood your requirements. Please check PMB. Thanks.

$160 USD dalam 7 hari
(64 Ulasan)

Hi, Please check inbox for details and samples of our works done

$175 USD dalam 4 hari
(56 Ulasan)

Understand alll you requirements. I will be happy to help you with this project. Hope to do business with you !

$180 USD dalam 2 hari
(104 Ulasan)

please check PM for details

$180 USD dalam 5 hari
(59 Ulasan)


$150 USD dalam 7 hari
(129 Ulasan)

Hi, First of all please check my reviews to have an idea of my expertise. If interested PM me to start ASAP. I am looking for long term relation ship. Regards

$200 USD dalam 5 hari
(37 Ulasan)

Hello sir i have rode all your requirements and I am capable of delivering the desired results to you. Regards PHPYOUTH

$165 USD dalam 7 hari
(28 Ulasan)

Let Champian handle this for you.

$230 USD dalam 3 hari
(23 Ulasan)

Thank you.

$220 USD dalam 5 hari
(28 Ulasan)

Hi I can do [login to view URL] see PM.

$170 USD dalam 10 hari
(41 Ulasan)

Read your details and interested to work, thanks.

$150 USD dalam 7 hari
(32 Ulasan)

Hello i can help you. please give me my PM for detail.

$225 USD dalam 7 hari
(31 Ulasan)

Sir, we are ready to work in your project. Plz check private message for details. Thanks

$160 USD dalam 6 hari
(7 Ulasan)

good project [login to view URL] project requirement [login to view URL] expected from your side. IT Square team

$100 USD dalam 8 hari
(3 Ulasan)

Ready to start right now.....please consider my bid..... Please check PM.

$150 USD dalam 3 hari
(17 Ulasan)

Hi. Your requirement is clear. I have expertise in PHP, Javascript (jQuery, Ajax), HTML,CSS and Web Design. So I can finish this project with the best result and very fast. Let me do it for you. thank you

$150 USD dalam 2 hari
(9 Ulasan)