Need Help with Dynamic Table Generation for Small Wordpress Site.

Discussion in 'PHP' started by Spliffic, Feb 19, 2008.

  1. #1
    I assume this can be coded in JSP or PHP (as long as it can "plugin" to Wordpress I am fine with either). This would be my first website, and am willing to pay for this to be done (unfortunately I have a limited budget, please make me a reasonable offer).

    Here is the basic requirement:

    Allow the user to perform a product comparison within one page in Wordpress page. The user can either:
    1. Select multiple items from a read-only listbox, using CTRL+Click to select a minimum of 2 items and a maximum of 4 items and click "submit" (this is the query search criteria). User defined error message should be displayed if min or max selection not made and clicking submit. Min/Max rules should be user defined (e.g. provide comments in code where I can change this to max 5 in the future if needed etc).

    OR

    2. Select multiple items from a left hand sid read-only listbox by highlighting the item, but instead they click a right arrow button to move the item to a right hand side read-only textarea (items on this side are what is submitted for query). Below this right hand text area, have a submit button. Same min-max rules apply when clicking submit as above. This method is preferred but will depend on what the cost will be.

    Once the user clicks submit, a table will be displayed with the items that were selected. The search criteria will never change, in other words the word that is selected from above will always be the searchable field. There is also no need to add, update, or delete any records from this screen. The search result will always be the entire record, and will not require custom results. So basically if the user selects item 1 and 2 to be compared and clicks submit, the database query should simply be "select * from table where item ID = 1 or 2. I would also like to have an image to be the first item of each record.

    Once the user clicks submit, the table will be displayed in the same page and will hide search components on the screen (i.e. only show the table and not allow further input). If the user wants to do another search, a button or link should be provided at the top of the table and at the bottom of the table to "perform another comparison".


    If it is easier, I can create a WP-table and include all the possible records and then the coding could basically hide everything until the search is performed and "unhide" what the user has entered for search criteria. This could be another way that this is done.

    Please PM me if you can help me out. Very much appreciated! :)
     
    Spliffic, Feb 19, 2008 IP
  2. 00johnny

    00johnny Peon

    Messages:
    149
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    sounds like something phpmyadmin does. maybe you can lift code from there...
     
    00johnny, Feb 19, 2008 IP
  3. Spliffic

    Spliffic Peon

    Messages:
    270
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Thanks for the reply, and yes it would be something that phpMyAdmin would be able to handle, but the problem is that I don't know how I would be able to "lift" the code I need out of the phpMyAdmin package (as I do not know how to code this). I also don't know how to cherry pick what I would need in terms of which files I would need to keep etc, not to mention where I would put the files in my Wordpress site.

    My understanding of phpMyAdmin is that it's a database administration tool for mySQL database. I'm sure it can retrieve the data for what I need, but I also have no idea how to populate it into a table. If someone wants to bastardize phpMyAdmin to fit it to my needs, I would surely pay them to do that as well.
     
    Spliffic, Feb 19, 2008 IP