ChatGPT is changing the world, starting with our Web 206 class. Today in class, I was able to create my own database, insert a data table in that database, and add the data from my table to a page on my site. Just a year ago, I would’ve needed to have taken a coding course on PHP, a database course to learn SQL, and a course that teaches HTML and CSS.
However, with the power of ChatGPT, I was able to do this in just one class period by asking ChatGPT a series of questions and having it write the code for me. One of the benefits of ChatGPT is that it also takes you through the code that you’ve generated, so you can understand the code that’s written and not just copy it. Below shows the series of questions I asked ChatGPT to generate the code I needed for this project.
- Create a hypothetical table showing Excel usage through region
- Write the SQL to create the following table. The table is named tblExcelByRegion
- Write the SQL to add the data to the table
- Write the code for a web page that will display the table
- Create a page to show the php code to display the table stored in a mysql database