PHP MySqlHelper::loadDataFromTableOrView示例

示例#1

文件： index.php 项目： pierodetomi/mysqlhelper

$people = $dbHelper->loadDataFromStoredProcedure(Person . __CLASS__, "getPersonById", array(2));
echo "getPersonById<br />";
echo json_encode($people[0]);
echo "<br /><br />";
// Load data from a stored procedure (passing 2 parameters)
$people = $dbHelper->loadDataFromStoredProcedure(Person . __CLASS__, "findPersonByIdOrName", array(2, "er"));
echo "findPersonByIdOrName<br />";
echo json_encode($people);
echo "<br /><br />";
// Load data from a stored procedure (without parameters)
$people = $dbHelper->loadDataFromStoredProcedure(Person . __CLASS__, "getPeople");
echo "getPeople<br />";
echo json_encode($people);
echo "<br /><br />";
// Load data from a table
$people = $dbHelper->loadDataFromTableOrView(Person . __CLASS__, "Person");
echo "Person table data<br />";
echo json_encode($people);
echo "<br /><br />";
// Load data from a view
$people = $dbHelper->loadDataFromTableOrView(Person . __CLASS__, "AllPeople");
echo "AllPeople view data<br />";
echo json_encode($people);
echo "<br /><br />";
$where = new SqlWhere();
$where->addCondition(ConditionType::NONE, "first_name", "=", "Piero", ParameterType::STRING)->addCondition(ConditionType::_OR, "first_name", "=", "Marco", ParameterType::STRING);
// Load data from a view
$people = $dbHelper->loadDataFromTableOrView(Person . __CLASS__, "AllPeople", $where);
echo "AllPeople view data (filtered)<br />";
echo json_encode($people);
echo "<br /><br />";