File "add_members.php"
Full Path: /home/analogde/www/Encounter/dashboard_work/add_members.php
File size: 14.96 KB
MIME-type: text/x-php
Charset: utf-8
<?php
include('includes/config.php');
if (!isset($_SESSION['user_id'])) {
header("Location: index.php");
exit();
}
$response = array('success' => false, 'message' => '');
$membershipTypesQuery = "SELECT id, type, amount FROM membership_types";
$membershipTypesResult = $conn->query($membershipTypesQuery);
function generateUniqueFileName($originalName) {
$timestamp = time();
$extension = pathinfo($originalName, PATHINFO_EXTENSION);
$uniqueName = $timestamp . '_' . uniqid() . '.' . $extension;
return $uniqueName;
}
if ($_SERVER["REQUEST_METHOD"] == "POST")
{
//header('Location: http://www.votresite.com/pageprotegee.php');
//exit();
$nom = $_POST['nom'];
$prenom = $_POST['prenom'];
$email = $_POST['email'];
$statut = $_POST['statut'];
$privilege = $_POST['privilege'];
//$dob = $_POST['dob'];
//$gender = $_POST['gender'];
//$contactNumber = $_POST['contactNumber'];
//$email = $_POST['email'];
//$address = $_POST['address'];
//$country = $_POST['country'];
//$statut = $_POST['statut'];
//$privilege = $_POST['privilege'];
//$membershipType = $_POST['membershipType'];
$user_id = 'ID-' . str_pad(mt_rand(1, 999999), 6, '0', STR_PAD_LEFT);
// if (!empty($_FILES['photo']['name']))
// {
// $uploadedPhoto = $_FILES['photo'];
// $uniquePhotoName = generateUniqueFileName($uploadedPhoto['name']);
// move_uploaded_file($uploadedPhoto['tmp_name'], 'uploads/member_photos/' . $uniquePhotoName);
// }
// else
// {
// $uniquePhotoName = 'default.jpg';
// }
/*
$insertQuery = "INSERT INTO members (fullname, dob, gender, contact_number, email, address, country, postcode, occupation,
membership_type, membership_number, photo, created_at)
VALUES ('$fullname', '$dob', '$gender', '$contactNumber', '$email', '$address', '$country', '$postcode', '$occupation',
'$membershipType', '$membershipNumber', '$uniquePhotoName', NOW())";
*/
/*
CREATE TABLE IF NOT EXISTS `members_data` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`nom` varchar(255) NOT NULL,
`prenom` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL,
`user_id` varchar(20) NOT NULL,
`statut` varchar(30) NOT NULL,
`privilege` varchar(30) NOT NULL,
`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`expiry_date` date DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
*/
$insertQuery = "INSERT INTO members_data (nom, prenom, email, user_id, statut, privilege , created_at, expiration)
VALUES ('$nom', '$prenom', '$email', '$user_id', '$statut', '$privilege', NOW() , 'toto' )";
if ($conn->query($insertQuery) === TRUE)
{
$response['success'] = true;
$response['message'] = 'Le nouveau membre a été entegistré : ' . $user_id;
}
else
{
$response['message'] = 'Erreur: ' . $conn->error;
}
}
?>
<?php include('includes/header.php');?>
<body class="hold-transition sidebar-mini layout-fixed layout-navbar-fixed layout-footer-fixed">
<div class="wrapper">
<?php include('includes/nav.php'); ?>
<?php include('includes/sidebar.php'); ?>
<!-- Content Wrapper. Contains page content -->
<div class="content-wrapper">
<?php include('includes/pagetitle.php'); ?>
<!-- Main content -->
<section class="content">
<div class="container-fluid">
<!-- Info boxes -->
<div class="row">
<!-- left column -->
<div class="col-md-12">
<?php if ($response['success']): ?>
<div class="alert alert-success alert-dismissible">
<button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button>
<h5><i class="icon fas fa-check"></i> OK</h5>
<?php echo $response['message']; ?>
</div>
<?php elseif (!empty($response['message'])): ?>
<div class="alert alert-danger alert-dismissible">
<button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button>
<h5><i class="icon fas fa-ban"></i> Error</h5>
<?php echo $response['message']; ?>
</div>
<?php endif; ?>
<!-- general form elements -->
<div class="card card-primary">
<div class="card-header">
<h3 class="card-title"><i class="fas fa-keyboard"></i> Add Members Form</h3>
</div>
<!-- /.card-header -->
<!-- form start -->
<form method="post" action="" enctype="multipart/form-data">
<div class="card-body">
<div class="row">
<div class="col-sm-6">
<label for="nom">Nom</label>
<input type="text" class="form-control" id="nom" name="nom"
placeholder="Saisir le nom" required>
</div>
<!--
<div class="col-sm-3">
<label for="dob">Date of Birth</label>
<input type="date" class="form-control" id="dob" name="dob" required>
</div>
<div class="col-sm-3">
<label for="gender">Gender</label>
<select class="form-control" id="gender" name="gender" required>
<option value="Male">Male</option>
<option value="Female">Female</option>
<option value="Other">Other</option>
</select>
</div>
-->
</div>
<div class="row mt-3">
<div class="col-sm-6">
<label for="prenom">Prénom</label>
<input type="test" class="form-control" id="prenom"
name="prenom" placeholder="Saisir le prénom" required>
</div>
<!--
<div class="col-sm-6">
<label for="email">Email</label>
<input type="email" class="form-control" id="email" name="email"
placeholder="Enter email" required>
</div>
-->
</div>
<div class="row mt-3">
<div class="col-sm-6">
<label for="emails">Email</label>
<input type="text" class="form-control" id="email" name="email"
placeholder="Saisir l'email" required>
</div>
<!--
<div class="col-sm-6">
<label for="country">Country</label>
<input type="text" class="form-control" id="country" name="country"
placeholder="Enter country" required>
</div>
-->
</div>
<div class="row mt-3">
<div class="col-sm-6">
<label for="statut">Statut</label>
<select class="form-control" id="statut" name="statut" required>
<option value="Actif">Actif</option>
<option value="Inactif">Inactif</option>
</select>
</div>
</div>
<div class="row mt-3">
<div class="col-sm-6">
<label for="statut">Privilége</label>
<select class="form-control" id="privilege" name="privilege" required>
<option value="Utilisateur">Utilisateur</option>
<option value="111">111</option>
<option value="222">222</option>
<option value="333">333</option>
</select>
</div>
</div>
<!-- Visit codeastro.com for more projects -->
<!--
<div class="row mt-3">
<div class="col-sm-6">
<label for="postcode">Postcode</label>
<input type="text" class="form-control" id="postcode" name="postcode"
placeholder="Enter postcode" required>
</div>
<div class="col-sm-6">
<label for="occupation">Occupation</label>
<input type="text" class="form-control" id="occupation" name="occupation"
placeholder="Enter occupation" required>
</div>
</div>
-->
<!--
<div class="row mt-3">
<div class="col-sm-6">
<label for="membershipType">Membership Type</label>
<select class="form-control" id="membershipType" name="membershipType" required>
<?php
/*
if ($membershipTypesResult) {
while ($row = $membershipTypesResult->fetch_assoc()) {
$currencyQuery = "SELECT currency FROM settings";
$currencyResult = $conn->query($currencyQuery);
if ($currencyResult->num_rows > 0) {
$currencyRow = $currencyResult->fetch_assoc();
$currencySymbol = $currencyRow['currency'];
} else {
$currencySymbol = '$';
}
echo "<option value='{$row['id']}'>{$row['type']} - {$currencySymbol}{$row['amount']}</option>";
}
} else {
echo "Error: " . $conn->error;
}*/
?>
</select>
</div>
-->
<!--
<div class="col-sm-6">
<label for="photo">Member Photo</label>
<input type="file" class="form-control-file" id="photo" name="photo">
</div>
-->
</div>
</div>
<!-- /.card-body -->
<div class="card-footer">
<button type="submit" class="btn btn-primary">Submit</button>
</div>
</form>
</div>
<!-- /.card -->
</div>
<!--/.col (left) -->
</div>
<!-- /.row -->
<!-- Visit codeastro.com for more projects -->
</div><!--/. container-fluid -->
</section>
<!-- /.content -->
</div>
<!-- /.content-wrapper -->
<!-- Control Sidebar -->
<aside class="control-sidebar control-sidebar-dark">
<!-- Control sidebar content goes here -->
</aside>
<!-- /.control-sidebar -->
<!-- Visit codeastro.com for more projects -->
<!-- Main Footer -->
<footer class="main-footer">
<strong> © <?php echo date('Y');?> codeastro.com</a> -</strong>
All rights reserved.
<div class="float-right d-none d-sm-inline-block">
<b>Developed By</b> <a href="https://xyz.com/">Zoulou</a>
</div>
</footer>
</div>
<!-- ./wrapper -->
<?php include('includes/footer.php'); ?>
</body>
</html>