insert statement has me stumped.

[nmphpwebdev]

I have this insert statment:

<?php

$content_title = 'Home Page Administration';
$page_title = 'Index Page Options';

include( '../includes/subheader.php' );
include_once( '../includes/dbconnect.php' );

if( isset( $_POST['action'] ) == 'Submit Info' )
    { //Handle the form

// Create a function for escaping the data.
function escape_data ($data) {
         // Need the connection.
                global $dbc;
                if (ini_get('magic_quotes_gpc')) {
                    $data = stripslashes($data);
                }
                return mysql_real_escape_string($data);
        } // End of function.

//Create a blank variable
$message = NULL;

//Check for content title
if( empty( $_POST['title'] ))
    {
         $t = FALSE;
         $message .= "<p><font color=\"red\">You need to title your post</font></p>";
    } else {
            $t = escape_data( $_POST['title'] );
            }

//Check for content to be submitted.
if( empty( $_POST['content'] )) {
        $c = FALSE;
        $message .="<p><font color=\"red\">You can\'t display a blank home page!!</font></p>";
        } else {
                $c = escape_date( $_POST['content'] );
                }

//Check for an image to be posted.
if( empty( $_POST['img'] )) {
     $i = FALSE;
     $message .="<p><font color=\"red\">You can\'t have a missing image</font></p>";
     } else {
     $i = $_POST['img'];
             }

//Check for img description
if( empty( $_POST['imgdesc'] )) {
        $imgdesc = FALSE;
        $message .="<p><font color=\"red\">We need a description for this image!!</font></p>";
        } else {
                $imgdesc = escape_data( $_POST['imgdesc'] );
                }

//Check for date to display
if( empty( $_POST['datetodisplay'] )) {
        $dm = FALSE;
        $message .= "<p><font color=\"red\">When do you want this to display?</font></p>";
        } else {
                $dm = $_POST['datetodisplay'];
                }
if( $t && $c && $i && $imgdesc && $dm )
    {
             $sql = "INSERT INTO indexpage
             ( id, title, content, datemod, img, imgdesc, datetodisplay )
             VALUES
             ( '', '$t', '$c', now(), '$i', '$imgdesc', '$dm' )";
              //$result = mysql_query( $sql );

          $result = mysql_query($sql) or die ("INSERT INTO DATABASE FAILED: ".mysql_error());

        }
//Print the messge if there is one
if( isset( $message )) {
        echo '<font color=\"red\">' . $message . '</font>';
        }
    }
?>

I am not able to send the post variables to the database, its not giving my red messages for missing fields, nothing.

Any ideas??

[dnoonan]

need more info... do you get an error message? i.e. does the insert fail and your script dies - what is the mysql error?

If not what gets inserted into the db?

Try doing a "print $sql;" before the execution and post the sql here as well.

[nmphpwebdev]

Unfortunately....I am not getting any kind of errors.

I have tried to print the sql statement and nothing is displayed in the browser.

the url to my page is

http://cahedev.nmsu.edu/steve/admin/adminhome.php

[noodles101]

your name for your Date input tag is "datemod" in your form , your looking for "datetodisplay" in your script so your insert statment will never get run.

Noods...

 <table width="100%">
        <tr>
            <td>Title your post<br /><small>IE. The date of the post</small></td>
            <td><input type="text" name="title" /></td>
        </tr>
        <tr>
            <td valign="top">Enter content to be displayed on home page:</td>
            <td><textarea cols="25" rows="10" name="content"></textarea></td>
            </tr>
        <tr>
            <td>Is there an image to be displayed?</td>
            <td><input type="file" name="img" /></td>
         </tr>
         <tr>
             <td>Image description<br /><small>What will be printed for the "ALT" tag</small></td>
             <td><input type="text" name="imgdesc" /></td>
         </tr>
         <tr>
             <td>Date to display as home page</td>
             <td><input type="text" name="datemod" /></td>
         </tr>
         <tr align="left">
             <td colspan="2">New Record Inserted: -1
</td>
             </tr>
            <tr>
                <td colspan="2">
                    <div align="center"><input type="submit" name"action" value="Submit Info" /></div>
            </td>
        </tr>
    </table>
 </form>

[nmphpwebdev]

thanks for the eye ball.

i changed the date name to datetodisplay and still a no go.....

I am on the verge of rewritting the script.
I may have missed something small...a tick, a semi colon...i don't know..but i am purley frustrated.

[noodles101]

try outputting the SQL statment before your IF statement.
just to see if its a problem with your IF

IF the statement looks ok, copy and paste it into your MYSQL query tool and see if it runs ok.

if it does... i'm lost....🙂

$sql = "INSERT INTO indexpage 
             ( id, title, content, datemod, img, imgdesc, datetodisplay ) 
             VALUES 
             ( '', '$t', '$c', now(), '$i', '$imgdesc', '$dm' )"; 
print sql;
if( $t && $c && $i && $imgdesc && $dm ) 
    { 
             $sql = "INSERT INTO indexpage 
             ( id, title, content, datemod, img, imgdesc, datetodisplay ) 
             VALUES 
             ( '', '$t', '$c', now(), '$i', '$imgdesc', '$dm' )"; 
              //$result = mysql_query( $sql ); 

          $result = mysql_query($sql) or die ("INSERT INTO DATABASE FAILED: ".mysql_error()); 

        }