$_POST[""] does not work...

[aznjay]

 

http://alltraxx.uni.cc/admin/test2.php

<form action="editlinks.php" method="post">
<select name="base">
<option value="ps">Photoshop</option>
<option value="phptut">Php Tutorial</option>
</select>
<input type="submit" name="table" value="submit">
</form>

 

http://alltraxx.uni.cc/admin/editlinks.php

<? include ("database.php");?>
<?
$tabs = $_POST["base"];

   //display all the news
   $result = mysql_query("select * from $tabs order by id"); 
   
   //run the while loop that grabs all the news scripts
   while($r=mysql_fetch_array($result)) 
   { 

      //grab the title and the ID of the news
      $title=$r["title"];//take out the title
      $id=$r["id"];//take out the id
      $rob=$r["id"];//take out the id
 //make the title a link
      echo "<a href='editlinks.php?cmd=edit&id=$id'>$title - Edit</a> | ";
      echo "<a href='editlinks.php?cmd=delete&id=$rob'>DELETE</a>";
      echo "<br>";
    }
?>
<?
if($_GET["cmd"]=="edit" || $_POST["cmd"]=="edit")
{
   if (!isset($_POST["submit"]))
   {
      $id = $_GET["id"];
  $tabs = $_POST["base"];
      $sql = "SELECT * FROM $tabs WHERE id=$id";
      $result = mysql_query($sql);        
      $myrow = mysql_fetch_array($result);

      ?>
  
      <form method="post">
      <input type=hidden name="id" value="<?php echo $myrow["id"] ?>">

      Title:<INPUT TYPE="TEXT" NAME="title" VALUE="<?php echo $myrow["head"] ?>" SIZE=30><br>
      Name:<INPUT TYPE="TEXT" NAME="who" VALUE="<?php echo $myrow["name"] ?>" SIZE=30><br>
      Time:<INPUT TYPE="TEXT" NAME="who" VALUE="<? echo date("g:i a"); ?>" SIZE=30><br>
      Date:<INPUT TYPE="TEXT" NAME="who" VALUE="<? echo date("M.j.y"); ?>" SIZE=30><br>
      Message:<br><TEXTAREA NAME="message" ROWS=15 COLS=40><? echo $myrow["msg"] ?></TEXTAREA><br>

   
      <input type="hidden" name="cmd" value="edit">
   
      <input type="submit" name="submit" value="submit">
   
      </form>
   
<? } 
}?>

 

 

 

The $tabs doesn't carry through out the page.. and i'm getting this error..I don't know how to fix it

 

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/jayjay/public_html/admin/editlinks.php on line 9

 

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/jayjay/public_html/admin/editlinks.php on line 31

 

I'm getting this error because of the $tabs

 

[Adam]

Try echo'in out $tabs and make sure its correct, and also change:

 

$result = mysql_query("select * from $tabs order by id");

 

to..

 

$result = mysql_query("select * from {$tabs} order by id") or die('MySQL Error: ' .mysql_error());

 

...then see what happens.

 

Adam

[aznjay]

Try echo'in out $tabs and make sure its correct, and also change:

 

$result = mysql_query("select * from $tabs order by id");

 

to..

 

$result = mysql_query("select * from {$tabs} order by id") or die('MySQL Error: ' .mysql_error());

 

...then see what happens.

 

Adam

 

It does not work...same error as the last time..

 

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/jayjay/public_html/admin/editlinks.php on line 9

 

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/jayjay/public_html/admin/editlinks.php on line 31

[wildteen88]

It is caused due to a logic error try

<?php
include "database.php"

if(isset($_POST['base']))
{
    $tabs = $_POST["base"];

   //display all the news
   $result = mysql_query("select * from $tabs order by id");

   //run the while loop that grabs all the news scripts
   while($r = mysql_fetch_array($result))
   {
      //grab the title and the ID of the news
      $title=$r["title"];//take out the title
      $id=$r["id"];//take out the id
      $rob=$r["id"];//take out the id
 //make the title a link
      echo "<a href='editlinks.php?cmd=edit&id=$id&base=$tabs'>$title - Edit</a> | ";
      echo "<a href='editlinks.php?cmd=delete&id=$rob&base=$tabs'>DELETE</a>";
      echo "<br>";
    }
}
elseif(isset($_REQUEST["cmd"]) && $_REQUEST["cmd"] == "edit")
{
   if (!isset($_POST["submit"]))
   {
      $id = $_GET["id"];
  $tabs = $_GET["base"];
      $sql = "SELECT * FROM $tabs WHERE id=$id";
      $result = mysql_query($sql);
      $myrow = mysql_fetch_array($result);
?>
      <form method="post">
      <input type=hidden name="id" value="<?php echo $myrow["id"] ?>">

      Title:<INPUT TYPE="TEXT" NAME="title" VALUE="<?php echo $myrow["head"] ?>" SIZE=30><br>
      Name:<INPUT TYPE="TEXT" NAME="name" VALUE="<?php echo $myrow["name"] ?>" SIZE=30><br>
      Time:<INPUT TYPE="TEXT" NAME="time" VALUE="<? echo date("g:i a"); ?>" SIZE=30><br>
      Date:<INPUT TYPE="TEXT" NAME="date" VALUE="<? echo date("M.j.y"); ?>" SIZE=30><br>
      Message:<br><TEXTAREA NAME="message" ROWS=15 COLS=40><? echo $myrow["msg"] ?></TEXTAREA><br>


      <input type="hidden" name="cmd" value="edit">
      <input type="hidden" name="base" value="<?php echo $base; ?>">

      <input type="submit" name="submit" value="submit">

      </form>
<?php
    }
    else
    {
        echo '<pre>' . print_r($_POST, true) . '</pre>';
    }
}
?>

[aznjay]

It is caused due to a logic error try

<?php
include "database.php"

if(isset($_POST['base']))
{
    $tabs = $_POST["base"];

   //display all the news
   $result = mysql_query("select * from $tabs order by id");

   //run the while loop that grabs all the news scripts
   while($r = mysql_fetch_array($result))
   {
      //grab the title and the ID of the news
      $title=$r["title"];//take out the title
      $id=$r["id"];//take out the id
      $rob=$r["id"];//take out the id
 //make the title a link
      echo "<a href='editlinks.php?cmd=edit&id=$id&base=$tabs'>$title - Edit</a> | ";
      echo "<a href='editlinks.php?cmd=delete&id=$rob&base=$tabs'>DELETE</a>";
      echo "<br>";
    }
}
elseif(isset($_REQUEST["cmd"]) && $_REQUEST["cmd"] == "edit")
{
   if (!isset($_POST["submit"]))
   {
      $id = $_GET["id"];
  $tabs = $_GET["base"];
      $sql = "SELECT * FROM $tabs WHERE id=$id";
      $result = mysql_query($sql);
      $myrow = mysql_fetch_array($result);
?>
      <form method="post">
      <input type=hidden name="id" value="<?php echo $myrow["id"] ?>">

      Title:<INPUT TYPE="TEXT" NAME="title" VALUE="<?php echo $myrow["head"] ?>" SIZE=30><br>
      Name:<INPUT TYPE="TEXT" NAME="name" VALUE="<?php echo $myrow["name"] ?>" SIZE=30><br>
      Time:<INPUT TYPE="TEXT" NAME="time" VALUE="<? echo date("g:i a"); ?>" SIZE=30><br>
      Date:<INPUT TYPE="TEXT" NAME="date" VALUE="<? echo date("M.j.y"); ?>" SIZE=30><br>
      Message:<br><TEXTAREA NAME="message" ROWS=15 COLS=40><? echo $myrow["msg"] ?></TEXTAREA><br>


      <input type="hidden" name="cmd" value="edit">
      <input type="hidden" name="base" value="<?php echo $base; ?>">

      <input type="submit" name="submit" value="submit">

      </form>
<?php
    }
    else
    {
        echo '<pre>' . print_r($_POST, true) . '</pre>';
    }
}
?>

 

 

I got this error :Parse error: syntax error, unexpected T_IF in /home/jayjay/public_html/admin/editlinks.php on line 4

[DarkWater]

Missed a ; on the first line of code.

[wildteen88]

Woops, add a semi-colon ( ; ) at the end of this line

include "database.php"

[aznjay]

Woops, add a semi-colon ( ; ) at the end of this line

include "database.php"

 

There is still a problem when ever I click to edit the...The information doesn't load in the forms...

[aznjay]

    $ids = $_GET["id"];
  $tabsl = $_GET["base"];
      $sql = "SELECT * FROM phptut WHERE id=14";
      $result = mysql_query($sql);
      $myrow = mysql_fetch_assoc($result);

?>
      <form method="post">
      <input type=hidden name="id" value="<?php echo $myrow["id"] ?>">

      Title:<INPUT TYPE="TEXT" NAME="title" VALUE="<?php echo $myrow["head"] ?>" SIZE=30><br>
      Name:<INPUT TYPE="TEXT" NAME="name" VALUE="<?php echo $myrow["name"] ?>" SIZE=30><br>
      Time:<INPUT TYPE="TEXT" NAME="time" VALUE="<? echo date("g:i a"); ?>" SIZE=30><br>
      Date:<INPUT TYPE="TEXT" NAME="date" VALUE="<? echo date("M.j.y"); ?>" SIZE=30><br>
      Message:<br><TEXTAREA NAME="message" ROWS=15 COLS=40><? echo $myrow["msg"] ?></TEXTAREA><br>


      <input type="hidden" name="cmd" value="edit">
      <input type="hidden" name="base" value="<?php echo $base; ?>">

      <input type="submit" name="submit" value="submit">

      </form>
<?php
    }
    else
    {
        echo '<pre>' . print_r($_POST, true) . '</pre>';
    }
}
?>

On this part of the code, it doesn't show any data.. in the forms.. what's wrong with it??

[aznjay]

BUMP!!!

[Minase]

explain me what you want to do,i cant understand your last post too good

[Adam]

try to find some errors...

 

for example on querys like:

 

$result = mysql_query($sql);

 

add:

 

$result = mysql_query($sql) or die('MySQL Error: ' .mysql_error());

 

Also echo out your inputs to make sure they're valid..

 

$ids = $_GET["id"];
$tabsl = $_GET["base"];

die('INPUTS: ' .$ids. ' ... ' .$tabsl);

 

You may also want to make sure there's actually a record being retrieved from the database:

 

$result = mysql_query($sql);

if (mysql_num_rows($result) == 0) {
    print 'No record found!';
} else {
    $myrow = mysql_fetch_assoc($result);

    // print out form

}

 

Your codes very minimal at the minute..

 

Adam

[aznjay]

try to find some errors...

 

for example on querys like:

 

$result = mysql_query($sql);

 

add:

 

$result = mysql_query($sql) or die('MySQL Error: ' .mysql_error());

 

Also echo out your inputs to make sure they're valid..

 

$ids = $_GET["id"];
$tabsl = $_GET["base"];

die('INPUTS: ' .$ids. ' ... ' .$tabsl);

 

You may also want to make sure there's actually a record being retrieved from the database:

 

$result = mysql_query($sql);

if (mysql_num_rows($result) == 0) {
    print 'No record found!';
} else {
    $myrow = mysql_fetch_assoc($result);

    // print out form

}

 

Your codes very minimal at the minute..

 

Adam

 

Thank you for that but i've tried all of that and it doesn't fix it still... i tried to echo it... it shows the table and the id, but it's not getting the data from SQL

[aznjay]

bump!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

[aznjay]

elseif(isset($_REQUEST["cmd"]) && $_REQUEST["cmd"] == "edit")
{
   if (!isset($_POST["submit"]))
   {
      $ids = $_GET["id"];
  $tabsl = $_GET["base"];
      $sql = "SELECT * FROM $tabsl WHERE id=$ids";
  $result = mysql_query($sql) or die('MySQL Error: ' .mysql_error());
      $myrow = mysql_fetch_array($result);

?>
      <form method="post">
      <input type=hidden name="id" value="<?php echo $myrow["id"]; ?>">

      Title:<INPUT TYPE="TEXT" NAME="right" VALUE="<?php echo $myrow["title"]; ?>" SIZE=30><br>
      Description:<INPUT TYPE="TEXT" NAME="left" VALUE="<?php echo $myrow["desp"]; ?>" SIZE=30><br>
      Time:<INPUT TYPE="TEXT" NAME="up" VALUE="<? echo date("g:i a"); ?>" SIZE=30><br>
      Date:<INPUT TYPE="TEXT" NAME="down" VALUE="<? echo date("M.j.y"); ?>" SIZE=30><br>
      Article:<br><TEXTAREA NAME="side" ROWS=15 COLS=40><? echo $myrow["article"] ?></TEXTAREA><br>




      <input type="submit" name="update" value="submit">
      </form>
<?php
    }


elseif ($_POST["update"])
{
if (!isset($_POST["update"]))
{
echo '<meta http-equiv="refresh" content="1;url=editlinks.php">';
      $id = $_POST["id"];
      $title = $_POST["right"];
      $tme = $_POST["left"];
      $dte = $_POST["down"];
  $message = $_POST["side"];

  
  $tabsl = $_GET["base"];
  $sql = "UPDATE $tabsl SET title='$title',time='$tme',date='$dte',article='$message', WHERE id=$id";
      //replace news with your table name above
      $result = mysql_query($sql);
}
}

    else
    {
        echo '<pre>' . print_r($_POST, true) . '</pre>';
    }
}
?>

 

Okay everything works...but now i'm adding an update command but why won't it UPDATE...

[CroNiX]

Its not good to mix <? and <?php.  You should always just use <?php so change the others to that.  Dont know if thats the problem, but a suggestion.

[wildteen88]

Fixed your code,

<?php
include "database.php";

if(isset($_POST['base']))
{
    $tabs = $_POST["base"];

    //display all the news
    $result = mysql_query("SELECY * FROM $tabs ORDER BY id");

    //run the while loop that grabs all the news scripts
    while($r = mysql_fetch_array($result))
    {
        //grab the title and the ID of the news
        $title = $r["title"];//take out the title
        $id = $r["id"];//take out the id
        $rob = $r["id"];//take out the id

        //make the title a link
        echo "<a href='editlinks.php?cmd=edit&id=$id&base=$tabs'>$title - Edit</a> | ";
        echo "<a href='editlinks.php?cmd=delete&id=$rob&base=$tabs'>DELETE</a>";
        echo "<br>";
    }
}
elseif(isset($_REQUEST["cmd"]) && $_REQUEST["cmd"] == "edit")
{
    // perform the following when the form below is submitted
    if(isset($_POST['edit_update']))
    {
        $id = $_POST["id"];
        $title = $_POST["title"];
        $time = $_POST["time"];
        $date = $_POST["date"];
        $message = $_POST["message"];

        $tabs = $_POST["base"];

        $sql = "UPDATE $tabs SET title='$title',time='$time',date='$date',article='$message', WHERE id=$id";

        $result = mysql_query($sql) or die(mysql_error());

        echo 'Table `'.$tabs.'` updated!';
    }
    // form hasn't been submitted yet, display edit form
    else
    {
        $id = $_GET["id"];
    	$tabs = $_GET["base"];
        $sql = "SELECT * FROM $tabs WHERE id=$id";
        $result = mysql_query($sql);
        $myrow = mysql_fetch_array($result);
?>
      <form method="post">
      <input type=hidden name="id" value="<?php echo $myrow["id"] ?>">

      Title:<INPUT TYPE="TEXT" NAME="title" VALUE="<?php echo $myrow["head"] ?>" SIZE=30><br>
      Name:<INPUT TYPE="TEXT" NAME="name" VALUE="<?php echo $myrow["name"] ?>" SIZE=30><br>
      Time:<INPUT TYPE="TEXT" NAME="time" VALUE="<?php echo date("g:i a"); ?>" SIZE=30><br>
      Date:<INPUT TYPE="TEXT" NAME="date" VALUE="<?php echo date("M.j.y"); ?>" SIZE=30><br>
      Message:<br><TEXTAREA NAME="message" ROWS=15 COLS=40><?php echo $myrow["msg"] ?></TEXTAREA><br>

      <input type="hidden" name="cmd" value="edit">
      <input type="hidden" name="base" value="<?php echo $base; ?>">

      <input type="submit" name="edit_update" value="submit">

      </form>
<?php
    }
}
elseif(isset($_REQUEST["cmd"]) && $_REQUEST["cmd"] == "delete")
{
    echo 'Perform delete action here';
}
?>