Proper Use of MYSQL UPDATE Function

Question

I am using MySQL query to UPDATE the information in the database.

I tried updating the information from the localhost/phpmyadmin and later on copy the code that was given in the localhost/phpmyadmin.

The problem is that the information/values are not updating in the database.

Below is the code:

<?php

   if(isset($_POST['updateProfile']))
     {
       $newUser = $_POST['newUsername'];
       $newPass = $_POST['newPassword'];
       $newConNum = $_POST['newContactNumber'];
       $newAdd = $_POST['newAddress'];

    include("dbconnect.php");

    //avatarPATH
    $filepath = "avatar/owner-".$_SESSION['username']."-fname-".$_SESSION['fname']."-l_name-".$_SESSION['lname']."-filename-".$_FILES["file"]["name"];

  $checkQuery = "SELECT * FROM `users`.`info` WHERE username = '".$userName."' ";
                $checkResult = $con->query($checkQuery);
                $count = mysqli_num_rows($checkResult);

                    while ($rows = mysqli_fetch_array($checkResult, MYSQLI_ASSOC))

                        {
                            $username = $rows['username'];
                            $userpass = $rows['password'];
                            $firstName = $rows['firstname'];
                            $lastName = $rows['lastname'];
                            $ConNum = $rows['contact_number'];
                            $usrAdd = $rows['user_address'];
                            $avaImgPth = $rows['avatar_image_path'];
                            $adminLvl = $rows['admin_level'];
                        }

                $query = "SELECT * FROM `users`.`info` WHERE username = '".$newUser."' ";
                $queryResult = $con->query($query);
                $result = mysqli_num_rows($queryResult);

                    if($result == 1)
                        {
                            echo $newUser." is already in use";
                        }

                    else
                        {
                            move_uploaded_file($_FILES["file"]["tmp_name"], "avatar/owner-".$_SESSION['username']."-fname-".$_SESSION['fname']."-l_name-".$_SESSION['lname']."-filename-".$_FILES["file"]["name"]);

                            //$updateQuery = "UPDATE `users`.`info` SET `username` = $newUser, `password` = $newPass, `contact_number` = $newConNum , `user_address` = $newAdd, `avatar_image_path` = $filepath WHERE `info`.`username` = '$username' AND `info`.`password` = '$userpass' AND `info`.`f_name` = '$firstname' AND `info`.`l_name` = '$lastname' AND `info`.`admin_level` = '$adminLvl'  AND  `info`.`contact_number` = '$ConNum' AND  AND  `info`.`user_address` = '$usrAdd' AND  `info`.`avatar_image_path` = '$avaImgPth' ";

                            $updateQuery = " UPDATE  `users`.`info` SET  `username` =  '$newUser',`password` =  '$newPass',`f_name` =  '$firstName',`l_name` =  '$lastName',`contact_number` =  '$newConNum',`user_address` =  '$newAdd',`avatar_image_path` =  '$filepath' WHERE  `info`.`username` =  'username' AND  `info`.`password` =  'userpass' AND `info`.`f_name` =  'firstName' AND  `info`.`l_name` =  'lastName' AND  `info`.`admin_level` =$adminLvl AND  `info`.`contact_number` =  '$ConNum' AND  `info`.`user_address` =  '$usrAdd' AND `info`.`avatar_image_path` =  '$avaImgPth' ";

                            echo "Profile successfully UPDATED!";
                        }

            }
    ?>

Thank you so much for your response.

I see following in your query WHERE info.username = 'username' AND info.password = 'userpass' AND info.f_name = 'firstName' AND info.l_name = 'lastName' AND..., username, userpass and other string are they not a variable? is $ missing there? — Lepanto
– Lepanto, Commented Apr 3, 2014 at 5:49
$executeUpdate = mysql_query( $updateQuery, $con); you should try this and refer this link (tutorialspoint.com/mysql/mysql-update-query.htm) and you should must check db connection is working or not.. — jmail
– jmail, Commented Apr 3, 2014 at 6:08
@Lepanto, I just forgot to put $ but when I put them on. The result is still the same. The values are still not updating in the database. — user3437929
– user3437929, Commented Apr 3, 2014 at 6:42

Jenz · Accepted Answer · 2014-04-03 05:50:52Z

2

You forgot to execute the query.

    $updateQuery =" UPDATE  `users`.`info` SET  `username` =  '$newUser',`password` =  '$newPass',`f_name` =  '$firstName',`l_name` =  '$lastName',`contact_number` =  '$newConNum',`user_address` =  '$newAdd',`avatar_image_path` =  '$filepath' WHERE  `info`.`username` =  '$username' AND  `info`.`password` =  '$userpass' AND `info`.`f_name` =  '$firstName' AND  `info`.`l_name` =  '$lastName' AND  `info`.`admin_level` =$adminLvl AND  `info`.`contact_number` =  '$ConNum' AND  `info`.`user_address` =  '$usrAdd' AND `info`.`avatar_image_path` =  '$avaImgPth' ";

    $excuteQuery = $con->query($updateQuery);

edited Apr 3, 2014 at 5:50

answered Apr 3, 2014 at 5:45

Jenz

8,3718 gold badges50 silver badges83 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

user3437929 Over a year ago

I added this $excuteQuery = $con->query($updateQuery); but still it doesn't update any information in the database.

Jenz Over a year ago

Try to echo the query and execute it in database to check whether u r getting any sql errors.

Funk Forty Niner Over a year ago

"You forgot to execute the query with mysql_query()" --- OP is using mysqli_* functions.

user3437929 Over a year ago

Still nothing happens.

Collectives™ on Stack Overflow

Proper Use of MYSQL UPDATE Function

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related