Count number of variables in object? - PHP

Question

Is there a way to count the number of variables in an object?

I have a object that is created dynamically, and I want to add each of the properties to a query to update these properties into the database. The variable $oProperties is an object:

public function update_model ($id, $oProperties)
{
    $SQL = "UPDATE `table` SET ";
    $count = 0;
    foreach($oProperties as $property=>$value)
    {   
        $count++;
        $SQL .= strtolower($property)." = '".$value."'";
        if($count !== $oProperties::count()) {$SQL .= ", ";}
    }
    $SQL .= " WHERE id='".$id."';";
}

I need to know the amount of properties in the object to know when to stop adding the comma to the query.

To remove the last comma you can just perform: $SQL = substr($SQL,-1) — dev0
– dev0, Commented Nov 11, 2015 at 12:56

Anton Ohorodnyk · Accepted Answer · 2015-11-12 08:39:09Z

1

You can use get_object_vars:

class foo {
    private $a;
    public $b = 1;
    public $c;
    private $d;
    static $e;
}

$test = new foo;
var_dump(get_object_vars($test));

Result:

array(2) {
  ["b"]=>
  int(1)
  ["c"]=>
  NULL
}

or if your object has type ArrayObject, you can use count method:

$arrayobj = new ArrayObject(array('first','second','third'));
var_dump($arrayobj->count());

But I think will be better use something like that:

public function update_model ($id, $oProperties)
{
    $SQL = "UPDATE `table` SET ";
    $properties = [];
    foreach($oProperties as $property=>$value)
    {
        $properties[] = strtolower($property)." = '".$value."'";
    }
    $SQL .= implode(', ', $properties);
    $SQL .= " WHERE id='{$id}';";
    return $SQL;
}

edited Nov 12, 2015 at 8:39

answered Nov 11, 2015 at 12:57

Anton Ohorodnyk

8836 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

PIDZB Over a year ago

Thnx, I used count(object_get_vars($oProperties)) to get the amount of variables. Works like a charm :)

Tahmina Khatoon · Accepted Answer · 2015-11-11 13:02:22Z

1

$arrayObj = (array)($oProperties);    
print_r(count($arrayObj));

answered Nov 11, 2015 at 13:02

Tahmina Khatoon

1,0913 gold badges11 silver badges30 bronze badges

Collectives™ on Stack Overflow

Count number of variables in object? - PHP

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related