How can I pass id="'.$row["courseid"].'"
into the ajax function,
I'm trying data:{'courseid':deleteId}
, but is not working any ideas on how to fix this problem.
<?php
echo "<table width='100%'>";
echo "<tr>
<th>Course name</th>
<th>Delete</th>
<th>Edit</th>
</tr>";
?>
<?php foreach($rows as $row):
echo "<tr>";
echo '<td><a href="#">' . htmlentities($row['coursename'], ENT_QUOTES, 'UTF-8') . '</a></td>';
echo '<td><button onclick="deleteC(' . $row['courseid'] . ')");"><font color="#e70404"> Delete </font> </button></td>';
echo '<td><a class="delete" id="'.$row["courseid"].'">Delette</a></td>';
echo "</tr> ";
endforeach;
echo "</table>";
?>
And this is the ajax function which is in the same page
<script type="text/javascript">
function deleteC(deleteId){
$.ajax({
type: "GET",
url: "deleteCourse.php",
data:{'courseid':deleteId},
success: function(result){
if(result=='correct'){
window.location='index.php';
}else {
window.location='coursesData.php';
}
}
});
}
</script>
This is the deleteCourse.php
<?php
require("connect.php");
if (isset($_GET['courseid']) && is_numeric($_GET['courseid']))
{
$id = $_GET['courseid'];
echo"$courseid";
$con=mysqli_connect("localhost","root","","independentstudyclass");
// Check connection
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
mysqli_query($con,"DELETE FROM courses WHERE courseid=$id");
echo "correct";
mysqli_close($con);
echo "correct";
}
else
{
header ("Location: ../index.php");
}
?>