Craig Hoffman wrote:
I have an form where someone can choose to upload a photo. If the person
does not upload a photo, an emtpy string is inserted in the DB. How can
I have it insert 'NULL' in the DB instead of an empty string when they
choose NOT to upload a photo but complete the form anyway?
Any help is appreciated!
Much Thanks -- CH
Here is my code and query if it helps:
if($_POST["postback_upload"])
{
include "include/db.php";
//image uploader
$uploadpath = 'images/climbs/';
$source = $_FILES['photo']['tmp_name'];
$route_photo = $_FILES['photo']['name'];
$dest == '';
if (($source != 'none') && ($source != '')) {
$dest = $uploadpath.$route_photo;
if ($dest != '') {
if (move_uploaded_file($source, $dest)) {
echo ("<h2>Image and Climbing log has been successfully
stored.</h2> ");
} else {
echo ("<h2>Image could not be stored.<h2>");
}
}
} else {
echo ("<h2>No new image supplied. Climbing long has been
successfully stored.<h2>");
}
//photo uploader - make "route_photo" a varible for MySQL to
work -- need to find out why.
$query = "INSERT INTO routes(user_id , date_climbed , route ,
pitchs , rating, area, outcrop, type, style, private_comments,
public_comments, stars, route_photo)
VALUES('NULL', '$_POST[date_climbed]', '$_POST[route]',
'$_POST[pitchs]', '$_POST[rating]',
'$_POST[area]', '$_POST[outcrop]', '$_POST[type]',
'$_POST[style]',
'$_POST[private_comments]','$_POST[public_comments]','$_POST[stars]',
'$route_photo')";
echo $query;
$msg = "<span style='color:red'>Could not insert record</span>";
$result = mysql_query($query,$db) or die(mysql_error());
Why not just check if it's an empty string, and replace it with NULL if so?
if ($route_photo = '') {
$route_photo = NULL;
}
I'm not completely sure though.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php