I am working on a program that allows me to save information from my VB6 program into an online mysql database. I need a php code to work in between the VB6 and the mysql.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
What this program will do is store and retrieve button and urls from a database. There will need to be a 2 part check on the items saved and retrieved. Below are what I see for the table layouts. CATAGORY catRow idKey catName catOnOff ITEM catRow idKey itemName itemOnOff itemURL Cat stands for category idKey is the common key through out the database, I will have several people saving into this database so the idKey is the identifier so people only save and retrieve there data. Basically I need to save from my VB6 program the catRow (this is a number 1,2 3……36), idKey (this is a combination like 143GHT32), catName, catOnOff (this is either true or false) The second table is the same except we will also save a URL and cat changes to item. I allow 36 catRow per idKey and each of those categories can have 36 items. I also need this set up so I can overwrite each category and item. Let’s say I have in CATEGORY catRow = 1, idKEY = 154rre5, catNAME = Rocks, catOnOff = true and I also have catRow = 2, idKEY = 154rre5, catNAME = Pebbles, catOnOff = true If I want to change catRow 1’s catName from Rocks to Stones then it needs to look for the idKey, catRow number and then replace catName = Rocks with catName = Stones. Hope that makes some sence. The way the retreavel part of the program will work is: Start the VB6 program and make a call to the php file to retrieve all the categories that have a true statement in the catOnOff field that matches the idKey I send from the VB6 program. The VB6 program then will show the category buttons with the catName on each button. At that point according to witch button I click on it will send another call to the php file and retrieve the information from the ITEM table using the catRow and idKey as the identifier, in the VB6 program it will build how ever many buttons I need and show the itemName on the buttons. When I click on a button it will use the itemURL from the ITEM field for that button to display a web page in my built in browser.
* * *This broadcast message was sent to all bidders on Friday Apr 28, 2006 3:16:36 PM:
I have had a few bidders asking some questions on this program. If you have any questions please feel free to come into the chat room for this prodject and I will answer any and all That I can. I am in the chat room right now and will be here for the next hour or so.
PHP version 4.4.2 MySQL version 4.1.18-standard