---
title: "strukturera upp resultatet utav SELECT"
type: "forum-thread"
url: "https://www.webforum.nu/amne/php/155922-strukturera-upp-resultatet-utav-select"
topic: "PHP"
topic_url: "https://www.webforum.nu/amne/php"
author: "Tulork"
published: "2007-01-12T21:16:38.000Z"
updated: "2007-01-12T22:22:38.000Z"
replies: 1
views: 307
page: 1
pages: 1
language: "sv-SE"
site: "webForum — webforum.nu"
rights: "Upphovsrätten till varje inlägg tillhör dess författare."
attribution: "Citera som: webForum, https://www.webforum.nu/amne/php/155922-strukturera-upp-resultatet-utav-select"
---

# strukturera upp resultatet utav SELECT

## #1 — Tulork, 2007-01-12T21:16Z

```php
<?php
ob_start();
session_start(); // Alltid överst på sidan

// Kolla om inloggad = sessionen satt
/*if (!isset($_SESSION['sess_user'])){
  header("Location: index.php");
  exit;
}
*/

if (!isset($_SESSION['sess_userlevel']) || $_SESSION['sess_userlevel'] != "admin") {
//  header("Location: index.php");
  header("refresh: 5;url=konto.php");
// eller
  echo "Du har inte behörighet till den här sidan";
  exit;
}

if (isset($_GET['logout'])){
  session_unset();
  session_destroy();
  header("Location: index.php");
  exit;
}
?>
<html>
<head>
<link rel=StyleSheet href="setts/style.css" TYPE="text/css">
</head>
<body class="back">

<?php

include "conn.php";

if ($_POST['JA'] == "Ja" && strlen($_POST['delete']) && $_POST['delete'] != "6")
{
  mysql_query("DELETE FROM $mem_table WHERE id = '" . $_POST['delete'] . "'");
  header("Location: remove.php");
  exit;
}

// Performing SQL query
$query = 'SELECT * FROM members';
$result = mysql_query($query) or die('Query failed: ' . mysql_error());

// Printing results in HTML
echo "<link rel=StyleSheet href=\"setts\style.css\" TYPE=\"text/css\">";
echo "<table>\n";
echo "<p class=\"text\">ID User Pass Name<p>";
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
   echo "\t<tr>\n";
   foreach ($line as $col_value) {
       echo "\t\t<td class=\"text\">$col_value</td>\n";
   }
   echo "\t</tr>\n";
}
echo "</table>\n";

// Free resultset
mysql_free_result($result);

if (isset ($_POST ['submit'])){
  $delete = $_POST['delete'];
  if ($delete=="126"){
    echo "<p class=\"text2\">Du kan inte ta bort Admin kontot!<p>";
  }

//--------------------------------------------------------------

  else {
        echo "
	<strong><p class=\"warning\">Är du säker på att du vill ta bort Användaren med id:</strong>$delete?<p>	
	<form method=\"post\" action=\"?\">
        <input type=\"submit\" name=\"JA\" value=\"Ja\">
        <input type=\"submit\" name=\"NEJ\" value=\"Nej\">
                 <input type=\"hidden\" name=\"delete\" value=\"$delete\">
        </form>";

  }
}
ob_end_flush();
?>

<br><form method="post" action="?">
<label for="delete"> Vilket id vill du ta bort</label>
<input type="text" name="delete" />
<input type="submit" name="submit" value="Ta bort!"/>
</form><br>
<a href="admin.php">Tillbaka</a><br><br>
<?php
echo "<a href=\"index.php?logout=\">Logga ut</a>\n";
?>
</body>
</html>
```

Har problem med att skapa en strukturerad utskrift utav resultatet från SELECT...(visar alla användare) 

vill att det ska se ut så här för en som besöker sidan   x(   är inte världsbäst på detta precis.

```
[B]ID [/B]     [B]User[/B]       [B]Pass[/B]       [B]Name[/B] 
1        olof        xxxx     olof
2        olof        xxxx     olof
3        olof        xxxx     olof
```

Permalänk: https://www.webforum.nu/p/155922

## #2 — Tulork, 2007-01-12T22:22Z

hehe, lugnt, jag fixade det själv :)

```php
echo "<link rel=StyleSheet href=\"setts\style.css\" TYPE=\"text/css\">";

echo "<table>\n";
echo "<td class=\"text\"><strong>ID</strong></td>";
echo "<td class=\"text\"><strong>User</strong></td>";
echo "<td class=\"text\"><strong>Pass</strong></td>";
echo "<td class=\"text\"><strong>Name</strong></td>";
echo "<td class=\"text\"><strong>Något</strong></td>";
echo "<td class=\"text\"><strong>Något mer</strong></td>";
echo "<td class=\"text\"><strong>Kanske detta</strong></td>";
echo "<td class=\"text\"><strong>Hej hej</strong></td>";
echo "<td class=\"text\"><strong>END</strong></td>";

while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
   echo "\t<tr>\n";
   foreach ($line as $col_value) {
       echo "\t\t<td class=\"text\">$col_value</td>\n";
   }
   echo "\t</tr>\n";
}
echo "</table>\n";
```

nu är det snyggt och rent :)

Permalänk: https://www.webforum.nu/p/1923351

---

Tråden på webben: https://www.webforum.nu/amne/php/155922-strukturera-upp-resultatet-utav-select
