<?php
header("Content-Type:text/html; charset=utf8");
class config{
public static function db() {
$con = mysql_connect("localhost", "root", "root");
mysql_query("set names utf8");
mysql_select_db("yunnan12316", $con);
}
}
class addData {
private $_send;
function alter($db,$post,$table) {
$this->_send = $db;
foreach ($_POST as $key => $value) {
$array[] = "add " . $key . " varchar(220),";
}
$string = rtrim(implode(" ", $array), ",");
$sql = "alter table ".$table." " . $string . "";
mysql_query($sql);
}
function add($db,$post,$table) {
$this->_send = $db;
foreach ($post as $key => $value) {
$k[] = $key;
$v[] = "'" . $value . "'";
}
$key_db = implode(',', $k);
$value_db = implode(',', $v);
$sql = "INSERT INTO ".$table." (".$key_db.") VALUES (".$value_db.")";
mysql_query($sql);
}
}
/*
table:qw_car,qw_goods
*/
$addData = new addData();
$post = @$_POST;
if(@$post['price']==null){
$addData->alter(config::db(),$post,'qw_car');
$addData->add(config::db(),$post,'qw_car');
}else{
$addData->alter(config::db(),$post,'qw_goods');
$addData->add(config::db(),$post,'qw_goods');
}