コード例 #1
0
ファイル: manutrack.php プロジェクト: bamzy/newest-press
function getmankw($field, $text)
{
    $text = mysql_real_escape_string($text);
    $cloud = mysql_query("SELECT title_orig, genre, notes, stat_id, man_id, per_id, datesubmitted FROM tbl_manuscript where {$field} LIKE '%{$text}%'") or die(mysql_error());
    while ($arr = mysql_fetch_assoc($cloud)) {
        $perid = $arr['per_id'];
        $author = authname($perid);
        printf('
	<p>
	<table>
	<tr><td>Manuscript ref #:</td><td><a href="viewmanuscript.php?manid=' . $arr['man_id'] . '">' . $arr['man_id'] . '</a></td><td></td></tr>
	<tr><td>Author:</td><td><a href="viewauthor.php?perid=' . $perid . '">' . $author . '</a></td><td></td></tr>
	<tr><td>Title:</td><td>' . $arr['title_orig'] . '</td><td></td></tr>
	<tr><td>Genre:</td><td>' . $arr['genre'] . '</td><td></td></tr>
	<tr><td>Notes:</td><td>' . $arr['notes'] . '</td><td></td></tr>');
        getstatus($arr['stat_id']);
        printf('<tr><td>Date submitted:&nbsp;&nbsp;</td><td>' . $arr['datesubmitted'] . '</td><td></td></tr>');
        getfileinfo($arr['man_id']);
    }
}
コード例 #2
0
    die('There was an error running the query [' . $query->error . ']');
}
$arr = $res->fetch_assoc();
$perid = $arr['per_id'];
$author = authname($perid);
printf('
		<div class="manuscript">
	
		<table>
		<tr><td>Manuscript ref #:</td><td>' . $manid . '</td><td></td></tr>
		<tr><td>Author:</td><td>' . $author . '</a></td><td></td></tr>
		<tr><td>Title:</td><td>' . $arr['title_orig'] . '</td><td></td></tr>
		<tr><td>Genre:</td><td>' . $arr['genre'] . '</td><td></td></tr>
		<tr><td>Author Note:</td><td>' . $arr['notes'] . '</td><td></td></tr>');
printf('<tr><td>Date submitted:&nbsp;&nbsp;</td><td>' . $arr['datesubmitted'] . '</td><td></td></tr>');
getfileinfo($manid);
printf('</div>');
printf('<span class="manuside">');
if ($arr['active'] == 'Y') {
    printf('Active&nbsp;<br /><br />');
} else {
    printf('Inactive&nbsp;<br /><br />');
}
getstatnohtml($arr['stat_id']);
printf('</span>');
$perid = $_SESSION['per_id'];
$query = "SELECT rev_id FROM tbl_review WHERE per_id={$perid} AND man_id={$manid}";
if (!($res = mysqlConnection::getConnection()->query($query))) {
    die('There was an error running the query [' . $query->error . ']');
}
$rows = $res->num_rows;