<html>
<head>
<title>fpBatis List Example</title>
</head>
<body>
<p>
<a href="list_example.php">List Example</a><br/>
<a href="create_example.php">Create Example</a>
</p>
<?php
require 'fpbatis.php';
$fpBatis = new FPBatis('sqlMap.xml');
$fpBatis->setDebug(true);
$id = $_GET['id'];
if ($_GET['delete'] == 'country') {
$fpBatis->doDelete('Countries.delete', array('id' => $id));
} else {
if ($_GET['delete'] == 'state') {
$fpBatis->doDelete('States.delete', array('id' => $id));
} else {
if ($_GET['delete'] == 'city') {
$fpBatis->doDelete('Cities.delete', array('id' => $id));
}
}
}
$params = array();
$params['sort'] = 'country';
$params['sortDir'] = 'DESC';
$params['idList'] = array(1, 2);
$allCountries = $fpBatis->doSelect('Countries.selectAll', $params);
echo '<ul>';
