Dynamic Grid Output Script Using PHP + MySQL Array Data

<?php// Include database connectioninclude_once 'connect_to_mysql.php';// SQL query to interact with info from our database$sql = mysql_query("SELECT id, member_name FROM member_table ORDER BY id DESC LIMIT 15"); $i = 0;// Establish the output variable$dyn_table = '<table border="1" cellpadding="10">';
while($row = mysql_fetch_array($sql)){

    $id = $row["id"];
    $member_name = $row["member_name"];

    if ($i % 3 == 0) { // if $i is divisible by our target number (in this case "3")
        $dyn_table .= '<tr><td>' . $member_name . '</td>';
    } else {
        $dyn_table .= '<td>' . $member_name . '</td>';
    }
    $i++;
}$dyn_table .= '</tr></table>';?><html>
<body>
<h3>Dynamic PHP Grid Layout From a MySQL Result Set</h3>
<?php echo $dyn_table; ?></body>
</html>

Comments

Text Ideas in Design - Turn Typography into exciting designs!

Text Ideas in Design - Turn Typography into exciting designs! TEXT THAT CREATES BACKGROUNDS Tiling, gradients, bokeh and text design interlink to form an interesting background. Bokeh is the photographic blur effect to get a soft, out-of-focus look. Extremely effective and relevant use of handwritten text to form a background and an image. The ad for Australia Post says “If you really want to touch someone, send them a letter.” The visual shows this literally – a letter hugging a girl. EXTRA-LARGE HEADLINES Looks like designers are having themselves a field day with big, bold headlines. The kind that stop you in your tracks and make you read. This site has the outsized headline in lower case and the content in all caps in a smart yet simple design that optimizes the use of color and type. Courtesy: LemonDesign Here every word begins with the letter ‘A’ which takes center-stage in no uncertain terms. ...

Web Design Ideas

ooking for something to add a little punch to your website design and make it stand apart? We bring you some ideas to trigger your creative thoughts and entice the user into your site. Use single page design - keep it simple Create unusual icons – let your imagination come into play Use attractive navigation – try out something different Draw on circular elements to attract the viewer - soften hard lines and angles Use good-looking textures Use CSS3 to create animations, transforms and transitions – a great alternative to Flash Try out unusual designs for forms Single Page Design Click here for some great ideas on single page designs! Just Dot This scrolling single-page website uses a simple concept – ideas coming to life on a blackboard, with all the changes, scribbles and erasing that refine the process of ideation. The white and red chalk sketches and typography highlight the site’s promise of “Brilliant ideas come to life”. The J...

Webnicia

Search This Blog