Thursday, 15 August 2013

Triggering action from a select using jquery and php -



Triggering action from a select using jquery and php -

i'm having problem jquery , php, php :s have select populated via php, that's code:

<script type="text/javascript" src="js/jquery.min.js"></script> <script type="text/javascript" src="js/script.js"></script> <select name="gname" id="gnome"> <option>scegli...</option> <?php include ('php/config.php'); //recupero organizzazioni dal database $sql = "select distinct gname, count(*) number gtdb `country` = 4 or `country` = 103 or `country` = 107 or `country` = 219 or `country` = 210 or `country` = 210 or `country` = 153 or `country` = 110 or `country` = 200 or `country` = 102 or `country` = 95 or `country` = 173 or `country` = 228 or `country` = 152 or `country` = 97 or `country` = 94 grouping gname having number >= 20 order gname"; $result = mysql_query($sql, $mysql); while($nome = mysql_fetch_array($result)) { ?> <option value= "<?php echo $nome['gname'];?>" ><?php echo $nome['gname']; ?></option> <?php }; ?> </select>

when select option, jquery function should post value of alternative php script , append result "result" div. jquery code:

$(document).ready(function() { $('#gnome').change(function() { var inpval=$(this).val(); $.ajax({ url: 'php/query.php', type: 'post', data: {valor : inpval}, success: function(data) { $('.result').html(data); } }); }); });

php code:

<?php include('config.php'); //database connection(works) $org_name=$_post['valor']; $query=mysql_query("select * gtdb gname '$org_name%'"); while($row=mysql_fetch_assoc($query)){ $row['name']; } ?>

actually i'm able connect database, query , populate select, when select alternative nil happens, don't know if it's fault of jquery code or of php code, help? in advance :)

edit: html code reaches browser, user3558931

<p>gname</p> <select name="gname" id="gnome"> <option>scegli...</option> <option value= "al-aqsa martyrs brigade" >al-aqsa martyrs brigade</option> <option value= "al-nusrah front" >al-nusrah front</option> <option value= "al-qa`ida in iraq" >al-qa`ida in iraq</option> <option value= "al-qa`ida in arabian peninsula (aqap)" >al-qa`ida in arabian peninsula (aqap)</option> <option value= "baloch liberation regular army (bla)" >baloch liberation regular army (bla)</option> <option value= "baloch republican regular army (bra)" >baloch republican regular army (bra)</option> <option value= "free syrian army" >free syrian army</option> <option value= "gunmen" >gunmen</option> <option value= "hamas (islamic resistance movement)" >hamas (islamic resistance movement)</option> <option value= "haqqani network" >haqqani network</option> <option value= "individual" >individual</option> <option value= "islamic state of republic of iraq (isi)" >islamic state of republic of iraq (isi)</option> <option value= "lashkar-e-islam (pakistan)" >lashkar-e-islam (pakistan)</option> <option value= "lashkar-e-jhangvi" >lashkar-e-jhangvi</option> <option value= "militants" >militants</option> <option value= "other" >other</option> <option value= "palestinian islamic jihad (pij)" >palestinian islamic jihad (pij)</option> <option value= "popular front end liberation of palestine (pflp)" >popular front end liberation of palestine (pflp)</option> <option value= "popular resistance committees" >popular resistance committees</option> <option value= "sindhu desh liberation regular army (sdla)" >sindhu desh liberation regular army (sdla)</option> <option value= "southern mobility motion (yemen)" >southern mobility motion (yemen)</option> <option value= "taliban" >taliban</option> <option value= "tehrik-i-taliban islamic republic of pakistan (ttp)" >tehrik-i-taliban islamic republic of pakistan (ttp)</option> <option value= "unknown" >unknown</option> </select>

and yes, it's terrorism xd

please change:

data: ({valor : inpval}),

to:

data: {valor : inpval},

and statement obtaining info value should be:

var inpval = this.value;

js fiddle demo

when alter select value please open dev tools , check network tab , you'll see ajax phone call made.

also create sure have element class result on page.

note: php script needs edited can homecoming something, maybe echo $row['gname'];

php jquery html mysql

No comments:

Post a Comment