Ima dve skripte i to
lnews.php
Code:
<?php
function lista() {
include "connect.php";
$db_connection = mysql_connect($dbhost, $dbuser, $dbpass)
or die("Could not connect to DB");
mysql_select_db ($dbbaza, $db_connection)
or die("Could not find DB");
$query = "SELECT id, opis, od, do "
. "FROM tt_vesti "
. "ORDER BY id";
$query_result = mysql_query ($query, $db_connection);
print("<table>\n");
print("<tr>\n");
print(" <td><b> id </b></td>\n");
print(" <td><b> opis </b></td>\n");
print(" <td><b> od </b></td>\n");
print(" <td><b> do </b></td>\n");
print("</tr>\n");
while ($row = mysql_fetch_object ($query_result))
{
$id = $row->id;
$opis = $row->opis;
$od = $row->od;
$do = $row->do;
print("<tr>\n");
$linija = '<td><a href="enews.php?id=' . $id . '">'. $id . '</a></td>';
print(" $linija\n");
$linija = '<td>' . $opis . '</td>';
print(" $linija\n");
$linija = '<td>' . $od . '</td>';
print(" $linija\n");
$linija = '<td>' . $do . '</td>';
print(" $linija\n");
print("</tr>\n");
}
print("</table>\n<br>\n");
mysql_close($db_connection); }
?>
<HTML>
<HEAD>
<TITLE>news list</TITLE>
<link href="page.css" rel="stylesheet" type="text/css">
</HEAD>
<BODY>
<H2>TT_VESTI : LIST<H2>
<?php lista(); ?>
</BODY>
</HTML>
<?php
function lista() {
include "connect.php";
$db_connection = mysql_connect($dbhost, $dbuser, $dbpass)
or die("Could not connect to DB");
mysql_select_db ($dbbaza, $db_connection)
or die("Could not find DB");
$query = "SELECT id, opis, od, do "
. "FROM tt_vesti "
. "ORDER BY id";
$query_result = mysql_query ($query, $db_connection);
print("<table>\n");
print("<tr>\n");
print(" <td><b> id </b></td>\n");
print(" <td><b> opis </b></td>\n");
print(" <td><b> od </b></td>\n");
print(" <td><b> do </b></td>\n");
print("</tr>\n");
while ($row = mysql_fetch_object ($query_result))
{
$id = $row->id;
$opis = $row->opis;
$od = $row->od;
$do = $row->do;
print("<tr>\n");
$linija = '<td><a href="enews.php?id=' . $id . '">'. $id . '</a></td>';
print(" $linija\n");
$linija = '<td>' . $opis . '</td>';
print(" $linija\n");
$linija = '<td>' . $od . '</td>';
print(" $linija\n");
$linija = '<td>' . $do . '</td>';
print(" $linija\n");
print("</tr>\n");
}
print("</table>\n<br>\n");
mysql_close($db_connection); }
?>
<HTML>
<HEAD>
<TITLE>news list</TITLE>
<link href="page.css" rel="stylesheet" type="text/css">
</HEAD>
<BODY>
<H2>TT_VESTI : LIST<H2>
<?php lista(); ?>
</BODY>
</HTML>
i enews.php
Code:
<HTML>
<HEAD>
<TITLE>news edit</TITLE>
<link href="page.css" rel="stylesheet" type="text/css">
</HEAD>
<BODY>
<H2>TT_VESTI : EDIT  <a href="lnews.php"> LIST </a></H2>
<FORM METHOD="POST" ACTION="enews.php" >
<?php
$id = $_REQUEST['id']; <<< da li ovo dobro ili treba drugacije?
?>
<?php
function check_mysql()
{
if (mysql_errno() > 0)
{
die("<BR> MySQL error " . mysql_errno() . ": " . mysql_error());
}
}
include "connect.php";
$db = mysql_connect( $dbhost, $dbuser, $dbpass );
if (!$db)
{
die("Failed to open connection to MySQL server.");
}
mysql_select_db( $dbbaza );
check_mysql();
if(!isset($id))
{
$id=0;
}
if (isset($left))
{
$query = "SELECT id, opis, od, do "
. "FROM tt_vesti "
. "WHERE id < $id "
. "ORDER BY id DESC ";
$result = mysql_query($query);
check_mysql();
$row = mysql_fetch_row($result);
check_mysql();
if ($row[0] > 0)
{
$id = $row[0];
$opis = $row[1];
$od = $row[2];
$do = $row[3];
}
}
elseif (isset($right))
{
$query = "SELECT id, opis, od, do "
. "FROM tt_vesti "
. "WHERE id > $id "
. "ORDER BY id ASC ";
$result = mysql_query($query);
check_mysql();
$row = mysql_fetch_row($result);
check_mysql();
if ($row[0] > 0)
{
$id = $row[0];
$opis = $row[1];
$od = $row[2];
$do = $row[3];
}
}
elseif (isset($search))
{
$id = 0;
$query = "SELECT id, opis, od, do "
. "FROM tt_vesti "
. "WHERE opis like '%$opis%' ";
$result = mysql_query($query);
check_mysql();
$row = mysql_fetch_row($result);
check_mysql();
if ($row[0] > 0)
{
$id = $row[0];
$opis = $row[1];
$od = $row[2];
$do = $row[3];
}
}
elseif (isset($add))
{
$query = "INSERT INTO tt_vesti "
. "( opis, od, do) VALUES ('$opis', '$od', '$do') ";
$result = mysql_query($query);
check_mysql();
$id = mysql_insert_id();
$message = "Record Added (id=$id)";
}
elseif (isset($update))
{
$query = "UPDATE tt_vesti SET opis='$opis', od='$od', do='$do' "
. "WHERE id = $id ";
$result = mysql_query($query);
check_mysql();
$message = "Record Updated (id=$id)";
}
elseif (isset($delete))
{
$query = "DELETE FROM tt_vesti WHERE id = $id ";
$result = mysql_query($query);
check_mysql();
$message = "Record Deleted (id=$id)";
}
elseif ($id != 0)
{
$query = "SELECT id, opis, od, do "
. "FROM tt_vesti "
. "WHERE id = $id ";
$result = mysql_query($query);
check_mysql();
$row = mysql_fetch_row($result);
check_mysql();
if ($row[0] > 0)
{
$id = $row[0];
$opis = $row[1];
$od = $row[2];
$do = $row[3];
}
}
$id = trim($id);
$opis = trim($opis);
$od = trim($od);
$do = trim($do);
?>
<table cols=2>
<tr>
<td><b>id (K) : </b></td>
<td><INPUT TYPE="TEXT" NAME="id" <?php echo "VALUE=\"$id\"" ?> ></td>
</tr>
<tr>
<td><b>opis (S) : </b></td>
<td><INPUT TYPE="TEXT" NAME="opis" <?php echo "VALUE=\"$opis\"" ?> ></td>
</tr>
<tr>
<td><b>od : </b></td>
<td><INPUT TYPE="TEXT" NAME="od" <?php echo "VALUE=\"$od\"" ?> ></td>
</tr>
<tr>
<td><b>do : </b></td>
<td><INPUT TYPE="TEXT" NAME="do" <?php echo "VALUE=\"$do\"" ?> ></td>
</tr>
</table>
<BR>
<INPUT TYPE="SUBMIT" NAME="left" VALUE="< (Prev)">
<INPUT TYPE="SUBMIT" NAME="right" VALUE="> (Next)">
<INPUT TYPE="SUBMIT" NAME="search" VALUE="Trazi (Search)">
<BR><BR>
<INPUT TYPE="SUBMIT" NAME="add" VALUE="Dodaj (Add)">
<INPUT TYPE="SUBMIT" NAME="update" VALUE="Izmena (Update)">
<INPUT TYPE="SUBMIT" NAME="delete" VALUE="Brisi (Delete)">
<INPUT TYPE="HIDDEN" NAME="id" <?php echo "VALUE=\"$id\"" ?> >
<?php
if (isset($message))
{
echo "<BR><BR>$message";
}
?>
</FORM>
</BODY>
</HTML>
<HTML>
<HEAD>
<TITLE>news edit</TITLE>
<link href="page.css" rel="stylesheet" type="text/css">
</HEAD>
<BODY>
<H2>TT_VESTI : EDIT  <a href="lnews.php"> LIST </a></H2>
<FORM METHOD="POST" ACTION="enews.php" >
<?php
$id = $_REQUEST['id']; <<< da li ovo dobro ili treba drugacije?
?>
<?php
function check_mysql()
{
if (mysql_errno() > 0)
{
die("<BR> MySQL error " . mysql_errno() . ": " . mysql_error());
}
}
include "connect.php";
$db = mysql_connect( $dbhost, $dbuser, $dbpass );
if (!$db)
{
die("Failed to open connection to MySQL server.");
}
mysql_select_db( $dbbaza );
check_mysql();
if(!isset($id))
{
$id=0;
}
if (isset($left))
{
$query = "SELECT id, opis, od, do "
. "FROM tt_vesti "
. "WHERE id < $id "
. "ORDER BY id DESC ";
$result = mysql_query($query);
check_mysql();
$row = mysql_fetch_row($result);
check_mysql();
if ($row[0] > 0)
{
$id = $row[0];
$opis = $row[1];
$od = $row[2];
$do = $row[3];
}
}
elseif (isset($right))
{
$query = "SELECT id, opis, od, do "
. "FROM tt_vesti "
. "WHERE id > $id "
. "ORDER BY id ASC ";
$result = mysql_query($query);
check_mysql();
$row = mysql_fetch_row($result);
check_mysql();
if ($row[0] > 0)
{
$id = $row[0];
$opis = $row[1];
$od = $row[2];
$do = $row[3];
}
}
elseif (isset($search))
{
$id = 0;
$query = "SELECT id, opis, od, do "
. "FROM tt_vesti "
. "WHERE opis like '%$opis%' ";
$result = mysql_query($query);
check_mysql();
$row = mysql_fetch_row($result);
check_mysql();
if ($row[0] > 0)
{
$id = $row[0];
$opis = $row[1];
$od = $row[2];
$do = $row[3];
}
}
elseif (isset($add))
{
$query = "INSERT INTO tt_vesti "
. "( opis, od, do) VALUES ('$opis', '$od', '$do') ";
$result = mysql_query($query);
check_mysql();
$id = mysql_insert_id();
$message = "Record Added (id=$id)";
}
elseif (isset($update))
{
$query = "UPDATE tt_vesti SET opis='$opis', od='$od', do='$do' "
. "WHERE id = $id ";
$result = mysql_query($query);
check_mysql();
$message = "Record Updated (id=$id)";
}
elseif (isset($delete))
{
$query = "DELETE FROM tt_vesti WHERE id = $id ";
$result = mysql_query($query);
check_mysql();
$message = "Record Deleted (id=$id)";
}
elseif ($id != 0)
{
$query = "SELECT id, opis, od, do "
. "FROM tt_vesti "
. "WHERE id = $id ";
$result = mysql_query($query);
check_mysql();
$row = mysql_fetch_row($result);
check_mysql();
if ($row[0] > 0)
{
$id = $row[0];
$opis = $row[1];
$od = $row[2];
$do = $row[3];
}
}
$id = trim($id);
$opis = trim($opis);
$od = trim($od);
$do = trim($do);
?>
<table cols=2>
<tr>
<td><b>id (K) : </b></td>
<td><INPUT TYPE="TEXT" NAME="id" <?php echo "VALUE=\"$id\"" ?> ></td>
</tr>
<tr>
<td><b>opis (S) : </b></td>
<td><INPUT TYPE="TEXT" NAME="opis" <?php echo "VALUE=\"$opis\"" ?> ></td>
</tr>
<tr>
<td><b>od : </b></td>
<td><INPUT TYPE="TEXT" NAME="od" <?php echo "VALUE=\"$od\"" ?> ></td>
</tr>
<tr>
<td><b>do : </b></td>
<td><INPUT TYPE="TEXT" NAME="do" <?php echo "VALUE=\"$do\"" ?> ></td>
</tr>
</table>
<BR>
<INPUT TYPE="SUBMIT" NAME="left" VALUE="< (Prev)">
<INPUT TYPE="SUBMIT" NAME="right" VALUE="> (Next)">
<INPUT TYPE="SUBMIT" NAME="search" VALUE="Trazi (Search)">
<BR><BR>
<INPUT TYPE="SUBMIT" NAME="add" VALUE="Dodaj (Add)">
<INPUT TYPE="SUBMIT" NAME="update" VALUE="Izmena (Update)">
<INPUT TYPE="SUBMIT" NAME="delete" VALUE="Brisi (Delete)">
<INPUT TYPE="HIDDEN" NAME="id" <?php echo "VALUE=\"$id\"" ?> >
<?php
if (isset($message))
{
echo "<BR><BR>$message";
}
?>
</FORM>
</BODY>
</HTML>
Mislim da ne moze jednostavnije i to negde radi, a ovde nece. Sta treba podesiti?
Hvala
Pomozite Micro$oftu u borbi protiv piraterije, poklonite prijatelju Linux