Find Jobs
Hire Freelancers

Refactor Part SQL Table, and data

$30-250 USD

Stengt
Lagt ut omtrent 6 år siden

$30-250 USD

Betalt ved levering
the website currently handles student data. and registers attendance, payments and student info, because the business operates in a way that student can be in random classes the developer set it to store the data for the classes in different tables. and now as the student number is around 200. retrieving students became very slow as it is calling 4 tables. As the example of the code snippet below <?php $this->db->or_where("class_id",$class_id); $this->db->or_where("class_id2",$class_id); $this->db->or_where("class_id3",$class_id); $this->db->or_where("class_id4",$class_id); $this->db->or_where("section_id",$section_id); $students = $this->db->get('student')->result_array(); foreach($students as $row):?> and I think this could be normalised to a single table that contains multiple classes and thus reducing the call to 1 table the second thing is payments, seem to be used badly as right now there are about 1200 rows of data which is due to the data entry being all wrong. And I thought it would be better to make an incremented call to retrieve the first 10 rows from the DB. If you would like more information, please don't hesitate to contact me
Prosjekt-ID: 4405209

Om prosjektet

26 forslag
Eksternt prosjekt
Aktiv 6 år siden

Ønsker du å tjene penger?

Fordeler med budgivning på Freelancer

Angi budsjettet og tidsrammen
Få betalt for arbeidet ditt
Skisser forslaget ditt
Det er gratis å registrere seg og by på jobber
26 freelancers are bidding on average $147 USD for this job
Brukeravatar
To rework on the database design for storing the student class details in a single table. To work on the payments table for retrieving data in increments Question: Please provide your site url to have a look at. In which platform the site has been developed ? Approx time to complete: 6 - 7 days (Senior only ) Thanks Gopal
$421 USD om 7 dager
4,7 (646 omtaler)
9,3
9,3
Brukeravatar
Hi I have gone through the details of your project and we find it well within our capabilities. I offer a wide range of services, including Web design, PHP/MySQL web application development, Open sources like Joomla, Os-commerce,vBulletin ,Shopify, Bigcommerce, Magneto ,Zen cart-Drupal , android and IOS , I can create and deliver the project as per the information.I have skilled, expert programmers I'm very excited to assist you in making your Sites successful – please feel free to contact me directly to discuss this position further. Thanks
$194 USD om 7 dager
4,7 (535 omtaler)
8,5
8,5
Brukeravatar
I will Refactor Part SQL Table, and data.I will start it right now Codeigniter, MySQL, PHP, SQL have 5+ years experience.
$166 USD om 2 dager
5,0 (41 omtaler)
7,1
7,1
Brukeravatar
Hello. My name is Wang Fei. I am web developer. i have just read your job post and I am very interesting your job. I have full skill in mysql,codeignetor... I have experience for 8+ years in web development. I will provide good project for you. regards
$150 USD om 3 dager
5,0 (50 omtaler)
7,0
7,0
Brukeravatar
Hello sir I have 6 years experience in Codeigniter, MySQL, PHP, SQL please award me this project we will do it in 1 days please contact me on chat for discuss
$50 USD om 3 dager
4,8 (136 omtaler)
7,4
7,4
Brukeravatar
Greetings!!! I can start immediately I'm a professional Web developer with more than 6 Years experience in php, laravel, magento, wordpress and all types of designing work. I have very good Knowledge and clear understanding of online store websites.
$138 USD om 10 dager
4,9 (66 omtaler)
5,8
5,8
Brukeravatar
Hello, I saw your post and I am interested in the project. Do you have a development instance of the same app ? Kind Regards John
$133 USD om 4 dager
4,7 (58 omtaler)
5,1
5,1
Brukeravatar
Hi, I am really interested to work on this project, You database needs to be normalized, I would like to discuss with you more details, please come on chat for more info; Skills: Codeigniter, MySQL, PHP, SQL We can do a great JOB. let s discuss Contact me; Thanks
$100 USD om 7 dager
4,7 (40 omtaler)
4,7
4,7
Brukeravatar
A proposal has not yet been provided
$222 USD om 3 dager
4,9 (18 omtaler)
4,5
4,5
Brukeravatar
5 Reasons why you should hire me for your custom website and Application Development. 1. Available 24/7 upon your request 2. Delivery on-time with 100% satisfaction 3. Always think beyond boundaries and provide user friendly solution 4. Provide excellence with commitment 5. Most important, Free technical support for lifetime. Thank you
$222 USD om 4 dager
4,2 (19 omtaler)
4,8
4,8
Brukeravatar
A proposal has not yet been provided
$100 USD om 3 dager
4,5 (168 omtaler)
4,8
4,8
Brukeravatar
I am a technical business analyst with 15 years experience in database design and development (though primarily in SQL server). I have designed and built numerous custom DBs, and complex database integrations. Including the back-end database (including design, views, stored procedures, etc.) for e-commerce. I would love to chat further about your project!
$133 USD om 3 dager
5,0 (4 omtaler)
2,4
2,4
Brukeravatar
A proposal has not yet been provided
$154 USD om 3 dager
5,0 (2 omtaler)
2,3
2,3
Brukeravatar
Dear, I’d like to be considered for your writing position. I’m a Web Developer who is specialized in web application development . I highly value professionalism and hold myself strictly accountable to represent my client’s brand. I aim to form a long-term working relationship. I have 1+year strong web development skills, mainly using WordPress for content management and Php and Javascript for web application development. I’m an all rounder with both front-end and back-end development skills. My work has been primarily focussed on: • Web application development with a combination of: • HTML • CSS and SASS • PHP • MySQL AND Microsoft SQL • JavaScript • jQuery • Website deployment using open-source content management systems such as WordPress. • Web application development using the Php framework and Javascript I’m a WordPress expert and have developed sites using advanced WordPress functionality, including: • multiple post types and taxonomies • lots of custom templates • custom loops and widgets • AJAX and jQuery • custom meta and options • admin tweaks • and more. I’ve also worked with: • BuddyPress • SMS integration • custom API’s • complex forms • maps and geocoding • custom email digests • and WordPress networks/multisite. Please kindly suggest your requirement what change you want. I able do that. Regards Hinglaj singh Rajawat
$145 USD om 3 dager
5,0 (2 omtaler)
0,8
0,8
Brukeravatar
Hello, This is in response to your job notification for the position of Java Professional for your project. I have been working as a Java developer for the last 6+ years with a software firm and mentioned below are some of my achievements in this role: - Designed and developed a conversion plan for 100+ Uniface modules into equivalent Java/J2EE. - Managed a project team developing a Java/MySQL based web application/Window Application - Converted a user based web application to a Java/J2EE application for better performance. I’m well versed with: - Designing database architecture and server scripting - Studying and establishing connectivity with network systems, search engines, and information servers. - Developing knowledge and understanding of the technical environment including program compilation, file structures and program interfaces in the Java EE environment. I have a full understanding of Designing and development of Java Technology. Expertise in JSP/Servlet/Collection/JDBC , Framework - Spring/Hibernate, API -iText/POI/iPerf, Database(Oracle/MySQL/ PostgreSQL/MongoDB), Should you need any more details, please do let me know. Thanking you for your time and looking forward to hear from you. Regards Vivek
$80 USD om 10 dager
5,0 (3 omtaler)
0,9
0,9
Brukeravatar
Hello Thanks !!.We have closely analyzed your requirement and the its look pretty clear and interesting so far, it would be great if can discuss the same over chat to make it more clear .
$166 USD om 2 dager
0,0 (0 omtaler)
0,0
0,0
Brukeravatar
Hi! I would like to know what exactly your problem is, because I've once worked in company which handled data around 500k - 1m rows, and I am involved for redesigning the db used. Can we discuss further over chat? Maybe I can help you. Looking forward to your answer!
$166 USD om 6 dager
0,0 (0 omtaler)
0,0
0,0

Om klienten

UNITED KINGDOMs flagg
london, United Kingdom
5,0
1
Betalingsmetode bekreftet
Medlem siden apr. 6, 2013

Klientbekreftelse

Takk! Vi har sendt deg en lenke for at du skal kunne kreve din gratis kreditt.
Noe gikk galt. Vær så snill, prøv på nytt.
Registrerte brukere Publiserte jobber
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Forhåndsvisning innlasting
Tillatelse gitt for geolokalisering.
Påloggingsøkten din er utløpt og du har blitt logget ut. Logg på igjen.