ID an PopUp übergeben

function print_Sportler() {
    $content = "<figure class='wp-block-table is-style-stripes'><table>";
    $content .= "<thead>
                    <tr>
                        <th>ID</th>
                        <th>Name</th>
                        <th>Alter</th>
                        <th>Aktiv</th>
                        <th>Disziplin</th>
                    </tr>
                <thead>";
    $content .= "<tbody>";
    
    $res = execute_query("select * from Sportler");
    
    if($res->num_rows > 0) {
        // ... schreibe jeden Datensatz in eine Zeile
        while($row = $res->fetch_assoc()) {
            $content .= "<tr>
                            <td>" . $row["ID"] . "</td>
                            <td>" . $row["Name"] . "</td>
                            <td>" . $row["Alter"] . "</td>
                            <td>" . $row["Aktiv"] . "</td>
                            <td>" . $row["Disziplin"] . "</td>
                        </tr>";
        }
    }
    
    $content .= "</tbody></table></figure>";
    
    return $content;
}

function print_MitgliederDetails($id) {
    // Kopf der Tabelle
    $content = "<figure class='wp-block-table is-style-stripes'><table>";
    $content .= "<thead>
                    <tr>
                        <th>ID</th>
                        <th>Name</th>
                        <th>Alter</th>
                        <th>Aktiv</th>
                        <th>Disziplin</th>
                    </tr>
                <thead>";
    $content .= "<tbody>";
    
    // Daten fuer die Tabelle holen
    $res = execute_query("select $id from Formation");
    
    // Wenn Daten existieren ...
    if($res->num_rows > 0) {
        // ... schreibe jeden Datensatz in eine Zeile
        while($row = $res->fetch_assoc()) {
            $content .= "<tr>
                            <td>" . $row["ID"] . "</td>
                            <td>" . $row["Name"] . "</td>
                            <td>" . $row["Alter"] . "</td>
                            <td>" . $row["Aktiv"] . "</td>
                            <td>" . $row["Disziplin"] . "</td>
                        </tr>";
        }
    }
    
    // Tabelle endet hier
    $content .= "</tbody></table></figure>";
    
    return $content;
}

function print_mitglieder() {
//Hier wird das JavaScript erstellt


    echo "<script>function myFunction() {alert('<?php echo print_MitgliederDetails() ?>')};</script>";
    


    $content = "<figure><table>";
    $content .= "<thead>
                    <tr>
                        <th>ID</th>
                        <th>Vorname</th>
                        <th>Nachname</th>
                        <th>Geburtsdatum</th>
                        <th>Beispiel</th>
                    </tr>
                <thead>";
    $content .= "<tbody>";
    
    $res = execute_query("select * from Mitglied");
    
    if($res->num_rows > 0) {
        while($row = $res->fetch_assoc()) {
            $currDate = $row["Geburtsdatum"];
            $changeDate = date("d-m-Y", strtotime($currDate));
            $mitgliedID = $row['MitgliederID'];
            if($mitgliedID % 2 == 0)
            $content .= "<tr class='whiteRow'>
                            <td><a href='#' data-toggle='tooltip' title=' ' id=" . $row['MitgliederID'] . ">" . $row["MitgliederID"] . "</a></td>
                            <td><a onclick='myFunction()'>" . $row["Vorname"] . "</a></td>
                            <td>" . $row["Nachname"] . "</td>
                            <td>" . $changeDate . "</td>
                            <td>" . '<a href="javascript:PUM.open(288);">DetailAnsicht</a>' . "</td>
                        </tr>";
            else
                    $content .= "<tr class='grayRow'>
                            <td><a href='#' data-toggle='tooltip' title='Hooray!' id=" . $row['MitgliederID'] . ">" . $row["MitgliederID"] . "</a></td>
                            <td>" . $row["Vorname"] . "</td>
                            <td>" . $row["Nachname"] . "</td>
                            <td>" . $changeDate . "</td>
                            <td>" . '<a href="javascript:PUM.open(288);">DetailAnsicht</a>' . "</td>
                        </tr>";
        }
    }
    
    $content .= "</tbody></table></figure>";


    return $content;
}

function create_verein_cpt() {


    $labels = array(
        'name' => 'Verein',
        'singular_name' => 'Verein',
    );
    $args = array(
        'label' => __( 'Verein', 'Verein' ),
        'description' => __( 'Verein', 'Verein' ),
        'labels' => $labels,
        'menu_icon' => 'dashicons-admin-tools',
        'supports' => array(),
        'taxonomies' => array(),
        'public' => true,
        'show_ui' => true,
        'show_in_menu' => true,
        'menu_position' => 5,
        'show_in_admin_bar' => true,
        'show_in_nav_menus' => true,
        'can_export' => true,
        'has_archive' => true,
        'hierarchical' => false,
        'exclude_from_search' => false,
        'show_in_rest' => true,
        'publicly_queryable' => true,
        'capability_type' => 'post',
    );
    register_post_type( 'verein', $args );


}
add_action( 'init', 'create_verein_cpt', 0 );


add_action( 'admin_init', 'my_admin' );


function my_admin() {
    add_meta_box(
        'verein_review_meta_box',
        'Verein Informationen',
        'display_verein_review_meta_box',
        'verein',
    );
}


function display_verein_review_meta_box() {
    ?>
    <table>
        <tr>
            <td style="width: 50%">ID</td>
            <td><input type="text" size="40" name="verein" value="<?php echo get_post_meta( get_the_ID(), 'ID', true ); ?>"  /></td>
        </tr>
        <tr>
            <td style="width: 50%">Vereinsname</td>
            <td><input type="text" size="40" name="verein" value="<?php echo get_post_meta( get_the_ID(), 'Name', true ); ?>"  /></td>
        </tr>
        <tr>
            <td style="width: 50%">Vereins Email</td>
            <td><input type="text" size="40" name="verein" value="<?php echo get_post_meta( get_the_ID(), 'Email', true ); ?>"  /></td>       
        </tr>
        <tr>
            <td style="width: 50%">Landesverband</td>
            <td><input type="text" size="40" name="verein" value="<?php echo get_post_meta( get_the_ID(), 'Verband', true ); ?>"  /></td>       
        </tr>
    </table>
    <?php
}


add_action( 'wp', 'insert_into_verein_cpt' );


function check_for_similar_meta_ids() {
    $id_arrays_in_cpt = array();


    $args = array(
        'post_type'      => 'verein',
        'posts_per_page' => -1,
    );


    $loop = new WP_Query($args);
    while( $loop->have_posts() ) {
        $loop->the_post();
        $id_arrays_in_cpt[] = get_post_meta( get_the_ID(), 'ID', true );
    }


    return $id_arrays_in_cpt;
}


function query_verein_table( $verein_available_in_cpt_array ) {
    global $wpdb;
    $table_name = $wpdb->prefix . 'verein';


    if ( NULL === $verein_available_in_cpt_array || 0 === $verein_available_in_cpt_array || '0' === $verein_available_in_cpt_array || empty( $verein_available_in_cpt_array ) ) {
        $results = $wpdb->get_results("SELECT * FROM $table_name");
        return $results;
    } else {
        $ids = implode( ",", $verein_available_in_cpt_array );
        $sql = "SELECT * FROM $table_name WHERE id NOT IN ( $ids )";
        $results = $wpdb->get_results( $sql );
        return $results;
    }
}


function insert_into_verein_cpt() {


    $verein_available_in_cpt_array = check_for_similar_meta_ids();
    $database_results = query_verein_table( $verein_available_in_cpt_array );


    if ( NULL === $database_results || 0 === $database_results || '0' === $database_results || empty( $database_results ) ) {
        return;
    }


    foreach ( $database_results as $result ) {
        $verein_model = array(
            'post_title' => wp_strip_all_tags( $result->Name ),
            'meta_input' => array(
                'ID'        => $result->ID,
                'Name'        => $result->Name,
                'Email'        => $result->Email,
                'Verband'        => $result->Verband,
            ),
            'post_type'   => 'verein',
            'post_status' => 'publish',
        );
        wp_insert_post( $verein_model );
    }
}