donations.php

<?php
include ('server.php');

class donations {

    //call with only first 6 parameters, isNew is defaulted to true
    public function sqlInsert($donor, $contact, $email, $phone, $description, $foodType, $distcenter, $isNew = 1){
	   
	  global $servername;
	  global $username;
	  global $password;
	  global $dbname;
	  
      $connection = new mysqli($servername, $username, $password, $dbname);      
		if($connection === null){
			echo "Error connecting to database";
		}

		$theInsert = $connection->prepare("INSERT INTO donations SET DONOR=?, CONTACT=?, EMAIL=?, PHONE=?, DESCRIPTION=?, FOODTYPE=?, DISTID=?, ISNEW=?");		
		$theInsert->bind_param("sssssisi", $donor, $contact, $email, $phone, $description, $foodType, $distcenter, $isNew);
		$theInsert->execute();
      server::emailClients();  
    }

   //function runs through all the contents of the database and converts their ISNEW value to 0
   public function makeOld(){

	  global $servername;
	  global $username;
	  global $password;
	  global $dbname;
	  
      $connection = new mysqli($servername, $username, $password, $dbname);      
		if($connection === null){
			echo "Error connecting to database";
		}

		$theUpdate = "UPDATE donations SET ISNEW=0 WHERE 1 > 0";
		$connection->query($theUpdate);
   }

   //return all entries in the table matching the ISNEW value specified in the input parameter (0 or 1)
   public function rowInfo($newOrOld){
 	  global $servername;
	  global $username;
	  global $password;
	  global $dbname;
	  
      $connection = new mysqli($servername, $username, $password, $dbname);      
		if($connection === null){
			echo "Error connecting to database";
		}

		$theUpdate = "SELECT * FROM donations WHERE ISNEW=$newOrOld";
		
      $allRows = array();

      if($row = $connection->query($theUpdate)){
	      while($distinctRow = $row->fetch_array(MYSQL_NUM)){
         $allRows[] = $distinctRow;  
	      }
	   }
		return $allRows;   	
   }

   //function to wipe the existing contents of the database 
   public function clearIt(){

	  global $servername;
	  global $username;
	  global $password;
	  global $dbname;
	  
      $connection = new mysqli($servername, $username, $password, $dbname);      
		if($connection === null){
			echo "Error connecting to database";
		}

		$theUpdate = "DELETE FROM donations WHERE 1";
		$connection->query($theUpdate);
   }
}
 
?>