dynamic tables question

dreams4000

hey all.. I have a dynamic table being generated from the code below. basically makes a excel like table based off input by someone. I have it running up to a 15x15 table and can store that data in the mysql database. My two header items below work perfect.. The data part works perfect when editing the form and having it insert the data, but now im trying to display the data and it isnt working right. Maybe someone can take a look and see something i am not.

What it is doing is outputing the side headers and top headers fine, but then data I have 0 thru 224 each stored in the database.
Instead of putting 0 thru 14 on the first row, 15 thru 29 on the second row etc.. it is just puting 0 thru 14 on every row. I know it is a looping issue but I can't seem to see it.. Any help? (The variables $columns2 & $rows2 each = 15)


	echo "<table width=100%><td></td>";

//Loops thru the top headers and displays them.			
for($j = 0; $j < $columns2; $j++) {
		$table_head = "build_tp_custom_case_header_top$j";
		$header_top12 = $tp_custom_caseDetail->$table_head;
		$header_top13 = $header_top12[0];

echo "<td>$header_top13</td>";
}

//end of top headers

//Loops thru the side headers, making a row	

for($i = 0; $i < $rows2; $i++)
{
	$table_side = "build_tp_custom_case_header_side$i";
	$header_side12 = $tp_custom_caseDetail->$table_side;
$header_side13 = $header_side12[0];
echo "<tr><td>$header_side13</td>";


   //Loops thru the data fields making a column for each field up to the column specification.
		for($j = 0; $j < $columns2; $j++) {


	$table_data = "build_tp_custom_case_data$j";
	$data12 = $tp_custom_caseDetail->$table_data;
	$data13 = $data12[0];


echo "<td>$data13</td>";

        }
//end data

}
//end side headers


echo "</table><table>";

I can see why it is looping and doing 0 thru 14 over and over, but not sure how to get it to stop at 14 on the first row, then start at 15 on the second row, and so on thru all 15 rows(or less if specified).. anyone have any ideas? Thanks so much!

dreams4000

No ideas? I am more than happy to explain the code further if it is needed. It looks just like some looping issue. Any thoughts are welcome🙂 Thanks all

tekky

my suggestion... and im sure its not the most efficicent but I would do it this way

loop through the DB and build yourself an array[14][14]

so you have 0-14 down and across giving you a 15x15 square

once you have the array build, a simple foreach loop would display it all

very simple and no complex stuff to it 🙂

dreams4000

not quite sure how to pull that one off with this setup🙁 No ideas on keeping it in a similar setup as above?

tekky

how do you currently have it reading the data and how does the table schema look?

dreams4000

Hi there, currently I have one field in the database for each of the possible fields in a 15x15 table (as that is the max this form allows) I wanted an easy way to access any particulars within that table without having to put all 200+ fields into an array and sort them out from there. I am sure it probably isnt the best way, but it works for how I need. Right now, the data read is what is in the code above. The headers for the side and top read just fine.. the data reads fine up to the first row.... or.. the entire data list but all on one row (with some minor changes to the code above).. I just need it to give a new row for each 15 of data so they match up with the headers.

I could just hardcode a specification for every single database field in there and just display that, but that is a huge amount of code for something that should be able to loop like I have the headers doing:\ just cant get it to display right.. I do thank you for your help with this!🙂

tekky

well without seeing how you read the data from the database, I can say that you will need 2 for loops to traverse the data something like

for($i=0;$i<15;$i++)
{
  for($j=0;$j<15;$j++)
  {
     echo "This is data for row $i column $j: " . $data[$i][$j];
     //or like this (which is most likely how you need
     echo "This is data from row $i column $j: " . $datarow[$j];
  }
}

dreams4000

The query is just a where $id = some particular row id #.

The database itself is just a table with a data1,data2,data3,data4.......data250 fields in it.. Each one will have a value based on input from this dynamic table that I have built. So, from that.. it should output like:

                     Top Header 1       Top Header 2     Top Header 3

Side Header 1 Data1 Data2 Data3
Side Header 2 Data 4 Data 5 Data6

etc... but instead of outputing the datafields as such.. it is either doing all of the data fields across one row (where side header 1 is) out to the full length of the 200+ fields.. Or.. with the code in this post, it is simply putting data1 thru 15 for each row instead of starting at 16 on the second row and 31 on the third row.. etc. The code you just posted is pretty much what is already there.

  for($i = 0; $i < $rows2; $i++) 
    { 
        $table_side = "build_tp_custom_case_header_side$i"; 
        $header_side12 = $tp_custom_caseDetail->$table_side; 
$header_side13 = $header_side12[0]; 
echo "<tr><td>$header_side13</td>"; 


   //Loops thru the data fields making a column for each field up to the column specification. 
        for($j = 0; $j < $columns2; $j++) { 


    $table_data = "build_tp_custom_case_data$j"; 
    $data12 = $tp_custom_caseDetail->$table_data; 
    $data13 = $data12[0]; 


echo "<td>$data13</td>"; 

        } 
//end data 

} 
//end side headers

is the same thing. 🙁

tekky

try this then... dynamic increments 😉

  for($i = 0; $i < $rows2; $i++) 
    { 
        $table_side = "build_tp_custom_case_header_side$i"; 
        $header_side12 = $tp_custom_caseDetail->$table_side; 
$header_side13 = $header_side12[0]; 
echo "<tr><td>$header_side13</td>"; 


   //Loops thru the data fields making a column for each field up to the column specification. 
        for($j = 0; $j < $columns2; $j++) { 


    $table_data = 'build_tp_custom_case_data' . $i *15 + $j; 
    $data12 = $tp_custom_caseDetail->$table_data; 
    $data13 = $data12[0]; 


echo "<td>$data13</td>"; 

        } 
//end data 

} 
//end side headers

I didnt notice your for($i) loop up there... that should easily solve your problem 😉

dreams4000

When I tried the change, no data displayed. But I can see why not. In the code before, it had:

$table_data = "build_tp_custom_case_data$j";

The data$j is what is specifying the table's field. for example $j may be data1 or data5 etc based on the incriment. The problem lies in that $columns2 only goes up to 15.. so thus only up to data15. If I change columns2 to 225, then data goes up to data1 thru data225 since 225 is the max for $j in that case. (but then it outputs all 225 on one single row without breaking it after every 15.

Your new code:


$table_data = 'build_tp_custom_case_data' . $i *15 + $j;

takes out the data$j part, so it doesnt know that the column in mysql is called data1 data2 data3 etc.. correctly.. as even if it was the first data point 1*15 +1 would give data16.. (though no data is displaying off the above setup so im not sure how that is workin)

tekky

Dump your array using print_r() and <pre> tags around it to verify that you are getting the correct data in your vars