File: /var/www/vhosts/uat-api.tsprojects.net/httpdocs/ratemycoach-web/AddCoachTest.php
<?php
session_start();
$MyId = $_GET["idUsers"];
?><?php
$mysql_server = 'localhost';
$mysql_username = 'pxhlcbmy_ccast99942cr';
$mysql_password = 'rYCh2@23';
$mysql_database = 'pxhlcbmy_coachrychdb';
$mysql_table = 'tblcoachesXL';
$mysql_fields = array();
$db = mysqli_connect($mysql_server, $mysql_username, $mysql_password);
if (!$db)
{
die('Failed to connect to database server!<br>'.mysqli_error($db));
}
mysqli_select_db($db, $mysql_database) or die('Failed to select database<br>'.mysqli_error($db));
$index = isset($_REQUEST['index']) ? mysqli_real_escape_string($db, $_REQUEST['index']) : 0;
$action = isset($_REQUEST['action']) ? mysqli_real_escape_string($db, $_REQUEST['action']) : '';
if ($_SERVER['REQUEST_METHOD'] == 'POST')
{
if ($action == 'delete')
{
if (isset($_REQUEST['id']))
{
$id = mysqli_real_escape_string($db, $_REQUEST['id']);
$sql = "DELETE FROM " . $mysql_table . " WHERE idUsers='$id'";
mysqli_query($db, $sql) or die(mysqli_error($db));
}
mysqli_close($db);
exit;
}
else
if ($action == 'save')
{
$id = isset($_REQUEST['id']) ? mysqli_real_escape_string($db, $_REQUEST['id']) : -1;
$emailusers = mysqli_real_escape_string($db, $_REQUEST['emailUsers']);
$gender = mysqli_real_escape_string($db, $_REQUEST['gender']);
$coachtitle = mysqli_real_escape_string($db, $_REQUEST['coachtitle']);
$sports = mysqli_real_escape_string($db, $_REQUEST['sports']);
$schoolname = mysqli_real_escape_string($db, $_REQUEST['schoolname']);
$schoolcity = mysqli_real_escape_string($db, $_REQUEST['schoolcity']);
$schoolstate = mysqli_real_escape_string($db, $_REQUEST['schoolstate']);
$totalyearscoaching = mysqli_real_escape_string($db, $_REQUEST['totalyearscoaching']);
$schoolwonlossrecord = mysqli_real_escape_string($db, $_REQUEST['schoolwonlossrecord']);
$careerwonlossrecord = mysqli_real_escape_string($db, $_REQUEST['careerwonlossrecord']);
$championships = mysqli_real_escape_string($db, $_REQUEST['championships']);
$awards = mysqli_real_escape_string($db, $_REQUEST['awards']);
$yearscoachinghere = mysqli_real_escape_string($db, $_REQUEST['yearscoachinghere']);
$f_name = mysqli_real_escape_string($db, $_REQUEST['f_name']);
$l_name = mysqli_real_escape_string($db, $_REQUEST['l_name']);
$userimg = mysqli_real_escape_string($db, $_REQUEST['userImg']);
if ($id >= 0)
{
$sql = "UPDATE " . $mysql_table . " SET `emailUsers` = '$emailusers', `gender` = '$gender', `coachtitle` = '$coachtitle', `sports` = '$sports', `schoolname` = '$schoolname', `schoolcity` = '$schoolcity', `schoolstate` = '$schoolstate', `totalyearscoaching` = '$totalyearscoaching', `schoolwonlossrecord` = '$schoolwonlossrecord', `careerwonlossrecord` = '$careerwonlossrecord', `championships` = '$championships', `awards` = '$awards', `yearscoachinghere` = '$yearscoachinghere', `f_name` = '$f_name', `l_name` = '$l_name', `userImg` = '$userimg' WHERE `idUsers` = '$id'";
mysqli_query($db, $sql) or die(mysql_error($db));
}
else
{
$sql = "INSERT " . $mysql_table . " (`emailUsers`, `gender`, `coachtitle`, `sports`, `schoolname`, `schoolcity`, `schoolstate`, `totalyearscoaching`, `schoolwonlossrecord`, `careerwonlossrecord`, `championships`, `awards`, `yearscoachinghere`, `f_name`, `l_name`, `userImg`) VALUES ('$emailusers', '$gender', '$coachtitle', '$sports', '$schoolname', '$schoolcity', '$schoolstate', '$totalyearscoaching', '$schoolwonlossrecord', '$careerwonlossrecord', '$championships', '$awards', '$yearscoachinghere', '$f_name', '$l_name', '$userimg')";
mysqli_query($db, $sql) or die(mysqli_error($db));
}
echo 'Record saved';
mysqli_close($db);
exit;
}
}
$total = 0;
$sql = "SELECT COUNT(*) FROM " . $mysql_table;
$result = mysqli_query($db, $sql);
if ($result)
{
$row = mysqli_fetch_array($result);
$total = $row[0];
}
if ($action == 'prev')
{
$index--;
if ($index < 0)
$index = 0;
}
else
if ($action == 'next')
{
$index++;
if ($index >= $total)
$index = $total-1;
}
else
if ($action == 'first')
{
$index = 0;
}
else
if ($action == 'last')
{
$index = $total-1;
}
else
if ($action == 'new')
{
$index = -1;
}
if ($index >= 0 && $index < $total)
{
$sql = "SELECT * FROM " . $mysql_table . " LIMIT " . $index . ",1";
$result = mysqli_query($db, $sql);
if ($result)
{
$mysql_fields = mysqli_fetch_array($result);
}
}
else
{
$mysql_fields['idUsers'] = -1;
}
mysqli_close($db);
?>
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Coach RYCH - Rate Your Coach</title>
<meta name="generator" content="WYSIWYG Web Builder 18 - http://www.wysiwygwebbuilder.com">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="css/font-awesome.min.css" rel="stylesheet">
<link href="css/coachRychVer2.0.css" rel="stylesheet">
<link href="css/AddCoachTest.css" rel="stylesheet">
<script src="js/jquery-1.12.4.min.js"></script>
<script src="js/jquery-ui.min.js"></script>
<script>
function mySqlSetValue(id, value)
{
var $obj = $('#'+id);
if ($obj.attr('type') == 'checkbox')
{
$obj.prop('checked', (value == '1'));
}
else
if ($obj.attr('type') == 'radio')
{
var name = $obj.attr('name');
var selector = "input[name='" + name + "'][value='" + value + "']";
$(selector).prop('checked', true);
}
else
{
$obj.val(value);
}
}
function mySqlGetValue(id)
{
var $obj = $('#'+id);
if ($obj.attr('type') == 'checkbox')
{
return ($obj.prop('checked') ? 1 : 0);
}
else
if ($obj.attr('type') == 'radio')
{
var name = $obj.attr('name');
var selector = "input[name='" + name + "']:checked";
return $(selector).val();
}
return $obj.val();
}
function mySqlSave()
{
$.post('<?php echo basename(__FILE__); ?>', { action: 'save', id: <?php echo $mysql_fields['idUsers']; ?>, emailUsers: mySqlGetValue('ebEmail'), gender: mySqlGetValue('ebGender'), coachtitle: mySqlGetValue('ebCoachTitle'), sports: mySqlGetValue('ebSports'), schoolname: mySqlGetValue('ebSchoolName'), schoolcity: mySqlGetValue('ebCity'), schoolstate: mySqlGetValue('ebState'), totalyearscoaching: mySqlGetValue('ebTYCoaching'), schoolwonlossrecord: mySqlGetValue('ebSchoolWLRecord'), careerwonlossrecord: mySqlGetValue('ebCareerWonLoss'), championships: mySqlGetValue('ebChamps'), awards: mySqlGetValue('ebAwards'), yearscoachinghere: mySqlGetValue('ebYearsATSchool'), f_name: mySqlGetValue('ebfname'), l_name: mySqlGetValue('eblname'), userImg: mySqlGetValue('ebImg') }, function(result)
{
alert(result);
});
}
function mySqlDelete()
{
if (confirm('Are you sure you want to delete this record?'))
{
$.post('<?php echo basename(__FILE__); ?>', { action: 'delete', id: <?php echo $mysql_fields['idUsers']; ?> }, function(result)
{
mySqlLast();
});
}
}
function mySqlAction(action)
{
var form = $('<form action="<?php echo basename(__FILE__); ?>" method="post">' +
'<input type="hidden" name="index" value="<?php echo $index; ?>" />' +
'<input type="hidden" name="action" value="' + action + '" />' +
'<\/form>');
$('body').append(form);
$(form).submit();
}
function mySqlPrevious()
{
mySqlAction('prev');
}
function mySqlNext()
{
mySqlAction('next');
}
function mySqlFirst()
{
mySqlAction('first');
}
function mySqlLast()
{
mySqlAction('last');
}
function mySqlNew()
{
mySqlAction('new');
}
function mySqlLoad()
{
mySqlSetValue("ebEmail", "<?php echo $mysql_fields['emailUsers'] ?>");
mySqlSetValue("ebGender", "<?php echo $mysql_fields['gender'] ?>");
mySqlSetValue("ebCoachTitle", "<?php echo $mysql_fields['coachtitle'] ?>");
mySqlSetValue("ebSports", "<?php echo $mysql_fields['sports'] ?>");
mySqlSetValue("ebSchoolName", "<?php echo $mysql_fields['schoolname'] ?>");
mySqlSetValue("ebCity", "<?php echo $mysql_fields['schoolcity'] ?>");
mySqlSetValue("ebState", "<?php echo $mysql_fields['schoolstate'] ?>");
mySqlSetValue("ebTYCoaching", "<?php echo $mysql_fields['totalyearscoaching'] ?>");
mySqlSetValue("ebSchoolWLRecord", "<?php echo $mysql_fields['schoolwonlossrecord'] ?>");
mySqlSetValue("ebCareerWonLoss", "<?php echo $mysql_fields['careerwonlossrecord'] ?>");
mySqlSetValue("ebChamps", "<?php echo $mysql_fields['championships'] ?>");
mySqlSetValue("ebAwards", "<?php echo $mysql_fields['awards'] ?>");
mySqlSetValue("ebYearsATSchool", "<?php echo $mysql_fields['yearscoachinghere'] ?>");
mySqlSetValue("ebfname", "<?php echo $mysql_fields['f_name'] ?>");
mySqlSetValue("eblname", "<?php echo $mysql_fields['l_name'] ?>");
mySqlSetValue("ebImg", "<?php echo $mysql_fields['userImg'] ?>");
}
</script>
<script src="js/wwb18.min.js"></script>
<script>
$(document).ready(function()
{
$("a[href*='#lgAbout']").click(function(event)
{
event.preventDefault();
$('html, body').stop().animate({ scrollTop: $('#wb_lgAbout').offset().top }, 600, 'easeOutSine');
});
mySqlLoad();
});
</script>
</head>
<body>
<div id="Layer1">
<div id="wb_IconFont1">
<a href="#headerLayoutGrid"><div id="IconFont1"><i class="fa fa-arrow-up"></i></div></a></div>
</div>
<div id="wb_lgAbout">
<div id="lgAbout">
<div class="row">
<div class="col-1">
<div class="col-1-padding">
</div>
</div>
<div class="col-2">
<div class="col-2-padding">
<div id="wb_Heading1">
<h2 id="Heading1">Add a Coach Test</h2>
</div>
<label for="" id="Label2">To add a coach, click the Add a Coach Button to clear the form. Enter the coach's information, then click the Save Button.</label>
<input type="submit" id="Button3" onclick="mySqlNew();ShowObjectWithEffect('wb_lgSGBack', 1, 'fade', 1);return false;" name="" value="Add a Coach">
</div>
</div>
<div class="col-3">
<div class="col-3-padding">
</div>
</div>
</div>
</div>
</div>
<div id="wb_LayoutGrid3">
<div id="LayoutGrid3">
<div class="row">
<div class="col-1">
<!-- myFunction -->
<div id="Html1">
<script>
function myFunction() {
fileInput = document.getElementById('myFile');
filename = fileInput.files[0].name;
document.getElementById('ebImg').value = filename;
}
</script></div>
</div>
<div class="col-2">
<div id="wb_LayoutGrid1">
<div id="LayoutGrid1">
<div class="row">
<div class="col-1">
<input type="text" id="error" name="error" value="<?php echo $error_message; ?>" spellcheck="false">
<div id="wb_LayoutGrid4">
<div id="LayoutGrid4">
<div class="row">
<div class="col-1">
<label for="" id="Label3">First Name</label>
</div>
<div class="col-2">
<input type="text" id="ebfname" name="ebfname" value="" spellcheck="false">
</div>
</div>
</div>
</div>
<div id="wb_LayoutGrid5">
<div id="LayoutGrid5">
<div class="row">
<div class="col-1">
<label for="" id="Label4">Last Name</label>
</div>
<div class="col-2">
<input type="text" id="eblname" name="eblname" value="" spellcheck="false">
</div>
</div>
</div>
</div>
<div id="wb_LayoutGrid10">
<div id="LayoutGrid10">
<div class="row">
<div class="col-1">
<label for="ebMail" id="Label6">E-mail</label>
</div>
<div class="col-2">
<input type="text" id="ebMail" name="ebMail" value="" spellcheck="false">
</div>
</div>
</div>
</div>
<div id="wb_LayoutGrid11">
<div id="LayoutGrid11">
<div class="row">
<div class="col-1">
<label for="" id="Label7">Gender</label>
</div>
<div class="col-2">
<select name="ComoBoxGender" size="1" id="ebGender">
<option value="Male">Male</option>
<option value="Female">Female</option>
</select>
</div>
</div>
</div>
</div>
<div id="wb_LayoutGrid12">
<div id="LayoutGrid12">
<div class="row">
<div class="col-1">
<label for="" id="Label8">Coach Title</label>
</div>
<div class="col-2">
<input type="text" id="ebCoachTitle" name="coachtitle" value="" spellcheck="false">
</div>
</div>
</div>
</div>
<div id="wb_LayoutGrid13">
<div id="LayoutGrid13">
<div class="row">
<div class="col-1">
<label for="" id="Label9">Sports</label>
</div>
<div class="col-2">
<select name="comboBoxSport" size="1" id="ebSports">
<option selected value="Please select a sports">Please select a sports</option>
<option value="Baseball">Baseball</option>
<option value="Basketball">Basketball</option>
<option value="Basketball Girls">Basketball Girls</option>
<option value="Football">Football</option>
<option value="Lacross">Lacross</option>
<option value="Lacross Girls">Lacross Girls</option>
<option value="Soccer">Soccer</option>
<option value="Soccer Girls">Soccer Girls</option>
<option value="Cheerleaders">Cheerleaders</option>
<option value="Softball">Softball</option>
<option value="Volleyball">Volleyball</option>
</select>
</div>
</div>
</div>
</div>
<div id="wb_LayoutGrid14">
<div id="LayoutGrid14">
<div class="row">
<div class="col-1">
<label for="" id="Label10">School Name</label>
</div>
<div class="col-2">
<input type="text" id="ebSchoolName" name="School Name" value="" spellcheck="false">
</div>
</div>
</div>
</div>
<div id="wb_LayoutGrid15">
<div id="LayoutGrid15">
<div class="row">
<div class="col-1">
<label for="" id="Label11">City</label>
</div>
<div class="col-2">
<input type="text" id="ebCity" name="City" value="" spellcheck="false">
</div>
</div>
</div>
</div>
<div id="wb_LayoutGrid16">
<div id="LayoutGrid16">
<div class="row">
<div class="col-1">
<label for="" id="Label12">State</label>
</div>
<div class="col-2">
<select name="state" size="1" id="ebState">
<option selected value="Select your state">Select your state</option>
<option value="AL">Alabama</option>
<option value="AK">Alaske</option>
<option value="AR">Arkansas</option>
<option value="AZ">Arizona</option>
<option value="CA">California</option>
<option value="CO">Colorado</option>
<option value="CT">Connecticut</option>
<option value="DE">Delaware</option>
<option value="DC">District of Columbia</option>
<option value="FL">Florida</option>
<option value="GA">Georgia</option>
<option value="HI">Hawaii</option>
<option value="ID">Idaho</option>
<option value="IL">Illinois</option>
<option value="IN">Indiana</option>
<option value="IA">Iowa</option>
<option value="KS">Kansas</option>
<option value="KY">Kentucky</option>
<option value="LA">Louisiana</option>
<option value="ME">Maine</option>
<option value="MD">Maryland</option>
<option value="MA">Massachusetts</option>
<option value="MI">Michigan</option>
<option value="MN">Minnesota</option>
<option value="MS">Mississippi</option>
<option value="MO">Missouri</option>
<option value="MT">Montana</option>
<option value="NE">Nebraska</option>
<option value="NV">Nevada</option>
<option value="NH">New Hampshire</option>
<option value="NJ">New Jersey</option>
<option value="NM">New Mexico</option>
<option value="NY">New York</option>
<option value="NC">North Carolina</option>
<option value="ND">North Dakota</option>
<option value="OH">Ohio</option>
<option value="OK">Oklahoma</option>
<option value="OR">Oregon</option>
<option value="PA">Pennsylvania</option>
<option value="RI">Rhode Island</option>
<option value="SC">South Carolina</option>
<option value="SD">South Dakota</option>
<option value="TN">Tennessee</option>
<option value="TX">Texas</option>
<option value="UT">Utah</option>
<option value="VT">Vermont</option>
<option value="VA">Virginia</option>
<option value="WA">Washington</option>
<option value="WV">West Virginia</option>
<option value="WI">Wisconsin</option>
<option value="WY">Wyoming</option>
</select>
</div>
</div>
</div>
</div>
<div id="wb_LayoutGrid17">
<div id="LayoutGrid17">
<div class="row">
<div class="col-1">
<label for="" id="Label14">Total Years Coaching</label>
</div>
<div class="col-2">
<input type="text" id="ebTYCoaching" name="totalyearscoaching" value="" spellcheck="false">
</div>
</div>
</div>
</div>
<div id="wb_LayoutGrid18">
<div id="LayoutGrid18">
<div class="row">
<div class="col-1">
<label for="" id="Label15">Years Coaching at this School</label>
</div>
<div class="col-2">
<input type="text" id="ebYearsATSchool" name="yearscoachingatthisschool" value="" spellcheck="false">
</div>
</div>
</div>
</div>
<div id="wb_LayoutGrid19">
<div id="LayoutGrid19">
<div class="row">
<div class="col-1">
<label for="" id="Label16">Won/Loss Record at this School</label>
</div>
<div class="col-2">
<input type="text" id="ebSchoolWLRecord" name="schoolwonlossrecord" value="" spellcheck="false">
</div>
</div>
</div>
</div>
<div id="wb_LayoutGrid20">
<div id="LayoutGrid20">
<div class="row">
<div class="col-1">
<label for="" id="Label17">Career Won/Loss Record</label>
</div>
<div class="col-2">
<input type="text" id="ebCareerWonLoss" name="careerwonlossrecord" value="" spellcheck="false">
</div>
</div>
</div>
</div>
<div id="wb_LayoutGrid21">
<div id="LayoutGrid21">
<div class="row">
<div class="col-1">
<label for="" id="Label18">Championships</label>
</div>
<div class="col-2">
<input type="text" id="ebChamps" name="champisonships" value="" spellcheck="false">
</div>
</div>
</div>
</div>
<div id="wb_LayoutGrid22">
<div id="LayoutGrid22">
<div class="row">
<div class="col-1">
<label for="" id="Label19">Awards</label>
</div>
<div class="col-2">
<input type="text" id="ebAwards" name="awards" value="" spellcheck="false">
</div>
</div>
</div>
</div>
<div id="wb_LayoutGrid7">
<div id="LayoutGrid7">
<div class="row">
<div class="col-1">
<label for="" id="Label1">Photo Name</label>
</div>
<div class="col-2">
<input type="text" id="ebImg" name="ebImg" value="" readonly spellcheck="false">
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div id="wb_LayoutGrid6">
<form name="LayoutGrid6" method="post" action="" enctype="multipart/form-data" id="LayoutGrid6">
<div class="row">
<div class="col-1">
<label for="" id="Label5">Upload a Profile Photo</label>
</div>
<div class="col-2">
<iframe name="InlineFrame1" id="InlineFrame1" src="https://coachrych.com/newFileUpload.php"></iframe>
</div>
</div>
</form>
</div>
<div id="wb_lgSGBack">
<div id="lgSGBack">
<div class="row">
<div class="col-1">
</div>
<div class="col-2">
<input type="submit" id="btnSave" onclick="mySqlSave();ShowObjectWithEffect('btnSave', 0, 'fade', 1);ShowObject('btnDeactivate', 1);return false;" name="btnSave" value="Save">
</div>
<div class="col-3">
</div>
</div>
</div>
</div>
</div>
<div class="col-3">
</div>
</div>
</div>
</div>
</body>
</html>