<?php include 'db.php'; $id = scalar('SELECT id FROM users WHERE login="******" AND pass="******"', $conn); if ($id != null) { $_SESSION['myid'] = $id; echo $id; }
<?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;
<?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; }