If you have no idea where to start you may want to look into learning PHP and MySQL (I teach the perfect beginners course, message me and I'll hook you up).
You said you have no idea where to start, so I'm going to suggest some easy steps that will help with the learning curve.
- First, download "wamp" or "lamp" (Windows|Linux Apache MySQl PHP) so you can start building PHP applications on your computer.
- Next, setup phpMyAdmin (or just MySQL); create a database and assign a user to it. Google will be your best friend at this point.
- Once your database is set up, use mysqli_* functions to connect to your database. Here's a basic sample PHP MySQL connection script:
$host = "localhost";
$user = "database_username";
$pass = "database_username_password";
$database = "database_name";
$con = mysqli_connect($host, $user, $pass, $database);
$msg = "Could not connect to the database. <br />";
$msg .= "Error Number: " . mysqli_connect_errno();
$msg .= "Error: " . mysqli_connect_error();
- From there, you'll want to learn how to create columns inside of tables in your database and best practices for MySQL (indexing, unique's, unsigned int's, etc).
- Then you'll be able to create PHP scripts that connect to, and query, your database. php.net has a fantastic documentation and I suggest looking up their document everytime you need to learn something new in PHP.
- Then create a user interface. You'll probably start with HTML forms (POST method > GET method) and whenever the form is submitted, you can escape your $_POST variables and query your database.
- MySQL allows math. To reduce inventory is as simple as "UPDATE table SET column1 = column1 - 1 WHERE item_id='$item_id' LIMIT 1"
That will keep you busy for quite some time. And despite what others say, if you have no idea how to build it.. that's the perfect time to learn how (just don't go live with it because you'll always learn more that can make your application more secure, faster, etc).
Kalob from Footrr.com