解决方案 »

  1.   

    插入数据库:
    <?
    require('database.php');
    //------------------------------------
    $ip=getenv('REMOTE_ADDR');
    $conn=mysql_connect($mysql_server_name,$mysql_username,$mysql_password,$mysql_database);
    $sql="INSERT INTO `liuyanban` ( `id` , `name` , `sex` , `tel` , `email`,`info` , `ip` , `time_at` ) VALUES ('', '$name', '$sex', '$tel','$email', '$info', '$ip', NOW( ) )";
    mysql_select_db($mysql_database,$conn);
    $result=mysql_query($sql);
    $id = mysql_insert_id();
    mysql_close($conn);
    header('location:liuyanban.php');
    ?>
    <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
    <html>
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
    <title>无标题文档</title>
    </head><body>
    <?
    echo $name;
    echo $sex;
    echo $tel;
    echo $email;
    echo $info;
    ?><p>&nbsp;</p>
    </body>
    </html>
      

  2.   

    显示页:
    <?
    $mysql_server_name="localhost";
    $mysql_username="root";
    $mysql_password="";
    $mysql_database="information";
    //-----------
        if(!$name || !$password)
         {
         header('location:goon_false.php');
         }
        else{
            $sql="SELECT name FROM `lend` WHERE name = '$name' ";
       $conn=mysql_connect($mysql_server_name,$mysql_username,$mysql_password,$mysql_database);
       $result=mysql_db_query($mysql_database,$sql,$conn);
       $row=mysql_fetch_row($result);
        //显示
       //print_r($row);
       mysql_free_result($result);
      if(!$row)
     {
      header('location:goon_false.php');
      break;
      }
      else{
       $sql="SELECT password FROM `lend` WHERE name='$name' AND password=sha1('$password')";
       $conn=mysql_connect($mysql_server_name,$mysql_username,$mysql_password,$mysql_database);
       $result=mysql_db_query($mysql_database,$sql,$conn);
       $row=mysql_fetch_row($result);
       //显示
       //print_r($row);       
       mysql_free_result($result);        
       if(!$row)
       {
       header('location:goon_false.php');
       break;
       }

       }

                
       $sql="SELECT count(*) FROM `liuyanban` ";
       $conn=mysql_connect($mysql_server_name,$mysql_username,$mysql_password,$mysql_database);
       $result=mysql_db_query($mysql_database,$sql,$conn);
       $row1=mysql_fetch_row($result);
       //显示
       //print_r($row1);       
       mysql_free_result($result);
       $row1[0]+=1;     

     
    $conn=mysql_connect($mysql_server_name,$mysql_username,$mysql_password,$mysql_database);
    $sql="SELECT id , name ,sex , tel, email,  info , ip, DATE_FORMAT(time_at,'%Y年 %m月 %d日 %T')   FROM `liuyanban`   ORDER BY `id` DESC";
    $result=mysql_db_query($mysql_database,$sql,$conn);
    while($row=mysql_fetch_row($result))
    {
    $row1[0]--;
    if($row[2]==1)
    $men="先生";
    else
    $men="小姐";

    ?><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
    <html>
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
    <title>留言板</title>
    <style type="text/css">
    <!--
    .style1 {
    font-size: 16px;
    font-family: "华文新魏";
    }
    .style3 {
    font-size: 14px;
    color: #FF6600;
    }
    .style5 {color: #0066FF}
    .style7 {
    font-size: 18px;
    color: #FF3333;
    }
    .style8 {
    font-size: 20px;
    color: #0033CC;
    }
    .style9 {color: #9933CC}
    .style10 {color: #996666}
    body,td,th {
    font-size: 16px;
    }
    .style11 {
    font-size: 24px;
    color: #CC3399;
    }
    .style12 {font-size: 12px}
    -->
    </style>
    <script language="JavaScript" type="text/JavaScript">
    <!--
    function MM_jumpMenu(targ,selObj,restore){ //v3.0
      eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
      if (restore) selObj.selectedIndex=0;
    }function MM_popupMsg(msg) { //v1.0
      alert(msg);
    }
    //-->
    </script>
    </head><body>
    <table width="950" border="0" cellpadding="0" cellspacing="1" bgcolor="#0033FF">
      <tr>
        <td bgcolor="#66FFCC" >
        <span class="style3"><?=$row[7] ?></span>(<span class="style5"><?=$row[6]?></span>) &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[<A href="modify.php?id=<?=$row[0] ?>del1=<?=$del1?>" class="style12"  target="_blank">修改</A>]&nbsp;[<A href="del.php?id=<?=$row[0] ?>del1=<?=$rand ?>del2=<?=$i?>" class="style12" onClick="MM_popupMsg('确定删除本条留言?')">删除</A>]<br>
    <span class="style7"><?=$row[1] ?></span><span class="style8"><?=$men ?></span>&lt;<span class="style9"><a href="mailto:<?=$row[4] ?>" target="_blank"><?=$row[4] ?></a></span>&gt; <span class="style10">第<span class="style11">&nbsp;
        <?=$row1[0] ?>
        &nbsp;</span>留言</span>:</td>
      </tr>
      <tr>
        <td width="" bgcolor="#FFFFFF"><span class="style1"><?=nl2br($row[5]) ?></span></td>
      </tr>
    </table><br>
    <hr size=2 color=#999999 width="950" align="left"><br>
    <?
    //print_r([row]);
    }
    mysql_free_result($result);
    ?>
    <table width="950" border="0" cellpadding="0" cellspacing="1" id="02">
      <tr>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      <tr align="right" valign="middle">
        <td colspan="2"><form name="form1" method="post" >
            GO
                <select name="menu1" onChange="MM_jumpMenu('parent',this,0)">
                  <option selected>----</option>
                  <option value="lyshow.php">01</option>
                  <option value="lyshow002.php">02</option>
                </select>
        </form></td>
      </tr>
    </table>
    <p>&nbsp;</p>
    </body>
    </html>
      

  3.   

    http://download.csdn.net/source/779143
    里面很详细,有你想要的所有
      

  4.   

    学校都没开php的!
    自己看看!