connect_error) { die('Connect Error (' . $mysqli->connect_errno . ') ' . $mysqli->connect_error); } $stmt = $conn->prepare("SELECT * FROM `tb_conf_ss` where `ss_id`=?"); // "s" means the database expects a string $stmt->bind_param("s", $id); $stmt->execute(); $result = $stmt->get_result(); $row = $result->fetch_all(); $stmt->close(); $conn->close(); ?>
2014 Madrid, Spain
List by
connect_error) { die('Connect Error (' . $mysqli->connect_errno . ') ' . $mysqli->connect_error); } $stmt1 = $conn1->prepare("SELECT * FROM `tb_conf_ss_time` where `ss_id`=?"); // "s" means the database expects a string $stmt1->bind_param("s", $id); $stmt1->execute(); $result1 = $stmt1->get_result(); //$rows1 = $result1->fetch_assoc(); $rows1 = $result1->fetch_array(); $stmt1->close(); $conn1->close(); ?> prepare("SELECT * FROM `tb_conf_abstract` , `tb_conf_usr`, `tb_conf_usr_fee` WHERE `tb_conf_abstract`.`abs_author_id` = `tb_conf_usr`.`uid` AND `tb_conf_usr`.`uid` = `tb_conf_usr_fee`.`uid` AND `tb_conf_abstract`.`abs_category` = 'SS' AND `tb_conf_abstract`.`abs_special_session` =? AND `tb_conf_abstract`.`abs_ss_status`= 'A' ORDER BY `tb_conf_usr`.`usr_last_name`"); break; case "Time": $sqls = $conn->prepare("SELECT * FROM `tb_conf_abstract` , `tb_conf_usr`, `tb_conf_usr_fee` WHERE `tb_conf_abstract`.`abs_author_id` = `tb_conf_usr`.`uid` AND `tb_conf_usr`.`uid` = `tb_conf_usr_fee`.`uid` AND `tb_conf_abstract`.`abs_category` = 'SS' AND `tb_conf_abstract`.`abs_special_session` =? AND `tb_conf_abstract`.`abs_ss_status`= 'A' ORDER BY `tb_conf_abstract`.`time_block`,`tb_conf_abstract`.`speaker_order`"); break; default: $sqls = $conn->prepare("SELECT * FROM `tb_conf_abstract` , `tb_conf_usr`, `tb_conf_usr_fee` WHERE `tb_conf_abstract`.`abs_author_id` = `tb_conf_usr`.`uid` AND `tb_conf_usr`.`uid` = `tb_conf_usr_fee`.`uid` AND `tb_conf_abstract`.`abs_category` = 'SS' AND `tb_conf_abstract`.`abs_special_session` =? AND `tb_conf_abstract`.`abs_ss_status`= 'A' ORDER BY `tb_conf_usr`.`usr_last_name`"); } $sqls->bind_param("s", $id); $sqls->execute(); $results = $sqls->get_result(); $rows = $result->fetch_assoc(); $sqls->close(); $conn->close(); ?>
Assigned Schedule
Time blocks assigned to the session:
Author Name Abstract Title Time Block Speaking Order Date Time Period
"> ">