PHP link MYSQL Edit

Source: Internet
Author: User
PHP link MYSQL edit question xx. php? Id = 123 & nbsp; here, the related values in SQL are opened, and the original values are displayed. & nbsp; then you can edit & nbsp; and save it to the original ID, how to write such a PHP page. I thought about the PHP link MYSQL editing problem for a long time.
Xx. php? Id = 123

Here, we will open the related values in SQL, display the original values in them, and then edit and save them to the original ID. how can we write such a PHP page. I thought about it for a long time.

------ Solution --------------------
Query display and modification must be completed separately
Query

$ Link = @ mysql_connect (LOCALLHOST, USER, PASS) or die ('database connection failed! ');
Mysql_select_db (DBNAME, $ link );
Mysql_query ('set name gb2312 ');
$ SQL = "select * from table name ";
$ Result = mysql_query ($ SQL, $ link );
Echo' ';
While ($ row = mysql_fetch_assoc ($ result )){
Echo'';
Echo''. $ Row ['id'].'';
......
Echo'';
}
Echo'';
Mysql_free_result ($ result );
Mysql_close ($ link );

Modify
On the form page, upload the ID of the data you want to modify to the editing page, click "modify" on the editing page, and then upload it to the dynamic page (perform the above operations to connect to the database and perform modifications)

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.

A Free Trial That Lets You Build Big!

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

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

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

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.