Find all textbox values and post into PHP MySQL

Question

I am just a newbie to jQuery can some one help me?

I want to create a invoice system like this one

All I need to do is add a submit button that will function some thing like this

.find all input of textareas identified by some unique id

then post that values into php MySQl earch row will contain unqiue data.

You said "find all input of textareas identified by some unique id". But if the id is unique, there can be only zero or one text element. Did you mean "by some unique name" ? — Luc125, Dec 06 '11 at 07:46

score 0 · Accepted Answer · answered Dec 06 '11 at 07:34

Ambiguity in your question anyway this will get you an array of values of all the text boxes

        $(document).ready(function(){
$('#somebuttonid').click(function(){
        var tbarray = new Array();
        $('.yourtextboxclass').each(function(){
        tbarray.push($(this).val()); //You will have a array tbarray with all the values of textboxes
        }):
        $('#somehiddenelementid').val(tbarray);
        $('#somehiddenelementidcontainingform').submit(); //Make sure your action is set,you can access like $_post['$somehiddenelmentname'];
        });
});

    <!--html side-->
    <form id="somehiddenelementidcontainingform" action="youraction" method="post">
    <input type="hidden" name="somehiddenelmentname[]" id="somehiddenelementid" />
    </form>

Thanks for your help, i will try this query into my code hope if its hepl. :) — Amanullah, Dec 06 '11 at 19:51

score 0 · Answer 2 · answered Dec 06 '11 at 08:19

I was surprised to find that this function, phrased in this way, did not bring back plenty of posts with obvious answers.

Amanullah, a lot of the comments asks that you try for yourself first, because people normally do not like to answer questions that are google'able.

I was going to recommend the same, but when I did a search with your keywords, there were no obvious answers.

To serialize all your input elements, you can use:

$('form :input').serialize() // creates a query string tb1=bob&tb2=smith

$('form :input').serializeArray() // creates a JSON object [{name:"tb1", value:"bob}, {name:"tb2", value:"smith"}]

Note that those go by element NAME and not ID. Once your values are serialized, you can send them to the server. If you only want to grab textboxes, change your selector to $('form :input:text')

Find all textbox values and post into PHP MySQL

2 Answers2