if ($admin == 'admin') {
$authority = 1;
$users = 1;
$category = 1;
$service = 1;
$orders = 1;
$support = 1;
$notice = 1;
$api = 1;
$setting = 1;
$admin_query= $baglanti->query("SELECT * FROM admin WHERE user_name = '$user_name' ")->fetch(PDO::FETCH_ASSOC);
if ($admin_query > 0) {
include "admin-setting.php";
echo '<script type = "text/javascript"> swal("Kullanıcı adı mevcut", "Farklı kullanıcı adı deneyin.", "error") </script>';
Yonlendir("admin-setting.php",2);
}else{
$baglanti->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$sorgu2 = $baglanti->prepare("INSERT INTO authority (authority, users, category, service, orders,support,notice,api, setting, admin_name) VALUES($authority, $users, $category, $service, $orders, $support, $notice, $api, $setting, '$user_name' )");
$sorgu2->execute();
$baglanti->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$sorgu = $baglanti->prepare("INSERT INTO admin (user_name, password, authority) VALUES('$user_name', '$password', $authority)");
$sorgu->execute();
include "admin-setting.php";
echo '<script type = "text/javascript"> swal("Yeni admin oluşturuldu", "lütfen Bekleyin Yönlendiriliyorsunuz.", "success") </script>';
Yonlendir("admin-setting.php",2);
}
}else{
$authority = 2;
if(isset($_POST['authority'])) {
$authority = $_POST['authority'];
$states = array
(
array("kullanıcılar",0),
array("kategori",0),
array("servisler",0),
array("siparişler",0),
array("destek",0),
array("duyuru",0),
array("api",0),
array("ayarlar",0)
);
for ($i=0; $i <count($states) ; $i++) {
if (in_array($states[$i][0], $authority)) {
$states[$i][1] = 1;
}
}
$baglanti->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$sorgu2 = $baglanti->prepare("INSERT INTO authority (authority, users, category, service, orders,support,notice,api,setting,admin_name) VALUES(
$authority,
$states[0][1],
$states[1][1],
$states[2][1],
$states[3][1],
$states[4][1],
$states[5][1],
$states[6][1],
$states[7][1],
'$user_name' )");
$sorgu2->execute();
}$sorgu2->execute(); Bölümünde hata veriyor $states[0][1] şeklinde ekletemiyorum. Bunu nasıl ekletebilirim?
<div style="margin-left: 15px; margin-bottom: 10px; " >
<input type="checkbox" name="authority[]" value="kullanıcılar" > Kullanıcılar -
<input type="checkbox" name="authority[]" value="kategori"> Kategori -
<input type="checkbox" name="authority[]" value="servisler" > Servisler -
<input type="checkbox" name="authority[]" value="siparişler"> Siparişler -
<input type="checkbox" name="authority[]" value="destek" > Destek -
<input type="checkbox" name="authority[]" value="duyuru" > duyuru -
<input type="checkbox" name="authority[]" value="api"> Api -
<input type="checkbox" name="authority[]" value="ayarlar" > Ayarlar
[COLOR=initial] </div>[/COLOR]