current community

your communities

more stack exchange communities

Stack Exchange
tour help
careers 2.0
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 0 down vote favorite

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 ;)

share|improve this question
1  
So what does mysqli_error() tell you? Please also learn to always either use mysqli_escape_string() or prepared statements. –  johannes Feb 3 at 17:59
    
@johannes It says: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[1] = ""; $subjectcodes[2] = ""; $subjectcodes[3] = "' at line 3 –  Ahmed Feb 3 at 18:02
    
I think, its a really bad idea to store it in array for the 1st place, because retrieving & querying data wont be efficient. –  Akhil Sidharth Feb 3 at 18:03
    
@AkhilSidharth Well do you know another way to store an "array" in mysql. And I can retrieve the queries easy and use it after doing eval() But storing is the problem :( –  Ahmed Feb 3 at 18:04
1  
json encode your array and insert into db. When you need it , fetch it from db and then again json decode it and you will have your original array. –  altafhussain Feb 3 at 18:08

2 Answers 2

up vote 2 down vote accepted

Do it as below:

$subjectcodes[1] = "";
$subjectcodes[2] = "";
$subjectcodes[3] = "";
$subjectcodes[4] = "";
$subjectcodes[5] = "";
$subjectcodes[6] = "";
$subjectcodes[7] = "";

json_encode($subjectcodes);

Insert into your DB.

After you fetch it from DB, then decode it as below:

$array = json_decode($yourArrayItemFromDB);

ANd you will have your original array like $subjectcodes.

Using this way, you can not only save arrays, but you can also save objects in DB.

share|improve this answer
    
Thank you it worked :D –  Ahmed Feb 3 at 18:31
    
you are welcome :) –  altafhussain Feb 3 at 18:47
up vote 3 down vote

A PHP array or object or other complex data structure cannot be transported or stored or otherwise used outside of a running PHP script. If you want to persist such a complex data structure beyond a single run of a script, you need to serialize it. That just means to put the structure into a "lower common denominator" that can be handled by things other than PHP, like databases, text files, sockets. The standard PHP function serialize is just a format to express such a thing, it serializes a data structure into a string representation that's unique to PHP and can be reversed into a PHP object using unserialize. There are many other formats though, like JSON or XML.

From here

share|improve this answer
    
I am going to try that right now! –  Ahmed Feb 3 at 18:15

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.