PHP+MySql

1、安装MySQL，用户：root；口令：why521

2、进入MySQL，创建数据库：create database test;

3、创建表：

CREATE TABLE logs_result 

(

today_time DATE,

customers_id INTEGER, version_id VARCHAR(30),

last_update_time DATETIME, success INTEGER,

fail INTEGER,remarks VARCHAR(200), PRIMARY KEY(today_time,customers_id,version_id)

);

 

4、表中插入数据：

insert into logs_result values('2011-5-23',123,123,'2011-5-20',1,0,'hi');

insert into logs_result values('2011-5-24',234,234,'2011-5-24',5,2,'kevin test 2');

commit;

 

5、将下载的amfphp 1.9.zip解压缩，并将文件放入Apache2的工作目录（默认安装在/var/www/目录下），重命名为amfphp1.9

6、在浏览器输入http://127.0.0.1/amfphp1.9/gateway.php，正常情况下会显示以下内容：

7、在amfphp1.9/services目录下新建目录org/zgflex/，并在其下建立文件LogResult.php，内容：

<?php

class LogResult {

 

  public $cust_id;

  public $today_time;

  public $version_id;

  public $success_num;

  public $fail_num;

  public $remark;

 

  var $_explicitType = "org.zgflex.LogResult"; //_explicitType用来指定在客户端也有一个LogResult类和其对应，当连接时，通过对应的对象传递数据

}

?>

 

8、在amfphp1.9/services目录下新建GetData.php

<?php

require_once './org/zgflex/LogResult.php'; //为对象信息，存放在amfphp1.9/services/org/zgflex/目录下

 

define( "DATABASE_SERVER", "localhost"); //数据库地址

define( "DATABASE_USERNAME", "root"); //数据库用户

define( "DATABASE_PASSWORD", "why521");//数据库口令

define( "DATABASE_NAME", "test");//数据库名称

 

class GetData{

 

    private $_db;

 

/**

* Class contains methods for getting data about teams and players

* it contains database connection

*/

 

    public function __construct() //构造函数，连接数据库

    {

        try {

            $this->_db = mysql_connect(DATABASE_SERVER, DATABASE_USERNAME, DATABASE_PASSWORD);

            mysql_select_db(DATABASE_NAME, $this->_db);

        }

        catch (Exception $exc)

        {

            return 'ERROR #1: Could not connect to the database';

        }

    }

 

/**

* function gets data about the teams, sorted by title

* @returns array with Team objects

*/

 

  public function getResults()

  {

          $sql = 'SELECT customers_id,today_time,version_id,success,fail,remarks from logs_result'; //执行sql语句

 

          $result = mysql_query($sql, $this->_db);

 

          $teams = array();

 

          while ($row = mysql_fetch_object($result)) { //将返回的数据存放到对象数组中

                  $team = new LogResult();

                  $team->cust_id = $row->customers_id;

                  $team->today_time= $row->today_time;

                  $team->version_id = $row->version_id;

                  $team->success_num = $row->success;

                  $team->fail_num = $row->fail;

                  $team->remark = $row->remarks;

 

                  $teams[] = $team;

          }

 

          mysql_free_result($result);

          return $teams;

  }

 

}

/*

$test = new SoccerManager();

var_dump($test->getTeams());

*/

?>

 

9、在浏览器中输入：http://127.0.0.1/amfphp1.9/browser/ 浏览器中左侧栏应显示以下信息：

 

10，点击GetData，右侧出现下图：

 

11、点击call按钮，将显示如下信息：

 

11、修改文件amfphp1.9/gateway.php中的

$gateway->setCharsetHandler("utf8_decode", "ISO-8859-1", "ISO-8859-1");修改为：

$gateway->setCharsetHandler("utf8_decode", "UTF-8", "UTF-8");