CODEWITHSUNDEEP
phpoop
user492642
user492642

Reputation: 169

use instance of object inside a function

I am trying to find the best way to use an instance of my connection inside a function, but I don't know if I should pass it in as a parameter of my function or use a global.

This is my code:

<?php

require_once('class/connexion.php');

$cx = Connexion::getConnexion();


function get_customers(){
    $query = "SELECT * FROM customers";
    $select = $cx->prepare($query);
    $select->execute();
    $result = $select->fetchAll(PDO::FETCH_ASSOC);

    return $result
}


get_customers();

?>

Upvotes: 1

Views: 48

Answers (1)

user2693928
user2693928

Reputation:

Pass it as argument:

<?php
require_once('class/connexion.php');

$cx = Connexion::getConnexion();


function get_customers($cx){
    $query = "SELECT * FROM customers";
    $select = $cx->prepare($query);
    $select->execute();
    $result = $select->fetchAll(PDO::FETCH_ASSOC);

    return $result
 }


get_customers($cx);

?>

Upvotes: 3

Related Questions