Problem with Mootools Ajax request and submitting a form

Posted by Arwed on Stack Overflow See other posts from Stack Overflow or by Arwed
Published on 2011-03-02T14:19:46Z Indexed on 2011/03/02 15:25 UTC
Read the original article Hit count: 285

Filed under:
|
|
|

Hello. This is my problem:

I have a table with content comming from a database. Now i tryed to realize a way to (a) delete rows from the table (b) edit the content of the row "on the fly". (a) is working perfectly (b) makes my head smoking!

Here is the complete Mootools Code:

<script type="text/javascript">
window.addEvent('domready', function() {
$('edit_hide').slide('hide');
var saf = new Request.HTML(
{
    url: 'termin_safe.php',
    encoding: 'utf-8',  
    onComplete: function(response)
    {
    document.location.href='';
    }
});
var req = new Request.HTML(
{
    url: 'fuss_response.php',
    encoding: 'utf-8',
    onComplete: function(response)
    {
    document.location.href='';
    }
});
var eDit = $('edit_hide'); 
var eD = new Request.HTML(
{
    url: 'fuss_response_edit.php',
    update: eDit,
    encoding: 'utf-8',
    onComplete: function(response)
    {
    $('sst').addEvent( 'click', function(e){
      e.stop();
    saf.send();
    });
    }
});
$$('input.edit').addEvent( 'click', function(e){
      e.stop();
    var aID = 'edit_', bID = '', cID = 'ed_';
    var deleteID = this.getProperty('id').replace(aID,bID); 
    var editID = $(this.getProperty('id').replace(aID,cID));
      eD.send({data : "id=" + deleteID});
      $('edit_hide').slide('toggle');
    });
$$('input.delete').addEvent( 'click', function(e){
      e.stop();
    var aID = 'delete_', bID = '';
    var deleteID = this.getProperty('id').replace(aID,bID); 
      new MooDialog.Confirm('Soll der Termin gelöscht werden?', function(){
        req.send({data : "id=" + deleteID}); 
      }, function(){
      new MooDialog.Alert('Schon Konfuzius hat gesagt: Erst denken dann handeln!');
      });  
    });
});
</script>

Here the PHP Part that makes the Edit Form:

<?php

$cKey = mysql_real_escape_string($_POST['id']);

$request = mysql_query("SELECT * FROM fusspflege WHERE ID = '".$cKey."'");
  while ($row = mysql_fetch_object($request))
    {
    $id = $row->ID;
    $name = $row->name;
    $vor = $row->vorname;
    $ort = $row->ort;
    $tel = $row->telefon;
    $mail = $row->email;
    }
echo '<form id="termin_edit" method="post" action="">';
echo '<div><label>Name:</label><input type="text" id="nns" name="name" value="'.$name.'"></div>';
echo '<div><label>Vorname:</label><input type="text" id="nvs" name="vorname" value="'.$vor.'"></div>';
echo '<div><label>Ort:</label><input type="text" id="nos" name="ort" value="'.$ort.'"></div>';
echo '<div><label>Telefon:</label><input type="text" id="nts" name="telefon" value="'.$tel.'"></div>';
echo '<div><label>eMail:</label><input type="text" id="nms" name="email" value="'.$mail.'"></div>';
echo '<input name="id" type="hidden" id="ids" value="'.$id.'"/>';
echo '<input type="button" id="sst" value="Speichern">';
echo '</form>';
?>

And last the Code of the termin_safe.php

$id = mysql_real_escape_string($_POST['id']);
$na = mysql_real_escape_string($_POST['name']);
$vn = mysql_real_escape_string($_POST['vorname']);
$ort = mysql_real_escape_string($_POST['ort']);
$tel = mysql_real_escape_string($_POST['telefon']);
$em = mysql_real_escape_string($_POST['email']);  
$score = mysql_query("UPDATE fuspflege SET name = '".$na."', vorname = '".$vn."', ort = '".$ort."', telefon = '".$tel."', email = '".$em."' WHERE ID = '".$id."'");

As far as i can see the request does work but the data is not updated! i guess somethings wrong with the things posted For any suggestions i will be gladly happy!

© Stack Overflow or respective owner

Related posts about php

Related posts about AJAX