//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 addSport($arr) { $lname = $arr["loc_name"]; $ltdd = $arr["lattd"]; $lngtdd = $arr["longtd"]; $config = new config("localhost", "root", "", "play_a_sport_db", "", "mysqli"); $db = new db($config); $db->openConnection(); $result = $db->addNewSportRecord($lname, $ltdd, $lngtdd); $db->closeConnection(); if ($result === TRUE) { $url = 'sports.php'; echo '<META HTTP-EQUIV=REFRESH CONTENT="0; ' . $url . '">'; } else { $_SESSION["inlocname"] = $lname; $_SESSION["inltdd"] = $ltdd; $_SESSION["inlngtdd"] = $lngtdd; $url = 'sport_new.php'; echo '<META HTTP-EQUIV=REFRESH CONTENT="0; ' . $url . '">'; } }