Customise the database columns

  • BennyBoy82

    (@bennyboy82)


    14 years, 8 months ago

    Hi

    Im building a website for a motorbike shop in Thailand http://www.brotherhoodpattaya.com,
    i have spent the last 3 hours building an order and booking form for the shop but need some help to finish it off.

    Everything looks nice and im happy with its appearance.

    The problem i have is the way i receive the data, its all over the place.

    I had a look a quick look at the order by short code but im not entirely sure its what i need, if it is i dont know how to set it up.

    The form in question is on this page http://www.brotherhoodpattaya.com/order-form/

    Id like to receive the data in the order its given through the form.

    Rent or buy motorbike – Which particular bike – how long they want to rent it – the date they want to hire.

    Then if they are buying anything from the merchandise section to display what product number there interested in and the quantity .

    This pattern needs to follow throughout the form, what product they want and the quantity.

    At the end of the form are personal details.

    I really want to get this problem solved as ive spent so much time working with html on the form getting it to look just right.

    Im hoping there will be an easy solution to this problem and that someone elase out there has already dealt with a similar issue.

    Looking forward to your suggestions

    Kind Regards

    Ben

Viewing 5 replies - 1 through 5 (of 5 total)
  • Thread Starter BennyBoy82

    (@bennyboy82)

    14 years, 8 months ago

    I have just noticed that my contact form looks different in firefox compared to google chrome.

    I built it in google chrome and just checked it in firefox and its changed.

    Anyone got any ideas?

    Im hoping some help is out their, im thinking of starting over and completely changing the way i set up this form. Its a shame because i spent so long building it and in google chrome it looks good.

    I need the form to function correctly and i need it to look the same in all of the browsers.

    Help me please.

    Kind regards

    BennyBoy

    Plugin Author Michael Simpson

    (@msimpson)

    14 years, 8 months ago

    If your issues concern the layout of form elements on your pages that you created with Contact Form 7, then re-post on this forum: http://wordpress.org/tags/contact-form-7

    Plugin Author Michael Simpson

    (@msimpson)

    14 years, 8 months ago

    The problem i have is the way i receive the data, its all over the place.

    I had a look a quick look at the order by short code but im not entirely sure its what i need, if it is i dont know how to set it up.

    If you can elaborate on what this means, maybe I can help. I see your form on the page but I don’t see any data from form submissions.

    Thread Starter BennyBoy82

    (@bennyboy82)

    14 years, 8 months ago

    Thanks for getting back to me.

    There doesn’t seem to be a particular order in which i receive my data and i want to know how to configure it so that i receive the data as i explained in my first post.

    How can i show you how i receive the data?

    Can i attache a file here? If so can you explain how please.

    As you can see on the order form i made. We have a choice of motorbikes for rent or for sale and we have a selection of different brands, harley davidson, yamaha, buell etc. Then underneath we have retal period check boxes and drop down boxes for the date they want to rent for.

    When testing the form and the database this information does display in the database as id like. Under my “motorbikes” column I can see that the person wants to “rent” rather than “buy” then i have columns for the different models of motorbikes which is fine, and next i can see that they want to rent for a certain amount of days, next i can see on what particular dates they are interested in hiring.

    So far so good.

    The rest of the data from this point is not organised how i want it. The next section is for merchandise and i have “Mugs & Cups” and i have “collectables”. I want the user to be able to choose the item code from the dropdown box and choose the quantity which is next to it. The same principle needs to continue throughout the database

    I want to see my database looking like this;

    Mugs & Cups Quantity Collectables Quantity Sunglasses Quantity
    MG001 X2 COL002 X3 ACC002 X3
    MG005 X4 COL003 X2 ACC005 X4

    But when i tried to use the same shortcode [mugs & cups] for three dropdown boxes i was only given one result. So for each of the dropdown boxes i changed it to [mugs & Cups] [mugs & cups 1] and [mugs & cups 2]. If this is the only way to get the results then i want the database to look like this;

    Mugs & Cups Quantity Mugs & Cups 1 Quantity 1 Mugs & Cups2 Quantity2
    MG001 X2 MG002 X4 MG006 X2

    In the database it looks like this;

    MugsCups Quantity Collectables Collectables Quantity1 Sunglasses Gloves MugsCups1 Quantity2 Quantity3

    These are the column titles, not enough room on the screen.

    I hope this explains a little bit more about my problem and what i want to achieve.

    I want to know what i need to do to receive my data in an orderly fashion, product-quantity-product -quantity-product-quantity.

    Not, product -quantity-product-quantity-product-product-product-quantity-quantity – quantity-your name- – quantity – your email – quantity etc

    Thanks

    Ben

    Plugin Author Michael Simpson

    (@msimpson)

    14 years, 8 months ago

    I’m still having some trouble following what exactly the issue is. Seems like there are a couple issues.

    In the CF7 Editor (not my plugin) you will need to have a different “Name” for every form field. I see you have 3 sets for “Mugs & Cups” order, each has a product and a quantity. If you want it set up this way each drop down must have a different form field name (like mcType1, mcNum1, mcType2, mcNum2).

    In the DB Admin page, you should see columns in the order that they appear on the screen. But if you have changed the form and have older submissions from when the form fields were organized differently, then the fields may show up in that order instead. The only way to fix the order is to go into the DB table and update the field_order field on entries. So if you look at a recent order in the wp_cf7dbplugin_submits table, you will see an entry for each field of the form and a form_order field. Update all the other submissions to follow this order. For example, if a field is supposed to be the third, try:

    UPDATEwp_cf7dbplugin_submitsSET field_order = 3 WHERE form_name = 'your form name' field_name = 'your third field'

    Then all ‘your third field’ will be consistently labeled as order 3 in the db and consequently the DB admin panel will show them in that column order.

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Customise the database columns’ is closed to new replies.