field name and value

nikko50

I'm trying to populate the "newArray" with the field name as the key and the field value as the value. How can I do that??

//COMPARE THESE FIELDS
  $fieldName = array (  "Ticket_Number",
                        "Ticket_Status", 
                        "Assigned_To"

                  );
              $r = $db-> select($sql);  


                while($row = mysql_fetch_field($r)) {

                          if(in_array($row->name,$fieldName)){

                          $newArray[$row->name] = [B]$row->value [/B]; 

                            }

jkurrle

It is an oddity, but you can use double dollar signs to probably do what you want to do. For example, here is some sample code that uses this in a different scenario:

$POST_Array=array("name","address","phone");
foreach($POST_Array as $POST_Item)
  {
  $$POST_Item=$_POST[$POST_Item];
  }

Hope this gives you some ideas...

laserlight

Actually, you should write the SQL query to select exactly those columns that you want, upon which you can write:

$result = $db->select($sql);
$newArray = mysql_fetch_assoc($result);

Or if you actually want to handle multiple rows:

$result = $db->select($sql);
$newArray = array();
while ($row = mysql_fetch_assoc($result)) {
    $newArray[] = $row;
}

jkurrle

Laser, I don't quite follow that. I think he wants to pull the column name out as the array key and the field's data as the key's data. Where are you getting the column names?

I suppose you could use "describe tablename_XXX" as a query to get the field names, but I assume there's a more elegant way to do that...

Weedpacket

jkurrle wrote:
Where are you getting the column names?

From the keys of the returned associative array. Oh, wait, they're already there: mysql_fetch_assoc() returns an array of values keyed by field name - it should be easy to construct an array of values keyed by field name from that 🙂

(And if the original poster cannot rewrite the $sql statement so that it returns only the fields wanted (those listed in $fieldName), then

$newArray = array_diff_key($newArray, array_diff_key($newArray, array_flip($fieldName)));

is an inelegant workaround.)

jkurrle

Got it. I've only used mysql_fetch_array() to get my data; I'm too lazy to learn them all :-)

Weedpacket

mysql_fetch_array() gives you associative keys as well.....

jkurrle

Ok, I'll have to look at at that again. When I use it, I have always used it this way:

$row=mysql_fetch_array($result,MYSQL_ASSOC);

Which assigns the field names as variable names. But how would I use mysql_fetch_array to pull the field names as array keys? "Curiouser and curiouser", said Alice...

Weedpacket

jkurrle wrote:
Which assigns the field names as variable names. But how would I use mysql_fetch_array to pull the field names as array keys?

I think you need to think this sentence through again. I for one am now officially at a total loss. I mean

But how would I use mysql_fetch_array to pull the field names as array keys?

You'd use

$row=mysql_fetch_array($result,MYSQL_ASSOC);

Assuming you didn't want numeric keys as well.

jkurrle

Ok, I didn't exactly say that correctly. Sorry about the confusion. This is what I meant:

In the original post, Nikko50 wanted to get the actual name of the key and the value of the key, then he wanted to insert them into his array statement as keyname->keyvalue. When I use mysql_fetch_array($result, MYSQL_ASSOC), I get they keynames set to variables, but not the keynames themselves. In other words, I get "$fred", but not "fred". What I was trying to figure out is how do I get "fred". Does this make better sense?

Weedpacket

jkurrle wrote:
When I use mysql_fetch_array($result, MYSQL_ASSOC), I get they keynames set to variables, but not the keynames themselves. In other words, I get "$fred", but not "fred".

You do? Your implementation of mysql_fetch_array() must be different from mine, then. MY version of mysql_fetch_array() returns an array (although I hasten to add that I never use any of the mysql_*() functions anyway).

laserlight

In the original post, Nikko50 wanted to get the actual name of the key and the value of the key, then he wanted to insert them into his array statement as keyname->keyvalue. When I use mysql_fetch_array($result, MYSQL_ASSOC), I get they keynames set to variables, but not the keynames themselves. In other words, I get "$fred", but not "fred". What I was trying to figure out is how do I get "fred". Does this make better sense?

nikko50 was "trying to populate the "newArray" with the field name as the key and the field value as the value".

Suppose we have a database table named User with the fields name, phone, and address. If we want to populate an array with the field names name and phone and get the field value as the value using the MySQL API, we would write:

$result = mysql_query("SELECT name, phone FROM User");
$user = mysql_fetch_assoc($result);

Now $users has the data we wanted, e.g., equivalent to:

$user = array('name' => 'John', 'phone' => '12345');

If we wanted to extend this to an array of multiple rows from the result set, we would then write:

$result = mysql_query("SELECT name, phone FROM User");
$users = array();
while ($row = mysql_fetch_assoc($result)) {
    $users[] = $row;
}

Then $users would be equivalent to say:

$users = array(
    array('name' => 'John', 'phone' => '12345'),
    array('name' => 'Jane', 'phone' => '67890')
);

Note that mysql_fetch_assoc($result) is equivalent to mysql_fetch_array($result, MYSQL_ASSOC).

jkurrle

Thanks, Laser. That makes more sense. I've played with mysql_assoc() trying to extract the keys themselves, which doesn't appear possible. But, your example shows how the keys can be transferred directly to the array, which is what Nikko50 wanted.

I would normally assume that the person programming ought to know what the keys are to begin with, but I got hung around the idea of extracting the keys themselves, instead of the key->data relationship.

Weedpacket

jkurrle wrote:
I've played with mysql_assoc() trying to extract the keys themselves, which doesn't appear possible.

[man]array_keys[/man]