PHP + MYSQL allows you to add, delete, modify, and query. add, delete, and add, PHP, mysql tutorial

PHP + MYSQL allows you to add, delete, modify, and query, and add and delete mysql. PHP + MYSQL allows you to add, delete, modify, query, and delete files in mysql .. File content .. Dbconn. phpuserListt. phpeditUser. phpeditDo. phpdetailUser. phpdeleteUser. phpaddUser. phpa PHP + MYSQL allows you to add, delete, modify, and query users, and add and delete mysql users.

File list .. File content ..

Dbconn. php
UserListt. php
EditUser. php
EditDo. php
DetailUser. php
DeleteUser. php
AddUser. php
AddDo. php

<? Php // create a 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');?>

 Member Information List      
 
 <? Phprequire_once 'Inc/dbConn. php'; // What is this .. Date_default_timezone_set ("PRC"); // read 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" 
   ";}?> 
  
   
  
  
 
   
 
    
Id
 
    
User name
 
    
Password
 
    
Gender
 
    
Age
 
    
Date of birth
 
    
Hobbies
 
    
Registration time
 
    
Last logon time
 
    
Operation
 
   
 
    
". $ User ['id']."
 
    
". $ User ['username']."
 
    
". $ User ['password']."
 
    
". $ User ['sex']."
 
    
". $ User ['age']."
 
    
". Date (" Y-m-d ", $ user ['birthday'])."
 
    
". $ User ['hobby']."
 
    
". Date (" Y-m-d ", $ user ['add _ time'])."
 
    
". Date (" Y-m-d ", $ user ['last _ login'])."
 
    
Add & nbsp delete & nbsp change & nbsp check
 
   
 
 
  

 Edit user<? Php require_once 'Inc/dbConn. php'; $ userId = $ _ GET ['id']; // What is this .. Date_default_timezone_set ("PRC"); // read data... $ SQL = "select * from user where id =". $ userId; $ result = mysql_query ($ SQL, $ con); $ user = mysql_fetch_array ($ result);?>

<? Phprequire_once 'Inc/dbConn. php '; ////////////// /// // $ user_id = $ _ POST ['User _ id']; $ user_name = $ _ POST ['User _ name']; $ password = $ _ POST ['password']; if ($ _ POST ['sex'] = 'male') {$ sex = 1;} else if ($ _ POST ['sex'] = 'female ') {$ 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); $ holobby =$ _ POST ['hobby']; $ profile =$ _ POST ['Profile ']; $ addTime = mktime (date ("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', holobby = '$ hoby ', profile = '$ profile' where id = '$ user_id' "; echo $ SQL; // execute the SQL statement mysql_query ($ SQL, $ con ); // Obtain the number of affected rows $ rows = mysql_affected_rows (); // return the number of affected rows. // if the number of affected rows is greater than or equal to 1, the value is successfully added, otherwise, if ($ rows> = 1) {alert ("edited successfully"); href ("userListt. php ");} else {alert (" edit failed "); // href (" addUser. php ");} function alert ($ title) {echo"