'; echo 'Connected to database
'; echo " Using (PDO::FETCH_NUM)
"; /*** The SQL SELECT statement ***/ //$sql = "SELECT * FROM emp1 ORDER BY fname"; $sql= "SELECT ctof(29.25)"; /*** fetch into an PDOStatement object ***/ $stmt = $dbconn->query($sql); /*** echo number of columns ***/ $result = $stmt->fetch(PDO::FETCH_NUM); //$result = $stmt->fetch(PDO::FETCH_ASSOC); // PDO::FETCH_NUM returns the row as a numerical array /*** loop over the object directly ***/ foreach($result as $key=>$val) { echo "function Converting (ºC to ºF) row::". $key.' = '.$val.'⁰F
'; } /*** close the database connection ***/ $dbconn= null; } catch(PDOException $e) { echo $e->getMessage(); } ?>