Tagged Questions
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 ...