[insert_php]

try{
$dbh = new PDO(“mysql:host=localhost; dbname=uzchsrscac_uz”,”uzchsrscac_uz”,”password1″);
}
catch(PDOException $e)
{
echo $e->getMessage();
}

$posts = $dbh->prepare(“SELECT * from `research-reocrd-final-view`”);
$posts->execute();
foreach($posts as $row)
{
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
}
echo “

Project Title Field of Research Funding Agency Budget PI Start Date End Date Institution Title Gender Position Email Phone Co Investigator Department Co Investigator1 Institution1 Department1 Co Investigator2 Institution2 Department2 Study Site Publication1 Publication2 Publication3
“.$row[0].” “.$row[1].” “.$row[2].” “.$row[3].” “.$row[4].” “.$row[5].” “.$row[6].” “.$row[7].” “.$row[8].” “.$row[9].” “.$row[10].” “.$row[11].” “.$row[12].” “.$row[13].” “.$row[14].” “.$row[15].” “.$row[16].” “.$row[17].” “.$row[18].” “.$row[19].” “.$row[20].” “.$row[21].” “.$row[22].” “.$row[23].” “.$row[24].”

“;
[/insert_php]