Expanding the Conference Database
in HTML/PHP
Preface
As with previous lab examples, examples for this HTML/PHP script are
taken from accepted papers from SIGCSE 2008. In a few cases, the status
of a paper is listed here as "submitted" rather than "accepted"
to provide a better example. Independent of the information
reported here, all papers were accepted and are included in the
SIGCSE 2008 Proceedings, available through the
ACM Digital Library.
This script adds
-
2 papers, but not their authors
-
2 authors, but not their papers
Connect to the Database
logging into MySQL database: done
selecting database: done
Insert New Records into Paper Table
defining query for papers 7, 8, 9: INSERT INTO confPaper VALUES (7, "Cross-Cultural Issues in a Tutored Video Instruction Course", "accepted"), (8, "Engaging Constructions: Family-Based Computing Experiences For Immigrant Middle School Students", "accepted"),(9, "A Course in Collaborative Computing: Collaborative Learning and Research with a Global Perspective", "submitted");
executing query: done
defining query for authors : INSERT INTO confAuthor VALUES (13, "Roxanne", "Canosa", "Rochester Institute of Technology", "made-up-11@school9.edu"),(14, "Joan", "Lucas", "SUNY Brockport", "made-up-12@school10.edu");
executing query: done
Wrap Up
closing database: done