建字段_添加数据_生成json.php

最新推荐文章于 2023-04-02 08:16:09 发布

转载最新推荐文章于 2023-04-02 08:16:09 发布 · 120 阅读

文章标签：

本文介绍了一个使用PHP编写的简单数据库操作类，该类支持连接数据库、查询数据、修改表结构及插入数据等功能。通过实例化该类并调用相应的方法，可以轻松实现对数据库的基本操作。

<?php
header("Content-Type:text/html;charset=utf8");

class db{
    
    static  $localhost = "localhost";
    static  $user = "root";
    static  $psw ="root";
    static  $db = "yunnan12316";
    
    public function conn() {
        $con = mysql_connect(self::$localhost, self::$user, self::$psw);
        mysql_query("set names utf8");
        mysql_select_db(self::$db, $con);
    }
    
    public function select($table) {
        $conn = $this->conn();
        $sql = "select * from ".$table; 
        $result = mysql_query($sql);
        while($row = mysql_fetch_array($result))
          {
            $data[] = $row;
          }
        $content['content'] = @$data;
        $json = json_encode($content);
        echo $json;
    }
    
    public function alter($table) {
        foreach ($_POST as $key => $value) {
            $array[] = "add " . $key . " varchar(220),";
        }
        $string = rtrim(implode(" ", $array), ",");
        $sql = "alter table ".$table." " . $string . "";
        mysql_query($sql);
    }
    
    public function add($table) {
        $conn = $this->conn();
        $conn = $this->alter($table);
        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 = "test";
$db = new db();

if($_SERVER['REQUEST_METHOD']=='POST'){
    $db->add($table);
}else{
    $db->select($table);
}