$mysqli = new mysqli ("localhost","root","","bank");
if( empty($_POST) ){
$result = $mysqli->query("
SELECT
arajark_.*,
varks_.`name` as varks_name,
banker_.`name` as bank_name
FROM
arajark_
LEFT JOIN varks_ ON varks_.id = arajark_.varks_id
LEFT JOIN banker_ ON banker_.id = arajark_.bank_id
-- ORDER BY banker_.`name` DESC
");
$allvarks = $mysqli->query("SELECT * FROM varks_");
$allbanks = $mysqli->query("SELECT * FROM banks_");
}elseif(!empty($_POST) && isset($_POST["_token"])) {
var_dump($_POST['_token']);die;
}
$allresults = array();
?>
-- ORDER BY banker_.`name` DESC
select a.*
,p.payman
,v.name
,vb.name
,vb.price
,vb.expiry_date
,vb.percent
from arajark_ AS a
left join payman_arajark AS p
ON a.ID = p.arajark_id
left join varks_ AS v
ON a.varks_id = v.ID
left join banker_ AS b
ON a.bank_id = b.ID
inner join varks AS vb
ON b.ID = vb.bank_id
AND b.name = vb.name