½«mysqlµÄÊý¾Ýת³Éxml
Çó¸öPHPÀà
ÒýÓà ÐèÇó²»Ã÷È·! ¾ßÌåÐèÇóÊÇ http·½Ê½ ½«Ò»Ð©Êý¾Ý·µ»Øxml¸ø¶Ô·½ Ê×ÏÈ µÃ½«Êý¾Ý¿âµÄÊý¾ÝÈ¡³öÀ´ºó£¬×ª³Éxml£¬ http://www.ibm.com/developerworks/cn/opensource/os-xmldomphp/ÒýÓà ÒýÓà 1 Â¥ jakey9826 µÄ»Ø¸´: ÐèÇó²»Ã÷È·! ¾ßÌåÐèÇóÊÇ http·½Ê½ ½«Ò»Ð©Êý¾Ý·µ»Øxml¸ø¶Ô·½ Ê×ÏÈ µÃ½«Êý¾Ý¿âµÄÊý¾ÝÈ¡³öÀ´ºó£¬×ª³Éxml£¬ Èç¹ûÊý¾ÝÁ¿²»ÊǺܴóµÄ»°,¿ÉÒÔ½«Êý¾Ý´æ³ÉÊý×é,È»ºóÔÙ½«Êý×éת³Éxml. µ±È»Ò²¿ÉÒÔÑ»·È¡³öÔÙÀûÓÃdomxmlµÈÉú³Éxml ÎÒ»¹ÊÇϲ»¶ÓÃ×Ö·û´®²Ù×÷¡£ xmlÒ²¾ÍÊÇÒ»¶Î×Ö·û´®°ÕÁË¡£×ö×Ö·û´®Ì滻ȻºóÊä³ö×î¼òµ¥ÁË¡£ echo " <root> <title>".$title." </title> </root>"; ´æ³ÉÊý×éת»¯xml e4x·¨½âÎö ÔÚ³ÌÐò¿ªÍ·¼ÓÉÏ if ( stristr($_SERVER["HTTP_ACCEPT"],"application/xhtml+xml") ) { header("Content-type: application/xhtml+xml;charset=utf-8"); } else { header("Content-type: text/xml;charset=utf-8"); } xmlÖ»ÊÇÒ»ÖÖ¸ñʽºÍhtmlÒ»Ñù. ¾ÍÊÇÉú³É xml ºÃÁË Ð´¸ö º¯Êý²»¾ÍOKÁË
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4 mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓᣠ×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£ Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£ºError 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it. ¿ ......
ÓÐÒ»ÌõsqlÓï¾ä select a.name ,b.name from tableA a,tableB b where a.id = b.id and ¡£¡£¡££¨ÆäËû¹ýÂËÌõ¼þ£© ÆäÖÐa.id ΪtableAÖ÷¼ü ÓÐΨһÐÔË÷Òý Êý¾ÝÁ¿²Å1ǧ¶à b.id ΪÈÕÖ¾±ítableB µÄÍâ¼ü £¬ÂýÈ¥Ìõ¼þµÄ²Å ......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡ лл¸÷λÁË ¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î ±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡ ллÁË ¼Æ»®ÈÎÎñ...php....sql...truncate....OK Äã¾ÍÕâ½ÓÔÚҳà ......
SQL code: create PROCEDURE aa(SqlCMD1 varchar(8000),SqlCMD2 varchar(8000),SqlCMD3 varchar(8000)) begin declare exit handler for sqlexception rollback; start TRANSACTION; EXECUTE SqlCMD1; EXE ......