speaker Multimusen

At finde seneste autoincrement

May 15th, 2013 by

Kanbanens logfil skal gemme nummeret på sidste autoincrement i en anden tabel. Men hvordan finder man det? Løsning (inspired by this blogpost):

        // looking for the number of the last id increment
        $last = $wpdb->get_row("SHOW TABLE STATUS LIKE 'kbnQotes'");
        $lastid = $last->Auto_increment -1;

        // adding the entry to the log
        $title = date('Y-m-d G:i:s') . '<br /><strong> ' . $_POST['Title'] . '</strong><br />' .  $_POST['What'];

                // indsaetter ingen vaerdi i Id ... hvordan opdateres den?
                $wpdb->insert(
                        "KbnQog",
                        array(
                                'Id' => NULL,
                                'What' => $_POST['What'],
                                'KbnNotesId' => $lastid,
                                'KbnStatesId' => $_POST['KbnStatesId'],
                                'KbnProjectsId' => $_POST['KbnProjectsId'],
                                'KbnNotesName' => $title,
                                'Date' => date('Y-m-d G:i:s')
                        ),
                        array(
                                '%d', '%s', '%d', '%d', '%d', '%s', '%s'
                        )
                );