Php+mysql+jquery implementation of--php _php tutorial to release Weibo program

In the previous article, "Php+mysql+jquery implementation of the microblogging program--jquery," explains how to use jquery to achieve the real-time word count of input forms and the function of Ajax to submit data to the background. This article will show you how the background handles the data submitted by the foreground and returns the results.

Let's start by explaining the business process for this example:

1, the front-end user input content, and the input of the content of the words in real-time statistics.

2, the user submits the data, jquery realizes through the Ajax sends the data in the background.

3, the background PHP receives the data submitted form, and the data for the necessary security filtering.

4. Background PHP connects to MySQL database and writes the submitted form data to the corresponding data table.

5, backstage to return the successful result data content, and through Ajax to insert the returned data content into the front page.

The above 1, 2 steps in the previous article: The jquery chapter has been explained, this article will complete the rest of the section.

Data table First we want to prepare a data table, the table structure is as follows:

 
  
  

  
   
   
CREATE TABLE ' say ' ( 
  
   
   
 ' id ' int (one) not NULL auto_increment, 
  
   
   
 ' userid ' int (one) not NULL default ' 0 ', 
  
   
   
 ' Content ' varchar (+) not NULL, 
  
   
   
 ' Addtime ' int (ten) is not NULL, 
  
   
   
 PRIMARY KEY ENGINE=MyISAMCHARSET   =UTF8
 
  
  

Note that in this example, the Time field: the type of addtime is set to int, it is convenient for subsequent time processing, and in many applications such as the Discuz forum, the time type is converted to a digital type.

Timeline processing functions and formatted output list functions: The timeline handler function, which is to convert the time to what we see like "5 minutes Ago", "Yesterday 10:21", and more, we can look at the article I wrote earlier: PHP implements the timeline function, the code is as follows:

 
 

  
  

  
/* Time conversion function */
  
  

  
function Trantime ($time) {
  
  

  
 $ Rtime  =  Date ("m-d h:i", $time); 
  
  

  
 $ Htime  =  Date ("H:i", $time); 
  
  

  
 $  Time  Time = Time ()-$time; 
  
  

  

  
  

  
if ($time  <   ) {
  
  

  
 $ Str  =  ' Just ' ; 
  
  

  
}
  
  

  
else if ($time  <     ) {
  
  

  
 $ min  =   Floor ($time/60); 
  
  

  
 $ Str = $min. ' Minutes ago '; 
  
  

  
}
  
  

  
else if ($time  <     *) {
  
  

  
 $ h  =   Floor ($time/(60*60)); 
  
  

  
 $ Str = $h. ' Hour ago '. $htime; 
  
  

  
}
  
  

  
else if ($time  <    * 3) {
  
  

  
 $ D  =   Floor ($time/(60*60*24)); 
  
  

  
if ($D==1)
  
  

  
 $ Str  =  ' Yesterday ' . $rtime; 
  
  

  
Else
  
  

  
 $ Str  =  ' The day before yesterday ' . $rtime; 
  
  

  
}
  
  

  
else {
  
  

  
 $ Str = $rtime; 
  
  

  
}
  
  

  
return $str;
  
  

  
}
 
 

The formatted output function is the function to output the user information and the published content and time in a certain format to the front page, the code is as follows:

 
 

  
  

  
function Formatsay ($say, $dt, $uid) {
  
  

  
 $ say = Htmlspecialchars (Stripslashes ($say)); 
  
  

  

  
  

  
Return
  
  

  
   <  div    class   =   "saylist"      
  
  

  
 < a   href="#"><img   src = "images/". $uid. JPG "   width="  " height=" " alt=" Demo "   />  
  
  

  
  a > 
  
  

  
 < Div   class="saytxt"> 
  
  

  
 < P > < Strong > < a   href="#">demo_ '. $uid. '   a>  strong>  '.   
  
  

  
Preg_replace ('/(?: http|https|ftp): \/\/(?: [a-z0-9][a-z0-9_-]* (?: \. [A-z0-9] [a-z0-9_-]*) +):? (\d+)? \/? [^\s\ "\ ']+)/I ',
  
  

  
 ' < a   href="$"   rel="nofollow"   Target = "Blank" >  $   a>', $say). '  
  
  

  
  P >  
  
  

  
 < Div   class="date">'. Trantime ($DT). '   div >   
  
  

  
  Div > 
  
  

  
 < Div   class="clear">  div>   
  
  

  
  Div > ' 
  
  

  
; }
 
 

Put all two of these functions into function.php, ready to be called at any time.

submit.php processing form data

In the previous article, we know that jquery submits the data from the front end to the submit.php in the background via Ajax. Then submit is to complete all the following tasks. Please look at the code:

 
 

  
  

  
Require_once (' connect.php '); Database Connection File
  
  

  
Require_once (' function.php '); Function call File
  
  

  

  
  

  
$ txt = stripslashes ($_post[' saytxt ');//Get Submitted data
  
  

  
$ txt = mysql_real_escape_string (Strip_tags ($txt), $link);//filter HTML tags and escape special characters
  
  

  
if (Mb_strlen ($txt)<1  | | mb_strlen ($txt)>
  
  

  
Die ("0"); Determine if the number of input characters meets the requirements
  
  

  

  
  

  
$  Time  Time =time ();//Get Current time
  
  

  
$ userid = Rand (0,4); 
  
  

  
Inserting data into a data table
  
  

  
$ Query = mysql_query ("INSERT into say (userid,content,addtime) VALUES (' $userid ', ' $txt ', ' $time ')"); 
  
  

  
if (Mysql_affected_rows ($link)!=1)
  
  

  
Die ("0");
  
  

  
Echo Formatsay ($txt, $time, $userid); Call function Output result
 
 

Note that in this case, the user ID (userid) is randomly processed for demonstration purposes, and the actual application is to get the ID of the current user. In addition to the database connection files, you can write their own, in the download I provided the demo also has this file.

Finally, go back to the front page index.php. Index.php mainly in addition to provide input entry, but also to take the background processing the returned results, and to the data in the database to display. The code is as follows:

 
 

  
  

  
 Php 
  
  

  
Define (' Include_check ', 1);
  
  

  
Require_once (' connect.php ');
  
  

  
Require_once (' function.php ');
  
  

  

  
  

  
$ Query = mysql_query ("SELECT * from say ORDER BY id DESC limit 0,10"); 
  
  

  
While ($row=mysql_fetch_array($query)) {
  
  

  
 $ saylist. = Formatsay ($row [content], $row [Addtime], $row [UserID]; 
  
  

  
}
  
  

  
?> 
  
  

  
<  form    id   =   "MyForm"    action   =   "say.php"    method   =   "POST"  span class= "tag" >>   
  
  

  
   <  h3  >  span class= "tag" >< span    class   =   "counter"  >    !-- span  >   tell me what you are doing ...  !-- h3  >      
  
  

  
   <  textarea    span class= "attribute" >name  =   "saytxt"    id   =   "saytxt"    class   =   "input"    tabindex   =   "1"    rows   =   "2"    cols   =   "Max"  >  !-- textarea  >     
  
  

  
 < P > 
  
  

  
 < input   type="Submit"   class="SUB_BTN"     value = "commit" disabled = "   Disabled "   /> 
  
  

  
 < span   id="msg">  span >   
  
  

  
  P > 
  
  

  
 form > 
  
  

  
< Div   class="clear">  div >   
  
  

  
< Div   id="saywrap"> 
  
  

  
 PHP echo $sayList; ?> 
  
  

  
 Div >  
 
 

At this point, this example from the front-end interaction to the background processing program, all completed, interested students have better hands-on, to learn from the fun.

http://www.bkjia.com/PHPjc/587917.html www.bkjia.com true http://www.bkjia.com/PHPjc/587917.html techarticle In the previous article, "Php+mysql+jquery implementation of the microblogging program jquery," explains how to use jquery to implement the input form of real-time word count and Ajax to submit data to the background function. This article ...

