[insert_php]

$servername = “mysql3000.mochahost.com”;
$username = “techoki_spp”;
$password = “(^vwx.}vDy],”;
$dbname = “techoki_ssp”;

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die(“Falha na Conexão: ” . $conn->connect_error);
}

$eventoId = $_GET[‘eventoId’] == NULL ? 0 : $_GET[‘eventoId’];

$sql = “SELECT id,title FROM ssp_events”;

$result = $conn->query($sql);

echo “

Selecione um evento para visualizar as inscrições.

“;

echo ““;
echo “Selecione um evento“;
while($row = $result->fetch_assoc()) {
echo “” . $row[“title”] . ““;
}
echo ““;

if($eventoId > 0)
{
$sql = “SELECT * FROM ssp_events_registration WHERE EventoId = ” . $eventoId;
$result = $conn->query($sql);
if ($result->num_rows > 0) {
echo “

“;
}

[/insert_php]