PHP get_line_items_table_name示例

示例#1

文件： db_functions.php 项目： Trying-On-The-Trades/panomanager

function create_line_item($purchase_id, $item_id, $price)
{
    global $wpdb;
    $line_item_table = get_line_items_table_name();
    $wpdb->insert($line_item_table, array('purchase_id' => $purchase_id, 'item_id' => $item_id, 'price' => $price));
}

示例#2

文件： database.php 项目： Trying-On-The-Trades/panomanager

function build_line_items_sql()
{
    $line_items_table = get_line_items_table_name();
    $items_table = get_items_table_name();
    $purchases_table = get_purchases_table_name();
    $sql = "CREATE TABLE {$line_items_table} (\n    `purchase_id` int(10) NOT NULL,\n    `item_id` int(10) NOT NULL,\n    `price` decimal(10, 2),\n    PRIMARY KEY (`purchase_id`, `item_id`),\n    FOREIGN KEY (`purchase_id`) REFERENCES {$purchases_table}(`id`),\n    FOREIGN KEY (`item_id`) REFERENCES {$items_table}(`id`)\n    );";
    return $sql;
}