structure for statement in php for mysqli

[picassoo]

Hi, can you post here... separate script for: Insert - Upload - select- delete, each option. PHP script only.
I want to do a table, but can not understand script, models/funcs.php

Example
table:
Id,
name,
email,
phone,
and description

Here what I have, example.


<pre>

Code:

// Editare Lista produse *******************************************************************************************************************************
function fetchAllbarangg()
{
    global $mysqli,$db_table_prefix;
    $stmt = $mysqli->prepare("SELECT
        id_brg,
        nama_brg,
        harga_brg,
        desc_brg,
        jml_brg,
        gambar_brg,
        detali_ac,
        detali_atentie,
        Masuri_de_siguranta,
        Semne_si_simptome,
        Pastrare_si_utilizare,
        oferta
        FROM ".$db_table_prefix."barang
        WHERE
        id_brg = ?
        LIMIT 1");
    $stmt->execute();
    $stmt->bind_result($id_brg, $nama_brg, $harga_brg, $desc_brg, $jml_brg, $gambar_brg, $detali_ac, $detali_atentie, $Masuri_de_siguranta, $Semne_si_simptome, $Pastrare_si_utilizare, $oferta);
    
    while ($stmt->fetch()){
        $row[] = array('id_brg' => $id_brg, 'nama_brg' => $nama_brg, 'harga_brg' => $harga_brg, 'desc_brg' => $desc_brg, 'jml_brg' => $jml_brg, 'gambar_brg' => $gambar_brg, 'detali_ac' => $detali_ac, 'detali_atentie' => $detali_atentie, 'Masuri_de_siguranta' => $Masuri_de_siguranta, 'Semne_si_simptome' => $Semne_si_simptome, 'Pastrare_si_utilizare' => $Pastrare_si_utilizare, 'oferta' => $oferta);
    }
    $stmt->close();
    return ($row);
}

</pre>



Thanks.