会员管理系统2010.3.4

一个基本会员管理系统——实现会员登录、会员注册、会员修改自身资料、管理员删除会员资料、管理员修改会员资料

一、数据库规划

 通过MySQL直接创建相关表格  create database、create table

查看表的内容 通过select *from table

二、公共程序

1、创建数据库连接 sql_connect.php

<?

$link=mysql_connect(...)or die(...)

mysql_select_db(...)or die(...)

?>

2、网页重导向

<?php

Function my_header($redirect)

{

echo "<script language=/"javascript/">"; //JavaScript协助转向

echo "location.href"='".$redirect."';

echo "</script>";

return；

}

Function my_msg($msg,$redirect)

{

echo "<SCRIPT Language=javascript>";

echo "window.alert('".$msg."')";

echo "<SCRIPT>";

echo "<script language =/"javascript"/>";

echo "location.href='".$redirect."'";

echo "</script>";

return;

}

?>

3、会员登录(基本函数)

<form name="form1" action = "login_chk.php" method = "post">   //

$sqlstr = "select * from member where id = '".$_POST['user_id']."' and passwd = '".$_POST['user_passwd']."' and status =1";

$result = mysql_query($sqlstr,$link);

$row=mysql_fetch_array($result,MYSQL_BOTH);

if (mysql_num_rows($result)==1&& $row["rank"]==100){

setcookie("cookie_chk","adm_logined");

setcookie("cookie_id",$_POST['id']);

my_header("adm.php");