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

How to update this array?
I am saving a string that looks this: username1, username2, username3...
into a single cell in a

Help on Order Entry Form/System Where is best to begin.
I have a dilema and a very short amount of time at this point and I'm looking for some help on decid

Oracle Text CTX_DOC.snippet slow
I have a table (FILE_TABLE) that contains a blob column (ft_file) and I have created the following O

help, header() is not working!
Hello, I have this code:


<?php

/**
* @author samoi
* @copyright 200

UL and LI Add Form
The idea I want here is when the user click on a character name from the drop down select bar at the

Cron Job and Output
I have php codes running under a cron job.
But everytime i output (echo) , it comes out as comple

include function being weird?
I have a very simple system to grab an IP outputted by a PHP file.. (for a project I have) but it ou

While Problem
i am having a problem with a while statement here is the code
Code: [Select]<?php
sess

Displaying Column Names
I have a question regarding the ability to show the column names from my table/query.
What I'm lo

Frustrated php Newbie
First off, I am pretty much a PHP nub. I can read and understand the language (most of the time) so