当我寻找一种在用户在特定日期之间免费搜索酒店时临时保存搜索结果的方式时,我发现了临时表。
但是某些问题甚至在mysql手册中都没有得到解答.... 比如...
临时表对于每个执行脚本的用户是否唯一?还是当两个不同的用户同时运行脚本时会被覆盖...?
表什么时候被销毁..?当用户关闭浏览器窗口或只是从运行脚本的页面中导航开去..?
感谢您的澄清...
这就是我是如何做的....
$table = "CREATE OR REPLACE TEMPORARY TABLE $free_room(
room_id INT(5),
room_name VARCHAR(150),
max_persons INT(1),
rooms_free INT(1),
room_price INT(6),
hotel_id INT(4),
hotel_name VARCHAR(100),
hotel_stars INT(1),
hotel_type INT(1)) ENGINE=MEMORY";
$query_getFreeRooms = "INSERT INTO $free_room
SELECT $rooms.room_id,
$rooms.room_name,
$rooms.max_persons,
$rooms.total_rooms - $rooms.booked_rooms AS rooms_free,
$rooms.room_price,
$hotels.hotel_id,
$hotels.hotel_name,
$hotels.hotel_stars,
$hotels.hotel_type
FROM $hotels,$rooms
WHERE $rooms.room_id NOT IN (SELECT room_id
FROM $reservations
WHERE $dateCheck)
AND $hotels.hotel_city = '$city_search1'
AND $hotels.hotel_id = $rooms.hotel_id
AND $hotels.hotel_deleted = '0'
AND $rooms.room_deleted = '0'";