IF/ELSE condition in sql and php

Question

I'm inserting into my database id and hours, which is working successfully. However when i insert a new value for an id that has a previous value, the old val isn't replaced by the new, instead they're kept both. I'm trying to update the function with an if/else statement (commented part). But still the same result. The if/else statement must check first if hours (a column in the table) value is empty, if so then perform sql insert, else perform sql update. Any help please?

if (isset($_POST['submit'])) {
    $hours = $_POST['Hours'];
    $selectid = $_POST['SelectID'];
    $sql1 = "INSERT INTO `editedworkhours` (`id`,`H`) VALUES('$selectid','$hours')";

    $getResult = mysql_query($sql1);
    if (mysql_affected_rows() > 0) {

    } else {

    }

    $tempname = $row['Field'];
    $sql2 = "UPDATE editedworkhours SET H ='" . $_GET["hours"] . "' WHERE IDNumber='" . $_GET["selectid"] . "'";
    $result2 = mysqli_query($con, $sql2);
    if ($con->query($sql2) === TRUE) {
    } else {

    }


}
echo $menu;

First SELECT, then check if exists or not, then do insert or update — Sougata Bose
– Sougata Bose, Commented Aug 3, 2015 at 6:56
@b0s3 i tried this: jsfiddle.net/8jxvy3pe but i'm not sure how to check in the if condition whether the value in cell in column addedwh is null — dan
– dan, Commented Aug 3, 2015 at 6:58

Abdulla Nilam · Accepted Answer · 2015-08-03 07:50:45Z

2

Try this

<?php
    if(isset($_POST['submit']))
    {
        $addedhours = $_POST['AddedHours'];
        $selectaf = $_POST['SelectAF'];

        $sql1="SELECT * FROM editedworkhours WHERE AFNumber='$selectaf' and AddedWH ='$addedhours'";

        $getResult = mysql_query($sql1);
        $count = count($getResult);
        if(!empty($count) || $count==1)
        {
            $tempname = $row['Field'];
            $sql2 = "UPDATE editedworkhours SET AddedWH ='$addedhours' WHERE AFNumber='$selectaf'";
            $result2 = mysql_query($sql2);

            if (isset($result2))
            {
                //Data inserted
            }
            else
            {
                //Insert Failed
                echo '<script>swal("Error", "Something went wrong error");</script>';
            }
            echo '<script>swal("Success", "Changes have been saved", "success");</script>';
        }
        else
        {
            $sql3 = "INSERT INTO editedworkhours (AFNumber,AddedWH) VALUES('$selectaf','$addedhours')";
            $Result =   mysql_query($sql3);
            if(isset($Result))
            {
                echo 'Success';
            }
            else
            {
                echo 'Failed';
            }
        }
    }
    echo $menu;

edited Aug 3, 2015 at 7:50

answered Aug 3, 2015 at 7:05

Abdulla Nilam

39.7k18 gold badges85 silver badges115 bronze badges

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

6 Comments

dan Over a year ago

in your code, the if condition is checking if $count is empty, if so then update?

dan Over a year ago

dear i'm getting now a notice for undifined inde for both selectaf and addedhours

Abdulla Nilam Over a year ago

how you pass this data?? any form data?? <form ...

dan Over a year ago

is it possible to open a chat conv?

Abdulla Nilam Over a year ago

You keep comment it will load automatically. Kindly upload the code

|

Collectives™ on Stack Overflow

IF/ELSE condition in sql and php

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related