


Squeeze some time to blog-php&MySQL practice, blog-php_PHP tutorial
Squeeze some time to blog-php&MySQL practice, blog-php
hi
You’re going to have hot pot tonight, take some time to write something, don’t let your boss find out
1. PHP and MySQL
5. Backend of article publishing system
5.2 Create configuration file and initialization file
In order to unify the configuration and facilitate management, there is also the need to reduce code redundancy.
Config.php and connect.php respectively
config.php
/*
* Configuration file
*/
//Configuration database related information
//Since it is a constant, use define
define( 'HOST', '127.0.0.1');
define('USERNAME', 'root');
define('PASSWORD', '');
connect.php
/*
* File linked to the database
* Mainly link to the database server and then select the database.
* The special thing is to set the character set.
* Then hope to judge each operation
*/
//Include configuration file
require_once 'config.php';
//Connect the database
if(!$con=mysqli_connect(HOST,USERNAME,PASSWORD)){
echo mysqli_error($con);
}
//Select database
if(mysqli_select_db($con, 'info')){
echo mysqli_error($con);
}
//Character set
if(mysqli_query($con,'set names utf8')){
echo mysqli_error($con);
}
After completion, test the linked file and it will be ok. Both mysqli and mysql are acceptable here, as long as the format is correct.
5.3 Publish article
Article publishing interface article.add.php
< /head>
后台管理系统 | |
版权所有 |
不是很漂亮就是了,学习嘛
文章发布处理程序article.add.handle.php
require_once('../connect.php');
//把传递过来的信息入库,在入库之前对所有的信息进行校验。
if(!(isset($_POST['title'])&&(!empty($_POST['title'])))){
echo "<script>alert('标题不能为空');window.location.href='article.add.php';</script>";
}
$title = $_POST['title'];
$author = $_POST['author'];
$description = $_POST['description'];
$content = $_POST['content'];
$dateline = time();
$insertsql = "insert into article(title, author, description, content, dateline) values('$title', '$author', '$description', '$content', $dateline)";
if(mysqli_query($con,$insertsql)){
echo "<script>alert('发布文章成功');window.location.href='article.manage.php';</script>";
}else{
echo "<script>alert('发布失败');window.location.href='article.manage.php';</script>";
}
?>
注意两者的功能和连接,就是add页面把东西传给handle处理
------------------------
由于我遇到了前所未见的乱码问题。。。跪着解决中。。。。望大家不吝赐教(wamp环境,mysql,zend,浏览器都已经设置为utf8,apache配置文件中添加了AddDefaultCharset UTF-8,问题依然存在,我晕啊。。。。)

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

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

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

PHP 8.4 brings several new features, security improvements, and performance improvements with healthy amounts of feature deprecations and removals. This guide explains how to install PHP 8.4 or upgrade to PHP 8.4 on Ubuntu, Debian, or their derivati

If you are an experienced PHP developer, you might have the feeling that you’ve been there and done that already.You have developed a significant number of applications, debugged millions of lines of code, and tweaked a bunch of scripts to achieve op

Visual Studio Code, also known as VS Code, is a free source code editor — or integrated development environment (IDE) — available for all major operating systems. With a large collection of extensions for many programming languages, VS Code can be c

JWT is an open standard based on JSON, used to securely transmit information between parties, mainly for identity authentication and information exchange. 1. JWT consists of three parts: Header, Payload and Signature. 2. The working principle of JWT includes three steps: generating JWT, verifying JWT and parsing Payload. 3. When using JWT for authentication in PHP, JWT can be generated and verified, and user role and permission information can be included in advanced usage. 4. Common errors include signature verification failure, token expiration, and payload oversized. Debugging skills include using debugging tools and logging. 5. Performance optimization and best practices include using appropriate signature algorithms, setting validity periods reasonably,

A string is a sequence of characters, including letters, numbers, and symbols. This tutorial will learn how to calculate the number of vowels in a given string in PHP using different methods. The vowels in English are a, e, i, o, u, and they can be uppercase or lowercase. What is a vowel? Vowels are alphabetic characters that represent a specific pronunciation. There are five vowels in English, including uppercase and lowercase: a, e, i, o, u Example 1 Input: String = "Tutorialspoint" Output: 6 explain The vowels in the string "Tutorialspoint" are u, o, i, a, o, i. There are 6 yuan in total

This tutorial demonstrates how to efficiently process XML documents using PHP. XML (eXtensible Markup Language) is a versatile text-based markup language designed for both human readability and machine parsing. It's commonly used for data storage an

Static binding (static::) implements late static binding (LSB) in PHP, allowing calling classes to be referenced in static contexts rather than defining classes. 1) The parsing process is performed at runtime, 2) Look up the call class in the inheritance relationship, 3) It may bring performance overhead.

What are the magic methods of PHP? PHP's magic methods include: 1.\_\_construct, used to initialize objects; 2.\_\_destruct, used to clean up resources; 3.\_\_call, handle non-existent method calls; 4.\_\_get, implement dynamic attribute access; 5.\_\_set, implement dynamic attribute settings. These methods are automatically called in certain situations, improving code flexibility and efficiency.
