Laravel Display table product if not exist on quantity table
Clash Royale CLAN TAG #URR8PPP Laravel Display table product if not exist on quantity table In PHP-MySQL I can create this query... $sql = "SELECT * FROM product"; $result = $conn->query($,con, $sql); while($row =mysql_fetch_array($result)) $sqlquantity = "SELECT * FROM quantity where branchid='4' and productid='$row['productid']'"; $resultquantity = $conn->query($,con, $sqlquantity); if (mysqli_num_rows($resultquantity) == 0) echo $row['productname']. "not available in branch" else echo $row['productname']. "available in branch" But how can I do this using Laravel? I have 3 tables +-----------------+ +-----------------+ +----------------+ | product table | | quantity table | | branch table | +-----------------+ +-----------------+ +----------------+ | id | | productid | | id | | productname | | branchid | | branchname | +-----------------+ | quantity | +----------------+ +---------...