Avatar billede schunck Juniormester
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";
-----------------
Avatar billede schunck Juniormester
20. juli 2006 - 12:44 #1
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&amp;")."\n</div>\n";

require_once "side_right.php";
require_once "footer.php";
?>
Avatar billede schunck Juniormester
20. juli 2006 - 13:49 #2
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&amp;")."\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
Avatar billede schunck Juniormester
21. juli 2006 - 15:47 #3
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&amp;")."\n</div>\n";

require_once "side_right.php";
require_once "footer.php";
?>
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Vi tilbyder markedets bedste kurser inden for webudvikling

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester