database - wpdb Insert unknown post data dynamic foreach loop

admin管理员组

文章数量:1289868

I have this old function which I would like to use in WordPress.

public function database_insert( $table, $data ) {
        $data_key = "(";
        $data_value = "(";
        $i = 0;

        foreach ($data as $key => $value)  {
            if ( $key != "speichern" ) {
                if ( $i != 0 ) {
                    $data_key = $data_key.", ";
                    $data_value = $data_value.", ";
                }

                $data_key = $data_key.$key;

                if ( $value == "NULL" ) {
                    $data_value = $data_value.$value;
                } else {
                    $data_value = $data_value."'".mysqli_real_escape_string( $this->conn, $value)."'";
                }
                $i++;
            }
        }

        $data_key = $data_key.")";
        $data_value = $data_value.")";
        $i = 0;
        
        $query = "INSERT INTO ".$table." ".$data_key." VALUES ".$data_value;
        $result = mysqli_query( $this->conn, $query ); 
        echo mysqli_error( $this->conn );
        
        if ( $result == 1 ) { 
            return mysqli_insert_id( $this->conn );
        } else {
            return false;
        }
}

Unfortunately, I can't quite figure out how to do this.Does anyone of you have any idea whether this is possible?

本文标签： databasewpdb Insert unknown post data dynamic foreach loop