Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>What you want is completely possible with the use of ob_start(); Take a look here... <a href="http://www.php.net/ob_start" rel="nofollow">http://www.php.net/ob_start</a> and that will give you an idea. I don't know what your code looks like but as an example you could do something like this...</p> <pre><code>&lt;?php ob_start(); $query = "SELECT * FROM users"; $results = DB::get()-&gt;query($sql); echo "&lt;pre&gt;"; print_r($results); echo "&lt;/pre&gt;"; $content = ob_get_content(); @ob_end_clean(); echo $contents; //continue processing </code></pre> <p>obviously you need to tailor that for your specific script but that is an idea to get you where you need to go</p> <p>~~~~~~~~~EDIT~~~~~~~~~~~~~</p> <p>OK so using your code and comments here you go. First, yes you can do more than one while loop with the results, though you shouldn't as that is bad coding practices. That being said here is what I would do...</p> <pre><code>ob_start(); $level = ob_get_level(); $dbc = mysql_connect("$db_host","$db_username","$db_pass"); if (!$dbc) { die('SERVER ERROR PLEASE CONTACT US FOR MORE INFORMATION!'); } mysql_select_db("$db_name", $dbc); $sql = "SELECT * FROM `ads` WHERE (`status` LIKE 'active%' OR `status` LIKE 'featured%') ORDER BY `clicks` DESC LIMIT 10;"; $result = mysql_query($sql,$dbc); $totalads=mysql_num_rows($result); $str=""; while ($row = mysql_fetch_assoc($result)) { $str .= $row["banner"] . "][". $row["link"] . "&lt;br /&gt;"; $views[] = $row['views']; $target_views[] = $row['targetviews']; $ids[] = $row['id']; } echo $str; $content = ob_get_contents(); if(ob_get_level() &gt; $level + 1) { ob_end_flush(); } echo $content; @ob_end_clean(); for($i = 0, $len = count($views); $i &lt; $len; $i++) { if((intval($views[$i] + 1) &gt;= intval($target_views[$i]) { $sql = "UPDATE `ads` SET `views` = `views` + 1 , `status` = 'expired' WHERE `ID`=".$ids[$i].";"; } else { $sql = "UPDATE `ads` SET `views` = `views` + 1 WHERE `ID`=".$ids[$i].";"; } $result = mysql_query($sql); mysql_free_result($result); } //I don't know what this stuff here is for except for the close line, but it's her if you want it $str=rtrim($str,"&lt;BR&gt;"); mysql_free_result($result); mysql_close($dbc); die ($str); </code></pre> <p>?></p> <p>You no longer need the die statement there, but I left it incase you wanted it for something else. That should do what you need, check my stuff for typos though I just kinda pushed it out real quick for ya. please don't forget to mark that little check box for the right answer if it works, or leads you to the solution. Thanks man</p>
    singulars
    1. This table or related slice is empty.
    1. POsend php text output to client browser and run rest in server side
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USRob
    1. USRob
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POsend php text output to client browser and run rest in server side
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COthis looks useful, il try it, ive updated my first post with my code
      singulars
      1. PO
      1. USuser2899094
    2. COYou are going to run into problems because the code you have that you say can be run later is inside of the while loop. Your best bet on this is to store values in an array in the while loop, then build your string and output that, then do your other things. Let me know if you want me to write some sample code for you
      singulars
      1. PO
      1. USRob
    3. COi know that. I was just thinking now is it worth it. the code is to return urls to an android phone that uses web.get method. I tried the script in phone browser and it loaded fast. But when using a 3G network every seconds counts as its slower speed. So it could help. what i want to know is could i build $str using one while ($row = mysql_fetch_assoc($result)) loop, output it, flush(), then use another while ($row = mysql_fetch_assoc($result)) loop to do the mysql queries after output. or does fetch_assoc clear the result on by one, thus needing to run the query again?
      singulars
      1. PO
      1. USuser2899094
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload