CodeIgniter Forums
Difficult with UPDATE SQL query CI - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: General (https://forum.codeigniter.com/forumdisplay.php?fid=1)
+--- Forum: Lounge (https://forum.codeigniter.com/forumdisplay.php?fid=3)
+--- Thread: Difficult with UPDATE SQL query CI (/showthread.php?tid=74003)



Difficult with UPDATE SQL query CI - dreamweaver - 07-06-2019

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)); 



RE: Difficult with UPDATE SQL query CI - dreamweaver - 07-07-2019

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

Is there anyway I can delete this.


RE: Difficult with UPDATE SQL query CI - InsiteFX - 07-07-2019

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.