{"id":329,"date":"2014-02-11T19:10:18","date_gmt":"2014-02-11T18:10:18","guid":{"rendered":"http:\/\/louis.hatier.me\/blog\/?p=329"},"modified":"2015-08-12T17:38:06","modified_gmt":"2015-08-12T16:38:06","slug":"requete-imbriquee-zend-framework","status":"publish","type":"post","link":"https:\/\/louis.hatier.me\/blog\/requete-imbriquee-zend-framework\/","title":{"rendered":"Requ\u00eate imbriqu\u00e9e avec Zend Framework"},"content":{"rendered":"<p><a title=\"\" href=\"http:\/\/louis.hatier.me\/blog\/wp-content\/uploads\/2014\/02\/logo-zend-framework.jpg\" data-rel=\"lightbox-gallery-gvXvToGb\" data-rl_title=\"\" data-rl_caption=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-315 alignleft\" title=\"Logo Zend Framework\" src=\"http:\/\/louis.hatier.me\/blog\/wp-content\/uploads\/2014\/02\/logo-zend-framework.jpg\" alt=\"Logo Zend Framework\" width=\"237\" height=\"55\" \/><\/a>Voici un exemple simple d&rsquo;une requ\u00eate imbriqu\u00e9e avec Zend Framework.<\/p>\n<p>Dans cet exemple, on cherche les commentaires dont les noms d&rsquo;utilisateurs commencent par \u00ab\u00a0J\u00a0\u00bb.<\/p>\n<p><!--more--><\/p>\n<pre><code class=\"php\">\/**\r\n * Retourne des commentaires\r\n * \r\n * @return Zend_Db_Table_Rowset\r\n *\/\r\npublic function getCommentaires()\r\n{\r\n    $tableUtilisateur = new Table_Utilisateur();\r\n    $subSelect = new Zend_Db_Expr(\r\n       $tableUtilisateur-&gt;select()\r\n                        -&gt;from($tableUtilisateur-&gt;info(self::NAME), array('idUtilisateur'))\r\n                        -&gt;where('nom LIKE ?', 'J%')\r\n    );\r\n\r\n    $select = $this-&gt;select()\r\n                   -&gt;from($this-&gt;_name, array('contenu'))\r\n                   -&gt;where('idUtilisateur IN(?)', $subSelect)\r\n                   -&gt;order('date DESC');\r\n\r\n    return $this-&gt;fetchAll($select);\r\n}\r\n<\/code><\/pre>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_counters\" href=\"https:\/\/www.hupso.com\/share\/\"><img decoding=\"async\" src=\"https:\/\/static.hupso.com\/share\/buttons\/dot.png\" style=\"border:0px; padding-top:2px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_c=new Array(\"twitter\",\"facebook_like\",\"pinterest\",\"email\",\"linkedin\");var hupso_counters_lang = \"en_US\";var hupso_image_folder_url = \"\";var hupso_url_c=\"\";var hupso_title_c=\"Requ%C3%AAte%20imbriqu%C3%A9e%20avec%20Zend%20Framework\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"excerpt":{"rendered":"<p>Voici un exemple simple d&rsquo;une requ\u00eate imbriqu\u00e9e avec Zend Framework. Dans cet exemple, on cherche les commentaires dont les noms d&rsquo;utilisateurs commencent par \u00ab\u00a0J\u00a0\u00bb.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[57,17],"class_list":["post-329","post","type-post","status-publish","format-standard","hentry","category-php","tag-php","tag-zend"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Requ\u00eate imbriqu\u00e9e avec Zend Framework - Melting Poutre<\/title>\n<meta name=\"description\" content=\"Exemple simple d&#039;une requ\u00eate imbriqu\u00e9e avec Zend Framework\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/louis.hatier.me\/blog\/requete-imbriquee-zend-framework\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Requ\u00eate imbriqu\u00e9e avec Zend Framework - Melting Poutre\" \/>\n<meta property=\"og:description\" content=\"Exemple simple d&#039;une requ\u00eate imbriqu\u00e9e avec Zend Framework\" \/>\n<meta property=\"og:url\" content=\"https:\/\/louis.hatier.me\/blog\/requete-imbriquee-zend-framework\/\" \/>\n<meta property=\"og:site_name\" content=\"Melting Poutre\" \/>\n<meta property=\"article:published_time\" content=\"2014-02-11T18:10:18+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2015-08-12T16:38:06+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/louis.hatier.me\/blog\/wp-content\/uploads\/2014\/02\/logo-zend-framework.jpg\" \/>\n<meta name=\"author\" content=\"Louis Hatier\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Louis Hatier\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/louis.hatier.me\/blog\/requete-imbriquee-zend-framework\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/louis.hatier.me\/blog\/requete-imbriquee-zend-framework\/\"},\"author\":{\"name\":\"Louis Hatier\",\"@id\":\"https:\/\/louis.hatier.me\/blog\/#\/schema\/person\/2f200d0368def135b452e65491c4dd11\"},\"headline\":\"Requ\u00eate imbriqu\u00e9e avec Zend Framework\",\"datePublished\":\"2014-02-11T18:10:18+00:00\",\"dateModified\":\"2015-08-12T16:38:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/louis.hatier.me\/blog\/requete-imbriquee-zend-framework\/\"},\"wordCount\":33,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/louis.hatier.me\/blog\/#\/schema\/person\/2f200d0368def135b452e65491c4dd11\"},\"image\":{\"@id\":\"https:\/\/louis.hatier.me\/blog\/requete-imbriquee-zend-framework\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/louis.hatier.me\/blog\/wp-content\/uploads\/2014\/02\/logo-zend-framework.jpg\",\"keywords\":[\"PHP\",\"Zend\"],\"articleSection\":[\"PHP\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/louis.hatier.me\/blog\/requete-imbriquee-zend-framework\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/louis.hatier.me\/blog\/requete-imbriquee-zend-framework\/\",\"url\":\"https:\/\/louis.hatier.me\/blog\/requete-imbriquee-zend-framework\/\",\"name\":\"Requ\u00eate imbriqu\u00e9e avec Zend Framework - Melting Poutre\",\"isPartOf\":{\"@id\":\"https:\/\/louis.hatier.me\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/louis.hatier.me\/blog\/requete-imbriquee-zend-framework\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/louis.hatier.me\/blog\/requete-imbriquee-zend-framework\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/louis.hatier.me\/blog\/wp-content\/uploads\/2014\/02\/logo-zend-framework.jpg\",\"datePublished\":\"2014-02-11T18:10:18+00:00\",\"dateModified\":\"2015-08-12T16:38:06+00:00\",\"description\":\"Exemple simple d'une requ\u00eate imbriqu\u00e9e avec Zend Framework\",\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/louis.hatier.me\/blog\/requete-imbriquee-zend-framework\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/louis.hatier.me\/blog\/requete-imbriquee-zend-framework\/#primaryimage\",\"url\":\"http:\/\/louis.hatier.me\/blog\/wp-content\/uploads\/2014\/02\/logo-zend-framework.jpg\",\"contentUrl\":\"http:\/\/louis.hatier.me\/blog\/wp-content\/uploads\/2014\/02\/logo-zend-framework.jpg\"},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/louis.hatier.me\/blog\/#website\",\"url\":\"https:\/\/louis.hatier.me\/blog\/\",\"name\":\"Melting Poutre\",\"description\":\"Du web et d&#039;autres choses\",\"publisher\":{\"@id\":\"https:\/\/louis.hatier.me\/blog\/#\/schema\/person\/2f200d0368def135b452e65491c4dd11\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/louis.hatier.me\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/louis.hatier.me\/blog\/#\/schema\/person\/2f200d0368def135b452e65491c4dd11\",\"name\":\"Louis Hatier\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/louis.hatier.me\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/cd8d107ede5a4ec340326655e74a00ca62b02e41a02442f961c36f085aa89942?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/cd8d107ede5a4ec340326655e74a00ca62b02e41a02442f961c36f085aa89942?s=96&d=mm&r=g\",\"caption\":\"Louis Hatier\"},\"logo\":{\"@id\":\"https:\/\/louis.hatier.me\/blog\/#\/schema\/person\/image\/\"},\"sameAs\":[\"https:\/\/louis.hatier.me\",\"https:\/\/www.linkedin.com\/in\/louishatier\/\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Requ\u00eate imbriqu\u00e9e avec Zend Framework - Melting Poutre","description":"Exemple simple d'une requ\u00eate imbriqu\u00e9e avec Zend Framework","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/louis.hatier.me\/blog\/requete-imbriquee-zend-framework\/","og_locale":"fr_FR","og_type":"article","og_title":"Requ\u00eate imbriqu\u00e9e avec Zend Framework - Melting Poutre","og_description":"Exemple simple d'une requ\u00eate imbriqu\u00e9e avec Zend Framework","og_url":"https:\/\/louis.hatier.me\/blog\/requete-imbriquee-zend-framework\/","og_site_name":"Melting Poutre","article_published_time":"2014-02-11T18:10:18+00:00","article_modified_time":"2015-08-12T16:38:06+00:00","og_image":[{"url":"http:\/\/louis.hatier.me\/blog\/wp-content\/uploads\/2014\/02\/logo-zend-framework.jpg","type":"","width":"","height":""}],"author":"Louis Hatier","twitter_misc":{"\u00c9crit par":"Louis Hatier"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/louis.hatier.me\/blog\/requete-imbriquee-zend-framework\/#article","isPartOf":{"@id":"https:\/\/louis.hatier.me\/blog\/requete-imbriquee-zend-framework\/"},"author":{"name":"Louis Hatier","@id":"https:\/\/louis.hatier.me\/blog\/#\/schema\/person\/2f200d0368def135b452e65491c4dd11"},"headline":"Requ\u00eate imbriqu\u00e9e avec Zend Framework","datePublished":"2014-02-11T18:10:18+00:00","dateModified":"2015-08-12T16:38:06+00:00","mainEntityOfPage":{"@id":"https:\/\/louis.hatier.me\/blog\/requete-imbriquee-zend-framework\/"},"wordCount":33,"commentCount":0,"publisher":{"@id":"https:\/\/louis.hatier.me\/blog\/#\/schema\/person\/2f200d0368def135b452e65491c4dd11"},"image":{"@id":"https:\/\/louis.hatier.me\/blog\/requete-imbriquee-zend-framework\/#primaryimage"},"thumbnailUrl":"http:\/\/louis.hatier.me\/blog\/wp-content\/uploads\/2014\/02\/logo-zend-framework.jpg","keywords":["PHP","Zend"],"articleSection":["PHP"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/louis.hatier.me\/blog\/requete-imbriquee-zend-framework\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/louis.hatier.me\/blog\/requete-imbriquee-zend-framework\/","url":"https:\/\/louis.hatier.me\/blog\/requete-imbriquee-zend-framework\/","name":"Requ\u00eate imbriqu\u00e9e avec Zend Framework - Melting Poutre","isPartOf":{"@id":"https:\/\/louis.hatier.me\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/louis.hatier.me\/blog\/requete-imbriquee-zend-framework\/#primaryimage"},"image":{"@id":"https:\/\/louis.hatier.me\/blog\/requete-imbriquee-zend-framework\/#primaryimage"},"thumbnailUrl":"http:\/\/louis.hatier.me\/blog\/wp-content\/uploads\/2014\/02\/logo-zend-framework.jpg","datePublished":"2014-02-11T18:10:18+00:00","dateModified":"2015-08-12T16:38:06+00:00","description":"Exemple simple d'une requ\u00eate imbriqu\u00e9e avec Zend Framework","inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/louis.hatier.me\/blog\/requete-imbriquee-zend-framework\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/louis.hatier.me\/blog\/requete-imbriquee-zend-framework\/#primaryimage","url":"http:\/\/louis.hatier.me\/blog\/wp-content\/uploads\/2014\/02\/logo-zend-framework.jpg","contentUrl":"http:\/\/louis.hatier.me\/blog\/wp-content\/uploads\/2014\/02\/logo-zend-framework.jpg"},{"@type":"WebSite","@id":"https:\/\/louis.hatier.me\/blog\/#website","url":"https:\/\/louis.hatier.me\/blog\/","name":"Melting Poutre","description":"Du web et d&#039;autres choses","publisher":{"@id":"https:\/\/louis.hatier.me\/blog\/#\/schema\/person\/2f200d0368def135b452e65491c4dd11"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/louis.hatier.me\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":["Person","Organization"],"@id":"https:\/\/louis.hatier.me\/blog\/#\/schema\/person\/2f200d0368def135b452e65491c4dd11","name":"Louis Hatier","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/louis.hatier.me\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/cd8d107ede5a4ec340326655e74a00ca62b02e41a02442f961c36f085aa89942?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/cd8d107ede5a4ec340326655e74a00ca62b02e41a02442f961c36f085aa89942?s=96&d=mm&r=g","caption":"Louis Hatier"},"logo":{"@id":"https:\/\/louis.hatier.me\/blog\/#\/schema\/person\/image\/"},"sameAs":["https:\/\/louis.hatier.me","https:\/\/www.linkedin.com\/in\/louishatier\/"]}]}},"_links":{"self":[{"href":"https:\/\/louis.hatier.me\/blog\/wp-json\/wp\/v2\/posts\/329","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/louis.hatier.me\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/louis.hatier.me\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/louis.hatier.me\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/louis.hatier.me\/blog\/wp-json\/wp\/v2\/comments?post=329"}],"version-history":[{"count":6,"href":"https:\/\/louis.hatier.me\/blog\/wp-json\/wp\/v2\/posts\/329\/revisions"}],"predecessor-version":[{"id":468,"href":"https:\/\/louis.hatier.me\/blog\/wp-json\/wp\/v2\/posts\/329\/revisions\/468"}],"wp:attachment":[{"href":"https:\/\/louis.hatier.me\/blog\/wp-json\/wp\/v2\/media?parent=329"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/louis.hatier.me\/blog\/wp-json\/wp\/v2\/categories?post=329"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/louis.hatier.me\/blog\/wp-json\/wp\/v2\/tags?post=329"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}