Converting or place a PHP array to class variables

Question

How do I convert from my PHP array (mysql_fetch_array) to a declared PHP Class then encode that to json format string. My array:

    while ($rows = mysql_fetch_array($result, MYSQL_ASSOC)){
    $patient[] = array( 'id' => $rows['id'],
                        'name' => $rows['name'], 
                        'sex' => $rows['sex'], 
                        'civil_status' => $rows['civil_status'],
                        'age' => $rows['age'], 
                        'type_of_admission' => $rows['type_of_admission'],
                        'admission_diagnosis' => $rows['admission_diagnosis'],
                        'date_admitted' => $rows['date_admitted']);
          }

My declare PHP Class

  class Person
    {
     public $id;
     public $name;
     public $sex;
     public $civil_status;
     public $age;
     public $type_of_admission;
     public $admission_diagnosis;
     public $date_admitted;
  }

Why do you need to populate a class before calling json_encode()? Just json_encode the array. — Travesty3
– Travesty3, Commented Sep 20, 2013 at 2:18

Anthony · Accepted Answer · 2013-09-20 02:02:21Z

1

I think you are looking for mysql_fetch_object:

while ($row = mysql_fetch_object($result, 'Person')){

    $json_rows[] = json_encode($row);

}

Also, you should be using mysqli, which has the same basic concept.

answered Sep 20, 2013 at 2:02

Anthony

37.2k26 gold badges103 silver badges167 bronze badges

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

2 Comments

Alejandro Iván Over a year ago

I believe this will probably help either: stackoverflow.com/questions/9896254/php-class-instance-to-json

shade niniski Over a year ago

@AlejandroIván tnx I look to it now

Kyslik · Accepted Answer · 2013-09-20 01:41:02Z

0

just retype to (object)

$object = (object) $array_name;

for json_encode.

answered Sep 20, 2013 at 1:41

Kyslik

8,4355 gold badges58 silver badges90 bronze badges

1 Comment

shade niniski Over a year ago

i want to place that $patient array to Person class then json_encode, how do i do it?

Collectives™ on Stack Overflow

Converting or place a PHP array to class variables

2 Answers 2

2 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related