Creating Database

Hello BHW,

I want to create database, I have logistics company, I have truck drivers and want to create a database where I put all my drivers and search them, for me and for my colleagues.


Something like:

Name:
Truck type:
Directions:
Phone number:

And I want to filter it by this settings.

Thank you guys in advance!

Anyone?

If you want to build it yourself I'd suggest by starting to look into setting up a database. The most common databases are MySQL and Mongo.

There are plenty of tutorials on how to setup the basics. My advise would be to start with some software called WAMP (there's XAMP or nginx as well, just a matter of taste).

Once setup you can start creating a database structure. I'm using MySQL Workbench to visualise everything (I recommend starting with an editor when you start with these kind of things).

In workbench you can create a new schema and the desired table where you can insert all your columns, which are the parameters for your trucks and other variables.

Once you've setup the database you can either manually populate it or through a Web browser.
While installing WAMP you also get a web server which can be connected to on your local PC.

Create a PHP script to lookup your database table and if you'd like to insert new records to your database through your Web page you can also make a script for this.


Everty step I've described, or at least tried to, can be found on YouTube or just by googling. If you need help at a spesific point you can also ask around.

I hope this is of any help to you. Good luck!

I would like to help you. brief your requirement.