// The variable $are_we_online should be true (or 1) if we are connected to the server.
//echo "Are we online: " . $are_we_online; // prints 0 or 1.
// Let us run a query.
$sql = $db->query("SELECT * FROM {admins}");
// The variable $sql will now hold the data returned from the database, we can now work with it.
// Does it have rows ?
/*$hasRows = $db->hasRows($sql);
echo "Does it have rows: " . $hasRows; // prints 0 or 1 (true or false).
// How many rows does it have.
$countRows = $db->countRows($sql);
echo "How many rows: " . $countRows; // returns the number of rows.*/
// We can get the data from the fetch_assoc function.
//$result = $db->fetchAssoc($sql);
// We can get the data from the fetch_array function.
$result = $db->fetchArray($sql);
//We can even print out the latest used query:
//echo $db->lastQuery();
$dbusername = $result['username'];
$dbpwd = $result['password'];
if ($entrduname == $dbusername && $entrdpwd == $dbpwd) {
$_SESSION["username"] = $dbusername;
$_SESSION["password"] = $dbpwd;
$url = 'sports.php';
echo '<META HTTP-EQUIV=REFRESH CONTENT="0; ' . $url . '">';
} else {
$url = 'index.php';
echo '<META HTTP-EQUIV=REFRESH CONTENT="0; ' . $url . '">';
}
// As a last thing, close the connection.
$db->closeConnection();
public function getSpecificSport($id)
{
$sid = $id;
$table = "locations";
$config = new config("localhost", "root", "", "play_a_sport_db", "", "mysqli");
$db = new db($config);
$db->openConnection();
$sql = $db->query("SELECT id,location_name,latitude,longtitude FROM {locations} WHERE `id`=" . $sid);
$result = $db->fetchArray($sql);
$db->closeConnection();
$_SESSION['id'] = $result["id"];
$_SESSION['lname'] = $result["location_name"];
$_SESSION['ltd'] = $result["latitude"];
$_SESSION['lngtd'] = $result["longtitude"];
$url = 'sport_edit.php';
echo '<META HTTP-EQUIV=REFRESH CONTENT="0; ' . $url . '">';
}
