Re: Regarding calling stored procedures

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



<?php
$mysql = mysql_connect
("localhost", "root", "abcd", "empdb");
$res_new=array();
$Query1="";$Query="";$result1=0;
$url="sciencedaily.com";
$Query1="call GetExpert_last('$url')";
echo $Query1;
echo "<br/>";
$res = $mysql->query("$Query1");
if(mysqli_num_rows($res)>0)
{
$row = mysql_fetch_row($res);
$res = $row[0];
$res_new[] = $row[0];
$res_new[] = $row[1];
//$mysqli->close();
//$res=NULL;
*********$Query="call GetExpert_lastvalue($res)";
echo $Query;echo "<br/>";
$result1=5;
$result1=$mysql->query("$Query");
echo "hai";echo "<br/>";
echo $result1;
if(mysql_num_rows($result1)>0)
{
$expert_value= mysql_fetch_row($result1);
$res_new[]=$expert_value[0];
$res_new[]=$expert_value[1];

$res_new[]=$expert_value[2];

} else
{
$res_new[]="None";
}
}

for($i=0;$i<count($res_new);$i++)
{
$strid= $res_new["$i"];
echo $strid;
echo "<br/>";
}


?>


[Non-text portions of this message have been removed]


[Index of Archives]     [PHP Home]     [PHP Users]     [PHP Soap]     [Kernel Newbies]     [Yosemite]     [Yosemite Campsites]

  Powered by Linux