問(wèn)題描述

所以我發(fā)現(xiàn)了這個(gè)將mysql查詢轉(zhuǎn)換為XML頁(yè)面的很棒的函數(shù)，它看起來(lái)正是我需要的.唯一的問(wèn)題是它使用了 mysql，但不再受支持，而且結(jié)果使用的函數(shù)之一不在 mysqli 中.有誰(shuí)知道 mysql_field_name 的替代方法?

So I found this great function that converts mysql queries into a XML page, and it looks like exactly what I need. The only problem is that it uses mysql, but thats not supported anymore, and it turns out one of the functions used isn't in mysqli. Does anyone know of an alternative to mysql_field_name?

這是我找到的函數(shù)

function sqlToXml($queryResult, $rootElementName, $childElementName)
{ 
$xmlData = "<?xml version="1.0" encoding="ISO-8859-1" ?>
"; 
$xmlData .= "<" . $rootElementName . ">";

while($record = mysql_fetch_object($queryResult))
{ 
    /* Create the first child element */
    $xmlData .= "<" . $childElementName . ">";

    for ($i = 0; $i < mysql_num_fields($queryResult); $i++)
    { 
        $fieldName = mysql_field_name($queryResult, $i); 

        /* The child will take the name of the table column */
        $xmlData .= "<" . $fieldName . ">";

        /* We set empty columns with NULL, or you could set 
            it to '0' or a blank. */
        if(!empty($record->$fieldName))
            $xmlData .= $record->$fieldName; 
        else
            $xmlData .= "null"; 

        $xmlData .= "</" . $fieldName . ">"; 
    } 
    $xmlData .= "</" . $childElementName . ">"; 
} 
$xmlData .= "</" . $rootElementName . ">"; 

return $xmlData; 
}

有問(wèn)題的部分是

$fieldName = mysql_field_name($queryResult, $i);

謝謝

邁克

推薦答案

有很多方法可以做到，我猜最相似的是:

There are many ways to do it, I guess the most similar would be:

$fieldName = mysqli_fetch_field_direct($result, $i)->name;

http://www.php.net/手冊(cè)/en/mysqli-result.fetch-field-direct.php

這篇關(guān)于mysqli 中 mysql_field_name 的替代方案的文章就介紹到這了，希望我們推薦的答案對(duì)大家有所幫助，也希望大家多多支持html5模板網(wǎng)！