Inspiring

Question

datagrid populated from mysql dbase using php

Forum|Forum|15 years ago
August 15, 2010
2 replies
2932 views

There are three methods: loadvars, xml and flash remoting.

I have a great tutorial from Lee Brimlow but he only passes one column into a listbox.

I want various columns passed into a datagrid.

I'm not too sure how to amend the php code

<?PHP

$link = mysql_connect("Localhost","user","password");

mysql_select_db("cambridgekidsdb");

$query = 'SELECT * FROM trivia_user';

$results = mysql_query($query);

echo "<?xml version=\"1.0\"?>\n";

echo "<triviauser>\n";

while($line = mysql_fetch_assoc($results)) {

echo "<item>" . $line["user_name"] . "</item>\n";

}

echo "</triviauser>\n";

mysql_close($link);

?>

How do I "echo" out the other columns.

The flash AS3 code is:

var theXML:XML = new XML();

theXML.ignoreWhite = true;

theXML.onLoad = function() {

var nodes = this.firstChild.childNodes;

for(i=0;i<nodes.length;i++) {

theGrid.addItem(nodes.firstChild.nodeValue,i);

}

theXML.load("http://www.cambridgekids.es/trivia_user.php");

I'm almost there and this will be fundamental to my website as I can create important stats on hundreds of children.

Thank you in advance.

ActionScript

This topic has been closed for replies.

C

codeBeastAdobeAuthor

Inspiring

Hi guys.

I'm afraid I couldn't get things to work. The good news is I GOOGLED my butt off and learnt so much about PHP and mysql you wouldn't believe it.

In the end, I have been advised to convert the php code to output xml for many reasons. Flash has zero problems with xml and code is easy.

Especially now that the new XML class in AS3 makes things easy.

This is the code I got from Kirupa.

<?php

header("Content-type: text/xml");

$host = "localhost";

$user = "root";

$pass = "";

$database = "test";

$linkID = mysql_connect($host, $user, $pass) or die("Could not connect to host.");

mysql_select_db($database, $linkID) or die("Could not find database.");

$query = "SELECT * FROM blog ORDER BY date DESC";

$resultID = mysql_query($query, $linkID) or die("Data not found.");

$xml_output = "<?xml version=\"1.0\"?>\n";

$xml_output .= "<entries>\n";

for($x = 0 ; $x < mysql_num_rows($resultID) ; $x++){

$row = mysql_fetch_assoc($resultID);

$xml_output .= "\t<entry>\n";

$xml_output .= "\t\t<date>" . $row['date'] . "</date>\n";

// Escaping illegal characters

$row['text'] = str_replace("&", "&", $row['text']);

$row['text'] = str_replace("<", "<", $row['text']);

$row['text'] = str_replace(">", ">", $row['text']);

$row['text'] = str_replace("\"", """, $row['text']);

$xml_output .= "\t\t<text>" . $row['text'] . "</text>\n";

$xml_output .= "\t</entry>\n";

}

$xml_output .= "</entries>";

echo $xml_output;

?>

A

Andrei1-bKoviI

Inspiring

XML is indeed more solid, especially if your queries output contains special characters.

Just a couple of thoughts.

1. You don't need to place extra line breaks and paces into xml in PHP. First, they don't matter; second, XML will be smaller.

2. If you expect special (illegal) characters in output - you should use CDATA in the XML. This way there is no need for their replacement. For instance, the lines

// Escaping illegal characters

$row['text'] = str_replace("&", "&", $row['text']);

$row['text'] = str_replace("<", "<", $row['text']);

$row['text'] = str_replace(">", ">", $row['text']);

$row['text'] = str_replace("\"", """, $row['text']);

$xml_output .= "\t\t<text>" . $row['text'] . "</text>\n";

can be just one line:

$xml_output .= "<text><![CDATA[" . $row['text'] . "]]></text>";

Also, this is just my opinion, conceptually, I feel that PHP side shouldn't care for what is legal and what is not from a standpoint of how other application consumes the output (in this case Flash). In addition, from the standpoint of content management, it is difficult to account for all the special characters and as such it makes data vulnerable to future bugs and data entry deviations. CDATA allows for presenting data in its purest form.

C

codeBeastAdobeAuthor

Inspiring

Excellent information as always. Thanks Andrei.

My Virtual World is really coming on. When it's up and running (stunning graphics) I'll send a link. You have helped me with a lot of it ith regards optimization etc... (I owe you).(Just gonna post a new one now on the canvass size.)