I have this Ajax with PHP that determines my value correctly from a php sql query, on my "test page".
When adding the code to my main page, the button adds the correct data for a half second, and then removes it, leaving the "categories " input textbox empty.
The rest of the page is populated onload from local storage, before i press this button to populate the "categories " textbox. Any suggestions please?
Ajax
Category2.php
When adding the code to my main page, the button adds the correct data for a half second, and then removes it, leaving the "categories " input textbox empty.
The rest of the page is populated onload from local storage, before i press this button to populate the "categories " textbox. Any suggestions please?
Code:
HTML <td><input type="text" name="categories" id="categories" placeholder="categories" /></td> (The textboxes below are populated from localstorage) <td><input type="text" name="gender" id="gender" placeholder="gender" /></td> <td><input type="text" name="age" id="age" placeholder="age" /></td> <td><input type="text" name="racecode" id="racecode" placeholder="racecode" /></td> <button id="but" font size="2" style ="color:red" >Add Category </button>
Code:
<script type="text/javascript"> $(document).ready(function(){ $("#but").click(function(){ var vargender = $("#gender").val(); var varracecode = $("#racecode").val(); var varage = $("#age").val(); $.ajax({ method: "post", url: "category2.php", data: {gender:vargender,racecode:varracecode,age:varage} }) .done(function(data){ $("#categories").val(data); }); }); }); </script>
Code:
<?php include("connection.php"); $gender = $_POST['gender']; $racecode = $_POST['racecode']; $age = $_POST['age']; $query = ("SELECT * FROM tblcategories WHERE '$age' >= age_from AND '$age' <= age_to AND '$racecode' = racecode AND '$gender' = gender"); $result = mysqli_query($connection, $query); $output = ''; while($row = mysqli_fetch_assoc($result)) { $output = $row["category_name"]; echo($output); } ?>
Comment