PHP/AJAX stored procedure issue -


i'm having issue stored procedure launched via select change event. problem though i'm able selected item's value, while pass argument stored procedure , bind it, procedure doesn't launched. i've tried launch statically , works. have tried change datatype , mime type , other stuffs i'm stuck. here's code:

$groupe = new groupe();  if (isset($_post['value'])){      $param = $_post['name'];      $storedprocedure = 'call listetitrespargroupe(:groupes)';      $query = $groupe->prepare($storedprocedure);     $query->bindparam(':groupes', $param, pdo::param_str);       $query->execute();      echo $_post['name'].' -> '.$param.'   '.$storedprocedure;     echo '<table class="table table-hover col-lg-12">';      while ($resultat = $query->fetch()){          echo'<tr><td class="col-md-12">'.$resultat[0].'</td></tr>';      }     echo '</table>'; }  

the ajax code:

var selectedtext = {value: $('#groupe option:selected').text(),  name:$('#groupe option:selected').text()};      $.ajax({          url: './storedprocedures.php',         type: 'post',         datatype: 'text',         mimetype : 'text/html; charset=utf-8',         data: selectedtext      })     .done(function(data){$('#titres').html(data);})     .fail(function() {          console.log("erreur");         alert('ajax query has failed');      })     .always(function() {          console.log("terminé");      }); 

if has idea why doesn't work, i'd grateful

just try in different way, might try removing bind:

$query->bindparam(':groupes', $param, pdo::param_str); 

and try putting param in execute function:

$query->execute(array(':groupes'=>$param)); 

it 1 less line of code, , worth try maybe see if fails.


Comments