Welcome to the Treehouse Community
The Treehouse Community is a meeting place for developers, designers, and programmers of all backgrounds and skill levels to get support. Collaborate here on code errors or bugs that you need feedback on, or asking for an extra set of eyes on your latest project. Join thousands of Treehouse students and alumni in the community today. (Note: Only Treehouse students can comment or ask questions, but non-students are welcome to browse our conversations.)
Looking to learn something new?
Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and a supportive community. Start your free trial today.

Daniphord Mwajah
186 Points!empty() function lies
I have a problem post my data to database, every time I try to submit data to my data base the !empty function lies, it says that all the fields need to be field, while in fact they are! I don't know what is wrong with my code I even tried to echo the values from the form and they all print fine, but still my code tells me that All fields need to be filled. Below is the code:
<?php
$date = @$_POST['date'];
$month = @$_POST['month'];
$year = @$_POST['year'];
$group = @$_POST['group'];
$name = @$_POST['teachername'];
$boys = @$_POST['boysnum'];
$girls = @$_POST['girlsnum'];
$total = @$_POST['total'];
$sponsored = @$_POST['sponsored'];
$lunchtakers = @$_POST['lunchtakers'];
$comment = @$_POST['comment'];
$recordby = @$_SESSION['userName'];
echo $date."<br>";
echo $month."<br>";
echo $year."<br>";
echo $group."<br>";
echo $name."<br>";
echo $boys."<br>";
echo $girls."<br>";
echo $sponsored."<br>";
echo $lunchtakers."<br>";
echo $comment."<br>";
echo $recordby."<br>";
if(isset($_POST['submit'])){
if(!empty($date) && !empty($month) && !empty($year) && !empty($group) && !empty($name) && !empty($boysnum) && !empty($girlsnum) && !empty($total) && !empty($sponsored) && !empty($lunchtakers) && !empty($comment) && !empty($recordby)) {
$insert = "INSERT INTO `khmattendance`( `Date`, `Month`, `Year`, `Groupname`, `Teachersfullname`, `Numberofboys`,
`Numberofgirls`, `Totalnumber`, `Sponsoredchildren`, `Lunchtakers`, `Teacherscomment`, `Addedby`) VALUES (
'".mysqli_real_escape_string($connect, $date)."',
'".mysqli_real_escape_string($connect, $month)."',
'".mysqli_real_escape_string($connect, $year)."',
'".mysqli_real_escape_string($connect, $group)."',
'".mysqli_real_escape_string($connect, $name)."',
'".mysqli_real_escape_string($connect, $boys)."',
'".mysqli_real_escape_string($connect, $girls)."',
'".mysqli_real_escape_string($connect, $total)."',
'".mysqli_real_escape_string($connect, $sponsored)."',
'".mysqli_real_escape_string($connect, $lunchtakers)."',
'".mysqli_real_escape_string($connect, $comment)."',
'".mysqli_real_escape_string($connect, $recordby)."')";
$result = mysqli_query($connect, $insert);
echo "<br><br>";
if($result){
echo '<div class="div1">';
echo '<br>';
echo '<h1><strong>Data successfully inserted!</strong></h1><br><br>';
echo '<a href="sponsorregister.php" id="backlink">Back to previous Page</a><br>';
echo"<br>"; echo "OR<br>";
echo '<a href="khmcorner.php" >Back to controllpanel</a><br>';
echo '</div>';
}else{
echo "<br><br>";
echo '<div id="div1">';
echo '<br><br>';
echo '<h1><strong>Data insertion was unsuccessful!<strong></h1></div><br><br><br>';
echo '<a href="sponsorshipaccountsfeeder.php" id="backlink">Back to previous Page</a><br>';
}
}else{
echo "<br><br>";
echo '<div id="div1">';
echo '<br><br>';
echo '<h1><strong>All fields need to be filled!<strong></h1></div><br><br><br>';
echo '<a href="sponsorshipaccountsfeeder.php" id="backlink">Back to previous Page</a><br>';
}
}
1 Answer

Sean T. Unwin
28,660 PointsThe variables $boysnum
and $girlsnum
do not exist. They are declared as $boys
and $girls
. This means that in the if
statement with all the ! empty()
's is failing.
/*...*/ !empty($boysnum) && !empty($girlsnum) /*...*/
//should be:
/*...*/!empty($boys) && !empty($girls) /*...*/
To be clear, ! empty()
is not lying to you.

Daniphord Mwajah
186 PointsThank you very much Sean, I now understand why! Your answers were very helpful.
Sean T. Unwin
28,660 PointsSean T. Unwin
28,660 PointsI edited your post slightly to make it a bit more readable.