Canon EOS 7D
)
*/
//if ((isset($_POST)) and (! empty($_POST))) {
if (! empty($_POST)){
echo "info dispo";
$key = key($_POST);
$val = $_POST["$key"];
$_POST = array();
$page = 1;
//echo $key . " - " . $val;
$req = "SELECT * FROM photos WHERE " . $key . " = '" . $val . "'";
echo $req;
$conn2 = new PDO("sqlite:db_photo.sqlite3");
$conn2->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$limit = 13;
$offset = $limit * ($page -1);
$stmt = $conn2->prepare($req);
//$stmt->execute(array($limit, $offset));
$stmt->execute();
$result = $stmt->fetchAll(PDO::FETCH_ASSOC);
$rowcount = count($result);
echo $rowcount;
}
else {
echo "non dispo";
}
_pr($_POST);
echo 'requests';
$conn = new PDO("sqlite:db_photo.sqlite3");
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$request = array(
'lens' => 'SELECT DISTINCT lens FROM photos WHERE lens <> "" ORDER BY lens',
'model' => 'SELECT DISTINCT model FROM photos WHERE model <> "" ORDER BY model',
'iso' => 'SELECT DISTINCT iso FROM photos WHERE iso <> "" ORDER BY iso',
'speed' => 'SELECT DISTINCT speed FROM photos WHERE speed <> "" ORDER BY speed',
'keywords' => 'SELECT DISTINCT keywords FROM photos WHERE keywords <> ""'
);
$select = array();
$i = 0;
foreach ($request as $key => $val){
$query = $conn->query($val);
$select[$i] = $query->fetchAll(PDO::FETCH_ASSOC);
$select[$i] = array_column($select[$i],$key);
if ($i == 4){
$mc = array();
foreach($select[$i] as $row){
$x = explode(",", $row);
foreach ($x as $y){
if ((! str_starts_with($y, "_")) && (! str_ends_with($y, "_"))) {
$mc [] = $y;
}
}
}
$motcles = array_unique($mc);
usort($motcles, 'strcasecmp'); // 'strcasecmp'
$select[$i] = $motcles;
}
$i++;
}
//_pr($select);
/*
try {
$query = $conn->query('SELECT DISTINCT lens FROM photos WHERE lens <> "" ORDER BY lens');
$lens = $query->fetchAll(PDO::FETCH_ASSOC);
$lens = array_column($lens,'lens');
$query = $conn->query('SELECT DISTINCT model FROM photos WHERE model <> "" ORDER BY model');
$model = $query->fetchAll(PDO::FETCH_ASSOC);
$model = array_column($model,'model');
$query = $conn->query('SELECT DISTINCT iso FROM photos WHERE iso <> "" ORDER BY iso');
$iso = $query->fetchAll(PDO::FETCH_ASSOC);
$iso = array_column($iso,'iso');
$query = $conn->query('SELECT DISTINCT speed FROM photos WHERE speed <> "" ORDER BY speed');
$speed = $query->fetchAll(PDO::FETCH_ASSOC);
$speed = array_column($speed,'speed');
$query = $conn->query('SELECT DISTINCT keywords FROM photos WHERE keywords <> ""');
$keywords = $query->fetchAll(PDO::FETCH_ASSOC);
$keywords = array_column($keywords,'keywords');
$conn = null;
}
catch(PDOException $e) {
echo $e->getMessage();
}
//_pr($keywords);
$mc = array();
foreach($keywords as $row){
$x = explode(",", $row);
foreach ($x as $y){
if ((! str_starts_with($y, "_")) && (! str_ends_with($y, "_"))) {
$mc [] = $y;
}
}
}
$motcles = array_unique($mc);
usort($motcles, 'strcasecmp'); // 'strcasecmp'
echo count($motcles);
*/
/*
https://www.csscodelab.com/pure-css-custom-select-box-dropdown-styling/
*/
?>
"> | "> | "> | ">
© 2013- sur-le-sentier.fr