if.. else statement in php won't execute

Question

nadiam 0 Posting Pro in Training

11 Years Ago

So as the title entails, my if else statemnt in php won't execute. i mean i would undrstand if the 'if' didn't execute but it didn't even read the else statement. so when i submit nothing happens.

<?php
session_start();

if(isset($_POST['jansave']))
{
    $basic = $_POST['basic'];
    $allowance = $_POST['allowance'];
    $bonus = $_POST['bonus'];
    $epf = $_POST['epf'];
    $asb = $_POST['asb'];
    $royalty = $_POST['royalty'];
    $sub = $_POST['sub'];
    $div = $_POST['div'];
    $others = $_POST['others'];

    if($basic&&$allowance&&$bonus&&$epf&&$asb&&$royalty&&$sub&&$div&&$others)
    {
        require "connect.php";

        $total=($basic + $allowance + $bonus + $epf + $asb + $royalty + $sub + $div + $others);
        $query=("INSERT INTO january VALUES ('$basic', '$allowance', '$bonus', '$epf', '$asb', '$royalty', '$sub', '$div', '$others', '$total')");
        $result=mysql_query($query);
        if($result)
        {
            echo "<b>Your Total Income is $total</b>";
        }
    }
    else
    {
        echo ('<script type="text/javascript">alert("Sorry!");</script>');
    }

}

?>

html code:

<form method="post" action="income.php">
        <div style="height:0px;"><input type="submit" value="Save" class="save" name="jansave"></div>
        <table border="1" rules="groups" cellpadding="10px;" class="tableincome">
        <thead>
            <th>Monthly Salary</th>
            <th></th>
            <th>RM</th>
        </thead>
        <tr>
            <td>Basic Salary</td>
            <td></td>
            <td><center><input type="text" name="basic" size="11" placeholder="0" value="<?php if(isset($_POST['basic'])){echo htmlentities($_POST['basic']);} ?>"></center></td>
        </tr>
        <tr>
            <td>Fixed Allowance</td>
            <td></td>
            <td><center><input type="text" name="allowance" size="11" placeholder="0" value="<?php if(isset($_POST['allowance'])){echo htmlentities($_POST['allowance']);} ?>"></center></td>
        </tr>
        <tr>
            <td>Bonus</td>
            <td></td>
            <td><center><input type="text" name="bonus" size="11" placeholder="0" value="<?php if(isset($_POST['bonus'])){echo htmlentities($_POST['bonus']);} ?>"></center></td>
        </tr>
        <thead>
            <th>OTHER SOURCE OF INCOME</th>
            <th></th>
            <th>RM</th>
        </thead>
        <tr>
            <td>EPF</td>
            <td></td>
            <td><center><input type="text" name="epf" size="11" placeholder="0" value="<?php if(isset($_POST['epf'])){echo htmlentities($_POST['epf']);} ?>"></center></td>
        </tr>
        <tr>
            <td>ASB</td>
            <td></td>
            <td><center><input type="text" name="asb" size="11" placeholder="0" value="<?php if(isset($_POST['asb'])){echo htmlentities($_POST['asb']);} ?>"></center></td>
        </tr>
        <tr>
            <td>Dividen/Interest(AHB/TABUNG HAJI/etc)</td>
            <td></td>
            <td><center><input type="text" name="div" size="11" placeholder="0" value="<?php if(isset($_POST['div'])){echo htmlentities($_POST['div']);} ?>"></center></td>
        </tr>
        <tr>
            <td>Royalty</td>
            <td></td>
            <td><center><input type="text" name="royalty" size="11" placeholder="0" value="<?php if(isset($_POST['royalty'])){echo htmlentities($_POST['royalty']);} ?>"></center></td>
        </tr>
        <tr>
            <td>Subletting/Rent</td>
            <td></td>
            <td><center><input type="text" name="sub" size="11" placeholder="0" value="<?php if(isset($_POST['sub'])){echo htmlentities($_POST['sub']);} ?>"></center></td>
        </tr>
        <tr>
            <td>Others(Unit Trust/Emas/IPO/etc)</td>
            <td></td>
            <td><center><input type="text" name="others" size="11" placeholder="0" value="<?php if(isset($_POST['others'])){echo htmlentities($_POST['others']);} ?>"></center></td>
        </tr>
        </table>
        </form>

could someone please point out my utterly stupid mistake that i did? coz the php code was fine yesterday then i had to redo some coding and today it aint working.

php programming-construct

5 Contributors
13 Replies
342 Views
23 Hours Discussion Span
Latest Post 11 Years Ago Latest Post by nadiam

pzuurveen 90 Posting Whiz in Training

11 Years Ago

are you sureif(isset($_POST['jansave'])) is true?
if not the script exit whitout output
is 'jansave' the name of your submit-button?

start with var_dump($POST) to check

diafol

11 Years Ago

Are you talking about this if...

if($basic&&$allowance&&$bonus&&$epf&&$asb&&$royalty&&$sub&&$div&&$others)

? I believe that's the one with the else.

Anyway, do you really want such an annoying thing as a js alert? Can't you just post a message to the screen?

JorgeM 958 Problem Solver

11 Years Ago

The problem seems be related to your DB connection and/or query. When I test out your code removing the DB related code, the If..else block executes as expected. If I fill in all of the values in your form, the if produces true. If i leave out any of the input elements, it returns false.

diafol

11 Years Ago

I'm with Jorge here. The only thing I can think of is that the query is being run, but it's not returning a valid resource ($result).

Try this...

    if($result)
    {
        echo "<b>Your Total Income is $total</b>";
    }else{
        echo "bad mysql stuff";
    }

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

nadiam 0 Posting Pro in Training · Answer 1 · 2013-11-12T15:09:12+00:00

pzuurveen: yea 'jansave' is the name. i did $var_dump and its okay, i mean it prints wtv value i put in the text field.

diafol: yeap thats the if. yeah it kinda is annoying huh?? will c what i can do

nadiam 0 Posting Pro in Training · Answer 2 · 2013-11-12T15:09:51+00:00

nadiam 0 Posting Pro in Training

11 Years Ago

any ideas?

nadiam 0 Posting Pro in Training · Answer 3 · 2013-11-12T15:30:48+00:00

nadiam 0 Posting Pro in Training

11 Years Ago

alright. will check it out now. thanks JorgeM

nadiam 0 Posting Pro in Training · Answer 4 · 2013-11-12T16:14:09+00:00

i really have no clue here guys. i've run the system from registration page and all the db related stuff is good until this particular part. and the db related coding are practically the same. :( help this is my final year project

JorgeM 958 Problem Solver Team Colleague Featured Poster · Answer 5 · 2013-11-12T16:32:38+00:00

Again, the problem appears to be related to the DB portion of your code. Here is your code with the DB components removed. It works as expected...

<?php
session_start();
if(isset($_POST['jansave']))
{
    $basic = $_POST['basic'];
    $allowance = $_POST['allowance'];
    $bonus = $_POST['bonus'];
    $epf = $_POST['epf'];
    $asb = $_POST['asb'];
    $royalty = $_POST['royalty'];
    $sub = $_POST['sub'];
    $div = $_POST['div'];
    $others = $_POST['others'];
    if($basic&&$allowance&&$bonus&&$epf&&$asb&&$royalty&&$sub&&$div&&$others)
    {
        $total=($basic + $allowance + $bonus + $epf + $asb + $royalty + $sub + $div + $others);

            echo ("<b>Your Total Income is $total</b>");    
    }
    else
    {
        echo ("<b>Please fill out the entire form.</b>");
    }
}
?>
<!doctype html>
<html>
<head>
        <title>Demo</title>
        </head>
        <body>
        <form method="post" action="income.php">
        <div style="height:0px;"><input type="submit" value="Save" class="save" name="jansave"></div>
        <table border="1" rules="groups" cellpadding="10px;" class="tableincome">
        <thead>
            <th>Monthly Salary</th>
            <th></th>
            <th>RM</th>
        </thead>
        <tr>
            <td>Basic Salary</td>
            <td></td>
            <td><center><input type="text" name="basic" size="11" placeholder="0" value="<?php if(isset($_POST['basic'])){echo htmlentities($_POST['basic']);} ?>"></center></td>
        </tr>
        <tr>
            <td>Fixed Allowance</td>
            <td></td>
            <td><center><input type="text" name="allowance" size="11" placeholder="0" value="<?php if(isset($_POST['allowance'])){echo htmlentities($_POST['allowance']);} ?>"></center></td>
        </tr>
        <tr>
            <td>Bonus</td>
            <td></td>
            <td><center><input type="text" name="bonus" size="11" placeholder="0" value="<?php if(isset($_POST['bonus'])){echo htmlentities($_POST['bonus']);} ?>"></center></td>
        </tr>
        <thead>
            <th>OTHER SOURCE OF INCOME</th>
            <th></th>
            <th>RM</th>
        </thead>
        <tr>
            <td>EPF</td>
            <td></td>
            <td><center><input type="text" name="epf" size="11" placeholder="0" value="<?php if(isset($_POST['epf'])){echo htmlentities($_POST['epf']);} ?>"></center></td>
        </tr>
        <tr>
            <td>ASB</td>
            <td></td>
            <td><center><input type="text" name="asb" size="11" placeholder="0" value="<?php if(isset($_POST['asb'])){echo htmlentities($_POST['asb']);} ?>"></center></td>
        </tr>
        <tr>
            <td>Dividen/Interest(AHB/TABUNG HAJI/etc)</td>
            <td></td>
            <td><center><input type="text" name="div" size="11" placeholder="0" value="<?php if(isset($_POST['div'])){echo htmlentities($_POST['div']);} ?>"></center></td>
        </tr>
        <tr>
            <td>Royalty</td>
            <td></td>
            <td><center><input type="text" name="royalty" size="11" placeholder="0" value="<?php if(isset($_POST['royalty'])){echo htmlentities($_POST['royalty']);} ?>"></center></td>
        </tr>
        <tr>
            <td>Subletting/Rent</td>
            <td></td>
            <td><center><input type="text" name="sub" size="11" placeholder="0" value="<?php if(isset($_POST['sub'])){echo htmlentities($_POST['sub']);} ?>"></center></td>
        </tr>
        <tr>
            <td>Others(Unit Trust/Emas/IPO/etc)</td>
            <td></td>
            <td><center><input type="text" name="others" size="11" placeholder="0" value="<?php if(isset($_POST['others'])){echo htmlentities($_POST['others']);} ?>"></center></td>
        </tr>
        </table>
        </form>
        </body>
</html>

Here is a working demo of this sample code (minus the DB component)... >> http://itg.somee.com/dw/dw-467335/

bertha32 0 Newbie Poster · Answer 6 · 2013-11-12T20:11:45+00:00

When I test out your rule eliminating the DB related rule, the If..else block carries out as expected.

nadiam 0 Posting Pro in Training · Answer 7 · 2013-11-13T06:37:56+00:00

haih.. yeah its a db problem. and i really don't know how to fix it. but thanks for the input guys.

nadiam 0 Posting Pro in Training · Answer 8 · 2013-11-13T06:39:02+00:00

so since now its a db prob ill just mark this discussion as solved.

nadiam 0 Posting Pro in Training · Answer 9 · 2013-11-13T13:34:53+00:00

just to let anyone know i solved the problem and it was actually the naming of the variable. i mean i had to change

$div = $_POST['div'];

to

$dividend = $_POST['dividend'];

and it worked. im not really sure y. maybe it conflicted with the <div>'s i already had.