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
Post a Comment