Hi experts,
I use DataConnector for getting data from database. With this code:
[code]<?php
require_once("…/codebase/data_connector.php");
require_once(“config.php”);
$conn = mysql_connect($mysql_server,$mysql_user,$mysql_pass);
mysql_select_db($mysql_db);
mysql_query('set names utf8');
$data = new DataConnector($conn);
$data->dynamic_loading(20);
$data->render_sql("SELECT *,cat.title as catTitle,con.title as title FROM ".$mysql_prefix."content AS con JOIN ".$mysql_prefix."categories AS cat ON con.catid=cat.id WHERE sectionid=1 AND state=1 ORDER BY created DESC;","con.Id","id,title,catTitle,introtext,fulltext,created");
?>[/code]
I read this but in the xml file that I created “pos” parameter and “total_count” parameter there aren’t. But “dynamic_loading(20);” loads the first 20 rows. So i tried DataViewConnector. There is “total_count” parameter but dataview can not read the xml file. So i tried to use the instruction LIMIT in sql, but don’t work. How can i do?
Another problem. Don’t view Bottom Toolbaar with the iphone but work with android. The code:var bottomToolbar = {
view: "toolbar",
height:50,
id: "bottomBar",
type: "SubBar",
elements:[{ view: "segmented", id:'bottomTabbar', selected:'dataview_1', multiview:true, align:"center",height:50,
options: [
{ value: 'dataview_1', label: 'Notizie'},
{ value: 'template_2', label: 'Schede'},
]}
]
};
Excuse me for my english. thanks