Unknown column 'image'

Question

davy_yg 2 Posting Whiz

10 Years Ago

When I try to save the form this error appears:

Unknown column 'image' in 'field list'

Also location & description remains empty. Why is it?

input_image.php

<?php

    include('../includes/koneksi.php');

    $id = isset($_POST['id']) ? $_POST['id'] : '';  
    $confirmation = isset($_POST['confirmation']) ? $_POST['confirmation'] : '';  
    $productname = isset($_POST['productname']) ? $_POST['productname'] : ''; 
    $location = isset($_POST['location']) ? $_POST['location'] : '';
    $description = isset($_POST['description']) ? $_POST['description'] : '';
    $urlimages = isset($_POST['urlimages']) ? $_POST['urlimages'] : '';


    //Load berita
    if (!empty($_REQUEST['id'])){
        $result = mysql_query("SELECT * FROM gallery WHERE id =".$_REQUEST['id']) or die(mysql_error());
        $data = mysql_fetch_array($result);
        $id = $data['id'];
        $productname = $data['productname'];
        $location = $data['location'];
        $description = $data['description'];
        $urlimages = $data['urlimages'];

    }

    //Simpan berita 
    if (isset($_REQUEST['ok'])){

        if (empty($_REQUEST['id']))
            $sqlstr = "INSERT INTO gallery(productname, location, description, urlimages) VALUES('".$productname."','".$location."','".$description."','".urlimages."')";
        else
            $sqlstr = "UPDATE gallery SET productname='".$productname."', image='".$location."', description='".$description."', urlimages='".$urlimages."' WHERE id=".$_REQUEST['id'];
        $result = mysql_query($sqlstr) or die(mysql_error());

        //Jika mode edit, maka tidak akan dikirimkan konfirmasi kepada subscriber
        //if (empty($_REQUEST['id']))   kirimEmail($idKategori, $judul, $news);
        $confirmation = ($result) ? "Data telah tersimpan." : "Gagal menyimpan data.";  
    }
    ?>
    <div align="center">
        <div style="width:800px;text-align:left;">
        <script type="text/javascript" src="../../Masterlink/cgoods/ckeditor/ckeditor.js"></script>
        <link href="../../Masterlink/cgoods/ckeditor/content.css" rel="stylesheet" type="text/css"/>
        <?php echo $confirmation;?>
        <form method="post" action="<?php echo $_SERVER['PHP_SELF']?>">
            <input type="hidden" name="id" value="<?php echo $id; ?>"/>
            <table>
                <tr>
                    <td>Product Name : </td>
                    <td><input size="30px" type="text" name="productname" value="<?php echo $productname; ?>"/></td>
                </tr>
                <tr>
                    <td>Location :</td>
                    <td><select name="location">
                    <option value="pic1">pic1</option>
                    <option value="pic2">pic2</option>
                    <option value="pic3">pic3</option>
                    <option value="pic4">pic4</option>
                    <option value="pic5">pic5</option>
                    <option value="pic6">pic6</option>
                    <option value="pic7">pic7</option>
                    <option value="pic8">pic8</option>
                    </select></td>
                </tr>
                <tr>
                    <td>Description : </td>
                    <td><textarea rows="4" cols="50"/>

php

6 Contributors
19 Replies
291 Views
3 Days Discussion Span
Latest Post 10 Years Ago Latest Post by TonyG_cyprus

All 19 Replies

Squidge 101 Newbie Poster

10 Years Ago

When uploading files you also need to declare a "enctype".

Also please show the full error, and the lines of code it will refer to

radhakrishna.p 29 Posting Whiz in Training

10 Years Ago

hai davy_yg,

in addtion to the above responses,please consider this one

while you inserting data into galley table your sql syntax is like as follows

INSERT INTO gallery(productname, location, description, urlimages).......

but while you updating the gallery table your sql is

UPDATE gallery SET productname='".$productname."', image='".$location."', description='".$description."', urlimages='".$urlimages."' WHERE id=".$_REQUEST['id'];

in update statement we found image column but not in insert statement

please check your gallery table structure once so that your problem will be solved

any comments are appreciated.....

Edited 10 Years Ago by radhakrishna.p because: giving clarity on the solution

TonyG_cyprus 36 Newbie Poster

10 Years Ago

  $sqlstr = "UPDATE gallery SET productname='".$productname."', image='".$location."', description='".$description."', urlimages='".$urlimages."' WHERE id=".$_REQUEST['id'];

You are making heavy work of this, and it's hard to understand, and there is a" missing at the end.

 $request=$_REQUEST['id'];
 $sqlstr = "UPDATE gallery SET productname='$productname', image='$location', description='$description', urlimages='$urlimages' WHERE id='$request' ";

would work better for me, and it's less to type and IMHO, easier to read and check.

Webville312 14 Newbie Poster

10 Years Ago

Also, when submitting your form, the tag should be

<form action="submit_form.php" method="POST" enctype="multipart/form-data">

That should work ...

TonyG_cyprus 36 Newbie Poster

10 Years Ago

@webville, innit funny how you can look at code for hours, and not spot a missing { !!

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

ivanichi 0 Light Poster · Answer 1 · 2013-04-29T09:51:48+00:00

check your image field, location field, and description field in your table

davy_yg 2 Posting Whiz · Answer 2 · 2013-04-30T02:35:28+00:00

that's the full error message - I also just declare enctype and the error still appears.

Webville312 14 Newbie Poster · Answer 3 · 2013-04-30T05:53:13+00:00

And also you have an error with this line;

VALUES('".$productname."','".$location."','".$description."','".urlimages."')";

I think, it should be;

VALUES('".$productname."','".$location."','".$description."','".$urlimages."')";

davy_yg 2 Posting Whiz · Answer 4 · 2013-04-30T08:21:47+00:00

ok, I do not see the error message any longer. It's just location & description remains empty even after I input the form.

input_image.php

//Simpan berita 
    if (isset($_REQUEST['ok'])){

        if (empty($_REQUEST['id']))
            $sqlstr = "INSERT INTO gallery(productname, location, description, urlimages) VALUES('".$productname."','".$location."','".$description."','".$urlimages."')";
        else
            $sqlstr = "UPDATE gallery SET productname='".$productname."', location='".$location."', description='".$description."', urlimages='".$urlimages."' WHERE id=".$_REQUEST['id'];
        $result = mysql_query($sqlstr) or die(mysql_error());

        //Jika mode edit, maka tidak akan dikirimkan konfirmasi kepada subscriber
        //if (empty($_REQUEST['id']))   kirimEmail($idKategori, $judul, $news);
        $confirmation = ($result) ? "Data telah tersimpan." : "Gagal menyimpan data.";  
    }
    ?>
    <div align="center">
        <div style="width:800px;text-align:left;">
        <script type="text/javascript" src="../../Masterlink/cgoods/ckeditor/ckeditor.js"></script>
        <link href="../../Masterlink/cgoods/ckeditor/content.css" rel="stylesheet" type="text/css"/>
        <?php echo $confirmation;?>
        <form method="post" enctype="multipart/form-data" action="<?php echo $_SERVER['PHP_SELF']?>">
            <input type="hidden" name="id" value="<?php echo $id; ?>"/>
            <table>
                <tr>
                    <td>Product Name : </td>
                    <td><input size="30px" type="text" name="productname" value="<?php echo $productname; ?>"/></td>
                </tr>
                <tr>
                    <td>Location :</td>
                    <td><select name="location">
                    <option value="pic1">pic1</option>
                    <option value="pic2">pic2</option>
                    <option value="pic3">pic3</option>
                    <option value="pic4">pic4</option>
                    <option value="pic5">pic5</option>
                    <option value="pic6">pic6</option>
                    <option value="pic7">pic7</option>
                    <option value="pic8">pic8</option>
                    </select></td>
                </tr>
                <tr>
                    <td>Description : </td>
                    <td><textarea rows="4" cols="50"/></textarea></td>
                </tr>
                <tr>
                    <td>Url Images: </td>
                    <td><input size="30px" type="text" name="judul" value="<?php echo $urlimages; ?>"/></td>                    
                </tr>
                    <td>Images: </td>
                    <td><input size="30px" type="file" name="image" value="<?php echo $image; ?>"/></td>
                <tr><?php // showing the picture ?>
                    <td><img src="photos/<?php echo $image; ?>"/></td>
                </tr>                
                <tr>             
                    <td><input type="submit" name="ok" value="Simpan"/></td>
              </tr>
            </table>
        </form>
        </div>
    </div>

Webville312 14 Newbie Poster · Answer 5 · 2013-04-30T09:18:56+00:00

What do you mean by

It's just location & description remains empty even after I input the form.

davy_yg 2 Posting Whiz · Answer 6 · 2013-04-30T10:12:12+00:00

In the table view:

Product Name    Location    Description Url Images  Action
wheatbread          urlimages   Hapus |Edit

Location & Description remains empty so does in the sql tables. I thought I already fill in in the form so that it fills with some text.

Webville312 14 Newbie Poster · Answer 7 · 2013-04-30T11:04:08+00:00

Aaaahh, ok ... Looking at your code, you need to specify what code to excecute. For instance, change

 if (empty($_REQUEST['id']))
            $sqlstr = "INSERT INTO gallery(productname, location, description, urlimages) VALUES('".$productname."','".$location."','".$description."','".$urlimages."')";
        else
            $sqlstr = "UPDATE gallery SET productname='".$productname."', location='".$location."', description='".$description."', urlimages='".$urlimages."' WHERE id=".$_REQUEST['id'];
        $result = mysql_query($sqlstr) or die(mysql_error());
        //Jika mode edit, maka tidak akan dikirimkan konfirmasi kepada subscriber
        //if (empty($_REQUEST['id']))   kirimEmail($idKategori, $judul, $news);
        $confirmation = ($result) ? "Data telah tersimpan." : "Gagal menyimpan data.";

TO

 if (empty($_REQUEST['id']))
 {
            $sqlstr = "INSERT INTO gallery(productname, location, description, urlimages) VALUES('".$productname."','".$location."','".$description."','".$urlimages."')";
            }
        else
        {
            $sqlstr = "UPDATE gallery SET productname='".$productname."', location='".$location."', description='".$description."', urlimages='".$urlimages."' WHERE id=".$_REQUEST['id'];
        $result = mysql_query($sqlstr) or die(mysql_error());
        //Jika mode edit, maka tidak akan dikirimkan konfirmasi kepada subscriber
        //if (empty($_REQUEST['id']))   kirimEmail($idKategori, $judul, $news);
        $confirmation = ($result) ? "Data telah tersimpan." : "Gagal menyimpan data.";  
        }

Webville312 14 Newbie Poster · Answer 8 · 2013-04-30T11:05:04+00:00

Try that and then let us know what the result will be ...

davy_yg 2 Posting Whiz · Answer 9 · 2013-05-01T04:12:24+00:00

I thought it suppose to be like this:

if (isset($_REQUEST['ok'])){

        if (empty($_REQUEST['id']))
            {
            $sqlstr = "INSERT INTO gallery(productname, location, description, urlimages) VALUES('".$productname."','".$location."','".$description."','".$urlimages."')";
            }
        else
            {
            $sqlstr = "UPDATE gallery SET productname='".$productname."', location='".$location."', description='".$description."', urlimages='".$urlimages."' WHERE id=".$_REQUEST['id'];
            }
        $result = mysql_query($sqlstr) or die(mysql_error());

        //Jika mode edit, maka tidak akan dikirimkan konfirmasi kepada subscriber
        //if (empty($_REQUEST['id']))   kirimEmail($idKategori, $judul, $news);
        $confirmation = ($result) ? "Data telah tersimpan." : "Gagal menyimpan data.";  
    }

Yet, I still wonder why location & description is empty. The previous solution that webville suggest does not work either.

TonyG_cyprus 36 Newbie Poster · Answer 10 · 2013-05-01T08:27:25+00:00

$sqlstr = "UPDATE gallery SET productname='".$productname."', location='".$location."', description='".$description."', urlimages='".$urlimages."' WHERE id=".$_REQUEST['id'];

is still missing the end i.e: WHERE id='".$_REQUEST['id']."';

davy_yg 2 Posting Whiz · Answer 11 · 2013-05-01T09:45:53+00:00

I change it to:

else
            {
            $sqlstr = "UPDATE gallery SET productname='".$productname."', location='".$location."', description='".$description."', urlimages='".$urlimages."' WHERE id='".$_REQUEST['id']."'"; }

Otherwise there is another error appears. I still yet see the two columns being filled in when I update the data.

davy_yg 2 Posting Whiz · Answer 12 · 2013-05-02T03:48:16+00:00

Is there any way to trace it where the flaws are?

Webville312 14 Newbie Poster · Answer 13 · 2013-05-02T08:12:03+00:00

@TonyG CYPRUS, It is quite funny, but then it happens; especially when you write a code when you are feeling tired or sleepy ...

@davy yg, what error are you getting this tym?

TonyG_cyprus 36 Newbie Poster · Answer 14 · 2013-05-02T17:22:30+00:00

Have you echoed out your post data to ensure that it is actually being sent?
We could all be beating ourselves up over something that's not there to start with.
Mysql can be funny over extra spaces, missing comma's etc.

Unknown column 'image'

Recommended Answers Collapse Answers

All 19 Replies

Recommended Answers