pdo_stored_func2.htm
 
Uses:
/*** 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 Celsius to Fahrenheit (C to F) ". $key.' = '.$val.'<br />';
    }
   

 

Code

<?php
/*** mysql hostname ***/
$hostname = 'localhost';
/*** mysql username ***/
$username = 'Manas9';
/* dbname */
$db = "test";
/*** mysql password ***/
$password = 'Manas9237';

try {

$dbconn= new PDO("mysql:host=$hostname;dbname=$db", $username, $password);
/*** echo a message saying we have connected ***/
echo 'Retreive of MySQL stored function with PDP <br />';
echo 'Connected to database <br />';
/*** The SQL SELECT statement ***/
//$sql = "SELECT * FROM emp1 ORDER BY fname";
$sql= "SELECT ctof(29.25)";
echo" fetch into an PDOStatement object <br/>";
$stmt = $dbconn->prepare($sql);
$stmt->execute();

/* Fetch only the first row from the results */
$result= $stmt->fetch();
echo "29.25<sup>o</sup>C = ".$result[0]." <sup>o</sup>F ";
echo "<br/>db closed ";
/*** close the database connection ***/
$dbconn= null;
}
catch(PDOException $e)
{
echo $e->getMessage();
}
?>
 

Displaying with Firefox browser:

Using MySQL PHP application: