I am willing to insert an array to a database as normal text.
$subjectcodes[1] = "";
$subjectcodes[2] = "";
$subjectcodes[3] = "";
$subjectcodes[4] = "";
$subjectcodes[5] = "";
$subjectcodes[6] = "";
$subjectcodes[7] = "";
etc...
I give my array an stringname called list_update. So you get this ( I am having "\" so it doesn't see it as PHP )
$list_update="
\$subjectcodes\[1\] = \"\";
\$subjectcodes\[2\] = \"\";
\$subjectcodes\[3\] = \"\";
\$subjectcodes\[4\] = \"\";
\$subjectcodes\[5\] = \"\";
\$subjectcodes\[6\] = \"\";
\$subjectcodes\[7\] = \"\";
"
Now when I use my query to input my list into a table it doesn't do anything.
mysqli_query($connect,"INSERT INTO subjects (list)
VALUES (" . $list_update . ") WHERE user='". $userid ."'");
Does someone know how I can solve this?
Thank you very much in advance ;)