drupal7中基本的数据库操作实例详解-PHP Tutorial-php.cn

Home

Backend Development

PHP Tutorial

drupal7中基本的数据库操作实例详解

PHP中文网

Jun 03, 2017 am 09:52 AM

drupal是用数据库来存网站内容的，不像静态页那样直接是html文件，Drupal 7 数据库API增加了一些新的功能让语法更加清晰，使用也更加方便。它还能使用查询生成器来构造查询对象的能力，无需在代码中写原始的SQL语句，一是提高了代码可阅读性，二是兼容所有数据库。下面就列罗出一些经常使用的技巧，可能不够全面，还请大家多多补充。

1．单表查询（最基本使用方法）

2．条件查询（condition）

<?php $result = db_select('node', 'n') ->fields('n') ->condition('nid', 5,'=') //nid等于5的条件 ->condition('status', 0,'>') // 状态大于0,也就是为真等于1 ->condition('uid', array(1,5,7),'IN') //使用IN操作，当然还可以使用 NOT IN ->execute() ->fetchAssoc(); ?>

3．联合查询（Join）

<?php $query = db_select('field_data_field_slide','f'); //主表 $query->join('node', 'n', 'fa.entity_id = n.nid'); // 联合node表,条件是nid $query->condition('f.field_slide_channel_tid',$chanid,'='); $query->condition('n.status','1','='); //发布状态 $query->fields('n',array('nid')); //查询nid $query->orderBy('n.nid','DESC'); //排序条件 $query->range(0,4); //取得4条数据 $result = $query->execute(); ?>

4.添加字段（addField）

<?php $query = db_select('taxonomy_term_hierarchy','h'); //选择表 $query->join('taxonomy_term_data','d','h.tid = d.tid'); // 联合查询 $query->addField('d', 'tid'); // 添加字段 $query->condition('h.parent',0); // 添加条件where $query->condition('d.vid',$vid); // 再添加一个条件 and .... $query->addTag('ditusearch_generate_path'); // 添加Tag 可选项，这个就是方便其他地方可以改变这个查询$query 比如如果添加了tag 可以使用 hook_query_alter 对其进行查询如果你使用过views开发，views 也可以了类似的hook $tid = $query->execute()->fetchCol(); ?>

5.分页使用（pager）

6.多表联合分页

<?php $query = db_select('field_data_field_news','fa')->extend('PagerDefault'); //多表联合查询extend条件必须放在db_select之后 $query->join('node','n','fa.entity_id = n.nid'); $query->join('field_data_field_news_date_sort', 'fb', 'fa.entity_id = fb.entity_id'); $query->fields('n', array('nid','title')); $query->condition('fa.field_news_classify_tid',$tids,'in'); $query->condition('n.type','news','='); $query->condition('n.status','1','='); $query->orderBy('fb.field_news_date_sort_value','DESC'); $query->limit(14); $result = $query->execute(); ?>

 

function _module_name_autocomplete($string) { $matches = array(); // Some fantasy DB table which holds cities $query = db_select('cities', 'c'); // Select rows that match the string $return = $query ->fields('c', array('city')) ->condition('c.city', '%' . db_like($string) . '%', 'LIKE') ->range(0, 10) ->execute(); // add matches to $matches foreach ($return as $row) { $matches[$row->city] = check_plain($row->city); } // return for JS drupal_json_output($matches); //--json格式返回 }

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

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

Assassin's Creed Shadows: Seashell Riddle Solution

4 weeks ago By DDD

What's New in Windows 11 KB5054979 & How to Fix Update Issues

3 weeks ago By DDD

Where to find the Crane Control Keycard in Atomfall

4 weeks ago By DDD

Roblox: Dead Rails - How To Complete Every Challenge

1 months ago By DDD

How to fix KB5055523 fails to install in Windows 11?

2 weeks ago By DDD

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

Where is the login entrance for gmail email?

7741

Java Tutorial

1643

CakePHP Tutorial

1397

Laravel Tutorial

1291

PHP Tutorial

1233

Related knowledge

How to use CodeIgniter4 framework in php? May 31, 2023 pm 02:51 PM

PHP is a very popular programming language, and CodeIgniter4 is a commonly used PHP framework. When developing web applications, using frameworks is very helpful. It can speed up the development process, improve code quality, and reduce maintenance costs. This article will introduce how to use the CodeIgniter4 framework. Installing the CodeIgniter4 framework The CodeIgniter4 framework can be downloaded from the official website (https://codeigniter.com/). Down

How to use Pagoda Panel for MySQL management Jun 21, 2023 am 09:44 AM

Pagoda Panel is a powerful panel software that can help us quickly deploy, manage and monitor servers, especially small businesses or individual users who often need to build websites, database management and server maintenance. Among these tasks, MySQL database management is an important job in many cases. So how to use the Pagoda panel for MySQL management? Next, we will introduce it step by step. Step 1: Install Pagoda Panel. Before starting to use Pagoda Panel for MySQL management, you first need to install Pagoda Panel.

How to use PHP scripts to perform database operations in Linux environment Oct 05, 2023 pm 03:48 PM

How to use PHP to perform database operations in a Linux environment. In modern web applications, the database is an essential component. PHP is a popular server-side scripting language that can interact with various databases. This article will introduce how to use PHP scripts for database operations in a Linux environment and provide some specific code examples. Step 1: Install the Necessary Software and Dependencies Before starting, we need to ensure that PHP and related dependencies are installed in the Linux environment. usually

How to use thinkorm to improve database operation efficiency Jul 28, 2023 pm 03:21 PM

How to use thinkorm to improve database operation efficiency With the rapid development of the Internet, more and more applications require a large number of database operations. In this process, the efficiency of database operations becomes particularly important. In order to improve the efficiency of database operations, we can use thinkorm, a powerful ORM framework, to perform database operations. This article will introduce how to use thinkorm to improve the efficiency of database operations and illustrate it through code examples. 1. What is thinkormthi?

Using PDO for Database Operations: A Better Way with PHP Jun 21, 2023 pm 01:36 PM

Using PDO for database operations: A better way with PHP In web development, it is very common to use databases for data storage, management, and query. As a language widely used in Web development, PHP naturally provides a wealth of database operation methods. In PHP, you can use MySQLi, PDO and other extension libraries to perform database operations. Among them, PDO is a very commonly used database operation method and has more advantages than other methods. This article will introduce what PDO is to

How to use the FULL OUTER JOIN function in MySQL to obtain the union of two tables Jul 26, 2023 pm 05:45 PM

How to use the FULLOUTERJOIN function in MySQL to obtain the union of two tables. In MySQL, the FULLOUTERJOIN function is a powerful join operation that combines inner joins and outer joins. It can be used to get the union of two tables, that is, combine all the data in the two tables into a single result set. This article will introduce the usage of the FULLOUTERJOIN function and provide some sample code to help readers better understand. FULLOUTERJOIN function

How to use Doctrine ORM for database operations in Symfony framework Jul 29, 2023 pm 04:13 PM

How to use DoctrineORM in Symfony framework for database operations Introduction: Symfony framework is a popular PHP framework that provides many powerful tools and components for building web applications quickly and easily. One of the key components is DoctrineORM, which provides an elegant way to handle database operations. This article will introduce in detail how to use DoctrineORM to perform database operations in the Symfony framework. we will

PHP backend design: database operation and data interaction practice Jan 19, 2024 am 10:31 AM

When developing a website, application or system, database operations and data interaction are essential. As a commonly used backend development language, PHP's database operation and data interaction capabilities are also very powerful. This article will introduce some commonly used database operation functions and data interaction practices in PHP. At the same time, we will explain these operations and practices with code examples to facilitate readers to better understand and apply them. 1. Database connection Before performing database operations, you first need to connect to the database. In PHP we can use

See all articles