Esempi in PHP per get_items_table_name

Esempio n. 1

File: db_functions.php Progetto: Trying-On-The-Trades/panomanager

function update_item($id, $name, $description, $image = null, $price, $type_id)
{
    global $wpdb;
    $item_table = get_items_table_name();
    $params = array('name' => $name, 'description' => $description, 'price' => $price, 'type_id' => $type_id);
    if (!is_null($image)) {
        $params['image'] = $image;
    }
    $wpdb->update($item_table, $params, array('id' => $id));
}

Esempio n. 2

File: database.php Progetto: Trying-On-The-Trades/panomanager

function build_items_sql()
{
    $items_table = get_items_table_name();
    $item_types_table = get_item_types_table_name();
    $sql = "CREATE TABLE {$items_table} (\n    `id` int(10) NOT NULL AUTO_INCREMENT,\n    `name` varchar(30),\n    `description` text,\n    `image` varchar(80),\n    `price`  decimal(10, 2),\n    `type_id` int(10) NOT NULL,\n    PRIMARY KEY (`id`),\n    FOREIGN KEY (`type_id`) REFERENCES {$item_types_table}(`id`)\n    );";
    return $sql;
}