PageRenderTime 52ms CodeModel.GetById 16ms RepoModel.GetById 0ms app.codeStats 0ms

/includes/functions.php

https://bitbucket.org/proactivedevelopers/doe
PHP | 603 lines | 546 code | 51 blank | 6 comment | 35 complexity | f19abf495b723a6c08252b0fc8b14fa2 MD5 | raw file
  1. <?php
  2. include_once("connect.php");
  3. function getmarks($year, $school, $sn)
  4. {
  5. $squel = mysql_query("Select * from main where school='$school' and year='$year' and sn='$sn'");
  6. $sqdata = mysql_fetch_assoc($squel);
  7. $no = getsub($year);
  8. for ($i = 1; $i <= $no; $i++) {
  9. $mark = "sub" . $i;
  10. $mark1 = "sub" . $i . "1";
  11. $dd = $sqdata[$mark] + $sqdata[$mark1];
  12. $ret[$i] = $dd;
  13. }
  14. return $ret;
  15. }
  16. function getGPA($n)
  17. {
  18. if ($n >= 0 && $n < 20) {
  19. $return[0] = 0;
  20. $return[1] = 'E';
  21. } elseif ($n >= 20 && $n < 30) {
  22. $return[0] = 0.8;
  23. $return[1] = 'D';
  24. } elseif ($n >= 30 & $n < 40) {
  25. $return[0] = 1.6;
  26. $return[1] = 'D+';
  27. } elseif ($n >= 40 & $n < 50) {
  28. $return[0] = 2.0;
  29. $return[1] = 'C';
  30. } elseif ($n >= 50 & $n < 60) {
  31. $return[0] = 2.4;
  32. $return[1] = 'C+';
  33. } elseif ($n >= 60 & $n < 70) {
  34. $return[0] = 2.8;
  35. $return[1] = 'B';
  36. } elseif ($n >= 70 & $n < 80) {
  37. $return[0] = 3.2;
  38. $return[1] = 'B+';
  39. } elseif ($n >= 80 & $n < 90) {
  40. $return[0] = 3.6;
  41. $return[1] = 'A';
  42. } else {
  43. $return[0] = 4.0;
  44. $return[1] = 'A+';
  45. }
  46. return $return;
  47. }
  48. function tellresult($the, $prac, $no, $year, $type)
  49. {
  50. $gr = isgrace($the, $prac, $no, $year, $type);
  51. if ($gr == 'p') {
  52. $res[0] = "Passed";
  53. $res[1] = 0;
  54. } elseif ($gr == 'f') {
  55. $res[0] = "Failed";
  56. $res[1] = 0;
  57. } else {
  58. $res[0] = "Passed";
  59. $res[1] = $gr;
  60. }
  61. return $res;
  62. }
  63. function isgrace($b, $pb, $no, $year, $type)
  64. {
  65. $passpercentage = mysql_result(mysql_query("select * from curriculum"), 0, 1);
  66. $need = 0;
  67. $fqu = "Select sub1,sub11";
  68. for ($i = 1; $i <= $no - 1; $i++) {
  69. $aaa = $i + 1;
  70. $fqu .= ",sub" . $aaa . ",sub" . $aaa . "1";
  71. }
  72. $fqu .= " from fmpm where year=$year;";
  73. $query = mysql_query($fqu) or die(mysql_error());
  74. $fqu = mysql_fetch_row($query) or die(mysql_error());
  75. $grac = mysql_query("select marks from grace where year=$year and type='$type'");
  76. $gracc = mysql_fetch_row($grac);
  77. $r = "P";
  78. for ($i = 0, $x = 0; $i <= ($no - 1); $i++) {
  79. $pass = ceil(($fqu[$x++] * $passpercentage) / 100);
  80. $tpass = floor(($fqu[$x++] * $passpercentage) / 100);
  81. if ($b[$i] < $pass) {
  82. if ($b[$i] == 0)
  83. $need = 100;
  84. $need = $need + $pass - $b[$i];
  85. $r = "F";
  86. }
  87. if ($pb[$i] < $tpass) {
  88. $need = $need + $tpass - $pb[$i];
  89. $r = "F";
  90. }
  91. }
  92. if ($r == "P")
  93. return "p";
  94. elseif ($r == "F") {
  95. if ($need <= $gracc[0])
  96. return $need;
  97. else
  98. return "f";
  99. }
  100. }
  101. function getsub($year)
  102. {
  103. $sque = mysql_query("Select no From subject where year=$year");
  104. $abc = mysql_fetch_row($sque);
  105. return $abc[0];
  106. }
  107. function isprac($sub, $year)
  108. {
  109. $s = "sub" . $sub . "1";
  110. $query = mysql_query("select $s from fmpm where year=$year") or die(mysql_error());
  111. return mysql_result($query, 0, 0);
  112. }
  113. function subject($a, $year)
  114. {
  115. $fi = "sub" . $a;
  116. $give = mysql_query("select $fi from subject where year=$year");
  117. return mysql_result($give, 0, 0);
  118. }
  119. function putmarks($a, $result, $marks)
  120. {
  121. $passpercentage = mysql_result(mysql_query("select * from curriculum"), 0, 1);
  122. if ($result == "Failed")
  123. if (isgrace($marks))
  124. return $passpercentage;
  125. else
  126. return $a;
  127. else
  128. return $a;
  129. }
  130. function writespace($a)
  131. {
  132. for ($i = 1; $i <= $a; $i++)
  133. echo "&nbsp;";
  134. return;
  135. }
  136. function chkpass($pas, $user, $table)
  137. {
  138. $pass = sha1($pas);
  139. $sqll = mysql_query("Select auth_id from `$table` where password='$pass' and username='$user'");
  140. if (mysql_num_rows($sqll) >= 1)
  141. return true;
  142. else
  143. return false;
  144. }
  145. function changpass($old, $new)
  146. {
  147. $old = sha1($old);
  148. $new = sha1($new);
  149. if (mysql_query("Update auth set password='$new' where password='$old'"))
  150. return true;
  151. else
  152. return false;
  153. }
  154. function result_overallback($school, $year)
  155. {
  156. $a = mysql_query("Select count(sn) from main where school='$school' and year=$year");
  157. $b = mysql_query("Select count(sn) from main where school='$school' and per>=80 and result='Passed' and year=$year");
  158. $c = mysql_query("Select count(sn) from main where school='$school' and per>=60 and per<80 and result='Passed' and year=$year");
  159. $d = mysql_query("Select count(sn) from main where school='$school' and per>=45 and per<60 and result='Passed' and year=$year");
  160. $e = mysql_query("Select count(sn) from main where school='$school' and per>=32 and per<45 and result='Passed' and year=$year");
  161. $f = mysql_query("Select count(sn) from main where school='$school' and result='Failed' and year=$year");
  162. $rv[5] = mysql_result($a, 0, 0);
  163. $rv[0] = mysql_result($b, 0, 0);
  164. $rv[1] = mysql_result($c, 0, 0);
  165. $rv[2] = mysql_result($d, 0, 0);
  166. $rv[3] = mysql_result($e, 0, 0);
  167. $rv[4] = mysql_result($f, 0, 0);
  168. return $rv;
  169. }
  170. function result_overalld($year)
  171. {
  172. $total = mysql_query("Select count(sn) from maingrade where year=$year");
  173. $fail = mysql_query("Select count(sn) from maingrade where weight<40 and year=$year");
  174. $ap = mysql_query("Select count(sn) from maingrade where gpa = 'A+' and year=$year");
  175. $a = mysql_query("Select count(sn) from maingrade where gpa = 'A' and year=$year");
  176. $bp = mysql_query("Select count(sn) from maingrade where gpa = 'B+' and year=$year");
  177. $b = mysql_query("Select count(sn) from maingrade where gpa = 'B' and year=$year");
  178. $cp = mysql_query("Select count(sn) from maingrade where gpa = 'C+' and year=$year");
  179. $c = mysql_query("Select count(sn) from maingrade where gpa = 'C' and year=$year");
  180. $dp = mysql_query("Select count(sn) from maingrade where gpa = 'D+' and year=$year");
  181. $d = mysql_query("Select count(sn) from maingrade where gpa = 'D' and year=$year");
  182. $e = mysql_query("Select count(sn) from maingrade where gpa = 'E' and year=$year");
  183. $return['ap'] = mysql_result($ap, 0, 0);
  184. $return['a'] = mysql_result($a, 0, 0);
  185. $return['bp'] = mysql_result($bp, 0, 0);
  186. $return['b'] = mysql_result($b, 0, 0);
  187. $return['cp'] = mysql_result($cp, 0, 0);
  188. $return['c'] = mysql_result($c, 0, 0);
  189. $return['dp'] = mysql_result($dp, 0, 0);
  190. $return['d'] = mysql_result($d, 0, 0);
  191. $return['e'] = mysql_result($e, 0, 0);
  192. $return['fail'] = mysql_result($fail, 0, 0);
  193. $return['total'] = mysql_result($total, 0, 0);
  194. return $return;
  195. }
  196. function result_overall($school,$year)
  197. {
  198. $total = mysql_query("Select count(sn) from maingrade where year=$year and school='".$school."'");
  199. $fail = mysql_query("Select count(sn) from maingrade where weight<40 and year=$year and school='".$school."'");
  200. $ap = mysql_query("Select count(sn) from maingrade where gpa = 'A+' and year=$year and school='".$school."'");
  201. $a = mysql_query("Select count(sn) from maingrade where gpa = 'A' and year=$year and school='".$school."'");
  202. $bp = mysql_query("Select count(sn) from maingrade where gpa = 'B+' and year=$year and school='".$school."'");
  203. $b = mysql_query("Select count(sn) from maingrade where gpa = 'B' and year=$year and school='".$school."'");
  204. $cp = mysql_query("Select count(sn) from maingrade where gpa = 'C+' and year=$year and school='".$school."'");
  205. $c = mysql_query("Select count(sn) from maingrade where gpa = 'C' and year=$year and school='".$school."'");
  206. $dp = mysql_query("Select count(sn) from maingrade where gpa = 'D+' and year=$year and school='".$school."'");
  207. $d = mysql_query("Select count(sn) from maingrade where gpa = 'D' and year=$year and school='".$school."'");
  208. $e = mysql_query("Select count(sn) from maingrade where gpa = 'E' and year=$year and school='".$school."'");
  209. $return['ap'] = mysql_result($ap, 0, 0);
  210. $return['a'] = mysql_result($a, 0, 0);
  211. $return['bp'] = mysql_result($bp, 0, 0);
  212. $return['b'] = mysql_result($b, 0, 0);
  213. $return['cp'] = mysql_result($cp, 0, 0);
  214. $return['c'] = mysql_result($c, 0, 0);
  215. $return['dp'] = mysql_result($dp, 0, 0);
  216. $return['d'] = mysql_result($d, 0, 0);
  217. $return['e'] = mysql_result($e, 0, 0);
  218. $return['fail'] = mysql_result($fail, 0, 0);
  219. $return['total'] = mysql_result($total, 0, 0);
  220. return $return;
  221. }
  222. function high($subject, $year, $school)
  223. {
  224. $ssu = "sub" . $subject;
  225. $ssu1 = "sub" . $subject . "1";
  226. $ss = mysql_query("select max($ssu+$ssu1) from main where year=$year and school='$school'");
  227. $x = mysql_result($ss, 0, 0);
  228. return $x;
  229. }
  230. function highd($subject, $year)
  231. {
  232. $ssu = "sub" . $subject;
  233. $ssu1 = "sub" . $subject . "1";
  234. $ss = mysql_query("select max($ssu+$ssu1) from main where year=$year");
  235. $x = mysql_result($ss, 0, 0);
  236. return $x;
  237. }
  238. function district($subject, $year)
  239. {
  240. $ssu = "sub" . $subject;
  241. $ssu1 = "sub" . $subject . "1";
  242. $ss = mysql_query("select max($ssu+$ssu1) from main where year=$year");
  243. $x = mysql_result($ss, 0, 0);
  244. return $x;
  245. }
  246. function low($subject, $year, $school)
  247. {
  248. $ssu = "sub" . $subject;
  249. $ssu1 = "sub" . $subject . "1";
  250. $ss = mysql_query("select min($ssu+$ssu1) from main where year=$year and school='$school' and $ssu>0");
  251. $x = mysql_result($ss, 0, 0);
  252. return $x;
  253. }
  254. function lowd($subject, $year)
  255. {
  256. $ssu = "sub" . $subject;
  257. $ssu1 = "sub" . $subject . "1";
  258. $ss = mysql_query("select min($ssu+$ssu1) from main where year=$year and $ssu>0");
  259. $x = mysql_result($ss, 0, 0);
  260. return $x;
  261. }
  262. function avrg($subject, $year, $school)
  263. {
  264. $ssu = "sub" . $subject;
  265. $ssu1 = "sub" . $subject . "1";
  266. $ss = mysql_query("select round(avg($ssu+$ssu1),2) from main where year=$year and school='$school'");
  267. $x = mysql_result($ss, 0, 0);
  268. return $x;
  269. }
  270. function avrgd($subject, $year)
  271. {
  272. $ssu = "sub" . $subject;
  273. $ssu1 = "sub" . $subject . "1";
  274. $ss = mysql_query("select round(avg($ssu+$ssu1),2) from main where year=$year");
  275. $x = mysql_result($ss, 0, 0);
  276. return $x;
  277. }
  278. function jod($subject, $year, $school)
  279. {
  280. $ssu = "sub" . $subject;
  281. $ssu1 = "sub" . $subject . "1";
  282. $ss = mysql_query("select sum($ssu+$ssu1) from main where year=$year and school='$school'");
  283. $x = mysql_result($ss, 0, 0);
  284. return $x;
  285. }
  286. function jodd($subject, $year)
  287. {
  288. $ssu = "sub" . $subject;
  289. $ssu1 = "sub" . $subject . "1";
  290. $ss = mysql_query("select sum($ssu+$ssu1) from main where year=$year");
  291. $x = mysql_result($ss, 0, 0);
  292. return $x;
  293. }
  294. function topper($year, $school)
  295. {
  296. $ss = mysql_query("select sn,name,per from main where year=$year and school='$school' group by per DESC");
  297. $x[0] = mysql_result($ss, 0, 0);
  298. $x[1] = mysql_result($ss, 0, 1);
  299. $x[2] = mysql_result($ss, 0, 2);
  300. return $x;
  301. }
  302. function dtopper($year)
  303. {
  304. $ss = mysql_query("select sn,name,per,school from main where year=$year order by per DESC");
  305. $x[0][0] = mysql_result($ss, 0, 0);
  306. $x[0][1] = mysql_result($ss, 0, 1);
  307. $x[0][2] = mysql_result($ss, 0, 2);
  308. $x[0][3] = mysql_result($ss, 0, 3);
  309. $x[1][0] = mysql_result($ss, 1, 0);
  310. $x[1][1] = mysql_result($ss, 1, 1);
  311. $x[1][2] = mysql_result($ss, 1, 2);
  312. $x[1][3] = mysql_result($ss, 1, 3);
  313. $x[2][0] = mysql_result($ss, 2, 0);
  314. $x[2][1] = mysql_result($ss, 2, 1);
  315. $x[2][2] = mysql_result($ss, 2, 2);
  316. $x[2][3] = mysql_result($ss, 2, 3);
  317. $x[3][0] = mysql_result($ss, 3, 0);
  318. $x[3][1] = mysql_result($ss, 3, 1);
  319. $x[3][2] = mysql_result($ss, 3, 2);
  320. $x[3][3] = mysql_result($ss, 3, 3);
  321. $x[4][0] = mysql_result($ss, 4, 0);
  322. $x[4][1] = mysql_result($ss, 4, 1);
  323. $x[4][2] = mysql_result($ss, 4, 2);
  324. $x[4][3] = mysql_result($ss, 4, 3);
  325. return $x;
  326. }
  327. function dtopperi($year)
  328. {
  329. $ss = mysql_query("select main.sn,main.name,main.per,main.school from main inner join schools on main.school=schools.schoolcode and schools.type=0 and main.year=$year order by per DESC");
  330. $x[0][0] = mysql_result($ss, 0, 0);
  331. $x[0][1] = mysql_result($ss, 0, 1);
  332. $x[0][2] = mysql_result($ss, 0, 2);
  333. $x[0][3] = mysql_result($ss, 0, 3);
  334. $x[1][0] = mysql_result($ss, 1, 0);
  335. $x[1][1] = mysql_result($ss, 1, 1);
  336. $x[1][2] = mysql_result($ss, 1, 2);
  337. $x[1][3] = mysql_result($ss, 1, 3);
  338. $x[2][0] = mysql_result($ss, 2, 0);
  339. $x[2][1] = mysql_result($ss, 2, 1);
  340. $x[2][2] = mysql_result($ss, 2, 2);
  341. $x[2][3] = mysql_result($ss, 2, 3);
  342. $x[3][0] = mysql_result($ss, 3, 0);
  343. $x[3][1] = mysql_result($ss, 3, 1);
  344. $x[3][2] = mysql_result($ss, 3, 2);
  345. $x[3][3] = mysql_result($ss, 3, 3);
  346. $x[4][0] = mysql_result($ss, 4, 0);
  347. $x[4][1] = mysql_result($ss, 4, 1);
  348. $x[4][2] = mysql_result($ss, 4, 2);
  349. $x[4][3] = mysql_result($ss, 4, 3);
  350. return $x;
  351. }
  352. function dtopperiboy($year)
  353. {
  354. $ss = mysql_query("select main.sn,main.name,main.per,main.school from main inner join schools on main.school=schools.schoolcode and schools.type=0 and main.year=$year and main.gender like 'm%' order by per DESC LIMIT 0,1");
  355. $x[0][0] = mysql_result($ss, 0, 0);
  356. $x[0][1] = mysql_result($ss, 0, 1);
  357. $x[0][2] = mysql_result($ss, 0, 2);
  358. $x[0][3] = mysql_result($ss, 0, 3);
  359. return $x;
  360. }
  361. function dtopperigirl($year)
  362. {
  363. $ss = mysql_query("select main.sn,main.name,main.per,main.school from main inner join schools on main.school=schools.schoolcode and schools.type=0 and main.year=$year and main.gender like 'f%' order by per DESC LIMIT 0,1");
  364. $x[0][0] = mysql_result($ss, 0, 0);
  365. $x[0][1] = mysql_result($ss, 0, 1);
  366. $x[0][2] = mysql_result($ss, 0, 2);
  367. $x[0][3] = mysql_result($ss, 0, 3);
  368. return $x;
  369. }
  370. function grades(){
  371. $return[] = "A+";
  372. $return[] = "A";
  373. $return[] = "B+";
  374. $return[] = "B";
  375. $return[] = "C+";
  376. $return[] = "C";
  377. $return[] = "D+";
  378. $return[] = "D";
  379. $return[] = "E+";
  380. $return[] = "E";
  381. return $return;
  382. }
  383. function dtopperjboy($year)
  384. {
  385. $ss = mysql_query("select main.sn,main.name,main.per,main.school from main inner join schools on main.school=schools.schoolcode and schools.type=1 and main.year=$year and gender like 'm%' order by per DESC LIMIT 0,1");
  386. $x[0][0] = mysql_result($ss, 0, 0);
  387. $x[0][1] = mysql_result($ss, 0, 1);
  388. $x[0][2] = mysql_result($ss, 0, 2);
  389. $x[0][3] = mysql_result($ss, 0, 3);
  390. return $x;
  391. }
  392. function dtopperjgirl($year)
  393. {
  394. $ss = mysql_query("select main.sn,main.name,main.per,main.school from main inner join schools on main.school=schools.schoolcode and schools.type=1 and main.year=$year and gender like 'f%' order by per DESC LIMIT 0,2");
  395. $x[0][0] = mysql_result($ss, 0, 0);
  396. $x[0][1] = mysql_result($ss, 0, 1);
  397. $x[0][2] = mysql_result($ss, 0, 2);
  398. $x[0][3] = mysql_result($ss, 0, 3);
  399. $x[1][0] = mysql_result($ss, 1, 0);
  400. $x[1][1] = mysql_result($ss, 1, 1);
  401. $x[1][2] = mysql_result($ss, 1, 2);
  402. $x[1][3] = mysql_result($ss, 1, 3);
  403. return $x;
  404. }
  405. function dtopperj($year)
  406. {
  407. $ss = mysql_query("select main.sn,main.name,main.per,main.school from main inner join schools on main.school=schools.schoolcode and schools.type=1 and main.year=$year order by per DESC");
  408. $x[0][0] = mysql_result($ss, 0, 0);
  409. $x[0][1] = mysql_result($ss, 0, 1);
  410. $x[0][2] = mysql_result($ss, 0, 2);
  411. $x[0][3] = mysql_result($ss, 0, 3);
  412. $x[1][0] = mysql_result($ss, 1, 0);
  413. $x[1][1] = mysql_result($ss, 1, 1);
  414. $x[1][2] = mysql_result($ss, 1, 2);
  415. $x[1][3] = mysql_result($ss, 1, 3);
  416. $x[2][0] = mysql_result($ss, 2, 0);
  417. $x[2][1] = mysql_result($ss, 2, 1);
  418. $x[2][2] = mysql_result($ss, 2, 2);
  419. $x[2][3] = mysql_result($ss, 2, 3);
  420. $x[3][0] = mysql_result($ss, 3, 0);
  421. $x[3][1] = mysql_result($ss, 3, 1);
  422. $x[3][2] = mysql_result($ss, 3, 2);
  423. $x[3][3] = mysql_result($ss, 3, 3);
  424. $x[4][0] = mysql_result($ss, 4, 0);
  425. $x[4][1] = mysql_result($ss, 4, 1);
  426. $x[4][2] = mysql_result($ss, 4, 2);
  427. $x[4][3] = mysql_result($ss, 4, 3);
  428. return $x;
  429. }
  430. function btopper($year, $school)
  431. {
  432. $ss = mysql_query("select sn,name,gradepoint from maingrade where year=$year and school='$school' and left(gender,1)='M' order by weight DESC");
  433. if (mysql_num_rows($ss) > 0) {
  434. $x[0] = mysql_result($ss, 0, 0);
  435. $x[1] = mysql_result($ss, 0, 1);
  436. $x[2] = mysql_result($ss, 0, 2);
  437. } else {
  438. $x[0] = "N/A";
  439. $x[1] = "N/A";
  440. $x[2] = "N/A";
  441. }
  442. return $x;
  443. }
  444. function gtopper($year, $school)
  445. {
  446. $ss = mysql_query("select sn,name,gradepoint from maingrade where year=$year and school='$school' and left(gender,1)='F' order by weight DESC");
  447. if (mysql_num_rows($ss) > 0) {
  448. $x[0] = mysql_result($ss, 0, 0);
  449. $x[1] = mysql_result($ss, 0, 1);
  450. $x[2] = mysql_result($ss, 0, 2);
  451. } else {
  452. $x[0] = "N/A";
  453. $x[1] = "N/A";
  454. $x[2] = "N/A";
  455. }
  456. return $x;
  457. }
  458. function getfmth($year)
  459. {
  460. $tq = mysql_query("select * from fmpm where year=$year");
  461. $tt = mysql_fetch_row($tq);
  462. $no = getsub($year);
  463. $a = 0;
  464. $th = 1;
  465. for ($i = 1; $i <= $no; $i++) {
  466. $x[$a] = $tt[$th];
  467. $th = $th + 2;
  468. $a++;
  469. }
  470. return $x;
  471. }
  472. function getfmpr($year)
  473. {
  474. $tq = mysql_query("select * from fmpm where year=$year");
  475. $tt = mysql_fetch_row($tq);
  476. $no = getsub($year);
  477. $a = 0;
  478. $th = 2;
  479. for ($i = 1; $i <= $no; $i++) {
  480. $x[$a] = $tt[$th];
  481. $th = $th + 2;
  482. $a++;
  483. }
  484. return $x;
  485. }
  486. function givsub($year)
  487. {
  488. $no = getsub($year);
  489. $sq = mysql_query("select * from subject where year=$year");
  490. $ssq = mysql_fetch_row($sq);
  491. for ($i = 1; $i <= $no; $i++) {
  492. $x[$i - 1] = $ssq[$i + 2];
  493. }
  494. return $x;
  495. }
  496. function getmarkth($year, $school, $sn)
  497. {
  498. $no = getsub($year);
  499. $ss = mysql_query("select * from main where year=$year and school='$school' and sn='$sn'");
  500. $sss = mysql_fetch_row($ss);
  501. $a = 6;
  502. for ($i = 1; $i <= $no; $i++) {
  503. $x[$i - 1] = $sss[$a];
  504. $a = $a + 2;
  505. }
  506. return $x;
  507. }
  508. function getmarkpr($year, $school, $sn)
  509. {
  510. $no = getsub($year);
  511. $ss = mysql_query("select * from main where year=$year and school='$school' and sn='$sn'");
  512. $sss = mysql_fetch_row($ss);
  513. $a = 7;
  514. for ($i = 1; $i <= $no; $i++) {
  515. $x[$i - 1] = $sss[$a];
  516. $a = $a + 2;
  517. }
  518. return $x;
  519. }
  520. function checkdup($year, $sn)
  521. {
  522. $q = mysql_query("select * from main where year=$year and sn='$sn'");
  523. if (mysql_num_rows($q) > 0)
  524. return 1;
  525. else
  526. return 0;
  527. }
  528. /*
  529. $aa=getmarks(2059,"ABC School",4534);
  530. print_r($aa);
  531. echo "<br>".isgrace($aa);
  532. echo "<br>".putmarks(26,"Failed",$aa);
  533. */
  534. function idfromschool($school)
  535. {
  536. $data = mysql_query("select schoolcode from schools where name='$school'");
  537. $d = mysql_fetch_row($data);
  538. return $d[0];
  539. }
  540. function schoolfromid($id)
  541. {
  542. $data = mysql_query("select name from schools where schoolcode='$id'");
  543. $d = mysql_fetch_row($data);
  544. return $d[0];
  545. }
  546. function givetotal($year)
  547. {
  548. $que = mysql_query("Select * from fmpm where year=$year");
  549. $dat = mysql_fetch_row($que);
  550. return $dat[1] + $dat[2] + $dat[3] + $dat[4] + $dat[5] + $dat[6] + $dat[7] + $dat[8] + $dat[9] + $dat[10] + $dat[11] + $dat[12] + $dat[13] + $dat[14] + $dat[15] + $dat[16] + $dat[17] + $dat[18] + $dat[19] + $dat[20];
  551. }
  552. ?>