-
Notifications
You must be signed in to change notification settings - Fork 0
/
images.php
executable file
·123 lines (103 loc) · 3.79 KB
/
images.php
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
<?php
$slash="/";
$ImageSize = "100px";
$table="Slot";
$sql = "select * from $table where key_id= '$refNo' ";
$rownumber=0;
$res = mysql_query($sql);
while ( $row = mysql_fetch_array($res))
{
$datetime = strtotime($row['slot_date']);
$mysqldate = date("l j F Y", $datetime);
$item[0] = "<hr/>";
$item[0] .= " <div class=\"RowEventext1\" ><div class='bgGrey'>";
$item[0] .= "<center>". $row['op'].":" . " ".$mysqldate."</div></center>";
$item[0] .= " </div >";
echo $item[0];
}
//----------------------------------------------------------------------------------------------------------------------------------------
$table="Conferences";
$sql = "select * from $table where key_id= '$refNo' ";
$res = mysql_query($sql);
while ( $row = mysql_fetch_array($res))
{
$item[0] = "";
$item[0] .= " <div class=\"RowOddtext1\" ><div class='bgRed'>";
$item[0] .= $row['Name']. ":"." ". $row['Abbreviation'];
$item[0] .= " </div></div >";
echo $item[0];
}
//---------------------------------------------------------------------------------------------------------------------------------------
$sql = "select * from opening_paper where id = '$refNo' ";
$PathImage="Pictures/";
$res = mysql_query($sql);
$dedicated="Dedicated to";
echo " <div class=\"RowEventext1\" ><div class='bgGrey'>";
echo "<center>". $dedicated."</center></div>";
echo " </div >";
while ( $row = mysql_fetch_array($res))
{
$item[0] = "";
$item[0].= "<table><tr><td>";
$item[0] .= "<img src='" . $PathImage . $row['image'] ."' width = '$ImageSize'>";
$item[0].= "</td><td>";
echo $item[0];
//--------------------------------------------------------------------------------------------------------------------------------------
$table="User";
$sql = "select * from $table where key_id= '$refNo' ";
//echo "\n $sql \n";
//$PathImage="../Pictures/";
$res = mysql_query($sql);
while ( $row = mysql_fetch_array($res))
{
$item[0] = "<div id=\"Honour\">";
$item[0] .= $row['first_name']." ".$row['last_name'];
$item[0] .= "<br/> ".$row['affiliation'];
$item[0] .= "<br/> ".$row['address'];
$item[0] .= "</div></td></tr></table> ";
echo $item[0];
}
}
//-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
$refNo = $_GET['refNo'];
$tablename="keynotes";
$rownumber=0;
$sql = "select * from $tablename where user_id = '$refNo' ";
$res = mysql_query($sql);
while ( $row = mysql_fetch_array($res))
{
$item[0] = "";
$item[0] .= " <div id=\"RowOddtext\" >";
$item[0] .= $row['user_bio'] ;
$item[0] .= " </div> ";
echo $item[0];
}
$item[0] .= " </div> ";
//-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
$table="User";
$sql = "select * from $table where key_id= '$refNo' ";
//echo "\n $sql \n";
//$PathImage="../Pictures/";
$res = mysql_query($sql);
while ( $row = mysql_fetch_array($res))
{
$item[0] = "";
$item[0] .= " <div class=\"RowEventext\" >";
// $item[0] .= $row['first_name']." ".$row['last_name']." ";
//$item[0] .= " </div> ";
echo $item[0];
//-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
$sql = "select * from opening_paper where id = '$refNo' ";
$represents="Opening Paper: ";
$PathImage="/var/www/Pictures/";
$res = mysql_query($sql);
while ( $row = mysql_fetch_array($res))
{
$item[0] = "";
$item[0] .= "<div class='bgRed'>". $represents." "."\"".$row['title']."\"";
$item[0] .= " </div> </div>";
echo $item[0];
}
}
//-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
?>