Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $connect = MySql::conectar();
- $query = "SELECT * FROM `tb_site.test` LEFT JOIN `tb_site.user` ON `tb_site.test`.`user_id` = `tb_site.user`.`id` WHERE `tb_site.test`.`rifas_id` = ".$_GET['id']. " ORDER BY `tb_site.test`.`number` ASC";
- $result = $connect->query($query);
- $result = $result->fetchAll();
- $count_query_result = sizeof($result);
- $show_result = get_number_by_userid($result);
- function get_number_by_userid($numbers){
- $count = sizeof($numbers);
- $name_number_list = array();
- for($i = 0 ; $i < $count ; $i++){
- $name_tmp = $numbers[$i]["name"];
- $number_tmp = $numbers[$i]["number"];
- if(array_key_exists($name_tmp, $name_number_list)){
- $name_number_list[$name_tmp] = $name_number_list[$name_tmp].' , '.$number_tmp;
- }else{
- $name_number_list[$name_tmp] = $number_tmp;
- }
- }
- return $name_number_list;
- }
- ?>
- <div class="box-content">
- <div class="wraper-table">
- <table>
- <tr class="bg-blue">
- <td>Nome</td>
- <td>Números</td>
- <td>Status</td>
- <td></td>
- </tr>
- <?php
- foreach($show_result as $key => $value){
- ?>
- <form action="<?php echo INCLUDE_PATH_PAINEL; ?>edit_type?id=<?php echo $_GET['id'] ?>" method="POST">
- <tr>
- <td><?php echo $key; ?><input type="hidden" name="user_name" value="<?php echo $key ?>"></td>
- <td><?php echo $value; ?></td>
- <td>
- <select name = "selected_type" id = '<?php echo $key ?>' onchange="show_select(this, this.id)">
- <option>Aletar Status</option>
- <option value="0">Livre</option>
- <option value="1">Reservado</option>
- <option value="2">Pago</option>
- </select>
- </td>
- <td><button type="submit">Salvar</button></td>
- </tr>
- </form>
- <?php } ?>
- </table>
- </div>
- </div>
- <?php
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement