At finde seneste autoincrement

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?
                                'Id' => NULL,
                                'What' => $_POST['What'],
                                'KbnNotesId' => $lastid,
                                'KbnStatesId' => $_POST['KbnStatesId'],
                                'KbnProjectsId' => $_POST['KbnProjectsId'],
                                'KbnNotesName' => $title,
                                'Date' => date('Y-m-d G:i:s')
                                '%d', '%s', '%d', '%d', '%d', '%s', '%s'

By Per Thykjaer Jensen

Per is the WordPress expert at Business Academy Aarhus. Senior Lecturer at the Multimedia Design Programme. His background is in the Arts: MA Literature History and BA Art History. Later he added a MA in IT, interaction and Multimedia. And he is a wicked Linux user.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

We use cookies - is it ok with you+ more information will set a few cookies from Doubleclick, Google and the Social Media plugins they ay set some cookies.