php FETCH_CLASS and autocomplete in Eclipse

Question

I am new to PHP and PDO. I'm working with Eclipse PDT.

$stmt = $pdo->prepare("SELECT * from articolo");
$stmt->execute();
$result = $stmt->fetchAll(PDO::FETCH_CLASS, "Articolo");

After that I want to be able to type:

$result[0]->

and from there pressing ctrl+space Eclipse should popup the autocomplete with all the members and functions of that class Articolo.

But nothing happens, as if the IDE doesn't know the Class of $result. Am I doing something wrong? Maybe a cast of $result to (Articolo) is needed?

doing:

$var = new Articolo()
$var->

the autocomplete popup appear correctly.

Nick · Accepted Answer · 2012-06-13 22:06:47Z

1

I'd bet that you just need to give Eclipse a type hint. I'm not an Eclipse user, but you typically use phpdoc and do something along the lines of:

...
$result = $stmt->fetchAll(PDO::FETCH_CLASS, "Articolo");
/** @var $record Articolo */
$record = $result[0];

answered Jun 13, 2012 at 22:06

Nick

6,9752 gold badges36 silver badges58 bronze badges

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

Comments

Community · Accepted Answer · 2017-05-23 11:49:11Z

0

Assuming your query was successful & returned more than 1 row, $result contains numerous objects. Each object will be of type Articolo.

To access the object's method(s) you will have to do the following:

$result = $stmt->fetchAll(PDO::FETCH_CLASS, "Articolo");



foreach($result as $object)
{
    // call a method on each object
    $object->someFunction();
}

Explanation of above code:

Fetch the data, so that $result should contain an array of Articolo objects.
Loop through each object & call a function name that exists in the Articolo Class.

The reason your IDE (Eclipse) did not recognise the functions in the Articolo Class was because you were trying to call a function from the $result variable, which was not of the type Articolo Class.

Some Stack overflow usage tips:

Always use the search in the top right hand corner. Numerous people have come across problems that may could help you.
Always have a look at the How to Ask Questions FAQ
Feedback & always ask further questions if required!

edited May 23, 2017 at 11:49

CommunityBot

11 silver badge

answered Jun 12, 2012 at 20:23

Haroon

1,1551 gold badge11 silver badges13 bronze badges

1 Comment

Simone Conti Over a year ago

thanks for the advice, but Eclipse keeps not popping out the automplete on the objects.

Simone Conti · Accepted Answer · 2012-06-12 22:53:57Z

0

I found a solution:

$articolo = new Articolo();
$stmt = $pdo->prepare("SELECT * from articolo");
$stmt->setFetchMode(PDO::FETCH_INTO, $articolo);
$stmt->execute();           

while ($stmt->fetch()) {
    $articoli[] = clone $articolo;
}           
return $articoli;

answered Jun 12, 2012 at 22:53

Simone Conti

5943 gold badges10 silver badges20 bronze badges

Collectives™ on Stack Overflow

php FETCH_CLASS and autocomplete in Eclipse

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related