kako se prenose parametri?

[ dragancesu @ 27.04.2007. 16:53 ] @

Nije da nisam procitao i uradio ali me sada izludjuje da ne radi na verat-u. U svari na jednoj prezentaciji radi, a na drugoj ne. Ono gde "guta" sve je hosting1 i php 4.4.4 , a kod druga je na hosting3.verat.net i php 4.3.9 (podaci koje pkazuje phpinfo)

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>

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 &nbsp<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