Hello,I am newbie in working with php. I am trying to change this table,have a look:
php.JPG:
I want to change the first colum,from date,and rewrite there what i want, etc “custom”
The problem for me is,that I cant find the part that should rewrite these fields.
If anyone could repply to this thread,and step by step write what i have to do to make that table as I want.
Heres to code of php table too:
<?php
/************************************************************************/
/* MILPACS (Military Personell and Classification System) */
/* Author::Donovan [3rd ID] */
/* Copyright (c) 2005 by Steven Donovan AKA Donovan [3rd ID] */
/* Email::
[email protected]
/* Homepage::http://www.3rd-infantry-division.net */
/* */
/* This program is free software; you can redistribute it and/or modify */
/* it under the terms of the GNU General Public License as published by */
/* the Free Software Foundation; either version 2 of the License. */
/* */
/* This program is distributed in the hope that it will be useful, but */
/* WITHOUT ANY WARRANTY; without even the implied warranty of */
/* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU */
/* General Public License for more details. */
/* */
/* If you want a copy of the GNU General Public License write to the */
/* Free Software Foundation, Inc. */
/* 59 Temple Place, Suite 330, Boston, MA 02111-1307 */
/* USA */
/************************************************************************/
/*********************************************************/
/* View Drill */
/*********************************************************/
if (!defined('MODULE_FILE')) {
die ("You can't access this file directly...");
}
//require_once("common.php");
session_start();
if ($_SESSION['loggedin1'] ) {
define('INDEX_FILE', false);
$index = 0;
require_once("mainfile.php");
$module_name = basename(dirname(__FILE__));
@include_once("header.php");
global $prefix, $db, $module_name, $bgcolor1, $bgcolor2;
$result = $db->sql_query("SELECT * FROM " . $prefix . "_milpacs_main");
$info = $db->sql_fetchrow($result);
$unit_name = $info[unit_name];
$unit_tag = $info[unit_tag];
OpenTable();
echo"
"
. "$unit_tag výcviková stránka
|
"
. ""
. ""
. "
"
. ""
."";
CloseTable();
OpenTable();
echo"
"
. "
Datum výcviku |
Vedoucí výcviku |
Prohlídnout výcvik"
. " |
"
."";
// create the SQL statement
$sql = "SELECT drill_id, drill_dt, drill_leader FROM " . $prefix . "_milpacs_drills ORDER BY drill_dt DESC";
//fill the table with values from drill table
$result = $db->sql_query($sql);
$total = $db->sql_numrows($result);
$posts_per_page = 20;
if (!isset($start)) { $start = 0; }
else {$start = intval($start);}
$pageaddy = "modules.php?name=MILPACS&file=viewdrill";
if($total > $posts_per_page) {
$times = 0;
for($x = 0; $x < $total; $x += $posts_per_page)
$times++;
$pages = $times;
}
if($total > $posts_per_page) {
$printposts = "";
$times = 1;
$printposts = $printposts . ""." ( ";
$last_page = $start - $posts_per_page;
if($start > 0) {
$printposts = $printposts . "P?edchozí stránka ";
}
for($x = 0; $x < $total; $x += $posts_per_page) {
if($times != 1)
$printposts = $printposts . " | ";
if($start && ($start == $x)) {
$printposts = $printposts . "".$times."";
}
else if($start == 0 && $x == 0) {
$printposts = $printposts . "1";
}
else {
$printposts = $printposts . "$times";
}
$times++;
}
if(($start + $posts_per_page) < $total) {
$next_page = $start + $posts_per_page;
$printposts = $printposts . " Další stránka";
}
$printposts = $printposts . " ) |
\n";
}
$sql = "SELECT drill_id, drill_dt, drill_leader FROM " . $prefix . "_milpacs_drills ORDER BY drill_dt DESC LIMIT $start, $posts_per_page";
//fill the table with values from drill table
$result = $db->sql_query($sql);
while ( $row = $db->sql_fetchrow($result) ) {
extract($row);
list($Year,$Month,$Day) = split('-',$drill_dt);
$formatdrilldate = date("F j, Y",mktime(12,0,0,$Month,$Day,$Year));
?>
<?php echo $formatdrilldate ?> |
<?php echo $drill_leader ?> |
Klikni zde!
|
<?php
}
?>
<?php
if($total > $posts_per_page) {
echo $printposts;
}
}
else
{
$_SESSION['loggedin1'] = 0;
Header("Location: modules.php?name=MILPACS&file=checkuser");
}
?>
<?php
CloseTable();
@include_once("footer.php");
?>
Thank you for any post and your time…