本文整理汇总了PHP中Publication::find_by_sql方法的典型用法代码示例。如果您正苦于以下问题：PHP Publication::find_by_sql方法的具体用法？PHP Publication::find_by_sql怎么用？PHP Publication::find_by_sql使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Publication的用法示例。
在下文中一共展示了Publication::find_by_sql方法的2个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1:
</tr>
';
$qual_counter++;
}
}
?>
</tbody>
</table>
<?php
if ($personal_details['student_status'] == "PGA") {
?>
<h4 align="center" class="alert alert-success">Academic Publications</h4>
<?php
$academic_publication = Publication::find_by_sql("SELECT * FROM academic_publications WHERE applicant_id='" . $applicant_id . "'");
if (empty($academic_publication)) {
$no_information = 'No Information Supplied';
echo '
<table class="table table-bordered table-hover">
<thead>
<th>S/N</th>
<th>Title Of Publication</th>
<th>Institution</th>
<th>Qualification</th>
<th>Year</th>
</thead>
<tbody>
<tr>
<td width="4%"> 1. </td>
<td width="20%">' . $no_information . '</td>示例2: MySQLDatabase
<?php
$database = new MySQLDatabase();
$session = new Session();
$academic_publications = Publication::find_by_sql("SELECT * FROM academic_publications WHERE applicant_id=" . $session->applicant_id);
$other_publications = OtherPublication::find_by_sql("SELECT * FROM otherpublications WHERE applicant_id=" . $session->applicant_id);
?>
<form action="" method="POST" class="publications" >
<!-- Beginning of Publications -->
<table class="table table-hover">
<caption><h3>Academic Publications</h3></caption>
<caption><h4>Thesis, Projects and Publications</h4></caption>
<thead>
<tr>
<th>S/N</th>
<th>Title</th>
<th>Institution</th>
<th>Qualifications</th>
<th>Date</th>
</tr>
</thead>
<tbody id="thesis_projects_publication">
<?php
if (!empty($academic_publications)) {
$index = 1;
foreach ($academic_publications as $academic) {
$publication_title = 'publication_title_' . $index;
$publication_inst = 'publication_institution_' . $index;
$publication_qualification = 'publication_qualification_' . $index;