How do I make a simple database program?

Can C2 be used to make a simple database program for tracking things?

Say for instance, I want to track the issuance of books or something. I have one textbox for the name of the book and another for the name of the person who I gave it to. I would like to enter the info, click a button and add it to my list/database.

After that, I would like to be able to view that list in it's entirety and or search by specific field.

Sounds complicated, but I feel like it's possible.

Thoughts?

The easiest way to interact with a database is in PHP.

There are tons of tutorials on Google on how to do this also.

http://www.w3schools.com/php/php_mysql_connect.asp is one example.

From there, you simply access your PHP app via AJAX (HTTP GET) and then have that API pass information back to your database.

Check it out

myvisualdatabase.com

Like MS Access but easiest. Look video lesson section on site.

To interact with MySQL database, you will have to connect it with PHP. You can do that by creating db_connection.php file and add the connection parameters in it. This way you can quickly connect mysql database with PHP (https://www.cloudways.com/blog/connect-mysql-with-php/ ).