sahpadamgame.php

<?php require_once('Connections/connection.php'); ?>
<?php
$colname_q_padamgame = "-1";
if (isset($_GET['idpeserta'])) {
  $colname_q_padamgame = (get_magic_quotes_gpc()) ? $_GET['idpeserta'] : addslashes($_GET['idpeserta']);
}
mysql_select_db($database_connection, $connection);
$query_q_padamgame = sprintf("SELECT * FROM daftar_acara WHERE idpeserta = '%s'", $colname_q_padamgame);
$q_padamgame = mysql_query($query_q_padamgame, $connection) or die(mysql_error());
$row_q_padamgame = mysql_fetch_assoc($q_padamgame);
$totalRows_q_padamgame = mysql_num_rows($q_padamgame);

$colname_q_padamgame2 = "-1";
if (isset($_GET['idpeserta'])) {
  $colname_q_padamgame2 = (get_magic_quotes_gpc()) ? $_GET['idpeserta'] : addslashes($_GET['idpeserta']);
}
mysql_select_db($database_connection, $connection);
$query_q_padamgame2 = sprintf("SELECT * FROM peserta WHERE idpeserta = %s", $colname_q_padamgame2);
$q_padamgame2 = mysql_query($query_q_padamgame2, $connection) or die(mysql_error());
$row_q_padamgame2 = mysql_fetch_assoc($q_padamgame2);
$totalRows_q_padamgame2 = mysql_num_rows($q_padamgame2);

$colname_q_padamgame3 = "-1";
if (isset($_GET['kodacara'])) {
  $colname_q_padamgame3 = (get_magic_quotes_gpc()) ? $_GET['kodacara'] : addslashes($_GET['kodacara']);
}
mysql_select_db($database_connection, $connection);
$query_q_padamgame3 = sprintf("SELECT * FROM acara WHERE kodacara = %s", $colname_q_padamgame3);
$q_padamgame3 = mysql_query($query_q_padamgame3, $connection) or die(mysql_error());
$row_q_padamgame3 = mysql_fetch_assoc($q_padamgame3);
$totalRows_q_padamgame3 = mysql_num_rows($q_padamgame3);
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>

<body>
<p>REKOD INI AKAN DIHAPUSKAN DARI PANGKALAN DATA</p>
<table width="447" border="1">
  <tr>
    <td width="143">NAMA</td>
    <td width="288"><?php echo $row_q_padamgame2['nama']; ?></td>
  </tr>
  <tr>
    <td>NO KP </td>
    <td><?php echo $row_q_padamgame2['nokp']; ?></td>
  </tr>
  <tr>
    <td>Kelas</td>
    <td><?php echo $row_q_padamgame2['kelas']; ?></td>
  </tr>
  <tr>
    <td>Jantina</td>
    <td><?php echo $row_q_padamgame2['jantina']; ?></td>
  </tr>
  <tr>
    <td>Acara</td>
    <td><?php echo $row_q_padamgame3['namaacara']; ?></td>
  </tr>
</table>
<p><a href="papargame.php">Kembali</a></p>
</body>
</html>
<?php
mysql_free_result($q_padamgame);

mysql_free_result($q_padamgame2);

mysql_free_result($q_padamgame3);
?>