Okay, I coded a very basic one just now:
config.php
<?php
//site info
$applications = 1; //0 = closed & 1 = open
//mysql info
$cloc = "YOUR HOST FOR MYSQL"; //usually localhost
$cuser = "MYSQL USERNAME"; //usually root
$cpass= "YOUR MYSQL PASS";
$cdb = "THE DATABASE NAME";
$conn = mysql_connect("$cloc","$cuser","$cpass"); // Username connection
if (!$conn) die ("<center>Could not connect MySQL. Check your configuration settings by opening config.php.</center>");
mysql_select_db($cdb,$conn) or die ("Could not open database.");
?>
jobapps.php
<?php
include("config.php");
if($applications == 1) {
if($_POST['submit']) {
$habboname = strip_tags($_POST['habboname']);
$hotel = $_POST['hotel'];
$email = strip_tags($_POST['email']);
$country = strip_tags($_POST['country']);
$experience = nl2br(strip_tags($_POST['experience']));
$date = date("Y-m-d");
$time = date("H:m:s");
if($habboname == NULL || $hotel == NULL || $email == NULL || $country == NULL || $experience == NULL) {
echo "You have left a field blank!<br /><br />";
}else{
$sendapp = mysql_query("INSERT INTO apps (id, habboname, hotel, email, country, experience, date, time) VALUES (NULL, '$habboname', '$hotel', '$email', '$country', '$experience', '$date', '$time')");
echo "You have successfully sent your application!<br /><br />";
}
}else{
}
echo "<form method='POST'>
Habbo Name:<br />
<input type='text' name='habboname' size='30' maxlength='30'><br /><br />
Hotel Used:<br />
<select name='hotel'>
<option value='US'>Habbo USA</option>
<option value='UK'>Habbo UK</option>
<option value='CA'>Habbo CA</option>
<option value='AU'>Habbo AU</option>
</select><br /><br />
Email Address:<br />
<input type='text' name='email' size='30' maxlength='30'><br /><br />
Country:<br />
<input type='text' name='country' size='30' maxlength='30'><br /><br />
Experience:<br />
<textarea name='experience' rows='10' cols='40' maxlength='500'></textarea><br /><br />
<input type='submit' name='submit' value='Send App'>
</form>";
}else{
echo "Sorry, applications are closed.";
}
?>
viewapps.php
Job Applications:<br />
<?php
include ("config.php");
$comquery = mysql_query("SELECT * FROM apps ORDER BY id ASC");
while ($com = mysql_fetch_array($comquery)) {
$hn = $com['habboname'];
$hotel = $com['hotel'];
$email = $com['email'];
$country = $com['country'];
$experience = $com['experience'];
$time = $com['time'];
$date = $com['date'];
echo "<table width='800'>
<tr bgcolor='F8F8F8'>
<td>Habbo Name:</td>
<td width='50%'>{$hn}</td>
</tr>
<tr bgcolor='F0F0F0'>
<td width='50%'>Hotel:</td>
<td width='50%'>{$hotel}</td>
</tr>
<tr bgcolor='F8F8F8'>
<td width='50%'>Email:</td>
<td width='50%'>{$email}</td>
</tr>
<tr bgcolor='F0F0F0'>
<td width='50%'>Country:</td>
<td width='50%'>{$country}</td>
</tr>
<tr bgcolor='F8F8F8'>
<td width='50%'>Experience:</td>
<td width='50%'>{$experience}</td>
</tr>
<tr bgcolor='F0F0F0'>
<td width='50%'>Date:</td>
<td width='50%'>{$date}</td>
</tr>
<tr bgcolor='F8F8F8'>
<td width='50%'>Time:</td>
<td width='50%'>{$time}</td>
</tr>
<tr bgcolor='F0F0F0'>
<td width='50%'>Habbo Name:</td>
<td width='50%'>{$hn}</td>
</tr>
<br />";
}
?>SQL
CREATE TABLE IF NOT EXISTS `apps` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`habboname` varchar(50) NOT NULL,
`hotel` varchar(2) NOT NULL,
`email` varchar(50) NOT NULL,
`country` varchar(50) NOT NULL,
`experience` longtext NOT NULL,
`date` date NOT NULL,
`time` time NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;This is very basic, I'll probably continue with it tomorrow, and make a project out of it, but until then, this works perfectly well.
Why did you strip tags on other things but not on $hotel ? Hotel input could be modified. I cba to read all but you wrote it fast, so it's nice of you.