Server IP : 92.204.138.22 / Your IP : 18.224.52.190 Web Server : Apache System : Linux ns1009439.ip-92-204-138.us 4.18.0-553.8.1.el8_10.x86_64 #1 SMP Tue Jul 2 07:26:33 EDT 2024 x86_64 User : internationaljou ( 1019) PHP Version : 7.4.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /home/internationaljou/SSRG-01-03-2024/admin/ |
Upload File : |
<?php include("header.php"); include("left-menu.php"); include("config.php"); //header('location:articleview.php?value='); ?> <noscript> <div class="alert alert-block col-md-12"> <h4 class="alert-heading">Warning!</h4> <p>You need to have <a href="http://en.wikipedia.org/wiki/JavaScript" target="_blank">JavaScript</a> enabled to use this site.</p> </div> </noscript> <div id="content" class="col-lg-10 col-sm-10"> <!-- content starts --> <div> <ul class="breadcrumb"> <li> <a href="#">Home</a> </li> <li> <a href="#">Special Issue Article</a> </li> </ul> </div> <div class="row"> <div class="box col-md-12"> <div class="box-inner"> <div class="box-header well" data-original-title=""> <h2><i class="glyphicon glyphicon-home"></i> View Special Issue Article</h2> <div class="box-icon"> <a href="#" class="btn btn-setting btn-round btn-default"><i class="glyphicon glyphicon-cog"></i></a> <a href="#" class="btn btn-minimize btn-round btn-default"><i class="glyphicon glyphicon-chevron-up"></i></a> <a href="#" class="btn btn-close btn-round btn-default"><i class="glyphicon glyphicon-remove"></i></a> </div> </div> <div class="box-content"> <table class="table table-striped table-bordered bootstrap-datatable datatable responsive"> <thead> <tr> <th>S.NO</th> <th>Conference Name</th> <th>Short form</th> <th>Year</th> <th>Department</th> <th>Part</th> <th>Title</th> <th>Author</th> <th>Pdf</th> <th>Action</th> </tr> </thead> <tbody> <?php $i=0; $sshortname = $_REQUEST['name']; $sdepartment = $_REQUEST['department']; $spart = $_REQUEST['part']; $syear = $_REQUEST['year']; $query = "select * from specialissue_conference inner join specialissue_article on specialissue_conference.sp_id=specialissue_article.sc_id Inner join article_department on specialissue_article.department=article_department.dp_id"; if($sshortname!='') { $query.= " where sp_id='$sshortname'"; } if($sdepartment!='') { $query.= " And department='$sdepartment'"; } if($spart!='') { $query.= " And part='$spart'"; } if($syear!='') { $query.= " And specialissue_article.year='$syear'"; } //echo $query; //exit; $sqls = mysqli_query($conn,$query); //$sqls = mysqli_query($conn,"select * from `specialissue_conference` "); while ($row = mysqli_fetch_array($sqls)) { $i++; ?> <tr> <td class="center"><?php echo $i ?></td> <td class="center"><?php echo $row['conference_name']; ?></td> <td class="center"><?php echo $row['shortform']; ?></td> <td class="center"><?php echo $row['year']; ?></td> <td class="center"><?php echo $row['department_name']; ?></td> <td class="center"><?php echo $row['part'] ?></td> <td class="center"><?php echo $row['title'] ?></td> <td class="center"><?php echo $row['author'] ?></td> <td class="center"><?php echo $row['pdf'] ?></td> <td class="center"><a class="btn btn-success" href="edit_specialissue.php?sid=<?php echo $row['sp_id'] ?>"> <i class="glyphicon glyphicon-edit icon-white"></i> Edit </a> <a class="btn btn-success" onclick='confirmationDelete(this);return false;' href="delete_specialissue.php?sid=<?php echo $row['sp_id'];?>" > <i class="glyphicon glyphicon-trash icon-white"></i> Delete </a></td> </tr> <?php } ?> </tbody> </table> </div> </div> </div> </div> <?php include("footer.php"); ?>