what's wrong with this code?

virva

Hi!

I have a form with a checkbox in it (name=julkaisu) I have this kind of code that should add the values to the db. Other values are added correctly, but I always get the note "not checked" from the checkbox, even though it was checked. So, what is the problem?
Thanks for your help.

<?php

include_once("functions.php");

if ($julkaisu) {
$julkaistaan = 'yes';
echo "checked";

$insert = "INSERT INTO klubikanta
(enimi, snimi, tehtava, yritys, kurssi, sposti, osoite, postinro,
postipaikka, laskutus, lisatiedot, julkaisu, tunnus, salasana, pvm)
VALUES ('$enimi', '$snimi', '$tehtava', '$yritys', '$kurssi', '$sposti', '$osoite', '$postinro',
'$postipaikka', '$laskutus','$lisatiedot', '$julkaistaan', '$tunnus', '$salasana', '$pvm')";

    } 
    else { 
    $julkaistaan = 'no'; 
    echo "not checked";

}

$result = db_execute($insert);
if ($result) {
echo "New data inserted.\n";
echo "Tunnuksesi on: $tunnus\n";
echo "Salasanasi on: $salasana\n";
}
else {
echo "No data inserted. Try again.\n";
echo "\n";
}

amansabharwal

suppose you have declared your check box like this:

now in your code do the following change

if($julkaisu=="yes")
{
echo "checked"
}
else

{
echo "not checked";

}

i hope it will work

virva

Thank you very much, it worked! 🙂