Include Error

[Titan85]

Hello, I am having an issue getting my script to include a file if it finds a certain action specified ($_GET['act'] == "whatever"). I have used this many times before but for some reason this one is not working and I can't figure out why. I am sure it is something stupid, but just can't find it. Here is the code:

<?php

// If no action is selected
if(!$_GET['act']) {
    
    // Get coupons
    $sql = "SELECT * FROM `coupons` ORDER BY id DESC";
    $qry = mysql_query($sql) or die ('Error Getting Coupons! <br />' .mysql_error());
    $count = mysql_num_rows($qry);
    
    
    // If no results
    if($count < 1) {
        echo '
        There are no coupons at this time.
        ';
    }
    
        // Get words
            if($count == 1) {
                $are = "is";
                $coupon = "coupon";
            } else {
                $are = "are";
                $coupon = "coupons";
            }
            
    // If there are results
    if($count >= 1) {
    
        // Tell how many coupons
        echo "
            There $are <i>$count</i> current $coupon.
        ";
        
            // Row colors
            $counter = 1;
                $color = "#EEEEEE";
    
        // Start Table
        echo '
<!-- Coupon Management Table -->
            <form method="post" action="">
                <table width="100%">
                    <tr>
                        <td class="table"><b>ID</b></td>
                        <td class="table"><b>Name</b></td>
                        <td class="table"><b>Date</b></td>
                        <td class="table"><b>Delete</b></td>
                        <td class="table"><b>Edit</b></td>
                    </tr>';
                    
        // For each coupon found
        while($c = mysql_fetch_array($qry)) {
            echo '
                    <tr style="background-color: '.$color.'">
                        <td class="table">'.$c['id'].'</td>
                        <td class="table"><a href="?act=view&id='.$c['id'].'">'.$c['title'].'</a></td>
                        <td class="table">'.$c['date'].'</td>
                         <td class="table"><input type="checkbox" name="checkbox[]" value="'.$c['id'].'" /></td>
                        <td class="table"><a href="?act=edit&id='.$c['id'].'"><img src="../images/edit.png" border="0" alt="" /></a></td>
                    </tr>';
                    
                // Get row color
                ++$counter;
                if($color == "#EEEEEE") {
                    $color = "#CCCCCC";
                } else {
                    $color = "#EEEEEE";
                }
        }
        
        // End table/form and echo submit button
            echo '
                    <tr>
                        <td colspan="5"><div align="right"><input type="submit" name="delete" value="Delete Selected" /></div></td>
                    </tr>
                </table>
            </form>
<!-- /Coupon Management Table -->';
    }
}

// If delete was hit
if($delete) {
    for($i=0;$i<$count;$i++) {
        $del_id = $checkbox[$i];
        $sql = "DELETE FROM `coupons` WHERE id = '$del_id'";
        $result1 = mysql_query($sql) or die ('Error Deleting Coupons! <br />' .mysql_error());
    }
}

// If delete worked
if($result1) {
    echo '
    <meta http-equiv="refresh" content="2;URL=index.php" />
    ';
    
    echo 'The selected coupons have been deleted.
    ';
}

// If edit was hit
if($_GET['act'] == "edit") {
    require('edit.php');
}

// If view was hit
if($_GET['act'] == "view") {
    require('view.php');
}

?>

Even if I delete the file I say to include, I do not get the "does not exist" error that I should, so it is definitely just not including it. The url does indeed have index.php?act=whatever in it. Hope someone sees the problem, thanks.

[mburt]

Try using include "edit.php" and include "view.php" instead, whereas if you use require it may produce a fatal warning error.

[Titan85]

Try using include "edit.php" and include "view.php" instead, whereas if you use require it may produce a fatal warning error.

Well, it has worked on about 10 other scripts I have made without an issue, but for some reason this one is causing problems

[thetestingsite]

The code works for me (in the aspect of the include/require section). If I go to test.php?act=edit, it gives me this error:

Fatal error: main() [function.require]: Failed opening required 'edit.php' (include_path='.;C:\php5\pear') in J:\****\****\test.php on line 105

Same with act=view. Can you post a link to your page (or pm it) so that we can take a look to see what's going on with it.

[Titan85]

The code works for me (in the aspect of the include/require section). If I go to test.php?act=edit, it gives me this error:



Same with act=view. Can you post a link to your page (or pm it) so that we can take a look to see what's going on with it.

The script is password protected and for some really odd reason I can't get it to add another user. I am going to rewrite the code and see if it works, if not, I will give you the login info

[thetestingsite]

Let me know what happens and if you need any more help.

[Titan85]

Let me know what happens and if you need any more help.

I redid it and its no good. I even used the code from a script that is working, but yet it won't work. I still can't seem to get another login to work. I have to take a step back for a bit and come back fresh.

[thetestingsite]

Have you just tried to make a new page with just an include/require in it just to see if it is something in the script or something on the server?

[Titan85]

I found the problem, it was that my link to include the edit page was "index.php?act=edit&id=id", but I had the "if($_GET['act'] == "edit")" code on my manage.php page. Simple error that messed everything up. Thanks for all the help testingsite, I really appreciate it