<?php
include "../inc/init.php";
if(!$user->isAdmin()) {
header("Location: $set->url/login.php");
exit;
}
$page->title = "Edit Menu";
$page->description = "Edit Menu";
$page->keyword = "";
$presets->setActive("adminpanel");
include "header.php";
include "menu-side.php";
// connect to the database
$servername = "$set->db_host";
$username = "$set->db_user";
$password = "$set->db_pass";
$dbname = "$set->db_name";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
if(isset($_POST['add_mainmenu']))
{
$menu = mysqli_real_escape_string($conn,$_POST['menu']);
$menu_link = mysqli_real_escape_string($conn,$_POST['menu_link']);
$sql_mainmenu=$conn->query("INSERT INTO `".MLS_PREFIX."mainmenu` (menu,menu_link) VALUES('$menu','$menu_link')");
//info success or error
if($sql_mainmenu) {
?>
<script>window.location.replace("navigation.php");</script>
<?php
} else {
echo '<div class="container"><p style="padding:15px" class="bg-danger"> Error, Cant Save!' . mysqli_error($conn) . '</p></div>';
}
}
if(isset($_POST['add_sub_menu']))
{
$parent = mysqli_real_escape_string($conn,$_POST['parent']);
$submenu = mysqli_real_escape_string($conn,$_POST['submenu']);
$submenu_link = mysqli_real_escape_string($conn,$_POST['submenu_link']);
$sql_submenu=$conn->query("INSERT INTO `".MLS_PREFIX."submenu` (mainmenu_id,submenu,submenu_link) VALUES('$parent','$submenu','$submenu_link')");
//info success or error
if($sql_submenu) {
?>
<script>window.location.replace("navigation.php");</script>
<?php
} else {
echo '<div class="container"><p style="padding:15px" class="bg-danger"> Error, Cant Save!' . mysqli_error($conn) . '</p></div>';
}
}
?>
<legend>Add Main Menu</legend>
<div class="row">
<div class="col-md-6">
<form method="post" class="form-horizontal">
<div class="form-group">
<label class="col-sm-4 control-label" for="sitename">Menu Name</label>
<div class="col-sm-7">
<select required name="menu" class="form-control">
<option value="">Please Select...</option>
<?php
$res=$conn->query("SELECT * FROM `".MLS_PREFIX."page`");
while($row1=$res->fetch_array())
{
?>
<option value="<?php echo $row1['title']; ?>" required><?php echo $row1['title']; ?></option>
<?php
}
?>
</select>
</div>
</div>
<div class="form-group">
<label class="col-sm-4 control-label" for="sitename">Menu Link</label>
<div class="col-sm-7">
<select required name="menu_link" class="form-control">
<option value="">Please Select...</option>
<?php
$res=$conn->query("SELECT * FROM `".MLS_PREFIX."page`");
while($row1=$res->fetch_array())
{
?>
<option value="<?php echo $row1['link']; ?>" required><?php echo $row1['title']; ?></option>
<?php
}
?>
</select>
<p class="text-info">Menu Link Must be Same as Menu Name.</p>
</div>
</div>
<div class="form-group">
<div class="col-sm-offset-2 col-sm-7">
<button class="btn btn-primary" type="submit" name="add_mainmenu">Add main menu</button> <a href="navigation.php"><button type="button" class="btn btn-default">Cancel</button></a>
</div>
</div>
</form>
</div>
<div class="col-md-6">
<form method="post" class="form-horizontal">
<div class="form-group">
<label class="col-sm-4 control-label" for="sitename">Menu Name</label>
<div class="col-sm-7">
<input type="text" class="form-control" placeholder="Menu Name" name="menu" required/>
</div>
</div>
<div class="form-group">
<label class="col-sm-4 control-label" for="sitename">Link External</label>
<div class="col-sm-7">
<input type="text" class="form-control" placeholder="Menu Link" name="menu_link" required/>
</div>
</div>
<div class="form-group">
<div class="col-sm-offset-2 col-sm-9">
<button class="btn btn-primary" type="submit" name="add_mainmenu">Add main menu</button> <a href="navigation.php"><button type="button" class="btn btn-default">Cancel</button></a>
</div>
</div>
</form>
</div>
</div><!--row-->
<br />
<legend>Add Submenu</legend>
<div class="row">
<div class="col-md-6">
<form method="post" class="form-horizontal">
<div class="form-group">
<label class="col-sm-4 control-label" for="sitename">Select Parent Menu</label>
<div class="col-sm-7">
<select name="parent" class="form-control" required>
<option value="">Please Select...</option>
<?php
$res=$conn->query("SELECT * FROM `".MLS_PREFIX."mainmenu`");
while($row=$res->fetch_array())
{
?>
<option value="<?php echo $row['id']; ?>" required><?php echo $row['menu']; ?></option>
<?php
}
?>
</select>
</div>
</div>
<div class="form-group">
<label class="col-sm-4 control-label" for="sitename">Submenu Name</label>
<div class="col-sm-7">
<select name="submenu" class="form-control" required>
<option value="">Please Select...</option>
<?php
$res=$conn->query("SELECT * FROM `".MLS_PREFIX."page`");
while($row1=$res->fetch_array())
{
?>
<option value="<?php echo $row1['title']; ?>" required><?php echo $row1['title']; ?></option>
<?php
}
?>
</select>
</div>
</div>
<div class="form-group">
<label class="col-sm-4 control-label" for="sitename">Submenu Link</label>
<div class="col-sm-7">
<select name="submenu_link" class="form-control" required>
<option value="">Please Select...</option>
<?php
$res=$conn->query("SELECT * FROM `".MLS_PREFIX."page`");
while($row1=$res->fetch_array())
{
?>
<option value="<?php echo $row1['link']; ?>" required><?php echo $row1['title']; ?></option>
<?php
}
?>
</select>
<p class="text-info">Submenu Link Must be Same as Submenu.</p>
</div>
</div>
<div class="form-group">
<div class="col-sm-offset-2 col-sm-7">
<button type="submit" class="btn btn-primary" name="add_sub_menu">Add sub menu</button> <a href="navigation.php"><button type="button" class="btn btn-default">Cancel</button></a>
</div>
</div>
</form>
</div>
<div class="col-md-6">
<form method="post" class="form-horizontal">
<div class="form-group">
<label class="col-sm-4 control-label" for="sitename">Select Parent Menu</label>
<div class="col-sm-7">
<select name="parent" class="form-control" required>
<option value="">Please Select Parent ...</option>
<?php
$res=$conn->query("SELECT * FROM `".MLS_PREFIX."mainmenu`");
while($row=$res->fetch_array())
{
?>
<option value="<?php echo $row['id']; ?>" required><?php echo $row['menu']; ?></option>
<?php
}
?>
</select>
</div>
</div>
<div class="form-group">
<label class="col-sm-4 control-label" for="sitename">Submenu Name</label>
<div class="col-sm-7">
<input type="text" class="form-control" placeholder="Menu Name" name="submenu" required/>
</div>
</div>
<div class="form-group">
<label class="col-sm-4 control-label" for="sitename">Submenu Link External</label>
<div class="col-sm-7">
<input type="text" class="form-control" placeholder="Submenu Link" name="submenu_link" required/>
</div>
</div>
<div class="form-group">
<div class="col-sm-offset-2 col-sm-7">
<button type="submit" class="btn btn-primary" name="add_sub_menu">Add sub menu</button> <a href="navigation.php"><button type="button" class="btn btn-default">Cancel</button></a>
</div>
</div>
</form>
</div>
</div>
<div class="pull-right">
</div>
<?php
include 'admin-footer.php';
?>
|
Download
