function readDataParser($sql, $case, $searchstring, $scanner = false)
{
$con = newConnection();
if ($result = $con->query($sql)) {
if ($scanner === true) {
while ($row = $result->fetch_assoc()) {
if (strpos(strtolower($row["query"]), strtolower($searchstring)) !== false) {
if ($case === 1) {
echo "[" . $row["query"] . "]<br>";
} else {
echo "[" . $row["query"] . "] [" . $row["Datelog"] . "]<br>";
}
}
}
} else {
while ($row = $result->fetch_assoc()) {
if ($case === 1) {
echo "[" . $row["query"] . "]<br>";
} else {
echo "[" . $row["query"] . "] [" . $row["Datelog"] . "]<br>";
}
}
}
} else {
echo "No results found";
}
$con->close();
}
if ($username) {
$password = safe_REQUEST($_REQUEST, 'password');
$user_id = authenticateUser($username, $password);
if ($user_id) {
$stat = newConnection();
if ($stat !== false) {
addDebugLog($action . " username={$username} SUCCESS\n" . $stat);
print "SUCCESS\n" . $stat;
}
$_SESSION['connected'] = $user_id;
} else {
addDebugLog($action . " username={$username} ERROR 10: Username and password key failed to authenticate.");
print "ERROR 10: Username and password key failed to authenticate.\n";
}
} else {
$stat = newConnection();
if ($stat !== false) {
addDebugLog($action . " SUCCESS\n" . $stat);
print "SUCCESS\n" . $stat;
}
AddToLog('Read-Only Anonymous Client connection.');
$_SESSION['connected'] = 'Anonymous';
$_SESSION['readonly'] = 1;
}
exit;
case 'listgedcoms':
$out_msg = "SUCCESS\n";
foreach (get_all_gedcoms() as $ged_id => $gedcom) {
$out_msg .= "{$gedcom}\t" . get_gedcom_setting($ged_id, 'title') . "\n";
}
addDebugLog($action . " " . $out_msg);
<?php
// Defines the mysqli database object, and provides convenience functions for running commonly executed queries
/* Require database stuff */
require_once "functions/conf.inc.php";
require_once "functions/connection.php";
/* Defines the $mysqli object */
$mysqli = newConnection($CFG);
/* Random function */
function test()
{
$query = <<<VEV
SELECT question_id FROM `{$prefix}questions`
VEV;
// Execute the query and grab the data.
$result = $mysqli->query($query);
}
<?php
require_once 'conf.inc.php';
require_once 'connection.php';
$connection = newConnection($CFG);
$prefix = $connection->prefix;
$query = <<<EOL
SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
-- -----------------------------------------------------
-- Table `{$prefix}user`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `{$prefix}user` ;
CREATE TABLE IF NOT EXISTS `{$prefix}user` (
`user_id` INT NOT NULL AUTO_INCREMENT ,
`first_name` VARCHAR(60) NOT NULL ,
`last_name` VARCHAR(60) NOT NULL ,
`email` VARCHAR(255) NOT NULL ,
`grad_yr` SMALLINT NULL ,
`last_online` DATE NULL ,
`student_id` VARCHAR(60) NOT NULL ,
`image_url` TEXT NULL COMMENT 'profile pic\\n\\nurl to the image relative to installation\\\\'s resource directory, or from the web?' ,
PRIMARY KEY (`user_id`) ,
INDEX `grad_yr` (`grad_yr` ASC) ,
INDEX `last_name` (`last_name` ASC) ,
UNIQUE INDEX `student_id` (`student_id` ASC) )
