Sedang Disiapkan

Add / Modify / Delete Script for PHP4 SQLite Database - 3 tables

We are using a linux box with SQLite for our database and PHP VERSION 4(!!) with PECL sqlite package (start here if you don't have it installed yet: [url removed, login to view]). There are 3 tables that we need to add/modify/delete records from. I will supply you with the sqlite .db file to work from. You can develop it on your server, or I can give you an account to develop it off mine.

You will be responsible for displaying all of the data in a spreadsheet-like view. There should be buttons to add edit and delete each of the items. You will need to create form elements such as dropdown boxes and textboxes and populate

them with the appropriate data from the database.

I have screenshots of a previous project that you can use as a guideline for what it is supposed to look like. PM me

if you want to see the URL to the screenshot before you bid. Don't need graphics, just nicely laid out forms.

It's pretty straightforward, there are 3 main parts to this:

The main part is Events, each event can have several actions associated with it.

I'm open to feedback on this, but a treeview could be a nice way to display all of the events, and when you click the little plus sign it could show all of the actions associated with that event. Of course a simple tab showing the actions indented underneath each event would work fine as well.

Here is what the database looks like:

create table events(eId INTEGER PRIMARY KEY, name, deviceId, triggerData);

insert into events values(NULL, "status_pwr_on", "YAMAHA1", "%02?02001%03");

insert into events values(NULL, "status_pwr_off", "YAMAHA1", "%02?02000%03");

insert into events values(NULL, "status_pwr_100", "YAMAHA1", "%02?02002%03");

insert into events values(NULL, "status_pwr_011", "YAMAHA1", "%02?02003%03");

insert into events values(NULL, "status_pwr_110", "YAMAHA1", "%02?02004%03");

insert into events values(NULL, "status_pwr_101", "YAMAHA1", "%02?02005%03");

insert into events values(NULL, "status_pwr_010", "YAMAHA1", "%02?02006%03");

insert into events values(NULL, "status_pwr_001", "YAMAHA1", "%02?02007%03");

create table actions(aId INTEGER PRIMARY KEY, name, eId, type, delay, expression, outputTo, outputValue);

insert into actions values(NULL, "testAction", 1, "sql", 0, 0, 'powerStatus1', "g");

insert into actions values(NULL, "testAction", 1, "sql", 0, 0, 'powerStatus1', "g");

create table devices(dId INTEGER PRIMARY KEY, name, ipAddress, telnetPort, link);

insert into actions values(NULL, "YAMAHA1", '[url removed, login to view]', "23", "http://192.168.1.70/setup/");

insert into actions values(NULL, "YAMAHA2", '[url removed, login to view]', "4000", "http://192.168.1.71/setup/");

Events and actions are linked via eID so all actions which have an eID of 1 would get listed under event1.

Devices are a seperate table, which is the table that populates the drowpdown box for 'deviceId' in the events table.

The gui forms should work like this:

events table:

eId - autoincrement, just send null

name - textfield type=text

device - dropdown box populated by devices table

triggerData - Textbox 4 rows

actions table:

aId - autoincrement, just send null

name - textfield type=text

eId - type=hidden variable set depending on which event we are adding the action to.

type - dropdown, for now just put sql as the only choice

delay - small textfield type=text

expression - checkbox - sumbits 1 if checked 0 if not checked

outputTo - textfield

outputValue - textbox 4 rows

devices table:

dId - autoincrement, just send null

name - textfield type=text

ipAddress - textfield type=text

port - small textfield type-text

link - textfield type=text

You can use the standard form submit page refreshing methods to do this, but if your willing to spend the time to do it in ajax so that all add/modify/delete actions are done without leaving the page, i'd be willing to pay more for that. PM me to discuss.

Please bid only if you can start immediately. Specify if you will use standard form submits or ajax.

Kemahiran: PHP

Lihat lebih lanjut: php add modify delete, php4 sqlite, php database tables insert delete, delete table sqlite php, php4 sqlite database, delete data sqlite database, php4 insert update delete page, table add delete update php sqlite, insert sqlite database jsp, sqlite script, www linked, what to do when you get laid off, what to do when laid off, what are work values, sql get integer part, spreadsheet script, php script null, part standard, parts now, open table com, mine work, linked in sign in, laid off now what, laid off from work, get sql server port

Tentang Majikan:
( 2 ulasan ) New York, United States

ID Projek: #62636

11 pekerja bebas membida secara purata $86 untuk pekerjaan ini

encodedart

Please view PMB for detail. Thanks. EncodedArt Inc - A solution Canadian provider company.

$100 USD dalam 3 hari
(49 Ulasan)
7.2
Sphinks

Hello sir! I'm ready to start the job. Regards, Sphinks!

$100 USD dalam 3 hari
(88 Ulasan)
6.6
elfuerte

Check PMB for more information.

$75 USD dalam 0 hari
(25 Ulasan)
5.0
webdoers

We're the team of enthusiastic and technically conscious highly qualified engineers, with core software industry experience. Our team have 25 man-years experience. They are serving the key position in their respective Lagi

$100 USD dalam 20 hari
(9 Ulasan)
4.5
varshyltech

We at VarshylTech - an ITES company provide Internet Marketing services with primary focus on Website Design and Development, Graphic designs, Animations, 3D Max, Web Copywriting and Web marketing consulting to Clients Lagi

$100 USD dalam 10 hari
(2 Ulasan)
3.3
instance

GOOD QUALITY WORK WITH INTIME DELIVERY OF THE PRODUCT . 100% GUARANTEED OF HIGH QUALITY PROFESSIONAL WORK, AS WE ARE THE EXPERTISE IN JAVA/J2EE , JSP , EJB, ASP,PHP, STRUTS FRAME WORK RELATED PROJECTS. OUR COMPANY HAS Lagi

$80 USD dalam 8 hari
(1 Ulasan)
3.0
sunny78

I have 5+ years experince in Web Devlopement(JSP/Servlets,Perl,Could Fusion,PHP,MYSQL) and i have completed more than 30 sites in Perl,Could Fusion,PHP,JSP/Servlets. I am 100% certain that I can deliver an excellent Lagi

$90 USD dalam 2 hari
(0 Ulasan)
0.0
egoldpros

We can help you to create Add/Modify/Delete Script (connected to MySQL) for php.

$30 USD dalam sehari
(0 Ulasan)
0.0
WEBGLOW

WebGlow is a customer-specific service oriented company has got an Professional and creative [url removed, login to view] are the Professional Web Development Company having 3 years experience in Web design and development. We are solut Lagi

$70 USD dalam 10 hari
(0 Ulasan)
0.0
Ashwani1963

Escrow the payment and I will do it now, in next 2 hrs

$100 USD dalam sehari
(0 Ulasan)
0.0
harshini

Dear Sir, In reviewing your project description,we are confident that we would finish the project as per your expectations and [url removed, login to view] wish to make a ever-lasting Postive Impact through the Development of Lagi

$100 USD dalam 2 hari
(0 Ulasan)
0.0