Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4
  1. #1
    Senior Coder
    Join Date
    Aug 2005
    Posts
    1,119
    Thanks
    2
    Thanked 1 Time in 1 Post

    getting a form to work in itself?

    im using this code:

    PHP Code:
    <?php 

    if( !isset($_SESSION['login_username'])){
    header("Location: index.php?act=admin");
    } else {
    $_SESSION['login_username'] = $username;
    mysql_connect ($dbhost$dbusername$dbuserpass);
    mysql_select_db($dbname) or die(mysql_error());
    $query "SELECT * FROM $tuttable WHERE onoff='0' ORDER BY id DESC";
    $result mysql_query($query) or die(mysql_error());
    while (
    $row mysql_fetch_array($result)) {
     echo 
    "<table style=\"clear: both;\">
        <form action=\"#\" method=\"post\">
            <tr>
                <td rowspan=\"2\">
                    <img width=\"40\" height=\"40\" alt=\"preview\" src=\""
    .$row['image']."\" />
                </td>
                <td align=\"center\">
                    Title: <input type=\"text\" name=\"name\" value=\""
    .$row['title']."\" />
                </td>
                <td align=\"center\">
                    Author: <input type=\"text\" name=\"authorname\" value=\""
    .$row['author']."\" />
                </td>
                <td align=\"center\">
                    Tut-URL: <input type=\"text\" name=\"loca\" value=\"viewtut.php?id="
    .$row['id']."\" />
                </td>
                <td align=\"center\" rowspan=\"2\" colspan=\"2\">
                    <select name=\"approve\" id=\"approve\">
                    <option value=\"3\" selected=\"selected\">Edit</option>
                    <option value=\"1\">Approve</option>
                    <option value=\"0\">Leave as is</option>
                    <option value=\"2\">Delete</option>
                    </select>
                    <br />
                    <input type=\"hidden\" name=\"idnum\" value=\""
    .$row['id']."\" />
                    <input type=\"submit\" class=\"submit\" value=\"Go\" />
                    <br />
                    <input type=\"reset\" class=\"submit\" value=\"Reset\" />
                </td>
            </tr>
            <tr>
                <td colspan=\"1\">
                    <textarea name=\"descrip\">"
    .$row['descr']."</textarea>
                </td>
                <td align=\"center\">
                    <input type=\"radio\" name=\"cat\" value=\"Photoshop\" checked/> Photoshop<br />
                    <input type=\"radio\" name=\"cat\" value=\"PHP\" /> PHP<br />
                    <input type=\"radio\" name=\"cat\" value=\"PSP\" /> PSP<br />
                    <input type=\"radio\" name=\"cat\" value=\"PSE\" /> PSE<br />
                </td>
            </tr>
            <tr>
                <td colspan=\"7\">
                    Preview Location: 
                    <input type=\"text\" value=\""
    .$row['image']."\" name=\"preview\" size=\"55\" />
                </td>
            </tr>
        </form>
    </table>"
    ;
    }
    if (
    $_POST['approve'] == 1) {
         
    // SQL to update row to be active
    } else if ($_POST['approve'] == 2) {
         
    // SQL to delete row
    }  else if ($_POST['approve'] == 3) {
         
    // SQL to update row
         
    $update "UPDATE $tuttable = WHERE ".$row['image']."=".$row['image']."";
        
    mysql_query($update);
    }  
    }
    ?>
    and if i click edit then go, it sends me back to the login form. Also, i don't think my sql for the update is correct. Can anyone fix this form?

  • #2
    Regular Coder
    Join Date
    May 2004
    Posts
    144
    Thanks
    0
    Thanked 0 Times in 0 Posts
    your using session vars but the code doesnt start a session.
    PHP Code:
    <?php
    session_start
    ();
    also, are you using the form name for the the action or the # symbol?
    PHP Code:
     <form action="#\" method=\"post\"> 
    i would try using the actual filename it's submitting to for testing.

    i would also try
    PHP Code:
    if (isset($_POST[submit])){
    if (
    $_POST['approve'] == 1) {
         
    // SQL to update row to be active
    } else if ($_POST['approve'] == 2) {
         
    // SQL to delete row
    }  else if ($_POST['approve'] == 3) {
         
    // SQL to update row
         
    $update "UPDATE $tuttable = WHERE ".$row['image']."=".$row['image']."";
        
    mysql_query($update);
    }   


    good luck
    Last edited by ClubCosmic; 01-06-2006 at 02:05 AM.

  • #3
    Senior Coder
    Join Date
    Aug 2005
    Posts
    1,119
    Thanks
    2
    Thanked 1 Time in 1 Post
    this is being included in a page that does use session_start()

  • #4
    Senior Coder
    Join Date
    Aug 2005
    Posts
    1,119
    Thanks
    2
    Thanked 1 Time in 1 Post
    *bump*


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •