PHP scalar Examples

Example #1

File: signin.php Project: x29a100/gram

<?php

include 'db.php';
$id = scalar('SELECT id FROM users WHERE login="******" AND pass="******"', $conn);
if ($id != null) {
    $_SESSION['myid'] = $id;
    echo $id;
}

Example #2

File: subscribe.php Project: x29a100/gram

<?php

include 'db.php';
$subscribe = scalar('SELECT 1 FROM subscribe WHERE fromid = ' . par('fromid') . ' AND toid = ' . par('toid'), $conn);
if ($subscribe != 1) {
    insert('INSERT INTO subscribe (fromid, toid) VALUES (' . par('fromid') . ', ' . par('toid') . ')', $conn);
}
echo 1;

Example #3

File: signup.php Project: x29a100/gram

<?php

include 'db.php';
$loginCount = scalar('SELECT COUNT(*) FROM users WHERE login="******"', $conn);
if ($loginCount == 0) {
    insert('INSERT INTO users (login, pass) VALUES ("' . par('login') . '", "' . par('pass') . '")', $conn);
    $_SESSION['auth'] = '1';
    echo 1;
}