Hello,
I'm working on an app with phonegap and dreamweaver CS6.
I have an multiple Jquery select form:
The Ajax script:Code:<form id="target" method="post"> <select name="tricks" id="tricks" data-native-menu="false" data-mini="false" multiple="multiple" size="10"> <option value="Ollie">Ollie</option> <option value="Shuvit">Shuvit</option> <option value="Kickflip">Kickflip</option> <option value="Heelflip">Heelflip</option> <option value="Pop-shuvit">Pop-shuvit</option> <option value="Varial-kickflip">Varial-kickflip</option> <option value="Varial-Heelflip">Varial-Heelflip</option> <option value="360-flip">360-flip</option> </select> <input type="button" value="Add changes"/> </form>
(I checked if it posted the values to my handler.php with firebug, it says: tricks Ollie tricks Shuvit, and sends: tricks=Ollie&tricks=Shuvit)
Btw: Which I select it will just send it
The PHP code:Code:<script type="text/javascript"> $(document).ready(function(){ $('#target').click(function(e) { $.ajax({ type: "POST", url: "http://pruissenwebdesign.nl/sk8mate/mobile/handler.php", data: $('#target').serializeArray(), cache: false, dataType: "text", success: function(tricks) { alert("whatever"); } }); }); }); </script>
(This is just to check if it insert's in database, but it won't show up,...)
Btw: The first of VALUES is an ID
I think it has something to do with an array, but I'm not really into array's...Code:<?php mysql_connect('localhost','username','password'); mysql_select_db('pruisse_sk8mate'); $info = $_POST['tricks']; $sql = mysql_query("INSERT INTO tricks VALUES(' ','$info')"; ?>
Hope you guys can help me out!
Greetings, Boris




Reply With Quote
Bookmarks