One Hat Cyber Team

View File Name : create_csv_users.php

<?php session_start();?>


<?php include('../../connections.php'); ?>

<?php

	$upload_status="";
	
	if(isset($_POST['submit'])) {
     
                // Define file details
          $fileName = $_FILES['file']['name'];
          $fileTmpName = $_FILES['file']['tmp_name'];
          $fileType = $_FILES['file']['type'];

          // Check if file is a CSV
          if($fileType !== 'text/csv') {
            die("Error: Please upload a CSV file.");
          }

          // Open file and read data
          $file = fopen($fileTmpName, "r");

          // Skip the first row (header)
          fgetcsv($file);

          // Loop through data and insert into database
          while (($data = fgetcsv($file, 1000, ",")) !== FALSE) {
            
           try {
            // Escape data to prevent SQL injection
            $phone = mysqli_real_escape_string($connect, $data[0]);
            $name = mysqli_real_escape_string($connect, $data[1]);
            $city = mysqli_real_escape_string($connect, $data[2]);
            $email = mysqli_real_escape_string($connect, $data[3]);

            $currentDate = date('Y-m-d');

            $hash = md5($phone);

             // Query to check if user ID exists in database
            $sql_count = "SELECT COUNT(*) as count FROM users WHERE user_id = $phone";
             
             $result_COUNT = mysqli_query($connect, $sql_count);

             
             $row = mysqli_fetch_assoc($result_COUNT);
             $count = $row['count'];
             
             if ($count == 0) {
               
                               // Insert data into database
                 $sql = "INSERT INTO `users`(`user_id`, `name`, `city`, `email`, `password`, `created_date`,  `profile`, `status`) 
                 VALUES ('$phone','$name','$city','$email','$hash','$currentDate','','')";

                if(mysqli_query($connect, $sql)) {

                 // echo "Record added successfully.<br>";

                  $upload_status="success";

                } else {

                  // echo "Error: " . mysqli_error($connect) . "<br>";

                   $upload_status="fail";

                }
               
             }
             

            
       		} catch (Exception $e) {
             
              $upload_status="fail";

                    // handle the exception

          }

          }

          // Close file and database connection
          fclose($file);
          mysqli_close($connect);
 

    }
?>

<!DOCTYPE html>

<html lang="en">
  <head>
    <meta charset="utf-8" />
    <link rel="apple-touch-icon" sizes="76x76" href="g">
    <link rel="icon" type="image/png" href="assets/img/favicon.png">
    <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1" />
    <title>Thuru</title>
    <meta content='width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=0, shrink-to-fit=no' name='viewport' />
    <link href="https://fonts.googleapis.com/css?family=Montserrat:400,700,200" rel="stylesheet" />
    <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/font-awesome/latest/css/font-awesome.min.css" />
    <!-- CSS Files -->
    <link href="assets/css/bootstrap.min.css" rel="stylesheet" />
   <link href="assets/css/light-bootstrap-dashboard.css?v=2.0.1" rel="stylesheet" />
    <link href="https://cdn.jsdelivr.net/npm/select2@4.0.12/dist/css/select2.min.css" rel="stylesheet" />
    <link href="https://cdnjs.cloudflare.com/ajax/libs/select2/4.0.6-rc.0/css/select2.min.css" rel="stylesheet" />
    <script src="https://cdnjs.cloudflare.com/ajax/libs/select2/4.0.6-rc.0/js/select2.min.js"></script>
    <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css"></script>
    <link href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css" rel="stylesheet" />
   <link href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css" rel="stylesheet" />
    <script src="https://cdn.tiny.cloud/1/2igvmvhno245qw3kilqkwmuc2atwu0w1unsi8xj4y87a9cpz/tinymce/5/tinymce.min.js" referrerpolicy="origin"></script>
   <link href="assets/css/demo.css" rel="stylesheet" />



<style>
	 .inline{
		 display: inline-block;
		 float: right;
		 margin: 20px 0px;
	 }
	 input,button{
		 height: 34px;
	 }

</style>

  </head>


	<body>



        <?php include('./header.php');?>



        <div class="main-panel">



        <?php include('./side_bar.php');?>



            <div class="content">



                <div class="container-fluid">

                    <div class="container-fluid">


                    <div class="content pl-0 pr-0">

                <div class="container-fluid">


                        <div class="row">



                     <div class="row">
                      <div class="col-md-12">
                          <?php

						

								if($upload_status=="success"){

                                   echo '<div class="alert alert-success">
                                     	<strong>Success!</strong> Successfully Uploaded
                                     	</div>';

                                }else if( $upload_status=="fail"){

                                  		echo '<div class="alert alert-danger">

                                            <strong>False!</strong>Try Again Later</div>';

                                }

                       
                          ?>


                               <form id="RegisterValidation" enctype="multipart/form-data" method="post">

                                 
                                  <div class="card ">
                                       <div class="card-header ">
										<h4 class="card-title">Add your CSV file</h4>
                                       </div>
                                       <div class="card-body ">
                                         <div class="row">
                                               <div class="form-group has-label col-md-6">
                                                   <label class="pb-1">
                                                   CSV
                                                   <star class="star">*</star>

                                                   </label>
                                                   <input type="file" class="form-control "  name="file" accept=".csv"  />
                                               </div>
                                           </div>
                                           <div class="card-category form-category">
                                           <star class="star">*</star> Required fields</div>
                                      </div>
                                       <div class="card-footer text-right">
                                           <button type="submit" name="submit" class="btn btn-info btn-fill pull-right" id="button">SUBMIT</button>
                                           <div class="clearfix"></div>
                                       </div>

                                   </div>

                                  </form>

                            </div>

                        </div>

                    </div>

                </div>
            </div>
            <footer class="footer">
                <div class="container">
                    <nav>
                        <p class="copyright text-center">
                            ©
                            <script>
                                document.write(new Date().getFullYear())
                            </script>
                            <a href="https://inoxzasolutions.com/">Inoxza Solutions</a>Innovations Foreve
                        </p>
                    </nav>
                </div>
            </footer>
        </div>
    </div>
</body>


</html>

      <!--   Core JS Files   -->
<script src="assets/js/core/jquery.3.2.1.min.js" type="text/javascript"></script>
<script src="assets/js/core/popper.min.js" type="text/javascript"></script>
<script src="assets/js/core/bootstrap.min.js" type="text/javascript"></script>
<script src="assets/js/plugins/bootstrap-switch.js"></script>
<!--  Google Maps Plugin    -->
<script type="text/javascript" src="https://maps.googleapis.com/maps/api/js?YOUR_KEY_HERE"></script>
<!--  Chartist Plugin  -->
<script src="assets/js/plugins/chartist.min.js"></script>
<!--  Notifications Plugin    -->
<script src="assets/js/plugins/bootstrap-notify.js"></script>
<!--  jVector Map  -->
<script src="assets/js/plugins/jquery-jvectormap.js" type="text/javascript"></script>

<!--  Plugin for Date Time Picker and Full Calendar Plugin-->
<script src="assets/js/plugins/moment.min.js"></script>
<!--  DatetimePicker   -->
<script src="assets/js/plugins/bootstrap-datetimepicker.js"></script>
<!--  Sweet Alert  -->
<script src="assets/js/plugins/sweetalert2.min.js" type="text/javascript"></script>
<!--  Tags Input  -->
<script src="assets/js/plugins/bootstrap-tagsinput.js" type="text/javascript"></script>
<!--  Sliders  -->
<script src="assets/js/plugins/nouislider.js" type="text/javascript"></script>

<!--  Bootstrap Select  -->
<script src="assets/js/plugins/bootstrap-selectpicker.js" type="text/javascript"></script>

<script src="assets/js/plugins/jquery.validate.min.js" type="text/javascript"></script>

<script src="assets/js/plugins/jquery.bootstrap-wizard.js"></script>

<script src="assets/js/plugins/bootstrap-table.js"></script>

<script src="assets/js/plugins/jquery.dataTables.min.js"></script>

<script src="assets/js/plugins/fullcalendar.min.js"></script>

<script src="assets/js/light-bootstrap-dashboard.js?v=2.0.1" type="text/javascript"></script>