i am new to php,js and ajax, i am trying to display data from database with ajax but it doesn't seem to be working(console.log isn't executing). can anyone say what is wrong with the code?
at first i though jquery library isn't properly loaded but now i have included jquery library just above the function html/-
<div class="dropdown-menu" id="studentNames">
<a class="dropdown-item" href="#">Action</a>
<?php
$conn=connectDB();
$sql = "SELECT * FROM students";
$result = $conn-> query($sql) or die('error'.mysqli_error($conn));
if($result->num_rows>0){
while($row=$result->fetch_assoc()){
echo "<p class='dropdown-item' onClick=myfunction('$row[name]')>"."$row[name]"."</p><br>";
}
}
?>
js code/-
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.4.1/jquery.min.js"</script>
<script>
function myfunction(name){
$(document).ready(function(){
$.ajax({
url:"showStudents.php", //the page containing php script
type: "post", //request type,
dataType: 'json',
data: {
registration: "success",
name: name
},
success:function(){
console.log("data");
}
});
});
}
php code/-
if(isset($_POST['registration'])&&$_POST['registration']== "success"){
$regstration = $_POST['registration'];
$name = $_POST['name'];
$array = array();
$conn = connectDB();
$sql = "SELECT * FROM students where name='$name'";
$result = $conn-> query($sql) or die('error'.mysqli_error($conn));
if($result->num_rows>0){
while($row=$result->fetch_assoc())
{
array_push($array,$row['name'],$row['branch']);
}
echo $array;
}
}