the code was properly written with php mysqli but still data was getting fetched so we used pdo for thr task