【php开源代码栏目提醒】:文章导读:在新的一年中,各位网友都进入紧张的学习或是工作阶段。网学会员整理了php开源代码-person.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();
include('head.php');
require_once('com/db.php');
$db = new DataAccess();
$db->connect();
?>
<html>
<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="css.css" type="text/css">
<title>个人简历</title>
</head>
<body>
<?php
require_once('com/db.php');
$db = new DataAccess();
$db->connect();
//$_POST['enterpriseid']取不到
查询字符串的值
if(!empty($_GET['personid']))
$sql = "select u.user_id,u.name,u.sex,u.length,u.edu,u.birthday,u.language1,u.language2,u.langlevel1,langlevel2,s.specialname,u.computer,GraduateDate," .
"u.marry,u.click,u.salary,u.job1,u.job2,u.type,u.works,u.worktime,u.phone,u.posts,u.mobile,u.address,u.introduce,a.areaclass," .
"u.university,u.place,u.nation,u.email,j.jobclass " .
"from user u,speciallist s,arealist a,joblist j where u.special_id=s.speciallist_id and u.joblist_id=j.joblist_id " .
"and u.city_id=a.arealist_id and u.user_id='".$_GET['personid']."'";
else
$sql = "select j.job,j.id from job j,enterprise e where 1<>1";
$result = $db->query($
sql);
$row_num = $db->getRowNum();
if($row_num > 0)
{
$db1 = new DataAccess();
$db1->connect();
$sql = "update user set click=click+1 where user_id = '".$_GET['personid']."'";
$result1 = $db1->perform($sql);
if(!$result1)
echo '更新点击数出错!';
$row =
mysql_fetch_array($result)
?>
<div align="center">
<table border="0" width="760" cellspacing="0" cellpadding="0" id="table1" height="226">
<tr>
<td style="border-left: 1px solid #0086DF; border-right: 1px solid #0086DF" width="760" valign="top">
<div align="center">
<table border="0" width="76%" cellspacing="0" cellpadding="0" id="table3" height="50">
<tr>
<td>
<p align="center"><font size="5"><?php echo $row['name']; ?>个人简历
</font>(被阅<font color="#FF3900"><?php echo $row['click']+1; ?></font>次)</td>
</tr>
</table>
<table border="1" width="651" cellspacing="0" cellpadding="0" bordercolor="#0086DF" id="table2" style="border-collapse: collapse">
<tr>
<td height="30" background="images/person_bg.gif" width="649" colspan="5">
<p align="left"> <b>个人基本信息</b></td>
</tr>
<tr>
<td height="30" width="105" align="center" bgcolor="#FEFBF4">
<p align="center">姓 名:</td>
<td height="30" width="217">
<?php echo $row['name']; ?></td>
<td height="30" width="106" align="center" bgcolor="#FEFBF4">
性 别:</td>
<td height="30" width="95">
<?php echo $row['sex']; ?></td>
</tr>
<tr>
<td height="30" width="105" align="center" bgcolor="#FEFBF4">
出生日期:</td>
<td height="30" width="217">
<?php echo $row['birthday']; ?></td>
<td height="30" width="106" align="center" bgcolor="#FEFBF4">
民 族:</td>
<td height="30" width="95">
<?php echo $row['nation']; ?></td>
</tr>
<tr>
<td height="30" width="105" align="center" bgcolor="#FEFBF4">
户 籍:</td>
<td height="30" width="217">
<?php echo $row['areaclass']; ?></td>
<td height="30" width="106" align="center" bgcolor="#FEFBF4">
身 高:</td>
<td height="30" width="95">
<?php echo $row['length']; ?>cm</td>
</tr>
<tr>
<td height="30" width="105" align="center" bgcolor="#FEFBF4">
婚姻状况:</td>
<td height="30" width="217">
<?php echo $row['marry']; ?></td>
<td height="30" width="106" align="center" bgcolor="#FEFBF4">
学 历:</td>
<td height="30" width="95">
<?php echo $row['edu']; ?></td>
</tr>
<tr>
<td height="30" width="105" align="center" bgcolor="#FEFBF4">
专业:</td>
<td height="30" width="217">
<?php echo $row['specialname']; ?></td>
<td height="30" width="106" align="center" bgcolor="#FEFBF4">
现住地点:</td>
<td height="30" width="95">
<?php echo $row['place']; ?></td>
</tr>
<tr>
<td height="30" width="105" align="center" bgcolor="#FEFBF4">
毕业时间:</td>
<td height="30" width="217">
<?php echo $row['GraduateDate']; ?></td>
<td height="30" width="106" align="center" bgcolor="#FEFBF4">
毕业院校:</td>
<td height=