Styjun

Network Switch Upgrade Planning questions

Import keychain to clean macOS install?

How do I overlay a PNG over two videos (one video overlays another) in one command using FFmpeg?

Can I ask an author to send me his ebook?

Is it OK if I do not take the receipt in Germany?

When does Bran Stark remember Jamie pushing him?

Protagonist's race is hidden - should I reveal it?

Why did Israel vote against lifting the American embargo on Cuba?

Why do people think Winterfell crypts is the safest place for women, children & old people?

Putting Ant-Man on house arrest

Can Deduction Guide have an explicit(bool) specifier?

How can I introduce the names of fantasy creatures to the reader?

What's the connection between Mr. Nancy and fried chicken?

Weaponising the Grasp-at-a-Distance spell

Does the Pact of the Blade warlock feature allow me to customize the properties of the pact weapon I create?

Is "ein Herz wie das meine" an antiquated or colloquial use of the possesive pronoun?

Trying to enter the Fox's den

Do chord progressions usually move by fifths?

Can this water damage be explained by lack of gutters and grading issues?

Converting a text document with special format to Pandas DataFrame

Can the van der Waals coefficients be negative in the van der Waals equation for real gases?

What is the evidence that custom checks in Northern Ireland are going to result in violence?

Like totally amazing interchangeable sister outfit accessory swapping or whatever

What were wait-states, and why was it only an issue for PCs?

Converting PDO resultset array to string

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

0

I have a class that retrieves a result set from a database. The result is wrapped in arrays which are then stored as session variables as shown in the code

 $days = array();
 $amount = array();
 $commission = array();

foreach ($result as $row) {
 array_push($days,$row['sales_day']);
 array_push($amount,$row['sales_total']);
 array_push($commission,$row['sales_comm']);
 $_SESSION['days'] = $days;
 $_SESSION['amount'] = $amount;
 $_SESSION['commission'] = $commission;

I then attempt to display the data in HTML table as in this code:

<tr>
 <td><label><?php print_r($_SESSION['days']); ?></label></td>
 <td><label><?php print_r ($_SESSION['amount']); ?></label></td>
 <td><label><?php print_r($_SESSION['commission']); ?></label></td>
</tr>

The problem is that the output is something like: array[0] => 1. But I want only the values retrieved from the database to display and not the array indices.

php html resultset

share|improve this question

edited Mar 22 at 13:59

marc_s

586k13011281273

asked Mar 3 at 7:07

ZeekstemZeekstem

266

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  If print_r shows that, it means that's what $row['sales_day'] (and others) contained to begin with. You're gonna have to show more code than that.
  
  – Jeto
  Mar 3 at 7:13
  
  

  
  
  
  


• 
  
  
  

  
  2
  

  
  
  
  
  
  

  
  
  print_r is intended to output the structure of data, not as a user friendly table output. You'll need to iterate the data to output the individual values, probably each in their own <td>, like done here. NB: the use of session variables seems irrelevant to your question?
  
  – trincot
  Mar 3 at 7:30
  

  
  
  
  

add a comment | 

0

I have a class that retrieves a result set from a database. The result is wrapped in arrays which are then stored as session variables as shown in the code

 $days = array();
 $amount = array();
 $commission = array();

foreach ($result as $row) {
 array_push($days,$row['sales_day']);
 array_push($amount,$row['sales_total']);
 array_push($commission,$row['sales_comm']);
 $_SESSION['days'] = $days;
 $_SESSION['amount'] = $amount;
 $_SESSION['commission'] = $commission;

I then attempt to display the data in HTML table as in this code:

<tr>
 <td><label><?php print_r($_SESSION['days']); ?></label></td>
 <td><label><?php print_r ($_SESSION['amount']); ?></label></td>
 <td><label><?php print_r($_SESSION['commission']); ?></label></td>
</tr>

The problem is that the output is something like: array[0] => 1. But I want only the values retrieved from the database to display and not the array indices.

php html resultset

share|improve this question

edited Mar 22 at 13:59

marc_s

586k13011281273

asked Mar 3 at 7:07

ZeekstemZeekstem

266

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  If print_r shows that, it means that's what $row['sales_day'] (and others) contained to begin with. You're gonna have to show more code than that.
  
  – Jeto
  Mar 3 at 7:13
  
  

  
  
  
  


• 
  
  
  

  
  2
  

  
  
  
  
  
  

  
  
  print_r is intended to output the structure of data, not as a user friendly table output. You'll need to iterate the data to output the individual values, probably each in their own <td>, like done here. NB: the use of session variables seems irrelevant to your question?
  
  – trincot
  Mar 3 at 7:30
  

  
  
  
  

add a comment | 

I have a class that retrieves a result set from a database. The result is wrapped in arrays which are then stored as session variables as shown in the code

 $days = array();
 $amount = array();
 $commission = array();

foreach ($result as $row) {
 array_push($days,$row['sales_day']);
 array_push($amount,$row['sales_total']);
 array_push($commission,$row['sales_comm']);
 $_SESSION['days'] = $days;
 $_SESSION['amount'] = $amount;
 $_SESSION['commission'] = $commission;

I then attempt to display the data in HTML table as in this code:

<tr>
 <td><label><?php print_r($_SESSION['days']); ?></label></td>
 <td><label><?php print_r ($_SESSION['amount']); ?></label></td>
 <td><label><?php print_r($_SESSION['commission']); ?></label></td>
</tr>

The problem is that the output is something like: array[0] => 1. But I want only the values retrieved from the database to display and not the array indices.

php html resultset

share|improve this question

edited Mar 22 at 13:59

marc_s

586k13011281273

asked Mar 3 at 7:07

ZeekstemZeekstem

266

 $days = array();
 $amount = array();
 $commission = array();

foreach ($result as $row) {
 array_push($days,$row['sales_day']);
 array_push($amount,$row['sales_total']);
 array_push($commission,$row['sales_comm']);
 $_SESSION['days'] = $days;
 $_SESSION['amount'] = $amount;
 $_SESSION['commission'] = $commission;

<tr>
 <td><label><?php print_r($_SESSION['days']); ?></label></td>
 <td><label><?php print_r ($_SESSION['amount']); ?></label></td>
 <td><label><?php print_r($_SESSION['commission']); ?></label></td>
</tr>

share|improve this question

edited Mar 22 at 13:59

marc_s

586k13011281273

asked Mar 3 at 7:07

ZeekstemZeekstem

266

share|improve this question

edited Mar 22 at 13:59

marc_s

586k13011281273

asked Mar 3 at 7:07

ZeekstemZeekstem

266

edited Mar 22 at 13:59

marc_s

586k13011281273

edited Mar 22 at 13:59

marc_s

586k13011281273

asked Mar 3 at 7:07

ZeekstemZeekstem

266

asked Mar 3 at 7:07

ZeekstemZeekstem

266

1 Answer
1

active

oldest

votes

1

I've considered that you need to save data in a part of your code and print them somewhere else.

if at the first step you want to save all items into $_SESSION and then show them in next steps, use this code:

the first step:

$merged_data = array();
foreach ($result as $row) 
 $merged_data[] = array(
 'sales_day' => $row['sales_day'],
 'sales_total' => $row['sales_total'],
 'sales_comm' => $row['sales_comm']
 );

$_SESSION['merged_data'] = $merged_data;

the second step: (somewhere else in your code)

<?php foreach ($_SESSION['merged_data'] as $data) ?>
 <td><label><?= $data['days']; ?></label></td>
 <td><label><?= $data['amount']; ?></label></td>
 <td><label><?= $data['commission']; ?></label></td>
<?php ?>

share|improve this answer

answered Mar 3 at 7:58

soheil yosoheil yo

3431126

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks a lot @sohiel. I used your code as is and it worked perfectly. But note that the variables in $data are: sales_day, sales_amount, sales_comm. Thanks again. I am very grateful
  
  – Zeekstem
  Mar 3 at 8:49
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @Zeekstem your welcome, you can select the answer as the accepted answer if it solved your problem
  
  – soheil yo
  Mar 4 at 14:51
  
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54966433%2fconverting-pdo-resultset-array-to-string%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

1

I've considered that you need to save data in a part of your code and print them somewhere else.

if at the first step you want to save all items into $_SESSION and then show them in next steps, use this code:

the first step:

$merged_data = array();
foreach ($result as $row) 
 $merged_data[] = array(
 'sales_day' => $row['sales_day'],
 'sales_total' => $row['sales_total'],
 'sales_comm' => $row['sales_comm']
 );

$_SESSION['merged_data'] = $merged_data;

the second step: (somewhere else in your code)

<?php foreach ($_SESSION['merged_data'] as $data) ?>
 <td><label><?= $data['days']; ?></label></td>
 <td><label><?= $data['amount']; ?></label></td>
 <td><label><?= $data['commission']; ?></label></td>
<?php ?>

share|improve this answer

answered Mar 3 at 7:58

soheil yosoheil yo

3431126

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks a lot @sohiel. I used your code as is and it worked perfectly. But note that the variables in $data are: sales_day, sales_amount, sales_comm. Thanks again. I am very grateful
  
  – Zeekstem
  Mar 3 at 8:49
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @Zeekstem your welcome, you can select the answer as the accepted answer if it solved your problem
  
  – soheil yo
  Mar 4 at 14:51
  
  

  
  
  
  

add a comment | 

1

I've considered that you need to save data in a part of your code and print them somewhere else.

if at the first step you want to save all items into $_SESSION and then show them in next steps, use this code:

the first step:

$merged_data = array();
foreach ($result as $row) 
 $merged_data[] = array(
 'sales_day' => $row['sales_day'],
 'sales_total' => $row['sales_total'],
 'sales_comm' => $row['sales_comm']
 );

$_SESSION['merged_data'] = $merged_data;

the second step: (somewhere else in your code)

<?php foreach ($_SESSION['merged_data'] as $data) ?>
 <td><label><?= $data['days']; ?></label></td>
 <td><label><?= $data['amount']; ?></label></td>
 <td><label><?= $data['commission']; ?></label></td>
<?php ?>

share|improve this answer

answered Mar 3 at 7:58

soheil yosoheil yo

3431126

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks a lot @sohiel. I used your code as is and it worked perfectly. But note that the variables in $data are: sales_day, sales_amount, sales_comm. Thanks again. I am very grateful
  
  – Zeekstem
  Mar 3 at 8:49
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @Zeekstem your welcome, you can select the answer as the accepted answer if it solved your problem
  
  – soheil yo
  Mar 4 at 14:51
  
  

  
  
  
  

add a comment | 

I've considered that you need to save data in a part of your code and print them somewhere else.

if at the first step you want to save all items into $_SESSION and then show them in next steps, use this code:

the first step:

$merged_data = array();
foreach ($result as $row) 
 $merged_data[] = array(
 'sales_day' => $row['sales_day'],
 'sales_total' => $row['sales_total'],
 'sales_comm' => $row['sales_comm']
 );

$_SESSION['merged_data'] = $merged_data;

the second step: (somewhere else in your code)

<?php foreach ($_SESSION['merged_data'] as $data) ?>
 <td><label><?= $data['days']; ?></label></td>
 <td><label><?= $data['amount']; ?></label></td>
 <td><label><?= $data['commission']; ?></label></td>
<?php ?>

share|improve this answer

answered Mar 3 at 7:58

soheil yosoheil yo

3431126

$merged_data = array();
foreach ($result as $row) 
 $merged_data[] = array(
 'sales_day' => $row['sales_day'],
 'sales_total' => $row['sales_total'],
 'sales_comm' => $row['sales_comm']
 );

$_SESSION['merged_data'] = $merged_data;

<?php foreach ($_SESSION['merged_data'] as $data) ?>
 <td><label><?= $data['days']; ?></label></td>
 <td><label><?= $data['amount']; ?></label></td>
 <td><label><?= $data['commission']; ?></label></td>
<?php ?>

share|improve this answer

answered Mar 3 at 7:58

soheil yosoheil yo

3431126

answered Mar 3 at 7:58

soheil yosoheil yo

3431126

answered Mar 3 at 7:58

soheil yosoheil yo

3431126