{"id":298,"date":"2013-07-25T00:11:50","date_gmt":"2013-07-25T00:11:50","guid":{"rendered":"http:\/\/blog.luisrodriguez.pe\/?p=298"},"modified":"2013-11-15T20:13:13","modified_gmt":"2013-11-15T20:13:13","slug":"json-con-jquery-en-php","status":"publish","type":"post","link":"https:\/\/luisrodriguez.pe\/blog\/json-con-jquery-en-php\/","title":{"rendered":"Crear JSON con PHP y jQuery"},"content":{"rendered":"

Realizaremos un ejemplo claro que como hacer un petici\u00f3n AJAX con tipo de datos JSON (acr\u00f3nimo de JavaScript Object Notation)<\/a>
\nlas explicaciones del script ya estan comentadas dentro de las mismas<\/p>\n

la pagina json.php<\/p>\n\n

\/\/aqui una simple conexion a la base de datos<\/span>\nmysql_select_db(<\/span>"maltin"<\/span>,<\/span>mysql_connect(<\/span>"localhost"<\/span>,<\/span> "root"<\/span>,<\/span> "pass"<\/span>)<\/span>)<\/span>;<\/span>\n\/\/consultamos a la tabla codigos<\/span>\n$sql=<\/span>mysql_query(<\/span>"select * from codigos"<\/span>)<\/span>;<\/span>\n\/\/definimos las variables<\/span>\n$data=<\/span>array(<\/span>)<\/span>;<\/span>\n$i=<\/span>0<\/span>;<\/span>\n\/\/un while para obtener los datos del array que nos devuelve la base de datos<\/span>\nwhile (<\/span>$row=<\/span>mysql_fetch_array(<\/span>$sql)<\/span>)<\/span>\n{<\/span>\n    \/\/los metemos en una variable<\/span>\n    $data[<\/span>$i]<\/span>[<\/span>"id"<\/span>]<\/span>=<\/span>$row[<\/span>id]<\/span>;<\/span>\n    $data[<\/span>$i]<\/span>[<\/span>"letra"<\/span>]<\/span>=<\/span>$row[<\/span>letra]<\/span>;<\/span>\n    $data[<\/span>$i]<\/span>[<\/span>"codigo"<\/span>]<\/span>=<\/span>$row[<\/span>codigo]<\/span>;<\/span>\n    $data[<\/span>$i]<\/span>[<\/span>"estado"<\/span>]<\/span>=<\/span>$row[<\/span>estado]<\/span>;<\/span>\n    $i++;<\/span>\n}<\/span>\n\/\/y finalmente usamos json_encode una funciona nativa del php que lo formatea<\/span>\necho json_encode(<\/span>$data)<\/span>;<\/span><\/pre><\/td><\/tr><\/table><\/div>\n\n
La pagina index.php que hace el llamado del json.php<\/p>\n\n
$(<\/span>document)<\/span>.ready<\/span>(<\/span>function<\/span>(<\/span>)<\/span>{<\/span>\n\/\/una peticion ajax de tipo get con tipo de datos json<\/span>\n\/\/llamamos a la pagina json.php que contiene toda la data<\/span>\n\/\/ y si se realizo correctamente mostramos el contenido con un<\/span>\n\/\/ each ya que sera un listado y todo lo metemos en una div<\/span>\n    $.ajax<\/span>(<\/span>{<\/span>\n        type:<\/span> "GET"<\/span>,<\/span>\n        dataType:<\/span> "json"<\/span>,<\/span>\n        url:<\/span> "json.php"<\/span>,<\/span> \n \n        success :<\/span> function<\/span>(<\/span>data)<\/span> {<\/span>\n \n                              $.each<\/span>(<\/span>data,<\/span> function<\/span>(<\/span>i,<\/span> item)<\/span> {<\/span>\n                                    $(<\/span>"div"<\/span>)<\/span>.append<\/span>(<\/span>item.id<\/span>+<\/span>" "<\/span>+<\/span>item.codigo<\/span>+<\/span>""<\/span>)<\/span>\n                               }<\/span>)<\/span>;<\/span>\n \n\t\t\t}<\/span>\n    }<\/span>)<\/span>\n \n}<\/span>)<\/span><\/pre><\/td><\/tr><\/table><\/div>\n\n","protected":false},"excerpt":{"rendered":"Realizaremos un ejemplo claro que como hacer un petici\u00f3n AJAX con tipo de datos JSON (acr\u00f3nimo de JavaScript Object Notation) las explicaciones del script ya estan comentadas dentro de las mismas la pagina json.php \/\/aqui una simple conexion a la base de datos mysql_select_db("maltin",mysql_connect("localhost", "root", "pass")); \/\/consultamos a la tabla codigos $sql=mysql_query("select * from codigos");[…]","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7,6],"tags":[],"class_list":["post-298","post","type-post","status-publish","format-standard","hentry","category-javascript","category-php"],"yoast_head":"\nCrear JSON con PHP y jQuery - Blog Luis Rodriguez<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/luisrodriguez.pe\/blog\/json-con-jquery-en-php\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Crear JSON con PHP y jQuery - Blog Luis Rodriguez\" \/>\n<meta property=\"og:description\" content=\"Realizaremos un ejemplo claro que como hacer un petici\u00f3n AJAX con tipo de datos JSON (acr\u00f3nimo de JavaScript Object Notation) las explicaciones del script ya estan comentadas dentro de las mismas la pagina json.php \/\/aqui una simple conexion a la base de datos mysql_select_db("maltin",mysql_connect("localhost", "root", "pass")); \/\/consultamos a la tabla codigos $sql=mysql_query("select * from codigos");[...]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/luisrodriguez.pe\/blog\/json-con-jquery-en-php\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog Luis Rodriguez\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/luisrodriguez.pe\" \/>\n<meta property=\"article:published_time\" content=\"2013-07-25T00:11:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2013-11-15T20:13:13+00:00\" \/>\n<meta name=\"author\" content=\"Luis Rodriguez\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@luizmirodriguez\" \/>\n<meta name=\"twitter:site\" content=\"@luizmirodriguez\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Luis Rodriguez\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/luisrodriguez.pe\/blog\/json-con-jquery-en-php\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/luisrodriguez.pe\/blog\/json-con-jquery-en-php\/\"},\"author\":{\"name\":\"Luis Rodriguez\",\"@id\":\"https:\/\/luisrodriguez.pe\/blog\/#\/schema\/person\/ec55de81e01fdaf3533eb78f6a49090c\"},\"headline\":\"Crear JSON con PHP y jQuery\",\"datePublished\":\"2013-07-25T00:11:50+00:00\",\"dateModified\":\"2013-11-15T20:13:13+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/luisrodriguez.pe\/blog\/json-con-jquery-en-php\/\"},\"wordCount\":54,\"commentCount\":0,\"articleSection\":[\"JAVASCRIPT\",\"PHP\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/luisrodriguez.pe\/blog\/json-con-jquery-en-php\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/luisrodriguez.pe\/blog\/json-con-jquery-en-php\/\",\"url\":\"https:\/\/luisrodriguez.pe\/blog\/json-con-jquery-en-php\/\",\"name\":\"Crear JSON con PHP y jQuery - Blog Luis Rodriguez\",\"isPartOf\":{\"@id\":\"https:\/\/luisrodriguez.pe\/blog\/#website\"},\"datePublished\":\"2013-07-25T00:11:50+00:00\",\"dateModified\":\"2013-11-15T20:13:13+00:00\",\"author\":{\"@id\":\"https:\/\/luisrodriguez.pe\/blog\/#\/schema\/person\/ec55de81e01fdaf3533eb78f6a49090c\"},\"breadcrumb\":{\"@id\":\"https:\/\/luisrodriguez.pe\/blog\/json-con-jquery-en-php\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/luisrodriguez.pe\/blog\/json-con-jquery-en-php\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/luisrodriguez.pe\/blog\/json-con-jquery-en-php\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\/\/luisrodriguez.pe\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Crear JSON con PHP y jQuery\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/luisrodriguez.pe\/blog\/#website\",\"url\":\"https:\/\/luisrodriguez.pe\/blog\/\",\"name\":\"Blog Luis Rodriguez\",\"description\":\"Analytics Developer\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/luisrodriguez.pe\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/luisrodriguez.pe\/blog\/#\/schema\/person\/ec55de81e01fdaf3533eb78f6a49090c\",\"name\":\"Luis Rodriguez\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/3b0f9734b267ecb38e1860734b4caebda4efa8be9a2bb536862b6a2ba23afa82?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/3b0f9734b267ecb38e1860734b4caebda4efa8be9a2bb536862b6a2ba23afa82?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/3b0f9734b267ecb38e1860734b4caebda4efa8be9a2bb536862b6a2ba23afa82?s=96&d=mm&r=g\",\"caption\":\"Luis Rodriguez\"},\"description\":\"Hola, Soy Luis Rodriguez, radico en Lima \u2013 Per\u00fa, formado en una carrera inform\u00e1tica, desempe\u00f1ando desde el 2007 como programador web y viendo proyectos desde Front End y Back End a lo que me perfile como Full Stack. Esta Experiencia junto a mi inter\u00e9s en la Anal\u00edtica Web me ayud\u00f3 mucho entender el funcionamiento interno de las herramientas de anal\u00edtica, con las que vengo trabajo activamente desde 2017. Linkedin\",\"sameAs\":[\"http:\/\/luisrodriguez.pe\"],\"url\":\"https:\/\/luisrodriguez.pe\/blog\/author\/admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Crear JSON con PHP y jQuery - Blog Luis Rodriguez","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:\/\/luisrodriguez.pe\/blog\/json-con-jquery-en-php\/","og_locale":"es_ES","og_type":"article","og_title":"Crear JSON con PHP y jQuery - Blog Luis Rodriguez","og_description":"Realizaremos un ejemplo claro que como hacer un petici\u00f3n AJAX con tipo de datos JSON (acr\u00f3nimo de JavaScript Object Notation) las explicaciones del script ya estan comentadas dentro de las mismas la pagina json.php \/\/aqui una simple conexion a la base de datos mysql_select_db("maltin",mysql_connect("localhost", "root", "pass")); \/\/consultamos a la tabla codigos $sql=mysql_query("select * from codigos");[...]","og_url":"https:\/\/luisrodriguez.pe\/blog\/json-con-jquery-en-php\/","og_site_name":"Blog Luis Rodriguez","article_publisher":"https:\/\/www.facebook.com\/luisrodriguez.pe","article_published_time":"2013-07-25T00:11:50+00:00","article_modified_time":"2013-11-15T20:13:13+00:00","author":"Luis Rodriguez","twitter_card":"summary_large_image","twitter_creator":"@luizmirodriguez","twitter_site":"@luizmirodriguez","twitter_misc":{"Escrito por":"Luis Rodriguez","Tiempo de lectura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/luisrodriguez.pe\/blog\/json-con-jquery-en-php\/#article","isPartOf":{"@id":"https:\/\/luisrodriguez.pe\/blog\/json-con-jquery-en-php\/"},"author":{"name":"Luis Rodriguez","@id":"https:\/\/luisrodriguez.pe\/blog\/#\/schema\/person\/ec55de81e01fdaf3533eb78f6a49090c"},"headline":"Crear JSON con PHP y jQuery","datePublished":"2013-07-25T00:11:50+00:00","dateModified":"2013-11-15T20:13:13+00:00","mainEntityOfPage":{"@id":"https:\/\/luisrodriguez.pe\/blog\/json-con-jquery-en-php\/"},"wordCount":54,"commentCount":0,"articleSection":["JAVASCRIPT","PHP"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/luisrodriguez.pe\/blog\/json-con-jquery-en-php\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/luisrodriguez.pe\/blog\/json-con-jquery-en-php\/","url":"https:\/\/luisrodriguez.pe\/blog\/json-con-jquery-en-php\/","name":"Crear JSON con PHP y jQuery - Blog Luis Rodriguez","isPartOf":{"@id":"https:\/\/luisrodriguez.pe\/blog\/#website"},"datePublished":"2013-07-25T00:11:50+00:00","dateModified":"2013-11-15T20:13:13+00:00","author":{"@id":"https:\/\/luisrodriguez.pe\/blog\/#\/schema\/person\/ec55de81e01fdaf3533eb78f6a49090c"},"breadcrumb":{"@id":"https:\/\/luisrodriguez.pe\/blog\/json-con-jquery-en-php\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/luisrodriguez.pe\/blog\/json-con-jquery-en-php\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/luisrodriguez.pe\/blog\/json-con-jquery-en-php\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/luisrodriguez.pe\/blog\/"},{"@type":"ListItem","position":2,"name":"Crear JSON con PHP y jQuery"}]},{"@type":"WebSite","@id":"https:\/\/luisrodriguez.pe\/blog\/#website","url":"https:\/\/luisrodriguez.pe\/blog\/","name":"Blog Luis Rodriguez","description":"Analytics Developer","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/luisrodriguez.pe\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Person","@id":"https:\/\/luisrodriguez.pe\/blog\/#\/schema\/person\/ec55de81e01fdaf3533eb78f6a49090c","name":"Luis Rodriguez","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/secure.gravatar.com\/avatar\/3b0f9734b267ecb38e1860734b4caebda4efa8be9a2bb536862b6a2ba23afa82?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/3b0f9734b267ecb38e1860734b4caebda4efa8be9a2bb536862b6a2ba23afa82?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3b0f9734b267ecb38e1860734b4caebda4efa8be9a2bb536862b6a2ba23afa82?s=96&d=mm&r=g","caption":"Luis Rodriguez"},"description":"Hola, Soy Luis Rodriguez, radico en Lima \u2013 Per\u00fa, formado en una carrera inform\u00e1tica, desempe\u00f1ando desde el 2007 como programador web y viendo proyectos desde Front End y Back End a lo que me perfile como Full Stack. Esta Experiencia junto a mi inter\u00e9s en la Anal\u00edtica Web me ayud\u00f3 mucho entender el funcionamiento interno de las herramientas de anal\u00edtica, con las que vengo trabajo activamente desde 2017. Linkedin","sameAs":["http:\/\/luisrodriguez.pe"],"url":"https:\/\/luisrodriguez.pe\/blog\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/luisrodriguez.pe\/blog\/wp-json\/wp\/v2\/posts\/298","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/luisrodriguez.pe\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/luisrodriguez.pe\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/luisrodriguez.pe\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/luisrodriguez.pe\/blog\/wp-json\/wp\/v2\/comments?post=298"}],"version-history":[{"count":13,"href":"https:\/\/luisrodriguez.pe\/blog\/wp-json\/wp\/v2\/posts\/298\/revisions"}],"predecessor-version":[{"id":414,"href":"https:\/\/luisrodriguez.pe\/blog\/wp-json\/wp\/v2\/posts\/298\/revisions\/414"}],"wp:attachment":[{"href":"https:\/\/luisrodriguez.pe\/blog\/wp-json\/wp\/v2\/media?parent=298"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/luisrodriguez.pe\/blog\/wp-json\/wp\/v2\/categories?post=298"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/luisrodriguez.pe\/blog\/wp-json\/wp\/v2\/tags?post=298"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}