Use a dialog box to prompt the user to enter query conditions. What does such a query belong to?

Use a dialog box to prompt the user to enter query conditions. Such a query is a parameter query; if you want to create a query that uses different values ​​​​each time, you can use parameters in the query; the parameters are the values ​​provided when running the query. Placeholder; the user cannot exit modal dialog boxes with these characteristics at runtime.

The operating environment of this article: Windows 7 system, DELL G3 computer

Use a dialog box to prompt the user to enter query conditions, such a query belongs What?

Use a dialog box to prompt the user to enter query conditions. Such queries are parameter queries.

Related introduction:

In some cases, it is necessary to create a query that can be used multiple times, but with different values ​​each time. For example, you might frequently run a query to find all title_ids written by a certain author. You can run the same query for each request, just using a different author ID or name each time.

To create a query that uses different values ​​each time, you can use parameters in the query. Parameters are placeholders for the values ​​provided when running the query. The user cannot exit a modal dialog box with these characteristics at run time.

SELECT title_id
FROM titleauthor
WHERE (au_id = ?)

For more related knowledge, please visit the FAQ column!

The above is the detailed content of Use a dialog box to prompt the user to enter query conditions. What does such a query belong to?. For more information, please follow other related articles on the PHP Chinese website!