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

Hyperlink in PHP to MySQL record
Hello,

I am having trouble as i am new to php. I have connected to the database and I have di

very easy question about SQL info
Hello,
I think that I have a very easy question.
I know how to create a form using php SQL and

Error: SQL Syntax; Line 1
Code:

<?php require "global_settings.php"; ?>
<title&g

Escape Latin Characters
I need to escape latin characters in an xml doc. Example: "é" is escaped to "é". I thoug

OOP help
okay so i have a class im making it has everything setup i just need to randomize the 2 variables an

Match 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

DBCA Templates
Hi all,

I'm working on creating a template for DBCA, but can't find any documentation on the

Appending GET data with form submition
Okay, what I'm trying to do is to use a form to append an already existing GET data string.

I

moving mouse to display image coordinates
I have an existing MFC application that shows an image in the main window.
I'd like to be able to

An odd assignment statement. Can someone explain this assignment to me?
What purpose is served by the bit of code between the two equal signs in the $installurl set? Is th