Hier ist mein Code. Es wird nur der letzte Elementwert eingefügt. Ich möchte alle Werte in ein Feld mit unterschiedlichen IDs und alle Daten in unterschiedliche Zeilen einfügen.

    public function update($user_slider, $user_welcomebox, $user_servicebox, $user_postbox, $user_testimonials, $user_welcomemessage, $user_welcomededcription, $user_welcomelink, $user_welcomelinktitle, $user_servicetitle, $user_totalservicedisplay, $user_ourservice, $user_blogtitle, $user_totalblogdisplay,$user_ourblog, $user_newstitle, $user_totalnewsdisplay, $user_ournews, $user_totaltestimonialdisplay, $user_ourtestimonial) {
    $db = connectionstart();
     $currentdatetime = date("Y-m-d H:i:s", time());
        $currentgmtdatetime = gmdate("Y-m-d H:i:s", time() - (5 * 60 * 60));
    $sql = "select * from user_options ";
    $result = mysql_evaluate($db, $sql, 0);
    $columns = array(
        "name" => 'slider'
            , "value" => $user_slider
        ,"name" => 'welcomebox'
            , "value" => $user_welcomebox
        ,"name" => 'servicebox'
            , "value" => $user_servicebox
        ,"name" => 'postbox'
            , "value" => $user_postbox
        ,"name" => 'testimonials'
            , "value" => $user_testimonials
        ,"name" => 'welcomemessage'
            , "value" => $user_welcomemessage
        ,"name" => 'welcomededcription'
            , "value" => $user_welcomededcription
        ,"name" => 'welcomelink'
            , "value" => $user_welcomelink
        ,"name" => 'welcomelinktitle'
            , "value" => $user_welcomelinktitle
        ,"name" => 'servicetitle'
            , "value" => $user_servicetitle
        ,"name" => 'totalservicedisplay'
            , "value" => $user_totalservicedisplay
        ,"name" => 'ourservice'
            , "value" => $user_ourservice
        ,"name" => 'blogtitle'
            , "value" => $user_blogtitle
        ,"name" => 'totalblogdisplay'
            , "value" => $user_totalblogdisplay
        ,"name" => 'ourblog'
            , "value" => $user_ourblog
        ,"name" => 'newstitle'
            , "value" => $user_newstitle
        ,"name" => 'totalnewsdisplay'
            , "value" => $user_totalnewsdisplay
        ,"name" => 'ournews'
            , "value" => $user_ournews
        ,"name" => 'totaltestimonialdisplay'
            , "value" => $user_totaltestimonialdisplay
        ,"name" => 'ourtestimonial'
            , "value" => $user_ourtestimonial
        , "entrydate" => $currentdatetime

        );
    if ($result != 0) {
        $result = mysql_update($db, "user_options", $columns, "");
        if ($result == true) {
            $result = 'SUCCESS';
        }
    } else {
        $result = mysql_insert($db, "user_options", $columns, "");
        if ($result == true) {
            $result = 'SUCCESS';
        }
    }
    connectionclose($db);
    return $result;
}

dieser Code fügt nur den letzten Wert wie diesen ein

id          name             value
 1          testimonials      5

Ich möchte Daten wie diese einfügen

id      name               value
 1      slider               0
 2      welcome box          1
 3      welcome message      hi

Funktion für Update

     if (!function_exists('mysql_update')) {

function mysql_update($db, $table, $columns, $where = "") {
    $sql = "UPDATE `" . $table . "` SET";
    $arry = array();
    foreach ($columns as $field => $value) {
        array_push($arry, " `" . $field . "`='" . $value . "' ");
    }
    // implode keys of $array...
    $sql .= implode(",", $arry);
    if (isset($where) && $where != "") {
        $sql .= " " . $where;
    }
    $result = mysql_query($sql, $db) or die(mysql_error());
    return $result;
}

}

Funktion für Einfügen

       if (!function_exists('mysql_insert_multiple')) {

function mysql_insert_multiple($db, $table, $columns) {
    $sql = "INSERT INTO `" . $table . "` ";
    // implode keys of $array...
    $sql .= " (`" . implode("`, `", array_keys($columns[0])) . "`)";
    // implode values of $array...
    $sql .= " VALUES ";
    $tempstr = array();
    foreach ($columns as $row) {
        $tempstr[] = " ('" . implode("', '", $row) . "') ";
    }
    $sql.=implode(',', $tempstr);
    $sql.=";";
    $result = mysql_query($sql, $db) or die(mysql_error());
    return $result;
}

}