newFindCommand('BareBone'); $request->addFindCriterion('Type Produit', $_REQUEST['Prod']); $request->addFindCriterion('Statut', "Auto"); $request->addSortRule('Note', 1, FILEMAKER_SORT_DESCEND); if (isset($_REQUEST['Ref'])) {$request->addFindCriterion('Reference', $_REQUEST['Ref']);}}; if ($_REQUEST['Prod'] == "Boitier") { $request = $fm->newFindCommand('Boitier'); $request->addFindCriterion('Type Produit', $_REQUEST['Prod']); $request->addFindCriterion('Statut', "Auto"); $request->addSortRule('Note', 1, FILEMAKER_SORT_DESCEND); if (isset($_REQUEST['Ref'])) {$request->addFindCriterion('Reference', $_REQUEST['Ref']);}}; if ($_REQUEST['Prod'] == "Alimentation") { $request = $fm->newFindCommand('Alimentation'); $request->addFindCriterion('Statut', "Auto"); $request->addFindCriterion('Type Produit', 'Bloc d\'Alimentation'); if (isset($_REQUEST['Ref'])) {$request->addFindCriterion('Reference', $_REQUEST['Ref']);}}; if ($_REQUEST['Prod'] == "Bluetooth") { $request = $fm->newFindCommand('Bluetooth'); $request->addFindCriterion('Type Produit', $_REQUEST['Prod']); $request->addFindCriterion('Statut', "Auto"); $request->addSortRule('PRIXVTTCA', 1, FILEMAKER_SORT_ASCEND); if (isset($_REQUEST['Ref'])) {$request->addFindCriterion('Reference', $_REQUEST['Ref']);}}; if ($_REQUEST['Prod'] == "Carte Mere") { $request = $fm->newFindCommand('Carte Mere'); $request->addFindCriterion('Type Produit', $_REQUEST['Prod']); $request->addFindCriterion('Statut', "Auto"); if (isset($_REQUEST['Ref'])) {$request->addFindCriterion('Reference', $_REQUEST['Ref']);}}; if ($_REQUEST['Prod'] == "Carte Graphique") { $request = $fm->newFindCommand('Carte Graphique'); $request->addFindCriterion('Type Produit', $_REQUEST['Prod']); $request->addFindCriterion('Statut', "Auto"); $request->addSortRule('PRIXVTTCA', 1, FILEMAKER_SORT_ASCEND); if (isset($_REQUEST['Ref'])) {$request->addFindCriterion('Reference', $_REQUEST['Ref']);}}; if ($_REQUEST['Prod'] == "Carte Acquisition") { $request = $fm->newFindCommand('Carte Acquisition'); $request->addFindCriterion('Type Produit', $_REQUEST['Prod']); $request->addFindCriterion('Statut', "Auto"); $request->addSortRule('PRIXVTTCA', 1, FILEMAKER_SORT_ASCEND); if (isset($_REQUEST['Ref'])) {$request->addFindCriterion('Reference', $_REQUEST['Ref']);}}; if ($_REQUEST['Prod'] == "Carte Controleur") { $request = $fm->newFindCommand('Carte Controleur'); $request->addFindCriterion('Type Produit', $_REQUEST['Prod']); $request->addFindCriterion('Statut', "Auto"); $request->addSortRule('PRIXVTTCA', 1, FILEMAKER_SORT_ASCEND); if (isset($_REQUEST['Ref'])) {$request->addFindCriterion('Reference', $_REQUEST['Ref']);}}; if ($_REQUEST['Prod'] == "Carte reseau") { $request = $fm->newFindCommand('Carte reseau'); $request->addFindCriterion('Type Produit', $_REQUEST['Prod']); $request->addFindCriterion('Statut', "Auto"); $request->addSortRule('PRIXVTTCA', 1, FILEMAKER_SORT_ASCEND); if (isset($_REQUEST['Ref'])) {$request->addFindCriterion('Reference', $_REQUEST['Ref']);}}; if ($_REQUEST['Prod'] == "Carte Son") { $request = $fm->newFindCommand('Carte Son'); $request->addFindCriterion('Type Produit', $_REQUEST['Prod']); $request->addFindCriterion('Statut', "Auto"); $request->addSortRule('PRIXVTTCA', 1, FILEMAKER_SORT_ASCEND); if (isset($_REQUEST['Ref'])) {$request->addFindCriterion('Reference', $_REQUEST['Ref']);}}; if ($_REQUEST['Prod'] == "Carte TV") { $request = $fm->newFindCommand('Carte TV'); $request->addFindCriterion('Type Produit', $_REQUEST['Prod']); $request->addFindCriterion('Statut', "Auto"); $request->addSortRule('PRIXVTTCA', 1, FILEMAKER_SORT_ASCEND); if (isset($_REQUEST['Ref'])) {$request->addFindCriterion('Reference', $_REQUEST['Ref']);}}; if ($_REQUEST['Prod'] == "Cartes de decompression") { $request = $fm->newFindCommand('Carte Divers'); $request->addFindCriterion('Type Produit', $_REQUEST['Prod']); $request->addFindCriterion('Statut', "Auto"); $request->addSortRule('PRIXVTTCA', 1, FILEMAKER_SORT_ASCEND); if (isset($_REQUEST['Ref'])) {$request->addFindCriterion('Reference', $_REQUEST['Ref']);}}; if ($_REQUEST['Prod'] == "Casque & Micro") { $request = $fm->newFindCommand('Casque et Micro'); $request->addFindCriterion('Type Produit', $_REQUEST['Prod']); $request->addFindCriterion('Statut', "Auto"); $request->addSortRule('PRIXVTTCA', 1, FILEMAKER_SORT_ASCEND); if (isset($_REQUEST['Ref'])) {$request->addFindCriterion('Reference', $_REQUEST['Ref']);}}; if ($_REQUEST['Prod'] == "Pack Clavier Souris") { $request = $fm->newFindCommand('Clavier Souris'); $request->addFindCriterion('Type Produit', 'Pack Clavier/Souris'); $request->addFindCriterion('Statut', "Auto"); $request->addSortRule('PRIXVTTCA', 1, FILEMAKER_SORT_ASCEND); if (isset($_REQUEST['Ref'])) {$request->addFindCriterion('Reference', $_REQUEST['Ref']);}}; if ($_REQUEST['Prod'] == "Clavier") { $req1 = $fm->newFindRequest('Clavier Souris'); $req1->addFindCriterion('Type Produit', 'Clavier'); $req1->addFindCriterion('Statut', 'Auto'); $req2 = $fm->newFindRequest('Clavier Souris'); $req2->addFindCriterion('Type Produit', 'Pack Clavier/Souris'); $req2->setOmit(TRUE); $request = $fm->newCompoundFindCommand('Clavier Souris'); $request->add(1, $req1); $request->add(2, $req2); $request->addFindCriterion('Statut', "Auto"); $request->addSortRule('PRIXVTTCA', 1, FILEMAKER_SORT_ASCEND); $request->setRange($Skip, $Max); $result = $request->execute(); } if ($_REQUEST['Prod'] == "Connectique interne") { $request = $fm->newFindCommand('Connectique'); $request->addFindCriterion('Type Produit', $_REQUEST['Prod']); $request->addFindCriterion('Statut', "Auto"); $request->addSortRule('PRIXVTTCA', 1, FILEMAKER_SORT_ASCEND); if (isset($_REQUEST['Ref'])) {$request->addFindCriterion('Reference', $_REQUEST['Ref']);}}; if ($_REQUEST['Prod'] == "Disque Dur interne") { $request = $fm->newFindCommand('Disque Dur'); $request->addFindCriterion('Type Produit', $_REQUEST['Prod']); $request->addSortRule('Capacite disque dur', 1, FILEMAKER_SORT_ASCEND); if (isset($_REQUEST['Ref'])) {$request->addFindCriterion('Reference', $_REQUEST['Ref']);}}; if ($_REQUEST['Prod'] == "Disque SSD") { $request = $fm->newFindCommand('Disque SSD'); $request->addFindCriterion('Type Produit', $_REQUEST['Prod']); $request->addFindCriterion('Statut', "Auto"); $request->addSortRule('Capacite disque dur', 1, FILEMAKER_SORT_ASCEND); if (isset($_REQUEST['Ref'])) {$request->addFindCriterion('Reference', $_REQUEST['Ref']);}}; if ($_REQUEST['Prod'] == "Ecran Plat") { $request = $fm->newFindCommand('Ecran Plat'); $request->addFindCriterion('Type Produit', $_REQUEST['Prod']); $request->addFindCriterion('Statut', "Auto"); $request->addSortRule('PRIXVTTCA', 1, FILEMAKER_SORT_ASCEND); if (isset($_REQUEST['Ref'])) {$request->addFindCriterion('Reference', $_REQUEST['Ref']);}}; if ($_REQUEST['Prod'] == "Haut-Parleur") { $request = $fm->newFindCommand('Haut-Parleur'); $request->addFindCriterion('Type Produit', $_REQUEST['Prod']); $request->addFindCriterion('Statut', "Auto"); $request->addSortRule('PRIXVTTCA', 1, FILEMAKER_SORT_ASCEND); if (isset($_REQUEST['Ref'])) {$request->addFindCriterion('Reference', $_REQUEST['Ref']);}}; if ($_REQUEST['Prod'] == "Lecteur Graveur") { $request = $fm->newFindCommand('Lecteur Graveur'); $request->addFindCriterion('AutoCDDVD', 'Optique'); $request->addFindCriterion('Statut', "Auto"); $request->addSortRule('PRIXVTTCA', 1, FILEMAKER_SORT_ASCEND); $request->addFindCriterion('AutoCDDVD', 'Optique'); $request->addFindCriterion('int ext', 'Interne 5,25 pouces'); if (isset($_REQUEST['Ref'])) {$request->addFindCriterion('Reference', $_REQUEST['Ref']);}}; if ($_REQUEST['Prod'] == "Lecteur de cartes memoires") { $request = $fm->newFindCommand('Lecteur de cartes memoires'); $request->addFindCriterion('Type Produit', $_REQUEST['Prod']); $request->addFindCriterion('Statut', "Auto"); $request->addSortRule('PRIXVTTCA', 1, FILEMAKER_SORT_ASCEND); if (isset($_REQUEST['Ref'])) {$request->addFindCriterion('Reference', $_REQUEST['Ref']);}}; if ($_REQUEST['Prod'] == "Memoire Vive") { $request = $fm->newFindCommand('Memoire Vive'); $request->addFindCriterion('Type Produit', $_REQUEST['Prod']); $request->addFindCriterion('Statut', "Auto"); $request->addSortRule('PRIXVTTCA', 1, FILEMAKER_SORT_ASCEND); if (isset($_REQUEST['Ref'])) {$request->addFindCriterion('Reference', $_REQUEST['Ref']);}}; if ($_REQUEST['Prod'] == "Processeur") { $request = $fm->newFindCommand('Processeur'); $request->addFindCriterion('Type Produit', $_REQUEST['Prod']); $request->addFindCriterion('Statut', "Auto"); $request->addSortRule('PRIXVTTCA', 1, FILEMAKER_SORT_ASCEND); if (isset($_REQUEST['Ref'])) {$request->addFindCriterion('Reference', $_REQUEST['Ref']);}}; if ($_REQUEST['Prod'] == "Accessoire") { $request = $fm->newFindCommand('Accessoire'); $request->addFindCriterion('Type Produit', $_REQUEST['Prod']); $request->addFindCriterion('Statut', "Auto"); $request->addSortRule('PRIXVTTCA', 1, FILEMAKER_SORT_ASCEND); if (isset($_REQUEST['Ref'])) {$request->addFindCriterion('Reference', $_REQUEST['Ref']);}}; if ($_REQUEST['Prod'] == "Souris") { $request = $fm->newFindCommand('Clavier Souris'); $request->addFindCriterion('Type Produit', "Souris"); $request->addFindCriterion('Statut', "Auto"); $request->addSortRule('PRIXVTTCA', 1, FILEMAKER_SORT_ASCEND); if (isset($_REQUEST['Ref'])) {$request->addFindCriterion('Reference', $_REQUEST['Ref']);}}; if ($_REQUEST['Prod'] == "Ventilateur") { $request = $fm->newFindCommand('Ventilateur'); $request->addFindCriterion('Type Produit', $_REQUEST['Prod']); $request->addFindCriterion('Statut', "Auto"); $request->addSortRule('PRIXVTTCA', 1, FILEMAKER_SORT_ASCEND); if (isset($_REQUEST['Ref'])) {$request->addFindCriterion('Reference', $_REQUEST['Ref']);}}; if ($_REQUEST['Prod'] == "Ventirad") { $request = $fm->newFindCommand('Ventirad'); $request->addFindCriterion('Type Produit', 'Ventirad CPU'); $request->addFindCriterion('Statut', "Auto"); $request->addSortRule('PRIXVTTCA', 1, FILEMAKER_SORT_ASCEND); if (isset($_REQUEST['Ref'])) {$request->addFindCriterion('Reference', $_REQUEST['Ref']);}}; if ($_REQUEST['Prod'] == "Accessoire ventilation") { $request = $fm->newFindCommand('Accessoires Moding'); $request->addFindCriterion('Type Produit', $_REQUEST['Prod']); $request->addFindCriterion('Statut', "Auto"); $request->addSortRule('PRIXVTTCA', 1, FILEMAKER_SORT_ASCEND); if (isset($_REQUEST['Ref'])) {$request->addFindCriterion('Reference', $_REQUEST['Ref']);}}; if ($_REQUEST['Prod'] == "Logiciel") { $request = $fm->newFindCommand('Logiciel'); $request->addFindCriterion('Type Produit', $_REQUEST['Prod']); $request->addFindCriterion('Statut', "Auto"); $request->addSortRule('PRIXVTTCA', 1, FILEMAKER_SORT_ASCEND); if (isset($_REQUEST['Ref'])) {$request->addFindCriterion('Reference', $_REQUEST['Ref']);}}; if ($_REQUEST['Prod'] == "HTPC") { $request = $fm->newFindCommand('HTPC'); $request->addFindCriterion('Type Produit', $_REQUEST['Prod']); $request->addSortRule('Note', 1, FILEMAKER_SORT_ASCEND); if (isset($_REQUEST['Ref'])) {$request->addFindCriterion('Reference', $_REQUEST['Ref']);}}; if ($_REQUEST['Prod'] == "Mini-ITX") { $request = $fm->newFindCommand('Mini-ITX'); $request->addFindCriterion('Type Produit', $_REQUEST['Prod']); $request->addSortRule('Note', 1, FILEMAKER_SORT_ASCEND); if (isset($_REQUEST['Ref'])) {$request->addFindCriterion('Reference', $_REQUEST['Ref']);}}; if ($_REQUEST['Prod'] == "Système d'Exploitation") { $request =& $fm->newCompoundFindCommand('Logiciel'); $findreq1 =& $fm->newFindRequest('Logiciel'); $findreq1->addFindCriterion('Type logiciels', 'Logiciel Système'); $findreq1->addFindCriterion('PC ou Mac', 'PC'); $findreq1->addFindCriterion('Modele', 'Seven'); $findreq1->addFindCriterion('Statut', 'Auto'); $request =& $fm->newCompoundFindCommand('Logiciel'); $findreq2 =& $fm->newFindRequest('Logiciel'); $findreq2->addFindCriterion('Type logiciels', 'Logiciel Système'); $findreq2->addFindCriterion('PC ou Mac', 'PC'); $findreq2->addFindCriterion('Modele', 'Ubuntu'); $findreq2->addFindCriterion('Statut', 'Auto'); $request =& $fm->newCompoundFindCommand('Logiciel'); $findreq3 =& $fm->newFindRequest('Logiciel'); $findreq3->addFindCriterion('Type logiciels', 'Logiciel Système'); $findreq3->addFindCriterion('PC ou Mac', 'PC'); $findreq3->addFindCriterion('Modele', 'OpenSUSE'); $findreq3->addFindCriterion('Statut', 'Auto'); $request =& $fm->newCompoundFindCommand('Logiciel'); $findreq4 =& $fm->newFindRequest('Logiciel'); $findreq4->addFindCriterion('Type logiciels', 'Logiciel Système'); $findreq4->addFindCriterion('PC ou Mac', 'PC'); $findreq4->addFindCriterion('Modele', 'Mint'); $findreq4->addFindCriterion('Statut', 'Auto'); $request->add(1,$findreq1); $request->add(2,$findreq2); $request->add(3,$findreq3); $request->add(4,$findreq4); $request->addFindCriterion('Statut', "Auto"); $request->addSortRule('PRIXVTTCA', 1, FILEMAKER_SORT_ASCEND); $request->setRange($Skip, $Max); } $result = $request->execute(); $records = $result->getRecords(); ?> <?php echo $titre_site; ?>
| "> | | |







getFoundSetCount(); if ($foundquantite == 1) echo "$foundquantite produit en vente..."; if ($foundquantite != 1) echo "$foundquantite produits en ventes..."; ?>








<?php echo nl2br($record->getField('Type Produit', 0) )?> <?php echo nl2br($record->getField('Marque', 0) )?> <?php echo nl2br($record->getField('Modele', 0) )?>
getField('Marque', 0) )?> getField('Modele', 0) )?>

getField('UserReview', 0) )?>
Réf. : getField('Reference', 0) )?>



getField('PRIXVTTCA', 0) )?> € TTC


 






getField('Type Produit', 0) )?> getField('Marque', 0) )?> getField('Modele', 0) )?>


getField('Pic2') != "") { ?>






























Réf. : getField('Reference', 0) )?>
Matériel disponible
Livrable sous getField('Delai livraison', 0) )?>


getField('PRIXVTTCA', 0) )?> €
getField('PRIXVHTA', 0) )?> € HT

Quantité ?




getField('Garantis') != "") { ?> Garantie getField('Garantis', 0) )?>

 

































































';} ?>
| Mentions légales | Affiliate Program | ©2010/2013 PCMontage.fr