[TYPO3-dev] Obsolete parts of pibase (WAS: classes location, get data from query...)

[Andrew Davis]

Hi Elmar,

I have read thru this and am trying to implement the dbal call... I fear 
that my lack of in-depth php knowledge is not helping any...learning...


I am trying to output a simple query (table and extension all setup from 
kickstarter...)

Here is my code, it is currently not outputting anything on front end I 
cut anad pased it, few changes, from the 1.4. Database connectivity and 
DBAL chapter you linked in last reply.


[start code]


function GenerateSlideShow($content,$conf){


//Get all rows
$res = $GLOBALS['TYPO3_DB']->sql(TYPO3_db, 'SELECT * FROM 
tx_avgffeatcontent_items');


$Slideshow='';	// init var;

while( $row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res) ) {

	$Slideshow.= $row['fc_title'].'<br />';
			
}


return $slideshow;

}


[end code]




I can substitute a string in the return statment, and I see it on the 
webpage, so all that is working, it is my db call or something else not 
working....

Any help much appreciated!

Thanks in advance,
Andrew Davis



> 
> 3.) Queries: 
> 
> The same. Forget pi_base API. Use new DBAL directly. 
> 
> http://typo3.org/documentation/document-library/core-documentation/doc_core_cgl/4.0.0/view/1/4/
> 
>