Tag zusammen,
könnt ihr mir sagen wo der Fehler liegt ? Ich finde ihn einfach nicht:
PHP-Code:
<?php
$server = "";
$username = "";
$password = "";
$database_name = "";
header ( 'Content-type: text/xml' );
mysql_connect ( $server, $username, $password ) or die ( mysql_error () );
mysql_select_db ( $database_name );
$user = mysql_real_escape_string ($_GET ['user']);
$sqlResult = mysql_query ( "SELECT username, message_count, last_activity, user_state, alerts_unread, conversations_unread
FROM xf_user WHERE username='$user'" );
if (! $result) {
$error = mysql_error ();
echo "<error>$error</error>";
} else if ($row = mysql_fetch_array ( $sqlResult )) {
echo "<user>\n";
foreach ( $row as $column => $value ) {
echo "\t<$column>$value</$column>\n";
}
echo "</user>\n";
} else {
echo "<noUser/>";
}
mysql_free_result($result);
mysql_close ();
?>
Lesezeichen