PHP to achieve MySQL database connection operation and user management

PHP to achieve MySQL database connection operation and user management _php skills

Last Update:2017-01-19 Source: Internet

Author: User

Tags create database

Developer on Alibaba Coud: Build your first app with APIs, SDKs, and tutorials on the Alibaba Cloud. Read more ＞

File List ... File contents ...
dbconn.php
userlistt.php
edituser.php
editdo.php
detailuser.php
deleteuser.php
adduser.php
adddo.php

<dbconn.php>

<?php
//CREATE DATABASE connection
$con = mysql_connect ("localhost", ' root ', ') or Die (' ERROR: '. mysql_error ());
mysql_select_db (' Hyxx ', $con) or Die (' ERROR: '. mysql_error ());
mysql_query (' Set NAMES utf8 ');
? >

userlistt.php

&lt;html&gt; &lt;head&gt; &lt;meta http-equiv= "Content-type" content= "text/html;  Charset=utf-8 "&gt; &lt;title&gt; member Information list &lt;/title&gt; &lt;/head&gt; &lt;body&gt; &lt;table border=" 1 "cellspacing=" 0 " cellpadding= "0" id= "userlist" align= "center" &gt; &lt;tr align= "center" &gt; &lt;td&gt;id&lt;/td&gt; &lt;td&gt; User name &lt;/td&gt; &lt;td&gt; password &lt;/td&gt; &lt;td&gt; sex &lt;/td&gt; &lt;td&gt; age &lt;/td&gt; &lt;td&gt; Birth date &lt;/t d&gt; &lt;td&gt; Hobbies &lt;/td&gt; &lt;td&gt; registration time &lt;/td&gt; &lt;td&gt; Last login time &lt;/td&gt; &lt;td&gt; operation &lt;/td&gt
   ;
&lt;/tr&gt; &lt;?php require_once ' inc/dbconn.php ';
What is this stuff?
Date_default_timezone_set ("PRC");
  Read the data ...
  $sql = "SELECT * from user ORDER by ID ASC";
  $result = mysql_query ($sql, $con);
  $userList = ';
    while ($rs = Mysql_fetch_array ($result)) {$userList [] = $rs; }//Loop user list foreach ($userList as $user) {echo &lt;tr&gt; &lt;td& gt;&nbsp; ". $user [' id ']."&lt;/td&gt; &lt;td&gt;&nbsp;" $user [' username ']. " &lt;/td&gt; &lt;td&gt;&nbsp; "$user [' Password ']." &lt;/td&gt; &lt;td&gt;&nbsp; "$user [' sex ']." &lt;/td&gt; &lt;td&gt;&nbsp; ". $user [' age ']." &lt;/td&gt; &lt;td&gt;&nbsp; ". Date (" y-m-d ", $user [' Birthday '])." &lt;/td&gt; &lt;td&gt;&nbsp; "$user [' hobby ']." &lt;/td&gt; &lt;td&gt;&nbsp; ". Date (" y-m-d ", $user [' Add_time '])." &lt;/td&gt; &lt;td&gt;&nbsp; ". Date (" y-m-d ", $user [' Last_login '])." &lt;/td&gt; &lt;td&gt;&nbsp;&lt;a href= ' adduser.php ' &gt; Add &lt;/a&gt; &lt;a href= ' deleteuser.ph P?id= ". $user [' id ']." '); \ " &gt;&amp;nbsp Delete &lt;/a&gt; &lt;a href= ' edituser.php?id= '. $user [' id ']. "'); \" &gt;&amp;nbsp &lt;/a&gt; &lt;a href= ' detailuser.php?id= '. $user [' id ']. "'); \"
        &GT;&AMP;NBSP Check &lt;/a&gt; &lt;/td&gt; &lt;/tr&gt; "; }?&gt; &lt;/table&gt;
  &lt;/body&gt; &lt;/html&gt;

Edituser.php

&lt;! DOCTYPE HTML PUBLIC "-//W3C//DTD XHTML 1.0 transitional//en" "Http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd "&gt; &lt;html xmlns=" http://www.w3.org/1999/xhtml "&gt; &lt;head&gt; &lt;meta http-equiv=" Content-type "content=" text/html; Charset=utf-8 "/&gt; &lt;title&gt; Edit user &lt;/title&gt; &lt;/head&gt; &lt;body&gt; &lt;?php require_once ' inc/dbconn.php
';
$userId =$_get[' id '];
What is this stuff?
Date_default_timezone_set ("PRC");
  Read the data ...
  $sql = "SELECT * from user where id=". $userId;
  $result = mysql_query ($sql, $con); $user = Mysql_fetch_array ($result);?&gt; &lt;form action= "editdo.php" method= "POST" &gt; &lt;input type= "hidden" name= "user_id" value= "&lt;?php echo $user [' id ']?&gt;"/&gt; &lt;table width= "444" border= "1" align= "Center" &gt; &lt;t R&gt; &lt;td&gt; username &lt;/td&gt; &lt;td&gt;&nbsp;&lt;input type= "text" name= "user_name" size= "ten" value=&lt ;? PHP echo $user [' username ']?&gt;/&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &LT;TD&Gt; password &lt;/td&gt; &lt;td&gt;&nbsp;&lt;input type= "password" name= "password" size= "ten" value=&lt;?php echo $user [' pas Sword ']?&gt;/&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt; sex &lt;/td&gt; &lt;td&gt;&nb Sp;&lt;input type= "Radio" name= "Sex" value= "male" &lt;?php if ($user [sex]== ' 1 ') echo "checked=\" checked\ ""?&gt;/&gt ; Male &lt;input type= "Radio" name= "Sex" value= "female" &lt;?php if ($user [sex]== ' 2 ') echo "checked=\" checked\ ""?&gt;/&gt; Women &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt; age &lt;/td&gt; &lt;td&gt;&nbsp;&lt;input type=
        "Text" name= "Age" size= "3" value=&lt;?php echo $user [' age ']?&gt;/&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt; Date of birth &lt;/td&gt; &lt;td&gt;&nbsp; &lt;!--1. The date of the year was obtained. 2. The corresponding date ...
        You know the--&gt; &lt;?php $birday _y=date ("y", $user [' birthday ']);
        $birday _m=date ("M", $user [' birthday ']);
     $birday _d=date ("D", $user [' birthday ']);   ?&gt; &lt;select name= "birthday_y" &gt; &lt;option value= "1980" &lt;?php if ($birday _y==1980) echo "s Elected=\ "selected\" "?&gt; &gt;1980&lt;/option&gt; &lt;option value=" 1981 "&lt;?php if ($birday _y==1981) echo" Selected=\ "selected\" "?&gt; &gt;1981&lt;/option&gt; &lt;option value=" 1982 "&lt;?php if ($birday _y==1982) echo  "Selected=\" selected\ ""?&gt; &gt;1982&lt;/option&gt; &lt;option value= "1983" &lt;?php if ($birday _y==1983) echo "Selected=\" selected\ "?&gt; &gt;1983&lt;/option&gt; &lt;option value=" 1984 "&lt;?php if ($birday _y==1984) Ech O "selected=\" selected\ ""?&gt; &gt;1984&lt;/option&gt; &lt;option value= "1985" &lt;?php if ($birday _y==1985) EC Ho "selected=\" selected\ "?&gt; &gt;1985&lt;/option&gt; &lt;option value=" 1986 "&lt;?php if ($birday _y==1986) E Cho "selected=\" selected\ ""?&gt; &gt;1986&lt;/option&gt; &lt;option value= "1987" &lt;?php if ($birday _y==1987) echo "Selected=\" selecteD\ ""?&gt; &gt;1987&lt;/option&gt; &lt;option value= "1988" &lt;?php if ($birday _y==1988) echo "selected=\" select Ed\ "";?&gt; &gt;1988&lt;/option&gt; &lt;option value= "1989" &lt;?php if ($birday _y==1989) echo "Selected=\" Selec Ted\ "";?&gt; &gt;1989&lt;/option&gt; &lt;option value= "1990" &lt;?php if ($birday _y==1990) echo "Selected=\" Sele
          Cted\ ""?&gt; &gt;1990&lt;/option&gt; &lt;/select&gt; year &lt;select name= "Birthday_m" &gt;
          &lt;option value= "1" &lt;?php if ($birday _m==1) echo "selected=\" selected\ "";?&gt; &gt;1&lt;/option&gt; &lt;option value= "2" &lt;?php if ($birday _m==2) echo "selected=\" selected\ "";?&gt; &gt;2&lt;/option&gt; &lt;opti On value= "3" &lt;?php if ($birday _m==3) echo "selected=\" selected\ ""?&gt; &gt;3&lt;/option&gt; &lt;option value = "4" &lt;?php if ($birday _m==4) echo "selected=\" selected\ "?&gt; &gt;4&lt;/option&gt; &lt;option" 5 " ;? PHP if ($birday _m==5) ECho "selected=\" selected\ ""?&gt; &gt;5&lt;/option&gt; &lt;option value= "6" &lt;?php if ($birday _m==6) echo "SEL" Ected=\ "selected\" "?&gt; &gt;6&lt;/option&gt; &lt;option value=" 7 "&lt;?php if ($birday _m==7) echo" Selected=\ " Selected\ "";?&gt; &gt;7&lt;/option&gt; &lt;option value= "8" &lt;?php if ($birday _m==8) echo "Selected=\" selected \ "";?&gt; &gt;8&lt;/option&gt; &lt;option value= "9" &lt;?php if ($birday _m==9) echo "selected=\" selected\ "";? &G T &gt;9&lt;/option&gt; &lt;option value= "Ten" &lt;?php if ($birday _m==10) echo "selected=\" selected\ "";?&gt; &gt;10 &lt;/option&gt; &lt;option value= "One" &lt;?php if ($birday _m==11) echo "selected=\" selected\ ""?&gt; &gt;11&lt;/ Option&gt; &lt;option value= "a" &lt;?php if ($birday _m==12) echo "selected=\" selected\ "";?&gt; &gt;12&lt;/optio n&gt; &lt;/select&gt; Month &lt;select name= "Birthday_d" &gt; &lt;option value= "1" ;? PHP if ($birday _d==1echo "selected=\" selected\ "?&gt; &gt;1&lt;/option&gt; &lt;option value=" 2 "&lt;?php if ($birday _d==2) echo" Selected=\ "selected\" "?&gt; &gt;2&lt;/option&gt; &lt;option value=" 3 "&lt;?php if ($birday _d==3) echo" Selected =\ "selected\" "?&gt; &gt;3&lt;/option&gt; &lt;option value=" 4 "&lt;?php if ($birday _d==4) echo" Selected=\ "Selec Ted\ "";?&gt; &gt;4&lt;/option&gt; &lt;option value= "5" &lt;?php if ($birday _d==5) echo "selected=\" selected\ ""; ?&gt; &gt;5&lt;/option&gt; &lt;option value= "6" &lt;?php if ($birday _d==6) echo "selected=\" selected\ "";?&gt; &G t;6&lt;/option&gt; &lt;option value= "7" &lt;?php if ($birday _d==7) echo "selected=\" selected\ ""?&gt; &gt;7&lt;/ option&gt; &lt;option value= "8" &lt;?php if ($birday _d==8) echo "selected=\" selected\ ""?&gt; &GT;8&LT;/OPTION&G
          T &lt;option value= "9" &lt;?php if ($birday _d==9) echo "selected=\" selected\ "";?&gt; &gt;9&lt;/option&gt; &lt;opti On value= "10 "&lt;?php if ($birday _d==10) echo" selected=\ "selected\";?&gt; &gt;10&lt;/option&gt; &lt;option value= "one" &L t;? PHP if ($birday _d==11) echo "selected=\" selected\ ";?&gt; &gt;11&lt;/option&gt; &lt;option value=" "&lt;?php I F ($birday _d==12) echo "selected=\" selected\ "";?&gt; &gt;12&lt;/option&gt; &lt;option value= "&lt;?php" if ($bi rday_d==13) echo "selected=\" selected\ "?&gt; &gt;13&lt;/option&gt; &lt;option value=" "&lt;?php if ($birday _ D==14) echo "selected=\" selected\ "?&gt; &gt;14&lt;/option&gt; &lt;option value=" "&lt;?php if ($birday _d==15 echo "selected=\" selected\ "?&gt; &gt;15&lt;/option&gt; &lt;option value=" "&lt;?php if ($birday _d==16) Ech O "selected=\" selected\ "?&gt; &gt;16&lt;/option&gt; &lt;option value=" "&lt;?php if ($birday _d==17) echo" se Lected=\ "selected\" "?&gt; &gt;17&lt;/option&gt; &lt;option value=" "&lt;?php if ($birday _d==18) echo" selecte D=\ "selected\" ";; &gt;18&lt;/option&gt; &lt;option value= "&lt;?php if ($birday _d==19) echo" selected=\ "selected\" ";?&gt; &gt;1 9&lt;/option&gt; &lt;option value= "&lt;?php if ($birday _d==20) echo" selected=\ "selected\" ";?&gt; &gt;20&lt; /option&gt; &lt;option value= "&lt;?php if ($birday _d==21) echo" selected=\ "selected\" ";?&gt; &gt;21&lt;/opti on&gt; &lt;option value= "&lt;?php if" ($birday _d==22) echo "selected=\" selected\ ""?&gt; &gt;22&lt;/option&gt
          ; &lt;option value= "&lt;?php if" ($birday _d==23) echo "selected=\" selected\ "";?&gt; &gt;23&lt;/option&gt; &lt;o  Ption value= "&lt;?php if" ($birday _d==24) echo "selected=\" selected\ "";?&gt; &gt;24&lt;/option&gt; &lt;option Value= "&lt;?php if ($birday _d==25) echo" selected=\ "selected\";?&gt; &gt;25&lt;/option&gt; &lt;option Valu E= "&lt;?php if ($birday _d==26) echo" selected=\ "selected\" ";?&gt; &gt;26&lt;/option&gt; &lt;option value=" 27 "&lt;?php if ($birday _d==27) echo "selected=\" selected\ "";?&gt; &gt;27&lt;/option&gt; &lt;option value= "a" &lt;?php if ($ birday_d==28) echo "selected=\" selected\ "?&gt; &gt;28&lt;/option&gt; &lt;option value=" "&lt;?php if ($birda y_d==29) echo "selected=\" selected\ ""?&gt; &gt;29&lt;/option&gt; &lt;option value= "a" &lt;?php if ($birday _d== echo "selected=\" selected\ "?&gt; &gt;30&lt;/option&gt; &lt;option value=" to "&lt;?php if ($birday _d==31) E
       Cho "selected=\" selected\ "";?&gt; &gt;31&lt;/option&gt; &lt;/select&gt; Day &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt; Hobby &lt;/td&gt; &lt;td&gt;&nbsp;&lt;input type= "text" name= "hobby" s Ize= "value=&lt;?php" echo $user [' hobby ']?&gt;/&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;  Biography &lt;/td&gt; &lt;td&gt;&nbsp;&lt;textarea name= "profile" rows= "cols=" &gt;&lt;?php echo $user [' Profiles '] ?&gt; &lt;/textarea&gt; &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td colspan= "2" align= "center" &gt;&lt;input type= "Submit" V alue= "Confirm modification"/&gt;&lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;p&gt;&nbsp;&lt;/p&gt; &lt;p&gt;&nbsp;&lt;/

 p&gt; &lt;p&gt;&nbsp;&lt;/p&gt; &lt;/form&gt; &lt;/body&gt; &lt;/html&gt;

Editdo.php

&lt;?php require_once ' inc/dbconn.php ';
Get user information////////////////////$user _id = $_post[' user_id '];
$user _name = $_post[' user_name '];
$password = $_post[' password '];    
if ($_post[' sex ']== ') {$sex =1;} else if ($_post[' sex ']== ' woman ') {$sex =2;} else $sex = 3;
;
$age = $_post[' age '];
$birthday _y = $_post[' birthday_y '];
$birthday _m = $_post[' birthday_m '];
$birthday _d = $_post[' birthday_d '];
$birthday =mktime (0,0,0, $birthday _m, $birthday _d, $birthday _y);
$hobby = $_post[' hobby '];
$profile = $_post[' profile '];
$addTime =mktime ("H"), Date ("M"), date ("s"), date ("M"), Date ("D"), Date ("Y"));
  $lastLoginTime = $addTime; $sql = "Update user set Username= ' $user _name ', password= ' $password ', sex= ' $sex ', age= ' $age ', birthday= ' $birthday ', hobby
  = ' $hobby ', profile= ' $profile ' where id= ' $user _id ';
  Echo $sql;
  Execute SQL statement mysql_query ($sql, $con);
  Gets the number of rows affected $rows = Mysql_affected_rows ();
    Returns the affect number of rows//If the number of rows is affected, the &gt;=1 is added successfully, otherwise the failure if ($rows &gt;= 1) {alert ("Edit succeeded"); href ("Userlistt.php ");
    }else{alert ("Edit failed");//href ("adduser.php"); Function alert ($title) {echo "&lt;script type= ' text/javascript ' &gt;alert (' $title ');&lt;/script&gt;";} function href ($url)
{echo ' &lt;script type= ' text/javascript ' &gt;window.location.href= ' $url ' &lt;/script&gt; ';}

 ?&gt;

Detailuser.php

&lt;! DOCTYPE HTML PUBLIC "-//W3C//DTD XHTML 1.0 transitional//en" "Http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd "&gt; &lt;html xmlns=" http://www.w3.org/1999/xhtml "&gt; &lt;head&gt; &lt;meta http-equiv=" Content-type "content=" text/html; Charset=utf-8 "/&gt; &lt;title&gt; View user Details &lt;/title&gt; &lt;/head&gt; &lt;body&gt; &lt;?php require_once ' inc/
Dbconn.php ';
$userId =$_get[' id '];
What is this stuff?
Date_default_timezone_set ("PRC");
  Read the data ...
  $sql = "SELECT * from user where id=". $userId;
  $result = mysql_query ($sql, $con);
        $user = Mysql_fetch_array ($result);?&gt; &lt;table width= "444" border= "1" align= "Center" &gt; &lt;tr&gt; &lt;td&gt; User ID &lt;/td&gt; &lt;td&gt;&nbsp;&lt;?php echo $userId?&gt; &lt;/td&gt; &lt;/tr&gt;
       ;tr&gt; &lt;td&gt; username &lt;/td&gt; &lt;td&gt;&nbsp;&lt;?php echo $user [' username ']?&gt; &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt; password &lt;/td&gt; &lt;td&gt;&nbsp;&lt;?php echo $user[' password ']?&gt; &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt; sex &lt;/td&gt; &lt;td&gt; &nbsp;&lt;?php if ($user [sex]== ' 1 ') echo "male"; else if ($user [sex]== ' 2 ') echo "female"; else "confidentiality";?&gt; &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt; age &lt;/td&gt; &LT;TD&G t;&nbsp;&lt;?php echo $user [' age ']?&gt; &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt; Birth &lt;/td&gt
        ; &lt;td&gt;&nbsp; &lt;!--1. The date of the year was obtained. 2. The corresponding date ... You know the--&gt; &lt;?php $birday _y=date ("y", $user [' birthday ']); Echo $birday _y. "
        Years "; $birday _m=date ("M", $user [' birthday ']); Echo $birday _m. "
        Month "; $birday _d=date ("D", $user [' birthday ']); Echo $birday _d. "
        Day "; ?&gt; &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt; Hobby &lt;/td&gt; &lt;td&gt;&nbsp;&lt ;? PHP echo $user [' hobby ']?&gt; &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt; personal profile &lt;/td&gt; & lt;! -can also box up &Lt;td&gt;&nbsp;&lt;textarea name= "Profile" rows= "the cols=" readonly&gt;&lt;?php echo $user [' profile ']?&gt; &lt;/ textarea&gt; &lt;/td&gt;--&gt; &lt;td&gt;&nbsp;&lt;?php echo $user [' profile ']?&gt; &lt;/td&gt; &lt;/tr&gt
       ;
       &lt;tr&gt; &lt;td colspan= "2" align= "center" &gt;&lt;a href= "userlistt.php" &gt; Return to User list &lt;/a&gt;&lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;p&gt;&nbsp;&lt;/p&gt; &lt;p&gt;&nbsp;&lt;/p&gt; &lt;p&gt;&nbsp;&lt;/p&
Gt

 &lt;/body&gt; &lt;/html&gt;

deleteuser.php

<?php
//contains database files
require_once ' inc/dbconn.php ';
Gets the deleted id
$id = $_get[' id '];
$row = Delete ($id, $con);
if ($row >=1) {
  alert ("Delete succeeded");
} else{
  alert ("Delete failed");
}
Jump to the User List page
href ("userlistt.php");
function Delete ($id, $con) {
  $sql = "Delete from user where id= ' $id '";
  Perform deletion
  of mysql_query ($sql, $con);
  Gets the number of rows affected
  $rows = Mysql_affected_rows ();
  Returns the effect of rows return
  $rows
;
Function alert ($title) {
  echo "<script type= ' text/javascript ' >alert (' $title ');</script>";
}
function href ($url) {
  echo "<script type= ' text/javascript ' >window.location.href= ' $url ' </script>";
}
?>

adduser.php

&lt;! DOCTYPE HTML PUBLIC "-//W3C//DTD XHTML 1.0 transitional//en" "Http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd "&gt; &lt;html xmlns=" http://www.w3.org/1999/xhtml "&gt; &lt;head&gt; &lt;meta http-equiv=" Content-type "content=" text/html; Charset=utf-8 "/&gt; &lt;title&gt; new users &lt;/title&gt; &lt;/head&gt; &lt;body&gt; &lt;form action=" adddo.php "method=" Post "&gt; &lt;input type=" hidden "name=" user_id "value=" "/&gt; &lt;table width=" 444 "border=" 1 "align=" center "&gt; &lt;tr&gt; &lt;td&gt; User name &lt;/td&gt; &lt;td&gt;&nbsp;&lt;input type=" text "Name=" user_name "s Ize= "Ten"/&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt; password &lt;/td&gt; &lt;td&gt;&nbsp;&lt ; input type= "password" name= "password" size= "ten"/&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt; Don't &lt;/td&gt; &lt;td&gt;&nbsp;&lt;input type= "Radio" name= "Sex" value= "male" checked= "checked"/&gt; Male &lt;input type= " Radio "name=", "Sex" value= "female" /&gt; Women &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt; age &lt;/td&gt; &lt;td&gt;&nbsp;&lt;inpu
        T type= "text" name= "Age" size= "3"/&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt; Birth date &lt;/td&gt; &lt;td&gt;&nbsp; &lt;select name= "birthday_y" &gt; &lt;option value= "1980" &GT;1980&LT;/OPTION&G
          T &lt;option value= "1981" &gt;1981&lt;/option&gt; &lt;option value= "1982" &gt;1982&lt;/option&gt; &lt;opti On Value= "1983" &gt;1983&lt;/option&gt; &lt;option value= "1984" &gt;1984&lt;/option&gt; &lt;option value = "1985" &gt;1985&lt;/option&gt; &lt;option value= "1986" &gt;1986&lt;/option&gt; &lt;option value= "1987" & Gt;1987&lt;/option&gt; &lt;option value= "1988" &gt;1988&lt;/option&gt; &lt;option value= "1989" &gt;1989& Lt;/option&gt; &lt;option value= "1990" &gt;1990&lt;/option&gt; &lt;/select&gt; year &L T;select NAMe= "Birthday_m" &gt; &lt;option value= "1" &gt;1&lt;/option&gt; &lt;option value= "2" &gt;2&lt;/option&gt;  &lt;option value= "3" &gt;3&lt;/option&gt; &lt;option value= "4" &gt;4&lt;/option&gt; &lt;option Value= "5" &gt;5&lt;/option&gt; &lt;option value= "6" &gt;6&lt;/option&gt; &lt;option value= "7" &gt;7&lt;/
          option&gt; &lt;option value= "8" &gt;8&lt;/option&gt; &lt;option value= "9" &gt;9&lt;/option&gt; &lt;option value= "A" &gt;10&lt;/option&gt; &lt;option value= "One" &gt;11&lt;/option&gt; &lt;option Valu E= "A" &gt;12&lt;/option&gt; &lt;/select&gt; month &lt;select name= "Birthday_d" &gt; ; option value= "1" &gt;1&lt;/option&gt; &lt;option value= "2" &gt;2&lt;/option&gt; &lt;option value= "3"
          ;3&lt;/option&gt; &lt;option value= "4" &gt;4&lt;/option&gt; &lt;option value= "5" &gt;5&lt;/option&gt; &lt;option value= "6" &gt;6&lt;/option&gt; &lt;option value= "7" &gt;7&lt;/option&gt; &lt;option value= "8" &gt;8&lt;/option &gt; &lt;option value= "9" &gt;9&lt;/option&gt; &lt;option value= "Ten" &gt;10&lt;/option&gt; ; option value= "one" &gt;11&lt;/option&gt; &lt;option value= "&gt;12&lt;/option&gt; &lt;option value=" 1 3 "&gt;13&lt;/option&gt; &lt;option value=" &gt;14&lt;/option&gt; &lt;option value= "&gt;15&lt;/opt"
          ion&gt; &lt;option value= "&gt;16&lt;/option&gt; &lt;option value=" &gt;17&lt;/option&gt; &lt;option value= "A" &gt;18&lt;/option&gt; &lt;option value= "A" &gt;19&lt;/option&gt; &lt;option val Ue= "&gt;20&lt;/option&gt; &lt;option value=" &gt;21&lt;/option&gt; &lt;option value= "&gt;22&lt"
          ;/option&gt; &lt;option value= "a" &gt;23&lt;/option&gt; &lt;option value= "a" &gt;24&lt;/option&gt; &lt;option value="&gt;25&lt;/option&gt; &lt;option value=" &gt;26&lt;/option&gt; &lt;option value= "&gt;27&lt;/o"
          Ption&gt; &lt;option value= "a" &gt;28&lt;/option&gt; &lt;option value= "a" &gt;29&lt;/option&gt; &lt;option value= "&gt;30&lt;/option&gt; &lt;option value=" &gt;31&lt;/option&gt; &lt;/select&
          Gt Day &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt; Hobby &lt;/td&gt; &LT;TD&GT;&NBSP;&LT;INP UT type= "text" name= "hobby" size= "/&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt; Personal Profile &lt;/td&
        Gt
       &lt;td&gt;&nbsp;&lt;textarea name= "Profile" rows= "ten" cols= "&gt;&lt;/textarea&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td colspan= "2" align= "center" &gt;&lt;input type= "Submit" value= "Add user"/&gt;&lt;/td&gt; &lt;/tr&
 Gt &lt;/table&gt; &lt;p&gt;&nbsp;&lt;/p&gt; &lt;p&gt;&nbsp;&lt;/p&gt; &lt;p&gt;&nbsp;&lt;/p&gt; &lt;/form&gt; &lt;/body&gt; &lt;/html&gt;

Adddo.php

&lt;?php require_once ' inc/dbconn.php ';
Get user information////////////////////$user _id = $_post[' user_id '];
$user _name = $_post[' user_name '];
echo $user _name;
$password = $_post[' password '];    
if ($_post[' sex ']== ') {$sex =1;} else if ($_post[' sex ']== ' woman ') {$sex =2;} else $sex = 3;
;
$age = $_post[' age '];
$birthday _y = $_post[' birthday_y '];
$birthday _m = $_post[' birthday_m '];
$birthday _d = $_post[' birthday_d '];
$birthday =mktime (0,0,0, $birthday _m, $birthday _d, $birthday _y);
$hobby = $_post[' hobby '];
$profile = $_post[' profile '];
$addTime =mktime ("H"), Date ("M"), date ("s"), date ("M"), Date ("D"), Date ("Y"));
  $lastLoginTime = $addTime;
  $sql = INSERT INTO User (Username,password,sex,age,birthday,hobby,profile,add_time,last_login).
  "Values (' $user _name ', ' $password ', ' $sex ', ' $age ', ' $birthday ', ' $hobby ', ' $profile ', ' $addTime ', ' $lastLoginTime ')";
  Echo $sql;
  Execute SQL statement mysql_query ($sql, $con);
  Gets the number of rows affected $rows = Mysql_affected_rows (); Returns the number of rows affected//If the number of rows is &gt;=1,Add success, otherwise failure if ($rows &gt;= 1) {alert ("Add success");
  href ("userlistt.php");
    }else{alert ("Add failed");//href ("adduser.php"); Function alert ($title) {echo "&lt;script type= ' text/javascript ' &gt;alert (' $title ');&lt;/script&gt;";} function href ($url)
{echo ' &lt;script type= ' text/javascript ' &gt;window.location.href= ' $url ' &lt;/script&gt; ';}

 ?&gt;

This article is an English version of an article which is originally in the Chinese language on aliyun.com and is provided for information purposes only. This website makes no representation or warranty of any kind, either expressed or implied, as to the accuracy, completeness ownership or reliability of the article or any translations thereof. If you have any concerns or complaints relating to the article, please send an email, providing a detailed description of the concern or complaint, to info-contact@alibabacloud.com. A staff member will contact you within 5 working days. Once verified, infringing content will be removed immediately.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

Get Started for Free

Sales Support

1 on 1 presale consultation

Chat Contact Sales
After-Sales Support

24/7 Technical Support 6 Free Tickets per Quarter Faster Response

Open a Ticket
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.

Learn More