Here is a situation

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
muzammil
Forum Newbie
Posts: 4
Joined: Tue Apr 12, 2011 7:48 am

Here is a situation

Post by muzammil »

First off Please bear with me. I am newbie.

Here is a table name 'Employes' and has following Columns.
ID(PK) | FirstName | LastName | SecurityLicence | CrowdLicence | DriversLicence | Password |

And through form all the values are assigned to these columns and user gets registered.
I have done it using this code and its working fine.

Code: Select all

<?php
session_name('YourVisitID');
session_start();
if(!isset($_SESSION['FirstName']))
	{
		header("Location: http://" . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF']) . "/index.php");
		exit();
	}
else
{
$page_title = 'Register';
include('templates/header.inc');
if(isset($_POST['submit']))
{
	require_once('mysql_connect.php');
	// connect to the db
	
	//Create a function for escaping the data.
	function escape_data($data)
	{
		global $con; // need connection
		if(ini_get('magic_quotes_gpc'))
		{
			$data = stripslashes($data);
		}
		return mysql_real_escape_string($data, $con);
	}
	$message = NULL;
	if(empty($_POST['firstName']))
	{
		$fn = FALSE;
		$message .= '<p>you forgot to enter your first name!</p>';
	}
	else
	{
		$fn = escape_data($_POST['firstName']);
	}
	
	if(empty($_POST['lastName']))
	{
		$ln = FALSE;
		$message .= '<p>You forgot to enter your last name!</p>';
	}
	else
	{
		$ln = escape_data($_POST['lastName']);
	}
	if(empty($_POST['licenceId']))
	{
		$li = FALSE;
		$message .='<p>You Forgot enter your Security Officer Licence Number!</p>';
	}
	else
	{
		$li = escape_data($_POST['licenceId']);
	}
	if(empty($_POST['crowdLicenceNo']))
	{
		$cln = FALSE;
		$message .='<p>You Forgot to enter your Crowd Controller Licence Number!</p>';
	}
	else
	{
		$cln = escape_data($_POST['crowdLicenceNo']);
	}
	if(empty($_POST['driverLicenceNo']))
	{
		$dln = FALSE;
		$message .='<p>You forgot to enter your Driving Licence Number!</p>';
	}
	else
	{
		$dln = escape_data($_POST['driverLicenceNo']);
	}
	if(empty($_POST['password']))
	{
		$p = FALSE;
		$message .='<p>You forgot to enter your password!</p>';
	}
	else
	{
			if($_POST['password'] == $_POST['password2'])
				{
					$p = escape_data($_POST['password']);
				}
			else
				{
					$p = FALSE;
					$message .='<p>Your password did not match the confirmed password</p>';
				}
	}
	if($fn && $ln && $li && $cln && $dln && $p)
	{
				
		$query = "SELECT ID FROM Employes WHERE SecurityLicence='$li'";
		$result = @mysql_query($query);
		if(mysql_num_rows($result) == 0)
		{ 
		
		
		$query = "INSERT INTO Employes (FirstName, LastName, SecurityLicence, CrowdLicence, Driverslicence, Password)
		VALUES ('$fn', '$ln', '$li', '$cln', '$dln', PASSWORD('$p'))";
		$result = @mysql_query($query);
			if($result)
				{
					echo '<p>You have been registered</p>';
		
				}
			else
			{
				$message = '<p>We apologise there is a system error.</p><p>' . mysql_error(). '</p>';
			}
		} 
		else 
		{
			$message = '<p>That Security Licence is already registered</p>';
		}
			mysql_close();
	}
	else
	{
		$message .='<p>Please try again</p>';
	}
}

//print the message if there is one
if (isset($message))
{
	echo '<font color="red">', $message, '</font>';
}
}
?>
<script type="text/javascript">
function validate_form()
{
	var f = document.forms["regForm"]["firstName"].value;
		if(f==null || f=="")
			{
				alert("First Name must be filled out");
				return false;
			}
	var l = document.forms["regForm"]["lastName"].value;
		if(l==null || l=="")
			{
				alert("Last Name must be filled out");
				return false;
			}
	var sl = document.forms["regForm"]["licenceId"].value;
	var s = /^\d{5,}$/g.test(sl);
	var sll = sl.length;
		if(s==false)
			{
				alert("Security Licence No must be filled out in digits");
				return false;
			}
		else if(sll>=7)
			{
				alert("Invalid Security Licence No");
				return false;
			}
	var csl = document.forms["regForm"]["crowdLicenceNo"].value;
	var k = /^\d{5,}$/g.test(csl);
	var csll = csl.length;
		if(k==false)
			{
				alert("Crowd Controller Licence No must be filled out in digits");
				return false;
			}
		else if(csll>=7)
			{
				alert("Invalid Crowd Controller Licence No");
				return false;
			}
	var d = document.forms["regForm"]["driverLicenceNo"].value;
	var v = /^\d{6,}$/g.test(d);
	var dl = d.length;
		if(v==false)
			{
				alert("Driver's Licence No must be filled out in digits");
				return false;
			}
		else if(dl>=11)
			{
				alert("Invalid Driver's Licence No");
				return false;
			}
	
}
</script>


<h3>Employment Registration Form</h3>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" name="regForm" method="post" onsubmit="return validate_form()">
<fieldset>
<legend>Enter informations in the form below</legend>
<table>
<tr><th>First Name:</th><td><input type="text" name="firstName" /></td></tr>
<tr><th>Last Name:</th><td><input type="text" name="lastName" /></td></tr>
<tr><th>SO Licence No:</th><td><input type="text" name="licenceId" size="5" /></td></tr>
<tr><th>CC Licence No:</th><td><input type="text" name="crowdLicenceNo" size="5" /></td></tr>
<tr><th>Driver's Licence No:</th><td><input type="text" name="driverLicenceNo" size="10" /></td></tr>
<tr><th>Create Password:</th><td><input type="password" name="password" size="10" /></td></tr>
<tr><th>Confirm Password:</th><td><input type="password" name="password2" size="10" /></td></tr>
</table>
<input type="submit" name="submit" value="Register" />
<input type="reset" value="Reset" />
</fieldset>   
</form>

<?php
include('templates/footer.inc'); 
?>
Here is another Table "Jobs", with the following columns.
JobID(PK) | ID(FK) | JobDate | JobStart | JobFinish | JobLocation | RequestedBy |

For Example I am the owner of the company and want to assign jobs to my registerd workers using a form.
I assign JobDate=12/12/12 JobStart=1900 JobFinish=2300 JobLocation=Perth Requestedby=John. And I do it using form. JobID will be incremented automatically.
Now what i dont understand is how do I assign ID(FK) to it?? I am newbie this question may sound stupid to many of you but hey please help.
Or should I replace ID(FK) with the SecurityLicence of the worker, Like this
JobID(PK) |ToSecurityLicence | JobDate | JobStart | JobFinish | JobLocation | RequestedBy |

What I want is when the workers signs in He should see the job assigned to him. Can I do it using inner join??? if so how to right PHP code for comparing these two tables???
I am way too much confused.

Too many of you I have made a fool of myself asking this question. But I believe a person who doesnt ask the question is fool foreva.

If somebody could Help I would really really aprreciate it.

Thanks.
Post Reply