PHP/MySQL Database/mysql unbuffered query

Материал из Web эксперт
Перейти к: навигация, поиск

Unbuffered Queries for Large Data Sets

   <source lang="html4strict">

<?php

           mysql_connect("localhost", "php", "password");
           mysql_select_db("phpdb");
           $result = mysql_unbuffered_query("SELECT ID, Name FROM conferences;");
           while ($row = mysql_fetch_assoc($result)) {
                   extract($row, EXTR_PREFIX_ALL, "conf");
                   print "$conf_Name\n";
           }
   ?>
 
 </source>