Hey guys!
This is giving me a headache, when i submit the form below, the textarea, e.g. name"eventdes" is always empty, I have check the $_POST and its all correct… not sure if anyone knows what else i can do!!
<form method="post" action="newevent.php"/>
<span class="style2">
<label for="email">Your Email</label>
<input type="text" name="email" id="email" class="BigText"/>
</span>
<p class="style2">
<label for="eventname">Event Name</label>
<input type="text" name="eventname" id="eventname" class= "BigText"/>
</p><p class="style2">
<label for="date">Date: From</label>
<input type="datefrom" id="date" name="date" class="BigText"/>To:
<input type="dateto" id="dateto" name="dateto" class="BigText"/>
</p>
<p>
<label for="eventdes" class="style2">Event Description</label>
<textarea name"eventdes" cols="54" rows="10" id="eventdes"/></textarea>
</p><p class="style2">
<label for="website">Event Website</label>
<input type="text" id="website" name="website" class="BigText" />
</p>
<p class="style2">
<label for="industry">Industry</label>
<input type="text" name="industry" id="industry" class="BigText"/>
</p>
<input type="submit" value="New Event" name="submit" id="submit"/>
</form></p>
</td>
</tr>
</table>
</body>
</html>
<?php
if(isset ($_POST['submit'])){
$dbc= mysqli_connect('localhost','user_alien','alien123','mookle');
$email=mysqli_real_escape_string($dbc,trim($_POST['email']));
$event=mysqli_real_escape_string($dbc,trim($_POST['eventname']));
$datefrom=mysqli_real_escape_string($dbc,trim($_POST['datefrom']));
$dateto= mysqli_real_escape_string($dbc,trim($_POST['dateto']));
$description=mysqli_real_escape_string($dbc,trim($_POST['eventdes']));
$website=mysqli_real_escape_string($dbc,trim($_POST['website']));
$industry=$_POST['industry'];
//check required fields//
$error=array();
if(empty($email)){$error[]='Please enter your email address';}
if(empty($event)){$error[]='Please enter your event name!';}
if(empty($description)){$error[]='Please enter your description!';}
if(count($error)==0){
//connect to database//
$dbc= mysqli_connect('localhost','user_alien','alien123','mookle')
or die('mysql error has occured');
$query="INSERT INTO mookle_tables VALUES('$email','$eventname','$date_from','$date_to','$description','$website','$industry')";
mysqli_query($dbc,$query);
echo ('your event is now in our system!');
}
else {
echo implode('<br />',$error);}
}
?>