Dynamically Generate Grid from Results

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
hwdesign
Forum Newbie
Posts: 9
Joined: Fri Dec 18, 2009 4:40 am

Dynamically Generate Grid from Results

Post by hwdesign »

I've run an MySQL query that returns an array of square thumbnails. I want to dynamically display the results in 3x3 grids sort of like this:

Code: Select all

[] [] []     [] [] []     [] [] []
[] [] []     [] [] []     [] [] []
[] [] []     [] [] []     [] [] []
I was thinking I could float three unordered lists next to each other, then wrap each set of three in a div and float the div. However, I'm stumped on how to do this dynamically.

Any help would be greatly appreciated.
User avatar
Architek
Forum Commoner
Posts: 44
Joined: Wed Jul 01, 2009 5:01 am
Location: Portland OR

Re: Dynamically Generate Grid from Results

Post by Architek »

I typically do this in a table...

here is an example of what I have done via table output.

Code: Select all

<div id="order-query-report">
		<table>
			<tr id="query-report-labels">
				<td class="head-county">County</td>
				<td class="head-username">Created By</td>
				<td class="head-datetime">Date Created</td>
				<td class="head-submit-status" span="1">Submit Status</td>
				<td class="head-ico"></td>
				<td class="head-username">Submitted By</td>
				<td class="head-datetime">Date Submitted</td>
				<td class="head-formtype" span="1">Form Type</td>
				<td class="head-ico2"></td>
			</tr>
		
<?php
//Make SQL Request
$query = "SELECT [instance]
							,[ordernumber]
							,[usernamesave]
							,[datesave]
							,[propcounty]
							,[submitstatus]
							,[usernamesubmit]
							,[datesubmit]
							,[formtype]
			   FROM [$db_name1].[dbo].[$tbl_name1]";
				if($ordernumber > "" and $datefilter > ""){$query .= " WHERE [ordernumber] = '".$ordernumber."' AND CONVERT(nvarchar(30), datesave, 110) like '%".$datefilter."%'";}
				if($ordernumber == "" and $datefilter > ""){$query .= " WHERE CONVERT(nvarchar(30), datesave, 110) like '%".$datefilter."%'";}
				if($ordernumber > "" and $datefilter == ""){$query .= " WHERE [ordernumber] = '".$ordernumber."'" ;}

			$result = sqlsrv_query($conn, $query);

			while($rows = sqlsrv_fetch_array($result)){
			?>
					<tr>
						<form action="<?php echo "ereet-query-".$rows['formtype'].".php"; ?>" method="post" id="queryform" name="queryform" target="_blank" >	
							<input type="hidden" name="instanceid" value="<?php echo $rows['instance']; ?>"></input>
							<input type="hidden" name="ordernumber" value="<?php echo $rows['ordernumber']; ?>"></input>
							<td >
								<?php echo $rows['propcounty']; ?>&#160;
							</td>
							<td >
								<?php echo $rows['usernamesave']; ?>&#160;
							</td>
							<td>
								<?php @$datesave = date_format($rows['datesave'], "m/d/Y h:i");
											echo $datesave; ?>&#160;
							</td>
							<td>
								<?php if($rows['submitstatus'] == 2){echo "Pending</td><td class=\"ico-noborder-lft\"><img src=\"images/aqua.png\" />";} 
											if($rows['submitstatus'] == 0){echo "Processing</td><td class=\"ico-noborder-lft\"><img src=\"images/yellow.png\" />";} 
											if($rows['submitstatus'] == 3){echo "Complete</td><td class=\"ico-noborder-lft\"><img src=\"images/green.png\" />";} ?>&#160;
							<td>
								<?php echo $rows['usernamesubmit']; ?>&#160;
							</td>
							<td>
								<?php @$datesubmit = date_format($rows['datesubmit'], "m/d/Y h:i");
											echo $datesubmit; ?>&#160;
							</td>
							<td>
								<?php if($rows['formtype'] = "standard"){$formname = "Standard Form";}
											if($rows['formtype'] = "mobilehome"){$ormname = "Mobile Home Form";}
											if($rows['formtype'] = "supplemental"){$formname = "Supplemental Form";}
											if($rows['formtype'] = "controlling"){$formname = "Controlling Interest Form";}
											if($formname > ""){echo $formname. "</td><td class=\"ico-noborder-lft\"><input type=\"image\" src=\"images/preview.png\" name=\"viewformquerys\" class=\"query-view-button\" value=\"\"></input>";}?>&#160;</td>
						</form>
					</tr>
						<?php
						}
						//close database
						sqlsrv_close($conn);
						}
						?>
		</table>
</div>

hwdesign
Forum Newbie
Posts: 9
Joined: Fri Dec 18, 2009 4:40 am

Re: Dynamically Generate Grid from Results

Post by hwdesign »

Thanks for the example.

I found this to work a little better in my situation:

Code: Select all

$setCount = 0;    // counter that keeps track of each set of scrolling lenses 
$count = 0;        // counter that keeps track of the lens we are up to in the list 
    while($row = mysql_fetch_array($r)){ 
        $setCount++;     
        $count++; 
        if($setCount == 1) {    // each time we start a new set 
            echo "<ul class='mySet'> 
";     
        }  
//... 
// WRITE your LI TAGS HERE... 
//... 
 
     if($setCount == 9 && $count < $totalNum) {     
    // if we have reached our 9th item in the set and we aren't at the end of the list... 
    echo "</ul> 
"; 
    $setCount = 0; 
     } else if($count == $totalNum) {    //  if we've reached the last item in the list... 
    echo "</ul> 
"; 
     } 
 
}
User avatar
Architek
Forum Commoner
Posts: 44
Joined: Wed Jul 01, 2009 5:01 am
Location: Portland OR

Re: Dynamically Generate Grid from Results

Post by Architek »

yea that is a mutch better way to handle that one.
Post Reply