Php+mysql Micro-Blogging system

1. Create a database

CREATE TABLE News (ID INT () not NULL auto_increment PRIMARY KEY, title VARCHAR (), dates date,connects text,hits INT (one) not NULL) ENGINE = INNODB DEFAULT CHARSET = UTF8 auto_increment =1

2. Connecting Database conn.php

<?php@mysql_connect ("127.0.0.2", "Root", "") or Die ("MySQL Connect false"), @mysql_select_db ("Wikidb") or Die (" Database connect false ");//mysql_set_charset (" Utf-8 "); mysql_query (" Set names ' Utf-8 ' ");? >

3. Set up homepage index.php

<a href= ' add.php ' > Add content </a>
<?phpinclude ("conn.php");//conn datebase;if (!empty ($_get[' id ')) {$sql = "select * from ' News ' WHERE ' id ' = '". $_get['    Id ']. "'";    $query =mysql_query ($sql);    $rs =mysql_fetch_array ($query);    $sqlup = "UPDATE ' news ' SET ' hits ' =hits+1 WHERE ' id ' = '". $_get[' id ']. "'"; mysql_query ($sqlup);}? >
5. Create an edit page edit.php
<?phpinclude ("conn.php");//conn datebase;if (!empty ($_get[' id ')) {     $sql = "Select  * FROM  ' News '  WHERE  ' id ' = ' ". $_get[' id ']." ' ";      $query =mysql_query ($sql);     $rs =mysql_fetch_array ($query);}     if (!empty ($_post[' Sub ')) {     $title =$_post[' title '];      $con =$_post[' con '];     $hid =$_post[' hid '];     $sql = "UPDATE   ' News '  SET  ' title ' = ' $title ', ' connects ' = ' $con '  where id= ' $hid '  limit 1 ';     mysql_query ($sql);    echo  "<script>alert (' update  Successful! '); location.href= ' index.php ' </script> ';}? ><form action= "edit.php"  method= "post" ><input type= "hidden"  name= "hid"   Value= "<?php echo  $rs [' id '] ?> ' > title <input type=" Text " name=" title "  Value= "<?php echo  $rs [' title '] ?> ><br> content <textarea rows= "5"  cols= "50"  name= "Con" ><?php echo  $rs [' Connects '] ?></textarea><br><input  type= "Submit"  name= "sub"  value= "POST" ></form>
6. Create Delete page del.php
<?phpinclude ("conn.php");//conn datebase;if (!empty ($_get[' del])) {$d =$_get[' del '];    $sql = "DELETE from ' News ' WHERE ' id ' = ' $d '";    mysql_query ($sql); echo "Delete successful";}? >

This article is from "Jerry" blog, please make sure to keep this source http://alipay.blog.51cto.com/7119970/1537559