文本文件数据库处理函数库_PHP
因为我租不起MySQL支持, 所以只能采用扁平文件存储,
我是采用perl常用的"|"定界的格式,就像 "name|email|homepage" 这样的格式。
随便写了几个函数, 觉得还是有点用处的。 大家有什么心得,
也希望能告诉我啊, 我来完善完善。
// dtf.inc.php3
//
// DTF -- Delimited Text File Functions
// Written by: Goghs
// http://www.eqiao.com
//
// Function to manage a delimited text file database
function dtf_fetch_all_as_string($filename) {
$fp = fopen( $filename, "r" );
$current = fread($fp, filesize($filename));
fclose($fp);
return $current;
}
function dtf_fetch_all_as_array($dbname) {
return file($dbname);
}
function dtf_update_db($dbname, $item) {
if (file_exists($dbname)):
$fp = fopen($dbname,"w+");
fputs($fp,$item);
fclose($fp);
else:
$fp = fopen($dbname,"w");
fputs($fp,$item);
fclose($fp);
endif;
}
function dtf_get_total_rows($dbname) {
return count(file($dbname));
}
function dtf_remove_pipe($input) {
if (is_string($input)) {
// $input=ereg_replace("|","",$input); // It’s said that str-replace is faster than ereg_replace
$input=str_replace("|","",$input);
}
if (is_array($input)) {
for ($i=0; $i
$input[$i] = ereg_replace("|","|",$input[$i]);
}
}
return $input;
}
// 这个函数没有用, 用htmlspecialchars就可以
// 但是如果只需要处理""而不需要处理 引号和 &时就很有用
function dtf_remove_html_tag($input) {
if (is_string($input)) {
$input = ereg_replace("
$input = ereg_replace(">",">",$input);
}
if (is_array($input)) {
for ($i=0; $i
$input[$i] = ereg_replace("
$input[$i] = ereg_replace(">",">",$input[$i]);
}
}
return $input;
}
// 可以定制这个函数, 控制是否允许html标记等
function dtf_sanitize($input) {
$input = dtf_remove_pipe($input);
// $input = dtf_remove_html_tag($input);
$input = stripslashes($input);
$input = htmlspecialchars($input);
return $input;
}

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

AI Hentai Generator
Generate AI Hentai for free.

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

1. The SUM function is used to sum the numbers in a column or a group of cells, for example: =SUM(A1:J10). 2. The AVERAGE function is used to calculate the average of the numbers in a column or a group of cells, for example: =AVERAGE(A1:A10). 3. COUNT function, used to count the number of numbers or text in a column or a group of cells, for example: =COUNT(A1:A10) 4. IF function, used to make logical judgments based on specified conditions and return the corresponding result.

How to use MySQLi to establish a database connection in PHP: Include MySQLi extension (require_once) Create connection function (functionconnect_to_db) Call connection function ($conn=connect_to_db()) Execute query ($result=$conn->query()) Close connection ( $conn->close())

Apple's latest releases of iOS18, iPadOS18 and macOS Sequoia systems have added an important feature to the Photos application, designed to help users easily recover photos and videos lost or damaged due to various reasons. The new feature introduces an album called "Recovered" in the Tools section of the Photos app that will automatically appear when a user has pictures or videos on their device that are not part of their photo library. The emergence of the "Recovered" album provides a solution for photos and videos lost due to database corruption, the camera application not saving to the photo library correctly, or a third-party application managing the photo library. Users only need a few simple steps

Exception handling in C++ can be enhanced through custom exception classes that provide specific error messages, contextual information, and perform custom actions based on the error type. Define an exception class inherited from std::exception to provide specific error information. Use the throw keyword to throw a custom exception. Use dynamic_cast in a try-catch block to convert the caught exception to a custom exception type. In the actual case, the open_file function throws a FileNotFoundException exception. Catching and handling the exception can provide a more specific error message.

To handle database connection errors in PHP, you can use the following steps: Use mysqli_connect_errno() to obtain the error code. Use mysqli_connect_error() to get the error message. By capturing and logging these error messages, database connection issues can be easily identified and resolved, ensuring the smooth running of your application.

How to integrate GoWebSocket with a database: Set up a database connection: Use the database/sql package to connect to the database. Store WebSocket messages to the database: Use the INSERT statement to insert the message into the database. Retrieve WebSocket messages from the database: Use the SELECT statement to retrieve messages from the database.

When passing a map to a function in Go, a copy will be created by default, and modifications to the copy will not affect the original map. If you need to modify the original map, you can pass it through a pointer. Empty maps need to be handled with care, because they are technically nil pointers, and passing an empty map to a function that expects a non-empty map will cause an error.

Using the database callback function in Golang can achieve: executing custom code after the specified database operation is completed. Add custom behavior through separate functions without writing additional code. Callback functions are available for insert, update, delete, and query operations. You must use the sql.Exec, sql.QueryRow, or sql.Query function to use the callback function.
