ajax asynchronous refresh to update the database_jquery
The previous article was all about the interface. Next, I will write about how to write data into the database without refreshing. 
When we change a certain score of a person or a few people, it can be written to the database without refreshing.
First, we need to declare the XMLHttpRequest object
// Declare XMLHttpRequest object
var xmlHttp;
function createXMLHTTP() {
if (window.XMLHttpRequest) {
xmlHttp = new XMLHttpRequest(); //Mozilla browser
}
else if (window.ActiveXObject) {
try {
xmlHttp = new ActiveXObject("Msxml2.XMLHTTP"); //Old version of IE
}
catch (e)
{ }
try {
xmlHttp = new ActiveXObject("Microsoft.XMLHTTP"); //New version of IE
}
catch (e)
{ }
if (!xmlHttp) {
window.alert("Cannot create XMLHttpRequest object instance!");
return false;
}
}
}
At the same time, a callback function is needed to determine whether Modification successful
//Update or add record callback function ( Check whether the score is successful)
function ModifyScore ()
{
if (xmlHttp.readyState == 4)
{
// if (xmlHttp.status == 200)
{
if (xmlHttp.responseText == "true")
{
}
else
{
// alert("Rating failed, please re-rate or contact the administrator" );
}
}
}
}
After the preparation is completed, the following is the key step:
Because it needs to be written when modifying the score Enter the database, so you only need to execute this piece of code to change the drop-down box value (when looping through selected items) as mentioned in the previous blog:
//Get the mutual review ID
var criticsID = checkbox[i].value;
//Write the modified value into the database
//Get the project score
var scoreAll = document.getElementById("score" checkbox[i].value srcElem.id "");
var accessAllScore = scoreAll.outerText;
//Get the project number
var assess = document.getElementById("assess" srcElem.id);
var assessID = assess.title;
createXMLHTTP(); //Create an XMLHttpRequest object
//Transfer data to another A page executes
var url = "CriticsAgainAjax.aspx?criticsID=" criticsID "&assessID=" assessID "&accessAllScore=" accessAllScore "&Event=allCriticsInfo";
xmlHttp.open("Post", url, true);
// xmlHttp.setRequestHeader("Content-Type","application/x-www-form-urlencoded");
xmlHttp.onreadystatechange = AnswerOneKindQuestion;
xmlHttp.send(null);
Finally, we only need to get the parameters in CriticsAgainAjax.aspx and write to the database
//Get parameters
if(Request.QueryString["Event"].ToString() == "allCriticsInfo")
{
string criticsID = Request.QueryString["criticsID"].ToString();
string assessID = Request.QueryString["assessID"].ToString();
string accessAllScore =Request.QueryString["accessAllScore"].ToString( );
}
After the parameters are passed, writing to the database is very easy, so I won’t mention it here.
In this way, the effect displayed in the foreground is that there is no refresh, and the data is written to the database from time to time. Just leave all the dirty work to the CriticsAgainAjax.aspx page, which is also a good division of labor.
In addition to less refreshing, another advantage of writing this is that ajax is an asynchronous operation, that is, after the data is thrown to CriticsAgainAjax.aspx in the js page, it will continue to execute without considering whether CriticsAgainAjax.aspx has been completed. , it may take 100 pieces of data to be thrown, and it takes three seconds to write to the database, and the time to throw it is very fast, maybe only a few tenths of a second, so the user will feel very good, and he does not need to wait for half a day after selecting to continue. implement.
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
What should I do if I encounter garbled code printing for front-end thermal paper receipts?
Apr 04, 2025 pm 02:42 PM
Frequently Asked Questions and Solutions for Front-end Thermal Paper Ticket Printing In Front-end Development, Ticket Printing is a common requirement. However, many developers are implementing...
Demystifying JavaScript: What It Does and Why It Matters
Apr 09, 2025 am 12:07 AM
JavaScript is the cornerstone of modern web development, and its main functions include event-driven programming, dynamic content generation and asynchronous programming. 1) Event-driven programming allows web pages to change dynamically according to user operations. 2) Dynamic content generation allows page content to be adjusted according to conditions. 3) Asynchronous programming ensures that the user interface is not blocked. JavaScript is widely used in web interaction, single-page application and server-side development, greatly improving the flexibility of user experience and cross-platform development.
Who gets paid more Python or JavaScript?
Apr 04, 2025 am 12:09 AM
There is no absolute salary for Python and JavaScript developers, depending on skills and industry needs. 1. Python may be paid more in data science and machine learning. 2. JavaScript has great demand in front-end and full-stack development, and its salary is also considerable. 3. Influencing factors include experience, geographical location, company size and specific skills.
How to merge array elements with the same ID into one object using JavaScript?
Apr 04, 2025 pm 05:09 PM
How to merge array elements with the same ID into one object in JavaScript? When processing data, we often encounter the need to have the same ID...
Is JavaScript hard to learn?
Apr 03, 2025 am 12:20 AM
Learning JavaScript is not difficult, but it is challenging. 1) Understand basic concepts such as variables, data types, functions, etc. 2) Master asynchronous programming and implement it through event loops. 3) Use DOM operations and Promise to handle asynchronous requests. 4) Avoid common mistakes and use debugging techniques. 5) Optimize performance and follow best practices.
How to achieve parallax scrolling and element animation effects, like Shiseido's official website?
or:
How can we achieve the animation effect accompanied by page scrolling like Shiseido's official website?
Apr 04, 2025 pm 05:36 PM
Discussion on the realization of parallax scrolling and element animation effects in this article will explore how to achieve similar to Shiseido official website (https://www.shiseido.co.jp/sb/wonderland/)...
The difference in console.log output result: Why are the two calls different?
Apr 04, 2025 pm 05:12 PM
In-depth discussion of the root causes of the difference in console.log output. This article will analyze the differences in the output results of console.log function in a piece of code and explain the reasons behind it. �...
The Evolution of JavaScript: Current Trends and Future Prospects
Apr 10, 2025 am 09:33 AM
The latest trends in JavaScript include the rise of TypeScript, the popularity of modern frameworks and libraries, and the application of WebAssembly. Future prospects cover more powerful type systems, the development of server-side JavaScript, the expansion of artificial intelligence and machine learning, and the potential of IoT and edge computing.
