In Progress

Import attendance

Hi I need to imprt the attendance iin mysql database using codeigniter. below is my table structure and attached excel file

CREATE TABLE `prl_attendence` (

`id` int(11) NOT NULL,

`branch_id` int(11) NOT NULL,

`emp_id` int(11) NOT NULL,

`attendance_date` date NOT NULL,

`in_time` varchar(100) NOT NULL,

`out_time` varchar(100) NOT NULL,

`leave_status` int(11) NOT NULL COMMENT '1=present,0=absent,2=leave,3=swap',

`shift_name` varchar(100) NOT NULL,

`late` varchar(100) NOT NULL,

`overtime` varchar(100) NOT NULL,

`leave_type` int(10) NOT NULL COMMENT '''1''=>''Late'',''2''=>''Short'',''3''=>''Half'',''4''=>''Absent''',

`is_deleted` int(11) NOT NULL,

`deleted_by` int(11) NOT NULL,

`deleted_date` datetime NOT NULL,

`ip_address` varchar(20) NOT NULL,

`created_by` int(11) NOT NULL,

`modified_by` int(11) NOT NULL,

`modified_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,

`created_date` datetime NOT NULL



-- Indexes for dumped tables



-- Indexes for table `prl_attendence`


ALTER TABLE `prl_attendence`



-- AUTO_INCREMENT for dumped tables



-- AUTO_INCREMENT for table `prl_attendence`


ALTER TABLE `prl_attendence`


Skills: PHP, MySQL, Codeigniter, HTML, Software Architecture

See more: i have about 225 emails from which i need to have certain information transferred to an excel sheet there are 4 fields that i ne, logo design studio 4.0, paccad packing designs version 4.0, mobile attendance, zoho attendance, attendance report, zoho people, zoho attendance api, online attendance app, at my attendance, digital attendance, photoshop 4.0, using the design view of website 4.0, dotnet 4.0, expression web 4.0, mvc 4.0, rhinoceros 4.0, silverlight 4.0, 4.0 graphic design shoes, album design 4.0 for photoshop

About the Employer:
( 1 review ) GHAZIABAD, India

Project ID: #26544198

Awarded to:


Hi, I'm a web and Api(Python and Php) developer and have 7 years experience I will provide you quality work according to your instructions. So please award me the project or send me message so that we can discuss it mo More

₹1000 INR in 1 day
(0 Reviews)

8 freelancers are bidding on average ₹969 for this job


Hi I have 5+ years experience in web development . I can make function to import xls according to given table structure . we can discuss more about in chat Thanks

₹1500 INR in 1 day
(23 Reviews)

Hi, I can Import your database , I am Codeigniter and laravel Expert having 10+ years of Experience Message me so we can discuss more. Thanks.

₹600 INR in 1 day
(20 Reviews)

I am indivisual software developer having 7 + years exp in Php,cake,codiegnator and wp,I have completed many web based project in all areas like edu,real estate,insurance,ecommerce. etc.

₹1050 INR in 1 day
(27 Reviews)

Hi professional developer here , i am interested in your project please sent me msg so that we can discuss more i can do this task in few minutes and i am immediately available for your help Thank you

₹1000 INR in 1 day
(2 Reviews)

Hi,  I have gone through project description and understand it very well.  I have working experience in website developments using HTML, CSS, Bootstrap, JavaScript, PHP and phpMyAdmin. I can assure you to give my 100 More

₹1050 INR in 3 days
(2 Reviews)

Hi, I see that you requireto import database. Let us know your details requirements so we could analyze it and start working. I have 7 years experince in PHP, 2.5 years experince in Codeigniter and 4.5 years in laravel More

₹700 INR in 1 day
(1 Review)

I know all the things in SQL because am I studied in engineering college with cs branch and know programming languages.i don't have to change any errors. So, please hire me.

₹850 INR in 2 days
(0 Reviews)