No data in city table so sign up not working!!
I noticed an issue in your code that if there are no values in the city table inside the ngo database then while sign up the user will not be able to select a location and thereby the form just resubmits and the page reloads erasing the data, and the user doesn't get created.
As a simple fix to this issue, I have modified the ngo.sql to add code for inserting some placeholder location.
Just copy paste this code to your ngo.sql:
-- Added some placeholder values to city table so that the signup page works properly
INSERT INTO city VALUES (2,'Bengaluru');
INSERT INTO city VALUES (3,'Ahmedabad');
No data in city table so sign up not working!!
I noticed an issue in your code that if there are no values in the city table inside the ngo database then while sign up the user will not be able to select a location and thereby the form just resubmits and the page reloads erasing the data, and the user doesn't get created.
As a simple fix to this issue, I have modified the ngo.sql to add code for inserting some placeholder location.
Just copy paste this code to your ngo.sql:
-- Added some placeholder values to city table so that the signup page works properly
INSERT INTO
cityVALUES (2,'Bengaluru');INSERT INTO
cityVALUES (3,'Ahmedabad');