Insert value in table with enter key

Question

Hi Friends

I have a problem, problem is that I have a textbox in html form in PHP, I want when we write some text in this textbox then press enter key then value of textbox will be insert in the sql table ? Please help me anyone urgently ?

Thanks..

Vineet Kumar Saini · Answer

Senthil Ji Your code doesn't execute properly . Please help me ?

Senthilkumar · Answer

Hi Vineet, The logic is you have two pages. One is page1 with textbox. when enter some text and hit on enter key will call ajax function. It uses the asynchrnous call to another page called AjaxPage.php, where it will get the ajax request and get the value. In AjaxPage.php, $data=$_GET["q"]; //$img = " "; echo $data ?> Some thing like that, you need to get the value in the query string and write the logic to insert into database table. now you need to write "Success" as output. This will be taken as response after inserting and message will be displayed in the page1.

Vineet Kumar Saini · Answer

Senthil Ji please tell me, where we will write database name and table name in your code ? Thanks

Senthilkumar · Answer

Hi Vineet, you need to like this. when enter some thing in text box and hit enter will call the ajax function to insert the value. Untitled Page function InsertVal(e) { if (e.keyCode == 13) { if(document.getElementById("txtInsert")) { var txt = document.getElementById("txtInsert").value; SaveValueToDB(txt); } } return false; } function SaveValueToDB(str) { var xmlhttp; if (str.length==0) { return; } if (window.XMLHttpRequest) {// code for IE7+, Firefox, Chrome, Opera, Safari xmlhttp=new XMLHttpRequest(); } else {// code for IE6, IE5 xmlhttp=new ActiveXObject("Microsoft.XMLHTTP"); } xmlhttp.onreadystatechange=function() { if (xmlhttp.readyState==4 && xmlhttp.status==200) { alert('Saved successfully...'); } } xmlhttp.open("GET","AjaxPage.php?q="+str,true); xmlhttp.send(); }

Insert value in table with enter key

Answers (4)