<?php
require 'mysql_db.php';
// Start Session
function init() {
session_start();
$session_id = session_id();
}
// Show MySQL error
function showerror() {
die("Error ". mysql_errno() . " : " . mysql_error());
}
// Login
function login($email,$pass) {
$connection = @ mysql_connect(HOST, USER, PASSWORD) or die("Could not connect");
mysql_select_db(DATABASE, $connection) or showerror();
$query="SELECT id, email, password, name FROM users WHERE email='$email'";
$result = @ mysql_query ($query, $connection) or showerror();
if (mysql_numrows($result) > 0) {
$password=mysql_result($result,0,"password");
//echo "pass = $pass, password = $password";exit;
$id=mysql_result($result,0,"id");
$name=mysql_result($result,0,"name");
if ($pass == $password) {
$_SESSION['email'] = "$email";
$_SESSION['id'] = "$id";
$_SESSION['name'] = "$name";
$status = "Online";
changestatus($id, $status);
header("Location: usermain.php");
} else {header("Location: index.php?error=1"); }
}else {
header("Location: index.php?error=1");
}
mysql_close($connection) or showerror();
}
function changestatus($id, $status){
$connection = @ mysql_connect(HOST, USER, PASSWORD) or die("Could not connect");
mysql_select_db(DATABASE, $connection) or showerror();
$query = "UPDATE users SET userstatus = '$status' WHERE id = $id ";
$result = @ mysql_query($query, $connection) or showerror();
mysql_close($connection) or showerror();
}
function returnstatus($id){
$connection = @ mysql_connect(HOST, USER, PASSWORD) or die("Could not connect");
mysql_select_db(DATABASE, $connection) or showerror();
$query = "SELECT userstatus FROM users WHERE id = $id ";
$result = @ mysql_query($query, $connection) or showerror();
$status = mysql_result($result,0,"userstatus");
mysql_close($connection) or showerror();
return $status;
}
function adduser($email, $password, $name, $gender, $location, $birthday, $address, $description, $photo) {
$connection = @ mysql_connect(HOST, USER, PASSWORD) or die("Could not connect");
mysql_select_db(DATABASE, $connection) or showerror();
if (is_uploaded_file($photo['tmp_name']) && $photo['size'] > 0) {
$photoname = addslashes(basename($photo['name']));
$photodata = addslashes(file_get_contents($photo['tmp_name']));
$photosize = getimagesize($photo['tmp_name']);
$phototype = $photosize['mime'];
$photoheightwidth = addslashes($photosize[3]);
} else {
$photo = "";
}
$email = mysql_real_escape_string($email);
$password = mysql_real_escape_string($password);
$name = mysql_real_escape_string($name);
$gender = mysql_real_escape_string($gender);
$location = mysql_real_escape_string($location);
$birthday = mysql_real_escape_string($birthday);
$address = mysql_real_escape_string($address);
$description = mysql_real_escape_string($description);
if ($photo == "") {
$query ="insert into users (id, email, password, name, gender, location, birthday, address, description) " .
"values (null, '$email', '$password', '$name', '$gender', '$location', '$birthday', '$address', '$description')";
} else {
$query ="insert into users " .
"(id, email, password, name, gender, location, birthday, " .
"address, description, photodata, photoname, phototype, photosize) " .
"values (null, '$email', '$password', '$name', '$gender', '$location', " .
"'$birthday', '$address', '$description', '$photodata', '$photoname', " .
"'$phototype', '$photoheightwidth')";
}
$result = @ mysql_query($query, $connection) or showerror();
mysql_close($connection) or showerror();
}
function updateuser($email, $password, $name, $gender, $location, $birthday, $address, $description, $photo){
$connection = @ mysql_connect(HOST, USER, PASSWORD) or die("Could not connect");
mysql_select_db(DATABASE, $connection) or showerror();
if (is_uploaded_file($photo['tmp_name']) && $photo['size'] > 0) {
$photoname = addslashes(basename($photo['name']));
$photodata = addslashes(file_get_contents($photo['tmp_name']));
$photosize = getimagesize($photo['tmp_name']);
$phototype = $photosize['mime'];
$photoheightwidth = addslashes($photosize[3]);
} else {
$photo = "";
}
$email = mysql_real_escape_string($email);
$password = mysql_real_escape_string($password);
$name = mysql_real_escape_string($name);
$gender = mysql_real_escape_string($gender);
$location = mysql_real_escape_string($location);
$birthday = mysql_real_escape_string($birthday);
$address = mysql_real_escape_string($address);
$description = mysql_real_escape_string($description);
if ($photo == ""){
$query = "UPDATE users SET password = '$password', name = '$name', " .
"gender = '$gender', location = '$location', birthday = '$birthday', address = '$address', description = '$description' " .
"WHERE email = '$email' " .
"LIMIT 1";
}
else {
$query = "UPDATE users SET password = '$password', name = '$name', gender = '$gender', " .
"location = '$location', birthday = '$birthday', address = '$address', description = '$description', " .
"photodata = '$photodata', photoname = '$photoname', phototype = '$phototype', photosize = '$photoheightwidth' " .
"WHERE email = '$email' LIMIT 1";
}
$result = @ mysql_query($query, $connection) or showerror();
mysql_close($connection) or showerror();
}
function deleteuser($id){
$connection = @ mysql_connect(HOST, USER, PASSWORD) or die("Could not connect");
mysql_select_db(DATABASE, $connection) or showerror();
$remove = "delete from users where id = $id ";
$result = @ mysql_query($remove, $connection) or showerror();
$remove = "delete from friends where uid=$id OR fid=$id ";
$result = @ mysql_query($remove, $connection) or showerror();
mysql_close($connection) or showerror();
}
function finduser($key, $gender){
$connection = @ mysql_connect(HOST, USER, PASSWORD) or die("Could not connect");
mysql_select_db(DATABASE, $connection) or showerror();
$query = "SELECT * FROM users where 0=0 ";
if (! empty($key)) { $query .= "AND (name LIKE '%$key%' OR location LIKE '%$key%') "; }
if (! empty($gender)) { $query .= "AND gender = '$gender' "; }
$query .= "ORDER BY id";
$result = @ mysql_query($query, $connection) or showerror();
$entries = array();
while ($row = mysql_fetch_array($result)) { $entries[] = $row; }
mysql_close($connection) or showerror();
return $entries;
}
function getfriends($id){
$connection = @ mysql_connect(HOST, USER, PASSWORD) or die("Could not connect");
mysql_select_db(DATABASE, $connection) or showerror();
$query = "SELECT f.*, u.email, u.name, u.location, u.gender, u.photodata, u.photoname, u.phototype, u.photosize, u.userstatus
FROM friends f INNER JOIN users u ON f.fid = u.id WHERE f.uid = '$id' AND status = 'A' ORDER BY uid " ;
$result = @ mysql_query($query, $connection) or showerror();
$entries = array();
while ($row = mysql_fetch_array($result)) {
$entries[] = $row;
}
mysql_close($connection) or showerror();
return $entries;
}
function getfriendsupdate($id){
$connection = @ mysql_connect(HOST, USER, PASSWORD) or die("Could not connect");
mysql_select_db(DATABASE, $connection) or showerror();
$query = "SELECT f.*, u.email, u.name, u.location, u.gender, u.photodata, u.photoname, u.phototype, u.photosize, u.current, u.userstatus " .
"FROM friends f INNER JOIN users u ON f.fid = u.id " .
"WHERE to_days(u.current) >= (to_days(now()) - 2) AND f.uid = '$id' AND f.status = 'A' ORDER BY u.current desc " ;
//echo "$query";exit;
$result = @ mysql_query($query, $connection) or showerror();
$entries = array();
while ($row = mysql_fetch_array($result)) {
$entries[] = $row;
}
mysql_close($connection) or showerror();
return $entries;
}
function getinvint($id){
$connection = @ mysql_connect(HOST, USER, PASSWORD) or die("Could not connect");
mysql_select_db(DATABASE, $connection) or showe
PHP交友系统
4星 · 超过85%的资源 需积分: 9 126 浏览量
2008-05-31
10:27:38
上传
评论
收藏 280KB RAR 举报 
sampleSNS.rar （69个子文件） 
WPass2 
user_process.php 3KB getimage.php 811B
doc2.html 9KB register.php 1KB search.php 239B index.php 976B userdetail.php 680B usermain.php 470B script.js 181B login_process.php 141B search_results.php 672B register_process.php 5KB includes defs.php 12KB images 
bg.gif 1021B header_bg.gif 61KB more_bg.gif 400B html_bg_h.gif 382B comment_bg_h.gif 648B css_bg.gif 356B comment_bg.gif 648B go_btn.gif 267B upd_btn.gif 314B reset_btn.gif 282B more_bg_h.gif 400B login_btn.gif 285B html_bg.gif 382B form_bottom.gif 211B del_btn.gif 300B join_bg.gif 2KB h1_bg.gif 8KB logo.gif 3KB sub_btn.gif 308B go_bg.gif 267B go_bg_h.gif 268B reg_btn.gif 322B form_top.gif 212B Thumbs.db 51KB footer_bg.gif 231B css_bg_h.gif 356B left_bg_end.gif 888B
def_photo.png 35KB main_bg.gif 2KB td.png 112KB mysql_db.php 233B profile.php 1KB templates_c %%03^030^030DBB69%%userfriends.tpl.php 2KB %%F7^F7F^F7F34188%%header.tpl.php 2KB %%B6^B60^B609D7CD%%search_results.tpl.php 3KB %%89^894^8943ECAB%%memhome.tpl.php 4KB %%6E^6EC^6EC2748F%%userdetail.tpl.php 4KB %%C7^C72^C7218DFD%%friends.tpl.php 7KB %%0E^0E4^0E407559%%footer.tpl.php 744B %%C8^C82^C821C881%%register.tpl.php 4KB %%D0^D0B^D0BAFE5D%%search.tpl.php 1KB %%45^45E^45E480CD%%index.tpl.php 2KB %%BA^BAA^BAA323DD%%profile.tpl.php 4KB templates footer.tpl 642B userfriends.tpl 828B friends.tpl 3KB userdetail.tpl 2KB index.tpl 1KB memhome.tpl 2KB search.tpl 1KB register.tpl 3KB header.tpl 2KB search_results.tpl 1KB profile.tpl 3KB style.css 11KB friends.php 639B资源评论
zxm_king9332013-11-02没有部署成功- icelovely2012-04-24部署有问题 貌似没有对应的数据库
- chunguangblog2012-08-04没有部署成功
