PHP Database::doquery Examples

Programming Language: PHP

Class/Type: Database

Method/Function: doquery

Examples at hotexamples.com: 2

PHP Database doQuery is a function that enables a programmer to create a query and execute it. It is a wrapper for SQL queries and can interact with various types of databases like MySQL and PostgreSQL. The package library used for this function is likely to be the PHP Data Objects (PDO) extension.

Example of usage:

try {
    $pdo = new PDO('mysql:host=localhost;dbname=testdb','username','password');
    $stmt = $pdo->prepare('SELECT * FROM users WHERE id=:id');
    $stmt->execute(['id' => 1]);
    $result = $stmt->fetch(PDO::FETCH_ASSOC);
    print_r($result);
} catch(PDOException $e) {
    echo "Error: " . $e->getMessage();
}

In this example, we are connecting to a MySQL database using PDO and fetching the details of a user with the ID of 1 from the 'users' table.

Another example:

try {
    $pdo = new PDO('pgsql:host=localhost;dbname=testdb','username','password');
    $stmt = $pdo->prepare('UPDATE products SET price=:price WHERE id=:id');
    $stmt->execute(['price' => 10.99, 'id' => 12]);
    echo "Product updated successfully!";
} catch(PDOException $e) {
    echo "Error: " . $e->getMessage();
}

In this example, we are connecting to a PostgreSQL database using PDO and updating the price of a product with the ID of 12 in the 'products' table. Overall, PHP Database doQuery is a useful function for interacting with databases in PHP and is commonly used in web development.

PHP Database::doquery - 2 examples found. These are the top rated real world PHP examples of Database::doquery from package testswarm extracted from open source projects. You can rate examples to help us improve the quality of examples.

Frequently Used Methods

Show Hide

query_insert(30)

Instance(30)

pDataConnect(30)

fetch(30)

Insert(30)

get_statistic_table(30)

commit(30)

obtain(30)

insert_id(30)

db(30)

connect(30)

select(30)

num_rows(30)

num_row(30)

close(30)

fetch_row(30)

update(30)

executeQuery(30)

execute(30)

fetchAll(30)

_instance(30)

resultset(30)

fetch_array(30)

sql2single(30)

fetch_object(30)

fetch_assoc(30)

sql2row(30)

sql2array(30)

prepare(30)

instance(30)

sql(30)

fetch_all_array(30)

get_course_table(30)

pexecute_first(30)

GetOne(30)

singleton(30)

pexecute(30)

single(30)

connection(30)

get(30)

getInstance(30)

store_result(30)

query(30)

exec(30)

query_update(30)

tDataConnect(30)

bind(30)

table(30)

getConnection(30)

get_main_table(30)

Database Class Documentation

Example #1

Show file

File: account.php Project: alwintje/alfa-workshops

$errors = null;
if (isset($_GET['checkMail'])) {
    $security->checkMail();
}
if ($user != false) {
    if (!$user['validated']) {
        $errors = "U moet uw account nog valideren.";
    } else {
        $core->loadPage("index.php");
    }
} else {
    if (isset($_GET['notValidated'])) {
        $errors = "U moet uw account nog valideren.";
    }
}
$query = $db->doquery("SELECT * FROM {{table}} WHERE active='1' LIMIT 1", "settings");
$settings = mysqli_fetch_array($query);
$mailHosts = explode(",", $settings['email_hosts']);
?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">

    <title>Alfa-Workshops</title>
    <link href="styles/base.css" rel="stylesheet" />
    <link href="styles/loginScreens.css" rel="stylesheet" />

</head>
<body>

Example #2

Show file

File: index.php Project: marijnkoel/StendenProject2

$core = new Core();
$db = new Database();
$db->opendb();
$security = new Security($core, $db);
$user = $security->checksession();
if (!$user) {
    $core->loadPage("login.php");
}
if (isset($_GET['logout'])) {
    $security->logout();
}
if (isset($_GET['deleteAll'])) {
    $items = explode(",", $_POST['items']);
    foreach ($items as $v) {
        if ($user['role'] == 2) {
            $db->doquery("DELETE FROM {{table}} WHERE id='" . $v . "'", "tickets");
            echo true;
        } elseif ($user['role'] == 1) {
            $q = $db->doquery("SELECT working_on FROM {{table}} WHERE id='" . $v . "' AND working_on='" . $user['id'] . "'", "tickets");
            if (mysqli_num_rows($q) > 0) {
                $db->doquery("DELETE FROM {{table}} WHERE id='" . $v . "'", "tickets");
                echo true;
            } else {
                echo "Assign ticket first to you.";
            }
        } else {
            $q = $db->doquery("SELECT user FROM {{table}} WHERE id='" . $v . "' AND user='******'id'] . "'", "tickets");
            if (mysqli_num_rows($q) > 0) {
                $db->doquery("DELETE FROM {{table}} WHERE id='" . $v . "'", "tickets");
                echo true;
            } else {