SQLite如何使用PHP PDO读取特定行 [英] SQLite how to read a specific row using PHP PDO

问题描述

这是表格:

名称:"TagValues"
列1:标记"
列2:值"
条目数:80

尝试读取带有Tag值"CustomTag"的特定行的查询是什么

Here is the table:

Name: "TagValues"
Column1: "Tag"
Column2: "Values"
No Of Entries: 80

What is the query to read a specific row with a Tag value "CustomTag" I Tried these

$UserTag = "CustomTag";
$query = "SELECT Tag FROM TagValues WHERE Tag='$UserTag'"; //it didn't work
$query = "SELECT FROM TagValues WHERE Tag='$UserTag'"; //it didn't work
$query = "SELECT * FROM TagValues WHERE Tag='$UserTag'"; //it didn't work

确切的语法是什么?

Whats is the exact syntax?

推荐答案

UserTag = " ;

UserTag = "CustomTag";

查询 = "

query = "SELECT Tag FROM TagValues WHERE Tag='

UserTag'" ; // 它不起作用

UserTag'"; //it didn't work

这篇关于SQLite如何使用PHP PDO读取特定行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！