Explore our sites

Stack Exchange
tour help careers 2.0
Take the tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 1 down vote favorite

I have the below code. It is only returning the first charater of a string.

    $conn = Mage::getSingleton('core/resource')->getConnection('connection_write');
$str = 'something to search for';
$fields = 'content_field1, content_field2, content_field3, content_field4';
$idFields = 'id_field1, id_field2, id_field3, id_field4';
$tables = 'table1, table2, table3, table4';
$table = explode(', ', $tables);
$field = explode(', ', $fields);
$rowId = explode(', ', $idFields);

$i=1;
while ($i<4) {
    $f = $field[$i];
    $id = $rowId[$i];
    $sql = $conn->select()->from($table[$i], array($f, $id))->where($f . " LIKE ?", '%' . $str . '%');
    $result = $conn->fetchRow($sql);

    foreach ($result as $row) {
    var_dump($row[$id]);
    }

    $i++;
}

However, if I use var_dump($row); the entire string from both the id fields and the content fields are outputted.

Can anyone explain to me what I am doing wrong?

Thanks in advance.

share|improve this question
 
A string is viewed as an array of characters, so $test = "abcs" also would act like $test = array('a','b','c','d') so it would be accessed as $test[2] would show c as its the 3rd index in the array of chars! –  RobertPitt Dec 29 '10 at 1:17
 
@RobertPitt: I would notice that analogue "string == array" is true only for accessing elements. In other cases strings and arrays behave differently. –  zerkms Dec 29 '10 at 1:22
 
Yes they do behave differently, The way I think of it is that Strings hae ArrayAccess implemented into them! –  RobertPitt Dec 29 '10 at 1:24
 
@RobertPitt: they don't implement ArrayAccess interface - unset operation is not defined for strings. The implementation is complete internal, it has nothing to do with outer interfaces. –  zerkms Dec 29 '10 at 1:27
 
I never said it did :/, I stated "The way I think of it", as i don't know fully the process of it. –  RobertPitt Dec 29 '10 at 1:31
show 1 more comment

3 Answers

up vote 0 down vote accepted

However, if I use var_dump($row); the entire string from both the id fields and the content fields are outputted.

well, why do you use var_dump($row[$id]); which exactly equals to "take $id'th char from $row string" then?

share|improve this answer
 
What I am trying to achieve is to isolate the id fields in the result. –  Jack Dec 29 '10 at 1:12
 
@Jack: var_dump($result); do you see key id there? If so - use $result['id'] instead of loop. –  zerkms Dec 29 '10 at 1:14
add comment
up vote 0 down vote 
foreach ($result as $row) {

$result is a list of rows you selected from the table. Each $row is a string. $row[$id] simply selects the $id'th character from this row string.

share|improve this answer
add comment
up vote 0 down vote

I believe the problem has to do with the fact that $result is an array (possibly an associative array) of strings. (I'm not familiar with Mage, but I'm assuming that fetchRow() returns only a single row and not all of your rows.)

Therefore, what's happening is you've probably got something like this:

$result = array("tom","dick","harry");

When you run foreach($result as $row), $row looks like "tom", "dick", and "harry" on each iteration.

Because $row is a string, calling $row[$id] makes PHP attempt to get get a single character from the $row string. Because it's expecting $id to be an integer in this case, it's probably interpreting "id_field1" as 0, which will end up returning the first character of your string.

I'm not exactly sure what you're trying to get back, but most likely this can be solved by changing your foreach section to be something like...

foreach ($result as $resultColumn) {
   var_dump($resultColumn);
}
share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.