yfa76550
yfa76****@nifty*****
2012年 1月 13日 (金) 18:37:57 JST
$B7*ED$G$9!#(B $B?'!9C5$7$?$j!";n9T:x8m$7$F$_$^$7$?$,!"$I$&$7$F$b=PMh$^$;$s!#(B $B$I$J$?$+%"%I%P%$%9D:$1$^$;$s$+!)(B $B$3$N>l$G!"$3$&$$$&<ALd$,$^$:$1$l$P!"E,Ev$J%5%$%H$r$*65$(2<$5$$!#(B === $B!IE0Dl!I$NK\$K$"$k%5%s%W%k-!(B(chapter 11 - dbutil2.php)$B$r$=$N$^$^%$%s%]!<%H$7$?$N$G$9$,!"(B $B7k2L$O!"0J2<$NMM$K!"2~9T$,$5$l$:!"%?%0$bIU$-$^$;$s!#(B 1 $B%j%s%4(B $B=)(B $B%P%i2J(B 2012-01-11 01:14:52 2 $B%&%s%7%e%&%_%+%s(B $BE_(B $B%_%+%s2J(B 2012-01-11 01:14:52 3 $B%V%I%&(B $B=)(B $B%V%I%&2J(B 2012-01- $B$=$NA0$N%5%s%W%k(B(chapter 11 - dbutil1.php$B!K!!(Bcsv_from_result$B!!$N7k2L$O0J2<$NMM$K(BOK$B$J$N$G!"(B $B4pK\E*$J=j$OLdBj$J$$$N$+$H;W$$$^$9!#(B ($BC"$7!"(Bv1,6$B$d(Bv1.7$B$G$O!"(Bcsv$B$b2~9T$5$l$:(B1$B9TI=5-!"%?%0$O$D$-$^$9$,!#!#!K(B "id","name","season","family","modified", "1","$B%j%s%4(B","$B=)(B","$B%P%i2J(B","2012-01-11 01:14:52", "2","$B%&%s%7%e%&%_%+%s(B","$BE_(B","$B%_%+%s2J(B","2012-01-11 01:14:52", $B-!%5%s%W%k$N<L$7$G$9!#(BCI_$BIU2C(B <?php /* * $B%G!<%?%Y!<%9%f!<%F%#%j%F%#%/%i%9(B $BMxMQNc(B2 * XML$B$N ＠ 8@.(B */ class Dbutil2 extends CI_Controller { function index() { // $B%G!<%?%Y!<%9%f!<%F%#%j%F%#%/%i%9$N%m!<%I(B $this->load->dbutil(); // $B8!:w(B $query = $this->db->query("SELECT * FROM fruits"); // XML$B$N ＠ _Dj(B $config = array ( 'root' => 'root', 'element' => 'element', 'newline' => "\n", 'tab' => "\t" ); // XML$B$N=PNO(B echo $this->dbutil->xml_from_result($query, $config); } } ?> $B-"%@%&%s%m!<%I$7$?!!(Bsystem\database\DB_utility.php$B!!$N<L$7$G$9!#(B xml_from_result$B!!$N$H$3$m$NH4?h(B /** * Generate XML data from a query result object * * @access public * @param object The query result object * @param array Any preferences * @return string */ function xml_from_result($query, $params = array()) { if ( ! is_object($query) OR ! method_exists($query, 'list_fields')) { show_error('You must submit a valid result object'); } // Set our default values foreach (array('root' => 'root', 'element' => 'element', 'newline' => "\n", 'tab' => "\t") as $key => $val) { if ( ! isset($params[$key])) { $params[$key] = $val; } } // Create variables for convenience extract($params); // Load the xml helper $CI =& get_instance(); $CI->load->helper('xml'); // Generate the result $xml = "<{$root}>".$newline; foreach ($query->result_array() as $row) { $xml .= $tab."<{$element}>".$newline; foreach ($row as $key => $val) { $xml .= $tab.$tab."<{$key}>".xml_convert($val)."</{$key}>".$newline; } $xml .= $tab."</{$element}>".$newline; } $xml .= "</$root>".$newline; return $xml; } $B$A$J$_$K!"(BcodeIgniter$B$r;H$o$:$K!"(BPEAR$B$N!I(BXML/Serializer.php$B!I$G!"JL$N%9%/%j%W%H$G$d$k$H!"(BXML$B$, ＠ 8@.=PMh$^$9$,!"(B PEAR$B$r(BcodeIgniter$B$K%$%s%]!<%H$7$F<B9T$9$k$H!"2~9T!&%?%0$J$7!"$H$J$j$^$9!#(B PEAR$B$NB>$N4X?t!J(BSpreadsheet_Excel_Writer$B!K$O(BOK$B$J$N$G!"$3$l$b2?$+HyL/$J=j$,860x$+$H!#(B $BD9J8$G$9$_$^$;$s!#(B $B59$7$/$*4j$$CW$7$^$9!#(B
