Avatar billede krohn Praktikant
16. april 2011 - 02:31 Der er 3 kommentarer og
1 løsning

Hjælp til echo table layout

Jeg har et PHP script på som en side. Det den gør er at finde, og vise de bruger der ikke er tildelt en bruger gruppe samt at vise det tilhørsforhold de har valgt (hvis de har valgt et)
Det virker ok, men jeg er ikke helt tifreds med layout, og ville gerne ænder det.
Men nu er jeg ikke særlig skarp hverken til PHP, og eller HTML (andre siger der er en del flere ting også)

Jeg har lavet en side som jeg gerne vil have den til at se ud, men slider med at få den til at vise de rigtige data, samt at få den til at echo
Den er lavet i Dreamveaver.

Er der nogen der kan hjælpe mig med at joine dem så jeg kan få det layout jeg ønsker, med de rigtige data. Eller bare sætte mig i den rigtige retning.


Her er der et par link så i kan se dem på siden:

Php script: http://rigcrew.com/viewpage.php?page_id=13

Som ønskes: http://rigcrew.com/viewpage.php?page_id=14

Her er php scriptet, og under er det jeg ønsker af layout:

\\PHP script start//


$result = dbquery("SELECT user_name, user_id, user_Wheredoyoubelong, user_groups FROM ".fusiona18f4_users." WHERE user_groups= 0 ORDER BY user_name ASC");



echo "<table>\n<tr>\n

<td><b>Username:</b></td>\n

<td><b><img src='/images/hvidspace.gif' alt='' /></a></b></td>\n

<td><b>Wheredoyoubelong:</b></td>\n

<td><b><img src='/images/hvidspacelang.gif' alt='' /></a></b></td>\n

<td><b>Choice</b></td>\n

</tr>\n";



if (dbrows($result)) {

while ($data = dbarray($result)) {



echo "<tr>\n

<td>".profile_link($data['user_id'], $data['user_name'], $data['user_level'])."</td>\n

<td><b><img src='/images/hvidspace.gif' alt='' /></a></b></td>\n

<td>".$data['user_Wheredoyoubelong']."</td>\n

<td><b><img src='/images/hvidspacelang.gif' alt='' /></a></b></td>\n";

}

}

echo "</tr>\n</table>\n";


\\PHP script End//

\\Layout start//

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="25%">Username</td>
    <td width="25%"><div align="center">Belong to</div></td>
    <td width="25%"><div align="center">Choose group</div></td>
    <td width="25%"><div align="center">Add to group    </div></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
  </tr>
  <tr>
    <td>&quot;.$data['user_name'].&quot;</td>
    <td><div align="center">&quot;.$data['user_Wheredoyoubelong'].&quot;</div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
  </tr>
  <tr>
    <td colspan="4"><hr /></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
    <td><div align="center"></div></td>
  </tr>
</table>
<p>&nbsp;</p>
<p>When table echo the  first line (Username, Belong to, Choose group, Add to group)  should of course not be repeated. </p>
<p>&nbsp;</p>
</body>
</html>

\\Layout end//
Avatar billede krohn Praktikant
16. april 2011 - 02:48 #1
Og lige et link til.

Som ønskes, men med en manuel opretttet "echo" http://rigcrew.com/viewpage.php?page_id=17
Avatar billede Fiber Bjørn Juniormester
16. april 2011 - 16:59 #2
Jeg er ikke helt med tror jeg...

vil du have data udskrevet her


    <td>".$data['user_name']."</td>
    <td><div align="center">".$data['user_Wheredoyoubelong']."</div></td>

ud fra denne forrespørgelse

$result = dbquery("SELECT user_name, user_id, user_Wheredoyoubelong, user_groups FROM ".fusiona18f4_users." WHERE user_groups= 0 ORDER BY user_name ASC");


??????
Avatar billede krohn Praktikant
18. april 2011 - 03:20 #3
Ja men slider noget med layout.

Er kommet lidt videre se her:
http://rigcrew.com/viewpage.php?page_id=18

Koden her:
------------------------
Se ønsket layout i bunden af siden



echo "<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n";
echo "  <tr>\n";
echo "    <td width=\"25%\">Username</td>\n";
echo "    <td width=\"25%\"><div align=\"center\">Belong to</div></td>\n";
echo "    <td width=\"25%\"><div align=\"center\">Add to</div></td>\n";
echo "    <td width=\"25%\"><div align=\"center\">Add</div></td>\n";
echo "  </tr>\n";
echo "</table>\n";
echo "<hr>\n";

$result = dbquery("SELECT user_name, user_id, user_Wheredoyoubelong, user_groups FROM ".fusiona18f4_users." WHERE user_groups= 0 ORDER BY user_name ASC");

if (dbrows($result)) {

while ($data = dbarray($result)) {


echo "<table1 width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n";
echo "  <tr>\n";
echo "    <td colspan=\"4\"><b></b></td>\n";
echo "  </tr>\n";
echo "  <tr>\n";
echo "    <td width=\"25%\"><b>".profile_link($data['user_id'], $data['user_name'], $data['user_level'])."</b></td>\n";
echo "    <td width=\"25%\"><b>".$data['user_Wheredoyoubelong']."</b></td>\n";
echo "    <td width=\"25%\"><b>Dropdown list her</b></td>\n";
echo "    <td width=\"25%\"><b>Add knap her</b></td>\n";
echo "  </tr>\n";
echo "  <tr>\n";
echo "    <td colspan=\"4\"></td>\n";
echo "  </tr>\n";
echo "  <tr>\n";
echo "    <td colspan=\"4\"><hr></td>\n";
echo "  </tr>\n";
echo "  <tr>\n";
echo "    <td colspan=\"4\"></td>\n";
echo "  </tr>\n";
echo "<tr>\n</table1>\n";

}

}

echo "</tr>\n</table1>\n";

------------------------------
Avatar billede krohn Praktikant
25. april 2011 - 19:06 #4
Jeg lukker her, da jeg fik det til ved at prøve mig frem.
Smider koden her til hjælp for andre

# kode #


echo "<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"850\">\n";
echo "<tbody>\n";
echo "<tr>\n";
echo "<td width=\"138\" height=\"78\"><img src=\"/images/american.gif\" border=\"0\" width=\"124\" height=\"110\" /></td>\n";
echo "<td width=\"712\">\n";
echo "<h1 class=\"he1\" style=\"text-align: center;\"><span class=\"he2\" style=\"font-size: xx-large; color: #006699;\">xxxxx <br /></span><br /><br /><span style=\"font-size: x-large; color: #006699;\"> Business Travel</span></h1>\n";
echo "</td>\n";
echo "</tr>\n";
echo "</tbody>\n";
echo "</table>\n";
echo "<br /> \n";
echo "<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"850\">\n";
echo "<tbody>\n";
echo "<tr>\n";
echo "<td class=\"he3\" colspan=\"4\">\n";
echo "<div style=\"text-align: left;\"><span style=\"font-size: large; color: #006699;\"> \n";
echo "<hr width=\"100%\" />\n";
echo "</span></div>\n";
echo "</td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td width=\"147\">\n";
echo "<h3><span style=\"color: #006699;\">Postal address:</span></h3>\n";
echo "</td>\n";
echo "<td colspan=\"3\">\n";
echo "<h3>Travel road</h3>\n";
echo "</td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td>\n";
echo "<h3><span style=\"color: #006699;\">Phonenumber:</span></h3>\n";
echo "</td>\n";
echo "<td colspan=\"3\">\n";
echo "<h3>+47 xxxxxxxx</h3>\n";
echo "</td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td>\n";
echo "<h3><span style=\"color: #006699;\">E-mail:</span></h3>\n";
echo "</td>\n";
echo "<td width=\"328\">\n";
echo "<h3><a href=\"mailto:xxxx@xxx.com\"><img src=\"/images/mail.png\" border=\"0\" width=\"25\" height=\"25\" /></a></h3>\n";
echo "</td>\n";
echo "<td colspan=\"2\"></td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td>\n";
echo "<h3><span style=\"color: #006699;\">Opening hours:</span></h3>\n";
echo "</td>\n";
echo "<td>\n";
echo "<h3>Monday to Friday xx:xx - xx:xx   (<strong>CET</strong>)</h3>\n";
echo "</td>\n";
echo "<td width=\"139\">\n";
echo "<h3><span style=\"color: #006699;\">Website:</span></h3>\n";
echo "</td>\n";
echo "<td width=\"236\">\n";
echo "<h3><a href=\"http://xxxxx.com/\" target=\"_blank\">Main website</a></h3>\n";
echo "</td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td colspan=\"4\"></td>\n";
echo "</tr>\n";
echo "</tbody>\n";
echo "</table>\n";
echo "<hr />\n";

$result = dbquery("SELECT * FROM ".fusiona18f4_users." WHERE user_groups='.15'  ORDER BY user_name ASC");

if (dbrows($result)) {
while ($data = dbarray($result)) {

echo "<table width=\"850\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n";
echo "  <tr>\n";
echo "    <td width=\"116\" rowspan=\"4\"><img src='".IMAGES."avatars/".$data['user_avatar']."' alt='' /></td>\n";
echo "    <td width=\"124\">User Name:</td>\n";
echo "    <td width=\"610\">".$data['user_name']."</td>\n";
echo "  </tr>\n";
echo "  <tr>\n";
echo "    <td>Full Name:</td>\n";
echo "    <td>".$data['user_Fullname']."</td>\n";
echo "  </tr>\n";
echo "  <tr>\n";
echo "    <td>E-mail:</td>\n";
echo "    <td>".$data['user_email']."</td>\n";
echo "  </tr>\n";
echo "  <tr>\n";
echo "    <td>Phonenumber:</td>\n";
echo "    <td>".$data['user_Phonenumber']."</td>\n";
echo "  </tr>\n";
echo "  <tr>\n";
echo "    <td colspan=\"3\"><hr></td>\n";
echo "  </tr>\n";
echo "</table>\n";
echo "\n";

}
}

# END#
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