Backend Development
PHP Tutorial
How to write a PHP script that uses a LIKE clause to match data from a MySQL table?
How to write a PHP script that uses a LIKE clause to match data from a MySQL table?
Sep 12, 2023 pm 11:13 PM
We can use similar syntax of WHERE...LIKE clause in PHP function - mysql_query(). This function is used to execute a SQL command and later another PHP function – if the WHERE...LIKE clause is used with the SELECT command, mysql_fetch_array() can be used to fetch all selected data .
But if the WHERE... LIKE clause is used with the DELETE or UPDATE command, no further calls to PHP functions are required.
To illustrate this, we have the following example -
Example
In this example we are writing a PHP script which will return a tutorial_tbl' All records in the table whose author name contains 'jay' -
<?php
$dbhost = 'localhost:3036';
$dbuser = 'root';
$dbpass = 'rootpassword';
$conn = mysql_connect($dbhost, $dbuser, $dbpass);
if(! $conn ) {
die('Could not connect: ' . mysql_error());
}
$sql = 'SELECT tutorial_id, tutorial_title,
tutorial_author, submission_date
FROM tutorials_tbl
WHERE tutorial_author LIKE "%jay%"';
mysql_select_db('TUTORIALS');
$retval = mysql_query( $sql, $conn );
if(! $retval ) {
die('Could not get data: ' . mysql_error());
}
while($row = mysql_fetch_array($retval, MYSQL_ASSOC)) {
echo "Tutorial ID :{$row['tutorial_id']} <br> ".
"Title: {$row['tutorial_title']} <br> ".
"Author: {$row['tutorial_author']} <br> ".
"Submission Date : {$row['submission_date']} <br> ".
"--------------------------------<br>";
}
echo "Fetched data successfully</p><p>";
mysql_close($conn);
?>The above is the detailed content of How to write a PHP script that uses a LIKE clause to match data from a MySQL table?. For more information, please follow other related articles on the PHP Chinese website!
Hot AI Tools
Undress AI Tool
Undress images for free
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
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 changes current umask
Mar 22, 2024 am 08:41 AM
This article will explain in detail about changing the current umask in PHP. The editor thinks it is quite practical, so I share it with you as a reference. I hope you can gain something after reading this article. Overview of PHP changing current umask umask is a php function used to set the default file permissions for newly created files and directories. It accepts one argument, which is an octal number representing the permission to block. For example, to prevent write permission on newly created files, you would use 002. Methods of changing umask There are two ways to change the current umask in PHP: Using the umask() function: The umask() function directly changes the current umask. Its syntax is: intumas
PHP server security settings: How to prohibit file downloads
Mar 10, 2024 pm 04:48 PM
PHP server security settings are an important part of website operation that cannot be ignored. Prohibiting file downloads is a key step to protect website data security. By setting some security measures in the PHP code, malicious users can be effectively prevented from obtaining sensitive information on the website by downloading files. This article will detail how to disable file downloads and provide specific PHP code examples. 1. Direct access to sensitive files is prohibited. Sensitive files stored in the website directory, such as database configuration files, log files, etc., should be prohibited from being accessed directly through the browser.
How to read text files in html
Mar 26, 2024 pm 04:07 PM
HTML itself cannot read text files directly, but this functionality can be achieved through back-end programming languages ??(such as PHP, Python, Java) or front-end JavaScript technology. The backend method uses PHP's file_get_contents() function to read the content from the text file and embed it into the HTML page. The front-end JavaScript method uses the Fetch API to send a GET request to a text file on the server, then parses the response content and displays it in an HTML page.
How to debug CLI mode in PHPStorm?
Apr 01, 2025 pm 02:57 PM
How to debug CLI mode in PHPStorm? When developing with PHPStorm, sometimes we need to debug PHP in command line interface (CLI) mode...
The meaning and characteristics of PHP version NTS
Mar 26, 2024 pm 12:39 PM
PHP is a popular open source scripting language that is widely used in web development. NTS in the PHP version is an important concept. This article will introduce the meaning and characteristics of the PHP version NTS and provide specific code examples. 1. What is PHP version NTS? NTS is a variant of the PHP version officially provided by Zend, which is called NotThreadSafe (non-thread safe). Usually PHP versions are divided into two types: TS (ThreadSafe, thread safety) and NTS
PHP FFmpeg extension installation guide: easy-to-follow tutorial
Mar 28, 2024 pm 02:17 PM
PHPFFmpeg Extension Installation Guide: Simple and easy-to-understand tutorial In the process of website development, sometimes we need to process various multimedia files, such as audio, video, etc. FFmpeg is a powerful multimedia processing tool that can process audio, video and other formats, and supports various transcoding, cutting and other operations. The PHPFFmpeg extension is an extension library that calls FFmpeg functions in PHP. It can be used to process multimedia files easily. Below we will introduce PHPF in detail
Steps and precautions for modifying encoding settings in PHP.ini
Mar 27, 2024 pm 06:06 PM
Steps and precautions for modifying encoding settings in PHP.ini PHP is a powerful server-side scripting language that is widely used in the field of web development. In the PHP development process, it is often necessary to process data in different encoding formats, so it is very important to set the encoding correctly. This article will introduce how to set the encoding by modifying the PHP configuration file php.ini, and provide specific code examples. Step 1: Locate the php.ini configuration file. First, you need to locate the php.ini configuration file in the PHP installation directory.
How to detect if there is no PHP process in Linux system
Mar 16, 2024 am 11:42 AM
"Detection method of no PHP process in Linux system, specific code examples are required" When using Linux system for web development, we often rely on PHP process to handle dynamic pages and logic, and sometimes we may need to monitor whether there is a PHP process on the server. This article will introduce a method to detect whether there is a PHP process in a Linux system and give specific code examples. Why is it necessary to detect the PHP process? In web development, the PHP process plays a vital role. It is responsible for parsing and executing PHP processes.
