在PHP中创建JSON结构

Question

$query = "SELECT `contact_id`, `user_id`, `date_backup`, `first_name`, `last_name` FROM tbl_contacts WHERE date(`date_backup`) = (SELECT MAX(date(`date_backup`)) FROM tbl_contacts WHERE `user_id`= '$userId' ) ORDER BY `date_backup` DESC, `contact_id` ASC";
$result = mysql_query($query);
while($row = mysql_fetch_assoc($result)) {
    $contacts = array(array());
    $contactId = $row['contact_id'];
    $names["first_name"] = $row['first_name'];
    $names["last_name"] = $row['last_name'];
    $contacts["names"][] = $names;

    // Phone
    $phoneQuery = "SELECT * FROM tbl_phone_details WHERE contact_id = '$contactId' AND date(`date_backup`) = (SELECT MAX(date(`date_backup`)) FROM tbl_phone_details WHERE `contact_id`= '$contactId')";
    $phoneResult = mysql_query($phoneQuery);

    $total = mysql_affected_rows();
    if($total >= '1') {
        while($phoneRow = mysql_fetch_assoc($phoneResult)) {
            $phones["phone_number"] = $phoneRow['phone_number'];
            $phones["phone_type"] = $phoneRow['phone_type'];
            $contacts["phones"][] = $phones;
        }
    } else {
        $contacts["phones"][] = array();
    }


    // Email    
    $emailQuery = "SELECT * FROM `tbl_email_details` WHERE `contact_id` = '$contactId' AND date(`date_backup`) = (SELECT MAX(date(`date_backup`)) FROM tbl_email_details WHERE `contact_id`= '$contactId')";
    $emailResult = mysql_query($emailQuery);

    $total = mysql_affected_rows();
    if($total >= '1') {
        while($emailRow = mysql_fetch_assoc($emailResult)) {        
            $emails["email_address"] = $emailRow['email_address'];
            $emails["email_type"] = $emailRow['email_type'];
            $contacts["emails"][] = $emails;
        }
    } else {
        $contacts["emails"][] = array();
    }   

    // Address  
    $addressQuery = "SELECT * FROM `tbl_address_detail` WHERE `contact_id` = '$contactId' AND date(`date_backup`) = (SELECT MAX(date(`date_backup`)) FROM tbl_address_detail WHERE `contact_id`= '$contactId')";
    $addressResult = mysql_query($addressQuery);

    $total = mysql_affected_rows();
    if($total >= '1') {
        while($addressRow = mysql_fetch_assoc($addressResult)) {
            $address["street"] = $addressRow['street'];
            $address["city"] = $addressRow['city'];
            $address["state"] = $addressRow['state'];
            $address["zip"] = $addressRow['zip'];
            $address["country"] = $addressRow['country'];
            $address["addressType"] = $addressRow['addressType'];

            $contacts["address"][] = $address;
        }
    } else {
        $contacts["address"][] = array();
    }

    $contectInfoJson["contacts"][] = $contacts;
}

$allContactJson["AllContacts"] = $contectInfoJson;

header('Content-Type: application/json');
echo json_encode($allContactJson);

OUTPUT OF CODE :-

AllContacts: {
userId: "15",
contacts: [
{
0: [ ], // Not needed
names: [ // Instead of array i need simple object of names
{
first_name: "ABC",
last_name: "XYZ"
}
],
phones: [
{
phone_number: "[phone]",
phone_type: "Work"
},
{
phone_number: "[phone]",
phone_type: "Home"
}
],
emails: [
[ ] //This is also extra and not needed.
],
address: [
{
street: "India",
city: "",
state: "",
zip: "",
country: "",
addressType: ""
}
]
},

REQUIRED OUTPUT:-

AllContacts: {
userId: "15",
contacts: [
{
names:
{
first_name: "ABC",
last_name: "XYZ"
},
phones: [
{
phone_number: "[phone]",
phone_type: "Work"
},
{
phone_number: "[phone]",
phone_type: "Home"
}
],
emails: [],
address: [
{
street: "India",
city: "",
state: "",
zip: "",
country: "",
addressType: ""
}
]
},

I am facing 2-3 small problem in the code.

First is that i am getting 0 : [] on every start of the object.

2nd one is names is array and i want it to be object not array.

3rd is emails :[ [] ], i want blank array if data is not available, but i am getting array inside array. I just want emails :[].

Answer 1

1. Replace $contacts = array(array()); with $contacts = array();. Should remove 0 : [].
2. $contacts["emails"][] = array(); is triggered probably, so try to replace it with $contacts["emails"] = array();
3. Replace $contacts["names"][] = $names; with $contacts["names"] = $names;