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.

[mudmin]

You are thinking procedurally, instead of thinking like an object oriented programmer. UserSpice can do procedural, but you have to use your own database class (or at least establish your own connection). And...make sure your first column is id. You can have id_brg, but you also want to have a regular id in your database.


Regardless of whether you are updating or inserting, you want to put all of your data into an array before you do your query.

Code:

$fields=array('id_brg'=>$id_brg, 'nama_brg'=>'$nama_brg'); //column_name=>entry

Then, if you are INSERTING a new record, all you need is the table you are trying to insert into

So, it would be

Code:

$db->insert('table_name',$fields);

If you are UPDATING, you need to know what record you are updating, so you need to give it that id.

Code:

$db->update('table_name',5,$fields);

To DELETE, you only really need to know the table and some form of logic. So do you want to delete when the username is "bob" or delete when the "id" equals 4. Whatever you want to do, just choose the table name and the logic.

$db->delete('table_name',array('id','=',4));

Pretty much everything you do is just a longer version of that. Does that make sense?
http://userspice.org/documentation-db-class-2/

[picassoo]

you are very good, thank you, now I understand.

[mudmin]

Awesome. Glad I could help.