1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / earnlouq / tapnaire.live / manager / include /
Filename : functions.php
back
<?php
// Function to sanitize the input
function sanitize_input($input) {
  $input = trim($input);
  $input = stripslashes($input);
  $input = htmlspecialchars($input);
  $input=htmlentities($input);

  return $input;
}
 
function sanitize_input2($input) {
  $input = trim($input);
  $input = stripslashes($input);

  return $input;
}

  // Function to sanitize the file name
  function sanitizeFileName($fileName)
  {
      $fileName = preg_replace("/[^a-zA-Z0-9.]/", "_", $fileName);
      $fileName = time() . "_" . $fileName;
      return $fileName;
  }


  // Generate coupon codes
function generateCouponCodes($name, $country, $plan, $count, $con) {
  $codes = array();

  for ($i = 0; $i < $count; $i++) {
    $code = generateCouponCode($name, $country,$plan, $con);
    $codes[] = $code;
  }

  return $codes;
}

// Generate coupon code
function generateCouponCode($name, $country, $plan, $con) {
  $namePrefix = strtoupper(substr($name, 0, 3)); // Extract first 3 letters and convert to uppercase
  $randomSegment1 = generateRandomCharacters(4, 'lowercase'); // First segment
  $randomSegment2 = generateRandomCharacters(4, 'mixed'); // Second segment (mix of numbers & letters)
  $randomSegment3 = generateRandomCharacters(5, 'mixed'); // Third segment (mix of numbers & letters)

  $code = "{$namePrefix}-{$randomSegment1}-{$randomSegment2}-{$randomSegment3}";

  // Check if the generated code already exists in the database
  if (checkCodeExists($con, $code)) {
      return generateCouponCode($name, $country, $plan, $con); // Recursively generate a new one if it exists
  }

  // Insert the generated code into the database
  insertCouponCode($code, $country,$plan, $con);

  return $code;
}

// Generate random characters
function generateRandomCharacters($length, $type = 'uppercase') {
  $uppercase = 'ABCDEFGHIJKLMNOPQRSTUVWXYZ';
  $lowercase = 'abcdefghijklmnopqrstuvwxyz';
  $numbers = '0123456789';

  if ($type === 'uppercase') {
      $characters = $uppercase;
  } elseif ($type === 'lowercase') {
      $characters = $lowercase;
  } else { // Mixed (letters + numbers)
      $characters = $lowercase . $numbers;
  }

  $code = '';
  for ($i = 0; $i < $length; $i++) {
      $code .= $characters[rand(0, strlen($characters) - 1)];
  }

  return $code;
}

// Insert coupon code into the database
function insertCouponCode($code, $country, $plan, $con) {
  // Perform a database query to insert the code into the table
  $vendorId = 0; // Replace with the actual vendor ID
  $country_id = $country; // Replace with the actual plan ID
  $amount = 3000; // Replace with the actual amount
  $status = '0'; // Replace with the actual status
  $createdAt = date('Y-m-d H:i:s'); // Current date and time

  $sql = "INSERT INTO coupons (vendor_id, country_id,plan_id, amount, coupon_code, status, created_at)
   VALUES ('$vendorId', '$country_id', '$plan','$amount', '$code', '$status', '$createdAt')";
  mysqli_query($con, $sql);
}



// Check if code exists in the database
function checkCodeExists($con, $code) {
  // Perform a database query to check if the code exists
  $sql = "SELECT COUNT(*) FROM coupons WHERE `coupon_code` = '$code'";
  $result = mysqli_query($con, $sql);
  $count = mysqli_fetch_row($result)[0];

  return $count > 0;
}

?>