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."); } }