#39892 [Opn->Fbk]: fetch_fields / fetch_field_direct

ID: 39892 Updated by: tony2001@php.net Reported By: migues at email dot cz -Status: Open +Status: Feedback Bug Type: MySQLi related Operating System: Win XP Pro SP2 PHP Version: 5.2.0 New Comment: It might become really simple as soon as I get what you're talking about. At the moment I don't get it, sorry. Previous Comments: ------------------------------------------------------------------------ [2006-12-19 21:56:49] migues at email dot cz Hey guys! Sorry I'm quite novice so it would took me long time to reproduce step by step creation a.s.o. But it's simple : def $res->fetch_fields(); in returns always null! I guess it will work always the same on other mysql 5.0... with mysqli_result object ------------------------------------------------------------------------ [2006-12-19 21:37:20] tony2001@php.net Thank you for this bug report. To properly diagnose the problem, we need a short but complete example script to be able to reproduce this bug ourselves. A proper reproducing script starts with <?php and ends with ?>, is max. 10-20 lines long and does not require any external resources such as databases, etc. If the script requires a database to demonstrate the issue, please make sure it creates all necessary tables, stored procedures etc. Please avoid embedding huge scripts into the report. ------------------------------------------------------------------------ [2006-12-19 21:23:11] migues at email dot cz Description: ------------ MySQL version: 5.0.27 def column for fetch_fields / fetch_field_direct is empty even if default values are set Reproduce code: --------------- $arrfields=$res->fetch_fields(); for ($i=0;$i<$res->field_count;$i++) { // /*OR */ foreach ($arrfields as $arrname=>$arrfld) //{ $arrfld=$res->fetch_field_direct($i); $fldinfo->appendChild($fldNode=$this->DOM->createElement(dbtag_field)); $fldNode->setAttribute(dbtag_fieldname,$arrfld->name); $fldNode->setAttribute(dbtag_fieldorgname,$arrfld->orgname); foreach($arrfld as $key=>$val) { $fldNode->appendChild($this->DOM->createElement($key,$val)); }}; Expected result: ---------------- <name>fieldname</name> .... <def>default _ value</def> .... Actual result: -------------- <name>fieldname</name> .... <def></def> .... ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=39892&edit=1