insert into 封装

php代码

//添加数据

function inserttable($tablename, $insertsqlarr, $returnid=0)
{
    $insertkeysql = $insertvaluesql = $comma = '';
    foreach ($insertsqlarr as $insert_key => $insert_value) {
        $insertkeysql .= $comma.'`'.$insert_key.'`';
        $insertvaluesql .= $comma.'\''.$insert_value.'\'';
        $comma = ', ';
    }

    mysql_query("insert into $tablename($insertkeysql)VALUES($insertvaluesql)");
    if($returnid) {
        return mysql_insert_id();
    }
}