CodeIgniter Migration for Admin Areas (India)

Posted yesterday

Worldwide

Summary

I have an ERP/School Management System built with PHP and CodeIgniter. The application stores address information using normalized relational database tables with foreign key relationships rather than free-text location fields. The countries table has already been populated with approximately 192 countries, so no country data is required. I need a CodeIgniter migration (preferred) or a MySQL SQL seed/insert script that populates the lower administrative levels for India. Existing Database Structure The following tables already exist: countries (already populated) states districts sub_districts These tables are linked using numeric IDs and foreign key relationships. Administrative Hierarchy The hierarchy should follow India's official administrative structure as closely as possible. India State District Sub-district (Tehsil, Taluk, Taluka, Mandal, Block, or the most appropriate official equivalent) The goal is to maintain a consistent four-level hierarchy used throughout the application. Application Flow The address selection process works as follows: User selects a Country. System loads the available States. User selects a State. System loads the corresponding Districts. User selects a District. System loads the available Sub-districts. User enters Address Line 1, Address Line 2, and any additional address details. Only the IDs of these administrative areas are stored within the database. Deliverables Please provide either: A CodeIgniter migration file (preferred) OR A MySQL SQL insert/seed script The deliverable should include: Complete list of Indian States Complete list of Districts Complete list of Sub-districts Correct parent-child relationships Proper foreign key mapping No duplicate records Clean, organized, and maintainable code Requirements Use official government or other well-maintained administrative datasets. Ensure the data is complete, accurate, and up to date. Parent-child relationships must be correctly mapped. The migration or SQL script should run without modification in a standard CodeIgniter project. Please Include in Your Proposal Estimated delivery time Your experience with PHP, CodeIgniter, and MySQL The administrative data source you intend to use Any assumptions made where administrative naming conventions may vary

  • Not Sure
    Hourly
  • < 1 month
    Duration
  • Expert
    Experience Level
  • Remote Job
  • One-time project
    Project Type
Skills and Expertise
Mandatory skills
PHP
MySQL
Web Development
Activity on this job
  • Proposals:15 to 20
  • Last viewed by client:yesterday
  • Interviewing:
    5
  • Invites sent:
    4
  • Unanswered invites:
    2
About the client
Member since Jul 5, 2026
  • South Africa
    7:18 AM

Explore similar jobs on Upwork

Software DeveloperHourly‐ Posted 8 months ago
ASP.NET MVC
Django
Python
AngularJS
JavaScript
jQuery
WordPress
Google Chrome Extension
React
CRM Development
Microsoft Dynamics 365
Microsoft Dynamics CRM
Microsoft Dynamics Development
Microsoft PowerApps
Single Sign-On
Three.js
JavaScript
WordPress
AR Plugin
WooCommerce
3D Modeling

How it works

  • Post a job icon
    Create your free profile
    Highlight your skills and experience, show your portfolio, and set your ideal pay rate.
  • Talent comes to you icon
    Work the way you want
    Apply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
  • Payment simplified icon
    Get paid securely
    From contract to payment, we help you work safely and get paid securely.
Want to get started? Create a profile

About Upwork

  • Rating is 4.9 out of 5.
    4.9/5
    (Average rating of clients by professionals)
  • G2 2021
    #1 freelance platform
  • 49,000+
    Signed contract every week
  • $2.3B
    Freelancers earned on Upwork in 2020

Find the best freelance jobs

Growing your career is as easy as creating a free profile and finding work like this that fits your skills.

Trusted by

  • Microsoft Logo
  • Airbnb Logo
  • Bissell Logo
  • GoDaddy Logo