YOU will see this HTML table at the bottom of each of the 98 countries we service. Click here, then mouseover a few countries at the top of the list to see they each have links. YOUR task is to complete links for all missing countries in each continent.
Meet Local People page is created in dynamic way . New country highways can be added by adding db entries and maps only.
Make sure the new tables ut_cities and ut_highway_detail tables are present in database entries for all highways and cities are also present.
While inserting data into these tables, data in ut_cities should be inserted first . While inserting data into ut_highway_detail , cityId from ut_cities to be used.
Below are some sample insert scripts
insert into ut_cities (cityName) values (‘CityNameA’); //city ids are auto populated
insert into ut_cities (cityName) values (‘CityNameB’);
insert into ut_highway_detail(AHRouteNo,AHSectionNo,EndPoint1,EndPoint2,orderNo,CountryId) values(‘AH1′,1 ,(select cityId from ut_cities where cityName=’CityNameA’),(select cityId from ut_cities where cityName=’CityNameB’),1 ,1 );
New Template php created named ‘meetLocalPeople.php’ in Pricerr theme folder.
On click of Highway , begin and end cities are populated . For this ‘fetchDropdowns.php’ is created in wp-admin folder .
On selecting begin and end cities, last box is populated . For this ‘fetchPlacesToVisitCount.php’ is created in wp-admin folder.
For all maps , folder named ‘maps’ to be created in Pricerr theme folder . And all maps to be inserted in this folder in php format.
After adding database entries for country highways and the highway map in map folder, the following url to be updated in ut_hyperlinks table of 7millionjobs.com
Eg. : https://latest.asianhighway26.com/meet-local-people/?country_id=4
Here instead of 4, the proper country id to be put which can be taken from ut_countries table.