dongyuli4538 2014-12-08 10:49
浏览 18

向远程数据库发出ajax请求[重复]

This question already has an answer here:

i have built a multi search form, that queries a database, by making an ajax request, it works fine and i can query my database and display the results in a div without reloading my page.

but now i am try to query a database on a remote a server,

and i was thinking by adding the full url of the domain where the database was hosted i would be able to query the database, but i have founded out that it would take more than that.

this is what has worked for me normally

function showUser() {
    if (showUser == "") {
        document.getElementById("txtHint").innerHTML = "";

        return;
    } else { 
        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) {
                document.getElementById("txtHint").innerHTML = xmlhttp.responseText;
            }
        }
        var usersvalue=encodeURIComponent(document.getElementById("users").value)
var uservalue=encodeURIComponent(document.getElementById("user").value)
        xmlhttp.open("GET","getuserwrong.php?users="+usersvalue+"&user="+uservalue, true);


        xmlhttp.send();

as we can see here this was a direct connect to my php file that queries my database.

and this is what i have tried out, when trying to query my database on a remote server, that hasnt worked

function showUser() {
    if (showUser == "") {
        document.getElementById("txtHint").innerHTML = "";

        return;
    } else { 
        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) {
                document.getElementById("txtHint").innerHTML = xmlhttp.responseText;
            }
        }
        var usersvalue=encodeURIComponent(document.getElementById("users").value)
var uservalue=encodeURIComponent(document.getElementById("user").value)
        xmlhttp.open("GET","http://whitechapelandpartners.com/getuserwrong.php?users="+usersvalue+"&user="+uservalue, true);


        xmlhttp.send();

as we can see here i have added the domain name to where i have setup my database remotely

i am not sure what i have done wrong here, because using this method when i try to query my database on the remote server nothing happens

any usefull suggestions. Regards

</div>
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 华为ensp模拟器中S5700交换机在配置过程中老是反复重启
    • ¥15 java写代码遇到问题,求帮助
    • ¥15 uniapp uview http 如何实现统一的请求异常信息提示?
    • ¥15 有了解d3和topogram.js库的吗?有偿请教
    • ¥100 任意维数的K均值聚类
    • ¥15 stamps做sbas-insar,时序沉降图怎么画
    • ¥15 买了个传感器,根据商家发的代码和步骤使用但是代码报错了不会改,有没有人可以看看
    • ¥15 关于#Java#的问题,如何解决?
    • ¥15 加热介质是液体,换热器壳侧导热系数和总的导热系数怎么算
    • ¥100 嵌入式系统基于PIC16F882和热敏电阻的数字温度计