键入时将值插入数据库 [英] Inserting values to database while typing

问题描述

我有一个任务。我想在文本框中键入值时将数据插入数据库....
即使我不知道是否可能。这是可能的。
任何例子都将受到赞赏。

I have a task.I want to insert data into database while typing values in textbox.... Even i don't know is it possible.Is it possible. Any example will be appreciated.

提前致谢

推荐答案

是的，可以这样做。这里的例子适合你，但是以PHP的方式。您可以使用此引用更改为JSP。

Yes, it possible to do that. Here example for you, but in PHP way. You can change into JSP by using this references.

Html

<input type="text" id="hey">

jQuery

$('#hey').on('keyup', function(){    
   $.ajax({
      type : 'POST',
      url : 'insertData.php', // --> server side code to insert data into db
      data : {
        val : $(this).val()
      },
      success : function(msg){
        // msg -> return by server side
        // any code in success
        // if success will print out this 'New record created successfully'
        // if error will print out this 'Error occured'
        console.log(msg);
      }
  });
});

Php - insertData.php

 <?php
 $servername = "localhost";
 $username = "username";
 $password = "password";
 $dbname = "myDB";

 // Create connection
 $conn = new mysqli($servername, $username, $password, $dbname);     

 $sql = "INSERT INTO comment (myText)
 VALUES (".$_POST['val'].")";

 if ($conn->query($sql) === TRUE) {
   echo "New record created successfully";
 } else {
   echo "Error occured";
 }

 $conn->close();
 ?>

这篇关于键入时将值插入数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！