PHP query Vs Unqork

idnamesalary
23546Anna700000
23452Bintu670000
23453Caddy800000
account

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

Your email address will not be published. Required fields are marked *

More Articles & Posts