How to go to an end of recordset using php?

Question

Here is the code:

<?php
  require'connection.php';

  $cons = mysql_query( 'SELECT Subject FROM tblsubject' );

  $total_rows = mysql_num_rows($cons);
  $counter = 0;
  $fields="";
  while($row = mysql_fetch_array($cons)) {
    if(++$counter == $total_rows) {
$fields .= $row['Subject']. ': { <br/> title: \''.$row['Subject'].'\',<br/> width:     \'20% \' <br/>}<br/>';
  }
  else {
$fields =  $row['Subject'].': { <br/> title: \''.$row["Subject"].'\',<br/> width:    \'20% \' <br/>},<br/>';
   }
  }

  echo $fields;
?>

The code stated above should produce an output like this below:

General: {
  title:'General',
  width: '20%',
},
Math: {
  title:'Math',
  width: '20%',
}

But if the query reaches its last row, the "," should be omitted after the last "}". I'm getting it right but when I echo it outside the while loop, only the two last row on the database are echoed.

Can someone help me with this? Please tell me where I am going wrong. Thank you very much :D I need to echo all the data in the table not just the final two.

score 1 · Accepted Answer · answered Feb 05 '14 at 03:25

1

Don't even bother with a complicated state checker. Just build an array and then implode it. Automatic "proper" number of commas.

while($row = mysql_fetch_array()) {
    $array[]= $row['data_you_want'];
}
echo implode(',', $array);

answered Feb 05 '14 at 03:25

Marc B

356,200
43
426
500

wow! this is great it real does solve my problem .. Thank you very much for this, it really solved my problem.. I'm just a beginner in php and still not familiar with all its functions .. thank you again :D – Nixxhalle Feb 05 '14 at 03:46
By the way, can use this if i'm going to put this on the query for example: the normal query is like this: msqyli_query(Science,Math,general)values('sometext',etc).. can i use the $array like this: msqyli_query( " ',',$array?? " )values('sometext',etc).. thanks :D – Nixxhalle Feb 05 '14 at 04:05

score 0 · Answer 2 · edited May 23 '17 at 12:03

You could try something like this:

$print = '';
while($row = mysql_fetch_array($cons)) {
    $row_subject_array[] = $row['Subject'];
}

for($i = 0; $i < count($row_subject_array); $i++) {
    $print .= $row_subject_array[$i]. ': { <br/> title: \''.$row_subject_array[$i].'\',<br/> width:     \'20% \' <br/>},';
}
$print = rtrim($print, ',');

echo "<br />";

Also a little suggestion: You should stop of use mysql_x() functions. These functions are deprecated, instead of it you can use mysqli_x() function or PDO.

Why shouldn't I use mysql_* functions in PHP?

score 0 · Answer 3 · answered Feb 05 '14 at 03:41

Hello and Welcome to Stack Overflow!

First of all you should avoid using the mysql class and use mysqli as mysql has been deprecated.

Now for your question, If your MySQL table has an ID column with Auto Increment enabled then you can do this:

SELECT id FROM table ORDER BY id DESC LIMIT 1

However if you want to achieve the same result then I would format my code in the following way:

$cons = mysql_query( 'SELECT Subject FROM tblsubject' );

$fieldsArray = array();

while($row = mysql_fetch_array($cons)) {
    array_push($fields_array,$row['Subject']. ': { <br/> title: \''.$row['Subject'].'\',<br/> width:     \'20% \' <br/>},<br/>');
}

array_pop($fieldsArray);

array_push($fieldsArray,$row['Subject']. ': { <br/> title: \''.$row['Subject'].'\',<br/> width:     \'20% \' <br/>}<br/>');

foreach($fieldsArray as $value) {
    echo $value;
}

tada!

score 0 · Answer 4 · answered Feb 05 '14 at 05:28

0

i always do:

 $var = substr($var,0,-1);

 echo $var; //or whatever

answered Feb 05 '14 at 05:28

bart2puck

2,432
3
27
53

How to go to an end of recordset using php?

4 Answers4