so i update my dexie db with my sql db, but the problem is that some of the values are empty
THE PROBLEM IS THAT WHEN I WANT TO PRINT THE VALUE IN PHP IT PRINTS ALL THE VALUES AND THE ONES WHICH ARE ""null"".... how do i fix this??
i am using datatables and i have a few columns which are linked and i still need to see that lets say the fuel col has nothing "" but it musnt show null
db.fuel.put({
department: data[i].department
});
this checks if the value coming from mysql is null then directly changes it to an empty string
url: 'fuel_fetch_null',
headers: { 'X-Requested-With': 'XMLHttpRequest' },
success: function(data) {
//fuel
db = db_open();
data = JSON.parse(data);
var datas = data.data;
for (i in datas) {
if(datas[i].department == null){
datas[i].department = '';
}
db.fuel.put({
id: datas[i].id,
department: datas[i].department
});
}
}
});