UPLOAD query mySQL

Question

I am here with another problem.

I am trying to do an UPLOAD query to my database and even though no problem appeared after the process, in my database nothing happened no record was changed.

Where could the problem be?

Here my code:

error_reporting(E_ALL);
session_start();

include('link.php');


$_SESSION ['id_user'];

$UserId=$_SESSION ['id_user'];

  $profileUsername= $link->real_escape_string($_POST['username']);
  $profilePassword= $link->real_escape_string($_POST['password']);
  $profileConfPassword= $link->real_escape_string($_POST['confirm_password']);
  $profileAddress= $link->real_escape_string($_POST['address']);
  $profilePostcode= $link->real_escape_string($_POST['postcode']);
  $profileTown= $link->real_escape_string($_POST['town']);
  // $country= $link->real_escape_string($_POST['country']);
  $profileTel= $link->real_escape_string($_POST['telephone']);
  $profileEmail= $link->real_escape_string($_POST['email']);


  $sqlUpdate="update customers set address= $profileAddress, postcode=$profilePostcode, town=$profileTown, telephone=$profileTel, 
   email=$profileEmail, username=$profileUsername, password=$profilePassword, confirm_password=$profileConfPassword
  
where id_costumer=".$UserId;


   echo $sqlUpdate;


  $link->query($sqlUpdate);

Thanks in advance.

Fanjo

Ardit Meti · Answer 1 · 2016-05-16T15:39:35.320

0

The values of those fields should be surrounded with ' single-quotes* like address='$profileAddress'

edited May 16 '16 at 15:39

answered May 16 '16 at 15:20

Ardit Meti

571
5
22

1

*"single-brackets"* ? Those are called "quotes", not "brackets". – Funk Forty Niner May 16 '16 at 15:21
I tried with single-brackets too but i doesn't work. – Fanjo May 16 '16 at 15:22

UPLOAD query mySQL

1 Answers1