Multiple arrays inside data

Posted on 16th Feb 2014 07:03 pm by admin

Hi,

Simple question. I have a column called "array" in my database, and inserted into each field is the following imploded array:
Code: mctriangle,570.65,355.1,1,1,0

It is an instance of an object. Each field in each row contains this information as an imploded array.

[0] = Name
[1] = X Axis
[2] = Y Axis
[3] = ScaleX
[4] = ScaleY
[5] = Rotation

When extracted from the database, it is exploded back into the array above.

As you can see, I would need to store a lot of rows for each object. Say we use 200 objects, thats 200 rows, which would be hard to search through.

My question is: Could I store multiple imploded arrays inside 1 row only. E.g:

mctriangle,570.65,355.1,1,1,0&&mctriangle,570.65,355.1,1,1,0&&mctriangle,570.65,355.1,1,1,0&&mctriangle,570.65,355.1,1,1,0&&mctriangle,570.65,355.1,1,1,0

The above would be 5 objects in one row of data, each imploded array separated by &&. How would I go about doing such a thing?

Thanks!

Your Answer:

Login to answer

Other forums

Securing a user input - need some confirmation
Hello All,

I am in the process of recoding a large proportion of an e-commerce site, one of t

records between 2 dates
Hello all,

I have a date tracked table which contains effective_start_date and effective

browse folder only
hi,
is there a way i can browse or get the directory or folder only and not the file?
i just w

Login Control?!
I have a Web Site that uses the login control also I have set the destinationurl to the page I want

list files from folder, only one for each date
I have many files in a folder and wish to only list one of each date

these are the file names

help finding hacking loopholes
i was attacked by a redirect php injection

my pc is clean of viruses

so i figure that

Remove directories not empty
hi,
i have an array that contains some names (1,4,6,56...). Every integer is a name of a folder.<

Points for Wiki contribution
Hi everyone,

I want to know how long does it take for the moderator to award points for a

Help a newbee save my job !
Hey guys i am dying here i am new to php and would like for someone to help me with this problem

iMatch stored value with the current value in a loop
Hello,

I have a MySQL db were I store articles in.

I have a form to fill these article