Hey guys,

I know this isn't really the point of the forum, but I figure it's still script related, so hopefully be ok.
I'm looking for suggestions or recommendations on how to improve my script to get data from a MySQL database.
I've looked over the forums already, and know there no way for plus to do it directly (at least no simple way), but I figured there still may be a much more efficient way than I currently have set up.

At the moment, data is added to MySQL via php pages, which then read the entire database into an xml file, which is accessed by my script.  At the moment however, this takes a good 10 seconds on my connection, and over a minute on a friends, which isnt really a great time especially with the database growing, so I need an alternative.

My best thought at the moment (best meaning hopefully will work but I dont really have a clue) is to make xml a file extension that is handled by php, and use $_POST or $_GET for the search term, but I cant do this currently (changing server tomorrow to hopefully get the ability).

I just thought I'd throw my hat in, see if anyone can suggest anything better for the system.

Cheers
Leroux

I would support the POST o GET method, and depending on the amount of dta being sent, a JSON object might be a bit better.

Cheers MeEtc.  I've neevr used JSON before, but it looks like it might be quite good and easy to implement.  Only gonna be downloading 5 different things.
For my limits, will definitly be easier to write a JSON script than an xml one (as far as my tests have shown.

Cheers for the input man.

JSON is terribly simple. Make a PHP array, output the result of json_encode of your array and eval() it in JScript.

If you want to go one step further, you could steal some functions from a JavaScript framework like PrototypeJS or jQuery to check the received JSON code for any potentially malicious code, such as function calls. However in a case of a simple Plus! script, you probably won't really need such extra security measures.

quote:

---

Originally posted by Matti
JSON is terribly simple. Make a PHP array, output the result of json_encode of your array and eval() it in JScript.

---

quote:

---

Originally posted by Leroux
..., would it be possible to have multiple things determined by case?

---

php code:

---

<?php
$test = array(
    "foo" => "bar",
    "FoO" => "cookie"
);
?>

---

js code:

---

var test = {
    "foo" : "bar",
    "FoO" : "cookie"
};

---

OK guys, I've finally set up the site, to add a json output, using php.
I'm a bit unclear as to how to do it on the msgpus side however.
Do I just download the page as a variable using XMLHTTP or is there another step in it, and then how do I eval() it?

I'm trying to test with http://arkanes-arkade.co.uk/x360/json.php?id=Sonic%20the%20hedgehog because I know sonic changes with the case.  Everything I've read seems to want something such as JSON[0] to define the info.  Would that make this gameid[0], where gameid is either SONIC THE HEDGEHOG or Sonic The Hedgehog?

Sorry to keep bothering.  I am trying to learn, I promise.

quote:

---

Originally posted by Leroux
I'm a bit unclear as to how to do it on the msgpus side however.
Do I just download the page as a variable using XMLHTTP or is there another step in it, and then how do I eval() it?

---

code:

---

{"foo":"bar","FoO":"cookie"}

---

JScript code:

---

xmlhttp.onreadystatechange = function(){
    if (xmlhttp.readyState == 4 && xmlhttp.status == 200){
        var results = eval( '(' + xmlhttp.responseText + ')' );
        Debug.Trace(results.foo);
        Debug.Trace(results.FoO);
    }
}

---

quote:

---

Originally posted by Leroux

I'm trying to test with http://arkanes-arkade.co.uk/x360/json.php?id=Sonic%20the%20hedgehog because I know sonic changes with the case.  Everything I've read seems to want something such as JSON[0] to define the info.  Would that make this gameid[0], where gameid is either SONIC THE HEDGEHOG or Sonic The Hedgehog?

---

quote:

---

Originally posted by felipEx

Unfortunately that website doesn't seem to be loading here... just wondering what do you get as output so we can have a look.
Also, you might want try out this online-JSON-editor and play around with JSON

---

code:

---

SONIC THE HEDGEHOG:{"Title":"Sonic The Hedgehog","PSM":"A blue streak speeds by - It\\'s Sonic The Hedgehog"}
Sonic The Hedgehog:{"Title":"Sonic The Hedgehog","PSM":"Faster than the naked eye - It\\'s Sonic The Hedgehog"}

---

code:

---

var results = eval( "(" + http.responseText + ")" );

---

quote:

---

Originally posted by Leroux
I'm having trouble with the eval function however.  I kept getting "Error: Expected ';' (code: -2146827284)".  Now that I've changed it to your however, with the extra "(" and ")" in it, I instaed get "Error: Expected ')' (code: -2146827282)".

- Out of interest, why are the extra brackets added?  Just so I fully understand the code I use.

---

code:

---

SONIC THE HEDGEHOG:{"Title":"Sonic The Hedgehog","PSM":"A blue streak speeds by - It\\'s Sonic The Hedgehog"}
Sonic The Hedgehog:{"Title":"Sonic The Hedgehog","PSM":"Faster than the naked eye - It\\'s Sonic The Hedgehog"}

---

code:

---

{"results": [
        {"Title": "Sonic The Hedgehog", "PSM": "A blue streak speeds by - It\\'s Sonic The Hedgehog"},
        {"Title": "Sonic The Hedgehog", "PSM": "Faster than the naked eye - It\\'s Sonic The Hedgehog"},
        {"Title": "Sonic The Hedgehog", "PSM": "test"}
    ]
}

---

JScript code:

---

        xmlhttp.onreadystatechange = function(){
            if (xmlhttp.readyState == 4 && xmlhttp.status == 200){
                var json = eval( '(' + xmlhttp.responseText + ')' );
               
                for (var x = 0; x < json.results.length; x++){
                    Debug.Trace(json.results[x].Title + "\n" + json.results[x].PSM);
                }
               
            }
        }

---

quote:

---

Originally posted by Leroux
- Out of interest, why are the extra brackets added?  Just so I fully understand the code I use.

---

quote:

---

The text must be wrapped in parens to avoid tripping on an ambiguity in JavaScript's syntax.

---

Matti - Thanks for the info.  Just helps.  I prefer to use code I understand properly, rather than just anything that works.

quote:

---

Originally posted by felipEx

I got a better way to organize this output and deal it with JScript.

code:

---

{"results": [
        {"Title": "Sonic The Hedgehog", "PSM": "A blue streak speeds by - It\\'s Sonic The Hedgehog"},
        {"Title": "Sonic The Hedgehog", "PSM": "Faster than the naked eye - It\\'s Sonic The Hedgehog"},
        {"Title": "Sonic The Hedgehog", "PSM": "test"}
    ]
}

---

---