Hello, I really need help, so when I was running this in my local server it was working fine, but once I uploaded to Hostgator is giving me this error:
[21-Jul-2020 16:53:55 America/Chicago] PHP Fatal error: Uncaught Error: Call to a member function prepare() on null in /home4/l3mxta7i/plantsapp.tuiglesia.online/php/data.php:18
Stack trace:
#0 /home4/l3mxta7i/plantsapp.tuiglesia.online/proceso/add_new.php(53): loadFamilias()
#1 {main}
thrown in /home4/l3mxta7i/plantsapp.tuiglesia.online/php/data.php on line 18
The Code in data.php is =
`<?php
require 'fills_connect.php';
if(isset($_POST['aid'])) {
$db = new DbConnect;
$conn = $db->connect();
$stmt = $conn->prepare("SELECT * FROM ajaxplant_type WHERE family_id = " . $_POST['aid']);
$stmt->execute();
$plantas = $stmt->fetchAll(PDO::FETCH_ASSOC);
echo json_encode($plantas);
}
function loadFamilias() {
$db = new DbConnect;
$conn = $db->connect();
$stmt = $conn->prepare("SELECT * FROM ajaxdata_family");
$stmt->execute();
$familias = $stmt->fetchAll(PDO::FETCH_ASSOC);
return $familias;
}
if(isset($_POST['diay'])) {
$db = new DbConnect;
$conn = $db->connect();
$stmt = $conn->prepare("SELECT * FROM ajax_tipo WHERE id_process = " . $_POST['diay']);
$stmt->execute();
$procesos = $stmt->fetchAll(PDO::FETCH_ASSOC);
echo json_encode($procesos);
}
function loadProcedimiento() {
$db = new DbConnect;
$conn = $db->connect();
$stmt = $conn->prepare("SELECT * FROM ajax_process");
$stmt->execute();
$acciones = $stmt->fetchAll(PDO::FETCH_ASSOC);
return $acciones;
}
?>
The Code in line 53 in add_new.php is=
<?php
require '../php/data.php';
$familias = loadFamilias();
var_dump($familias);exit;
foreach ($familias as $family) {
echo "<option id='".$family['id']."' value='".$family['id']."'>".$family['family']."</option>";
}
?>`
How Can I fix this?