Untitled

<?php
/*
Template Name: visualizador de niveles
*/
?>
<?php

get_header();

$is_page_builder_used = et_pb_is_pagebuilder_used( get_the_ID() );

?>
<div id="main-content-visualización" style="padding-top: 13%;padding-left: 12%;padding-bottom: 5%;">
<?php
if (is_user_logged_in()){$cu = wp_get_current_user();
$patrocinador=$cu->user_login ;
}
//variables y conexion mysql
$hostname="localhost";
$username="myinvestpa";
$password="jPd4qB06";
$dbname="investpainbbdd";
$conn = mysqli_connect($hostname,$username,$password) or die ("<html><script language='JavaScript'>alert('Unable to connect to database! Please try again later.'),history.go(-1)</script></html>");
mysqli_select_db($conn,$dbname);


$query = "SELECT *
FROM wp_usermeta um1
WHERE um1.user_id IN ( SELECT um2.user_id FROM wp_usermeta um2 WHERE     um2.meta_key = 'id_del_referido' and um2.meta_value = '".$patrocinador."')AND um1.meta_key = 'nickname'";

$results1 = mysqli_query($conn,$query) or die('ok');

echo '<ul class="lista-nivel-uno">';

while ($fila = mysqli_fetch_row($results1)) {
echo '<li>'.$fila[3].'</li>'; //Ponemos $fila[3] debido a que es la columna de los valores

$query2 = "SELECT *
FROM wp_usermeta um1
WHERE um1.user_id IN ( SELECT um2.user_id FROM wp_usermeta um2 WHERE um2.meta_key = 'id_del_referido' and um2.meta_value = '".$fila[3]."')AND um1.meta_key = 'nickname'";
$results2 = mysqli_query($conn,$query2) or die('ok');

while ($fila2 = mysqli_fetch_row($results2)) {
echo '<ul class="lista-nivel-dos><li>'.$fila2[3].'</li>';

}
}
echo '</ul>';
echo '  </ul>';
?>
</div> <!-- #main-content -->

<?php get_footer(); ?>