StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POPHP How to fix this strange UNDEFINED OFFSET error?
primarykey
Id
15856851
data
AcceptedAnswerId
15856887
AnswerCount
2
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2013-04-06T22:42:13.193
FavoriteCount
1
LastActivityDate
2013-04-06T22:55:21.687
LastEditDate
2013-04-06T22:55:21.687
LastEditorUserId
1085050
OwnerUserId
1085050
ParentId
0
PostTypeId
1
Score
0
ViewCount
10278
LastEditorDisplayName
text
Body
Ok here is my model, which returns everything to my controller and forwarded to my view. I get the correct row output but I also get this strange undefined offset error. model <pre><code>function getAllCustomersPendingInstall() { $data=array(); //Need to use sessions to display proper //records for each user. Temp set id to user #7 $id = 7; //query the db and return all record where SalesRepId == $id $query = $this->db->get_where('customers', array('SalesRepId' => $id)); //check logic, if rows exist RETURN all rows, else //return message that no pending installs is available. if($query->num_rows >= 0) { foreach($query->result() as $row) { $data['cFirstName'][] = $row->customerFirstName; $data['cLastName'] [] = $row->customerLastName; $data['cId'][] = $row->customerId; $data['cStatus'][] = $row->customerStatus; $data['cDateSold'][] = $row->customerDateSold; $data['cCorp'][] = $row->customerCorp; $data['cAccount'][] = $row->customerAccount; $data['cAddress'] [] = $row->customerAddress; $data['cAptNum'][] = $row->customerCity; $data['cState'][] = $row->customerState; $data['cZip'][] = $row->customerZip; $data['cEmail'][] = $row->customerEmail; $data['cHomePhone'][] = $row->customerHomePhone; $data['cCellPhone'][] = $row->customerCellPhone; $data['cInstallDate'][] = $row->customerInstallDate; $data['cInstallTime'][] = $row->customerInstallTime; $data['cServiceLevelSold'][] = $row->customerServiceLevelSold; $data['cWinBackFrom'][] = $row->customerWinBackFrom; $data['cSaleSource'][] = $row->customerSaleSource; $data['cTier'][] = $row->customerTier; $data['mySalesRepId'][] = $row->SalesRepId; } } else { $data = "No pending installs available!"; return $data; } //the following var_dump is only showing the last record. //need to show all rows (which should be 2) //var_dump($data); exit; return $data; } </code></pre> view <pre><code> <?php $dataNumRows = count($optimum); ?> <?php for ($i = 0; $i < $dataNumRows; $i++) : ?> <?php echo $optimum['cFirstName'][$i]; ?> <?php echo $optimum['cLastName'][$i]; ?> <?php echo $optimum['cId'][$i]; ?> <?php echo $optimum['cStatus'][$i]; ?> <?php echo $optimum['cDateSold'][$i]; ?> <?php echo $optimum['cCorp'][$i]; ?> <?php echo $optimum['cAccount'][$i]; ?> <?php echo $optimum['cAddress'][$i]; ?> <?php echo $optimum['cAptNum'][$i]; ?> <?php echo $optimum['cState'][$i]; ?> <?php echo $optimum['cZip'][$i]; ?> <?php echo $optimum['cEmail'][$i]; ?> <?php echo $optimum['cHomePhone'][$i]; ?> <?php echo $optimum['cCellPhone'][$i]; ?> <?php echo $optimum['cInstallDate'][$i]; ?> <?php echo $optimum['cInstallTime'][$i]; ?> <?php echo $optimum['cServiceLevelSold'][$i]; ?> <?php echo $optimum['cWinBackFrom'][$i]; ?> <?php echo $optimum['cSaleSource'][$i]; ?> <?php echo $optimum['cTier'][$i]; ?> <?php echo $optimum['mySalesRepId'][$i]; ?> <?php endfor; ?> </code></pre> The webpage is displaying my data correctly but then it shows this undefined output error <pre><code>Tom Jones 1 4 02/11/2013 77 895482 1823 e15th St Brooklyn NY 11268 tones728@verizon.net 0000000000 0000000000 02/16/2013 1 11 1 1 1 7 Alexa Planter 2 4 02/13/2013 77 632584 5847 w79th Ave Brooklyn NY 11258 aplanter222@gmail.com 0000000000 0000000000 02/22/2013 1 31 1 1 2 7 A PHP Error was encountered Severity: Notice Message: Undefined offset: 2 Filename: views/welcome_message.php Line Number: 29 A PHP Error was encountered Severity: Notice Message: Undefined offset: 2 Filename: views/welcome_message.php Line Number: 30 .... repeated to line 49 </code></pre> Here is the lines causing the error: <pre><code>29| <?php echo $optimum['cFirstName'][$i]; ?> 30| <?php echo $optimum['cLastName'][$i]; ?> ..| <?php echo $optimum['cId'][$i]; ?> <?php echo $optimum['cStatus'][$i]; ?> <?php echo $optimum['cDateSold'][$i]; ?> <?php echo $optimum['cCorp'][$i]; ?> <?php echo $optimum['cAccount'][$i]; ?> <?php echo $optimum['cAddress'][$i]; ?> <?php echo $optimum['cAptNum'][$i]; ?> <?php echo $optimum['cState'][$i]; ?> <?php echo $optimum['cZip'][$i]; ?> <?php echo $optimum['cEmail'][$i]; ?> <?php echo $optimum['cHomePhone'][$i]; ?> <?php echo $optimum['cCellPhone'][$i]; ?> <?php echo $optimum['cInstallDate'][$i]; ?> <?php echo $optimum['cInstallTime'][$i]; ?> <?php echo $optimum['cServiceLevelSold'][$i]; ?> <?php echo $optimum['cWinBackFrom'][$i]; ?> <?php echo $optimum['cSaleSource'][$i]; ?> ..| <?php echo $optimum['cTier'][$i]; ?> 49| <?php echo $optimum['mySalesRepId'][$i]; ?> </code></pre>
Tags
<php><codeigniter>
Title
PHP How to fix this strange UNDEFINED OFFSET error?
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USfabbb
UserOwnerUserId
1. USfabbb
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POPHP How to fix this strange UNDEFINED OFFSET error?
 UserUserId
 USfabbb
 VoteTypeVoteTypeId
 VTFavorite
CommentsPostId
1. COCan you make the line visible which is causing this error
 singulars
 PostPostId
 POPHP How to fix this strange UNDEFINED OFFSET error?
 UserUserId
 USDaryl Gill

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.