fetchArray() not working in SQLite

Question

I'm working with SQLite on my webserver and have had no problems until now.

        $sql = "SELECT * from TeammateCurrent;";
        $ret = $db->query($sql);

        if($ret != false) {

            while($row = $ret->fetchArray(SQLITE3_ASSOC) ){
                $uniqueid = $row['uniqueID'];

                $name = $row['Name'];
                $lineID = $row['LineID'];
                $job = $row['Job'];
                $sunday = $row['Sunday'];
                $monday = $row['Monday'];
                $tuesday = $row['Tuesday'];
                $wednesday = $row['Wednesday'];
                $thursday = $row['Thursday'];
                $friday = $row['Friday'];
                $saturday = $row['Saturday'];
                //echo $name."<br>".$lineID."<br>".$job."<br>".$sunday."<br>".$monday."<br>".$tuesday."<br>".$wednesday."<br>".$thursday."<br>".$friday."<br>".$saturday."<br><br>";

                $sql = "INSERT INTO TeammateHistory (uniqueID, Name,LineID,Job,Sunday,Monday,Tuesday,Wednesday,Thursday,Friday,Saturday)
                    VALUES (NULL, '$name','$lineID','$job','$sunday','$monday','$tuesday','$wednesday','$thursday','$friday','$saturday');";

                $ret = $db->exec($sql);
                if(!$ret){
                    echo $db->lastErrorMsg();
                } else {

                }

                $sql2 = "UPDATE TeammateCurrent set Sunday='$day0', Monday='$day1', Tuesday='$day2', Wednesday='$day3', Thursday='$day4', Friday='$day5', Saturday='$day6' where uniqueID='$uniqueid';";

                $ret = $db->exec($sql2);
                if(!$ret){
                    echo $db->lastErrorMsg();
                } else {

                }
            }

        } else {
            echo "Query not successful";
        }

When the code above executes, I get the error Fatal error: Call to a member function fetchArray() on a non-object in /home/xxxx/public_html/xxxx.com/trg/rc2/db/startNewWeek.php on line 39

I've ran code just like this on other pages and they work fine, I'm at a total loss here.

My tables:

If you run the select in the sqlite command line does it work? — apokryfos
– apokryfos, Commented Jun 20, 2016 at 12:57
@Apokryfos I'm not sure how to do that, is it possible on a remote server? — GrumpyCrouton
– GrumpyCrouton, Commented Jun 20, 2016 at 12:58
@Saty that is part of the documentation @ tutorialspoint.com/sqlite/sqlite_php.htm I did try however, and did not work still. — GrumpyCrouton
– GrumpyCrouton, Commented Jun 20, 2016 at 12:59
If the remote server allows SSH connections and has the sqlite3 CLI (or similar) installed you can just remote in and do something like : sqlite3 dbname.db "query" — apokryfos
– apokryfos, Commented Jun 20, 2016 at 13:00
@apokryfos I don't think I have access to ssh in my current project — GrumpyCrouton
– GrumpyCrouton, Commented Jun 20, 2016 at 13:01

Fredster · Accepted Answer · 2016-06-20 13:16:35Z

3

you're reusing the variable $ret. You should have a different return variable for the SELECT statment and UPDATEs. In the second loop you're trying to do a fetchArray() of the return of an UPDATE statement.

edited Jun 20, 2016 at 13:16

answered Jun 20, 2016 at 12:56

Fredster

7761 gold badge6 silver badges17 bronze badges

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

4 Comments

GrumpyCrouton Over a year ago

Fatal error: Call to undefined method SQLite3Result::lastErrorMsg() in

Fredster Over a year ago

sorry I meant print_r($db->lastErrorMsg()); die();

GrumpyCrouton Over a year ago

If I uncomment out the echo'd string in my while statement, it appears it gets through a single iteration and then throws the error mentioned in my post.

Fredster Over a year ago

Ahh.. yes because you're reusing the variable $ret. You should have a different return variable for the SELECT statment and UPDATEs. In the second loop you're trying to do a fetchArray() of the return of an UPDATE statement.

Collectives™ on Stack Overflow

fetchArray() not working in SQLite

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related