File manager - Edit - /home/autoph/public_html/connect/home/import_fleet_database.php
Back
<?php include 'core/database/connect.php'; $uploadCount=0; //$conn = mysqli_connect("localhost", "root", "aee1024", "db_vts"); if (isset($_POST["import"])) { $fileName = $_FILES["file"]["tmp_name"]; if ($_FILES["file"]["size"] > 0) { $file = fopen($fileName, "r"); while (($column = fgetcsv($file, 5000, ",")) !== FALSE) { $uploadCount=$uploadCount+1; $sqlInsert = "INSERT into businesses_names(bid, business_name, type, business_region, business_municipality, business_city, business_barangay, business_street, contact_person, sales_person, contact_number, email, fb_account, website_link, date_time_added, status, comp_owner_id, deal_owner_id, last_update_date, data_assigned_to, last_update_time, lead_tag, dormant, owner) values ('".$column[0]."','".$column[1]."','".$column[2]."','".$column[3]."','".$column[4]."','".$column[5]."','".$column[6]."','".$column[7]."','".$column[8]."','".$column[9]."','".$column[10]."','".$column[11]."','".$column[12]."','".$column[13]."','".$column[14]."','".$column[15]."','".$column[16]."','".$column[17]."','".$column[18]."','".$column[19]."','".$column[20]."','".$column[21]."','".$column[22]."','".$column[23]."')"; //$result = mysqli_query($conn, $sqlInsert); $result = mysqli_query($sqlInsert); if (!empty($result)) { $type = "success"; $message = "New Service Appointment has been uploaded to yout system"; $upLoad=1; } else { $type = "error"; $message = "<p style='text-align:left;margin:20px;'>Problem in Importing CSV Data. Possible duplicate record detected.</p>"; $upLoad=0; } } } } ?> <!DOCTYPE html> <html> <head> <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script> <div id="wait" style="display:none;width:69px;height:89px;border:0px solid red;position:absolute;top:50%;left:50%;padding:2px;"> <img src='images/demo_wait.gif' width="64" height="64" /><br>Loading..</div> <script src="js/jquery-3.2.1.min.js"></script> <script type="text/javascript"> $(document).ready(function(){ //loading gif animator during query or page load $(document).ajaxStart(function(){ $("#wait").css("display", "block"); }); $(document).ajaxComplete(function(){ $("#wait").css("display", "none"); }); $(document).ready(function() { $("#frmCSVImport").on("submit", function () { $("#response").attr("class", ""); $("#response").html(""); var fileType = ".csv"; var regex = new RegExp("([a-zA-Z0-9\s_\\.\-:])+(" + fileType + ")$"); if (!regex.test($("#file").val().toLowerCase())) { $("#response").addClass("error"); $("#response").addClass("display-block"); $("#response").html("Invalid File. Upload : <b>" + fileType + "</b> Files."); return false; } return true; }); }); </script> </head> <body> <h2 style="padding:20px"> Upload New Fleet Database</h2> <div id="response" class="<?php if(!empty($type)) { echo $type . " display-block"; } ?>"><?php if(!empty($message)) { echo $message; } ?></div> <div class="outer-scontainer"> <div class="row" style='text-align:center'> <form class="form-horizontal" action="" method="post" name="frmCSVImport" id="frmCSVImport" enctype="multipart/form-data"> <div class="input-row" style='border:0px solid red;text-align:left;width:100%;padding-left:20px;background:#ffffff '> <label class="col-md-4 control-label">Choose CSV File</label> <input type="file" name="file" id="file" accept=".csv"> </div> <div class="input-row" style='border:0px solid red;text-align:center;width:100%;padding:25px;background:#transparent'> <button type="submit" id="submit" name="import" class="btn-submit" style='margin-top:15px;padding:4px;border-radius:3px;border:border:1px solid gray;width:100px'>Import</button> <br /> </div> </form> <?php if($uploadCount > 1 && $upLoad==1){echo "<p style='text-align:center;margin:20px;'>".$uploadCount." Records has been uploaded</p>";}else{}?> </div> </div> </body> </html>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings