The Application developed will be used to manage the placements in college, this software maintain the student details
Based on search criteria the corresponding details are displayed
This system also has to keep track of any forthcoming placement activities
Automatically send email or sms alerts to the eligible candidates
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.002049s ]
SELECT `a`.`aid`,`a`.`title`,`a`.`create_time`,`m`.`username` FROM `jrk_downrecords` `a` INNER JOIN `jrk_member` `m` ON `a`.`uid`=`m`.`id` WHERE `a`.`status` = 1 GROUP BY `a`.`aid` ORDER BY `a`.`create_time` DESC LIMIT 10 [ RunTime:0.090345s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.002480s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001941s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.002581s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003915s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.002789s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003580s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.016337s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.008252s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 255416 [ RunTime:0.001411s ]