How can I retrieve data from a database using PHP?

Question

I have a problem with retrieving data from a database using PHP statements. At the moment the output looks like:

[{"Bez":"Cino"},{"Bez":"Extra"},{"Bez":"Panini"},{"Bez":"And so on"}]

"Bez" is the label of the column and we don't want it to be displayed. We just want to display the cell's contents so it should look like:

[Cino,Extra,Panini,And so on]

The php is:

<?php
  $username = "root";
  $database = "kaffeehaus";
  mysql_connect('localhost', $username);
  @mysql_select_db($database) or die("Geht nicht!");

  $query = "SELECT Bez FROM kategorie";
  $result = mysql_query($query) or die(mysql_error("error"));
  $num = mysql_numrows($result);

  mysql_close();

  $rows = array();
  while ($r = mysql_fetch_assoc($result))
  {
    $rows[] = $r;
  }

  echo json_encode($rows);
?>

Tim Čas · Accepted Answer · 2012-02-10 12:26:10Z

2

Replace

$rows[] = $r;

With

$rows[] = $r['Bez'];

...though to be honest, I'd replace the whole "fetch" part with:

while($r = mysql_fetch_row($result))
    $rows[] = $r[0];

That's because mysql_fetch_row is generally faster than mysql_fetch_assoc.

answered Feb 10, 2012 at 12:26

Tim Čas

11k3 gold badges30 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user1201884 Over a year ago

Thank you very much. It worked just like it should be ;) . CI

Radu Murzea · Accepted Answer · 2012-02-10 12:28:26Z

0

Replace

while ($r = mysql_fetch_assoc($result)) { $rows[] = $r; }

with this:

while ($r = mysql_fetch_array ($result, MYSQL_ASSOC)) { $rows[] = $r['Bez']; }

answered Feb 10, 2012 at 12:28

Radu Murzea

11k10 gold badges50 silver badges72 bronze badges

Comments

Quasdunk · Accepted Answer · 2012-02-10 12:28:54Z

0

Use mysql_fetch_row() instead (or mysql_fetch_array($result, MYSQL_NUM);). It fetches a numerical array so the column names are not shown.

Then, your output will look something like this:

[{"0":"Cino"},{"1":"Extra"},{"2":"Panini"},{"3":"And so on"}]

answered Feb 10, 2012 at 12:28

Quasdunk

15.2k3 gold badges39 silver badges47 bronze badges

Comments

equero · Accepted Answer · 2012-02-10 12:29:23Z

0

Remove the json_encode part:

echo json_encode($rows); ?>

And use bez as row key:

echo ($rows['bez']); ?>

answered Feb 10, 2012 at 12:29

equero

203 bronze badges

Comments

user1201884 · Accepted Answer · 2012-02-13 14:31:30Z

And how does it work if there are more than one cell?

Our php looks like

<?php
 $username = "root";
 $database = "kaffeehaus";
 mysql_connect('localhost', $username);
 @mysql_select_db($database) or die("Geht nicht!");

 $ID_Kategorie = $_GET["Kategorie"];

 $query = "SELECT * FROM artikel WHERE ID_Kategorie=$ID_Kategorie";


 $result=mysql_query($query) or die("error");
 $num = mysql_numrows($result);

 mysql_close();

 $rows = array();
 while ($r  = mysql_fetch_assoc($result))
 {
    $rows = $r;

 }
 echo json_encode($rows);    ?>

And the output like:

[{"ID_Artikel": "12","ID_Kategorie":"19","Bez":"blabla","Beschreibung":"blabla"}]

But it schould look like:

[{"12","19","blabla","blabla"}]

Collectives™ on Stack Overflow

How can I retrieve data from a database using PHP?

5 Answers 5

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related