This is a screen recording I made while testing a new database function.
- From my howardamyjo@gmail.com Google browser homepage, I typed in the address bar:
localhost/amy - Chrome opened the index page, showing links for
- Projects
- Authors
- Sources
- Admin
- I clicked on Authors
- Chrome opened the Authors page, which listed 230 authors, topped with the input form to add an author.
- I added Gump, Bubba, then scrolled to the list to see it.
- I clicked on Gump, Bubba in the Authors list.
- Chrome opened the Gump, Bubba Author page. The page was programmed to list the author's sources on an author's page. However, there were no sources for this author yet. The message said, "Oopsie. Looks like you need to round up this author's material."
- I clicked the Sources icon in the left navigation bar. It listed 450 sources topped by an input form to add a source.
- Chrome opened the page
localhost/amy/pages/source_add.php
titled Add a Source. - A form waited to fill in details of a source, starting with a dropdown box to select an author.
- I selected Gump, Bubba from the dropdown.
- I titled the source "Can I Get a Witness?"
- I dated the source 2/20/2024.
- I copied the current URL into the Online Link field.
- For Published in, I typed "The Great Anthology of Nonsense."
- I clicked Add this source.
- Chrome produced a white page with a message box saying, "Source added successfully".
- I clicked OK on the message box and Chrome produced a blank copy of the Add a Source page.
- I clicked the Sources icon in the left navigation bar.
- Chrome produced the Sources page, now with Gump, Bubba, Can I Get a Witness at the top of the chronological list because it had no date.
- I clicked the new source.
- Chrome produced the Source page for Can I Get a Witness. All of the data fields were empty except the author, even though I had put data in them.
- I clicked the Update button.
- Chrome produced the Update a Source page, where I re-entered data into the supporting fields. For Published In, I typed "The Great Nonworking Anthology of Nonworking Code".
- I clicked the submit button labeled, "Replace existing data with this data". The Sources list appeared.
- This time, the source appeared in chronological order in the list because it had retained the date.
- I clicked the source and it had the information I had typed, along with a button to update the information.
- Two checkboxes (Full text and Primary doc) rendered as 0 for unchecked. I replaced the zeros with ones and clicked Replace existing...
- Chrome produced the Sources list.
- I scrolled to the source and clicked it.
- The ones had been updated.
- I opened a new Chrome tab and went to localhost/phpMyAdmin
- I opened the Sources table and saw the new source there with ones in the two checkbox fields.
On 1/2/2026, I archived this video in AWS/S3 as
2024-02-20_howard_database_test.mp4
I kept a thumbnail as:
2024-02-20_howard_database_test.avif








