PHP dataBase::getInstance Examples

Programming Language: PHP

Class/Type: dataBase

Method/Function: getInstance

Examples at hotexamples.com: 3

The "getInstance" method is a design pattern used in the development of PHP applications that involves creating and returning an instance of a class. It is commonly used in applications to manage database connections and improve performance by using a singleton design pattern.

A popular package library that includes "getInstance" is the PDO (PHP Data Objects) library. PDO is a database abstraction layer that allows developers to use a universal set of functions to interact with various types of databases, including MySQL, PostgreSQL, and SQLite.

Here is an example code snippet using PDO's "getInstance" method to connect to a MySQL database:

class Database {
  private static $instance = null;
  private $conn;

  private function __construct() {
    $host = 'localhost';
    $user = 'root';
    $pass = 'password';
    $db = 'my_db';

    try {
        $this->conn = new PDO("mysql:host=$host;dbname=$db;charset=utf8", $user, $pass);
    }
    catch (PDOException $e) {
        // handle connection error
    }
  }

  public static function getInstance() {
    if(!self::$instance) {
      self::$instance = new Database();
    }
    return self::$instance;
  }

  public function getConnection() {
    return $this->conn;
  }
}

// usage example
$db = Database::getInstance();
$conn = $db->getConnection();

In this example, the "getInstance" method is used to create a singleton instance of the "Database" class, which contains a private PDO connection. The "getConnection" method is then used to retrieve the connection and execute SQL queries. Overall, the "getInstance" method is a useful pattern for managing database connections in PHP applications, and is commonly found in database abstraction libraries like PDO.

PHP dataBase::getInstance - 3 examples found. These are the top rated real world PHP examples of dataBase::getInstance extracted from open source projects. You can rate examples to help us improve the quality of examples.

Frequently Used Methods

Show Hide

multiVariableQuery(26)

rowCount(23)

dbResultFetch(20)

dbResultFetchAll(14)

paramQuery(10)

simpleQuery(7)

QueryFetchArrayASSOC(6)

multiVariableQueryValue(5)

getInstance(3)

switchDebug(3)

selectFrom(3)

getRow(3)

reset(2)

closeCursor(2)

beginTransaction(2)

commit(2)

dbResultFetchOneRowOnly(2)

delete(1)

simpleQueryValue(1)

connectDb(1)

selectDb(1)

database_connect(1)

print_table(1)

query(1)

getInfo(1)

dbUpdate(1)

debugOC(1)

instance(1)

insert(1)

debugOut(1)

update(1)

Example #1

Show file

File: base_daoBAK.php Project: RJBG/lmbv2.0

 function delete_store_item($id)
 {
     try {
         $sql = "DELETE FROM item WHERE itemID=?";
         $stmt = dataBase::getInstance()->prepare($sql);
         $stmt->execute(array($id));
         return "success";
     } catch (PDOException $e) {
         return $e->getMessage();
     }
 }

Example #2

Show file

File: base_dao.php Project: RJBG/lmbv2.0

 function push_po_items($voucherID, $qty, $price, $eprice, $itemID)
 {
     try {
         $sql = "INSERT INTO voucher_item (voucherID, qty, price, eprice, itemID) VALUES(?,?,?,?,?)";
         $stmt = dataBase::getInstance()->prepare($sql);
         $stmt->execute(array($voucherID, $qty, $price, $eprice, $itemID));
         return "success";
     } catch (PDOException $e) {
         return $e->getMessage();
     }
 }

Example #3

Show file

File: base_daoBAK2.php Project: RJBG/lmbv2.0

 function push_item($itemName, $itemType, $deptID, $vendorID, $itemDes, $attribute, $size, $itemNo, $receiptNo, $UPC, $orderCost, $alternateLookup, $reorderPointByStore, $companyReorderPoint, $usualSellUnit, $usualOrderUnit, $baseUnit, $itemUnit2, $itemUnit3, $itemUnit4, $onHandQuantity, $storeReorderPoint, $regularPrice, $orderCost)
 {
     try {
         $store_sql = "SELECT * FROM store";
         $item_sql = "INSERT INTO item \n\t\t\t\t\t(storeID, itemType, deptID, vendorID, itemName, itemDes, attribute, size, itemNo, receiptNo, UPC, \n\t\t\t\t\t\torderCost, alternateLookup, reorderPointByStore, companyReorderPoint, usualSellUnit, usualOrderUnit, \n\t\t\t\t\t\tbaseUnit, itemUnit2, itemUnit3, itemUnit4) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
         $store_item_sql = "INSERT INTO store_item (itemID, storeID, onHandQuantity, storeReorderPoint, regularPrice, \n\t\t\t\t\torderCost) VALUES (?,?,?,?,?,?)";
         $store = dataBase::getInstance()->prepare($store_sql);
         $store->execute();
         foreach ($store as $key => $value) {
             $item = dataBase::getInstance()->prepare($item_sql);
             $item->execute(array($value["storeID"], $itemType, $deptID, $vendorID, $itemName, $itemDes, $attribute, $size, $itemNo, $receiptNo, $UPC, $orderCost, $alternateLookup, $reorderPointByStore, $companyReorderPoint, $usualSellUnit, $usualOrderUnit, $baseUnit, $itemUnit2, $itemUnit3, $itemUnit4));
             $last_id = dataBase::getInstance()->prepare("SELECT * FROM item WHERE itemID =(SELECT max(itemID) FROM item)");
             $last_id->execute();
             $id_result = "";
             foreach ($last_id as $key => $id_data) {
                 $id_result = $id_data["itemID"];
             }
             $store_item = dataBase::getInstance()->prepare($store_item_sql);
             $store_item->execute(array($id_result, $value["storeID"], $onHandQuantity, $storeReorderPoint, $regularPrice, $orderCost));
         }
         return "success";
     } catch (PDOException $e) {
         return $e->getMessage();
     }
 }