Home Backend Development PHP Tutorial php+mysql 取视频表信息。怎么匹配截取name

php+mysql 取视频表信息。怎么匹配截取name

Jun 13, 2016 pm 01:18 PM
name split video

php+mysql 取视频表信息。如何匹配截取name
php+mysql 数据库视频表 取视频信息 video_list
其中有字段video_name 如下: 
数据1《百家讲坛》20111220 
数据2《百家讲坛》20111214 王立群读《史记》――秦始皇(三十)生死茫茫 
如果是数据1 直接取video_name,输出
如果是数据2 截取时间后面的字符输出
8位日期数字的左右都有一个空格符。
请问我该如何在循环中判断这2中类型并截取呢?是用正则么,该怎嘛写啊

------解决方案--------------------
$t = preg_split('/\s+\d+\s+/', $roe['video_name'], PREG_SPLIT_NO_EMPTY);
echo end($t);

------解决方案--------------------
哦,少了一个参数
$t = preg_split('/\s+\d+\s+/', $roe['video_name'],-1, PREG_SPLIT_NO_EMPTY);
------解决方案--------------------
$roe['video_name']= '《百家讲坛》20111214 王立群读《史记》――秦始皇(三十)生死茫茫';
$chars = preg_split('/[0-9]/', $roe['video_name'], -1,PREG_SPLIT_NO_EMPTY );
$rs= (count($chars)>1) ? $chars[1] : $roe['video_name'];
echo $rs;

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)

Hot Topics

Java Tutorial
1664
14
PHP Tutorial
1268
29
C# Tutorial
1243
24
How to fix VIDEO DXGKRNL fatal error in Windows 11 How to fix VIDEO DXGKRNL fatal error in Windows 11 Apr 13, 2023 pm 08:22 PM

Click to enter: ChatGPT Tool Plug-in Navigation Collection Some users complained that their computers frequently crashed with the stop code VIDEO DXGKRNL FATAL ERROR. This particular issue occurs only occasionally and has a bugcheck value of 0x00000113, which indicates a violation in the Microsoft DirectX graphics kernel subsystem, as indicated by the bugcheck value. Usually, the error occurs when a corrupt driver interferes with the normal operation of the graphics card's graphics processor. If you're currently struggling with this specific issue, our article will provide you with a variety of high-quality troubleshooting tips. Below you'll find various methods that other users who encountered the exact same error have used successfully. yes

Motorola Razr 50 Ultra shows up in leaked teaser video with waterproof case and huge secondary display Motorola Razr 50 Ultra shows up in leaked teaser video with waterproof case and huge secondary display Jun 20, 2024 pm 09:31 PM

Over the past few weeks, the most important specifications and the euro prices of the Motorola Razr 50 and the Razr 50 Ultra have been leaked. Now the enormously reliable leaker @MysteryLupin was able to publish the teaser video embedded below, which

Pixel 9 Pro XL vs iPhone 15 Pro Max camera comparison reveals surprising Google wins in video and zoom performance Pixel 9 Pro XL vs iPhone 15 Pro Max camera comparison reveals surprising Google wins in video and zoom performance Aug 24, 2024 pm 12:32 PM

The Google Pixel 9 Pro and Pro XL are Google's answers to the likes of the Samsung Galaxy S24 Ultra and the Apple iPhone 15 Pro and Pro Max. Daniel Sin on YouTube(watch below) has compared the Google Pixel 9 Pro XL to the iPhone 15 Pro Max with some

Snapdragon X Elite CPU performance nearly identical on battery and plugged-in in Vivobook S15 benchmarks Snapdragon X Elite CPU performance nearly identical on battery and plugged-in in Vivobook S15 benchmarks Jun 20, 2024 pm 03:59 PM

Despite the hype surrounding the Qualcomm Snapdragon X Elite, it has been a rather mediocre launch. In our review, we found that the most impressive part of the new Qualcomm Snapdragon X Elite X1E-78-100-powered Asus Vivobook S 15 was the seamlessnes

Panasonic Lumix S9 supply shortages complete Fujifilm X100VI impersonation act despite bad press Panasonic Lumix S9 supply shortages complete Fujifilm X100VI impersonation act despite bad press Jun 14, 2024 am 09:36 AM

Sinceitslaunchearlierthisyear,thePanasonicLumixS9hasbeenembroiledincontroversy.BetweenthecornersPanasoniccuttoarriveatsuchasmallbodyandthefusscertaincamerareviewerskickeduponYouTube,itseemedliketheLumixS9wasdoom

A closer look at the video element in HTML A closer look at the video element in HTML Feb 24, 2024 pm 08:18 PM

Detailed explanation of the video tag in HTML The video tag in HTML5 is a tag used to play videos on web pages. It can render videos using different formats, such as MP4, WebM, Ogg, and more. In this article, we will introduce the use of video tag in detail and provide specific code examples. Basic Structure The following is the basic structure of the video tag:

How to solve 'undefined: bytes.Split' error in golang? How to solve 'undefined: bytes.Split' error in golang? Jun 25, 2023 pm 02:02 PM

In the Go language, the bytes package is a package for manipulating byte types, and it contains many useful methods, such as the Split() method. However, when using the Split() method, you may encounter an "undefined: bytes.Split" error. This error is usually caused by incompatible Go versions or lack of necessary dependent libraries. This article will introduce some methods to solve this error. Method 1: Upgrade the Go version as follows

What is the use of split method in go language What is the use of split method in go language Jan 28, 2023 pm 01:37 PM

In the Go language, the Split() method is used to split a string. You can use delimiters to divide the string into a list of substrings, and the substrings are returned in the form of slices. Split() is a method of the strings package. You need to import the strings package before using it. The syntax is "strings.Split (string to be split, delimiter)".

See all articles