query2hash PHP Code Examples

Example #1

0

Show file

File: view.php Project: hightechcompany/dotproject

	<th colspan="2" align="center"><?php 
echo $title;
?>
</th>
</tr>

<form name="ticketform" action="index.php?m=ticketsmith&a=view&ticket=<?php 
echo $ticket;
?>
" method="post">
<input type="hidden" name="ticket" value="$ticket" />

<?php 
/* start form */
/* get ticket */
$ticket_info = query2hash("SELECT * FROM tickets WHERE ticket = {$ticket}");
print "<input type=\"hidden\" name=\"orig_assignment\" value='" . $ticket_info["assignment"] . "' />\n";
print "<input type=\"hidden\" name=\"author\" value='" . $ticket_info["author"] . "' />\n";
print "<input type=\"hidden\" name=\"priority\" value='" . $ticket_info["priority"] . "' />\n";
print "<input type=\"hidden\" name=\"subject\" value='" . $ticket_info["subject"] . "' />\n";
/* output ticket */
for ($loop = 0; $loop < count($fields["headings"]); $loop++) {
    print "<tr>\n";
    if ($fields["headings"][$loop] !== "<br />") {
        $fields["headings"][$loop] = $AppUI->_($fields["headings"][$loop]);
    }
    print "<td align=\"right\">" . $fields["headings"][$loop] . "</td>";
    print "<td align=\"left\" class=\"hilite\">" . format_field($ticket_info[$fields["columns"][$loop]], $fields["types"][$loop]) . "</td>\n";
    print "</tr>\n";
}
$ticket_info["assignment"];

Example #2

0

Show file

File: admin.php Project: klr2003/sourceread

     $title = "User Deleted";
     $content = "<tr><td align=\"center\" colspan=\"3\">The user has been deleted.</td></tr>\n";
     break;
 case "new":
     $title = "Create User";
     $content = "<tr><td><strong>Name</strong></td><td colspan=\"2\"><font size=\"-1\"><input type=\"text\" name=\"name\" size=\"20\"></font></td></tr>\n";
     $content .= "<tr><td><strong>Email</strong> </td><td colspan=\"2\"><font size=\"-1\"><input type=\"text\" name=\"email\" size=\"20\"></font></td></tr>\n";
     $content .= "<tr><td><strong>Username</strong></td><td colspan=\"2\"><font size=\"-1\"><input type=\"text\" name=\"username\" size=\"20\"></font></td></tr>\n";
     $content .= "<tr><td><strong>Password</strong></td><td colspan=\"2\"><font size=\"-1\"><input type=\"password\" name=\"password\" size=\"20\"></font></td></tr>\n";
     $content .= "<tr><td><strong>Signature</strong></td><td colspan=\"2\"><tt><textarea name=\"signature\" cols=\"72\" rows=\"3\"></textarea></tt></td></tr>\n";
     $content .= "<tr><td><br /></td><td colspan=\"2\"><font size=\"-1\"><input type=\"submit\" value=\"Create user\"></font></td></tr>\n";
     $content .= "<input type=\"hidden\" name=\"action\" value=\"create\">\n";
     break;
 case "edit":
     $title = "Edit User";
     $user_info = query2hash("SELECT * FROM users WHERE id = '{$id}'");
     $content = "<tr><td><strong>Name</strong></td><td colspan=\"2\"><font size=\"-1\"><input type=\"text\" name=\"name\" size=\"20\" value=\"" . $user_info["name"] . "\"></font></td></tr>\n";
     $content .= "<tr><td><strong>Email</strong> </td><td colspan=\"2\"><font size=\"-1\"><input type=\"text\" name=\"email\" size=\"20\" value=\"" . $user_info["email"] . "\"></font></td></tr>\n";
     $content .= "<tr><td><strong>Password</strong></td><td colspan=\"2\"><font size=\"-1\"><input type=\"password\" name=\"password\" size=\"20\" value=\"" . $user_info["password"] . "\"></font></td></tr>\n";
     $content .= "<tr><td><strong>Signature</strong></td><td colspan=\"2\"><tt><textarea name=\"signature\" cols=\"72\" rows=\"3\">" . $user_info["signature"] . "</textarea></tt></td></tr>\n";
     $content .= "<tr><td><br /></td><td colspan=\"2\"><font size=\"-1\"><input type=\"submit\" name=\"action\" value=\"Apply changes\"> <input type=\"submit\" name=\"action\" value=\"Delete this user\"></font></td></tr>\n";
     $content .= "<input type=\"hidden\" name=\"id\" value=\"" . $user_info["id"] . "\">\n";
     $content .= "<input type=\"hidden\" name=\"old_password\" value=\"" . $user_info["password"] . "\">\n";
     break;
 default:
     $title = "User Administration";
     $content = "<tr><td align=\"center\"><strong>Edit</strong></td><td><strong>User</strong></td><td><strong>Email</strong></td></tr>\n";
     $result = do_query("SELECT id, name, email FROM users WHERE username != 'admin' ORDER BY id");
     while ($row = result2hash($result)) {
         $content .= "<tr>";
         $content .= "<td align=\"center\"><a href=\"index.php?a=ticketsmith&a=edit&id=" . $row["id"] . "\"><img src=modules/ticketsmith/images/posticon.gif\" border=\"0\"></a></td>";

Example #3

0

Show file

File: view.php Project: srinivasulurao/jonel

	<th colspan="2" align="center"><?php 
echo $title;
?>
</th>
</tr>

<form name="ticketform" action="index.php?m=ticketsmith&amp;a=view&amp;ticket=<?php 
echo $ticket;
?>
" method="post">
<input type="hidden" name="ticket" value="$ticket" />

<?php 
/* start form */
/* get ticket */
$ticket_info = query2hash("SELECT * FROM {$dbprefix}tickets WHERE ticket = {$ticket}");
print "<input type=\"hidden\" name=\"orig_assignment\" value='" . $ticket_info["assignment"] . "' />\n";
print "<input type=\"hidden\" name=\"author\" value='" . $ticket_info["author"] . "' />\n";
print "<input type=\"hidden\" name=\"priority\" value='" . $ticket_info["priority"] . "' />\n";
print "<input type=\"hidden\" name=\"subject\" value='" . $ticket_info["subject"] . "' />\n";
/* output ticket */
for ($loop = 0; $loop < count($fields["headings"]); $loop++) {
    print "<tr>\n";
    if ($fields["headings"][$loop] !== "<br />") {
        $fields["headings"][$loop] = $AppUI->_($fields["headings"][$loop]);
    }
    print "<td align=\"right\">" . $fields["headings"][$loop] . "</td>";
    print "<td align=\"left\" class=\"hilite\">" . format_field($ticket_info[$fields["columns"][$loop]], $fields["types"][$loop]) . "</td>\n";
    print "</tr>\n";
}
$ticket_info["assignment"];

Example #4

0

Show file

File: admin.php Project: hoodoogurus/dotprojecteap

     $title = "User Deleted";
     $content = "<tr><td align=\"center\" colspan=\"3\">The user has been deleted.</td></tr>\n";
     break;
 case "new":
     $title = "Create User";
     $content = "<tr><td><strong>Name</strong></td><td colspan=\"2\"><font size=\"-1\"><input type=\"text\" name=\"name\" size=\"20\" /></font></td></tr>\n";
     $content .= "<tr><td><strong>Email</strong> </td><td colspan=\"2\"><font size=\"-1\"><input type=\"text\" name=\"email\" size=\"20\" /></font></td></tr>\n";
     $content .= "<tr><td><strong>Username</strong></td><td colspan=\"2\"><font size=\"-1\"><input type=\"text\" name=\"username\" size=\"20\" /></font></td></tr>\n";
     $content .= "<tr><td><strong>Password</strong></td><td colspan=\"2\"><font size=\"-1\"><input type=\"password\" name=\"password\" size=\"20\" /></font></td></tr>\n";
     $content .= "<tr><td><strong>Signature</strong></td><td colspan=\"2\"><tt><textarea name=\"signature\" cols=\"72\" rows=\"3\"></textarea></tt></td></tr>\n";
     $content .= "<tr><td><br /></td><td colspan=\"2\"><font size=\"-1\"><input type=\"submit\" value=\"Create user\" /></font></td></tr>\n";
     $content .= "<input type=\"hidden\" name=\"action\" value=\"create\" />\n";
     break;
 case "edit":
     $title = "Edit User";
     $user_info = query2hash("SELECT * FROM {$dbprefix}users WHERE id = '{$id}'");
     $content = "<tr><td><strong>Name</strong></td><td colspan=\"2\"><font size=\"-1\"><input type=\"text\" name=\"name\" size=\"20\" value=\"" . $user_info["name"] . "\" /></font></td></tr>\n";
     $content .= "<tr><td><strong>Email</strong> </td><td colspan=\"2\"><font size=\"-1\"><input type=\"text\" name=\"email\" size=\"20\" value=\"" . $user_info["email"] . "\" /></font></td></tr>\n";
     $content .= "<tr><td><strong>Password</strong></td><td colspan=\"2\"><font size=\"-1\"><input type=\"password\" name=\"password\" size=\"20\" value=\"" . $user_info["password"] . "\" /></font></td></tr>\n";
     $content .= "<tr><td><strong>Signature</strong></td><td colspan=\"2\"><tt><textarea name=\"signature\" cols=\"72\" rows=\"3\">" . $user_info["signature"] . "</textarea></tt></td></tr>\n";
     $content .= "<tr><td><br /></td><td colspan=\"2\"><font size=\"-1\"><input type=\"submit\" name=\"action\" value=\"Apply changes\" /> <input type=\"submit\" name=\"action\" value=\"Delete this user\" /></font></td></tr>\n";
     $content .= "<input type=\"hidden\" name=\"id\" value=\"" . $user_info["id"] . "\" />\n";
     $content .= "<input type=\"hidden\" name=\"old_password\" value=\"" . $user_info["password"] . "\" />\n";
     break;
 default:
     $title = "User Administration";
     $content = "<tr><td align=\"center\"><strong>Edit</strong></td><td><strong>User</strong></td><td><strong>Email</strong></td></tr>\n";
     $result = do_query("SELECT id, name, email FROM {$dbprefix}users WHERE username != 'admin' ORDER BY id");
     while ($row = result2hash($result)) {
         $content .= "<tr>";
         $content .= "<td align=\"center\"><a href=\"?a=ticketsmith&amp;a=edit&amp;id=" . $row["id"] . "\"><img src='modules/ticketsmith/images/posticon.gif' border=\"0\" /></a></td>";

PHP query2hash Examples