Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

AmfphpÓëFlex½»»¥:¶ÁÈ¡mysqlÊý¾Ý

·þÎñÆ÷¶Ë´úÂë,amfphpµÄservicesĿ¼Ï½¨Á¢readData.phpÎļþ,´úÂëÈçÏÂ
<?php
    class ReadDB
    {
              function getData()
             {
                  mysql_connect("localhost","root","root");
                  mysql_select_db("mmmm");
                  mysql_query("SET NAMES UTF8");
                  $sql="select * from mmmm";
                  return mysql_query($sql);
             }
    }
?>
flex´úÂë
<?xml version="1.0" encoding="utf-8"?>
<mx:Application xmlns:mx="http://www.adobe.com/2006/mxml" layout="absolute" backgroundColor="#FFFFFF">
    <mx:RemoteObject id="myservice" fault="FaultHandler(event)" showBusyCursor="true" source="ReadDB" destination="amfphp">
        <mx:method name="getData" result="ReadHandler(event)" />
    </mx:RemoteObject>
<mx:Script>
        <![CDATA[
            import mx.managers.CursorManager;
            import mx.rpc.events.ResultEvent;
            import mx.rpc.events.FaultEvent;
            //×¢£º´íÎó´¦Àíº¯Êý
   &nb


Ïà¹ØÎĵµ£º

Flex¶àSWFÎļþ¼ÓÔØÖ®Applicatoin Domain

¸ÅÒª
µ±ÎÒÃǼÓÔØÍⲿswfʱ£¬±ØÐëÒªÁ˽âÓ¦ÓóÌÐòÓò(Application Domain)¡£´ÓAdobe¹Ù·½ÎļþÖУ¬ÎÒÃÇ¿ÉÒÔµÃÖªÓ¦ÓóÌÐòÓòÄܹ»°Ñ´¦ÓÚͬһ¸ö°²È«Óò(Security Domain)ÖеÄÀà·ÖÀ뿪£¬ÕâÑù¾Í¿ÉÒÔÈÃÒ»¸öÀàµÄ¶à¸ö¶¨Òå¹²´æ£¬»òÊÇÈöà¸ö×ÓÓ¦ÓÃÀ´¹²Ïí¸¸Ó¦ÓõÄÀඨÒå¡£¼òµ¥µãÀí½â¾ÍÊÇÓ¦ÓóÌÐòÓòΪÀඨÒåÌṩÁË·ÖÇø¹¦ÄÜ¡£
Ó¦ÓóÌÐòÓò
Ò»¸ ......

ÔÙ̸mysqlµÄÅäÖÃÎļþmy.ini or my.cnf (Ö®Ò»)

ÈçÈôתÔر¾ÎÄ£¬Çë×¢Ã÷ԭʼ³ö´¦£ºhttp://hi.baidu.com/hexiong/blog/item/e860e5dd9b0d3ae376c6381a.html
(hexiong@baidu or iihero@CSDN)
ż¶ûÅöµ½ÓÐÈËÎÊʹÓÃmysqlÃüÁîÐУ¬ÀÏÈÃÈËÊäÈë--default-character-set=gbkÖ®ÀàÎÞÁĵÄÑ¡ÏÈÃÈË·³¡£ÈÃÈ˶àÊäÈëÁ˼¸¸ö×Ö·û£¬È·ÊµÓе㲻¶Ô¾¢¡£
¼ÓÉÏÓÐʱºò×Ô¼ºÓÐʱºòDIY£¬ºÜÉÙÔÚwindow ......

Mysql ÈÕÆÚºÍʱ¼äת»»º¯Êý´óÈ«

¶ÔÓÚÿ¸öÀàÐÍÓµÓеÄÖµ·¶Î§ÒÔ¼°²¢ÇÒÖ¸¶¨ÈÕÆÚºÎʱ¼äÖµµÄÓÐЧ¸ñʽµÄÃèÊö¼û7.3.6 ÈÕÆÚºÍʱ¼äÀàÐÍ¡£
ÕâÀïÊÇÒ»¸öʹÓÃÈÕÆÚº¯ÊýµÄÀý×Ó¡£ÏÂÃæµÄ²éѯѡÔñÁËËùÓмǼ£¬Æädate_colµÄÖµÊÇÔÚ×îºó30ÌìÒÔÄÚ£º
mysql> SELECT something from table
WHERE TO_DAYS(NOW()) - TO_DAYS(date_col) select DAYOFWEEK('1998-02-03');
-&g ......

mysqlÃüÁ½õ

mysql
ÃüÁ½õ
²âÊÔ»·¾³£ºmysql 5.0.45
¡¾×¢£º¿ÉÒÔÔÚmysql
ÖÐͨ¹ýmysql>
SELECT VERSION();
À´²é¿´Êý¾Ý¿â°æ±¾¡¿

Ò»¡¢Á¬½ÓMYSQL
¡£

¸ñʽ£º mysql -h
Ö÷»úµØÖ· -u
̞
£­p
Óû§ÃÜÂë
1
¡¢Á¬½Óµ½±¾»úÉϵÄMYSQL
¡£

Ê×ÏÈ´ò¿ªDOS
´°¿Ú£¬È»ºó½øÈëĿ¼mysql\bin
£¬ÔÙ¼üÈëÃüÁîmysql -u r ......

.NETÁ¬½ÓMySqlÊý¾Ý¿âµÄ·½·¨¼°Ê¾Àý

·½·¨Ò»£º
ʹÓÃMySQLÍƳöµÄMySQL Connector/Net×é¼þ£¬ ¸Ã×é¼þÊÇMySQLΪADO.NET·ÃÎÊMySQLÊý¾Ý¿âÉè¼ÆµÄ.NETרÓ÷ÃÎÊ×é¼þ¡£Íê³É¸Ã×é¼þºó£¬ÐèÒªÔÚÏîÄ¿ÖÐÒýÓÃÕâ¸ö×é¼þ£¬Ò²¿ÉÒÔÖ±½ÓÔÚÅäÖÃÎļþµÄ<assemblies>½ÚµãÄÚÌí¼ÓÏÂÃæµÄ½Úµã£º
<add assembly="MySql.Data, Version=5.1.5.0, Culture=neutral, PublicKeyToken=C5687 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ