How to read database using PHP

Question

I have a table named classes and a field named subjects. I want to get each subject in the database in to multiple php variables or a simple array

Answer 1

Something like this, obviously you will need to alter some info:

$mysqli = my_sqli_connect("localhost", "joeblogs", "password", "testDB");

$sql = "SELECT subject FROM classes";
$res = mysqli_query($mysqli, $sql);

echo $res;

Answer 2

google.

Answer 3

thanks @bagshot