Forum PHP.pl

[PHP] pobierz, plaintext 
echo "<table width='750' border='1' rules='all' title='Member list'>
  <tr>
	<td><center><b>L.p</b></center></td>
	<td><center><b>ID</b></center></td>
    <td><center><b><a href="">Nick</a></b></center></td>
	<td><center><b>E-mail</b></center></td>
    <td><center><b>Kasa</b></center></td>
	<td><center><b>Ranga</b></center></td>
	<td><center><b>Data rejestracji</b></center></td>
  </tr>
...........
...........
...........
</table>";
[PHP] pobierz, plaintext 

[SQL] pobierz, plaintext 
$result = mysql_query('SELECT * FROM users ORDER BY nick')
[SQL] pobierz, plaintext 

[PHP] pobierz, plaintext 
<?php
echo '<h3>Lista użytkowników:</h3>';
		$result = mysql_query('SELECT * FROM users ORDER BY id');
echo "<table width='750' border='1' rules='all' title='Member list'>
  <tr>
	<td><center><b>L.p</b></center></td>
	<td><center><b>ID</b></center></td>
    <td><center><b>Nick</b></center></td>
	<td><center><b>E-mail</b></center></td>
    <td><center><b>Kasa</b></center></td>
	<td><center><b>Ranga</b></center></td>
	<td><center><b>Data rejestracji</b></center></td>
	<td><center><b>Usuń</b></center></td>
  </tr>";
$lp = 1;  
while($row = mysql_fetch_assoc($result)) {
 
  echo '<tr><form action="userlist.php" method="post"><input type="hidden" name="id" value="'.$row['id'].'" />'."
	<td><center>".$lp."</center></td>
	<td><center>".$row['id']."</center></td>
    <td><center>".$row['nick']."</center></td>
	<td><center>".$row['email']."</center></td>
    <td><center>".$row['kasa']."<font color='green'>$</span></center></td>
	<td><center>"; 
	if($row['grupa'] == 4) {
	echo '<font color="black">User</font>'; }
	else if($row['grupa'] == 3) {  
	echo '<font color="blue">V.I.P</font>';}
	else {
	echo '<font color="red">Admin</font>'; } 
	echo "</center></td>
	<td><center>".date("d.m.Y, H:i", $row['data_rejestracji'])."</center></td>
	<td><center>";
	$lp++;
	?>
	<input class="delete" type="submit" name="cmd" value="Usuń"></form>
 
<?php
}
	echo "</center></td>
  </tr>";
 
 
echo "</table>";
 
echo 'Sortuj według:<br /><a href="sort.php?sort=nick">Nicka rosnąco</a><br />
<a href="sort.php?sort=email_asc">E-maila rosnąco</a><br />
<a href="sort.php?sort=nick_desc">Nicka malejąco</a><br />
<a href="sort.php?sort=email_desc">E-maila malejąco</a>';
if(isset($_GET['sort'])){
switch($_GET['sort']){
case 'nick':
  $sort='nick';
  $asc_desc='ASC';
break;
case 'nick_desc':
  $sort='nick';
  $asc_desc='DESC';
break;
case 'email_asc':
  $sort='emial';
  $asc_desc='ASC';
break;
case 'email_desc':
  $sort='emial';
  $asc_desc='DESC';
break;
default:
  $sort='id';
  $asc_desc='ASC';
}
}else{ $sort='id'; $asc_desc='ASC';}
 
$result=mysql_query("SELECT * FROM users ORDER BY $sort $asc_desc");
 
 
if(isset($_POST['cmd']) && isset($_POST['id']))
{
$id = strip_tags(mysql_real_escape_string(intval($_POST['id'])));
$sql = "DELETE FROM users WHERE id=$id";
 
$result = mysql_query($sql);
 
echo "Użytkownik został usunięty.<Br>";
echo "<a href=\"index.php\">Powrót do panelu admina</a>.";
}
// koniec buforowania
ob_end_flush();
 
?>
[PHP] pobierz, plaintext