Table Join

JOIN or INNER JOIN: Return only those rows when there is at least one match in both tables.

LEFT JOIN: Return all rows from the left table, even if there are no matches in the right table.

RIGHT JOIN: Return all rows from the right table, even if there are no matches in the left table.

OUTER JOIN: Return all the rows of both tables even there is no matches.

Difference between echo() and print()

1) echo is faster than print. Because echo doesn’t have return parameter like print.

2) print behaves like function where echo not.

3) echo can take multiple parameter where print can’t.

NOTE: echo is the prefer method.