PHP play_a_sport\classes db Examples

Example #1

File: admin_login.php Project: BuddhiEash/play_a_sport_oop

use play_a_sport\classes\login;
use play_a_sport\classes\config;
$user = new login();
$val1 = $_POST["email"];
$val2 = $_POST["password"];
$user->setLogins($val1, $val2);
$getvals = $user->getLogins();
$entrduname = $getvals['username'];
$entrdpwd = $getvals['password'];
//echo $getvals['username'];
//echo $getvals['password'];
// We need to have 1 config object with all data in.
$config = new config("localhost", "root", "", "play_a_sport_db", "", "mysqli");
//type in your data here…
// Now we need to have access to the db class, we uses the config object to configure the db object.
$db = new db($config);
// We can now open the connection to the database.
$db->openConnection();
// If your config details are right, we are now connected to a database, lets test the connection before we run queries.
$are_we_online = $db->pingServer();
// 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);

Example #2

File: locations.php Project: BuddhiEash/play_a_sport_oop

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