id | name | salary |
23546 | Anna | 700000 |
23452 | Bintu | 670000 |
23453 | Caddy | 800000 |
Q1) Get the row which has salary = 700000
PHP
<?php
// for creating connection to database , igonore if already created
$con= new mysqli($servername,$username,$password,$dbname);
// Query to select row which has salary 70000
$sql= "SELECT * FROM account where salary='700000'";
//running the query
$value=$con->query($sql);
//fetching the value to show on page
if($value->num_rows>0){
while($row=$value->fetch_assoc()){
echo "id: " . $row["id"]. " - Name: " . $row["name"]. " Salary: " . $row["salary"]. "<br>";
}
}
?>
Unqork
- Let account be hidden field where all account data is saved
- Select dwf (data work flow) with name dwfGetsingleEntry
- Take input operator with input property Id as account
- filter operator salary= 70000
- from upper output node join output named theSalary
- take one init and trigger that dwf.



Q1) Get the rows which has salary greater than 700000
PHP
<?php
$sql= "SELECT * FROM account where salary>='700000'";
//running the query
$value=$con->query($sql);
//fetching the value to show on page
if($value->num_rows>0){
while($row=$value->fetch_assoc()){
echo "id: " . $row["id"]. " - Name: " . $row["name"]. " Salary: " . $row["salary"]. "<br>";
}
}
?>
Unqork
- Let account be hidden field where all account data is saved
- Select dwf (data work flow) with name dwfGetsingleEntry
- Take input operator with input property Id as account
- filter operator salary>0 70000
- from upper output node join output named theSalary
- take one initializer eg. initStart and trigger that dwf.


Leave a Reply