Forum


17:49

20/02/2009

Hello,
I have a pb to extrat information from array wich is returns by the method: getCol.
This is my cod in my javascript page.
var $tb = $("#liste_produit").getCol('eta_actif',true); $.ajax({ type: "POST", url: $url_aj, data: "typ_requete=enr_grid&tb="+ $tb, success: function(contenu){ alert(contenu); }, error: function(objet,type){ alert('error: ' + type); } });
the result is like this: [{id:1,value:val1},{id:2,value:val2},{id:3,value:val3},{id:...,value:..}]
How can I get back various values of the various array.
Thank you for your help.
Regards
Missa
11:39

20/02/2009

Hello,
I find! It is my AJAX request! It doesn't like object.That why I do this:
/* fonctionnalité du bouton envoyer de la page ajout et consultation*/ var $donnees_get = ""; var $liste_ajax = ""; $donnees_get = $("#liste_produit").getCol('eta_actif',true); for ($valeur in $donnees_get){ $liste_ajax = $liste_ajax + '|("' + $donnees_get[$valeur].id.substring(0,5) + '","' + $donnees_get[$valeur].id.substring(6,9) + '","' + $donnees_get[$valeur].value + '")' ; } $liste_ajax = $liste_ajax.substring(1); $.ajax({ type: "POST", url: $url_aj, data: "typ_requete=enr_grid&liste_ajax="+ $liste_ajax, success: function(contenu){ /*alert(contenu);*/ }, error: function(objet,type){ alert('error: ' + type); } });
And after that, Everything work in my Php page. I do this:
if ($_REQUEST['typ_requete'] == 'enr_grid') { $donnees = explode("|",$_REQUEST['liste_ajax']); foreach ($donnees as $valeur){ $id = explode(',',$valeur); $SQL = "UPDATE rf.ft_produit_codif SET eta_actif = ".substr($id[2],0,3)." WHERE cod_produit = ".substr($id[0],1,7)." AND cod_origine = ".substr($id[1],0,5); $result = mysqli_query($link,$SQL); } }
Regards
Most Users Ever Online: 715
Currently Online:
59 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
OlegK: 1255
markw65: 179
kobruleht: 144
phicarre: 132
YamilBracho: 124
Renso: 118
Member Stats:
Guest Posters: 447
Members: 11373
Moderators: 2
Admins: 1
Forum Stats:
Groups: 1
Forums: 8
Topics: 10592
Posts: 31289
Newest Members:
, razia, Prankie, psky, praveen neelam, greg.valainis@pa-tech.comModerators: tony: 7721, Rumen[Trirand]: 81
Administrators: admin: 66