| Код |
<?
$doc = new DOMDocument('1.0','windows-1251');
header('Content-Transfer-Encoding: 8bit');
header('Content-Type: text/xml; charset=UTF-8');
header('Expires: Mon, 26 Jul 1997 05:00:00 GMT');
header('Cache-Control: no-store, no-cache, must-revalidate');
header('Cache-Control: post-check=0, pre-check=0', FALSE);
header('Pragma: no-cache');
$level = $doc->createElement("response");
$doc -> appendChild($level);
require "../../confa/db.php";
$db=mysql_connect(db_server, db_user, db_passwd);
$tmp = @mysql_query("SHOW VARIABLES like 'character_set_server';");
$enc = @mysql_fetch_assoc($tmp);
@mysql_free_result($tmp);
$enc = $enc['Value'];
@mysql_query("SET character_set_client='$enc'");
@mysql_query("SET character_set_connection='$enc'");
@mysql_query("SET character_set_database='$enc'");
@mysql_query("SET character_set_results='$enc'");
unset($enc);
unset($tmp);
mysql_select_db(db_basename,$db);
$q=mysql_query("SELECT 1,2,3,4 FROM t WHERE s LIKE ................................");
$out="[";
for ($w=0; $w<mysql_num_rows($q);$w++)
{
..............
}
$root = $doc->createElement("block");
$level->appendChild($root);
$item = $doc->createElement("answer");
$root->appendChild($item);
$textid = $doc->createTextNode($out);
$item->appendChild($textid);
echo $doc->saveXML();
?>
|
если оставляю так-результат как я и написал в начале темы.
| Код |
<?
$doc = new DOMDocument('1.0','windows-1251');
header('Content-Transfer-Encoding: 8bit');
header('Content-Type: text/xml; charset=UTF-8');
header('Expires: Mon, 26 Jul 1997 05:00:00 GMT');
header('Cache-Control: no-store, no-cache, must-revalidate');
header('Cache-Control: post-check=0, pre-check=0', FALSE);
header('Pragma: no-cache');
$level = $doc->createElement("response");
$doc -> appendChild($level);
require "../../confa/db.php";
$db=mysql_connect(db_server, db_user, db_passwd);
mysql_select_db(db_basename,$db);
$q=mysql_query("SELECT 1,2,3,4 FROM t WHERE s LIKE ................................");
$out="[";
for ($w=0; $w<mysql_num_rows($q);$w++)
{
..............
}
$root = $doc->createElement("block");
$level->appendChild($root);
$item = $doc->createElement("answer");
$root->appendChild($item);
$textid = $doc->createTextNode($out);
$item->appendChild($textid);
echo $doc->saveXML();
?>
|
если так-то пишет mysql_num_rows(): supplied argument is not a valid MySQL result resource
так что что-то никак оно русский язык не хочет передавать..... |
