JOB FORWARDING
OBJECTIVE: Send job alerts to mobiles
Initially we need to design a web page where we collect the details about the area of interest and the mobile number of the candidate. This web page can be designed using HTML that links to a PHP page. In the area of interest column the user can mention which programming language he is interested in.
Secondly we need to create a database where the details of various companies are stored. That is, which company is implementing which programming language. These details need to be updated regularly.
Supposing, a user enters that his area of interest is JAVA, he must be sent a message that tells about the companies which are implementing java language as their base. The major task is to compare the area of interest with the details stored in the database and produce the required company information back to the user as a text message to their mobile number.
Front end —— PHP
Back end —— MySQL
STEPS TO BE FOLLOWED:
STEP 1: Install apache2, mysql and phpmyadmin in your system
STEP 2: Create a form using HTML to get the details from the user such as,
Name, Mobile Number, Qualification, Area of interest, Experience, etc. and submit the form
STEP 3: To submit these details, write coding in PHP, which connects to the database “job” that is already created
<?php
$con = mysql_connect(“localhost”,”root”,”");
if (!$con)
{ die(‘Could not connect: ‘ . mysql_error()); }
mysql_select_db(“job”, $con);
$sql=”INSERT INTO jobfrwd(name,mno,qual,area,exp)
VALUES
(‘$_GET[name]‘,’$_GET[mno]‘,’$_GET[qual]‘,’$_GET[area]‘,’$_GET[exp]‘)”;
if (!mysql_query($sql,$con))
{ die(‘Error: ‘ . mysql_error()); }
echo “Your record added successfully”;
mysql_close($con)
?>
<br><br>
<a href=”jobfrwd.html”>Back</a>
This code enters your details in the database “job” in the table say ”jobfrwd”.
STEP 4: Create another table “company” in same database.
Enter the details of few companies with the company
name,address,field in which the company works,
vacancy in the table.
STEP 5: Create another table say “compare” in the same database with the
following fields –name of the person,mobile number,company, vacancy.
STEP 6: Write a PHP code for comparing the user’s area of interest (in table “jobfrwd”) that matches with the field of the company(in the table“company”)
$sql = “SELECT jobfrwd.name,jobfrwd.mno,company.company,company.vacancy
FROM jobfrwd, company WHERE jobfrwd.area = company.field”;
$sql=”INSERT INTO compare (name, mno, company,vacancy)VALUES(‘$name’,'$mno’,'$company’,'$vacancy’)”;
The result of the above code is stored in the database “job” in the table “compare”. Now this table gives the name of the user, mobile number, company name, vacancy.
STEP 7: Next we need to send SMS to the user regarding the company that
matched his area of interest and if there is any vacancy available.
1. For this we must first install gnokii software using the following code.
sudo apt-get install gnokii
2. Then connect a Bluetooth device to the system
To connect the mobile and sys ON the Bluetooth in mobile and system,for system use bluetooth dongle.
In system the Bluetooth symbol appears as
Note: *in bluetooth symbol click and get preference and select “service”
In this symbol right click and select “Browse device” and select the your mobile and click “connect” ,and accept the message in mobile and give any passkey and click ok. Now the mobile and system are paired successfully.
Now goto terminal type,
sudo gedit /etc/gnokiirc
The file opens, change the settings as follows
- in 27th line default present like #port = aa:bb:cc:dd:ee:ff, change port = aa:bb:cc:dd:ee:ff and we want the mobile id or address to get(when mobile and sys connected only) type in terminal like
hcitool scan
- It gives the paired device mac address copy this .
- Paste in the 27th line like port = aa:bb:cc:dd:ee:ff change port = “your mobile address”
- Enable model = AT in 51th line disable #model=6110
- In line 101 remove # from connection = bluetooth
STEP 7: Write a code in PYTHON for sending SMS to the users whose
names are in the compare table.Run the program in terminal as follows.
python sms.py
!……………………………………………………………………….!
