thinkphp 新增字段

ALTER TABLE products ADD COLUMN stock INT DEFAULT 0;

namespace app\common\model;

use think\Model;

class ProductModel extends Model
{
    protected $table = 'products';

    // 定义新的字段
    protected $append = ['stock'];
}

use app\common\model\ProductModel;

class ProductController extends Controller
{
    public function index()
    {
        $products = ProductModel::all();
        return view('product/index', compact('products'));
    }
}

<table>
    <thead>
        <tr>
            <th>ID</th>
            <th>Name</th>
            <th>Stock</th>
        </tr>
    </thead>
    <tbody>
        @foreach($products as $product)
        <tr>
            <td>{{ $product->id }}</td>
            <td>{{ $product->name }}</td>
            <td>{{ $product->stock }}</td>
        </tr>
        @endforeach
    </tbody>
</table>

namespace app\common\command;

use think\console\Command;
use think\console\Input;
use think\console\Output;
use think\facade\Db;

class Migrate extends Command
{
    protected function configure()
    {
        $this->setName('migrate')
             ->setDescription('Run database migrations');
    }

    protected function execute(Input $input, Output $output)
    {
        Db::execute("ALTER TABLE products ADD COLUMN stock INT DEFAULT 0");
        $output->writeln("Migration completed successfully.");
    }
}

php think migrate