PDO array issue

PHP
1

I have the chunk of code below to turn into PDO, have had a go but I keep getting an error.

This is the original

$result = sqlsrv_query($conn, $sql); 
$r = sqlsrv_fetch_array($result);  
$numrows = $r[0];

This is what Im trying but its not working

$r = $conn->prepare($sql);
$r->execute();
while ($rows = $r->fetch(PDO::FETCH_ASSOC)) {
$numrows = $rows[0];
}
2

and that would be which one?

btw. that whole PDO code makes no sense:

  • if there are no data in the query, there is no need to use a prepared statement
  • PDO works best with foreach(). while() is too cumbersome.
  • depending on what result you want, there is certainly a better matching fetch mode for it.

I would guess

$r = $conn->query($sql);
$numrows = $r->fetchColumn();

would do the job as well.

1 Like
3

Sorry ye I forgot to post the error, its

Notice: Undefined offset: 0 in

4

An associative array does not have a numeric index.

5

I see, so how I retrieve $rows[0]

6

See post #2

1 Like
7

ah sorry, so i can call it by using $numrows[0]

8

why making it more complicated than it actually is?

9

Right I see, so i dont need to add the array position on it, ok thank you Dormilich

10

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.