Missing array elements

571 Contributor

I initialize an array with "$this->colArray = array_fill(0, 11, array_fill(0, 22, " "));" to create a two dimensional array ( an array of arrays) of blank HTML tags so I can display a complete table even if I do not fill in all the cells in the table.

Then I loop through my data and fill in the table cells.

The row data from the query is transposed so rows become columns in the array.

For some reason when I have less than a full page worth of data, some of the blank cells (not all) in the columns with no data in the array are deleted. In the table columns with no data rows below 5 are deleted. (see sample photo of results)

If I comment out the section where the data is loaded into the array then every column has missing cells.

My thought was I was reading the coordinates wrong, but that does not make sense as the data that is displayed are in the correct cells when I have a full page.

Am I reading the array incorrectly or what else could be deleting the array elements.

Here is my code, I have bolded what I think is the relevant text.

Expand|Select|Wrap|Line Numbers

 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<?php

try   

{

...some query code...
 
    if ( $result = $db->query($sql) )

    {

        if ( $result->num_rows > 0)

        {

?>

            <html>

                <head>

                    <title>Printable Soil Boring Samples</title>
 
                </head>
 
                <body>

                    <form>
 
<?php

                    $cPageCnt = 1;

                    $cRecCnt = 0;

                    $cBoring = '';
 
                    while ($row = $result->fetch_array()) 

                    {
 
                        $cRecCnt ++;
 
                        if (!isset($pObj)){

                            //set boring flag

                            $cBoring = $row["boring"];
 
                            //create page object if not exists

                            $pObj = new pageObject($row, $cPageCnt);

                            $pObj->loadRow($row, $cRecCnt);
 
                        }else if($cBoring != $row["boring"] or $cRecCnt > 10){
 
                            //print page object if new boring or record count has exceeded page

                            $pObj->printPage();
 
                            //insert page break

                            echo '<span class="newPage"></span>';
 
                            //re-initilize control variables
 
                            //reset record counter

                            $cRecCnt = 1;
 
                            //reset boring flag

                            $cBoring = $row["boring"];
 
                            //destroy page object

                            unset($pObj);
 
                            //advace page count

                            $cPageCnt ++;
 
                            //create new page object

                            $pObj = new pageObject($row, $cPageCnt);

                            $pObj->loadRow($row, $cRecCnt);
 
                        }else{

                            //add row data to page object

                            $pObj->loadRow($row, $cRecCnt);

                        }

                    }
 
                    if (isset($pObj)){

                        //some data is left to print

                        $pObj->printPage();
 
                        //destroy page object

                        unset($pObj);

                    }
 
?>

                    </form>

                </body>

            </html>

<?php

        }

    }

}
 
catch (exception $e) 

{

    echo 'An error occured : ' .$e->getMessage();

}
 
class pageObject

{

    //properties

    public $jobId;

    public $boring;

    public $date;

    public $page;

    public $project;

    public $client;

    public $engineer;

    public $webUser;
 
    //detail sample infor for boring

    public $colArray;
 
    //methods

    public function __construct( $row, $cPageCnt ) {
 
        //page header info for specific boring

        $this->jobId    = $row["jobid"];

        $this->boring    = $row["boring"];

        $this->date    = $row["sampleDate"];

        $this->page    = $cPageCnt;

        $this->project    = $row['prjctname'];

        $this->client    = $row['name'];

        $this->engineer    = $row['engineer'];

        $this->webUser    = trim($row['webUser']);
 
        //detail sample infor for boring
 
        $this->colArray = array_fill(0, 11, array_fill(0, 22, "&nbsp;"));

        /*

        -------------------

        fill in row headers 

        -------------------

        */

        $this->colArray[0][0]  = "Boring";                                            

        $this->colArray[1][0]  = "Sample #";                                          

        $this->colArray[2][0]  = "Depth in Feet";                                     

        $this->colArray[3][0]  = "No. of Blows";                                      

        $this->colArray[4][0]  = "Type";                                              

        $this->colArray[5][0]  = "Container Number";                                  

        $this->colArray[6][0]  = "Wet weight of<br/>Sample + Container";              

        $this->colArray[7][0]  = "Dry weight of<br/>Sample + Container";              

        $this->colArray[8][0]  = "Weight of container";"Percent moisture";            

        $this->colArray[9][0]  = "Percent moisture";                       

        $this->colArray[10][0] = "Weight of sample in air";                           

        $this->colArray[11][0] = "Weight of sample in water";                         

        $this->colArray[12][0] = "Weight of water";                                   

        $this->colArray[13][0] = "Disp. Dry unit weight in<br/>pounds per cubic foot";

        $this->colArray[14][0] = "Dim. Dry unit weight in<br/>pounds per cubic foot"; 

        $this->colArray[15][0] = "Dry unit scale weight";                             

        $this->colArray[16][0] = "Dimension<br/>(Diameter * Length)";                  

        $this->colArray[17][0] = "Qu (TSF)";                                          

        $this->colArray[18][0] = "Qu % failure";                                      

        $this->colArray[19][0] = "Qp (TSF)";                                          

        $this->colArray[20][0] = "Tv";                                                

        $this->colArray[21][0] = "Soil description"; 
 
    }                                
 
    public function loadRow($row, $cRecCnt){

        /*

        --------------------------------

        fill in columns with sample data

        --------------------------------

        */

        $this->colArray[0][$cRecCnt]  = ( empty($row["boring"] ))        ?"&nbsp;" :$row["boring"];

        $this->colArray[1][$cRecCnt]  = ( empty($row["sample"] ))        ?"&nbsp;" :$row["sample"];

        $this->colArray[2][$cRecCnt]  = ( empty($row["depth"] ))        ?"&nbsp;" :$row["depth"]; 

        $this->colArray[3][$cRecCnt]  = ( empty($row["blows"] ))        ?"&nbsp;" :$row["blows"];

        $this->colArray[4][$cRecCnt]  = ( empty($row["sampleType"] ))    ?"&nbsp;" :$row["sampleType"];

        $this->colArray[5][$cRecCnt]  = ( empty($row["contNumb"] ))        ?"&nbsp;" :$row["contNumb"];

        $this->colArray[6][$cRecCnt]  = ( $row['WWofSC'] == 0)            ?"&nbsp;" :$row['WWofSC'];

        $this->colArray[7][$cRecCnt]  = ( $row['DWofSC'] == 0)            ?"&nbsp;" :$row['DWofSC'];

        $this->colArray[8][$cRecCnt]  = ( $row['contWeight'] == 0)        ?"&nbsp;" :$row['contWeight'];

        $this->colArray[9][$cRecCnt]  = ( $row['moisture'] == 0)        ?"&nbsp;" :$row['moisture'];

        $this->colArray[10][$cRecCnt] = ( $row['sampleInAir'] == 0)        ?"&nbsp;" :$row['sampleInAir'];

        $this->colArray[11][$cRecCnt] = ( $row['sampleInWater'] == 0)    ?"&nbsp;" :$row['sampleInWater'];

        $this->colArray[12][$cRecCnt] = ( $row['water'] == 0)            ?"&nbsp;" :$row['water'];

        $this->colArray[13][$cRecCnt] = ( $row['dryUnit'] == 0)            ?"&nbsp;" :$row['dryUnit'];

        $this->colArray[14][$cRecCnt] = ( $row['dimDryUnit'] == 0)        ?"&nbsp;" :number_format($row['dimDryUnit'], 1, '.', '');

        $this->colArray[15][$cRecCnt] = ( $row['dimWeight'] == 0)        ?"&nbsp;" :number_format($row['dimWeight'], 1, '.', '');

        $this->colArray[16][$cRecCnt] = ( $row["dimDiameter"] == 0)        ?"&nbsp;" :$row["dimDiameter"];

        $this->colArray[17][$cRecCnt] = ( empty($row["qu"] ))            ?"&nbsp;" :$row["qu"];

        $this->colArray[18][$cRecCnt] = ( empty($row["percentFail"] ))    ?"&nbsp;" :$row["percentFail"];

        $this->colArray[19][$cRecCnt] = ( empty($row["qp"] ))            ?"&nbsp;" :$row["qp"];

        $this->colArray[20][$cRecCnt] = ( empty($row["tv"] ))            ?"&nbsp;" :$row["tv"];

        $this->colArray[21][$cRecCnt] = ( empty($row["soilDesc"] ))        ?"&nbsp;" :$row["soilDesc"];
 
    }                                                                                  
 
    public function printPage(){

?>

        <table 

            bgcolor="#FFFFFF"

            width="100%"

        >

          <tr>

            <td colspan="2">Job #:<?php echo $this->jobId ?></td>

          </tr>

        </table> 

        <table border="1">

<?php

        for ($i=0; $i <= 21; $i++) {

            echo '<tr>';

            echo '<td>'.$this->colArray[$i][0].'</td>';

            echo '<td>'.$this->colArray[$i][1].'</td>';

            echo '<td>'.$this->colArray[$i][2].'</td>';

            echo '<td>'.$this->colArray[$i][3].'</td>';

            echo '<td>'.$this->colArray[$i][4].'</td>';

            echo '<td>'.$this->colArray[$i][5].'</td>';
 //fails below here when there is no data in column

                     echo '<td>'.$this->colArray[$i][6].'</td>';

            echo '<td>'.$this->colArray[$i][7].'</td>';

            echo '<td>'.$this->colArray[$i][8].'</td>';

            echo '<td>'.$this->colArray[$i][9].'</td>';

            echo '<td>'.$this->colArray[$i][10].'</td>';

            echo '</tr>';

        }
 
        echo '</table>';

    }

}

?>

Jul 9 '12 #1

Subscribe Reply

✓ answered by Claus Mygind

A simple error, I reversed the rows and columns on the array_fill().

The correct code is:

$this->colArray = array_fill(0, 22, array_fill(0, 11, " "));

1463

Claus Mygind

571

Contributor

A simple error, I reversed the rows and columns on the array_fill().

The correct code is:

$this->colArray = array_fill(0, 22, array_fill(0, 11, " "));

Jul 9 '12 #2

by: Herrcho | last post by:

in K&R Chapter 6.3 it mentions two methods to calculate NKEYS. and points out the first one which is to terminate the list of initializers with a null pointer, then loop along keytab until the...

C / C++

Using reflection to access array elements

by: trevorelbourne | last post by:

Hi, I am having trouble accessing the elements of an array using reflection. This is the code I am having trouble with: FieldInfo Fields = Obj.GetType().GetFields(); foreach (FieldInfo fi in...

C# / C Sharp

Expanded ReadOnly Array Elements in PropertyGrid

by: ljlevend2 | last post by:

If a property's type is an array and the property is exposed in a PropertyGrid, then the property can be expanded so that the user can view and edit the array elements. But, I've noticed that if...

Visual Basic .NET

Removing Array Elements

by: RyanTaylor | last post by:

I have a final coming up later this week in my beginning Java class and my prof has decided to give us possible Javascript code we may have to write. Problem is, we didn't really cover JS and what...

Javascript

Array elements

by: Kumar | last post by:

How should I declare the array elements being half word? and the array elements of the type byte in C?? Please help Kumar

C / C++

segmentation fault writing to array elements in structure

by: SP | last post by:

The following code crashes after I add the two nested FOR loops at the end, I am starting to learn about pointers and would like to understand what I'm doing wrong. I think the problem is the way...

C / C++

can preprocessor automatically make N array elements?

by: dan | last post by:

I would like to have the preprocessor automatically generate the number of array elements requested. Each element is zero. The elements get pasted into a larger array. The other elements may be...

C / C++

How to convert value of array elements to array address?

by: simply123 | last post by:

I doing doing C btw... i have been trying to convert array elements into their respective addresses but Im faced with many problems. eg. int x (array with 7 elements) im trying to set the...

C / C++

Finding Posistion of array elements

by: awaisworld13 | last post by:

I want to write a program which take input and save the poistions of the array elements in another array. let if i enter an array A= 4 A=1 A=2 A=3 now the output array will hold 1 2 3

C / C++

How to implement a byte * to point to structure of array elements

by: eran yurman | last post by:

H, I need to call an API with the follwoing prototype: unsigned long CountDevices (BYTE *p_deviceSize,BYTE *p_device ); I have no knowledge of the content of the API function itself but...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...

Networking - Hardware / Configuration

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

C# / C Sharp

Missing array elements

✓ answered by Claus Mygind

Similar topics