<?php include_once "header_code.php"; setNavIndex(0); ?> <body> <?php include "nav.php"; ?> <div class="container"> <form action="add_new_user.php" method="POST" enctype="multipart/form-data" role="form"> <div> <input type="hidden" name="member_type" id="member_type" value="0" /> </div> <div class="row"> <div class="col-md-6"> <div class="form-group"> <label for="male_name">Member Name</label> <input type="text" class="form-control upper-case" name="male_name" id="male_name" placeholder="Eg:'John Doe'" /> </div> <div id="gender_details"> <div class="radio"> <label> <input type="radio" name="member_gender" id="member_gender_m" value="m" checked /> Male </label> </div> <div class="radio"> <label> <input type="radio" name="member_gender" id="member_gender_f" value="f" /> Female
<?php
include_once "header_code.php";
setNavIndex(2);
include_once "header_db.php";
$event_id = $_GET['id'];
$event = array();
$sql = "SELECT * FROM events WHERE id = " . $event_id;
if ($result = mysqli_query($connection, $sql)) {
while ($row = mysqli_fetch_array($result)) {
array_push($event, $row);
}
}
//print_r($event);
mysqli_close($connection);
?>
<body>
<?php
include "nav.php";
?>
<div class='container'>
<h3 style="margin-top: 30px; margin-bottom: 25px; color: brown;">Edit Event</h3>
<form action="edit_event.php" method="post" role="form">
<input type="hidden" name="id" value="<?php
echo $event_id;
?>
" />
<div class='row'>
<div class='col-md-6'>
<div class="form-group">
<?php
include_once "../header_code.php";
setNavIndex(3);
include "../nav.php";
$male_id = $_GET['id'];
$member = array();
$female = array();
$kids = array();
$blood_group = array("", "A+", "A-", "AB+", "AB-", "B+", "B-", "O+", "O-");
include "../header_db.php";
$sql = "SELECT * FROM s_male,s_common WHERE s_male.id = " . $male_id . " AND s_common.id = " . $male_id . ";";
if ($result = mysqli_query($connection, $sql)) {
while ($row = mysqli_fetch_array($result)) {
array_push($member, $row);
}
}
$sql = "SELECT * FROM s_female WHERE id = " . ($male_id + 1) . ";";
if ($result = mysqli_query($connection, $sql)) {
while ($row = mysqli_fetch_array($result)) {
array_push($female, $row);
}
}
//echo "<pre>";
//print_r($female);
//echo "</pre>";
$sql = "SELECT * FROM s_kids WHERE parent_id = " . $male_id . ";";
if ($result = mysqli_query($connection, $sql)) {
while ($row = mysqli_fetch_array($result)) {
array_push($kids, $row);
}
<?php
include "header_code.php";
setNavIndex(1);
include_once "header_db.php";
require_once "modules/Table.inc";
$members = array();
$sql = "SELECT id,Name FROM male ORDER BY Name;";
if ($result = mysqli_query($connection, $sql)) {
while ($row = mysqli_fetch_assoc($result)) {
array_push($members, $row);
}
}
$sql = "SELECT id,Name FROM female ORDER BY Name;";
if ($result = mysqli_query($connection, $sql)) {
while ($row = mysqli_fetch_assoc($result)) {
array_push($members, $row);
}
}
$selected_member = array();
$directors_arr = array();
if (isset($_GET['id'])) {
$dir_id = $_GET['id'];
$sql = "SELECT * from directors WHERE id = " . $dir_id . " LIMIT 1;";
if ($result = mysqli_query($connection, $sql)) {
while ($row = mysqli_fetch_assoc($result)) {
array_push($directors_arr, $row);
}
}
$sql = "SELECT id, Name FROM male WHERE id = (SELECT member_id from directors WHERE id = " . $dir_id . ")";
if ($result = mysqli_query($connection, $sql)) {
<?php
include "../header_code.php";
setNavIndex(6);
include "../nav.php";
//include("../project_config.php");
?>
<div class="container">
<?php
$str_alert = "";
if (isset($_GET['alert']) && isset($_GET['success']) && isset($_GET['fail'])) {
$str_alert = "<div class='alert alert-success alert-dismissible' role='alert'><button type='button' class='close' data-dismiss='alert' aria-label='Close'><span aria-hidden='true'>×</span></button>Your attachment was uploaded successfully and your mail count was " . $_GET['success'] . " </div>";
}
echo $str_alert;
?>
<div class='row'>
<div class='col-md-6'>
<h3 class="h3">Send mail</h3>
</div>
</div>
<div>
<form action="mail.php" method="post" enctype="multipart/form-data">
<div class="form-group">
<label for="sub">Subject</label>
<input type="text" class="form-control" id="sub" name="sub" />
</div>
<div class="form-group">
<label for="msg">Enter your Message</label><br />
<textarea rows="10" cols="100" id="msg" name="msg" class="form-control"></textarea>
</div>
<?php
$root = "../";
include_once $root . "header_code.php";
setNavIndex(4);
include_once $root . "header_db.php";
?>
<body>
<?php
include_once $root . "nav.php";
?>
<div class="container">
<a href="export.php" class="btn btn-primary pull-right">Export</a>
<h3>Participants List</h3>
<table class = "table">
<tr>
<th>Index</th>
<th>Team ID</th>
<th>Details</th>
<th>Club</th>
<th>Payment</th>
</tr>
<?php
$str = "";
$sql = "SELECT evt_team.id, evt_clubs.name as 'c_name', evt_team.payment_option FROM evt_team, evt_clubs\n\t\t\t\t\t\tWHERE evt_clubs.id = evt_team.club_id";
$counter = 1;
if ($result = mysqli_query($connection, $sql)) {
while ($row = mysqli_fetch_assoc($result)) {
$str .= "<tr><td>" . $counter++ . "</td>";
