Phil 7.25.14

8:00 – 5:00 SR

  • DB Backups
  • Added a event handler to get the comments.
  • Add clear() method. Nope, just used location.reload(true) to force a reload of the page from the server. Better!
  • Drat. I need it anyway, to prep for loading JSON. Done.
  • Save and Load should use the name in the FR name field. If the name is not in the list when save is pressed, it’s added to the list.
  • Work on save first, then load.
  • How to do a compound insert from Dong:
    • LAST_INSERT_ID() gives you the key/index of the last record inserted…..

      1. insert the first record

      INSERT INTO data_table (uid, data) VALUES (null, ‘data’)
      2. insert into master record
      INSERT INTO master_table (uid, some_data, key_to_data_table) VALUES (null, ‘some_data’, LAST_INSERT_ID());

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.