PHP loop using HTML tables -
evening all,
the code using follows :
<?php /** * template displaying pages. * template name: addserverindexoci * template displays pages default. * please note wordpress construct of pages * , other 'pages' on wordpress site use * different template. * * @package wordpress * @subpackage twenty_twelve * @since twenty twelve 1.0 */ get_header(); ?> <div id="primary" class="site-content"> <div id="content" role="main"> <?php while ( have_posts() ) : the_post(); ?> <?php get_template_part( 'content', 'page' ); ?> <?php comments_template( '', true ); ?> <?php endwhile; // end of loop. ?> <table border="2" bordercolor="#000000" style="background-color:#ffffff" width="160%" cellpadding="1" cellspacing="0"> <td><font face="arial, helvetica, sans-serif">server name</font</td> <td><font face="arial, helvetica, sans-serif">server address</font</td> <td><font face="arial, helvetica, sans-serif">server port</font</td> <td><font face="arial, helvetica, sans-serif">server description</font</td> <td><font face="arial, helvetica, sans-serif"> status</font</td> <?php mysql_connect("localhost", "", "") or die (mysql_error()); #echo "connected mysql "; mysql_select_db("starforg_search") or die (mysql_error()); #echo "connected data base"; $query = "select * "; $result = mysql_query ($query) or die (mysql_error()); $num=mysql_numrows($result); mysql_close(); $i=0; while ($i < $num) { $value = mysql_result($result,$i,"servername"); $value2 = mysql_result($result,$i,"serveraddress"); $value3 = mysql_result($result,$i,"portnumber"); $value4 = mysql_result($result,$i,"description"); ob_start(); if (!$socket = @fsockopen($value2, $value3, $errno, $errstr, 1)) { echo " <font color='red'><centre><strong> server offline!</strong></centre></font>"; } else { echo " <font color='green'><centre><strong> server online!</strong></centre></font>"; fclose($socket); } $status = ob_get_contents(); ob_end_clean(); ?> <tr> <td><font face="arial, helvetica, sans-serif"><? echo $value; ?></font</td> <td><font face="arial, helvetica, sans-serif"><? echo $value2; ?></font</td> <td><font face="arial, helvetica, sans-serif"><? echo $value3; ?></font</td> <td><font face="arial, helvetica, sans-serif"><? echo $value4; ?></font</td> <td><font face="arial, helvetica, sans-serif"><? echo $status; ?></font</td> <? $i++; } ?> </div><!-- #primary --> <?php get_footer(); ?> what want can see while loop trying display data inside of selected fields.
whats happening want keep looping until data displayed works, data go's bottom of page assuming because not using end tags html e.g < /tr>. problem if enter end tags table loop once , display set of data in field rest of data not in table format.
the question how can loop keep displaying data in fields , show footer nice , clean,
note: sorry if bit rough sick today :(
what's wrong ?
<table border="2" bordercolor="#000000" style="background-color:#ffffff" width="160%" cellpadding="1" cellspacing="0"> <tr> <td><font face="arial, helvetica, sans-serif">server name</font</td> <td><font face="arial, helvetica, sans-serif">server address</font</td> <td><font face="arial, helvetica, sans-serif">server port</font</td> <td><font face="arial, helvetica, sans-serif">server description</font</td> <td><font face="arial, helvetica, sans-serif"> status</font</td> </tr> <?php mysql_connect("localhost", "", "") or die (mysql_error()); #echo "connected mysql "; mysql_select_db("starforg_search") or die (mysql_error()); #echo "connected data base"; $query = "select * tablename"; $result = mysql_query ($query) or die (mysql_error()); $num=mysql_numrows($result); mysql_close(); $i=0; while ($i < $num) { $value = mysql_result($result,$i,"servername"); $value2 = mysql_result($result,$i,"serveraddress"); $value3 = mysql_result($result,$i,"portnumber"); $value4 = mysql_result($result,$i,"description"); ob_start(); if (!$socket = @fsockopen($value2, $value3, $errno, $errstr, 1)) { echo " <font color='red'><centre><strong> server offline!</strong></centre></font>"; } else { echo " <font color='green'><centre><strong> server online!</strong></centre></font>"; fclose($socket); } $status = ob_get_contents(); ob_end_clean(); ?> <tr> <td><font face="arial, helvetica, sans-serif"><? echo $value; ?></font</td> <td><font face="arial, helvetica, sans-serif"><? echo $value2; ?></font</td> <td><font face="arial, helvetica, sans-serif"><? echo $value3; ?></font</td> <td><font face="arial, helvetica, sans-serif"><? echo $value4; ?></font</td> <td><font face="arial, helvetica, sans-serif"><? echo $status; ?></font</td> </tr> <? $i++; } ?> </table> and dont't find table name in query $query = "select * ";
Comments
Post a Comment