<!-- Step-1 : code action button for data process -->
<!-- Step-2 : Make Connection using config.php -->
<!-- Step-3 : php variables for holding user's input data & protect input data using the fuction -->
<!-- Step-4 : save password in md5 -->
<!-- Step-5 : check the username avability -->
<!-- Step-6 : change the universal address for future update in server name -->
<?php include "header.php";
if(isset($_POST['save'])){
/* -- Step-2 : Make Connection using config.php */
include "config.php";
/* -- Step-3 : php variables for holding user's input data & protect input data using the fuction */
$fname = mysqli_real_escape_string($conn, $_POST['fname']);
$lname = mysqli_real_escape_string($conn, $_POST['lname']);
$user = mysqli_real_escape_string($conn, $_POST['user']);
/* -- Step-4 : save password in md5 */
$password = mysqli_real_escape_string($conn,md5($_POST['password']));
$role = mysqli_real_escape_string($conn, $_POST['role']);
/* -- Step-5 : check the username avability */
$sql = "SELECT username FROM user WHERE username = '{$user}' ";
$result = mysqli_query($conn, $sql) or die("Query Failed.");
if(mysqli_num_rows($result) > 0){ // check if any row contain the i/p username
echo "<p style='color:red; text-align:center; margin: 10px 0;'>lUserName already Exists.</p>";
}
else
{
$sql1 = "INSERT INTO user (first_name,last_name, username, password, role)
VALUES ('{$fname}', '{$lname}', '{$user}', '{$password}', '{$role}')";
if (mysqli_query($conn, $sql1)){
/* header("Location: http://localhost/myphp/news-sites/admin/users.php"); */
/* -- Step-6 : change the universal address for future update in server name */
header("Location: {$hostname}/admin/users.php");
}
}
}
?>
<div id="admin-content">
<div class="container">
<div class="row">
<div class="col-md-12">
<h1 class="admin-heading">Add User</h1>
</div>
<div class="col-md-offset-3 col-md-6">
<!-- Form Start -->
<!-- Step-1 : code action button for data process -->
<form action="<?php $_SERVER['PHP_SELF']; ?>" method ="POST" autocomplete="off">
<div class="form-group">
<label>First Name</label>
<input type="text" name="fname" class="form-control" placeholder="First Name" required>
</div>
<div class="form-group">
<label>Last Name</label>
<input type="text" name="lname" class="form-control" placeholder="Last Name" required>
</div>
<div class="form-group">
<label>User Name</label>
<input type="text" name="user" class="form-control" placeholder="Username" required>
</div>
<div class="form-group">
<label>Password</label>
<input type="password" name="password" class="form-control" placeholder="Password" required>
</div>
<div class="form-group">
<label>User Role</label>
<select class="form-control" name="role" >
<option value="0">Normal User</option>
<option value="1">Admin</option>
</select>
</div>
<input type="submit" name="save" class="btn btn-primary" value="Save" required />
</form>
<!-- Form End-->
</div>
</div>
</div>
</div>
<?php include "footer.php"; ?>