PHP script to read from database

Question

I have a database named teste with a table called exemplo with 2 columns (id, nome): Want a php script to select all the information in the nome column, and echo that information and place them in a txt file. What's wrong in the code? I can only see the first value and not the second.. And with an infinite loop!

$link = mysql_connect('localhost', 'root', '123');
if (!$link) {
  die('Could not connect: ' . mysql_error());
}

mysql_select_db('teste', $link);

/* Desired */
$file = fopen("myfile.txt","w");

$result = mysql_query("SELECT * FROM exemplo");
$array = mysql_fetch_array($result);
while ($array) {
  echo $array['nome'];

  fputs($file ,$array['nome']); 
}

mysql_close($link);

Marc B · Accepted Answer · 2011-05-17 15:34:32Z

3

    $array = mysql_fetch_array($result);

This only fetches one row of results. It doesn't stuff the entire result set into your array. You need to do:

while($row = mysql_fetch_array($result)) {
   echo $row['nome'];
   fputs($file, $row['nome']);
}

answered May 17, 2011 at 15:34

Marc B

362k44 gold badges433 silver badges508 bronze badges

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

Comments

onteria_ · Accepted Answer · 2011-05-17 15:34:40Z

0

That's because mysql_fetch_array only returns one result at a time, so $array is always true. You want this:

while ($array = mysql_fetch_array($result)) {
  echo $array['nome'];
  fputs($file ,$array['nome']); 
}

answered May 17, 2011 at 15:34

onteria_

70.9k7 gold badges73 silver badges64 bronze badges

1 Comment

aocferreira Over a year ago

and to add a new line and not see line1line2 in a row?

tim · Accepted Answer · 2011-05-17 15:33:57Z

0

You assign $array once and than loop over it in while($array) so this keeps running and running as $array is unchanged! Try changing your code like that:

<?php

        $link = mysql_connect('localhost', 'root', '123');
        if (!$link) {
                die('Could not connect: ' . mysql_error());
        }

        mysql_select_db('teste', $link);

        /* Desired */

        $file = fopen("myfile.txt","w");

        $result = mysql_query("SELECT * FROM exemplo");
        while ($array = mysql_fetch_array($result)) {
        echo $array['nome'];

        fputs($file ,$array['nome']); }
        mysql_close($link);
?>

answered May 17, 2011 at 15:33

tim

10.1k22 gold badges88 silver badges146 bronze badges

1 Comment

Michael Berkowski Over a year ago

Remove the ; from the while loop condition. while ($array = mysql_fetch_array($result);)

castis · Accepted Answer · 2011-05-17 15:35:53Z

0

This should work. you were leaving fputs out of the data loop.

<?php

$link = mysql_connect('localhost', 'root', '123');
if (!$link) {
    die('Could not connect: ' . mysql_error());
}
mysql_select_db('teste', $link);

/* Desired */

$file = fopen("myfile.txt","w");

$result = mysql_query("SELECT * FROM exemplo");
while($array = mysql_fetch_array($result))
{
    echo $array['nome'];
    fputs($file, $array['nome'] ."\n");
}

mysql_close($link);

answered May 17, 2011 at 15:35

castis

8,2144 gold badges45 silver badges66 bronze badges

Comments

Mat · Accepted Answer · 2011-05-17 15:41:13Z

0

mysql_fetch_array returns a single row. You need to call it in a loop:

while ($array = mysql_fetch_array($result)) {
    echo $array['nome'], "\n";
    // do more stuff
}

edited May 17, 2011 at 15:41

answered May 17, 2011 at 15:34

Mat

208k41 gold badges407 silver badges423 bronze badges

2 Comments

aocferreira Over a year ago

and to add a new line and not see line1line2 in a row?

Mat Over a year ago

for that you need to add a line separator yourself

Collectives™ on Stack Overflow

PHP script to read from database

5 Answers 5

Comments

1 Comment

1 Comment

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

1 Comment

1 Comment

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related