We can add new records to that table each time a bill is paid, just as we could have added new pieces of paper to our file folder. Say we have a database, and it contains a table named bills_paid.Īlmost always, when giving things names in web development, we use a format that doesn’t contain any spaces, hence the name bills_paid as opposed to something like “Bills Paid”.

We can store data in a database in the same exact way. Within that folder, we have records of payments for various bills. So say, for example, we have a filing cabinet, and it contains a folder labeled “Bills Paid”. Tables are comprised of records, or rows, which you can think of as individual documents within one of the file folders, as depicted below. We can add, update, and remove pieces of data from our database, at will.ĭatabases are comprised of tables, which you can think of as file folders. It’s what will help us organize all of our app’s data. You can think of a database as a sophisticated, digital filing cabinet. Just as knowledge is power, information is power, as well.

Sure you can create a really fancy app like Twitter, but without all of its information-in the form of tweets, in Twitter’s case-stored, retrieved, and viewed, it’s really quite useless, if you think about it. One of the key elements to consider when building a web app is the data.ĭata, or information, is what really gives an app power and purpose. This is lesson three of a 10 ten-lesson course, Simple CodeIgniter App, which walks you through the creation of your first PHP web application using the CodeIgniter framework. Designing and Creating a MySQL Database Using phpMyAdminīy Alex Coleman | Build a Simple CodeIgniter App, CodeIgniter, Web App, Web Development

Phpmyadmin boolean