{"id":222,"date":"2010-01-10T04:23:44","date_gmt":"2010-01-10T02:23:44","guid":{"rendered":"http:\/\/grummfy.be\/blog\/?p=222"},"modified":"2010-01-10T15:47:17","modified_gmt":"2010-01-10T13:47:17","slug":"tri-de-listing-sql-via-des-liens-dans-zend-framework","status":"publish","type":"post","link":"https:\/\/grummfy.be\/blog\/222","title":{"rendered":"Tri de listing sql via des liens dans Zend Framework"},"content":{"rendered":"<p style=\"text-align: justify;\">Dans la plupart des cas lorsque l&rsquo;on affiche un listing provenant d&rsquo;une requ\u00eate sql on aimerait pouvoir offrir le tri \u00e0 l&rsquo;utilisateur. Dans l&rsquo;article qui suit, je vous propose de d\u00e9couvrir une mani\u00e8re de le faire assez facilement.<\/p>\n<p><!--more--><\/p>\n<p style=\"text-align: justify;\">Comme exemple nous prendrons le cas d&rsquo;une liste via l&rsquo;appelle du contr\u00f4leur membres et de l&rsquo;action liste.<\/p>\n<p style=\"text-align: justify;\">Dans le fichier <em>MembresController.php<\/em> nous aurons donc une m\u00e9thode <em>listeAction()<\/em><\/p>\n<pre lang=\"php\">\r\npublic function listeAction()\r\n{\r\n\t$membres = new Default_Model_DbTable_Membres();\r\n\t$this->view->entries = $membres->fetchAll();\r\n}\r\n<\/pre>\n<p>Et dans la vue <em>membres\/liste.phtml<\/em> nous aurons :<\/p>\n<pre lang=\"php\">\r\n<?php\r\n\r\n$rowCount = count($this->entries);\r\nif ($rowCount > 0)\r\n{\r\n?>\r\n<table>\r\n\t<tr>\r\n\t\t<th>Nom<\/th>\r\n\t\t<th>Adresse<\/th>\r\n\t\t<th>Code postal<\/th>\r\n\t\t<th>Ville<\/th>\r\n\t\t<th>Email<\/th>\r\n\t<\/tr>\r\n<?php foreach($this->entrie as $entry): ?>\r\n\t<tr>\r\n\t\t<td><?php echo $this->escape($entry->name) ?><\/td>\r\n\t\t<td><?php echo $this->escape($entry->addrese) ?><\/td>\r\n\t\t<td><?php echo $entry->postCode ?><\/td>\r\n\t\t<td><?php echo $this->escape($entry->cityName) ?><\/td>\r\n\t\t<td><?php echo $this->escape($entry->email) ?><\/td>\r\n\t<\/tr>\r\n<?php\r\n\tendforeach;\r\n\techo '<\/table>';\r\n}\r\nelse\r\n{\r\n\techo '<div>Aucun membre n\\'est enregistr\u00e9!<br \/>;)<br \/><\/div>';\r\n}\r\n?>\r\n<\/pre>\n<p>Jusque l\u00e0, normalement, rien de bien complexe pour celui qui connait ZF.<\/p>\n<p style=\"text-align: justify;\">Ajoutons deux fichiers (cf <a rel=\"attachment wp-att-223\" href=\"http:\/\/grummfy.be\/blog\/222\/zf-tuto-order-by\">pi\u00e8ce jointe<\/a>) dans le dossier librairy\/Gru.<\/p>\n<p style=\"text-align: justify;\">\nNous devons ensuite les charger de mani\u00e8re automatique. Pour ce faire, dans le bootstrap.php (dont un extrait possible est pr\u00e9sent ci-dessous) ajoutons les informations n\u00e9cessaires au chargement des fichiers :<\/p>\n<pre lang=\"php\">\r\n\tprotected function _initAutoload()\r\n\t{\r\n\t\t\/\/ nos deux lignes ajout\u00e9es\r\n\t\t$autoloader = Zend_Loader_Autoloader::getInstance();\r\n\t\t$autoloader->registerNamespace('Gru');\r\n\t\t\/\/ fin de l'ajout\r\n\r\n\t\t\/\/ Exemple de ce qu'il pourrait y avoir en plus!\r\n\t\t$autoloader = new Zend_Application_Module_Autoloader(array(\r\n\t\t\t'namespace' => 'Default',\r\n\t\t\t'basePath'  => dirname(__FILE__),\r\n\t\t));\r\n\t\treturn $autoloader;\r\n\t}\r\n\r\n\tprotected function _initView()\r\n\t{\r\n\t\t$view = new Zend_View();\r\n\t\t$viewRenderer = Zend_Controller_Action_HelperBroker::getStaticHelper('ViewRenderer');\r\n\t\t$viewRenderer->setView($view);\r\n\r\n\t\t\/\/d\u00e9but ajout\r\n\t\t$view->addHelperPath(APPLICATION_PATH . '\/..\/library\/Gru\/View\/Helper\/', 'Gru_View_Helper_');\r\n\t\t\/\/ fin de l'ajout\r\n\r\n\t\treturn $view;\r\n\t}\r\n<\/pre>\n<p>Maintenant, modifions notre application pour ajouter le tri. Reprenons notre contr\u00f4leur et modifions la m\u00e9thode <em>listeAction().<\/em><\/p>\n<pre lang=\"php\">\r\npublic function listeAction()\r\n{\r\n\t\/\/ Gestion du tri\r\n\t$order = new Gru_OrderBy('membre');\r\n\r\n\t\/\/Ajout des clefs de tri\r\n\t$order->addKey('name', 'Nom', 'asc');\r\n\t$order->addKey('add', 'Adresse');\r\n\t$order->addKey('postCode', 'Code postal', 'asc');\r\n\t$order->addKey('cityName', 'Ville', 'asc');\r\n\t$order->addKey('email', 'Courriel', 'asc');\r\n\r\n\t\/\/ injection des requ\u00eates get\r\n\t$order->insertRequestParams($this->getRequest()->getParam('order'), $this->getRequest()->getParam('by'));\r\n\r\n\t$this->view->orderKeys = $order->getKeys();\r\n\r\n\r\n\r\n\t$membres = new Default_Model_DbTable_Membres();\r\n\t\/\/ne pas oubleir d'ajouter les champs trier au moment de la requ\u00eate sql\r\n\t$this->view->entries = $membres->fetchAll(null, $order->getSqlKeys());\r\n}\r\n<\/pre>\n<p>Et pour finir notre vue :<\/p>\n<pre lang=\"php\">\r\n<?php\r\n\r\n$rowCount = count($this->entries);\r\nif ($rowCount > 0)\r\n{\r\n?>\r\n<table>\r\n\t<tr>\r\n\t\t<?php echo $this->orderBy()->th($this->orderKeys, $this->baseUrl('\/themes\/images\/')); ?>\r\n\t<\/tr>\r\n<?php foreach($this->entrie as $entry): ?>\r\n\t<tr>\r\n\t\t<td><?php echo $this->escape($entry->name) ?><\/td>\r\n\t\t<td><?php echo $this->escape($entry->addrese) ?><\/td>\r\n\t\t<td><?php echo $entry->postCode ?><\/td>\r\n\t\t<td><?php echo $this->escape($entry->cityName) ?><\/td>\r\n\t\t<td><?php echo $this->escape($entry->email) ?><\/td>\r\n\t<\/tr>\r\n<?php\r\n\tendforeach;\r\n\techo '<\/table>';\r\n}\r\nelse\r\n{\r\n\techo '<div>Aucun membre n\\'est enregistr\u00e9!<br \/>;)<br \/><\/div>';\r\n}\r\n?>\r\n<\/pre>\n<p>Dans l&rsquo;exemple, nous afficherons des ic\u00f4nes suivant le sens du tri, ic\u00f4nes se trouvant dans le r\u00e9pertoire sp\u00e9cifi\u00e9. Un clic sur les titres permet de trier suivant la colonne cliqu\u00e9e. A noter qu&rsquo;ici Adresse ne sera pas triable du au fait de la non pr\u00e9cision de l&rsquo;ordre.<\/p>\n<p style=\"text-align: justify;\">Il y aurait moyen d&rsquo;am\u00e9liorer le script :<\/p>\n<ul>\n<li>utilisations de d\u00e9corateurs<\/li>\n<li>utilisation de traduction<\/li>\n<li>Gru_OrderBy devrait \u00eatre un plugins<\/li>\n<li>&#8230;<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">En attendant, j&rsquo;esp\u00e8re que ce bout de code vous facilitera la vie!<\/p>\n<p style=\"text-align: justify;\">Des remarques, des questions? Postez un commentaire!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Dans la plupart des cas lorsque l&rsquo;on affiche un listing provenant d&rsquo;une requ\u00eate sql on aimerait pouvoir offrir le tri \u00e0 l&rsquo;utilisateur. Dans l&rsquo;article qui suit, je vous propose de d\u00e9couvrir une mani\u00e8re de le faire assez facilement.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"webmentions_disabled_pings":false,"webmentions_disabled":false,"footnotes":""},"categories":[9,10,5],"tags":[110,24,64],"class_list":["post-222","post","type-post","status-publish","format-standard","hentry","category-dev","category-php","category-projet","tag-php","tag-programmation","tag-zf"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.8 - aioseo.com -->\n\t<meta name=\"description\" content=\"Dans la plupart des cas lorsque l&#039;on affiche un listing provenant d&#039;une requ\u00eate sql on aimerait pouvoir offrir le tri \u00e0 l&#039;utilisateur. Dans l&#039;article qui suit, je vous propose de d\u00e9couvrir une mani\u00e8re de le faire assez facilement.\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Grummfy\"\/>\n\t<meta name=\"google-site-verification\" content=\"d4qc9gnvtzVc9s5gDVkEqZIVZLo42Wi\/lYmFP7\/G0Kw=\" \/>\n\t<meta name=\"keywords\" content=\"zend framework,zf,framework,php,tutoriel,tutorial,tutoriaux,tri,order,table,sql,programmation,d\u00e9veloppement,projet\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/grummfy.be\/blog\/222\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.8\" \/>\n\t\t<meta property=\"og:locale\" content=\"fr_FR\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Grummfy&#039;s project\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"Grummfy&#039;s project .:. Tri de listing sql via des liens dans Zend Framework\" \/>\n\t\t<meta property=\"og:description\" content=\"Dans la plupart des cas lorsque l&#039;on affiche un listing provenant d&#039;une requ\u00eate sql on aimerait pouvoir offrir le tri \u00e0 l&#039;utilisateur. Dans l&#039;article qui suit, je vous propose de d\u00e9couvrir une mani\u00e8re de le faire assez facilement.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/grummfy.be\/blog\/222\" \/>\n\t\t<meta property=\"fb:admins\" content=\"580961199\" \/>\n\t\t<meta property=\"article:tag\" content=\"zend framework\" \/>\n\t\t<meta property=\"article:tag\" content=\"zf\" \/>\n\t\t<meta property=\"article:tag\" content=\"framework\" \/>\n\t\t<meta property=\"article:tag\" content=\"php\" \/>\n\t\t<meta property=\"article:tag\" content=\"tutoriel\" \/>\n\t\t<meta property=\"article:tag\" content=\"tutorial\" \/>\n\t\t<meta property=\"article:tag\" content=\"tutoriaux\" \/>\n\t\t<meta property=\"article:tag\" content=\"tri\" \/>\n\t\t<meta property=\"article:tag\" content=\"order\" \/>\n\t\t<meta property=\"article:tag\" content=\"table\" \/>\n\t\t<meta property=\"article:tag\" content=\"sql\" \/>\n\t\t<meta property=\"article:tag\" content=\"programmation\" \/>\n\t\t<meta property=\"article:tag\" content=\"d\u00e9veloppement\" \/>\n\t\t<meta property=\"article:tag\" content=\"projet\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2010-01-10T02:23:44+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2010-01-10T13:47:17+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary\" \/>\n\t\t<meta name=\"twitter:site\" content=\"@Grummfy\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Grummfy&#039;s project .:. Tri de listing sql via des liens dans Zend Framework\" \/>\n\t\t<meta name=\"twitter:description\" content=\"Dans la plupart des cas lorsque l&#039;on affiche un listing provenant d&#039;une requ\u00eate sql on aimerait pouvoir offrir le tri \u00e0 l&#039;utilisateur. Dans l&#039;article qui suit, je vous propose de d\u00e9couvrir une mani\u00e8re de le faire assez facilement.\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/grummfy.be\\\/blog\\\/222#article\",\"name\":\"Grummfy's project .:. Tri de listing sql via des liens dans Zend Framework\",\"headline\":\"Tri de listing sql via des liens dans Zend Framework\",\"author\":{\"@id\":\"https:\\\/\\\/grummfy.be\\\/blog\\\/author\\\/admin#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/grummfy.be\\\/blog\\\/#organization\"},\"datePublished\":\"2010-01-10T04:23:44+02:00\",\"dateModified\":\"2010-01-10T15:47:17+02:00\",\"inLanguage\":\"fr-BE\",\"commentCount\":8,\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/grummfy.be\\\/blog\\\/222#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/grummfy.be\\\/blog\\\/222#webpage\"},\"articleSection\":\"D\\u00e9veloppement, PHP, Projet, PHP, programmation, ZF\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/grummfy.be\\\/blog\\\/222#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/grummfy.be\\\/blog#listItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/grummfy.be\\\/blog\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/grummfy.be\\\/blog\\\/cat\\\/projet#listItem\",\"name\":\"Projet\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/grummfy.be\\\/blog\\\/cat\\\/projet#listItem\",\"position\":2,\"name\":\"Projet\",\"item\":\"https:\\\/\\\/grummfy.be\\\/blog\\\/cat\\\/projet\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/grummfy.be\\\/blog\\\/222#listItem\",\"name\":\"Tri de listing sql via des liens dans Zend Framework\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/grummfy.be\\\/blog#listItem\",\"name\":\"Accueil\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/grummfy.be\\\/blog\\\/222#listItem\",\"position\":3,\"name\":\"Tri de listing sql via des liens dans Zend Framework\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/grummfy.be\\\/blog\\\/cat\\\/projet#listItem\",\"name\":\"Projet\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/grummfy.be\\\/blog\\\/#organization\",\"name\":\"Grummfy's project\",\"description\":\"Mes projets, mes r\\u00eaves, mes envies, ...\",\"url\":\"https:\\\/\\\/grummfy.be\\\/blog\\\/\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/grummfy.be\\\/blog\\\/author\\\/admin#author\",\"url\":\"https:\\\/\\\/grummfy.be\\\/blog\\\/author\\\/admin\",\"name\":\"Grummfy\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/grummfy.be\\\/blog\\\/222#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/97f073e7de2fb1e9d5c5329eb7db2c6de1c5a80e8cfe9b1233473f78a1c908f6?s=96&d=identicon&r=g\",\"width\":96,\"height\":96,\"caption\":\"Grummfy\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/grummfy.be\\\/blog\\\/222#webpage\",\"url\":\"https:\\\/\\\/grummfy.be\\\/blog\\\/222\",\"name\":\"Grummfy's project .:. Tri de listing sql via des liens dans Zend Framework\",\"description\":\"Dans la plupart des cas lorsque l'on affiche un listing provenant d'une requ\\u00eate sql on aimerait pouvoir offrir le tri \\u00e0 l'utilisateur. Dans l'article qui suit, je vous propose de d\\u00e9couvrir une mani\\u00e8re de le faire assez facilement.\",\"inLanguage\":\"fr-BE\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/grummfy.be\\\/blog\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/grummfy.be\\\/blog\\\/222#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/grummfy.be\\\/blog\\\/author\\\/admin#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/grummfy.be\\\/blog\\\/author\\\/admin#author\"},\"datePublished\":\"2010-01-10T04:23:44+02:00\",\"dateModified\":\"2010-01-10T15:47:17+02:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/grummfy.be\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/grummfy.be\\\/blog\\\/\",\"name\":\"Grummfy's project\",\"description\":\"Mes projets, mes r\\u00eaves, mes envies, ...\",\"inLanguage\":\"fr-BE\",\"publisher\":{\"@id\":\"https:\\\/\\\/grummfy.be\\\/blog\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Grummfy's project .:. Tri de listing sql via des liens dans Zend Framework","description":"Dans la plupart des cas lorsque l'on affiche un listing provenant d'une requ\u00eate sql on aimerait pouvoir offrir le tri \u00e0 l'utilisateur. Dans l'article qui suit, je vous propose de d\u00e9couvrir une mani\u00e8re de le faire assez facilement.","canonical_url":"https:\/\/grummfy.be\/blog\/222","robots":"max-image-preview:large","keywords":"zend framework,zf,framework,php,tutoriel,tutorial,tutoriaux,tri,order,table,sql,programmation,d\u00e9veloppement,projet","webmasterTools":{"google-site-verification":"d4qc9gnvtzVc9s5gDVkEqZIVZLo42Wi\/lYmFP7\/G0Kw=","miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/grummfy.be\/blog\/222#article","name":"Grummfy's project .:. Tri de listing sql via des liens dans Zend Framework","headline":"Tri de listing sql via des liens dans Zend Framework","author":{"@id":"https:\/\/grummfy.be\/blog\/author\/admin#author"},"publisher":{"@id":"https:\/\/grummfy.be\/blog\/#organization"},"datePublished":"2010-01-10T04:23:44+02:00","dateModified":"2010-01-10T15:47:17+02:00","inLanguage":"fr-BE","commentCount":8,"mainEntityOfPage":{"@id":"https:\/\/grummfy.be\/blog\/222#webpage"},"isPartOf":{"@id":"https:\/\/grummfy.be\/blog\/222#webpage"},"articleSection":"D\u00e9veloppement, PHP, Projet, PHP, programmation, ZF"},{"@type":"BreadcrumbList","@id":"https:\/\/grummfy.be\/blog\/222#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/grummfy.be\/blog#listItem","position":1,"name":"Accueil","item":"https:\/\/grummfy.be\/blog","nextItem":{"@type":"ListItem","@id":"https:\/\/grummfy.be\/blog\/cat\/projet#listItem","name":"Projet"}},{"@type":"ListItem","@id":"https:\/\/grummfy.be\/blog\/cat\/projet#listItem","position":2,"name":"Projet","item":"https:\/\/grummfy.be\/blog\/cat\/projet","nextItem":{"@type":"ListItem","@id":"https:\/\/grummfy.be\/blog\/222#listItem","name":"Tri de listing sql via des liens dans Zend Framework"},"previousItem":{"@type":"ListItem","@id":"https:\/\/grummfy.be\/blog#listItem","name":"Accueil"}},{"@type":"ListItem","@id":"https:\/\/grummfy.be\/blog\/222#listItem","position":3,"name":"Tri de listing sql via des liens dans Zend Framework","previousItem":{"@type":"ListItem","@id":"https:\/\/grummfy.be\/blog\/cat\/projet#listItem","name":"Projet"}}]},{"@type":"Organization","@id":"https:\/\/grummfy.be\/blog\/#organization","name":"Grummfy's project","description":"Mes projets, mes r\u00eaves, mes envies, ...","url":"https:\/\/grummfy.be\/blog\/"},{"@type":"Person","@id":"https:\/\/grummfy.be\/blog\/author\/admin#author","url":"https:\/\/grummfy.be\/blog\/author\/admin","name":"Grummfy","image":{"@type":"ImageObject","@id":"https:\/\/grummfy.be\/blog\/222#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/97f073e7de2fb1e9d5c5329eb7db2c6de1c5a80e8cfe9b1233473f78a1c908f6?s=96&d=identicon&r=g","width":96,"height":96,"caption":"Grummfy"}},{"@type":"WebPage","@id":"https:\/\/grummfy.be\/blog\/222#webpage","url":"https:\/\/grummfy.be\/blog\/222","name":"Grummfy's project .:. Tri de listing sql via des liens dans Zend Framework","description":"Dans la plupart des cas lorsque l'on affiche un listing provenant d'une requ\u00eate sql on aimerait pouvoir offrir le tri \u00e0 l'utilisateur. Dans l'article qui suit, je vous propose de d\u00e9couvrir une mani\u00e8re de le faire assez facilement.","inLanguage":"fr-BE","isPartOf":{"@id":"https:\/\/grummfy.be\/blog\/#website"},"breadcrumb":{"@id":"https:\/\/grummfy.be\/blog\/222#breadcrumblist"},"author":{"@id":"https:\/\/grummfy.be\/blog\/author\/admin#author"},"creator":{"@id":"https:\/\/grummfy.be\/blog\/author\/admin#author"},"datePublished":"2010-01-10T04:23:44+02:00","dateModified":"2010-01-10T15:47:17+02:00"},{"@type":"WebSite","@id":"https:\/\/grummfy.be\/blog\/#website","url":"https:\/\/grummfy.be\/blog\/","name":"Grummfy's project","description":"Mes projets, mes r\u00eaves, mes envies, ...","inLanguage":"fr-BE","publisher":{"@id":"https:\/\/grummfy.be\/blog\/#organization"}}]},"og:locale":"fr_FR","og:site_name":"Grummfy's project","og:type":"article","og:title":"Grummfy's project .:. Tri de listing sql via des liens dans Zend Framework","og:description":"Dans la plupart des cas lorsque l'on affiche un listing provenant d'une requ\u00eate sql on aimerait pouvoir offrir le tri \u00e0 l'utilisateur. Dans l'article qui suit, je vous propose de d\u00e9couvrir une mani\u00e8re de le faire assez facilement.","og:url":"https:\/\/grummfy.be\/blog\/222","fb:admins":"580961199","article:tag":["zend framework","zf","framework","php","tutoriel","tutorial","tutoriaux","tri","order","table","sql","programmation","d\u00e9veloppement","projet"],"article:published_time":"2010-01-10T02:23:44+00:00","article:modified_time":"2010-01-10T13:47:17+00:00","twitter:card":"summary","twitter:site":"@Grummfy","twitter:title":"Grummfy's project .:. Tri de listing sql via des liens dans Zend Framework","twitter:description":"Dans la plupart des cas lorsque l'on affiche un listing provenant d'une requ\u00eate sql on aimerait pouvoir offrir le tri \u00e0 l'utilisateur. Dans l'article qui suit, je vous propose de d\u00e9couvrir une mani\u00e8re de le faire assez facilement."},"aioseo_meta_data":{"post_id":"222","title":"#site_title .:. Tri de listing sql via des liens dans Zend Framework","description":"Dans la plupart des cas lorsque l'on affiche un listing provenant d'une requ\u00eate sql on aimerait pouvoir offrir le tri \u00e0 l'utilisateur. Dans l'article qui suit, je vous propose de d\u00e9couvrir une mani\u00e8re de le faire assez facilement.","keywords":[{"label":"Zend Framework","value":"Zend Framework"},{"label":"ZF","value":"ZF"},{"label":"zf","value":"zf"},{"label":"framework","value":"framework"},{"label":"php","value":"php"},{"label":"tutoriel","value":"tutoriel"},{"label":"tutorial","value":"tutorial"},{"label":"tutoriaux","value":"tutoriaux"},{"label":"tri","value":"tri"},{"label":"order","value":"order"},{"label":"table","value":"table"},{"label":"sql","value":"sql"}],"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[],"defaultGraph":"","defaultPostTypeGraph":""},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"location":null,"local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2021-01-21 15:11:40","updated":"2025-06-04 00:22:56","seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/grummfy.be\/blog\" title=\"Accueil\">Accueil<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/grummfy.be\/blog\/cat\/projet\" title=\"Projet\">Projet<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tTri de listing sql via des liens dans Zend Framework\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Accueil","link":"https:\/\/grummfy.be\/blog"},{"label":"Projet","link":"https:\/\/grummfy.be\/blog\/cat\/projet"},{"label":"Tri de listing sql via des liens dans Zend Framework","link":"https:\/\/grummfy.be\/blog\/222"}],"_links":{"self":[{"href":"https:\/\/grummfy.be\/blog\/wp-json\/wp\/v2\/posts\/222","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/grummfy.be\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/grummfy.be\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/grummfy.be\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/grummfy.be\/blog\/wp-json\/wp\/v2\/comments?post=222"}],"version-history":[{"count":4,"href":"https:\/\/grummfy.be\/blog\/wp-json\/wp\/v2\/posts\/222\/revisions"}],"predecessor-version":[{"id":228,"href":"https:\/\/grummfy.be\/blog\/wp-json\/wp\/v2\/posts\/222\/revisions\/228"}],"wp:attachment":[{"href":"https:\/\/grummfy.be\/blog\/wp-json\/wp\/v2\/media?parent=222"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/grummfy.be\/blog\/wp-json\/wp\/v2\/categories?post=222"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/grummfy.be\/blog\/wp-json\/wp\/v2\/tags?post=222"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}