PHP jjtsql_field_array_load Examples

Example #1

File: project_list.php Project: JJTComputing/JJTCode

if (!defined("jjtcode")) {
    die("Hacking Attempt!");
}
?>
<form action="/" class="jNice" method="GET">
<table border="1">
	<tr>
		<th>Project Name</th>
		<th>Description</th>
		<th>Last Modified</th>
		<th>Profile</th>
	</tr>

<?php 
// Load up the projects data from the MySQL table
$table = jjtsql_field_array_load("projects", "visible", "1");
foreach ($table as $value) {
    echo '<tr>';
    echo '<td class="action"><a href="/?action=file_list&amp;project_id=' . $value['id'] . '" class="delete">' . $value['project_name'] . '</a></td>';
    echo '<td>' . $value['description'] . '</td>';
    echo '<td>' . date("r", $value['last_modified']) . '</td>';
    echo '<td class="action"><a href="/?action=project_view&amp;project_id=' . $value['id'] . '" class="view">Profile</a></td>';
    echo '</tr>';
}
?>
</table>
<?php 
// If they can create projects, let them!
if ($_SESSION['level'] >= 2) {
    echo '<a href="/?action=project_create"><button class="" type="submit" name="" id=""><span><span>Create Project</span></span></button></a>';
}

Example #2

File: file_create.php Project: JJTComputing/JJTCode

	<br />

	<textarea id="textarea" style="width:900px; height:600px;" name="content"></textarea>

	<br />

	<input type="hidden" name="action" value="file_do" />
	<input type="hidden" name="do" value="create" />
	<input type="hidden" name="project_id" value="<?php 
    echo $project_id;
    ?>
" />
	 <?php 
    // Give them an offer to create the file in a directory, if there are any
    $directories = jjtsql_field_array_load("directories", "project_id", $project_id);
    // If it is a bool, there are no directories, and so the foreach loop will generate an error
    if (!is_bool($directories)) {
        echo 'Directory: <select name="directory">';
        echo '<option value="">/</option>';
        foreach ($directories as $value) {
            echo '<option value=' . $value['directory_id'] . '>' . $value['directory'] . '</option>';
        }
    }
    ?>
	</select>
	<br /><br /><br /><br />
	<input type="submit" name="" value="Create File" onSubmit="" />
	</fieldset>
	</form>
<?php