Hello, need a little help with a php script.

slackbear · #1 (**permalink**) 01-09-2008, 06:09 AM

Hello,I'm new here xD

Me and a friend are working on a sql type database using xml rss feeds, the problem is the lines like this:

$feed->table_name_."$table"

and i'm not sure exactly how to resolve this, i've tried everything i can think of.Any help would be appreciated =)

here's the code i've got so far:

PHP Code:


			
function readdb($file, $table, $row, $db, $field) {
    $feed = new SimpleXMLElement($file, null, true);
        foreach ($feed->table_name_."$table" as $theTable) { 
            foreach ("$theTable->row_name_".$row as $theRow) {
                foreach ("$theRow->db_".$db as $theDB) {
                    foreach ($theDB->children() as $child) {
                        switch ($child->getName()) {
                            case '$field':
                                return "$child<br />\n";
                            break;           
                        }
                    } 
                }
            }
        }
    }

and here's what we started with:

PHP Code:


			
$db = simplexml_load_file('feed.xml');

function readdb($table, $row, $coldb, $colname) {
return "$db->table_name_$table->row_name_$row->col_db_$coldb->col_name_$colname";
}
print readdb(test, rtest, 1, user);
echo "<hr>";
print $db->table_name_test->row_name_rtest->col_db_1->col_name_user;

?>

weblizzer · #2 (**permalink**) 01-31-2008, 09:17 PM

Quote:

Originally Posted by slackbear

Hello,I'm new here xD

Me and a friend are working on a sql type database using xml rss feeds, the problem is the lines like this:

$feed->table_name_."$table"

and i'm not sure exactly how to resolve this, i've tried everything i can think of.Any help would be appreciated =)

here's the code i've got so far:

PHP Code:


			
function readdb($file, $table, $row, $db, $field) {

    $feed = new SimpleXMLElement($file, null, true);

        foreach ($feed->table_name_."$table" as $theTable) { 

            foreach ("$theTable->row_name_".$row as $theRow) {

                foreach ("$theRow->db_".$db as $theDB) {

                    foreach ($theDB->children() as $child) {

                        switch ($child->getName()) {

                            case '$field':

                                return "$child<br />\n";

                            break;           

                        }

                    } 

                }

            }

        }

    }

and here's what we started with:

PHP Code:


			
$db = simplexml_load_file('feed.xml');



function readdb($table, $row, $coldb, $colname) {

return "$db->table_name_$table->row_name_$row->col_db_$coldb->col_name_$colname";

}

print readdb(test, rtest, 1, user);

echo "<hr>";

print $db->table_name_test->row_name_rtest->col_db_1->col_name_user;

?>

please change the

PHP Code:


			
foreach ($feed->table_name_."$table" as $theTable) {

to

PHP Code:


			
foreach ("$feed->table_name_".$table as $theTable) {



// OR 



foreach ("$feed->table_name_$table" as $theTable) {

HOPE ANY OF THAT ARE CORRECT

i didn't try it yet so just try to play any of it

slackbear · #3 (**permalink**) 02-06-2008, 05:21 PM

Thanks for your reply, i figured no one would respond after the firt two weeks.I have already tried that way, and for the sake of it...i retried and i still get this error:

Warning: Invalid argument supplied for foreach() in /var/www/wtfhax.net/xml.php on line 13

If you run accross anything let me know

weblizzer · #4 (**permalink**) 02-19-2008, 08:53 AM

IF you encounter that error meaning, their are no supplied value to be loop in for each so you might to check first the array if the sizeof($yourarray) > 0 then it executes or else nothing to loop.

skyfe · #5 (**permalink**) 03-09-2008, 12:24 PM

shouldn't this part:

Quote:

foreach ($feed->table_name_."$table" as $theTable) {
foreach ("$theTable->row_name_".$row as $theRow) {
foreach ("$theRow->db_".$db as $theDB) {

be:

Code:

        foreach ($feed->table_name_.$table as $theTable) { 
            foreach ($theTable->row_name_.$row as $theRow) {
                foreach ($theRow->db_.$db as $theDB) {

this?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode