0
votes
2answers
76 views

Store multidimensional array from JQuery Dropdown checklist in database in string form using loop

I want to store an array of checklist into a string in a database. Below this is the code in the interface which display a list of room with a dropdown checklist for each room. while($rows = ...
4
votes
2answers
73 views

MySQL tables or PHP explode for business hours

I need to store business hours for 200+ unique businesses (and growing). Each business has varying hours and some are closed for lunch. In addition, a business might open at 8am one day and 9am on ...
0
votes
1answer
48 views

Setup an array in php with children nodes

I have the following data from a table: +----+---------+-----+---------+--------------+ | id | name | id2 | sname | relation | +----+---------+-----+---------+--------------+ | 1 | Albaraa ...
-1
votes
3answers
80 views

create a PHP/mysql array

Sorry folks, being thick (please excuse) I have 3 MySql tables with data. Each table has a "common field" of a date (datestamp) I need to combine the select query from each table and order the array ...
0
votes
2answers
73 views

PHP group query results as nested associative array

I'm trying to group query results in PHP as an associative array in an efficient manner. I could use multiple nested foreach loops, checking if the current id field matches the previous for each array ...
0
votes
1answer
69 views

Sum values of multidimensional array by key without loop

I have this: Array ( [0] => Array ( [f_count] => 1 [uid] => 105 ) [1] => Array ( [f_count] => 0 [uid] => 106 ) [2] => Array ( [f_count] => 2 [uid] => 107 ) [3] => ...
3
votes
2answers
71 views

PHP functions to parse multidimensional array?

I run a query andfetchAll() $query = "SELECT uid, kill_count FROM users WHERE curmid=:mid AND status='1'"; ... $row = $stmt->fetchAll(); that returns this array: Array ( [0] => Array ( ...
0
votes
1answer
96 views

Multidimensional array PHP from MYSQL query

I have the followning tables in MYSQL: CommentTable with columns: comment, commenter, datecommented and postid PostTable with columns: postid, dateposted I perform this query in php Select ...
0
votes
1answer
28 views

Build multi-dimensional then add to Table

how can I create a single multidimensional array from 2 or more foreach loops: $arr = array(); //loop 1 foreach (dogs[1] as $key => $url) { $arr[$key]['pos'] = $key; $arr[$key]['place'] = "2"; ...
0
votes
1answer
51 views

retrieving specific rows from a table and storing each row as an associative array in session

I am creating a PHP/MSQL Application which is basically an online quiz, user will start quiz, internally for an instance randomly 30 questions are retrieved from db-table and stored in session. My ...
1
vote
2answers
58 views

Store specific values from a multi-dimensional array

This is my array: Array ( [0] => Array ( [0] => Received: from mout.perfora.net ([74.208.4.194]:64110) [1] => Received: from localhost ...
1
vote
2answers
129 views

Storing huge arrays in the database

I am working on an image processing project. I am using php for the GUI and matlab for the algorithm and Mysql as my database. I have 30,000 of images stored in the database for now. My matlab program ...
0
votes
4answers
122 views

Storing an array in a MySQL table

I have a 5 level multidimensional array. The number of keys in the array fluctuates but I need to store it in a database so I can access it with PHP later on. Are there any easy ways to do this? My ...
0
votes
2answers
51 views

php and mysql issue

I have a table that has an attribute named URL, when adding registries to this table, I can choose to leave that field NULL or to write a URL. If I leave it empty, I want to shows the url ...
0
votes
3answers
48 views

Creating a nested array with looping in PHP and MySQL

I have 2 MySQL tables, where I extract data with following SQL statements: Categories: SELECT cat_id, cat_name FROM categories Products: SELECT pro_id, pro_name, pro_category FROM products Of ...

1 2 3 4 5 13
15 30 50 per page