Application System

[HD-Christopher]

Hey there, I am starting a website and would like to know if there are any application systems out there. Kinda like habbcrazy.

But it should either send an e-mail or upload them to the directory. Can anyone help me out?

[iDenning]

Use a simple PHP contact form and edit it to your liking?

[Shibby-Shabs]

You could try maybe PHP Support tickets and edit the question fields and text.

~What kind of website you making?

[RastaLulz]

I'll code one right now using PHP, and MySQL.

[RastaLulz]

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.

[Calvin]

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.

Looks great +rep!

[BoyBetterKnow]

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.

[Fehm]

Anyone can view the apps with your thing Foskett?
Maybe a bit of protection would be nice

[Calvin]

Anyone can view the apps with your thing Foskett?
Maybe a bit of protection would be nice

create a login?

[RastaLulz]

Anyone can view the apps with your thing Foskett?
Maybe a bit of protection would be nice

Yes, I know, it was 3 in the morning and I was half asleep. I'll add a session, or a cookie login for staff later, if I get around to it, but this works perfectly fin for the time beings and the viewapps can easily be implemented into a staff login panel.