php - jQuery AJAX POST to allow form data sending without page redirect- how to then insert data into mysql -

-

text after "itemprop =" text ">

I have written three tutorials, one on a php file to submit form data, one on one that has followed To do all of this in mysql table, and then on a jQuery AJAX page without redirection.

The jQuery AJAX tutorial is here, as it seems that many people on this site can send forms without post redirects:

In the case of receiving data through AJX I have been installed correctly, but the php mysql statement will not write data to the database. I used firebug to check that the data is happening on PHP, and this is what I think it is.

I'm sure this issue is not one of the database connectivity, I think it is due to the format of the file which is being passed to the PHP file. Tutorial mix and matching was difficult for me; I need to open the string data that I created in the jQuery function?

In a different form, the jQuery AJAX tutorials he mentions are 'other than the more advanced things you can do here, besides sending an email and delivering a success message. For example, you can send your prices to a database, process them, then display the results back to the user '. It seems as if he is saying that you can do anything in the php file using POST. I thought the whole point of the php file was to store the database?

Thank you for your time.

Send jQuery AJAX data: 

  click on jQuery (function () {jQuery ("Button1.") (Function () {var txtRow1 = jQuery ('. # TxtRow1 ') Val (); tickerRow1 = jQuery (' # tickerRow1 ') Val ();. DataString =' txtRow1 = '+ txtRow1 +' & amp; tickerRow1 = '+ tickerRow1; // Warning (dataString) ; Return false; jQuery.ajax ({type: "POST", url: "form_action.php", data: datastring}); return;});});   
 and form_action.php:  
  & lt ;? Php $ dbhost = 'localhost'; $ Dbuser = 'User'; $ Dbpass = 'Pass'; $ Dbname = 'dbname'; $ Conn = mysql_connect ($ dbhost, $ dbuser, $ dbpass) or die ('Error connecting to mysql'); Mysql_select_db ($ dbname); $ TxtRow1 = $ _POST ['txtRow1']; $ Ticker 1 = $ _POST ['tickerro1']; $ Sqlinsert = "Include in stock_port (name, ticker) values ​​('$ txtRow1', '$ tickerRow1')";   
? & Gt;   
 
 
 First of all, make sure you run the data from the post:  
  $ sqlinsert = "insert stock_port (name, ticker) vALUES ( '". .mysql_real_escape_string ($ txtRow1) "', '' .mysql_real_escape_string ($ tickerRow1)." ') ";   < p> secondly, you are not executing the query (or some code is missing here?)  
  mysql_query ($ sqlinsert, $ Conn);

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