Re: Dumping, Storing, and Displaying XML data with PHP and MySQL

[fastest963]

Do:
----------------------------------------------------------------------------------
//connect to database
(code)

$query = sprintf("INSERT INTO TABLE+NAME (`time`, `body`, `favorited`,
`name`,
`description`, `avatar`, `url`, `twitterid`) VALUES ('%s', '%s', '%s',
'%s', '%s', '%s', '%s', '%s')",
                mysql_real_escape_string($xml->status->created_at),
                mysql_real_escape_string($xml->status->text),
                mysql_real_escape_string($xml->status->favorited),
                mysql_real_escape_string($xml->status->user->name),
                mysql_real_escape_string($xml->status->user-
>description),
                mysql_real_escape_string($xml->status->user-
>profile_image_url),
                mysql_real_escape_string($xml->status->user->url),
                mysql_real_escape_string($xml->status->id));
mysql_query($query) or die(mysql_error());

echo "Data Inserted!";

mysql_close ();
----------------------------------------------------------------------------------