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
Ïà¹ØÎĵµ£º
subject of application domain of flash and air.
ÔÚflash»òflexÖУ¬³ÌÐò¼ÓÔØÍⲿswfÎļþ£¬¸ÃÎļþµÄ³ÌÐòÓòĬÈÏΪÖ÷³Ì ÐòÓòµÄÒ»¸ö×ÓÓòÖС£±ÈÈçÄãʹÓÃA.swf¼ÓÔØB.swfÎļþ£¬B±»¼ÓÔغ󣬳ÉΪA³ÌÐòÓòµÄÒ»¸ö×ÓÓò£¬×ÓÓòÊÇÉêÃ÷ÀàµÄʱ£¬²»Äܸ²¸Ç¸¸ÀàÒÑÉêÃ÷ÀࣺÈç¹ûAÖж¨ ÒåÁËÀàcom.sogou.MapÀ࣬ͬʱBÖÐÒ²¶¨ÒåÁËcom.sogou.MapÀ࣬µ ......
Òý×Ó£º×÷ÓÚÒ»ÃûÓÉASP.NET¿ª·¢×ªµ½Flex¿ª·¢µÄ³ÌÐòÔ±£¬×ʼÊÊÓ¦µÄ¹ý³ÌÊÇÏ൱ÓäÔúÍÇáËɵġ£ÓÉÓÚÎÒÔçÔÚASP.NETÖÐÏ°¹ßÁ˱êǩʽµÄ²¼¾ÖºÍ¶ÔÓ¦µÄcode behindµÄ±à³Ì·½Ê½£¬ÔÚFlexÖеÄMXMLÓïÑÔÖ»²»¹ýÊÇMXMLÔªËغÍAS3Óï·¨µÄÖØÐÂÊìϤ¡£µ«ÊǾÍÏñASP.NETÖеıê¼ÇÓïÑÔ£¬MXMLÖ»²»¹ýÊÇAS3µÄÒ»ÖÖ·â×°£¬¹é¸ùµ½µ×Ëü»á±»×ª»¯³ÉAS3ÔÙ½øÐбàÒë£¬Ë ......
¶ÔÓÚÿ¸öÀàÐÍÓµÓеÄÖµ·¶Î§ÒÔ¼°²¢ÇÒÖ¸¶¨ÈÕÆÚºÎʱ¼äÖµµÄÓÐЧ¸ñʽµÄÃèÊö¼û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 ......
2009-05-05
´ò¿ªMySQLÔ¶³Ì·ÃÎÊȨÏÞ
¹Ø¼ü×Ö: mysql
1¡¢¸Ä±í·¨
¡¡¡¡¿ÉÄÜÊÇÄãµÄÕʺŲ»ÔÊÐí´ÓÔ¶³ÌµÇ½£¬Ö»ÄÜÔÚlocalhost¡£Õâ¸öʱºòÖ»ÒªÔÚlocalhostµÄÄÇ̨µçÄÔ£¬µÇÈëmysqlºó£¬¸ü¸Ä "mysql" Êý¾Ý¿âÀïµÄ "user" ±íÀïµÄ "host" Ï´Ó"localhost"¸Ä³Æ"%"
¡¡¡¡mysql -u root -p
mysql>use mysql;
¡¡¡¡mysql>upda ......
¾ÍÏóÐí¶àµÄPHP¿ª·¢ÕßÒ»Ñù£¬ÔÚ¸Õ¿ªÊ¼½¨Á¢¶¯Ì¬ÍøÕ¾µÄʱºò£¬ÎÒ¶¼ÊÇʹÓÃÏà¶Ô¼òµ¥
µÄÊý¾Ý½á¹¹¡£PHPÔÚÁ¬½ÓÊý¾Ý¿â·½ÃæµÄȷʵÊÇÊ®·Ö·½±ã£¨ÒëÕß×¢£ºÓÐЩÈËÈÏΪPHPÔÚÁ¬½Ó²»Í¬Êý¾Ý¿âʱûÓÐÒ»¸öͳһµÄ½Ó¿Ú£¬²»Ì«·½±ã£¬ÆäʵÕâ¿ÉÒÔͨ¹ýһЩÀ©
Õ¹¿âÀ´×öµ½ÕâÒ»µã£©£¬ÄãÎÞÐè¿´´óÁ¿µÄÉè¼ÆÎĵµ¾Í¿ÉÒÔ½¨Á¢ºÍʹÓÃÊý¾Ý¿â£¬ÕâÒ²ÊÇPHP»ñµÃ³É¹¦µÄÖ÷ ......