{"id":1538,"date":"2012-01-27T14:40:33","date_gmt":"2012-01-27T14:40:33","guid":{"rendered":"https:\/\/www.jose-aguilar.com\/blog\/?p=1538"},"modified":"2019-11-07T11:52:27","modified_gmt":"2019-11-07T11:52:27","slug":"buscador-con-letras-del-abecedario-con-consultas-a-base-de-datos","status":"publish","type":"post","link":"https:\/\/www.jose-aguilar.com\/blog\/buscador-con-letras-del-abecedario-con-consultas-a-base-de-datos\/","title":{"rendered":"Buscador con letras del abecedario con consultas a base de datos"},"content":{"rendered":"<p>En este art\u00edculo vas a descubrir como crear un buscador con letras del abecedario con consultas a una base de datos.<\/p>\n<p>En muchas p\u00e1ginas webs, sobretodo, en las que contienen muchos registros es necesario tener varios sistemas de b\u00fasqueda para que los usuarios lleguen a los art\u00edculos o productos que desean encontrar de forma r\u00e1pida y f\u00e1cil.<\/p>\n<p>Un ejemplo claro son la infinidad de p\u00e1ginas web que presentan libros o pel\u00edculas donde si ya sabemos previamente como se llama el libro o pel\u00edcula podemos acceder a la letra por la que comience.<\/p>\n<p>Estoy hablando de presentar al usuario un abecedario con sus letras y poder pulsar en una de ellas para ver los art\u00edculos que comiencen por dicha letra.<\/p>\n<p><a href=\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/01\/abc.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1544 size-full\" title=\"Buscador por letras del abecedario con PHP\" src=\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/01\/abc.png\" alt=\"Buscador por letras del abecedario con PHP\" width=\"734\" height=\"334\" srcset=\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/01\/abc.png 734w, https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/01\/abc-300x136.png 300w\" sizes=\"auto, (max-width: 734px) 100vw, 734px\" \/><\/a><\/p>\n<p>Implementar esta idea no es nada dif\u00edcil utilizando <strong>HTML<\/strong>, <strong>PHP<\/strong> y <strong>MySQL<\/strong>.<\/p>\n<p>En el el cuerpo de la p\u00e1gina o dentro de la etiqueta &lt;body&gt;, all\u00ed donde desees puedes agregar el c\u00f3digo de marcado para presentar las letras del abecedario mediante enlaces. Por ejemplo:<\/p>\n<div id=\"wpshdo_1\" class=\"wp-synhighlighter-outer\"><div id=\"wpshdt_1\" class=\"wp-synhighlighter-expanded\"><table border=\"0\" width=\"100%\"><tr><td align=\"left\" width=\"80%\"><a name=\"#codesyntax_1\"><\/a><a id=\"wpshat_1\" class=\"wp-synhighlighter-title\" href=\"#codesyntax_1\"  onClick=\"javascript:wpsh_toggleBlock(1)\" title=\"Click to show\/hide code block\">Source code<\/a><\/td><td align=\"right\"><a href=\"#codesyntax_1\" onClick=\"javascript:wpsh_code(1)\" title=\"Show code only\"><img decoding=\"async\" border=\"0\" style=\"border: 0 none\" src=\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/plugins\/wp-synhighlight\/themes\/default\/images\/code.png\" \/><\/a>&nbsp;<a href=\"#codesyntax_1\" onClick=\"javascript:wpsh_print(1)\" title=\"Print code\"><img decoding=\"async\" border=\"0\" style=\"border: 0 none\" src=\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/plugins\/wp-synhighlight\/themes\/default\/images\/printer.png\" \/><\/a>&nbsp;<a href=\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/plugins\/wp-synhighlight\/About.html\" target=\"_blank\" title=\"Show plugin information\"><img decoding=\"async\" border=\"0\" style=\"border: 0 none\" src=\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/plugins\/wp-synhighlight\/themes\/default\/images\/info.gif\" \/><\/a>&nbsp;<\/td><\/tr><\/table><\/div><div id=\"wpshdi_1\" class=\"wp-synhighlighter-inner\" style=\"display: block;\"><pre class=\"html4strict\" style=\"font-family:monospace;\"><span class=\"sc2\">&lt;<a href=\"http:\/\/december.com\/html\/4\/element\/div.html\"><span class=\"kw2\">div<\/span><\/a> <span class=\"kw3\">id<\/span><span class=\"sy0\">=<\/span><span class=\"st0\">&quot;alfabeto&quot;<\/span>&gt;<\/span> \n    <span class=\"sc2\">&lt;<a href=\"http:\/\/december.com\/html\/4\/element\/ul.html\"><span class=\"kw2\">ul<\/span><\/a> <span class=\"kw3\">class<\/span><span class=\"sy0\">=<\/span><span class=\"st0\">&quot;dictionary&quot;<\/span> <span class=\"kw3\">id<\/span><span class=\"sy0\">=<\/span><span class=\"st0\">&quot;filters&quot;<\/span>&gt;<\/span>\n        <span class=\"sc2\">&lt;<a href=\"http:\/\/december.com\/html\/4\/element\/li.html\"><span class=\"kw2\">li<\/span><\/a>&gt;&lt;<a href=\"http:\/\/december.com\/html\/4\/element\/a.html\"><span class=\"kw2\">a<\/span><\/a> <span class=\"kw3\">href<\/span><span class=\"sy0\">=<\/span><span class=\"st0\">&quot;index.php?letra=a&quot;<\/span>&gt;<\/span>A<span class=\"sc2\">&lt;<span class=\"sy0\">\/<\/span><a href=\"http:\/\/december.com\/html\/4\/element\/a.html\"><span class=\"kw2\">a<\/span><\/a>&gt;&lt;<span class=\"sy0\">\/<\/span><a href=\"http:\/\/december.com\/html\/4\/element\/li.html\"><span class=\"kw2\">li<\/span><\/a>&gt;<\/span> \n        <span class=\"sc2\">&lt;<a href=\"http:\/\/december.com\/html\/4\/element\/li.html\"><span class=\"kw2\">li<\/span><\/a>&gt;&lt;<a href=\"http:\/\/december.com\/html\/4\/element\/a.html\"><span class=\"kw2\">a<\/span><\/a> <span class=\"kw3\">href<\/span><span class=\"sy0\">=<\/span><span class=\"st0\">&quot;index.php?letra=b&quot;<\/span>&gt;<\/span>B<span class=\"sc2\">&lt;<span class=\"sy0\">\/<\/span><a href=\"http:\/\/december.com\/html\/4\/element\/a.html\"><span class=\"kw2\">a<\/span><\/a>&gt;&lt;<span class=\"sy0\">\/<\/span><a href=\"http:\/\/december.com\/html\/4\/element\/li.html\"><span class=\"kw2\">li<\/span><\/a>&gt;<\/span> \n        <span class=\"sc2\">&lt;<a href=\"http:\/\/december.com\/html\/4\/element\/li.html\"><span class=\"kw2\">li<\/span><\/a>&gt;&lt;<a href=\"http:\/\/december.com\/html\/4\/element\/a.html\"><span class=\"kw2\">a<\/span><\/a> <span class=\"kw3\">href<\/span><span class=\"sy0\">=<\/span><span class=\"st0\">&quot;index.php?letra=c&quot;<\/span>&gt;<\/span>C<span class=\"sc2\">&lt;<span class=\"sy0\">\/<\/span><a href=\"http:\/\/december.com\/html\/4\/element\/a.html\"><span class=\"kw2\">a<\/span><\/a>&gt;&lt;<span class=\"sy0\">\/<\/span><a href=\"http:\/\/december.com\/html\/4\/element\/li.html\"><span class=\"kw2\">li<\/span><\/a>&gt;<\/span> \n        <span class=\"sc2\">&lt;<a href=\"http:\/\/december.com\/html\/4\/element\/li.html\"><span class=\"kw2\">li<\/span><\/a>&gt;&lt;<a href=\"http:\/\/december.com\/html\/4\/element\/a.html\"><span class=\"kw2\">a<\/span><\/a> <span class=\"kw3\">href<\/span><span class=\"sy0\">=<\/span><span class=\"st0\">&quot;index.php?letra=d&quot;<\/span>&gt;<\/span>D<span class=\"sc2\">&lt;<span class=\"sy0\">\/<\/span><a href=\"http:\/\/december.com\/html\/4\/element\/a.html\"><span class=\"kw2\">a<\/span><\/a>&gt;&lt;<span class=\"sy0\">\/<\/span><a href=\"http:\/\/december.com\/html\/4\/element\/li.html\"><span class=\"kw2\">li<\/span><\/a>&gt;<\/span> \n        <span class=\"sc2\">&lt;<a href=\"http:\/\/december.com\/html\/4\/element\/li.html\"><span class=\"kw2\">li<\/span><\/a>&gt;&lt;<a href=\"http:\/\/december.com\/html\/4\/element\/a.html\"><span class=\"kw2\">a<\/span><\/a> <span class=\"kw3\">href<\/span><span class=\"sy0\">=<\/span><span class=\"st0\">&quot;index.php?letra=e&quot;<\/span>&gt;<\/span>E<span class=\"sc2\">&lt;<span class=\"sy0\">\/<\/span><a href=\"http:\/\/december.com\/html\/4\/element\/a.html\"><span class=\"kw2\">a<\/span><\/a>&gt;&lt;<span class=\"sy0\">\/<\/span><a href=\"http:\/\/december.com\/html\/4\/element\/li.html\"><span class=\"kw2\">li<\/span><\/a>&gt;<\/span> \n        <span class=\"sc2\">&lt;<a href=\"http:\/\/december.com\/html\/4\/element\/li.html\"><span class=\"kw2\">li<\/span><\/a>&gt;&lt;<a href=\"http:\/\/december.com\/html\/4\/element\/a.html\"><span class=\"kw2\">a<\/span><\/a> <span class=\"kw3\">href<\/span><span class=\"sy0\">=<\/span><span class=\"st0\">&quot;index.php?letra=f&quot;<\/span>&gt;<\/span>F<span class=\"sc2\">&lt;<span class=\"sy0\">\/<\/span><a href=\"http:\/\/december.com\/html\/4\/element\/a.html\"><span class=\"kw2\">a<\/span><\/a>&gt;&lt;<span class=\"sy0\">\/<\/span><a href=\"http:\/\/december.com\/html\/4\/element\/li.html\"><span class=\"kw2\">li<\/span><\/a>&gt;<\/span> \n        <span class=\"sc2\">&lt;<a href=\"http:\/\/december.com\/html\/4\/element\/li.html\"><span class=\"kw2\">li<\/span><\/a>&gt;&lt;<a href=\"http:\/\/december.com\/html\/4\/element\/a.html\"><span class=\"kw2\">a<\/span><\/a> <span class=\"kw3\">href<\/span><span class=\"sy0\">=<\/span><span class=\"st0\">&quot;index.php?letra=g&quot;<\/span>&gt;<\/span>G<span class=\"sc2\">&lt;<span class=\"sy0\">\/<\/span><a href=\"http:\/\/december.com\/html\/4\/element\/a.html\"><span class=\"kw2\">a<\/span><\/a>&gt;&lt;<span class=\"sy0\">\/<\/span><a href=\"http:\/\/december.com\/html\/4\/element\/li.html\"><span class=\"kw2\">li<\/span><\/a>&gt;<\/span> \n        <span class=\"sc2\">&lt;<a href=\"http:\/\/december.com\/html\/4\/element\/li.html\"><span class=\"kw2\">li<\/span><\/a>&gt;&lt;<a href=\"http:\/\/december.com\/html\/4\/element\/a.html\"><span class=\"kw2\">a<\/span><\/a> <span class=\"kw3\">href<\/span><span class=\"sy0\">=<\/span><span class=\"st0\">&quot;index.php?letra=h&quot;<\/span>&gt;<\/span>H<span class=\"sc2\">&lt;<span class=\"sy0\">\/<\/span><a href=\"http:\/\/december.com\/html\/4\/element\/a.html\"><span class=\"kw2\">a<\/span><\/a>&gt;&lt;<span class=\"sy0\">\/<\/span><a href=\"http:\/\/december.com\/html\/4\/element\/li.html\"><span class=\"kw2\">li<\/span><\/a>&gt;<\/span> \n        <span class=\"sc2\">&lt;<a href=\"http:\/\/december.com\/html\/4\/element\/li.html\"><span class=\"kw2\">li<\/span><\/a>&gt;&lt;<a href=\"http:\/\/december.com\/html\/4\/element\/a.html\"><span class=\"kw2\">a<\/span><\/a> <span class=\"kw3\">href<\/span><span class=\"sy0\">=<\/span><span class=\"st0\">&quot;index.php?letra=i&quot;<\/span>&gt;<\/span>I<span class=\"sc2\">&lt;<span class=\"sy0\">\/<\/span><a href=\"http:\/\/december.com\/html\/4\/element\/a.html\"><span class=\"kw2\">a<\/span><\/a>&gt;&lt;<span class=\"sy0\">\/<\/span><a href=\"http:\/\/december.com\/html\/4\/element\/li.html\"><span class=\"kw2\">li<\/span><\/a>&gt;<\/span> \n        <span class=\"sc2\">&lt;<a href=\"http:\/\/december.com\/html\/4\/element\/li.html\"><span class=\"kw2\">li<\/span><\/a>&gt;&lt;<a href=\"http:\/\/december.com\/html\/4\/element\/a.html\"><span class=\"kw2\">a<\/span><\/a> <span class=\"kw3\">href<\/span><span class=\"sy0\">=<\/span><span class=\"st0\">&quot;index.php?letra=j&quot;<\/span>&gt;<\/span>J<span class=\"sc2\">&lt;<span class=\"sy0\">\/<\/span><a href=\"http:\/\/december.com\/html\/4\/element\/a.html\"><span class=\"kw2\">a<\/span><\/a>&gt;&lt;<span class=\"sy0\">\/<\/span><a href=\"http:\/\/december.com\/html\/4\/element\/li.html\"><span class=\"kw2\">li<\/span><\/a>&gt;<\/span> \n        <span class=\"sc2\">&lt;<a href=\"http:\/\/december.com\/html\/4\/element\/li.html\"><span class=\"kw2\">li<\/span><\/a>&gt;&lt;<a href=\"http:\/\/december.com\/html\/4\/element\/a.html\"><span class=\"kw2\">a<\/span><\/a> <span class=\"kw3\">href<\/span><span class=\"sy0\">=<\/span><span class=\"st0\">&quot;index.php?letra=k&quot;<\/span>&gt;<\/span>K<span class=\"sc2\">&lt;<span class=\"sy0\">\/<\/span><a href=\"http:\/\/december.com\/html\/4\/element\/a.html\"><span class=\"kw2\">a<\/span><\/a>&gt;&lt;<span class=\"sy0\">\/<\/span><a href=\"http:\/\/december.com\/html\/4\/element\/li.html\"><span class=\"kw2\">li<\/span><\/a>&gt;<\/span> \n        <span class=\"sc2\">&lt;<a href=\"http:\/\/december.com\/html\/4\/element\/li.html\"><span class=\"kw2\">li<\/span><\/a>&gt;&lt;<a href=\"http:\/\/december.com\/html\/4\/element\/a.html\"><span class=\"kw2\">a<\/span><\/a> <span class=\"kw3\">href<\/span><span class=\"sy0\">=<\/span><span class=\"st0\">&quot;index.php?letra=l&quot;<\/span>&gt;<\/span>L<span class=\"sc2\">&lt;<span class=\"sy0\">\/<\/span><a href=\"http:\/\/december.com\/html\/4\/element\/a.html\"><span class=\"kw2\">a<\/span><\/a>&gt;&lt;<span class=\"sy0\">\/<\/span><a href=\"http:\/\/december.com\/html\/4\/element\/li.html\"><span class=\"kw2\">li<\/span><\/a>&gt;<\/span> \n        <span class=\"sc2\">&lt;<a href=\"http:\/\/december.com\/html\/4\/element\/li.html\"><span class=\"kw2\">li<\/span><\/a>&gt;&lt;<a href=\"http:\/\/december.com\/html\/4\/element\/a.html\"><span class=\"kw2\">a<\/span><\/a> <span class=\"kw3\">href<\/span><span class=\"sy0\">=<\/span><span class=\"st0\">&quot;index.php?letra=m&quot;<\/span>&gt;<\/span>M<span class=\"sc2\">&lt;<span class=\"sy0\">\/<\/span><a href=\"http:\/\/december.com\/html\/4\/element\/a.html\"><span class=\"kw2\">a<\/span><\/a>&gt;&lt;<span class=\"sy0\">\/<\/span><a href=\"http:\/\/december.com\/html\/4\/element\/li.html\"><span class=\"kw2\">li<\/span><\/a>&gt;<\/span> \n        <span class=\"sc2\">&lt;<a href=\"http:\/\/december.com\/html\/4\/element\/li.html\"><span class=\"kw2\">li<\/span><\/a>&gt;&lt;<a href=\"http:\/\/december.com\/html\/4\/element\/a.html\"><span class=\"kw2\">a<\/span><\/a> <span class=\"kw3\">href<\/span><span class=\"sy0\">=<\/span><span class=\"st0\">&quot;index.php?letra=n&quot;<\/span>&gt;<\/span>N<span class=\"sc2\">&lt;<span class=\"sy0\">\/<\/span><a href=\"http:\/\/december.com\/html\/4\/element\/a.html\"><span class=\"kw2\">a<\/span><\/a>&gt;&lt;<span class=\"sy0\">\/<\/span><a href=\"http:\/\/december.com\/html\/4\/element\/li.html\"><span class=\"kw2\">li<\/span><\/a>&gt;<\/span> \n        <span class=\"sc2\">&lt;<a href=\"http:\/\/december.com\/html\/4\/element\/li.html\"><span class=\"kw2\">li<\/span><\/a>&gt;&lt;<a href=\"http:\/\/december.com\/html\/4\/element\/a.html\"><span class=\"kw2\">a<\/span><\/a> <span class=\"kw3\">href<\/span><span class=\"sy0\">=<\/span><span class=\"st0\">&quot;index.php?letra=o&quot;<\/span>&gt;<\/span>O<span class=\"sc2\">&lt;<span class=\"sy0\">\/<\/span><a href=\"http:\/\/december.com\/html\/4\/element\/a.html\"><span class=\"kw2\">a<\/span><\/a>&gt;&lt;<span class=\"sy0\">\/<\/span><a href=\"http:\/\/december.com\/html\/4\/element\/li.html\"><span class=\"kw2\">li<\/span><\/a>&gt;<\/span> \n        <span class=\"sc2\">&lt;<a href=\"http:\/\/december.com\/html\/4\/element\/li.html\"><span class=\"kw2\">li<\/span><\/a>&gt;&lt;<a href=\"http:\/\/december.com\/html\/4\/element\/a.html\"><span class=\"kw2\">a<\/span><\/a> <span class=\"kw3\">href<\/span><span class=\"sy0\">=<\/span><span class=\"st0\">&quot;index.php?letra=p&quot;<\/span>&gt;<\/span>P<span class=\"sc2\">&lt;<span class=\"sy0\">\/<\/span><a href=\"http:\/\/december.com\/html\/4\/element\/a.html\"><span class=\"kw2\">a<\/span><\/a>&gt;&lt;<span class=\"sy0\">\/<\/span><a href=\"http:\/\/december.com\/html\/4\/element\/li.html\"><span class=\"kw2\">li<\/span><\/a>&gt;<\/span> \n        <span class=\"sc2\">&lt;<a href=\"http:\/\/december.com\/html\/4\/element\/li.html\"><span class=\"kw2\">li<\/span><\/a>&gt;&lt;<a href=\"http:\/\/december.com\/html\/4\/element\/a.html\"><span class=\"kw2\">a<\/span><\/a> <span class=\"kw3\">href<\/span><span class=\"sy0\">=<\/span><span class=\"st0\">&quot;index.php?letra=q&quot;<\/span>&gt;<\/span>Q<span class=\"sc2\">&lt;<span class=\"sy0\">\/<\/span><a href=\"http:\/\/december.com\/html\/4\/element\/a.html\"><span class=\"kw2\">a<\/span><\/a>&gt;&lt;<span class=\"sy0\">\/<\/span><a href=\"http:\/\/december.com\/html\/4\/element\/li.html\"><span class=\"kw2\">li<\/span><\/a>&gt;<\/span> \n        <span class=\"sc2\">&lt;<a href=\"http:\/\/december.com\/html\/4\/element\/li.html\"><span class=\"kw2\">li<\/span><\/a>&gt;&lt;<a href=\"http:\/\/december.com\/html\/4\/element\/a.html\"><span class=\"kw2\">a<\/span><\/a> <span class=\"kw3\">href<\/span><span class=\"sy0\">=<\/span><span class=\"st0\">&quot;index.php?letra=r&quot;<\/span>&gt;<\/span>R<span class=\"sc2\">&lt;<span class=\"sy0\">\/<\/span><a href=\"http:\/\/december.com\/html\/4\/element\/a.html\"><span class=\"kw2\">a<\/span><\/a>&gt;&lt;<span class=\"sy0\">\/<\/span><a href=\"http:\/\/december.com\/html\/4\/element\/li.html\"><span class=\"kw2\">li<\/span><\/a>&gt;<\/span> \n        <span class=\"sc2\">&lt;<a href=\"http:\/\/december.com\/html\/4\/element\/li.html\"><span class=\"kw2\">li<\/span><\/a>&gt;&lt;<a href=\"http:\/\/december.com\/html\/4\/element\/a.html\"><span class=\"kw2\">a<\/span><\/a> <span class=\"kw3\">href<\/span><span class=\"sy0\">=<\/span><span class=\"st0\">&quot;index.php?letra=s&quot;<\/span>&gt;<\/span>S<span class=\"sc2\">&lt;<span class=\"sy0\">\/<\/span><a href=\"http:\/\/december.com\/html\/4\/element\/a.html\"><span class=\"kw2\">a<\/span><\/a>&gt;&lt;<span class=\"sy0\">\/<\/span><a href=\"http:\/\/december.com\/html\/4\/element\/li.html\"><span class=\"kw2\">li<\/span><\/a>&gt;<\/span> \n        <span class=\"sc2\">&lt;<a href=\"http:\/\/december.com\/html\/4\/element\/li.html\"><span class=\"kw2\">li<\/span><\/a>&gt;&lt;<a href=\"http:\/\/december.com\/html\/4\/element\/a.html\"><span class=\"kw2\">a<\/span><\/a> <span class=\"kw3\">href<\/span><span class=\"sy0\">=<\/span><span class=\"st0\">&quot;index.php?letra=t&quot;<\/span>&gt;<\/span>T<span class=\"sc2\">&lt;<span class=\"sy0\">\/<\/span><a href=\"http:\/\/december.com\/html\/4\/element\/a.html\"><span class=\"kw2\">a<\/span><\/a>&gt;&lt;<span class=\"sy0\">\/<\/span><a href=\"http:\/\/december.com\/html\/4\/element\/li.html\"><span class=\"kw2\">li<\/span><\/a>&gt;<\/span> \n        <span class=\"sc2\">&lt;<a href=\"http:\/\/december.com\/html\/4\/element\/li.html\"><span class=\"kw2\">li<\/span><\/a>&gt;&lt;<a href=\"http:\/\/december.com\/html\/4\/element\/a.html\"><span class=\"kw2\">a<\/span><\/a> <span class=\"kw3\">href<\/span><span class=\"sy0\">=<\/span><span class=\"st0\">&quot;index.php?letra=u&quot;<\/span>&gt;<\/span>U<span class=\"sc2\">&lt;<span class=\"sy0\">\/<\/span><a href=\"http:\/\/december.com\/html\/4\/element\/a.html\"><span class=\"kw2\">a<\/span><\/a>&gt;&lt;<span class=\"sy0\">\/<\/span><a href=\"http:\/\/december.com\/html\/4\/element\/li.html\"><span class=\"kw2\">li<\/span><\/a>&gt;<\/span> \n        <span class=\"sc2\">&lt;<a href=\"http:\/\/december.com\/html\/4\/element\/li.html\"><span class=\"kw2\">li<\/span><\/a>&gt;&lt;<a href=\"http:\/\/december.com\/html\/4\/element\/a.html\"><span class=\"kw2\">a<\/span><\/a> <span class=\"kw3\">href<\/span><span class=\"sy0\">=<\/span><span class=\"st0\">&quot;index.php?letra=v&quot;<\/span>&gt;<\/span>V<span class=\"sc2\">&lt;<span class=\"sy0\">\/<\/span><a href=\"http:\/\/december.com\/html\/4\/element\/a.html\"><span class=\"kw2\">a<\/span><\/a>&gt;&lt;<span class=\"sy0\">\/<\/span><a href=\"http:\/\/december.com\/html\/4\/element\/li.html\"><span class=\"kw2\">li<\/span><\/a>&gt;<\/span> \n        <span class=\"sc2\">&lt;<a href=\"http:\/\/december.com\/html\/4\/element\/li.html\"><span class=\"kw2\">li<\/span><\/a>&gt;&lt;<a href=\"http:\/\/december.com\/html\/4\/element\/a.html\"><span class=\"kw2\">a<\/span><\/a> <span class=\"kw3\">href<\/span><span class=\"sy0\">=<\/span><span class=\"st0\">&quot;index.php?letra=w&quot;<\/span>&gt;<\/span>W<span class=\"sc2\">&lt;<span class=\"sy0\">\/<\/span><a href=\"http:\/\/december.com\/html\/4\/element\/a.html\"><span class=\"kw2\">a<\/span><\/a>&gt;&lt;<span class=\"sy0\">\/<\/span><a href=\"http:\/\/december.com\/html\/4\/element\/li.html\"><span class=\"kw2\">li<\/span><\/a>&gt;<\/span> \n        <span class=\"sc2\">&lt;<a href=\"http:\/\/december.com\/html\/4\/element\/li.html\"><span class=\"kw2\">li<\/span><\/a>&gt;&lt;<a href=\"http:\/\/december.com\/html\/4\/element\/a.html\"><span class=\"kw2\">a<\/span><\/a> <span class=\"kw3\">href<\/span><span class=\"sy0\">=<\/span><span class=\"st0\">&quot;index.php?letra=x&quot;<\/span>&gt;<\/span>X<span class=\"sc2\">&lt;<span class=\"sy0\">\/<\/span><a href=\"http:\/\/december.com\/html\/4\/element\/a.html\"><span class=\"kw2\">a<\/span><\/a>&gt;&lt;<span class=\"sy0\">\/<\/span><a href=\"http:\/\/december.com\/html\/4\/element\/li.html\"><span class=\"kw2\">li<\/span><\/a>&gt;<\/span> \n        <span class=\"sc2\">&lt;<a href=\"http:\/\/december.com\/html\/4\/element\/li.html\"><span class=\"kw2\">li<\/span><\/a>&gt;&lt;<a href=\"http:\/\/december.com\/html\/4\/element\/a.html\"><span class=\"kw2\">a<\/span><\/a> <span class=\"kw3\">href<\/span><span class=\"sy0\">=<\/span><span class=\"st0\">&quot;index.php?letra=y&quot;<\/span>&gt;<\/span>Y<span class=\"sc2\">&lt;<span class=\"sy0\">\/<\/span><a href=\"http:\/\/december.com\/html\/4\/element\/a.html\"><span class=\"kw2\">a<\/span><\/a>&gt;&lt;<span class=\"sy0\">\/<\/span><a href=\"http:\/\/december.com\/html\/4\/element\/li.html\"><span class=\"kw2\">li<\/span><\/a>&gt;<\/span> \n        <span class=\"sc2\">&lt;<a href=\"http:\/\/december.com\/html\/4\/element\/li.html\"><span class=\"kw2\">li<\/span><\/a>&gt;&lt;<a href=\"http:\/\/december.com\/html\/4\/element\/a.html\"><span class=\"kw2\">a<\/span><\/a> <span class=\"kw3\">href<\/span><span class=\"sy0\">=<\/span><span class=\"st0\">&quot;index.php?letra=z&quot;<\/span>&gt;<\/span>Z<span class=\"sc2\">&lt;<span class=\"sy0\">\/<\/span><a href=\"http:\/\/december.com\/html\/4\/element\/a.html\"><span class=\"kw2\">a<\/span><\/a>&gt;&lt;<span class=\"sy0\">\/<\/span><a href=\"http:\/\/december.com\/html\/4\/element\/li.html\"><span class=\"kw2\">li<\/span><\/a>&gt;<\/span> \n        <span class=\"sc2\">&lt;<span class=\"sy0\">\/<\/span><a href=\"http:\/\/december.com\/html\/4\/element\/ul.html\"><span class=\"kw2\">ul<\/span><\/a>&gt;<\/span>\n<span class=\"sc2\">&lt;<span class=\"sy0\">\/<\/span><a href=\"http:\/\/december.com\/html\/4\/element\/div.html\"><span class=\"kw2\">div<\/span><\/a>&gt;<\/span><\/pre><\/div><\/div>\n<p>Si te fijas bien, en los enlaces estoy pasando la letra por par\u00e1metro GET para capturarla por <strong>PHP<\/strong> para realizar la consulta correspondiente.<\/p>\n<p>Este c\u00f3digo de marcado quiz\u00e1 se puede optimizar considerando lo que he explicado en el siguiente enlace:<\/p>\n<p><a href=\"https:\/\/www.jose-aguilar.com\/blog\/letras-del-abecedario-con-php\/\">Letras del abecedario con PHP<\/a><\/p>\n<p>El c\u00f3digo PHP que recibe la letra mediante el par\u00e1metro GET, lo puedo hacer as\u00ed:<\/p>\n<div id=\"wpshdo_2\" class=\"wp-synhighlighter-outer\"><div id=\"wpshdt_2\" class=\"wp-synhighlighter-expanded\"><table border=\"0\" width=\"100%\"><tr><td align=\"left\" width=\"80%\"><a name=\"#codesyntax_2\"><\/a><a id=\"wpshat_2\" class=\"wp-synhighlighter-title\" href=\"#codesyntax_2\"  onClick=\"javascript:wpsh_toggleBlock(2)\" title=\"Click to show\/hide code block\">Source code<\/a><\/td><td align=\"right\"><a href=\"#codesyntax_2\" onClick=\"javascript:wpsh_code(2)\" title=\"Show code only\"><img decoding=\"async\" border=\"0\" style=\"border: 0 none\" src=\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/plugins\/wp-synhighlight\/themes\/default\/images\/code.png\" \/><\/a>&nbsp;<a href=\"#codesyntax_2\" onClick=\"javascript:wpsh_print(2)\" title=\"Print code\"><img decoding=\"async\" border=\"0\" style=\"border: 0 none\" src=\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/plugins\/wp-synhighlight\/themes\/default\/images\/printer.png\" \/><\/a>&nbsp;<a href=\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/plugins\/wp-synhighlight\/About.html\" target=\"_blank\" title=\"Show plugin information\"><img decoding=\"async\" border=\"0\" style=\"border: 0 none\" src=\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/plugins\/wp-synhighlight\/themes\/default\/images\/info.gif\" \/><\/a>&nbsp;<\/td><\/tr><\/table><\/div><div id=\"wpshdi_2\" class=\"wp-synhighlighter-inner\" style=\"display: block;\"><pre class=\"php\" style=\"font-family:monospace;\"><span class=\"kw1\">if<\/span> <span class=\"br0\">&#40;<\/span><a href=\"http:\/\/www.php.net\/isset\"><span class=\"kw3\">isset<\/span><\/a><span class=\"br0\">&#40;<\/span><span class=\"re0\">$_GET<\/span><span class=\"br0\">[<\/span><span class=\"st_h\">'letra'<\/span><span class=\"br0\">]<\/span><span class=\"br0\">&#41;<\/span><span class=\"br0\">&#41;<\/span> <span class=\"br0\">&#123;<\/span>\n    <span class=\"re0\">$letra<\/span> <span class=\"sy0\">=<\/span> <a href=\"http:\/\/www.php.net\/strtoupper\"><span class=\"kw3\">strtoupper<\/span><\/a><span class=\"br0\">&#40;<\/span><span class=\"re0\">$_GET<\/span><span class=\"br0\">[<\/span><span class=\"st_h\">'letra'<\/span><span class=\"br0\">]<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">;<\/span>\n    <span class=\"co1\">\/\/tu consulta a la base de datos...<\/span>\n<span class=\"br0\">&#125;<\/span><\/pre><\/div><\/div>\n<p>Utilizo la funci\u00f3n <a href=\"https:\/\/www.php.net\/manual\/es\/function.strtoupper.php\" target=\"_blank\" rel=\"noopener noreferrer\"><em>strtoupper()<\/em><\/a> de <strong>PHP<\/strong> para convertir a may\u00fasculas por el simple motivo de que todos art\u00edculos publicados empiezan por may\u00fasculas.<\/p>\n<p>La clave del asunto es incluir en la <em>query<\/em> o consulta que retorna los registros la siguiente condici\u00f3n en el WHERE.<\/p>\n<div id=\"wpshdo_3\" class=\"wp-synhighlighter-outer\"><div id=\"wpshdt_3\" class=\"wp-synhighlighter-expanded\"><table border=\"0\" width=\"100%\"><tr><td align=\"left\" width=\"80%\"><a name=\"#codesyntax_3\"><\/a><a id=\"wpshat_3\" class=\"wp-synhighlighter-title\" href=\"#codesyntax_3\"  onClick=\"javascript:wpsh_toggleBlock(3)\" title=\"Click to show\/hide code block\">Source code<\/a><\/td><td align=\"right\"><a href=\"#codesyntax_3\" onClick=\"javascript:wpsh_code(3)\" title=\"Show code only\"><img decoding=\"async\" border=\"0\" style=\"border: 0 none\" src=\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/plugins\/wp-synhighlight\/themes\/default\/images\/code.png\" \/><\/a>&nbsp;<a href=\"#codesyntax_3\" onClick=\"javascript:wpsh_print(3)\" title=\"Print code\"><img decoding=\"async\" border=\"0\" style=\"border: 0 none\" src=\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/plugins\/wp-synhighlight\/themes\/default\/images\/printer.png\" \/><\/a>&nbsp;<a href=\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/plugins\/wp-synhighlight\/About.html\" target=\"_blank\" title=\"Show plugin information\"><img decoding=\"async\" border=\"0\" style=\"border: 0 none\" src=\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/plugins\/wp-synhighlight\/themes\/default\/images\/info.gif\" \/><\/a>&nbsp;<\/td><\/tr><\/table><\/div><div id=\"wpshdi_3\" class=\"wp-synhighlighter-inner\" style=\"display: block;\"><pre class=\"php\" style=\"font-family:monospace;\">AND title LIKE <span class=\"st_h\">'&quot; . $letra . &quot;%'<\/span><\/pre><\/div><\/div>\n<p>Esta condici\u00f3n indica a la consulta <strong>SQL<\/strong> que quiero sacar todos los registros en el que el t\u00edtulo empiece por la letra escogida.<\/p>\n<p class=\"text-center\" style=\"text-align: center;\"><a class=\"btn btn-secondary\" href=\"https:\/\/www.jose-aguilar.com\/scripts\/php\/search-abc\/\" target=\"_blank\" rel=\"noopener noreferrer\"><i class=\"fa fa-eye\"><\/i> Ver demo<\/a> <a class=\"btn btn-primary\" href=\"https:\/\/www.jose-aguilar.com\/modulos-prestashop\/es\/32-abc-busqueda-de-productos.html\"><i class=\"fa fa-eye\"><\/i> Ver m\u00f3dulo Buscador con letras del abecedario para Prestashop<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Averigua como mostrar las letras del abecedario en tu p\u00e1gina web utilizando PHP y descubre cual es la clave para crear las consultas a la base de datos.<\/p>\n","protected":false},"author":1,"featured_media":7491,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,21],"tags":[68,124],"class_list":["post-1538","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-php","category-prestashop","tag-buscadores","tag-modulos-prestashop"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Buscador con letras del abecedario con consultas a base de datos - Jose Aguilar Blog<\/title>\n<meta name=\"description\" content=\"Averigua como mostrar las letras del abecedario en tu p\u00e1gina web utilizando PHP y descubre cual es la clave para crear las consultas a la base de datos.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Buscador con letras del abecedario con consultas a base de datos - Jose Aguilar Blog\" \/>\n<meta property=\"og:description\" content=\"Averigua como mostrar las letras del abecedario en tu p\u00e1gina web utilizando PHP y descubre cual es la clave para crear las consultas a la base de datos.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.jose-aguilar.com\/blog\/buscador-con-letras-del-abecedario-con-consultas-a-base-de-datos\/\" \/>\n<meta property=\"og:site_name\" content=\"Jose Aguilar Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/joseaguilarblog\" \/>\n<meta property=\"article:published_time\" content=\"2012-01-27T14:40:33+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-11-07T11:52:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/01\/buscador-con-letras-del-abecedario-con-consultas-a-base-de-datos.png\" \/>\n\t<meta property=\"og:image:width\" content=\"250\" \/>\n\t<meta property=\"og:image:height\" content=\"250\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Jose Aguilar\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@JoseAguilarBlog\" \/>\n<meta name=\"twitter:site\" content=\"@JoseAguilarBlog\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jose Aguilar\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/buscador-con-letras-del-abecedario-con-consultas-a-base-de-datos\/\",\"url\":\"https:\/\/www.jose-aguilar.com\/blog\/buscador-con-letras-del-abecedario-con-consultas-a-base-de-datos\/\",\"name\":\"Buscador con letras del abecedario con consultas a base de datos - Jose Aguilar Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/buscador-con-letras-del-abecedario-con-consultas-a-base-de-datos\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/buscador-con-letras-del-abecedario-con-consultas-a-base-de-datos\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/01\/buscador-con-letras-del-abecedario-con-consultas-a-base-de-datos.png\",\"datePublished\":\"2012-01-27T14:40:33+00:00\",\"dateModified\":\"2019-11-07T11:52:27+00:00\",\"author\":{\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/#\/schema\/person\/e6d485db1e1140866e95971d17105d11\"},\"description\":\"Averigua como mostrar las letras del abecedario en tu p\u00e1gina web utilizando PHP y descubre cual es la clave para crear las consultas a la base de datos.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/buscador-con-letras-del-abecedario-con-consultas-a-base-de-datos\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.jose-aguilar.com\/blog\/buscador-con-letras-del-abecedario-con-consultas-a-base-de-datos\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/buscador-con-letras-del-abecedario-con-consultas-a-base-de-datos\/#primaryimage\",\"url\":\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/01\/buscador-con-letras-del-abecedario-con-consultas-a-base-de-datos.png\",\"contentUrl\":\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/01\/buscador-con-letras-del-abecedario-con-consultas-a-base-de-datos.png\",\"width\":250,\"height\":250,\"caption\":\"Buscador con letras del abecedario con consultas a base de datos\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/buscador-con-letras-del-abecedario-con-consultas-a-base-de-datos\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\/\/www.jose-aguilar.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Buscador con letras del abecedario con consultas a base de datos\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/#website\",\"url\":\"https:\/\/www.jose-aguilar.com\/blog\/\",\"name\":\"Jose Aguilar Blog\",\"description\":\"Desarrollo Web con PrestaShop, WordPress, PHP, jQuery y Ajax\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.jose-aguilar.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/#\/schema\/person\/e6d485db1e1140866e95971d17105d11\",\"name\":\"Jose Aguilar\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/abbfef5f1d75260c549d0f2c2842bb697ba1aadff3b2836b39d2590c8a625415?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/abbfef5f1d75260c549d0f2c2842bb697ba1aadff3b2836b39d2590c8a625415?s=96&d=mm&r=g\",\"caption\":\"Jose Aguilar\"},\"description\":\"Director ejecutivo y tecnol\u00f3gico en JA Modules. Experto programador PrestaShop y Experto programador WordPress.\",\"sameAs\":[\"https:\/\/plus.google.com\/114357189801512615537\"],\"url\":\"https:\/\/www.jose-aguilar.com\/blog\/author\/josea902\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Buscador con letras del abecedario con consultas a base de datos - Jose Aguilar Blog","description":"Averigua como mostrar las letras del abecedario en tu p\u00e1gina web utilizando PHP y descubre cual es la clave para crear las consultas a la base de datos.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"es_ES","og_type":"article","og_title":"Buscador con letras del abecedario con consultas a base de datos - Jose Aguilar Blog","og_description":"Averigua como mostrar las letras del abecedario en tu p\u00e1gina web utilizando PHP y descubre cual es la clave para crear las consultas a la base de datos.","og_url":"https:\/\/www.jose-aguilar.com\/blog\/buscador-con-letras-del-abecedario-con-consultas-a-base-de-datos\/","og_site_name":"Jose Aguilar Blog","article_publisher":"https:\/\/www.facebook.com\/joseaguilarblog","article_published_time":"2012-01-27T14:40:33+00:00","article_modified_time":"2019-11-07T11:52:27+00:00","og_image":[{"width":250,"height":250,"url":"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/01\/buscador-con-letras-del-abecedario-con-consultas-a-base-de-datos.png","type":"image\/png"}],"author":"Jose Aguilar","twitter_card":"summary_large_image","twitter_creator":"@JoseAguilarBlog","twitter_site":"@JoseAguilarBlog","twitter_misc":{"Escrito por":"Jose Aguilar","Tiempo de lectura":"4 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.jose-aguilar.com\/blog\/buscador-con-letras-del-abecedario-con-consultas-a-base-de-datos\/","url":"https:\/\/www.jose-aguilar.com\/blog\/buscador-con-letras-del-abecedario-con-consultas-a-base-de-datos\/","name":"Buscador con letras del abecedario con consultas a base de datos - Jose Aguilar Blog","isPartOf":{"@id":"https:\/\/www.jose-aguilar.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.jose-aguilar.com\/blog\/buscador-con-letras-del-abecedario-con-consultas-a-base-de-datos\/#primaryimage"},"image":{"@id":"https:\/\/www.jose-aguilar.com\/blog\/buscador-con-letras-del-abecedario-con-consultas-a-base-de-datos\/#primaryimage"},"thumbnailUrl":"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/01\/buscador-con-letras-del-abecedario-con-consultas-a-base-de-datos.png","datePublished":"2012-01-27T14:40:33+00:00","dateModified":"2019-11-07T11:52:27+00:00","author":{"@id":"https:\/\/www.jose-aguilar.com\/blog\/#\/schema\/person\/e6d485db1e1140866e95971d17105d11"},"description":"Averigua como mostrar las letras del abecedario en tu p\u00e1gina web utilizando PHP y descubre cual es la clave para crear las consultas a la base de datos.","breadcrumb":{"@id":"https:\/\/www.jose-aguilar.com\/blog\/buscador-con-letras-del-abecedario-con-consultas-a-base-de-datos\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.jose-aguilar.com\/blog\/buscador-con-letras-del-abecedario-con-consultas-a-base-de-datos\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.jose-aguilar.com\/blog\/buscador-con-letras-del-abecedario-con-consultas-a-base-de-datos\/#primaryimage","url":"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/01\/buscador-con-letras-del-abecedario-con-consultas-a-base-de-datos.png","contentUrl":"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/01\/buscador-con-letras-del-abecedario-con-consultas-a-base-de-datos.png","width":250,"height":250,"caption":"Buscador con letras del abecedario con consultas a base de datos"},{"@type":"BreadcrumbList","@id":"https:\/\/www.jose-aguilar.com\/blog\/buscador-con-letras-del-abecedario-con-consultas-a-base-de-datos\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/www.jose-aguilar.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Buscador con letras del abecedario con consultas a base de datos"}]},{"@type":"WebSite","@id":"https:\/\/www.jose-aguilar.com\/blog\/#website","url":"https:\/\/www.jose-aguilar.com\/blog\/","name":"Jose Aguilar Blog","description":"Desarrollo Web con PrestaShop, WordPress, PHP, jQuery y Ajax","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.jose-aguilar.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Person","@id":"https:\/\/www.jose-aguilar.com\/blog\/#\/schema\/person\/e6d485db1e1140866e95971d17105d11","name":"Jose Aguilar","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.jose-aguilar.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/abbfef5f1d75260c549d0f2c2842bb697ba1aadff3b2836b39d2590c8a625415?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/abbfef5f1d75260c549d0f2c2842bb697ba1aadff3b2836b39d2590c8a625415?s=96&d=mm&r=g","caption":"Jose Aguilar"},"description":"Director ejecutivo y tecnol\u00f3gico en JA Modules. Experto programador PrestaShop y Experto programador WordPress.","sameAs":["https:\/\/plus.google.com\/114357189801512615537"],"url":"https:\/\/www.jose-aguilar.com\/blog\/author\/josea902\/"}]}},"_links":{"self":[{"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/posts\/1538","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/comments?post=1538"}],"version-history":[{"count":0,"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/posts\/1538\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/media\/7491"}],"wp:attachment":[{"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/media?parent=1538"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/categories?post=1538"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/tags?post=1538"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}