Attach mysql database to my website and create a few webpages

my website is [login to view URL]

I want to attach a few databases with fields

[personDB].fields:username,password, Type [ truck owner or Loads owner] ,Name, Surname, telephone, number, Location (full address], email, fax line, whatsapp number, trakerzid, spare1, spare2,spare3,spare4, date registered, profile photo

[loadsDB]: creation date, timeframe[ASAP, This week, next week, this month or pick date from calendar] , from, to, distance, size [number field], type[Bulk, boxed goods, Palletized Items, Individual items, Other] description,spare1,spare2,spare3,

[townsDB]: this will be a database of list of towns in south africa

[feedbackDB] . this will be a database where the truck owner can be rated for his level of service after a deal has been done [similar to ebay feedback system]

[trucksDB]. this is a database of trucks which is link to truckowner of persondb. fields will include things like type of truck, yearmodel, colour, loadcapacity, photo of truck etc, etc

[AreadbDB]. this is a dba of operating areas for truck owners. It will be made up of a list of tows from townDB as picked by truck owner

clever things the website should do:

if a new load is listed then the truck owner who operates in that area should get notified via email, Each truck owner will choose a list of towns where he works or wants to operate.

website pages;

Loads page:

show a list of all loads. something like.

load id, [loadsDB]from , [loadsDB]to, [loadsDB]type, [loadsDB]distance,[loadsDB]description.....Only display first 100 characters withe a 'more...' button which will load the rest of the description

if a user clicks the loadid then the full details will be displayed [ the user will need to login at this point]

Transportes page:

transporterid. , transporter company name, date registered, number of truck, type [Large company, small company, independent] areas of operations [list of areasdb],

if a user click the transporterid then will be taken to a full details page of the transporter including contact details etc etc

Example of a created 'load' .

date: created date

timeframe:{ Choose from list]


from ;Johannesburg

load type: Individual items

Load distance: around 550 km

description:[free text] I want to transport 5 Loads of Generators from Johannesburg to capetown

each generator is 500kg and is approx 1m square in size. must be done by next week

Dovednosti: Správa databází, HTML, MySQL, PHP, Web design

Zobrazit více: create pdf mysql database, create mysql database iis, create reports mysql database, how to connect sql database to html web page, how-to create a website with a database backend, how to create a database driven website, how to connect a web page to a database using php, how to connect html to database with mysql, database website examples, how to connect website to database in sql, how to create a website with a database, create mysql database phpmyadmin, phpfilenavigator create mysql database, create php mysql stories website, hack joomla website mysql database, create coupon database website, drupal mysql database website architecture, mysql database use create drag racing, mysql database manage create integrate website, format create database website using mysql

O zaměstnavateli:
( 17 recenzí ) London, United Kingdom

Identifikační číslo projektu: #17977860

Uděleno uživateli:


Hi, I am a full stack developer and have been working as freelancer from past 5 years on various freelancing platforms and now have marked my presence on to deliver quality project which I have been doi Další

$25 USD za 1 den
(1 recenze)

3 freelanceů na tento projekt zveřejnilo nabídku v průměrné hodnotě $27


Hello there, As per my understanding you need a MySQL database to website and create a few webpages. We have 7+year experience in website design and developments in E-commerce,Woo-commerce, JavaScript,PHP, WordPress Další

$35 USD za 1 den
(184 Recenzí)

Hi. Thanks for Visiting our Profile. After reading your job description, I’m happy to say that I believe my skillset are a perfect fit to meet your requirements. My favorite thing is sitting down with you one on one Další

$20 USD za 2 dní
(0 Recenzí)