The following warnings occurred:
Warning [2] Undefined variable $unreadreports - Line: 26 - File: global.php(961) : eval()'d code PHP 8.1.2-1ubuntu2.14 (Linux)
File Line Function
/global.php(961) : eval()'d code 26 errorHandler->error
/global.php 961 eval
/printthread.php 16 require_once



UserSpice
structure for statement in php for mysqli - Printable Version

+- UserSpice (https://userspice.com/forums)
+-- Forum: General (https://userspice.com/forums/forumdisplay.php?fid=20)
+--- Forum: UserSpice 5 - Roadmapping the Future (https://userspice.com/forums/forumdisplay.php?fid=31)
+--- Thread: structure for statement in php for mysqli (/showthread.php?tid=210)

structure for statement in php for mysqli - picassoo - 08-22-2016

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.

structure for statement in php for mysqli - mudmin - 08-22-2016

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/

structure for statement in php for mysqli - picassoo - 08-22-2016

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

structure for statement in php for mysqli - mudmin - 08-22-2016

Awesome. Glad I could help.