20. juli 2006 - 12:34
Der er
2 kommentarer og 1 løsning
autosæt 3 per linje
Jeg har et script... Hvor jeg gerne vil have den til at vise 3 tables per linje, og maks 9 tables ialt... Jeg kan ikke lige gennemskue, hvor jeg har en fejl i scriptet... ----------------- if (!isset($sortby) || !preg_match("/^[A-Z]$/", $sortby)) $sortby = "all"; $orderby = ($sortby == "all" ? "" : " WHERE user_name LIKE '".stripinput($sortby)."%'"); $result = dbquery("SELECT * FROM ".$db_prefix."users".$orderby.""); $rows = dbrows($result); if (!isset($rowstart) || !isNum($rowstart)) $rowstart = 3; if ($rows != 3) { $i = 3; echo "<table align='center' cellpadding='0' cellspacing='10' width='100%' class='tbl-border'> <tr><td>\n"; $result = dbquery("SELECT * FROM ".$db_prefix."users".$orderby." ORDER BY user_name, user_name LIMIT $rowstart,9"); echo "<table><tr>"; $o = 0; while ($data = dbarray($result)) { $cell_color = ($i % 2 == 0 ? "tbl1" : "tbl2"); $i++; echo "<table align='center' cellpadding='0' cellspacing='1' width='30%' class='tbl-border'><tr>\n<td width='100%' align='center' class='$cell_color'>\n<a href='profile.php?lookup=".$data['user_id']."'>".$data['user_name']." ".$data['user_enavn']."</a></td>\n</tr>"; echo "<tr>\n<td width='100%' align='center' class='$cell_color'>".($data['user_avatar'] ? "<img src='".IMAGES."avatars/".$data['user_avatar']."' width=\"100\" alt='".$locale['u017']."'>" : $locale['u046'])."</td>\n</tr>"; echo "<tr>\n<td width='100%' align='center' class='$cell_color'>".($data['user_trin'] ? $data['user_trin'] : $locale['u048'])."</td>\n</tr>\n</table>\n</td>"; if($o == 2){ echo "</tr><tr>"; $o = 0; }else{ $0++; } echo "</table>"; echo "</tr>\n</table>\n"; } else { echo "<center><br>\n".$locale['403']."$sortby<br><br>\n</center>\n"; } $search = array( "A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R", "S","T","U","V","W","X","Y","Z","0","1","2","3","4","5","6","7","8","9" ); echo "<hr>\n<table align='center' cellpadding='0' cellspacing='1' class='tbl-border'>\n<tr>\n"; echo "<td rowspan='2' class='tbl2'><a href='".FUSION_SELF."?sortby=all'>".$locale['404']."</a></td>"; for ($i=0;$i < 36!="";$i++) { echo "<td align='center' class='tbl1'><div class='small'><a href='".FUSION_SELF."?sortby=".$search[$i]."'>".$search[$i]."</a></div></td>"; echo ($i==17 ? "<td rowspan='2' class='tbl2'><a href='".FUSION_SELF."?sortby=all'>".$locale['404']."</a></td>\n</tr>\n<tr>\n" : "\n"); } echo "</tr>\n</table>\n"; -----------------
Annonceindlæg tema
Offentlig digitalisering
Fra effektivisering til digital suverænitet. Hvordan skaber det offentlige en digital fremtid med AI, sikkerhed og kontrol i centrum?
her kommer lige en opdatering en kammerat lavede: ---------------------- <?php require_once "maincore.php"; require_once "subheader.php"; require_once "side_left.php"; include LOCALE.LOCALESET."members-profile.php"; include LOCALE.LOCALESET."user_fields.php"; opentable($locale['082']); if (!isset($sortby) || !preg_match("/^[A-Z]$/", $sortby)) $sortby = "all"; $orderby = ($sortby == "all" ? "" : " WHERE user_name LIKE '".stripinput($sortby)."%'"); $result = dbquery("SELECT * FROM ".$db_prefix."users".$orderby.""); $rows = dbrows($result); if (!isset($rowstart) || !isNum($rowstart)) $rowstart = 3; if ($rows != 3) { $i = 3; echo "<table align='center' cellpadding='0' cellspacing='10' width='100%' class='tbl-border'> <tr><td>\n"; $result = dbquery("SELECT * FROM ".$db_prefix."users".$orderby." ORDER BY user_name, user_name LIMIT $rowstart,9"); while ($data = dbarray($result)) { $cell_color = ($i % 2 == 0 ? "tbl1" : "tbl2"); $i++; echo "<table align='center' cellpadding='0' cellspacing='1' width='30%' class='tbl-border'><tr>\n<td width='100%' align='center' class='$cell_color'>\n<a href='profile.php?lookup=".$data['user_id']."'>".$data['user_name']." ".$data['user_enavn']."</a></td>\n</tr>"; echo "<tr>\n<td width='100%' align='center' class='$cell_color'>".($data['user_avatar'] ? "<img src='".IMAGES."avatars/".$data['user_avatar']."' width=\"100\" alt='".$locale['u017']."'>" : $locale['u046'])."</td>\n</tr>"; echo "<tr>\n<td width='100%' align='center' class='$cell_color'>".($data['user_trin'] ? $data['user_trin'] : $locale['u048'])."</td>\n</tr>\n</table>\n</td>"; if($o == 2){ echo "</tr><tr>"; $o = 0; }else{ $o++; } echo "</tr></table>"; echo "</tr>\n</table>\n"; } } else { echo "<center><br>\n".$locale['403']."$sortby<br><br>\n</center>\n"; } $search = array( "A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R", "S","T","U","V","W","X","Y","Z","0","1","2","3","4","5","6","7","8","9" ); echo "<hr>\n<table align='center' cellpadding='0' cellspacing='1' class='tbl-border'>\n<tr>\n"; echo "<td rowspan='2' class='tbl2'><a href='".FUSION_SELF."?sortby=all'>".$locale['404']."</a></td>"; for ($i=0;$i < 36!="";$i++) { echo "<td align='center' class='tbl1'><div class='small'><a href='".FUSION_SELF."?sortby=".$search[$i]."'>".$search[$i]."</a></div></td>"; echo ($i==17 ? "<td rowspan='2' class='tbl2'><a href='".FUSION_SELF."?sortby=all'>".$locale['404']."</a></td>\n</tr>\n<tr>\n" : "\n"); } echo "</tr>\n</table>\n"; closetable(); if ($rows > 30) echo "<div align='center' style='margin-top:5px;'>".makePageNav($rowstart,30,$rows,3,FUSION_SELF."?sortby=$sortby&")."\n</div>\n"; require_once "side_right.php"; require_once "footer.php"; ?>
ok... nu er jeg kommet frem til følgende... ---------------------- <?php require_once "maincore.php"; require_once "subheader.php"; require_once "side_left.php"; include LOCALE.LOCALESET."members-profile.php"; include LOCALE.LOCALESET."user_fields.php"; opentable($locale['082']); if (!isset($sortby) || !preg_match("/^[A-Z]$/", $sortby)) $sortby = "all"; $orderby = ($sortby == "all" ? "" : " WHERE user_name LIKE '".stripinput($sortby)."%'"); $result = dbquery("SELECT * FROM ".$db_prefix."users".$orderby.""); $rows = dbrows($result); if (!isset($rowstart) || !isNum($rowstart)) $rowstart = 0; if ($rows != 0) { $result = dbquery("SELECT * FROM ".$db_prefix."users".$orderby." ORDER BY user_name, user_name LIMIT $rowstart,9"); echo "<table align='center' cellpadding='0' cellspacing='10' width='100%' class='tbl-border'><tr>"; $o = 0; while ($data = dbarray($result)) { echo "<td><table align='center' cellpadding='0' cellspacing='1' width='30%' class='tbl-border'>\n<tr>\n<td width='100%' align='center' class='tbl2'>\n<a href='profile.php?lookup=".$data['user_id']."'>".$data['user_name']." ".$data['user_enavn']."</a>\n</td>\n</tr>"; echo "<tr><td width='100%' align='center' class='tbl1'>".($data['user_avatar'] ? "<img src='".IMAGES."avatars/".$data['user_avatar']."' width=\"100\" alt='".$locale['u017']."'>" : $locale['u046'])."</td>\n</tr>"; echo "<tr><td width='100%' align='center' class='tbl2'>".($data['user_trin'] ? $data['user_trin'] : $locale['u048'])."</td>\n</tr>\n</table>\n</td>\n"; if($o==2){ echo "</tr>\n<tr>\n"; $o = 0; } else { $o++; } echo "</tr>\n</table>\n<table>\n"; } } else { echo "<center><br>\n".$locale['403']."$sortby<br><br>\n</center>\n"; } $search = array( "A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R", "S","T","U","V","W","X","Y","Z","0","1","2","3","4","5","6","7","8","9" ); echo "<hr>\n<table align='center' cellpadding='0' cellspacing='1' class='tbl-border'>\n<tr>\n"; echo "<td rowspan='2' class='tbl2'><a href='".FUSION_SELF."?sortby=all'>".$locale['404']."</a></td>"; for ($i=0;$i < 36!="";$i++) { echo "<td align='center' class='tbl1'><div class='small'><a href='".FUSION_SELF."?sortby=".$search[$i]."'>".$search[$i]."</a></div></td>"; echo ($i==17 ? "<td rowspan='2' class='tbl2'><a href='".FUSION_SELF."?sortby=all'>".$locale['404']."</a></td>\n</tr>\n<tr>\n" : "\n"); } echo "</tr>\n</table>\n"; closetable(); if ($rows > 9) echo "<div align='center' style='margin-top:5px;'>".makePageNav($rowstart,9,$rows,3,FUSION_SELF."?sortby=$sortby&")."\n</div>\n"; require_once "side_right.php"; require_once "footer.php"; ?> ------------------- men jeg mangler stadig at få dem til at stå så den sætter 3 tables per linje
Jeg fandt selv fejlen... der var en væltet tuborgklamme '}' der var sat forkert. I får lige det funktionelle script ------------------------------- <?php require_once "maincore.php"; require_once "subheader.php"; require_once "side_left.php"; include LOCALE.LOCALESET."members-profile.php"; include LOCALE.LOCALESET."user_fields.php"; opentable($locale['082']); if (!isset($sortby) || !preg_match("/^[A-Z]$/", $sortby)) $sortby = "all"; $orderby = ($sortby == "all" ? "" : " WHERE user_name LIKE '".stripinput($sortby)."%'"); $result = dbquery("SELECT * FROM ".$db_prefix."users".$orderby.""); $rows = dbrows($result); if (!isset($rowstart) || !isNum($rowstart)) $rowstart = 0; if ($rows != 0) { $result = dbquery("SELECT * FROM ".$db_prefix."users".$orderby." ORDER BY user_name, user_name LIMIT $rowstart,9"); $o=0; echo "<table align='center' cellpadding='0' cellspacing='10' width='100%' class='tbl-border'><tr>"; while ($data = dbarray($result)) { echo "<td><table align='center' cellpadding='0' cellspacing='1' width='30%' class='tbl-border'>\n"; echo "<tr>\n<td width='100%' align='center' class='tbl2'>\n<a href='profile.php?lookup=".$data['user_id']."'>".$data['user_name']." ".$data['user_enavn']."</a>\n</td>\n</tr>"; echo "<tr><td height='160' width='100%' valign='middle' align='center' class='tbl1'>".($data['user_avatar'] ? "<img src='".IMAGES."avatars/".$data['user_avatar']."' width=\"100\" alt='".$locale['u017']."'>" : $locale['u046'])."</td>\n</tr>"; echo "<tr><td width='100%' align='center' class='tbl2'>".($data['user_trin'] ? $data['user_trin'] : $locale['u048'])."</td>\n</tr>\n</table>\n</td>\n"; if($o==2){ echo "</tr>\n<tr>\n"; $o=0; } else { $o++; } } echo "</tr>\n</table>\n<table>\n"; } else { echo "<center><br>\n".$locale['403']."$sortby<br><br>\n</center>\n"; } $search = array( "A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R", "S","T","U","V","W","X","Y","Z","0","1","2","3","4","5","6","7","8","9" ); echo "<hr>\n<table align='center' cellpadding='0' cellspacing='1' class='tbl-border'>\n<tr>\n"; echo "<td rowspan='2' class='tbl2'><a href='".FUSION_SELF."?sortby=all'>".$locale['404']."</a></td>"; for ($i=0;$i < 36!="";$i++) { echo "<td align='center' class='tbl1'><div class='small'><a href='".FUSION_SELF."?sortby=".$search[$i]."'>".$search[$i]."</a></div></td>"; echo ($i==17 ? "<td rowspan='2' class='tbl2'><a href='".FUSION_SELF."?sortby=all'>".$locale['404']."</a></td>\n</tr>\n<tr>\n" : "\n"); } echo "</tr>\n</table>\n"; closetable(); if ($rows > 9) echo "<div align='center' style='margin-top:5px;'>".makePageNav($rowstart,9,$rows,3,FUSION_SELF."?sortby=$sortby&")."\n</div>\n"; require_once "side_right.php"; require_once "footer.php"; ?>
Vi tilbyder markedets bedste kurser inden for webudvikling