function GetbillsByLast_Name($Last_Name)
{
require 'credentials1.php';
//open connection and select database
$link = mysqli_connect($host, $user, $passwd, $database) or die("Error" . myqsli_error($link));
$query = "SELECT * FROM bills WHERE Last_Name LIKE '{$Last_Name}'" or die("Error in the consult.." . myqsli_error($link));
//execute the query
$result = mysqli_query($link, $query);
$billsArray = array();
//display indormation
while ($row = mysqli_fetch_array($result)) {
//fetch
$First_Name = $row[1];
$Last_Name = $row[2];
$Description = $row[3];
$Charge = $row[4];
$Payment = $row[5];
$Balance = $row[6];
//create bill object and store in an array
$bills = new billentity(-1, $First_Name, $Last_Name, $Description, $Charge, $Payment, $Balance);
array_push($billsArray, $bills);
}
//close connection and return result
mysqli_close($link);
return $billsArray;
}
function GetsemesterBysemester($semester)
{
require 'Credentials.php';
//open connection and select database
$link = mysqli_connect($host, $user, $passwd, $database) or die("Error" . myqsli_error($link));
$query = "SELECT * FROM semesters WHERE semester LIKE '{$semester}'" or die("Error in the consult.." . myqsli_error($link));
//execute the query
$result = mysqli_query($link, $query);
$semesterArray = array();
//display indormation
while ($row = mysqli_fetch_array($result)) {
//fetch
$First_Name = $row[1];
$Last_Name = $row[2];
$Semester = $row[3];
$Class = $row[4];
$Grade = $row[5];
$GPA = $row[6];
//create semester object and store in an array
$semester = new gradeentity(-1, $First_Name, $Last_Name, $Semester, $Class, $Grade, $GPA);
array_push($semesterArray, $semester);
}
//close connection and return result
mysqli_close($link);
return $semesterArray;
}
$sql .= " where Cost >= {$s_cost_more}";
$c = 1;
}
}
if ($s_cost_less != "") {
if ($c) {
$sql .= " and Cost <= {$s_cost_less}";
} else {
$sql .= " where Cost <= {$s_cost_less}";
$c = 1;
}
}
$sql .= ";";
$result = mysqli_query($con, $sql);
if (!$result) {
die(myqsli_error($con));
}
// Administration parts; these are written before the actual list because
// of the way divs are laid out.
// Values are only sent to skins_query in the case of edit mode, where a form
// must be used.
if ($mode == "deletes") {
$sid = isset($_GET['sid']) ? $_GET['sid'] : "";
$sqldeletes = "delete from skins where Skin_ID='{$sid}';";
$results = mysqli_query($con, $sqldeletes);
if (mysqli_error($con)) {
header("Location: ?mode=ds&msg=Skin couldn't be deleted.");
} else {
header("Location: ?mode=ds&msg=Skin succesfully deleted.");
}
}
