Fixed silly error where we inserted inside of a for loop I thought we deleted. I also tested the instructor stuff pretty intensively, and it works!

fixed missing parenthesis when added choices as an instructor. Also, attempted to fix typo in the query for prevChoices as a student.

massive revision to database interaction. much more maintainable. definitely full of bugs and missteps that will take a long time to sort out. Looking forward to it!

Very broken. Completely reworking databases. Turns out, there's a way to avoid using janky SQL arrays inside of columns by defining a tbale for every user and every choice. So that's what did. Now I'm trying to rewrite my awful code to work with our new postgres setup lol

weird bug where arrays which are DEFINITELY EMPTY suddenly gain a single element: the empty string. We hard-coded a fix in the function which converts SQL strings to proper arrays, but it's a crappy solution

students array in choices table still isn't being updated correctly. added extensive debugging messages

fixed issue where we assume in the fucntion 'sqlStringtoArray' that our implicit array has size at least 2. Now, we should be able to insert the userEmail into the choices students column more effectively. Note that choice titles must NOT have commas. Problems still might happen; this attempted solution has not been extensively tested

Refresh bug fixed! Got rid of unnecessary debug messages. Now we're trying to implement our 'oh crap our arrays from the db are actually strings' solution, which is using our handy-dandy fuction! If, after testing, there are no major bugs, then we'll proceed forward with a long-overdue refactoring of the code...

trying to fix bug where we need to refresh twice in order to auto-select to update to new choices

I've been confusing arrays with strings that look like arrays for hours! Turns out, when you make a SQL query, VARCHAR [] still gets returned as a string instead of an array. I've implemented a function for nicely converting these SQL array strings to proper PHP arrays. I still feel a little silly and frustrated, but it's nice to finally know what went wrong and how to fix it

We've probably made a bunch of fetch vs fetchAll errors. Let's troubleshoot!

prevChoices are... different types in our two programs, somehow? big confuse

json by fajnsfbhsdf

JSON derulo

i don't understand why it's not automatically converting JSON string to array in some but not all instances smh