# upload files
## Image Upload
{% hint style="info" %}
sedang dalam uji coba
{% endhint %}
image Upload adalah sebuah class helper dengan object oriented atau OOP yang menangani fitur image uploaded
{% hint style="success" %}
support extention file pdf, png, jpeg, png, gif, svg, doc, docx, txt,
{% endhint %}
### upload()
uploaded memiliki 3 paramter wajib, namafile, target directory, generate name files, dan akan result sebuah data object.
```php
Upload("name_files_image", "directory", "generate_file_name");
```
### value
* "gambar" => name file dari name di html
* $directory => target directory
* false => file tidak di generate nama filesnya
* true => false di generate random nama filesnya
{% hint style="info" %}
nama "gambar nama file pada html input type files
{% endhint %}
**pada berkas view html**
```php
```
**pada berkas controller**
```php
Upload("gambar", $directory, false);
# result
var_dump($data);
```
**result berupa object**
```php
object(stdClass)[57]
public 'image_original_name' => string 'preview.jpg' (length=11)
public 'image_name' => string '86e8985aa845f5a82b2b72e2b7bed713.jpg' (length=36)
public 'image_type' => string 'image/jpeg' (length=10)
public 'image_size' => int 1238922
public 'image_error' => int 0
```
### update files ()
untuk melakukan update files, files yang di update akan menghapus file lama dan mereplacenya dengan files baru mempunyai empat parameter
```php
UpdateFile("file_lama", "file_baru", "directory", "generate_file_name");
```
**pada berkas view html**
```php
```
**pada berkas controller**
```php
UpdateFile($oldfiles, "gambar", $directory, true);
# result object
var_dump($data);
# get nama files
echo $data->image_name; #or
# save nama files to variabel
$image = $data->image_name;
```
### interacting image with database
untuk interacsi dengan data didatabase
```php
# uploaded algorithm
# uploade image
# 1. uploaded files images
# 2. getting name files image
# 3. insert name files image to database
# update images
# 1. update files image
# 2. getting name files image
# 3. update name files image to database
```
## Files Upload ( pdf , exel, doc )
{% hint style="info" %}
sedang dalam uji coba
{% endhint %}
### upload csv or excel
untuk upload files berformas csv atau excel dapat menggunakan libraries office yang dibuat yaitu **read\_file*****\_*****csv().** untuk mengubah field pada csv menjadi array. setelah berubah menjadi array bisa di coba melakukan looping insert data.
```php
use MiniMvc\Apps\Libraries\office; // libraries
$office = new office; // buat object baru
$office->read_file_csv("namefile"); // return object
```
#### example
arah routenya web.php
**web.php**
```php
$router->get('office/upload', function () {
Routes::Routing("officeController", "index");
});
$router->post('office/upload', function () {
Routes::Routing("officeController", "upload");
});
```
**office\_view\.php**
```php
Document
```
pada berkas controllernya
**officeController.php**
**ini akan me return atau mengembalikan nilai array**
```php
use MiniMvc\Apps\Libraries\office;
class welcome extends Controller
{
public function __construct()
{
// code here
}
public function index()
{
view("office_view");
}
public function upload()
{
$office = new office;
$data = $office->read_file_csv("document"); // name di input html
dump($data); // debug return object
}
}
```
## Multiple Insert
untuk multiple insert data, hasil membaca file dari file excel itu bisa dilakukan dengan looping
example hasil read file excel \*covid-19 data example\*,
{% hint style="info" %}
index 0 atau pertama adalah nama column by row,
{% endhint %}
sebelum di remove index 0 atau nama columnnya :
```php
^ array:15 [▼
0 => array:6 [▼
0 => null
1 => "ODP"
2 => "PDP"
3 => "POSITIF"
4 => "SEMBUH"
5 => "MENINGGAL"
]
1 => array:6 [▼
0 => "3/26/2020"
1 => 204
2 => 89
3 => 17
4 => 0
5 => 4
]
2 => array:6 [▶]
3 => array:6 [▶]
4 => array:6 [▶]
5 => array:6 [▶]
6 => array:6 [▶]
7 => array:6 [▶]
8 => array:6 [▶]
9 => array:6 [▶]
10 => array:6 [▶]
11 => array:6 [▶]
12 => array:6 [▶]
13 => array:6 [▶]
14 => array:6 [▶]
]
```
{% hint style="info" %}
index 1 \~ n ke dua adalah isi dari field column by row
{% endhint %}
sesudah di remove index 0 dan yg tersisa hanya isi by row
```php
^ array:14 [▼
1 => array:6 [▼
0 => "3/26/2020"
1 => 204
2 => 89
3 => 17
4 => 0
5 => 4
]
2 => array:6 [▼
0 => "3/27/2020"
1 => 207
2 => 99
3 => 17
4 => 0
5 => 4
]
3 => array:6 [▶]
4 => array:6 [▶]
5 => array:6 [▶]
6 => array:6 [▶]
7 => array:6 [▶]
8 => array:6 [▶]
9 => array:6 [▶]
10 => array:6 [▶]
11 => array:6 [▶]
12 => array:6 [▶]
13 => array:6 [▶]
14 => array:6 [▶]
]
```
step by step
1. remove atau unset column pada index 0
2. buat model dan method save atau insert
3. loop data readfile remove fieldnya
### buat model
```php
class DocumentModel
{
private $table = 'documents';
private $db;
public function __construct()
{
$this->db = new Database;
}
public function save($tanggal, $odp, $pdp, $positif, $sembuh, $meninggal)
{
// query data insert
// (`id`, `tanggal`, `odp`, `pdp`, `positif`, `sembuh`, `meninggal`);
$query = "INSERT INTO $this->table VALUES ('',:tanggal,:odp,:pdp,:positif,:sembuh,:meninggal)";
$this->db->query($query);
// binding untuk data string
$this->db->bind('tanggal', $tanggal);
$this->db->bind('odp', $odp);
$this->db->bind('pdp', $pdp);
$this->db->bind('positif', $positif);
$this->db->bind('sembuh', $sembuh);
$this->db->bind('meninggal', $meninggal);
// execute insert atau save data
$this->db->execute();
return $this->db->rowCount();
}
}
```
### pada controllernya
```php
public function store()
{
// code here store here
$file_excel = office::read_file_csv("files");
// remove column
unset($file_excel->worksheet[0]);
// call model
$excel = model("DocumentModel");
// loop mutiple insert
foreach($file_excel->worksheet as $key){
$excel->save($key[0],$key[1],$key[2],$key[3],$key[4],$key[5]);
}
}
```
---
# Agent Instructions: Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter:
```
GET https://nagara.gitbook.io/code-zero-project/helper/upload-files.md?ask=
```
The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.