Easier development of database driven PHP portlets

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 5.0.0
• Fix Version/s: 5.0.0
• Component/s: None
• Labels: None

Just deploy a portlet with one index.php file with content like:

<?php
$pdo = new PDO("java_liferay:jdbc/LiferayPool");

$sql = "select * from user_";

foreach ($pdo->query($sql) as $row)

{ echo $row['userId'] . "<br />"; }

?>

Will attach a sample zip file with this in it already. This is done via injection of the datasource when the portlet starts up.

We can't inject it into "java:" because it's not a writeable context, so we inject it into "java_liferay:".