ansaurus

Question

printing meaningless lines of text prevents page download, but too many lines prevent from getting all entries in a mysql table. Why?

Answer 1

A:

What webserver do you use? Apache? Are there any extesnions to PHP installed? Try putting flush() after echo to see whats happen. If you could show you phpinfo() it could help.

habicht 2010-01-06 21:17:57

Apache, actually it's xampp. I edited this in my original question. I also added the result of phpinfo.. Where is it you suggest adding flush? The first echo or the second? or both?

Shawn 2010-01-06 21:55:57

I added flush after every echo, it doesn't seem to change anything..

Shawn 2010-01-06 21:58:50

Answer 2

A:

Works OK for me. It seems to print all the expected lines of "Any old text" and also all numbers after that.

I imagine that it might be a web server or PHP misconfiguration, but I can't quite think where to begin with that.

Jeff 2010-01-06 21:21:57

You say it works OK. Have you tried changing the number (418) to something else?

Shawn 2010-01-06 21:59:32

Yup, works for all the numbers I tried. I tried a variety such as 1, 200, 1000, all are OK.

Jeff 2010-01-07 05:15:15

Answer 3

A:

I tried it and it all works as expected.

Only thing I noticed is that the page is around 8kB. Is there some magic configuration in your webserver (which webserver are you using?) which could be connected with an 8kB page size?

mopoke 2010-01-06 21:24:57

I have no clue.. But I added the results of phpinfo in my original question, maybe you would recognize such a configuration?

Shawn 2010-01-06 21:56:38

Answer 4

+1 A:

Judging from your code, maybe the problems lies in the mysql connection. You should always check if the mysql connection is successfully or failed, before using it. Try to rewrite your code like this:

<html>
    <body>
    <?php
        //open connection
        $liendb = mysql_connect("localhost","","");
        if ( ! $liendb )
        {
          die('Could not connect: ' . mysql_error());
        }

        //select database
        $select_db = mysql_select_db ("test", $liendb);
        if ( ! $select_db )
        {
          die ("Failed to do select the database: ' . mysql_error());
        }

        //print 'magic' lines
        for($i = 0; $i < 418; ++$i)
        {
            echo("Any old text<br />");
        }

        //get table's content
        $resultatSQL = mysql_query("SELECT uid FROM nombres ORDER BY uid", $liendb);
        if ( ! $resultatSQL )
        {
          die('Invalid query: ' . mysql_error());
        }

        //process table content
        while($tab = mysql_fetch_array($resultatSQL, MYSQL_ASSOC))
        {
            echo("<p>".$tab['uid']."</p>");
            echo("<br />\n");
        }
        mysql_close($liendb);
    ?>
    </body>
</html>

With this code, if any error related with mysql connection happened, then you will got the error message, instead of it silently fail. Maybe it will make the php module in apache crash, so the process died prematurely and apache then send the incomplete page as a file to download, instead of displaying it as a web page.

Let me know the result in your computer.

Donny Kurnia 2010-01-14 13:52:12

I tried your code and I get one warning: ---Warning: Unknown: 1 result set(s) not freed. Use mysql_free_result to free result sets which were requested using mysql_query() in Unknown on line 0--- But even better, the problem seems to have stopped! No matter how many useless lines I print, I get all the table entries! I don't exactly know which part of your code solved the problem, but I'll try to figure that out next. Thanks very much in any case! and btw, do you know what it means to free result sets?

Shawn 2010-01-15 15:49:28

Well, after a couple of tests, I found out that the part of your code that solved my problem was adding $liendb in the mysql_close statement... Do you think you could explain this to me? Because frankly, I don't understand why this statement affects what happens earlier in the code...

Shawn 2010-01-15 16:00:57

you could read the function definition and usage here: http://id2.php.net/manual/en/function.mysql-close.php Maybe without passing `$liendb`, the statement try to close all connection, that might cause the execution died prematurely, and apache serve the page as php file, not as web page. My guess that the php module in your xampp have bug, or maybe the php-mysql client. Upgrade to latest version might solve the problems.

Donny Kurnia 2010-01-16 03:07:48

ansaurus

tags:

views:

answers:

printing meaningless lines of text prevents page download, but too many lines prevent from getting all entries in a mysql table. Why?

related questions