Find Jobs
Hire Freelancers

AJAX enabled Database frontend (singleuser)

$100-300 USD

In Progress
Posted about 18 years ago

$100-300 USD

Paid on delivery
Hi, I am looking for a web-programmer to code a new relational-database frontend for me, to enable me to work faster. Requirements: PHP5 or Perl, prototype javascript library (or similiar open source library), MySQL4/5, proper enconding(UTF-8). You may use and include PEAR and open source librarires, frameworks... The task: The database itself is quite primitive. Less than 2000 datasets. Just one user. DB structure maybe changed into completely relational structure. The fields are text, HTML (with js editor), dates and time, select, multiple select, binary selects (yes/no). You will work with an empty table. Tasks: 1. Display all records, edit individual record, delete individual record. 2. Provide real-time editing (without loading a new webpage), also in list view of all records. (e.g consider a yes/no field: upon click, the value should be changed for yes to no and vice versa. The newly displayed value should always be the result from a new database query, do not rely on successful queries. Errors should be marked) 3. Asynchronous data retrieval. To fill in the fields I rely partly on data retrieved from external sources. I need a possibility to fill in these fields with simple mouseclicks (similiar to the behaviour here: [login to view URL] ) The functions that retrieve this data will be provided. 4. Awareness of encoding and null values. Data entered should always be properly encoded. Fields that may be NULL, have to have he possibility to be set to NULL in the forms. 5. Multiple Edit: In list view, I would like to be able to apply the same values to mutliple fields at once. 6. Multiple filter and sorting possiblities in list view. Should be easily accessible eg via url [login to view URL];fieldb=false&sortby=c 7. Functionality comes first. Should work with IE and Firefox. It is a single user frontendend, so do not care aber simultaneous users. Security and Access will be handled on webserver level, so do not care about this. 8. Source-Code has to be provided. I do not accept any type of encoded scripts. 9. Payment by Paypal. Thanks for your offers.
Project ID: 51578

About the project

12 proposals
Remote project
Active 18 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hello! Please see PMB.
$300 USD in 10 days
5.0 (21 reviews)
5.3
5.3
12 freelancers are bidding on average $278 USD for this job
User Avatar
Hi, We have over 5 years of experience of web designing, search engine optimisation and web programming on php and other web technologies and programmed many applications. We are confident to complete this project with in budget and time. Thanks.
$300 USD in 10 days
5.0 (216 reviews)
9.0
9.0
User Avatar
We offer an outstanding value added services with high degree of quality at very competitive prices. We have skill set of creative designers, professional programmers and business analysts to cater your needs and to give cutting edge to your business. ***** Please see PMB for more info ****Best Regards*****
$300 USD in 10 days
4.2 (27 reviews)
6.4
6.4
User Avatar
Hi, Sir. We are experienced programmers and can complete you this project in a proffessional manner. We have completed succesfully a lot of projects here and on other freelance sites, and would like the opportunity to collaborate with you. Regards, Biro Carol
$300 USD in 12 days
5.0 (14 reviews)
5.6
5.6
User Avatar
check your pmb
$300 USD in 6 days
3.2 (18 reviews)
5.7
5.7
User Avatar
Hello, I would like to bid on this job. I'm an American living in Tokyo, with many years experience in Perl programming and linux/windows, see my CV. Personally I think the high end of your budget is not a lot of money for what you require, but since I have written database editing tools a number of times I know what is required. As I understand it, you have 2000 tables and the maximum number of rows per table will fit comfortably in one web page. If not I could add paging (say 100 rows per page) to save memory. The program would be done in Perl, and I would probably like to use Class::DBI though possibly just directly connect through the Mysql module if the table schema is not predefined. It of course requires a lot more work to write a general tool that will handle any relations and table schemas you throw at it, so I don't think it is unreasonable to ask if you can please set one unchanging table schema in advance. Especially if you think you might want to scrap the current schema and add lots of relations. If you must have a general purpose editor then I will try to meet your requirements. Another issue is that it is hard to use DHTML to enter a NULL. If I know where in the schema it allows NULLs I could add that to the program though. If you want editting to be done in list view but do not want a Save button (but do want confirmations from the db), then every click will require a db transaction of course. If the database is near you or on the same machine then that is simple. If you want to handle a remote db with some latency in the connection, then you might want to say make the field red while it is being transacted and then clear the color away after the field has been updated from the database. But I would rather leave such options out given the budget. Multiple selects, please explain what you want. Do you mean that you want to be able to type in your own SQL statement using multiple selects and edit the result? When you have escrowed the money, I will start. I do not accept PayPal, but perhaps this site does (I believe they can in fact pay out to PayPal). This is a fair system, and does not require trust of an organization (PayPal) that has so many people who hate it for arbitrary acts, plus with escrow it can be cancelled easily. I will provide a demo running on my own linux mysql server with your sample data so you can confirm it, and all source code will be provided. You will be responsible for installation on your server. Finally, I am curious about whether you have tried editing with the mysql windows client. It is not great but it would be helpful to know what parts you liked/disliked. I hope you can give me this job since I'm experienced writing db editors, know mysql, and am interested in dhtml. First thing after escrow will be to do a mockup of the screen you want to see, including how to select data sets, etc. I don't know, maybe it is important for you to edit two datasets at once or something. Also I can do visualization of the data in a graph or something, of course for extra fee. I think other bidders ought to put as much thought into their bids as I do, maybe this is a good reason to go with me even though I don't have a long history with this site. Thanks.
$300 USD in 14 days
4.5 (1 review)
2.4
2.4
User Avatar
Hi I am freelancer programmer. I have 5+ years experince in Web Devlopement(PHP, Perl , Cold Fusion 5, MySQL, ASP, SQL SERVER). I am 100% certain that I can deliver an excellent site for you within time. Looking forward to working with you. Regards suneel rawat
$299 USD in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello! This is a placeholder bid. We would like to take this opportunity to render our service. We shall request you to talk to us about the finer details. Assuring you of good service and quality work. Best Regards:-)
$300 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
We expertise in AJAX/WEB 2.0/RIA(Rich Internet Applications) domains. We have AJAXified several traditional web based sites to provide rich client experience. We are proficient with the following AJAX toolkits/frameworks: "Zimbra, OpenRico, Dojo, DWR, Scriptaculous, Prototype, Backbase". We would certainly like to AJAXify your site.
$100 USD in 5 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of GERMANY
Freiburg, Germany
0.0
1
Member since Mar 26, 2006

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.