Show button whose value is present in database else hide the button

Question

I have 5 columns in database id, a1, b1, c1 and d1. I want to show button a if the value in database for a1 is not there and if two values eg. c1 and b1 is present in database i want to show buttons for a and d.

Simple thing I want to show the button for that if there is no value in database.

I have tried the it by entering 16 conditions but it take a lot of time and space.

if(($row['a1'] == '') && ($row['b1'] != '') && ($row['c1'] != '') && ($row['d1'] != '')) {
?>
    <form action = "a1.php" method="POST">
        <input type="submit" name="a1" value="a1">
    </form>
<?php
} elseif (($row['b1'] == '') && ($row['a1'] != '') && ($row['c1'] != '') && ($row['d1'] != '')) {
?>
    <form action = "b1.php" method="POST">
        <input type="submit" name="b1" value="b1">
    </form>
<?php       
} elseif (($row['c1'] == '') && ($row['a1'] != '') && ($row['d1'] != '') && ($row['b1'] != '')) {
?>
    <form action = "c1.php" method="POST">
        <input type="submit" name="c1" value="c1">
    </form>
<?php
} elseif (($row['d1'] == '') && ($row['a1'] != '') && ($row['b1'] != '') && ($row['c1'] != '')) {
?>
    <form action = "d1.php" method="POST">
        <input type="submit" name="d1" value="d1">
    </form>
<?php   
}
?>

Is there any other way to do this.

Thanks in advance

please share the code what you've tried so far

Happy Coding
– Happy Coding

2017-02-27 06:09:22 +00:00
Commented Feb 27, 2017 at 6:09 — Happy Coding
– Happy Coding, Commented Feb 27, 2017 at 6:09
I have applied the conditions like this

Mario
– Mario

2017-02-27 06:22:38 +00:00
Commented Feb 27, 2017 at 6:22 — Mario
– Mario, Commented Feb 27, 2017 at 6:22
Does your code work as expected?

Paul Spiegel
– Paul Spiegel

2017-02-27 06:46:28 +00:00
Commented Feb 27, 2017 at 6:46 — Paul Spiegel
– Paul Spiegel, Commented Feb 27, 2017 at 6:46

vikas etagi · Accepted Answer · 2017-02-27 06:32:49Z

3

here is the logic you can try.if you are going for specific row

step1: select the row according to id

$sql =  SELECT * FROM Customers WHERE id=xyx(your preferred id);

step2: fetch a assosiative array.

  $result=mysqli_query($con,$sql);

  // Associative array
 $row=mysqli_fetch_assoc($result);

step2: check for the condition.

 if(isset($row['a1'])){
       echo "<button></button>"
   }

answered Feb 27, 2017 at 6:32

vikas etagi

6351 gold badge13 silver badges15 bronze badges

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

Comments

Alex · Accepted Answer · 2021-03-23 12:59:54Z

-1

echo "<button I'd=btn onClick=function()>call function Doesn't work to call javascript function

answered Mar 23, 2021 at 12:59

Alex

1

1 Comment

Milkmannetje Over a year ago

Hi Alex, welcome to StackOverflow! Could you please elaborate your given answer? It's really short at the moment, and doesn't actually seems to be a good 'answer'.

Collectives™ on Stack Overflow

Show button whose value is present in database else hide the button

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related