
In Drupal system have its own query builder it will create a query on Drupal way and sent to the Database server. To run a Database query we have built our condition on a specific format. The function db_query() function helps us to achieve run database queries in Drupal 6. The below is the syntax and example using a different type of Database queries.
Syntax:
db_query(DATABASE_QUERY);
Note: The placeholder for numeric is %d and for string %s.
1. SELECT Query:
The SELECT query is used for retrieve records from Database. The below is the Syntax and example for SELECT query.
Example:
$result = db_query("SELECT * FROM {node} WHERE type = 'article' AND status = 1", 0, 10); $output = array(); while ($data = db_fetch_object($result)) { $output[$data->title] = check_plain($data->title); } print_r($output);
2. Insert Query:
The insert query is used for save Records in Database, the below example demonstrate about the Insert query.
Example:
If we have auto increment field than we pass the value as 0.
3. Update Query:
The UPDATE query is used for altering the existing content.
Example:
4. Delete Query:
The DELETE query is used for remove files from Database.
Example:
db_query("DELETE FROM {node} WHERE nid = %d", 1);