Welcome Guest, Not a member yet? Register   Sign In
Difficult with UPDATE SQL query CI
#1

Hi guys, so to be such a bother but I am having trouble with a query which just looks perfect to me.

PHP Code:
$this->forename 'testing';
 
           $this->surname 'testing';
 
           $this->email 'testing';
 
           $this->password 'testing';
 
           $this->address 'testing';
 
           $this->city 'testing';
 
           $this->county 'testing';
 
           $this->country 'testing';
 
           $this->post_code 'testing';
 
           $this->access_level 0;

 
           echo $id;

 
           $this->password password_hash($this->passwordPASSWORD_DEFAULT, ['cost' => 15]);
 
           $sql "UPDATE user SET forename = ?, surname = ?, email = ?, password = ?, address = ?, city = ?, county = ?, country = ?, post_code = ?, access_level = ? WHERE id = ?";
 
           $this->db->query($sql, array($this->forename$this->surname$this->email$this->password$this->address$this->city$this->county$this->country$this->post_code$this->access_level$id)); 
Reply
#2

Sorry guys, I fixed it, there just seems to be something wrong with my browser.

Is there anyway I can delete this.
Reply
#3

It's always best to clear your browser's cache when make changes to code.

Chrome bring up developer Tools F12 and then right click the top right arrow
circle and click on the bottom empty cache and hard reload.
What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )
Reply




Theme © iAndrew 2016 - Forum software by © MyBB