old_php_organisationSocialNetwork/projectos.php at main · TOUSSAINT2346/old_php_organisationSocialNetwork · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
<?php
include('rest.php');
include('conectar.php');
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Mi mafia, Tu mafia</title>
<link rel="stylesheet" href="css/geral.css" type="text/css" />
</head>
<body leftmargin="0" topmargin="0" background="img/back2.png">
<table cellpadding="0" cellspacing="0" width="100%" border="0">
  <tr>
    <td width="10%">&nbsp;</td>
    <td align="center" valign="bottom"><p><img src="img/tit.png"></p></td>
    <td width="10%">&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td bgcolor="#c12a19" align="center" style="box-shadow: 0px 5px 15px #000;" height="50"><?php include ('menu.php');?></td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td bgcolor="#FFFFFF" style="box-shadow: 0px 5px 15px #000;" height="500" valign="top">
<!---- TABLE PROJECTS --------------->
<table width="100%" border="0">
      <tr>
      <td>&nbsp;</td>
      <td align="center" valign="top">
      <h1>Projetos</h1>
      </td>
      <td>&nbsp;</td>
      </tr>
      <tr>
      <td>&nbsp;</td>
      <td align="left">
      <h4><a href="addproject.php">&laquo; Criar um projeto &raquo;</a></h4>
      </td>
      <td>&nbsp;</td>
      </tr>
      <tr>
      <td>&nbsp;</td>
      <td>
      <table border="0" cellpadding="1" cellspacing="1" width="100%">
      <tr bgcolor="#CCCCCC">
      <td colspan="4"><h2>Últimos projetos</h2></td>
      </tr>
      <tr bgcolor="#CCCCCC">
      <td align="center" width="40%">Título</td>
      <td align="center" width="20%">Situação</td>
      <td align="center" width="20%">Criador</td>
      <td align="center" width="20%">Criação</td>
      </tr>
      <?php
        // Fetch projects
        $query_proj = "SELECT id_proj, nome_proj, sit_proj, dat_proj, creat_proj FROM projetos ORDER BY id_proj DESC";
        $stmt_proj = $conexao->prepare($query_proj);
        $stmt_proj->execute();
        $rs_proj = $stmt_proj->get_result();
        $nproj = $rs_proj->num_rows;

        if($nproj == 0){
        ?>
        <tr>
        <td colspan="4" align="center">
        <h3>Ainda não há nenhum projeto! :/</h3>
        </td>
        </tr>
        <?php
        }else{
		    while($projinfo = $rs_proj->fetch_assoc()){

                $id_proj    = $projinfo['id_proj'];
                $nome_proj  = $projinfo['nome_proj'];
                $sit_proj   = $projinfo['sit_proj'];
                $dat_proj   = $projinfo['dat_proj'];
                $creat_proj = $projinfo['creat_proj'];

                // Fetch creator information
                $query_popostu  = "SELECT nome_user, sobrenome_user FROM user WHERE id_user = ?";
                $stmt_popostu   = $conexao->prepare($query_popostu);
                $stmt_popostu->bind_param("i", $creat_proj);
                $stmt_popostu->execute();
                $rs_popostu     = $stmt_popostu->get_result();
                $popostu_info   = $rs_popostu->fetch_assoc();

                $nom_popost     = $popostu_info['nome_user'];
                $sobnom_popost  = $popostu_info['sobrenome_user'];
		?>
      <tr>
      <td><a href="readproject.php?i=<?=$id_proj;?>"><?=$nome_proj;?></a></td>
      <td><?php
	    if($sit_proj == 'vot'){
            echo 'Em processo de votação';
        }elseif($sit_proj == 'esp'){
            echo 'Esperando julgamento del Capo';
        }else{
            echo $sit_proj;
        }
	  ?></td>
      <td><a href="perfil.php?p=<?=$creat_proj?>"><font style="text-transform:capitalize;"><?=$nom_popost;?> <?=$sobnom_popost?></font></a></td>
      <td><?=$dat_proj?></td>
      </tr>
      <?php
		  }
}
	  ?>
      </table>
      </td>
      <td>&nbsp;</td>

      </tr>
      </table>
      </td>
      <td>&nbsp;</td>
      </tr>
    </table>
<!---- TABLE PROJECTS ENDS --------------->
    </td>
    <td>&nbsp;</td>
  </tr>

</table>

</body>
</html>