Home Backend Development PHP Tutorial Technical principles of generating HTML with PHP_PHP tutorial

Technical principles of generating HTML with PHP_PHP tutorial

Jul 21, 2016 pm 02:52 PM
database html mysql php one principle Can exist technology database New generate of customize

1) Create a new database in MYSQL and name it database (can be customized), create a new table and name it news (because it is a news release, just give it a name that is easy to remember, it can be customized) ), and then create these field names:


id (auto-increment, this is the key, type: INT)
title (as the name suggests, news title, the type can be TEXT)
content (news content, type can be TEXT)
path (HTML file path, type can be TEXT)

2) Create conn.php


This is the PHP file that connects to the database. You can put the statements to connect the data in this file separately. In the future, multiple files that need to connect to the database can directly reference this file.


3) Design a form for adding news add.form. The simple source code is as follows:


//Submit to add.php
News title:

News content:






4) Create an HTML template, save it as model.htm, and add.php can be in the same directory.


Sample source code:




The title of this news:{title}
Content of this news:{content}




The content within { } curly brackets is the content to be replaced. The design of the entire static template can be based on your own ideas, but the content to be replaced within { } must be included, such as {title}, {content} above; Kaka~ To put it simply, after designing a good-looking news template, just put the tags to be replaced, such as {title}, {content}, etc. where needed.

5) Detailed explanation of add.php source code


require_once(“conn.php”); //Reference conn.php and connect to the database
$title=$_POST[“title”];
$content=$_POST[“content”]; //Get form variables

//The following creates a text document, and its value is automatically counted
$countfile="count.txt";
if(!file_exists($countfile))
{
fopen($countfile,"w"); //If this file does not exist, it will automatically create one
}
$fp=fopen($countfile,"r");
$num=fgets($fp,20);
$num=$num+1; //The value is automatically increased by one each time
fclose($fp);
$fp=fopen($countfile,"w");
fwrite($fp,$num); //Update its value
fclose($fp);
//Use the automatically counted value above to obtain the HTML path $path
$houzui=”.html”;
$path=$num.$houzui;
//The path formed in this way grows automatically, such as 1.html, 2.html, 3.html………. Adding a piece of news will automatically add 1

//The following uses SQL statements to add data to the table news

$sql=”insert into news (title,content,path) values ​​(‘”.$title.”’,’”.$content.”’,’”.$path.”’)”;
$query=mysql_query($sql);
//The following is the key point, replace the {title}, {content} tags in the template with the data obtained from the form

$fp=fopen(“model.htm”,”r”) //Read-only open template
$str=fread($fp,filesize(“mode.htm”));//Read the content in the template
$str=str_replace(“{title}”,$title,$str);
$str=str_replace(“{content}”,$content,$str);//Replace content
fclose($fp);

$handle=fopen($path,”w”); //Open news path in writing mode
fwrite($handle,$str); //Write the replaced content into the generated HTML file
fclose($handle);
//Finishing work:

echo "View the news just added";
OK, the entire sample source code for generating HTML ends here. The key is to use the replacement method.
$str=str_replace("{replaced content}",$replaced content,$str);

Therefore, to summarize the above approach: first design the news template, use { } to put the content that needs to be replaced into the corresponding position in the template, then design the form, and then the final form handler, put the variables obtained from the form Just replace the corresponding content in the template, so that different HTML will be generated every time; if you need to modify the content of the HTML, the same is true. After obtaining the modified form content, first update the database with the update statement, and then replace the HTML in the template again. The content is enough; if you want to delete it, first delete the content to be deleted in the table, and then use unlink($path) to delete the physical HTML file.

www.bkjia.comtruehttp: //www.bkjia.com/PHPjc/371664.htmlTechArticle1) Create a new database in MYSQL and name it database (can be customized), create a new table and name it news (because it is a news release, just give it a name that is easy to remember and can be customized),...
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

MySQL and phpMyAdmin: Core Features and Functions MySQL and phpMyAdmin: Core Features and Functions Apr 22, 2025 am 12:12 AM

MySQL and phpMyAdmin are powerful database management tools. 1) MySQL is used to create databases and tables, and to execute DML and SQL queries. 2) phpMyAdmin provides an intuitive interface for database management, table structure management, data operations and user permission management.

Oracle's Role in the Business World Oracle's Role in the Business World Apr 23, 2025 am 12:01 AM

Oracle is not only a database company, but also a leader in cloud computing and ERP systems. 1. Oracle provides comprehensive solutions from database to cloud services and ERP systems. 2. OracleCloud challenges AWS and Azure, providing IaaS, PaaS and SaaS services. 3. Oracle's ERP systems such as E-BusinessSuite and FusionApplications help enterprises optimize operations.

HTML vs. CSS and JavaScript: Comparing Web Technologies HTML vs. CSS and JavaScript: Comparing Web Technologies Apr 23, 2025 am 12:05 AM

HTML, CSS and JavaScript are the core technologies for building modern web pages: 1. HTML defines the web page structure, 2. CSS is responsible for the appearance of the web page, 3. JavaScript provides web page dynamics and interactivity, and they work together to create a website with a good user experience.

The Compatibility of IIS and PHP: A Deep Dive The Compatibility of IIS and PHP: A Deep Dive Apr 22, 2025 am 12:01 AM

IIS and PHP are compatible and are implemented through FastCGI. 1.IIS forwards the .php file request to the FastCGI module through the configuration file. 2. The FastCGI module starts the PHP process to process requests to improve performance and stability. 3. In actual applications, you need to pay attention to configuration details, error debugging and performance optimization.

How to safely store JavaScript objects containing functions and regular expressions to a database and restore? How to safely store JavaScript objects containing functions and regular expressions to a database and restore? Apr 19, 2025 pm 11:09 PM

Safely handle functions and regular expressions in JSON In front-end development, JavaScript is often required...

Explain the purpose of foreign keys in MySQL. Explain the purpose of foreign keys in MySQL. Apr 25, 2025 am 12:17 AM

In MySQL, the function of foreign keys is to establish the relationship between tables and ensure the consistency and integrity of the data. Foreign keys maintain the effectiveness of data through reference integrity checks and cascading operations. Pay attention to performance optimization and avoid common errors when using them.

SQL vs. MySQL: Clarifying the Relationship Between the Two SQL vs. MySQL: Clarifying the Relationship Between the Two Apr 24, 2025 am 12:02 AM

SQL is a standard language for managing relational databases, while MySQL is a database management system that uses SQL. SQL defines ways to interact with a database, including CRUD operations, while MySQL implements the SQL standard and provides additional features such as stored procedures and triggers.

Redis: Understanding Its Architecture and Purpose Redis: Understanding Its Architecture and Purpose Apr 26, 2025 am 12:11 AM

Redis is a memory data structure storage system, mainly used as a database, cache and message broker. Its core features include single-threaded model, I/O multiplexing, persistence mechanism, replication and clustering functions. Redis is commonly used in practical applications for caching, session storage, and message queues. It can significantly improve its performance by selecting the right data structure, using pipelines and transactions, and monitoring and tuning.

See all articles