PHP inputNotice Examples

Example #1

File: panel_main_edit.php Project: hrustz/noname

  
  if(!$control){
    $mysqli -> query("UPDATE Products SET main = '0' WHERE main = '1' || main = '2' || main = '3'");
    
    $i = 1;
    
    foreach($_POST as $value){
      $mysqli -> query("UPDATE Products SET main = '$i' WHERE id = '$value'");
      $i++;
    }  
    
    inputNotice('Данные успешно изменены');
    header("Location: /panel/main_edit");
    exit;
  } else{
    inputNotice($control);
  }
}

/*
if($action == 'products_edit' && $_POST){
  $t1 = $_POST[t1];
  $t2 = $_POST[t2];
  $t3 = $_POST[t3];
  
  
  $q = $mysqli -> query("SELECT COUNT(*) FROM Products WHERE id = '$t1' || id = '$t2' || id = '$t3'");
  $idProd = $q -> fetch_row();
  
  if($idProd[0] != 3){
    $control = 'Введены номера несуществующих товаров';

Example #2

File: panel_news_edit.php Project: hrustz/noname

    
    if(!$control){
      $mysqli -> query("UPDATE News SET name = '$newName', description = '$newDescription', text = '$newText' WHERE id = '$id'");
      inputNotice('Новость успешно отредактированна');
      header('Location: /panel');
      exit();
    } else{
      inputNotice($control);
    }
  } else{
    inputNotice('Незаполнены все поля');
  }
}

if($action == 'delete'){
  $mysqli -> query("DELETE FROM News WHERE id = '$id'");
  inputNotice('Новость удалена');
  header('Location: /panel');
  exit();
}

if($id){
	$q = $mysqli -> query("SELECT name, description, text FROM News WHERE id = '$id'");
  $result = $q -> fetch_assoc();
  $result[id] = $id;
} else{
  error("Нет такой новости");
}

$title = 'Редактирование статьи';
$content = tpl('panel_news_edit', $result);

Example #3

File: panel_category_edit.php Project: hrustz/noname

  }
  
  if($control == $i){
    foreach($_POST[name] as $key => $value){
      $name = translate($value);
      $mysqli -> query("UPDATE Category SET name = '$name', translation = '$value' WHERE id = '$key'");
    }
    inputNotice('Категории успешно обновлены');
  } else{
    inputNotice('Заполнены не все поля');
  }
  header('Location: /panel/category_edit');
  exit();
}

if($action == 'delete') {
  $count = $mysqli -> query("SELECT COUNT(id) FROM Products WHERE category = '$id'") -> fetch_row();
  if($count[0] == 0){
    $mysqli -> query("DELETE FROM Category WHERE id = '$id'");
    inputNotice('Категория удалена');
  } else{
    inputNotice('Сначала переместите/удалите товары из этой категории');
  }
  header('Location: /panel/category_edit');
  exit();
}

$result[cat] = $sqlQuery = $mysqli -> query("SELECT * FROM Category") -> fetch_all(MYSQLI_ASSOC);

$title = "Редактирование категорий";
$content = tpl("panel_category_edit", $result);

Example #4

File: panel_products_edit.php Project: hrustz/noname

      inputNotice($control);
    }
  } else{
    inputNotice('Незаполнены все поля');
  }
}

if($action == 'delete'){
  $count = $mysqli -> query("SELECT COUNT(id) FROM Products WHERE id = '$id' && (main = '1' || main = '2' || main = '3')") -> fetch_row();
  if($count[0] == 0){
    $mysqli -> query("DELETE FROM Products WHERE id = '$id'");
    inputNotice('Товар удален');
    header('Location: /panel');
    exit();
  } else{
    inputNotice('Сначала удалите товар из вывода на главную страницу');
  }
}

if($id){
	$q = $mysqli -> query("SELECT name, description, photo, price, category FROM Products WHERE id = '$id'");
  $result = $q -> fetch_assoc();
	$q = $mysqli -> query("SELECT * FROM Category");
  $result[cat] = $q -> fetch_all(MYSQLI_ASSOC);
  $result[id] = $id;
} else{
  error("Нет такого товара");
}

$title = 'Редактирование товара';
$content = tpl('panel_products_edit', $result);

Example #5

File: panel_news_add.php Project: hrustz/noname

    
    $name = $_POST[name];
    $description = $_POST[description];
    $text = $_POST[text];
    $date = date("Y-m-d H:i:s");
    
    
    /*if($_FILES[photo][error] != 0){
      $photo = '/files/news/default.jpg';
    } else{
      $photo = '/files/news/'.translate($_FILES[photo][name]);      
      if(!move_uploaded_file($_FILES['photo']['tmp_name'], ROOT.$photo)){
        $control = 'Ошибка при загрузке фотографии';
      }
    }*/
    
    if(!$control){
      $mysqli -> query("INSERT INTO News(name, description, text, date) VALUES('$name', '$description', '$text', '$date')");
      inputNotice('Статья успешно добавлена');
      header('Location: /panel');
      exit();
    } else{
      inputNotice($control);
    }
  } else{
    inputNotice('Незаполнены все поля');
  }
}

$title = 'Добавление новости';
$content = tpl('panel_news_add', $result);