Ajax chained dropdown not loading/working correctly on the LIVE server-CodePudding

The

Here is the getStates.php file code:

<?php use App\Session; use App\Login; use App\Location; require_once("../../../vendor/autoload.php"); $objSession = new Session(); if(!$objSession->isLogged()) { Login::redirectTo("/login"); } $country_id = $_GET['country_id']; if(isset($_GET['country_id'])) { $objLocation = new Location(); echo json_encode($getStates = $objLocation->getStates($country_id)); }

and here is the getCities.php file code:

<?php use App\Session; use App\Login; use App\Location; require_once("../../../vendor/autoload.php"); $objSession = new Session(); if(!$objSession->isLogged()) { Login::redirectTo("/login"); } $state_id = $_GET['state_id']; $country_id = $_GET['country_id']; if(isset($_GET['state_id']) && isset($_GET['country_id'])) { $objLocation = new Location(); echo json_encode($getCities = $objLocation->getCities($state_id, $country_id)); }

and this is the code in the Location class that fetches the data:

public function getStates(string $id): ?string { $sql = "SELECT `id`, `name` FROM {$this->table_3} WHERE `country_id` = '". $this->escape($id) ."' ORDER BY `name` ASC"; $result = $this->fetchAll($sql); return json_encode($result); } public function getCities(string $state, string $country): bool|string { $sql = "SELECT `id`, `name` FROM {$this->table_4} WHERE `state_id` = '". $this->escape($state) ."' AND `country_id` = '". $this->escape($country) ."' ORDER BY `name` ASC"; $result = $this->fetchAll($sql); return json_encode($result); }

CodePudding user response：

Hi I think it could be the $.ajax AND the echo json_decode the issue....

I made my own AJAX function that I share in github https://github.com/jintor/stubajax

async function stubajax (divid,phphat,postix = [],pend = 'html') { var pcache = (Math.floor(Math.random() * 100000000) 1); postix["preventcache"] = pcache; // prevent browser caching postix["divid"] = encodeURIComponent(divid); postix["mojax_height"] = encodeURIComponent($(window).height()); postix["mojax_width"] = encodeURIComponent($(window).width()); // if you need to send cookies postix["cookies"] = decodeURIComponent(document.cookie); // if you need to send localStorage or sessionStorage stuff for (var i = 0; i < localStorage.length; i ){ postix[localStorage.key(i)] = localStorage.getItem(localStorage.key(i)); } for (var i = 0; i < sessionStorage.length; i ){ postix[sessionStorage.key(i)] = sessionStorage.getItem(sessionStorage.key(i)); } await fetch(phphat "?pcache=" pcache, { method: "POST", body: JSON.stringify(Object.assign({}, postix)), headers: {"Content-type": "application/json; charset=UTF-8"} }).then( response => { return response.text(); }).then( html => { switch ( pend ){ case 'append' : $("#" divid).append(html); break; case 'prepend' : $("#" divid).prepend(html); break; default : $("#" divid).html(html); break; } }).catch( err => console.log(err) ); }

AND YOU USE IT LIKE THIS

<input onchange="stubajax (\'div_id_that_will_reseive_the_ajax_message\',\'/path/to_php.php\',{\'extra1\':this.value},'html');

On the PHP side : a the end simply echo (WITHOUT json_encode)....

CodePudding user response：

So, I have asked on the comments and you have provided... here is what I think is happening... and what I think you should do.

your method getCities on the Location::class is returning a boolean... and sometimes a string...

json_encode will only return false on failure, this means json_encode has failed on encoding your sql result...

you can use json_last_error() and json_last_error_msg() to debug your json_encode() problem

you can find the documentation here

You can debug your problem on Local but, please make sure your local machine is running the same things on the live server, to replicate the error...

PHP version

Database Data

MySql Version (But I don't think it's necessary)

Browser (but just for testing, app should work on all browser)

if you can't replicate the error, you need to do it LIVE. (please be very careful, this should be your LAST RESORT)

I could not provide a specific answer because I don't know if $this->fetchAll() only returns an array or maybe sometimes it returns an error message...

I have provided you this answer, because your main concern on this question is why your program returning a simple false value...

for example in some cases it works fine for all 3 but for some cases it just does not load anything and in the console I am seeing a simple false and nothing else.