Käynnissä

Need Some modifications in a php script

Here is the deal. I have a php script that among other things recovers variables of LATITUDE and LONGITUDE from a mysql DB and shows icons in google maps api.

The script already has a form to add new stuff to the map, when I click anywhere in the map, it fills-up the form lat and long fields, so I just need to type a name and a few more information and it creates the table entry, after refreshing the page, it shows in the map.

I also have a "relations" table which basically has 3 fields, ID, ID_from, ID_to, where I store the information of which item is connected to which item, for example: ID=1, ID_from=200, ID_to=233, makes the google maps api create a linking red line between items 200 and 233.

My problem is to remove items from the map, I currently have to do it manually through PhpMyadmin, and I have to manually check the "relations table" if no other item is connected to the item I want to delete, which could be done a whole lot faster using Mysql querys.

So the job is:

- Add a form to delete items from the DB

- Check if the item ID is not connected to any other Item, and if it is make the necessary modifications

- Find out why the form that creates Items "relations" sometimes doesn't work.

Thank you.

Taidot: HTML, MySQL, PHP

Näytä lisää: why do i want to work here, line in problem, line icons, 233, remove my page in, php script create table, just type some, find a name, latitude longitude table, mysql stuff, google map script latitude longitude php, remove script, example mysql script, check table mysql script, mysql store lat, mysql remove table, php form delete mysql, latitude longitude google script, google latitude longitude map, entry maps, mysql form phpmyadmin, google maps api form, php script name, mysql php google maps api, php google maps api

Tietoa työnantajasta:
( 4 arvostelua ) Maceió, Brazil

Projektin tunnus: #1694307

Myönnetty käyttäjälle:

osworker

Ready for it

30 $ USD 1 päivässä
(3 arvostelua)
3.6

4 freelancers are bidding on average $47 for this job

LuigiWidmore

Hi sir , My name is Luigi Widmore and i'm an expert web developer. My areas are HTML/CSS PHP/MYSQL Design/Photoshop. I can deliver this project in 5 days or less. Please check PM for details , you may be impresse Lisää

99 $ USD 999 päivässä
(93 arvostelua)
6.3
MHedayet

Hi, very simple job for us. Ready to start right now and will finish really fast!!! :-)

30 $ USD 0 päivässä
(22 arvostelua)
4.2
achillesJK

I'll help u, sir. Please see your pm.

30 $ USD 0 päivässä
(3 arvostelua)
2.7