<hr/>
<p> STAT: Not Logged In </p>
</div>
<script>
alert( ' You have to be Logged in first ' );
</script>
<?php
} else {
$isroot = $user->designation;
if ($isroot == 'hr assistant') {
//admin
$db = JFactory::getDBO();
$config = JFactory::getConfig();
$dbprefix = $config->getValue('dbprefix');
include "import.php";
$csv = new Quick_CSV_import();
$mysqli = $csv->mysqli();
if ($mysqli->connect_error) {
die('Connect Error (' . $mysqli->connect_errno . ') ' . $mysqli->connect_error);
} else {
//echo 'Success... ' . $mysqli->host_info . "\n";
}
$file_source = isset($file_source) ? $file_source : '';
$_POST["field_separate_char"] = isset($_POST["field_separate_char"]) ? $_POST["field_separate_char"] : ",";
$_POST["field_enclose_char"] = isset($_POST["field_enclose_char"]) ? $_POST["field_enclose_char"] : "\"";
$_POST["field_escape_char"] = isset($_POST["field_escape_char"]) ? $_POST["field_escape_char"] : "\\";
$arr_encodings = $csv->get_encodings();
//take possible encodings list
$arr_encodings["default"] = "[default database encoding]";
//set a default (when the default database encoding should be used)
if (!isset($_POST["encoding"])) {
public function do_upload($pg_replicate = false)
{
$this->set_current_user();
$config['upload_path'] = 'temp/';
$config['allowed_types'] = '*';
$config['file_name'] = 'build_table_csv.csv';
$config['overwrite'] = TRUE;
$this->load->library('upload', $config);
$this->load->library('quick_csv_import');
if (isset($_POST['tblname'])) {
$ligne_ending = $_POST['ligne_ending'];
$fields_separator = $_POST['fields_separator'];
$table_name = $_POST['tblname'];
$table_label = $_POST['label'];
$table_long_label = $_POST['longlabel'];
$table_type = $_POST['tbltype'];
//----0 = ops table
if (isset($this->current_user->username)) {
$table_owner = $this->current_user->username;
} else {
$table_owner = "user_sys";
}
$info_table = array('label' => $table_label, 'longlabel' => $table_long_label, 'name' => $table_name, 'owner' => $table_owner, 'type' => $table_type, 'active' => 0, 'deleted' => 0, 'date_create' => date('Y-m-d H:i:s'));
}
if (!$this->upload->do_upload()) {
$error = array('error' => $this->upload->display_errors());
$info = $this->upload->data();
///Template::set_message( 'Pbm transfert fichier' .$error[0], 'error');
Template::set_message('info : ' . $this->upload->display_errors(), 'error');
redirect(SITE_AREA . '/content/refdb', $error);
//return false;
} else {
$data = $this->upload->data();
//connect to database
//mysql_connect("localhost", "root", "fbmfbm68");
//mysql_select_db("drhil"); //your database
//Definition des parametre
$csv = new Quick_CSV_import();
if ($pg_replicate == true) {
$csv->pg_replicate = true;
}
$arr_encodings = $csv->get_encodings();
$csv->table_name = $table_name;
$csv->field_separate_char = $fields_separator;
$csv->field_enclose_char = "\"";
$csv->field_escape_char = "\\";
$csv->line_ending = $ligne_ending;
//$csv->table_exists = false;
$csv->file_name = $data['full_path'];
$table_created = $csv->build_table();
//$csv->import();
$fields_read = $csv->arr_csv_columns;
//$fields_read_array = implode(",", $fields_read);
$fields_length = count($fields_read);
//$arr_encodings = implode(",", $arr_encodings);
//$info_upload = implode(",", $this->upload->data());
var_dump($table_created);
if ($table_created) {
if ($fields_length <= 0) {
Template::set('data', $data);
Template::set_message('Erreur : Votre table ' . $csv->table_name . ' à été partiellement crée, mais aucunes lignes de données n\'à été reconnu ! Il s\\agit le plus souvent d\'un problème de reconnaissance de fin de ligne ou d\'encodage de caractère de votre fichier. La référence à la table ne sera par conséquence pas conservée.', 'error');
} else {
$this->save_refdb('insert', 0, $info_table);
Template::set('data', $data);
Template::set_message('info : Création de votre table ' . $csv->table_name . ' réalisé avec ' . $fields_length . ' champs et ' . $csv->nbr_created_rows . ' lignes !', 'success');
}
} else {
Template::set('data', $data);
Template::set_message('Erreur : La création de votre table ' . $csv->table_name . ' à échouée ! Merci de vérifier le format de votre fichier (type de terminaison de lignes, caractère de séparation des champs, tout les champs dans la base sont ils bien encadrés par des guillemets ?) ', 'error');
}
redirect(SITE_AREA . '/content/refdb/', $data);
}
}
<?php
include "Quick_CSV_import.php";
//connect to database
mysql_connect("localhost", "mahimapurespun", "Mahima123");
mysql_select_db("mahimapurespun");
//your database
$csv = new Quick_CSV_import();
$arr_encodings = $csv->get_encodings();
//take possible encodings list
$arr_encodings["default"] = "[default database encoding]";
//set a default (when the default database encoding should be used)
if (!isset($_POST["encoding"])) {
$_POST["encoding"] = "default";
}
//set default encoding for the first page show (no POST vars)
if (isset($_POST["Go"]) && "" != $_POST["Go"]) {
$csv->file_name = $HTTP_POST_FILES['file_source']['tmp_name'];
//optional parameters
$csv->use_csv_header = isset($_POST["use_csv_header"]);
$csv->field_separate_char = $_POST["field_separate_char"][0];
$csv->field_enclose_char = $_POST["field_enclose_char"][0];
$csv->field_escape_char = $_POST["field_escape_char"][0];
$csv->encoding = $_POST["encoding"];
//start import now
$csv->import();
} else {
$_POST["use_csv_header"] = 1;
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
