7 #Connect to the database |
7 #Connect to the database |
8 $connect = mysqli_connect(DBASE_HOST, DBASE_USER, DBASE_PASS, DBASE_NAME); |
8 $connect = mysqli_connect(DBASE_HOST, DBASE_USER, DBASE_PASS, DBASE_NAME); |
9 if (! $connect) { |
9 if (! $connect) { |
10 die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); |
10 die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); |
11 } |
11 } |
|
12 mysqli_set_charset($connect, "utf8" ); |
12 |
13 |
13 // get data and store in a json array |
14 // get data and store in a json array |
14 $query = "SELECT * FROM inventory_fermentables ORDER BY supplier,name"; |
15 $query = "SELECT * FROM inventory_fermentables ORDER BY supplier,name"; |
15 if (isset($_GET['insert'])) { |
16 if (isset($_GET['insert'])) { |
16 // INSERT COMMAND |
17 // INSERT COMMAND |