向东博客 专注WEB应用 构架之美 --- 构架之美，在于尽态极妍 | 应用之美，在于药到病除|赢在IT，Playin' with IT,Focus on Killer Application,Marketing Meets Technology.

// Wade Arnold: 1/6/2008
// Example is designed to show how to use PHP sessions.
package {
    // required for flash file and output display
    import flash.display.MovieClip;
    import fl.events.*;
    import flash.events.*;
    // required to send/recieve data over AMF
    import flash.net.NetConnection;
    import flash.net.Responder;

    // Flash CS3 Document Class.
    public class Counter extends MovieClip {
        private var gateway:String = "http://localhost/server/amfphp/gateway.php";
        private var connection:NetConnection;
        private var responder:Responder;
        
        public function Counter() {
            trace("AMFPHP Session Counter Example");
            // Event listner for buttons
            increment_btn.addEventListener(MouseEvent.CLICK, incrementCounter);
            reset_btn.addEventListener(MouseEvent.CLICK, resetCounter);
            destroy_btn.addEventListener(MouseEvent.CLICK, destroySession);
            // Responder to handle data returned from AMFPHP.
            responder = new Responder(onResult, onFault);
            connection = new NetConnection;
            // Gateway.php url for NetConnection
            connection.connect(gateway);
        }
    
        // Method run when the "Increment Counter" button is clicked.
        public function incrementCounter(e:MouseEvent):void {
            // Send the data to the remote server.
            connection.call("Counter.increment", responder);
        }
        // Method run when the "Rest Counter" button is clicked.
        public function resetCounter(e:MouseEvent):void {
            // Send the data to the remote server.
            connection.call("Counter.unregister", responder);
        }
        
        // Method run when the "Destroy Session" button is clicked.
        public function destroySession(e:MouseEvent):void {
            // Send the data to the remote server.
            connection.call("Counter.destroy", responder);
        }
        
        // Handle a successful AMF call. This method is defined by the responder.
        private function onResult(result:Object):void {
            response_txt.text = String(result);
        }
        
        // Handle an unsuccessfull AMF call. This is method is dedined by the responder.
        private function onFault(fault:Object):void {
            response_txt.text = String(fault.description);
        }
    }
}

<?php
// Wade Arnold: 1/6/2008
// Example is designed to show how to use PHP sessions.
class Counter {

    public function __construct() {
        // Check if the session is available or create it.
        if (!isset($_SESSION['count'])) {    
            $_SESSION['count'] = 0;
        }
    }
    // Used to increment the session variable count.
    public function increment() {
        $_SESSION['count']++;
    return $_SESSION['count'];
    }
    // used to destroy the session variable and start over.
    public function unregister() {
        unset($_SESSION['count']);
    return true;
    }
    // remove the entire session from the server.
    public function destroy() {
        session_destroy();
    return true;
    }
}
?>

$new['content'] = preg_replace('/^[(\xc2\xa0)|\s]+/', '', $new['content']);

mysql> select distinct(UserNumber),Score_TT from Tbl_Score where FYear = "2009" and FWeek = '53' order by   Score_TT desc limit 0,10;
+-----------+--------+
| UserNumber       | Score_TT |
+-----------+--------+
| 70213303* |   1800 |
| 78400557* |   1450 |
| 45598211* |   1410 |
| 7575629*  |   1200 |
| 30394912* |   1148 |
| 98649685* |   1050 |
| 6653828*  |    850 |
| 38200298* |    800 |
| 80496539* |    800 |
| 18064165* |    670 |
+-----------+--------+
10 rows in set (0.37 sec)

mysql> select count(distinct UserNumber),UserNumber,Score_TT from Tbl_Score where FYear = "2009" and FWeek = '53' group by UserNumber order by   Score_TT desc limit 0,10;
+---------------------+-----------+--------+
| count(distinct UserNumber) | UserNumber       | Score_TT |
+---------------------+-----------+--------+
|                   1 | 70213303* |   1800 |
|                   1 | 78400557* |   1450 |
|                   1 | 45598211* |   1410 |
|                   1 | 7575629*  |   1200 |
|                   1 | 30394912* |   1148 |
|                   1 | 98649685* |   1050 |
|                   1 | 6653828*  |    850 |
|                   1 | 80496539* |    800 |
|                   1 | 38200298* |    800 |
|                   1 | 18064165* |    670 |
+---------------------+-----------+--------+

SELECT mail
FROM `t_import_mail`
WHERE 1
GROUP BY mail
HAVING count( 0 ) >1
LIMIT 0 , 30

select FQQ,FUserID,count(*) as ct from `Tbl_User_**` GROUP BY FQQ HAVING ct > 1;

<?php
echo(round(0.6025,3));
?>
[~]# php test.php
0.603

<?php
echo(round(0.6024,3));
?>
[~]# php test.php
0.602