php - jQuery AJAX POST to mysql table for dynamic table data- Am I doing this in anything like the right way? -

-

I have a table that I can dynamically add and remove any number of rows. After the data is entered, I am using jQuery's AJAX functionality to post it in a mysql database, so that no page is redirected or refreshed.

The only way I could think of working on it, was using it for loop in jQuery, how dirty it is to post each line separately to the database? Should I get all the table data and post it once? Different rows can be different on user and users can add and delete as many likes before submitting them.

Strange I have the variable count count due to having two rows at the top of the table. I could not do a great way of doing this.

I always went crazy about the data related to the correct line

Thank you for your time. Click here (function () {// process form var rowCount = jQuery ('# dataTable tr'). ; (Var i = 2; i & lt; rowCount; i ++) {// I am storing four elements of each row on mysql var txtRow1 = jQuery ('# txtRow' + (i-1)). (); Var TickerRow1 = jQuery ('# tickerRow' + (i-1)) Val (); var quantrav 1 = jQuery ('# quintro' + (i-1)). Val (); var valueRow1 = jQuery ('# ValueRow' + (I-1)). Val (); var Data String = 'txtRow1 =' + txtRow1 + '& Tickerwave 1 =' + Tickerau 1 + '& amp; quantRow1 =' + Volume 1 + '& Amp; Mono = 1' + MONO 1; / / Warning (Datasar ;) Return false; jQuery.ajax ({type: "post", url: "http://rccl.co.uk/form_action1.php", data: datastring});}; return back;});} );

It looks very clearly for me as if you have a well The established index is the query in the row, most of the form handlers using the variable i will open the repeated key of server-side form in a list, such as several checkboxes with the same name. You could take advantage of it here. 

  datastring = ''; (Var i = 2; i & lt; rowCount; i ++) for {var txtRow1 = jQuery ('# txtRow' + (i-1)). Val (); Var tickerRow1 = jQuery ('# ticker rau' + (i-1)). Val (); Var quantRow1 = jQuery ('# quantRow' + (i-1)). Val (); Var valueRow1 = jQuery ('# valueRow' + (i-1)). Val (); Datastring = datastring + 'index [] =' + (i-1) + 'txtrow1 [] =' + txtrow1 + 'and tikrarov 1 [] =' + tickerro 1 + 'and quantovo 1 [] =' + quantarrao 1 + '& Amp; ; ValueRow1 [] = '+ valueRow1; }   
 Then call Ajax with the whole string.  
 On the server side, you should get the array for each of these, each of which corresponds to the first first line, each of which corresponds to the second row, and so on. 
 
 Since the time I use PHP, it has been a long time since, but I believe that  []  symbols for each key item in PHP < It is necessary for the code> $ _ POST  sign to convert the contents of different keys into arrays.

Comments

Post a Comment

Popular posts from this blog

mysql - BLOB/TEXT column 'value' used in key specification without a key length -

-
I have developed an extension which works up to 1.6 on Magren (I'm trying Enterprise Edition, And I think the community is the same problem, because it is the same code). In my install script, I see the $ installer-> gt; CreateEntityTables ($ this- & gt; getTable ('alphanum / info')); The installation is done until it is not in the _text unit table. It crashed there! It turns out that when I log in to SQL and run it via PHPmyadmin, then this error is: Blob / Text column 'value' is used without the key 'key' . I saw the code there, and this is what is trying to create an index on the value column: -> addIndex ($ this- & gt; getIdxName ($ eavTableName, array ( 'attribute_id array (' attribute_id ',' value ')) - & gt; addIndex ($ this- & gt; getIdxName ($ eavTableName, array (' entity_type_id ' , 'Value')), array ('entity_type_id', 'value')) If there is no if statement is n...
Read more

c# - Using Vici cool Storage with monodroid -

-
Oh, for the moment I am not sure how it is officially supported, but for the success of the people Using Monodroid Vic Cool Storage I am able to leave and compile assemblies in my project, but while trying to use some classes, the errors of time have to be gathered. Especially when trying to connect like the example for Mono Touch string dbName = path. Cobain (environment. Gatefolder path (environment specialfolder personal), "mydb.db3"); // The following line will be called coolestation, where is the database, // to make it if it does not exist, and call a delegate that creates the necessary tables (only when the database file was newly created //) CSConfig.SetDB (DbName, true, () => {CSDatabase.ExecuteNonQuery ("Subscriber Integer Primary Key Attribute, Name Text (50) No, Number, Date First Text (30)");); There is no difference when I try to use the methods of CSConfig and when I cscfif If I try to pass 3 aggregates to STDB (3) then I get the invalid ...
Read more

python - referencing a variable in another function? -

-
I am an experienced TCL developer and write my own processes to help myself. I call it a proc i callVar, print out the value of the variable in a certain format, so I know that it is variable and what is the value "set foo 1; putVar foo" result 'foo = "1" I want to do the same thing in Python, but I can not find the answer :( In TCL I use the up command because when I pass the name of the variable, then I can see the value at the top. . I understand that an advanced light in the dragon There is no mechanism of r, but with its introspection capability, I would think that this is something trivial, but I am not getting the answer anywhere. It seems that this should work: and expanded: def foo (): y = "Hello World" printwor ("y") foo () y = "Hello World " You can, but you should not do so if your code is correct If is needed , then there is something wrong with your design, and you should probably use the dictionar...
Read more