It is with some relief that I note I am basically finished with the task of making my web page display data from a DB table. This assignment did not seem too difficult, but took me a surprisingly long time to finish (maybe > 8 hours). The task was create a database table, then display the table's data in my php web page. I ran into several difficulties with this task. One of the difficulties was making the table borders visible. It seems I was able to make them visible on one of my pages but not the other. It required more than I might have thought necessary to make them visible--setting visibility at the individual cells, using css (not html), rather than setting the visibility at the table tag. I'm not sure why I was not able to set border visibility at the table tag, nor why my table border still wouldn't show up in one of the tables, but it might have something to do with the css styles used to construct the page. Another difficulty was using an external .sql file to update the database. I learned that the .rtf format contains additional formatting information which probably is incompatible with mysql. I also learned how to save a text edit file as a .txt file in order to make it mysql compatible. After renaming the .txt extension .sql, I was able to successfully execute sql commands contained in the external file.
I may later try to figure out how to make the table borders visible on the 'nivo' webpage, but the assignment is basically finished.
No comments:
Post a Comment