Error with saving Form data to MySQL

the code saves the category, image title, image, and feature..
but the problem is that the "feature" is not saved, but the others were saved..
this is the data types of my table

category = text
title = text
image = longblob
feature = text

in html, the users input the feature in (textarea)..
is there a problem with the code? pls.. help

Expand|Select|Wrap|Line Numbers

 
<?php
 
// Connect to database
 
$errmsg = "";

if (! @mysql_connect("localhost","root","")) {

        $errmsg = "Cannot connect to database";

        }

@mysql_select_db("upload");
 
// Insert any new image into database
 
if ($_REQUEST[completed] == 1) {

        // Need to add - check for large upload. Otherwise the code

        // will just duplicate old file ;-)

        // ALSO - note that latest.img must be public write and in a

        // live appliaction should be in another (safe!) directory.

        move_uploaded_file($_FILES['imagefile']['tmp_name'],"latest.img");

        $instr = fopen("latest.img","rb");

    $image = addslashes(fread($instr,filesize("latest.img")));

    if (strlen($instr) < 149000) {

                mysql_query ("insert into sharp (category, title, imgdata, feature) values (\"". $_REQUEST[categ] . "\", \"". $_REQUEST[whatsit] . "\", \"". $image . "\", \"". $feature . "\")");

        } else {

                $errmsg = "Too large!";
 
        }

}
 
?>
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<title>Untitled Document</title>

<link href="div.css" rel="stylesheet" type="text/css" />

</head>

<body>

<style type="text/css"> 
 
body 

{ 

background-image: url(body.jpg);

background-repeat: no-repeat;
 
background-position: top left;

}
 
</style>
 
<h3 align = "left">Please upload a new picture and title</h3>

<form method=post>

<table border = "0" align = "left">

<tr>

    <td>Brand:</td>

    <td><select name = "brand">

        <option>SONY</option>

        <option>SHARP</option>

        <option>LG</option>

        <option>PANASONIC</option>

        <option>SAMSUNG</option>

        <option>JVC</option></select></td>

</tr>
 
<tr>

    <td>Category:</td>

    <td><select name = "categ">

        <option>TV</option>

        <option>AUDIO</option>

        <option>WASHING MACHINE</option>

        <option>REFRIGERATOR</option>

        <option>AIR CONDITIONER</option>

        <option>MICROWAVE OVEN</option></select></td>

</tr>
 
<tr>

    <td>Image Title:</td>

    <td><input name=whatsit></td>

</tr>
 
<tr>

    <input type=hidden name=MAX_FILE_SIZE value=150000>

    <input type=hidden name=completed value=1>

    <td>Upload Image:</td>

    <td><input type=file name=imagefile></td>

</tr>
 
<tr>

    <td>Feature:</td>

    <td><textarea name = "feature"></textarea></td>

</tr>
 
<tr>

    <td></td>

    <td><input type=submit value = "Save"></td>

</tr>
 
</table>

<br>
 
</form><br>
 
</body>

</html>

Feb 10 '08 #1

Subscribe Post Reply

1738

ak1dnar

1,584

Expert 1GB

In line number 22 (Your SQL Insert Statement), you have to assign the posted textarea value to $feature variable. You should use $_REQUEST['feature'] instead of $featureOr else put this Line before your sql query.
[PHP]$feature = $_REQUEST['feature'];[/PHP]

Feb 10 '08 #2

mirianCalin

In line number 22 (Your SQL Insert Statement), you have to assign the posted textarea value to $feature variable. You should use $_REQUEST['feature'] instead of $featureOr else put this Line before your sql query.
[PHP]$feature = $_REQUEST['feature'];[/PHP]

thanks for correcting me, it worked..
i was figuring that out the whole day..
thanks again..

Feb 10 '08 #3

Markus

6,050

Expert 4TB

You should also try and use single quotes around array indeces!
[php]
$_something = $_FILES[file][type]; // baaaad!
$_something = $_FILES['file']['type'] // good good good!
[/php]

Feb 10 '08 #4

Similar topics

Error log empty

by: Wayno | last post by:

My php logs are coming up empty. I have done all I can think of, and all that made sense to me. Can someone take a look at my php.ini please and tell me what you think may be the problem. I...

PHP

Syntax error (missing operator) in query expression

by: Maciej Paras | last post by:

Hello! I've written 2 pages: one i HTML format, and second - in ASP. When I'm posting data from HTML page, I receive this error generated by ASP page: Microsoft JET Database Engine (0x80040E14)...

ASP / Active Server Pages

Please help : System.Data.OleDb.OleDbException: Syntax error in IN

by: Joe | last post by:

Hello All, I am trying to insert a record in the MS Access DB and for some reason I cannot get rid of error message, System.Data.OleDb.OleDbException: Syntax error in INSERT INTO statement. ...

ASP.NET

Please help : System.Data.OleDb.OleDbException: Syntaxerror in INSERT INTO statement error

by: Joe | last post by:

Hello All, I am trying to insert a record in the MS Access DB and for some reason I cannot get rid of error message, System.Data.OleDb.OleDbException: Syntax error in INSERT INTO statement. ...

Visual Basic .NET

Saving and retrieving to/from MYSQL database. Help.

by: Krakatioison | last post by:

Hi everyone, can someone point me to download of an example for saving and retrieving to/from MYSQL database. Or did anyone of you tried this and could share your code with me. I've got some data...

Visual Basic .NET

Error 07002 SQLBindParameter not used for all parameters

by: Mikey G | last post by:

Hi, I created a simple VB.NET 2003 application through Visual Studio that connects to a MySQL database and loads a table into a Dataset, and then displays that table information in a DataGrid on a...

Visual Basic .NET

Registration Form - Error ?

by: Wayne Smith | last post by:

I've taken the following code from a developers web site which should allow a user to register and receive an email message with a link to activate their account, but when I click the link on my...

ASP.NET

Input not saving.

by: jessDMiller | last post by:

I have no clue why the data from the form isn't saving into the database. What am I doing wrong? addAnnounce.php: <td align=top> <form action="index2.php" method="post">Heading:<br...

PHP

Error- Contact Form

by: kammaldeep | last post by:

hi, i m newbie 2 PHP & to b frank ... will alwaz be ... i dont think i will go into much details with PHP as my work doesnot include workin with PHP bt i have a forum .. and i want to make a...

PHP

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA