Here is a situation
Posted: Sun Apr 17, 2011 9:21 pm
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.
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.
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');
?>
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.