procedural php/mysql to object oriented issue

Question

This is the original code I am trying to write in object oriented form..

$posResult = mysql_query("SELECT MAX(position)+1 FROM todo");

        if(mysql_num_rows($posResult))
            list($position) = mysql_fetch_array($posResult);

This is where I am at.... I think I need to bind_result? also, I have an issue with the mysql_fetch_array...

if($stmt = $this->HH->Database->prepare("SELECT MAX(position)+1 FROM todo")) {
        $stmt->execute();
        $stmt->store_result();

        if($stmt->num_rows != FALSE) {
            list($position) = mysql_fetch_array($posResult);
        }
    }

Can someone advise on how to correct this?

Is $this->HH->Database Mysqli or PDO?

drew010
– drew010

2012-08-08 01:05:45 +00:00
Commented Aug 8, 2012 at 1:05 — drew010
– drew010, Commented Aug 8, 2012 at 1:05
new mysqli($server, $user, $pass, $db);

Greg
– Greg

2012-08-08 01:07:18 +00:00
Commented Aug 8, 2012 at 1:07 — Greg
– Greg, Commented Aug 8, 2012 at 1:07

Fluffeh · Accepted Answer · 2012-08-08 01:08:59Z

1

It looks like you are moving over to PDO, which is great, it is a much better way to connect, but you are still trying to use some of the older mysql_* commands which won't work. While there are a number of ways to get the data, but this is the approach that I most commonly use:

if($stmt = $this->HH->Database->prepare("SELECT MAX(position)+1 FROM todo")) {
    $stmt->execute();

    $stmt->setFetchMode(PDO::FETCH_INTO, new yourClassName);
    foreach($stmt as $yourClassObject)
    {
        $someVar=$yourClassObject->QueryColumnName;
        // or
        $this->someProperty=$yourClassObject->QueryColumnName;
    }
    }

I do generally have a class that matches the results of the query, so I use FETCH_INTO but you can use a different method such as return an indexed array, associated array or others.

answered Aug 8, 2012 at 1:08

Fluffeh

33.6k16 gold badges69 silver badges80 bronze badges

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

2 Comments

Greg Over a year ago

I actually was not intending to move over to PDO... nor do I really know much about it at all. I realize the older mysql_ command does not work. Any other alternatives to the PDO approach?

Fluffeh Over a year ago

@Greg Actually I think that using PDO is easier than using the old functions. It might be different, but the flexibility is amazing - and if you just want to run simple queries directly it lets you do that as well.

Collectives™ on Stack Overflow

procedural php/mysql to object oriented issue

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related