Question

谁来帮我解释一下下面这段代码，是SAE里面php调用MYsql的，谢谢！

<?php
$mysql = new SaeMysql();

$sql = "SELECT * FROM `user` LIMIT 10";
$data = $mysql->getData( $sql );
$name = strip_tags( $_REQUEST['name'] );
$age = intval( $_REQUEST['age'] );
$sql = "INSERT INTO `user` ( `name` , `age` , `regtime` ) VALUES ( '" . $mysql->escape( $name ) . "' , '" . intval( $age ) . "' , NOW() ) ";
$mysql->runSql( $sql );
if( $mysql->errno() != 0 )
{
die( "Error:" . $mysql->errmsg() );
}

$mysql->closeDb();
?>

Answer 1

<?php
//初始话mysql连接
$mysql = new SaeMysql();

$sql = "SELECT * FROM `user` LIMIT 10";
//执行sql
$data = $mysql->getData( $sql );
//获取name参数，并过滤掉html xml php标记
$name = strip_tags( $_REQUEST['name'] );
//age参数格式化为整型
$age = intval( $_REQUEST['age'] );
//构造插入语句
$sql = "INSERT INTO `user` ( `name` , `age` , `regtime` ) VALUES ( '" . $mysql->escape( $name ) . "' , '" . intval( $age ) . "' , NOW() ) ";
//执行插入语句
$mysql->runSql( $sql );
//判断执行是否成功
if( $mysql->errno() != 0 )
{
die( "Error:" . $mysql->errmsg() );
}
//关闭数据库连接
$mysql->closeDb();
?>

Answer 2

数据库操作，添加一条新的记录，字段是name，age和regtime

Answer 3

就是一个取出数据在插入的过程而已