Jump to content

Newbie Ajax question


vinbrutus

Recommended Posts

I'm quiet new with Ajax and php.

 

I've created a table and now a want to be able to delete an entire row with a delete button. But offcourse nothing happens when i click on the button  :shrug:

 

Here i create the table, its not the entire code

 

<script src="ajax_framework.js" language="javascript"></script>

//MYSQL Statement
    $select = "SELECT * FROM `vliegers`";
    //Plaats query in pointer
    $query = mysql_query($select);

    //While-lus met query die alles in html-tabel zet
    echo "<table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" id=\"table\" class=\"tinytable\">";

   echo"<thead>
                <tr>
                    <th class=\"nosort\"><h3>ID</h3></th>
            
                    <th><h3>Naam</h3></th>
                    <th><h3>Type</h3></th>
				<th><h3>Fabrikant</h3></th>
				<th><h3>Schaal</h3></th>
                    <th><h3>Kitnr</h3></th>
                    <th><h3>Magazine</h3></th>
				<th><h3> Verwijder</h3><th>
                  
                </tr>
            </thead>";
   echo "<tbody>";
    while ($qry = mysql_fetch_array($query)) {


        echo "<tr><td>";

        echo $qry['id'];
        echo "</td><td>";
        echo $qry['naam'];
        echo "</td><td>";
        echo $qry['type'];
        echo "</td><td>";
			 echo $qry['fabrikant'];
        echo "</td><td>";
			 echo $qry['schaal'];
        echo "</td><td>";
        echo $qry['kitnr'];
        echo "</td><td>";
	echo $qry['magazine'];
	   echo "</td><td>";?>
	      <button type='submit' onclick="javascript:delete(<?=$qry['id']?>);" title='Verwijderen' style='width: 38px;'>
                <img src='delete.png' align='absmiddle'></button>
			<?php


        echo "</td></tr>";
    }
  echo "</tbody>";
    echo "</table>";

 

this is the ajax_framework.js file

 

var http3 = createObject();

function delete($id) {
// Optional: Show a waiting message in the layer with ID login_response
document.getElementById('insert_response').innerHTML = "Just a second..."
// Required: verify that all fileds is not empty. Use encodeURI() to solve some issues about character encoding.

var id = encodeURI(document.getElementById('id').value);


// Set te random number to add to URL request
nocache3 = Math.random();
// Pass the login variables like URL variable
http3.open('get', 'deleteEntry.php?id=' +id+ '&nocache = '+nocache3);
http3.onreadystatechange = deleteReply;
http3.send(null);

}


function deleteReply() {
if(http3.readyState == 4){
var response2 = http3.responseText;
// else if login is ok show a message: "Site added+ site URL".
document.getElementById('insert_response').innerHTML = 'Site added:'+response2;
window.location.reload();
}
}

 

And in the deleteEntry file i have the following code:

 

<!-- Include Database connections info. -->
<?php include('config.php'); 

//<!-- Verify if user exists for login -->

if(isset($_GET['id'])){

$sql="DELETE * FROM vliegers WHERE id= ".mysql_real_escape_string($_GET['id']);
$insertSite= mysql_query($sql) or die(mysql_error());

//<!-- If is set URL variables and insert is ok, show the site name -->

} 
else {
echo 'Error! Please fill all fileds!';
}
?>

 

Can somebody give me a tip in the wright direction? thanks in advance!

 

 

Link to comment
https://forums.phpfreaks.com/topic/265142-newbie-ajax-question/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.