<?php $db; $username = "******"; $password = "******"; $hostname = "localhost"; $database = "joel_bee_database"; try { //Instantiate a database object $db = new PDO("mysql:host={$hostname}; dbname={$database}", $username, $password); echo '<p>Connected to database</p>'; } catch (PDOException $e) { echo $e->getMessage(); } include "Models/observationModel.php"; $obsModel = new ObservationModel($db); $obsList = $obsModel->getAllObservations(); include "Views/observation-list.php"; $db = null;
<?php /* *Author: Alex Ball *Date: 01/15/2016 * *This website is a prototype for the beehive project. This project involves *a website that allows beekeepers to submit data about the number of mites *in their beehives so that Danny Najera can review this data to support the *theory that mites are the biggest threat to bees. * */ //get database connection called $beeDBConnection require '/home/alexb/secure-includes/bee-db-connection.php'; //get access to the data model require 'models/observationmodel.php'; //create data model instance $dataModel = new ObservationModel($beeDBConnection); //get data rows $resultRows = $dataModel->getAllDataRows(); //show the view require 'views/admin-beedata-table.php'; //close connection $beeDBConnection = null;
<?php try { //Instantiate a database object $hostname = 'localhost'; $database_name = 'axum_bee_database'; $username = '******'; $password = '******'; $db = new PDO("mysql:host={$hostname};dbname={$database_name}", $username, $password); echo 'Connected to database'; } catch (PDOException $e) { echo $e->getMessage(); } include 'models/observationmodel.php'; $obsModel = new ObservationModel($db); //public function getAllObservations $observation_list = $obsModel->getAllObservation(); include 'views/observation-list.php'; $db = null;
<?php require '../../db.php'; include "models/bee_observationsmodel.php"; $obsModel = new ObservationModel($dbh); $obsList = $obsModel->getAllObservations($dbh); include 'views/bee_observations-list.php'; $obsList = $obsModel->getAllObservations($dbh); include 'beeData.php'; $db = null;
//close connection $beeDBConnection = null; } else { $getErrors = 'location: index.php?error=true'; foreach ($errorArray as $error) { $getErrors .= $error; } header($getErrors); } } else { header('location: index.php'); } //if the submission is successful, show success view. if (isset($success)) { //get database rows where the hive name matches this //hive name submission. //get database connection called $beeDBConnection require '/home/alexb/secure-includes/bee-db-connection.php'; //we already have access to the bee data model from submitting //the form data. //create data model instance $dataModel = new ObservationModel($beeDBConnection); //get data rows $resultRows = $dataModel->getRowsByHiveName($miteFormHiveName); //show the view require 'views/user-beedata-table.php'; //close connection $beeDBConnection = null; } else { print '<h3>Error submitting to database.</h3>'; }