We can also use the code to perform the import other file types.
For example import the tables and data from a text file (txt).
First we should create two applications of the type Blank, let's call them blank and blank_2.
In the event of OnExecute blank application, put the following code:
?>
<center>
<form style='margin-top:50px;' action="../blank_2/blank_2.php" method="POST" enctype="multipart/form-data">
<fieldset>
<p><label for="Send file">Send file:</label></p>
<input type="file" name="file" class="width233" />
<input type="submit" name="send" value="Send" />
</fieldset>
</form>
</center>
<?php
We can see the action directed to the blank_2 application.
In the event OnExecute of blank_2 application put the code below:
$file = $_FILES['file'];
$file = file($file['tmp_name']);
$file_name = explode(".",$file['name']);
foreach ($file as $line_num => $line) {
if($line_num==0){
$columns = str_replace(" "," varchar(255),",$line);
sc_exec_sql("CREATE TABLE IF NOT EXISTS ".$file_name[0]." (".$columns." varchar(225) )","conn_mysql");
$columns = str_replace(" ",",",$line);
}
if($line_num>=1){
$date = str_replace(" ","','",$line);
sc_exec_sql("INSERT INTO ".$file_name[0]." ( ".$columns.") values ( '".$date."')","conn_mysql");
}
}
sc_lookup(ds,"SELECT COUNT(*) FROM ".$file_name[0],"conn_mysql");
if({ds[0][0]}>0){
sc_alert("Inserted records successfully!");
}
When performing the blank can view the following screen:
When entering a file:
And when we click on send:
Model for sending text file:
First line: Name of the columns, followed by a space.
Second line onwards: Values column.
Example:
Id Name Passowrd
1 Netmake Netmake
2 Netmake Netmake
Ronyan Alves
Comments
Seta Sistemas