Üye gruplandırma biri için önemliydi sanırım onuda belirtiyim
databasemiz
CREATE TABLE `tblusergroup` (
`ID` int(10) unsigned NOT NULL auto_increment,
`NAME` varchar(200) NOT NULL default '',
`DEFAULT_USER` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
--
-- Tablo döküm verisi `tblusergroup`
--
INSERT INTO `tblusergroup` (`ID`, `NAME`, `DEFAULT_USER`) VALUES
ÜYE DÜZENLEMEDE GRUPLAMA EKLEME
sayfa dizaynında hazırlandı html komutları mevcut
<?php
include("???.php");
if(isset($_GET['mode']) && $_GET['mode']=="doadd"){
$catname=trim(formatSQL($_POST["NAME"]));
if($catname!=""){
if(mysql_query("INSERT INTO tblusergroup (NAME,DEFAULT_USER)
VALUES ('" . $catname . "'," . (isset($_POST["DEFAULT_USER"])?"1":"0") . ")")){
$COMMONERROR="GRUP Eklendi";
}
else{
$COMMONERROR="HATA.";
echo mysql_error();
}
}else{
$COMMONERROR="Grup Adı Boş";
}
}
if(isset($_GET['mode']) && $_GET['mode']=="doupdate"){
$catname=trim(formatSQL($_POST["NAME"]));
$catID=trim(formatSQL($_GET["update"]));
if($catname!=""){
if(mysql_query("UPDATE tblusergroup SET NAME='" . $catname . "',DEFAULT_USER=" . (isset($_POST["DEFAULT_USER"])?"1":"0") . " WHERE ID=" . $catID)){
$COMMONERROR="Grup Güncellendi";
}
else
{
$COMMONERROR="HATA";
echo mysql_error();
}
}else{
$COMMONERROR="GRUP ADI";
}
}
if(isset($_GET['mode']) && $_GET['mode']=="delete"){
$catID=trim(formatSQL($_GET['delete']));
if($catID!=""){
if($catID!=1){
$result = mysql_query("SELECT * FROM tblUsers WHERE GroupID=" . $catID);
if(!$row = mysql_fetch_array($result))
{
mysql_query("DELETE FROM tblusergroup WHERE ID=" . $catID );
$COMMONERROR="Silindi";
}
else{
$COMMONERROR="Grup Silinemez.Kullanıcı mevcut.";
}
}else{
$COMMONERROR="Admin grub silinmemeli// engelliyorum :)";
}
}else{
$COMMONERROR="ID BOŞLADI";
}
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title></title>
<?php
if ($COMMONERROR!=""){
?>
<script language="javascript">
window.alert('<?=$COMMONERROR?>');
</script>
<?php
$COMMONERROR="";
}
?>
<link href="admin.css" rel="stylesheet" type="text/css">
</head>
<body topmargin="5" leftmargin="5"><br/>
<table width="98%" border="0" cellspacing="0" cellpadding="00">
<tr>
<td><table width="100%" border="1" cellpadding="10" cellspacing="0" bordercolor="#CCCCCC">
<tr>
<td class="PencereIci">
<table width="352" border="0" cellspacing="2" cellpadding="2">
<tr>
<td colspan="3">gruplar </td>
</tr>
<tr>
<td>id</td>
<td>ad</td>
<td><div align="center"> </div></td>
</tr>
<?php
$result = mysql_query("SELECT * FROM tblusergroup ORDER BY NAME ASC");
while($row = mysql_fetch_array($result))
{
?>
<tr bgcolor="#FFFFFFF">
<td width="36" bgcolor="#FFFFFF"><?=$row['ID']?></td>
<td width="207" bgcolor="#FFFFFF"><?=stripslashes($row['NAME'])?></td>
<td width="89" bgcolor="#FFFFFF"><a href="?mode=update&update=<?=$row['ID']?>"DÜZENLE</a> <a href="JavaScript:if(window.confirm('Silmek istediğinize eminmisin?')) window.location.href='?mode=delete&delete=<?=$row['ID']?>'">SİL</a> </td>
</tr>
<?php
}
?>
<tr>
<td colspan="3"><a href="?mode=addnew" class="GenelLink">YENİ
GRUP </a></td>
</tr>
</table>
<?php
if(isset($_GET['mode']) && $_GET['mode']=="addnew"){
?>
<p>YENİ GRUP </p>
<form name="form1" method="post" action="?mode=doadd">
<table width="270" border="0" cellpadding="2" cellspacing="2">
<tr bgcolor="#DBE8EA">
<td width="98" bgcolor="#FFFFFF">GRUP </td>
<td width="158" bgcolor="#FFFFFF"><input name="NAME" type="text" id="NAME" size="15" maxlength="50"></td>
</tr>
<tr bgcolor="#DBE8EA">
<td bgcolor="#FFFFFF">Varsayılan </td>
<td bgcolor="#FFFFFF"><label>
<input name="DEFAULT_USER" type="checkbox" id="DEFAULT_USER" value="YES">
</label></td>
</tr>
<tr bgcolor="#DBE8EA">
<td bgcolor="#FFFFFF"> </td>
<td bgcolor="#FFFFFF"><input type="submit" name="Submit" value="Kaydet">
</td>
</tr>
</table>
</form>
<p> </p>
<?php
}
?>
<?php
if(isset($_GET['mode']) && $_GET['mode']=="update"){
$catID=trim(formatSQL($_GET['update']));
$result = mysql_query("SELECT * FROM tblusergroup WHERE ID=" . $catID);
if($row = mysql_fetch_array($result))
{
?>
<p> DÜZENLE </p>
<form name="form1" method="post" action="?mode=doupdate&update=<?=$row['ID']?>">
<table width="270" border="0" cellspacing="2" cellpadding="2">
<tr bgcolor="#DBE8EA">
<td width="98" bgcolor="#FFFFFF">GRUP</td>
<td width="158" bgcolor="#FFFFFF"><input name="NAME" type="text" id="NAME" value="<?=stripslashes($row['NAME'])?>" size="15" maxlength="50"></td>
</tr>
<tr bgcolor="#DBE8EA">
<td bgcolor="#FFFFFF">Varsayılan </td>
<td bgcolor="#FFFFFF">
<input name="DEFAULT_USER" type="checkbox" id="DEFAULT_USER" value="YES" <? if($row['DEFAULT_USER']==1) {?>checked<? }?>>
</td>
</tr>
<tr bgcolor="#DBE8EA">
<td bgcolor="#FFFFFF"> </td>
<td bgcolor="#FFFFFF"><input type="submit" name="Submit" value="Kaydet">
</td>
</tr>
</table>
</form>
<p> </p>
<?php
}
}
?>
<p> </p>
<p> </p>
</td>
</tr>
</table></td>
</tr>
</table>
<p align="center"> </p>
</body>
</html> KULLANICIYI GURPLANDIRMA (UYE DUZENLE ALANI) <tr bgcolor="#DBE8EA">
<td width="145" bgcolor="#FFFFFF">Grup</td>
<td width="376" bgcolor="#FFFFFF"><select name="GROUP">
<option value="0"></option>
<?php
$result = mysql_query("SELECT * FROM tblusergroup ORDER BY NAME ASC");
while($row = mysql_fetch_array($result))
{
?>
<option value="<?=stripslashes($row['ID'])?>" <?php if($row['ID']==$_SESSION['USERDATA_GROUP']){?>selected<?php }?>><?=stripslashes($row['NAME'])?></option>
<?php Yazım hataları olabilir