Vacancies Script

Hi

i'm new to PHP and just starting out, i'm looking to create a script for our company website to show what job vacancies we have going.

I've read up online and the best way seems to be to create a mysql database and create a php form script in the backend of the site which submits the jobs to the database (details such as location, description, wage etc) then reads from the database to show the end user the current vacancies that we have.

What's the best way to start this and would the above be the right way to do this?

Thanks

 

Well you definitely need to read up on all the things you need to do, i mean follow tutorials. But here is what you need to do.

create a mysqli connection to your database

create a table in your database with colums ie
id | jobDescription | salary | etc | etc

Than open up a query
for example

$q = mysqli_query($conn,"SELECT * FROM mytable");
 
while($r = mysqli_fetch_array($q)){
echo $r['jobDescription'].'<br><br>';
echo $r['salary'].'<br><br>';
}

Code (markup):

This will get you started in searching for the right topics on the internet. I know it would be great that somebody feeds you the whole script for you personally, but I highly recommend you research how to do it and im very confident that what i have written above will help you along the way.

 

here's my 10 minute plan for you:
get a copy of wordpress. install a listing plugin - done!

need to know more? just gimme a shout