EliteConf
 All Data Structures Namespaces Files Functions Variables Pages
Interests_request_functionController.php
Go to the documentation of this file.
1 <?php
2 
7 class Interests_request_functionController extends Controller
8 {
9  public function actionIndex()
10  {
11  $this->render('index');
12  }
13 
17  public function request()
18  {
19 
20  Connect_DatabaseController::connect();
21 
22  $topic = $_POST['topic'];
23  $subtopic = $_POST['subtopic'];
24 
25  $topic_accepted = mysql_query("SELECT * FROM interests_topics WHERE name='$topic'");
26  $topic_unaccepted = mysql_query("SELECT * FROM interests_topics_confirmation WHERE name='$topic'");
27 
28  if(mysql_num_rows($topic_accepted)==0)
29  {
30  //eger onaylanmıs topiclerde yoksa
31 
32  if(mysql_num_rows($topic_unaccepted)==0)
33  {
34  //onaylanmamıs topiclerde yoksa
35  $sql_insert_topic="INSERT INTO interests_topics_confirmation (name)
36 VALUES
37 ('$topic')";
38 mysql_query($sql_insert_topic) or die (mysql_error());
39 
40  $sql_insert_subtopic="INSERT INTO interests_subtopics_confirmation (name)
41 VALUES
42 ('$subtopic')";
43 mysql_query($sql_insert_subtopic) or die (mysql_error());
44 
45  $last_added_topic = mysql_query("SELECT id FROM interests_topics_confirmation WHERE name='$topic'");
46  $last_added_subtopic = mysql_query("SELECT id FROM interests_subtopics_confirmation WHERE name='$subtopic'");
47 
48  while($row3 = mysql_fetch_array($last_added_topic))
49  {
50  $topid = $row3['id'];
51  while($row4 = mysql_fetch_array($last_added_subtopic))
52  {
53  $subid = $row4['id'];
54  $sql_insert_topic_subtopic="INSERT INTO topic_subtopic_confirmation (topicid, subtopicid)
55 VALUES
56 ('$topid', '$subid')";
57 mysql_query($sql_insert_topic_subtopic) or die (mysql_error());
58 
59  }
60 
61  }
62 
63 
64  }
65  else
66  {
67  //onaylanmamıs topiclerde varsa
68 
69  while($row2 = mysql_fetch_array($topic_unaccepted))
70  {
71 
72  $sql_insert_subtopic="INSERT INTO interests_subtopics_confirmation (name)
73  VALUES
74  ('$subtopic')";
75  mysql_query($sql_insert_subtopic) or die (mysql_error());
76 
77  $toid = $row2['id'];
78 
79  $last_added_subtopic = mysql_query("SELECT id FROM interests_subtopics_confirmation WHERE name='$subtopic'");
80 
81  while($row4 = mysql_fetch_array($last_added_subtopic))
82  {
83  $subid = $row4['id'];
84  $sql_insert_topic_subtopic="INSERT INTO topic_subtopic_confirmation (topicid, subtopicid)
85  VALUES
86  ('$toid', '$subid')";
87  mysql_query($sql_insert_topic_subtopic) or die (mysql_error());
88 
89  }
90 
91  }
92 
93  }
94 
95  }
96  else
97  {
98  //onaylanmıs topiclerde varsa
99  while ($row = mysql_fetch_array($topic_accepted))
100  {
101 
102  $sql_insert_subtopic="INSERT INTO interests_subtopics_confirmation (name)
103  VALUES
104  ('$subtopic')";
105  mysql_query($sql_insert_subtopic) or die (mysql_error());
106 
107  $toid = $row['id'];
108 
109  $last_added_subtopic = mysql_query("SELECT id FROM interests_subtopics_confirmation WHERE name='$subtopic'");
110 
111  while($row4 = mysql_fetch_array($last_added_subtopic))
112  {
113  $subid = $row4['id'];
114  $sql_insert_topic_subtopic="INSERT INTO topic_subtopic_existing_confirmation (topicid, subtopicid)
115  VALUES
116  ('$toid', '$subid')";
117  mysql_query($sql_insert_topic_subtopic) or die (mysql_error());
118 
119  }
120  }
121  }
122  /*
123  if($topic_accepted==NULL) echo "1 null<br>";
124  echo $topic_accepted . $topic;
125  if($topic_unaccepted==NULL) echo "2 null";
126  */
127 
128  }
129 
130 
131  public function newinterest()
132  {
133 
134 
135  Connect_DatabaseController::connect();
136 
137  $topic = $_POST['topic'];
138  $subtopic = $_POST['subtopic'];
139 
140  $topic_accepted = mysql_query("SELECT * FROM interests_topics WHERE name='$topic'");
141 
142  if(mysql_num_rows($topic_accepted)==0)
143  {
144  //eger topiclerde yoksa
145 
146  $sql_insert_topic="INSERT INTO interests_topics (name)
147 VALUES
148 ('$topic')";
149 mysql_query($sql_insert_topic) or die (mysql_error());
150 
151  $sql_insert_subtopic="INSERT INTO interests_subtopics (name)
152 VALUES
153 ('$subtopic')";
154 mysql_query($sql_insert_subtopic) or die (mysql_error());
155 
156  $last_added_topic = mysql_query("SELECT id FROM interests_topics WHERE name='$topic'");
157  $last_added_subtopic = mysql_query("SELECT id FROM interests_subtopics WHERE name='$subtopic'");
158 
159  while($row3 = mysql_fetch_array($last_added_topic))
160  {
161  $topid = $row3['id'];
162  while($row4 = mysql_fetch_array($last_added_subtopic))
163  {
164  $subid = $row4['id'];
165  $sql_insert_topic_subtopic="INSERT INTO topic_subtopic (topicid, subtopicid)
166 VALUES
167 ('$topid', '$subid')";
168 mysql_query($sql_insert_topic_subtopic) or die (mysql_error());
169 
170  }
171 
172  }
173 
174  }
175  else
176  {
177  //onaylanmıs topiclerde varsa
178  while ($row = mysql_fetch_array($topic_accepted))
179  {
180 
181  $sql_insert_subtopic="INSERT INTO interests_subtopics (name)
182  VALUES
183  ('$subtopic')";
184  mysql_query($sql_insert_subtopic) or die (mysql_error());
185 
186  $toid = $row['id'];
187 
188  $last_added_subtopic = mysql_query("SELECT id FROM interests_subtopics WHERE name='$subtopic'");
189 
190  while($row4 = mysql_fetch_array($last_added_subtopic))
191  {
192  $subid = $row4['id'];
193  $sql_insert_topic_subtopic="INSERT INTO topic_subtopic (topicid, subtopicid)
194  VALUES
195  ('$toid', '$subid')";
196  mysql_query($sql_insert_topic_subtopic) or die (mysql_error());
197 
198  }
199  }
200  }
201 
202  }
203 
204 
205  public function newinterest2()
206  {
207 
208 
209  Connect_DatabaseController::connect();
210 
211  $topic = $_POST['topic'];
212  $subtopic = $_POST['subtopic2'];
213 
214  $topic_accepted = mysql_query("SELECT * FROM interests_topics WHERE name='$topic'");
215 
216  if(mysql_num_rows($topic_accepted)==0)
217  {
218  //eger topiclerde yoksa
219 
220  $sql_insert_topic="INSERT INTO interests_topics (name)
221 VALUES
222 ('$topic')";
223 mysql_query($sql_insert_topic) or die (mysql_error());
224 
225  $sql_insert_subtopic="INSERT INTO interests_subtopics (name)
226 VALUES
227 ('$subtopic')";
228 mysql_query($sql_insert_subtopic) or die (mysql_error());
229 
230  $last_added_topic = mysql_query("SELECT id FROM interests_topics WHERE name='$topic'");
231  $last_added_subtopic = mysql_query("SELECT id FROM interests_subtopics WHERE name='$subtopic'");
232 
233  while($row3 = mysql_fetch_array($last_added_topic))
234  {
235  $topid = $row3['id'];
236  while($row4 = mysql_fetch_array($last_added_subtopic))
237  {
238  $subid = $row4['id'];
239  $sql_insert_topic_subtopic="INSERT INTO topic_subtopic (topicid, subtopicid)
240 VALUES
241 ('$topid', '$subid')";
242 mysql_query($sql_insert_topic_subtopic) or die (mysql_error());
243 
244  }
245 
246  }
247 
248  }
249  else
250  {
251  //onaylanmıs topiclerde varsa
252  while ($row = mysql_fetch_array($topic_accepted))
253  {
254 
255  $sql_insert_subtopic="INSERT INTO interests_subtopics (name)
256  VALUES
257  ('$subtopic')";
258  mysql_query($sql_insert_subtopic) or die (mysql_error());
259 
260  $toid = $row['id'];
261 
262  $last_added_subtopic = mysql_query("SELECT id FROM interests_subtopics WHERE name='$subtopic'");
263 
264  while($row4 = mysql_fetch_array($last_added_subtopic))
265  {
266  $subid = $row4['id'];
267  $sql_insert_topic_subtopic="INSERT INTO topic_subtopic (topicid, subtopicid)
268  VALUES
269  ('$toid', '$subid')";
270  mysql_query($sql_insert_topic_subtopic) or die (mysql_error());
271 
272  }
273  }
274  }
275 
276  }
277 
278  // Uncomment the following methods and override them if needed
279  /*
280  public function filters()
281  {
282  // return the filter configuration for this controller, e.g.:
283  return array(
284  'inlineFilterName',
285  array(
286  'class'=>'path.to.FilterClass',
287  'propertyName'=>'propertyValue',
288  ),
289  );
290  }
291 
292  public function actions()
293  {
294  // return external action classes, e.g.:
295  return array(
296  'action1'=>'path.to.ActionClass',
297  'action2'=>array(
298  'class'=>'path.to.AnotherActionClass',
299  'propertyName'=>'propertyValue',
300  ),
301  );
302  }
303  */
304 }
Generated on Sun Jun 2 2013 05:35:37 for EliteConf by   doxygen 1.8.4