关于ajax操作数据库后的数据处理有关问题
关于ajax操作数据库后的数据处理问题
在做一个页面,类似刷微博时拉到最下面可以选择“加载更多”,现在通过ajax实现了对数据库的操作
function ajax() {<br /> var page=document.getElementById("pageNum").value++;<br /> //先声明一个异步请求对象<br /> var xmlHttpReg = null;<br /> if (window.ActiveXObject) {//如果是IE<br /><br /> xmlHttpReg = new ActiveXObject("Microsoft.XMLHTTP");<br /><br /> } else if (window.XMLHttpRequest) {<br /><br /> xmlHttpReg = new XMLHttpRequest(); //实例化一个xmlHttpReg<br /> }<br /><br /> //如果实例化成功,就调用open()方法,就开始准备向服务器发送请求<br /> if (xmlHttpReg != null) {<br /> xmlHttpReg.open("get", "pro.php?index="+page, true);<br /> xmlHttpReg.send(null);<br /> xmlHttpReg.onreadystatechange = doResult; //设置回调函数<br /><br /> }<br /><br /> //回调函数<br /> //一旦readyState的值改变,将会调用这个函数,readyState=4表示完成相应<br /><br /> //设定函数doResult()<br /> function doResult() {<br /> <br /> if (xmlHttpReg.readyState == 4) {//4代表执行完成<br /> <br /> <br /> if (xmlHttpReg.status == 200) {//200代表执行成功<br /> //将xmlHttpReg.responseText的值赋给ID为resText的元素<br /> document.getElementById("resText").innerHTML = xmlHttpReg.responseText;<br /> <br /><br /> }<br /> }<br /><br /> }<br /> <br /><br /> }
后台数据库是php实现的,语句是
<br />…………<br />$sql="select * from tb_test limit ".$index*4;<br />$result = mysql_query($sql, $con);<br />
写到这儿不知道该怎么办了
通常情况下
使用while ($row=mysql_fetch_array($result)) {
……
}
就可以了,现在不知道改怎么输出,而且我的前台页面中,这些更新的数据是在一个table中
------解决方案--------------------
while ($row=mysql_fetch_array($result)) {
……
}
一样的在这个里面进行循环,但是此时可以加上tr等table下的标签然后组合成数组后,再转换成你要求的输出格式进行输出到结果就可以了。
------解决方案--------------------
将从数据库获取的数据(一般是数组),echo json_encode($res);
前台js用
var res=xmlHttpReg.responseText;
res=eval('('+res+')');
解出来
res['键名'],就可以获取对应的键值

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

AI Hentai Generator
Generate AI Hentai for free.

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

The message "Your organization has asked you to change your PIN" will appear on the login screen. This happens when the PIN expiration limit is reached on a computer using organization-based account settings, where they have control over personal devices. However, if you set up Windows using a personal account, the error message should ideally not appear. Although this is not always the case. Most users who encounter errors report using their personal accounts. Why does my organization ask me to change my PIN on Windows 11? It's possible that your account is associated with an organization, and your primary approach should be to verify this. Contacting your domain administrator can help! Additionally, misconfigured local policy settings or incorrect registry keys can cause errors. Right now

Windows 11 brings fresh and elegant design to the forefront; the modern interface allows you to personalize and change the finest details, such as window borders. In this guide, we'll discuss step-by-step instructions to help you create an environment that reflects your style in the Windows operating system. How to change window border settings? Press + to open the Settings app. WindowsI go to Personalization and click Color Settings. Color Change Window Borders Settings Window 11" Width="643" Height="500" > Find the Show accent color on title bar and window borders option, and toggle the switch next to it. To display accent colors on the Start menu and taskbar To display the theme color on the Start menu and taskbar, turn on Show theme on the Start menu and taskbar

By default, the title bar color on Windows 11 depends on the dark/light theme you choose. However, you can change it to any color you want. In this guide, we'll discuss step-by-step instructions for three ways to change it and personalize your desktop experience to make it visually appealing. Is it possible to change the title bar color of active and inactive windows? Yes, you can change the title bar color of active windows using the Settings app, or you can change the title bar color of inactive windows using Registry Editor. To learn these steps, go to the next section. How to change title bar color in Windows 11? 1. Using the Settings app press + to open the settings window. WindowsI go to "Personalization" and then

Do you see "A problem occurred" along with the "OOBELANGUAGE" statement on the Windows Installer page? The installation of Windows sometimes stops due to such errors. OOBE means out-of-the-box experience. As the error message indicates, this is an issue related to OOBE language selection. There is nothing to worry about, you can solve this problem with nifty registry editing from the OOBE screen itself. Quick Fix – 1. Click the “Retry” button at the bottom of the OOBE app. This will continue the process without further hiccups. 2. Use the power button to force shut down the system. After the system restarts, OOBE should continue. 3. Disconnect the system from the Internet. Complete all aspects of OOBE in offline mode

Taskbar thumbnails can be fun, but they can also be distracting or annoying. Considering how often you hover over this area, you may have inadvertently closed important windows a few times. Another disadvantage is that it uses more system resources, so if you've been looking for a way to be more resource efficient, we'll show you how to disable it. However, if your hardware specs can handle it and you like the preview, you can enable it. How to enable taskbar thumbnail preview in Windows 11? 1. Using the Settings app tap the key and click Settings. Windows click System and select About. Click Advanced system settings. Navigate to the Advanced tab and select Settings under Performance. Select "Visual Effects"

We all have different preferences when it comes to display scaling on Windows 11. Some people like big icons, some like small icons. However, we all agree that having the right scaling is important. Poor font scaling or over-scaling of images can be a real productivity killer when working, so you need to know how to customize it to get the most out of your system's capabilities. Advantages of Custom Zoom: This is a useful feature for people who have difficulty reading text on the screen. It helps you see more on the screen at one time. You can create custom extension profiles that apply only to certain monitors and applications. Can help improve the performance of low-end hardware. It gives you more control over what's on your screen. How to use Windows 11

Screen brightness is an integral part of using modern computing devices, especially when you look at the screen for long periods of time. It helps you reduce eye strain, improve legibility, and view content easily and efficiently. However, depending on your settings, it can sometimes be difficult to manage brightness, especially on Windows 11 with the new UI changes. If you're having trouble adjusting brightness, here are all the ways to manage brightness on Windows 11. How to Change Brightness on Windows 11 [10 Ways Explained] Single monitor users can use the following methods to adjust brightness on Windows 11. This includes desktop systems using a single monitor as well as laptops. let's start. Method 1: Use the Action Center The Action Center is accessible

In iOS 17, Apple introduced several new privacy and security features to its mobile operating system, one of which is the ability to require two-step authentication for private browsing tabs in Safari. Here's how it works and how to turn it off. On an iPhone or iPad running iOS 17 or iPadOS 17, Apple's browser now requires Face ID/Touch ID authentication or a passcode if you have any Private Browsing tab open in Safari and then exit the session or app to access them again. In other words, if someone gets their hands on your iPhone or iPad while it's unlocked, they still won't be able to view your privacy without knowing your passcode
