PHP 5 sample code for managing any database table in MySQL 5 (I) _ PHP Tutorial

Source: Internet
Author: User
Sample code for PHP 5 to manage any database table in MySQL 5 (1 ). Php (as the mainstream development language) 5 + MySQL (the best combination with PHP) 5 + apache (the most popular WEB server platform on the Unix platform) 2 is already the most popular site creation mode. 5 + MySQL (the best combination with php) 5 + apache (the most popular WEB server platform on the Unix platform) 2 is already the most popular site creation mode. It is a little tedious to operate on MySQL (the best combination with PHP) tables only using the SQL language. Therefore, I wrote a set of php (as the mainstream development language) code for adding, deleting, and modifying records to various tables by referring to the code on the Internet. For your reference and entertainment only.

The code below is available in php (as the mainstream development language) 5 + MySQL (the best combination with PHP) 5 + apache (the most popular WEB server platform on Unix) 2 for WinXp.

First, describe the applicability of the code. according to the characteristics of most tables, each table has an id. Therefore, the code applies to the table with the first column id. The name does not matter. it is important that the code performs operations based on the first column of Prima (the most complete VM Management System) ry key by default. There are no other restrictions. this code can operate any column table. Disadvantage: no input review is conducted. Therefore, do not enter blank rows or mismatched types when entering the record. this must be used with the table creation of MySQL (the best combination with PHP.

Note: reminder! When copying the above code, be sure to remove the tab before each line of code in the editor. otherwise, php (as the mainstream development language) 5 cannot be compiled.
In addition, $ database in each file is currently sunsite, and $ table is software, which can be modified as needed.

The first is index. php (as the mainstream development language). The main function is to allow users to enter the table name, and then click the View button to view the table content. It is also the default homepage.

// Index. php (as the mainstream development language)



Admin

Please input the table name



Then tables. php (as the mainstream development language) is used to display the table content. With the entry for adding, deleting, and modifying.
// Tables. php (as the mainstream development language)


Current table


$ Database = "sunsite"
$ Tablename = $ _ REQUEST [tablename];
Echo "Data from $ tablename"
MySQL (best combination with PHP) _ connect ("localhost", "root", "") or die ("Problem connecting to DataBase ");
$ Query = "show columns from $ tablename"
$ Result = MySQL (the best combination with PHP) _ db_query ($ database, $ query );
$ Column = 0;
If ($ result)
{
Echo "Found these entries in the database:

"
Echo"






$ Query = "select * from $ tablename"
$ Result = MySQL (the best combination with PHP) _ db_query ($ database, $ query );
If ($ result)
While ($ r = MySQL (the best combination with PHP) _ fetch_array ($ result ))
{
Echo"





"While ($ r = MySQL (the best combination with PHP) _ fetch_array ($ result )){Echo" "$ Column = $ column + 1;}Echo" "MySQL (the best combination with PHP) _ free_result ($ result ); "For ($ col = 0; $ col <$ column; $ col ++) echo" "Echo" "}Echo"
$ R [0]
$ R [$ col]
"
}
Else echo "No data ."
MySQL (the best combination with PHP) _ free_result ($ result );
If ($ column! = 0) // ($ tablename = "software" | $ tablename = "techtalk ")
Echo"



  • (As the mainstream development language) "> Home
  • (As the mainstream development language )? Tablename = $ tablename "> Add a new entry
  • (As the mainstream development language )? Tablename = $ tablename "> Edit an entry
  • (As the mainstream development language )? Tablename = $ tablename "> Delete an entry
"
?>

To be continued.

Http://www.bkjia.com/PHPjc/508894.htmlwww.bkjia.comtruehttp://www.bkjia.com/PHPjc/508894.htmlTechArticlephp (as the mainstream development language) 5 + MySQL (the best combination with PHP) 5 + apache (the most popular WEB server platform for Unix) 2 is already the most popular site creation mode. In...

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.