Welcome Guest, Not a member yet? Register   Sign In
Update query is altered by safari???
#6

[eluser]bobbob[/eluser]
Thanks for your replies.
I had stripped my code to make the post smaller.
Here is the whole controller:

Code:
function preferred()
    {
        $this->load->helper(array('form', 'url'));
        $this->load->library('form_validation');
        $this->form_validation->set_rules('preferred', 'preferred', 'required|trim|xss_clean');
        if ($this->form_validation->run() == FALSE) {
            echo 'Error';
        }else{
        $newdata = $_POST['preferred'];
        
        $id = $this->session->userdata('uid');
        $this->db->where('id',$id);
        
        $this->db->update('members',$_POST);
        //$this->db->query("UPDATE members SET preferred = '$newdata' WHERE id = '$id'");
        
        $this->session->set_userdata('preferred',$newdata);
        
        echo htmlentities($newdata);;
        
        }
    }
The whole picture may help. This is an ajax call.
the form has one field 'preferred'.

The JS script that sends the info to the controller is:
Code:
function updateit(){
     var url = 'index.php/members/preferred';
     var pars = $('preferred_form').serialize(true);
     var target = 'new_preferred';
     var myAjax = new Ajax.Updater(target, url, {method: 'post', parameters: pars});
}
var pageInit = function() {
   Event.observe('preferred_form', 'submit', function(e) {
      updateit();
      e.stop();
      
   });
}

document.observe('dom:loaded', pageInit);

I got the same results with validation included.
Help. Thanks


Messages In This Thread
Update query is altered by safari??? - by El Forum - 02-12-2009, 01:20 AM
Update query is altered by safari??? - by El Forum - 02-12-2009, 01:44 AM
Update query is altered by safari??? - by El Forum - 02-12-2009, 02:09 AM
Update query is altered by safari??? - by El Forum - 02-12-2009, 07:49 AM
Update query is altered by safari??? - by El Forum - 02-12-2009, 08:41 AM
Update query is altered by safari??? - by El Forum - 02-12-2009, 08:48 AM
Update query is altered by safari??? - by El Forum - 02-12-2009, 08:58 AM
Update query is altered by safari??? - by El Forum - 02-12-2009, 09:07 AM
Update query is altered by safari??? - by El Forum - 02-12-2009, 09:15 AM
Update query is altered by safari??? - by El Forum - 02-12-2009, 09:28 AM
Update query is altered by safari??? - by El Forum - 02-12-2009, 09:38 AM
Update query is altered by safari??? - by El Forum - 02-12-2009, 09:59 AM
Update query is altered by safari??? - by El Forum - 02-12-2009, 10:40 AM
Update query is altered by safari??? - by El Forum - 02-12-2009, 12:01 PM
Update query is altered by safari??? - by El Forum - 02-12-2009, 12:49 PM
Update query is altered by safari??? - by El Forum - 02-12-2009, 04:15 PM
Update query is altered by safari??? - by El Forum - 02-12-2009, 04:23 PM



Theme © iAndrew 2016 - Forum software by © MyBB