Unclear how to implement SHOW TABLES query

[wpebley]

Hi!

Love your PDO Wrapper! I am successfully using it in a large project and it has significantly cut down on my code size.

I hope you'll pardon my ignorance here, but it is unclear to me how I go about reading in and storing the results of TABLE SHOW using the wrapper. In regular PDO code, I am using the following...

//Execute the SHOW TABLE query
 try {
     $conn = new PDO(...);
     $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
     $stmt = $conn->prepare("SHOW TABLES");
     $stmt->execute();
 }
 catch(PDOException $e){
     echo "Error: " . $e->getMessage();
 }

 //Build array from the resulting SQL file rows

 $table= [];

 $row = 0;
 while ($r = $stmt->fetch(PDO::FETCH_NUM)) {
     $table[$row] = $r[0];
     $row = $row + 1;
 }       

This is the last piece that will allow me to have converted the entire project to your wrapper. Any guidance will be appreciated.

Thx,

Bill

[wpebley]

Hi dcblogdev! While revisiting my code, I just came back around to this issue. Any thoughts on how to implement SHOW TABLES in your wrapper?