{"id":6010,"date":"2013-06-12T13:56:10","date_gmt":"2013-06-12T13:56:10","guid":{"rendered":"https:\/\/www.jose-aguilar.com\/blog\/?p=6010"},"modified":"2019-03-05T17:26:07","modified_gmt":"2019-03-05T17:26:07","slug":"multiselect-con-jquery-ajax-y-php","status":"publish","type":"post","link":"https:\/\/www.jose-aguilar.com\/blog\/multiselect-con-jquery-ajax-y-php\/","title":{"rendered":"Multiselect con jQuery, Ajax y PHP"},"content":{"rendered":"

Muchos usuarios me han solicitado la creaci\u00f3n de un tutorial que presente un multiselect din\u00e1mico asociado a una base de datos habiendo visto previamente el art\u00edculo referente a un plugin jQuery ya existente: Multiselect<\/a>.<\/p>\n

Este plugin funciona de maravilla para la acci\u00f3n de multiseleccionar registros pero no he visto viable darle dinamismo interactuando con una base de datos.<\/p>\n

En este art\u00edculo vamos a ver una forma sencilla para crear un multiselect personalizado sin utilizar plugins y con interacci\u00f3n con una base de datos.<\/p>\n

En nuestra p\u00e1gina lo primero que tendremos que hacer es conectar mediante PHP y MySQLi a la base de datos deseada:<\/p>\n

<?php\r\n$conexion = new mysqli(DB_SERVER, DB_SERVER_USERNAME, DB_SERVER_PASSWORD, DB_DATABASE);\r\n?><\/pre>\n
En el ejemplo que vamos a ilustrar vamos a interactuar con una tabla de usuarios que tiene las siguientes caracter\u00edsticas:<\/p>\n
\"bdusers\"<\/a><\/p>\n
Para este tutorial nos vamos a centrar tan solo en la idUsuario, usuario y selected<\/strong>. Este \u00faltimo atributo con mayor \u00e9nfasis\u00a0 ya que ser\u00e1 el que determinar\u00e1 si un usuario ha sido elegido o no.<\/p>\n
En el <body> de nuestra p\u00e1gina tendremos el c\u00f3digo HTML y PHP con el que conseguiremos visualizar las 2 listas de usuarios. En una banda se muestran los usuarios seleccionados y en la otra el resto de usuarios por seleccionar.<\/p>\n
\"multiselectme\"<\/a><\/p>\n
Esto en c\u00f3digo se traduce como:<\/p>\n
<div id=\"multiselect\">\r\n\u00a0\u00a0\u00a0 <div class=\"left\">\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <h3>Usuarios elegidos<\/h3>\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <ul>\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 <?php\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0$result = $conexion->query(\"SELECT `idUsuario`, `usuario`, `selected` FROM `usuarios` WHERE selected=1\");\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0if ($result->num_rows > 0) {\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0while ($row_users = $result->fetch_assoc()) {\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0echo '<li id=\"user-'.$row_users['idUsuario'].'\" data=\"'.$row_users['idUsuario'].'\">'.$row_users['usuario'].'<\/li>';\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0}\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0}\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0?>\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/ul>\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <a href=\"#\" id=\"remove\">Quitar todos<\/a>\r\n\u00a0\u00a0 \u00a0<\/div>\r\n\r\n\u00a0\u00a0 \u00a0<div class=\"right\">\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0<h3>Usuarios<\/h3>\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <ul>\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <?php\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0$result = $conexion->query(\"SELECT `idUsuario`, `usuario`, `selected` FROM `usuarios` WHERE selected=0\");\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0if ($result->num_rows > 0) {\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0while ($row_users = $result->fetch_assoc()) {\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0echo '<li id=\"user-'.$row_users['idUsuario'].'\" data=\"'.$row_users['idUsuario'].'\">'.$row_users['usuario'].'<\/li>';\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0}\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0}\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0?>\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/ul>\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <a href=\"#\" id=\"add\">A\u00f1adir todo<\/a>\r\n\u00a0\u00a0\u00a0 <\/div>\r\n<\/div><\/pre>\n
Dentro de la etiqueta <head> de nuestra p\u00e1gina a\u00f1adiremos la librer\u00eda jQuery y los scripts necesarios para realizar los efectos:<\/p>\n
<script type=\"text\/javascript\" src=\"..\/jquery.js\"><\/script>\r\n<script type=\"text\/javascript\">\r\n$(document).ready(function() {\u00a0\u00a0 \u00a0\r\n\u00a0\u00a0 \u00a0$('#multiselect .right ul li').live('click',function() {\r\n\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0var user = $(this).text();\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0var data = $(this).attr('data');\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0var id = $(this).attr('id');\r\n\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0$('#multiselect .left ul').append('<li id=\"'+id+'\" data=\"'+data+'\">'+$(this).text()+'<\/li>');\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0$('#multiselect .right ul #'+id).remove();\r\n\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0var dataString = 'action=add&id='+data;\r\n\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0$.ajax({\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 type: \"POST\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 url: \"select.php\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 data: dataString,\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 success: function() {\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 });\r\n\u00a0\u00a0\u00a0 }); \u00a0\r\n\r\n\u00a0\u00a0 \u00a0$('#remove').live('click', function() {\u00a0\u00a0 \u00a0\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0$('#multiselect .left ul li').each(function(){\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0$('#multiselect .right ul').append('<li id=\"'+$(this).attr('id')+'\" data=\"'+$(this).attr('data')+'\">'+$(this).text()+'<\/li>');\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0$(this).remove();\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0});\r\n\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0var dataString = 'action=removeall';\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0$.ajax({\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0type: \"POST\",\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0url: \"select.php\",\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0data: dataString,\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0success: function() {\r\n\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0}\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0});\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0return false;\r\n\u00a0\u00a0\u00a0 }); \u00a0\r\n\r\n\u00a0\u00a0 \u00a0$('#add').live('click', function() {\u00a0\u00a0 \u00a0\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0$('#multiselect .right ul li').each(function(){\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0$('#multiselect .left ul').append('<li id=\"'+$(this).attr('id')+'\" data=\"'+$(this).attr('data')+'\">'+$(this).text()+'<\/li>');\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0$(this).remove();\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0});\r\n\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0var dataString = 'action=addall';\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0$.ajax({\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0type: \"POST\",\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0url: \"select.php\",\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0data: dataString,\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0success: function() {\r\n\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0}\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0});\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0return false;\r\n\u00a0\u00a0\u00a0 });\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\r\n});\u00a0\u00a0 \u00a0\r\n<\/script><\/pre>\n
En el c\u00f3digo anterior lo que tenemos son las acciones que se van a producir tras pulsar en un usuario, pulsar en el link de A\u00f1adir todo y pulsar en el link de quitar todo.<\/p>\n
Al hacer click en un usuario de la lista lo que hacemos es a\u00f1adirlo a la lista de usuarios seleccionados y quitarlo de la lista de usuarios ejecutando un archivo mediante la t\u00e9cnica AJAX para actualizar el registro que indica si un usuario ha sido elegido o no.<\/p>\n
Al hacer click en \u00abA\u00f1adir todo\u00bb, por cada elemento del listado lo movemos al listado de seleccionados y lo eliminados del listado de usuarios. En el caso de \u00abQuitar todo\u00bb hacemos la inversa.<\/p>\n
En el archivo select.php tenemos lo siguiente:<\/p>\n
<?php\r\n$conexion = new mysqli(DB_SERVER, DB_SERVER_USERNAME, DB_SERVER_PASSWORD, DB_DATABASE);\r\n\r\n$id = $_POST['id'];\r\n$action = $_POST['action'];\r\n\r\nswitch($action) {\r\n\u00a0\u00a0 \u00a0case 'add':\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0$update = \"UPDATE usuarios SET selected = 1 WHERE idUsuario = \".$id; \r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0break;\r\n\u00a0\u00a0 \u00a0case 'addall':\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0$update = \"UPDATE usuarios SET selected = 1 WHERE selected = 0\"; \r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0break;\r\n\u00a0\u00a0 \u00a0case 'removeall':\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0$update = \"UPDATE usuarios SET selected = 0 WHERE selected = 1\"; \r\n}\r\n\r\n$conexion->query($update);\r\n?><\/pre>\n
Seg\u00fan la opci\u00f3n que estemos realizando, ejecutaremos una query u otra.<\/p>\n
Ahora solo faltar\u00eda a\u00f1adir algo de estilos que como podr\u00e1s observar ser\u00e1 muy sencillo personalizarlo:<\/p>\n
#multiselect {\r\n\u00a0\u00a0 \u00a0float:left;\r\n\u00a0\u00a0 \u00a0width:100%;\r\n\r\n}\r\n\r\n#multiselect .left {\r\n\u00a0\u00a0 \u00a0float:left;\r\n\u00a0\u00a0 \u00a0width:290px;\r\n\u00a0\u00a0 \u00a0padding:10px;\r\n}\r\n\r\n#multiselect .right {\r\n\u00a0\u00a0 \u00a0float:right;\r\n\u00a0\u00a0 \u00a0width:290px;\r\n\u00a0\u00a0 \u00a0padding:10px;\r\n\r\n}\r\n\r\n#multiselect ul {\r\n\u00a0\u00a0 \u00a0border:1px solid #999999;\r\n\u00a0\u00a0 \u00a0background-color:#eee;\r\n\u00a0\u00a0 \u00a0width:272px;\r\n\u00a0\u00a0 \u00a0height:150px;\r\n\u00a0\u00a0 \u00a0overflow: auto;\r\n\u00a0\u00a0 \u00a0float:left;\r\n\u00a0\u00a0 \u00a0margin:0px;\r\n\u00a0\u00a0 \u00a0padding:0px;\r\n}\r\n\r\n#multiselect ul li {\r\n\u00a0\u00a0 \u00a0background-color:#CCCCCC;\r\n\u00a0\u00a0 \u00a0border-bottom:1px solid #999999;\r\n\u00a0\u00a0 \u00a0float:left;\r\n\u00a0\u00a0 \u00a0width:98%;\r\n\u00a0\u00a0 \u00a0padding-left:5px;\r\n\u00a0\u00a0 \u00a0list-style:none;\r\n\u00a0\u00a0 \u00a0cursor:pointer;\r\n}\r\n\r\n#multiselect ul li:hover {\r\n\u00a0\u00a0 \u00a0background-color:#999999;\r\n}<\/pre>\n
Ver el ejemplo en funcionamiento<\/a><\/p>\n
Si te ha servido este tutorial hazte fan de la p\u00e1gina de facebook del blog Jose Aguilar<\/a> o s\u00edguenos a trav\u00e9s de Twitter<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"
Muchos usuarios me han solicitado la creaci\u00f3n de un tutorial que presente un multiselect din\u00e1mico asociado a una base de datos habiendo visto previamente el art\u00edculo referente a un plugin jQuery ya existente: Multiselect. Este plugin funciona de maravilla para la acci\u00f3n de multiseleccionar registros pero no he visto viable darle dinamismo interactuando con una […]<\/p>\n","protected":false},"author":1,"featured_media":6011,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[31,5,3],"tags":[167,62],"class_list":["post-6010","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ajax","category-jquery","category-php","tag-eventos","tag-selects"],"yoast_head":"\nMultiselect con jQuery, Ajax y PHP - Jose Aguilar Blog<\/title>\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=\"Multiselect con jQuery, Ajax y PHP - Jose Aguilar Blog\" \/>\n<meta property=\"og:description\" content=\"Muchos usuarios me han solicitado la creaci\u00f3n de un tutorial que presente un multiselect din\u00e1mico asociado a una base de datos habiendo visto previamente el art\u00edculo referente a un plugin jQuery ya existente: Multiselect. Este plugin funciona de maravilla para la acci\u00f3n de multiseleccionar registros pero no he visto viable darle dinamismo interactuando con una […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.jose-aguilar.com\/blog\/multiselect-con-jquery-ajax-y-php\/\" \/>\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=\"2013-06-12T13:56:10+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-03-05T17:26:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2013\/06\/multiselectme.png\" \/>\n\t<meta property=\"og:image:width\" content=\"613\" \/>\n\t<meta property=\"og:image:height\" content=\"227\" \/>\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=\"5 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\/multiselect-con-jquery-ajax-y-php\/\",\"url\":\"https:\/\/www.jose-aguilar.com\/blog\/multiselect-con-jquery-ajax-y-php\/\",\"name\":\"Multiselect con jQuery, Ajax y PHP - Jose Aguilar Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/multiselect-con-jquery-ajax-y-php\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/multiselect-con-jquery-ajax-y-php\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2013\/06\/multiselectme.png\",\"datePublished\":\"2013-06-12T13:56:10+00:00\",\"dateModified\":\"2019-03-05T17:26:07+00:00\",\"author\":{\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/#\/schema\/person\/e6d485db1e1140866e95971d17105d11\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/multiselect-con-jquery-ajax-y-php\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.jose-aguilar.com\/blog\/multiselect-con-jquery-ajax-y-php\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/multiselect-con-jquery-ajax-y-php\/#primaryimage\",\"url\":\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2013\/06\/multiselectme.png\",\"contentUrl\":\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2013\/06\/multiselectme.png\",\"width\":613,\"height\":227},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/multiselect-con-jquery-ajax-y-php\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\/\/www.jose-aguilar.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Multiselect con jQuery, Ajax y PHP\"}]},{\"@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":"Multiselect con jQuery, Ajax y PHP - Jose Aguilar Blog","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":"Multiselect con jQuery, Ajax y PHP - Jose Aguilar Blog","og_description":"Muchos usuarios me han solicitado la creaci\u00f3n de un tutorial que presente un multiselect din\u00e1mico asociado a una base de datos habiendo visto previamente el art\u00edculo referente a un plugin jQuery ya existente: Multiselect. Este plugin funciona de maravilla para la acci\u00f3n de multiseleccionar registros pero no he visto viable darle dinamismo interactuando con una […]","og_url":"https:\/\/www.jose-aguilar.com\/blog\/multiselect-con-jquery-ajax-y-php\/","og_site_name":"Jose Aguilar Blog","article_publisher":"https:\/\/www.facebook.com\/joseaguilarblog","article_published_time":"2013-06-12T13:56:10+00:00","article_modified_time":"2019-03-05T17:26:07+00:00","og_image":[{"width":613,"height":227,"url":"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2013\/06\/multiselectme.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":"5 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.jose-aguilar.com\/blog\/multiselect-con-jquery-ajax-y-php\/","url":"https:\/\/www.jose-aguilar.com\/blog\/multiselect-con-jquery-ajax-y-php\/","name":"Multiselect con jQuery, Ajax y PHP - Jose Aguilar Blog","isPartOf":{"@id":"https:\/\/www.jose-aguilar.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.jose-aguilar.com\/blog\/multiselect-con-jquery-ajax-y-php\/#primaryimage"},"image":{"@id":"https:\/\/www.jose-aguilar.com\/blog\/multiselect-con-jquery-ajax-y-php\/#primaryimage"},"thumbnailUrl":"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2013\/06\/multiselectme.png","datePublished":"2013-06-12T13:56:10+00:00","dateModified":"2019-03-05T17:26:07+00:00","author":{"@id":"https:\/\/www.jose-aguilar.com\/blog\/#\/schema\/person\/e6d485db1e1140866e95971d17105d11"},"breadcrumb":{"@id":"https:\/\/www.jose-aguilar.com\/blog\/multiselect-con-jquery-ajax-y-php\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.jose-aguilar.com\/blog\/multiselect-con-jquery-ajax-y-php\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.jose-aguilar.com\/blog\/multiselect-con-jquery-ajax-y-php\/#primaryimage","url":"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2013\/06\/multiselectme.png","contentUrl":"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2013\/06\/multiselectme.png","width":613,"height":227},{"@type":"BreadcrumbList","@id":"https:\/\/www.jose-aguilar.com\/blog\/multiselect-con-jquery-ajax-y-php\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/www.jose-aguilar.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Multiselect con jQuery, Ajax y PHP"}]},{"@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\/6010","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=6010"}],"version-history":[{"count":0,"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/posts\/6010\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/media\/6011"}],"wp:attachment":[{"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/media?parent=6010"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/categories?post=6010"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/tags?post=6010"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}