【php开源代码栏目提醒】:网学会员鉴于大家对php开源代码十分关注,论文会员在此为大家搜集整理了“insert_job.php”一文,供大家参考学习
<?php
/*
* Created on 2006-11-21
*
* To change the template for this generated file go to
* Window - Preferences - PHPeclipse -
PHP - Code Templates
*/
session_start();
require_once('db.php');
require_once('getID.php');
$db = new DataAccess();
$db->connect();
$provinceid = getProvinceID($province);
$placeid = getProvinceID($place);
$jobtypeid = getJoblistID($jobtype);
$specialid = getSpecialistID($special);
$time = date('y.m.d');
if(isset($_SESSION["validuser"]) and 2==$_SESSION['usercode'])
$enterpriseid = $_SESSION["validuser"];
else
{
header("Location:error.php?errid=14");
return;
}
$db1 = new DataAccess();
$db1->connect();
$sql = "insert into job(joblist_id,job,city,num,age,speciallist_id,city_id,edu,place,language,languagelevel,sex,type,marry,computer,live,salary,jobdescribe,addtime,enterprise_id)" .
" values('$jobtypeid','$job','$city','$num','$age','$specialid','$provinceid','$edu','$placeid','$language','$level','$sex','$type','$marry','$computer','$live','$salary','$jobdescribe','$time','$enterpriseid')";
$result = $db1->perform($
sql);
if(!$result)
header("Location:error.php?errid=12");
else
{
echo "发布成功!<a href='../index.php'>完成发布</a> <a href='../addjob.php'>继续发布</a>";
}
$db->close();
?>