/**
* Getting all users
*/
public function getAllUsers()
{
$c = new DB_Connect();
$d = $c->connect();
$result = mysqli_query($d, "select * FROM gcm_users");
return $result;
}
function __construct()
{
require_once 'include/DB_Connect.php';
// connecting to database
$db = new DB_Connect();
$this->conn = $db->connect();
}
function __construct()
{
$path = elgg_get_plugins_path();
include_once $path . 'elgg_with_rest_api/lib/DB_connect.php';
$conn = new DB_Connect();
$this->db = $conn->connect();
}
function __construct()
{
$path = elgg_get_plugins_path();
include_once $path . 'web_services/lib/DB_connect.php';
$conn = new DB_Connect();
$this->db = $conn->connect();
}
public function delete()
{
$con = new DB_Connect();
$con->exec('delete from test_type where test_type_id=' . JPOST('test_type_id'));
$jTableResult = array();
$jTableResult['Result'] = "OK";
print json_encode($jTableResult);
}
function __construct()
{
require_once __DIR__ . '/DB_connect.php';
// Importando clase de conexión
// conectando...
$db = new DB_Connect();
$this->con = $db->getDbConnection();
// Conectando con base de datos
}
function updatePassword()
{
$st_user = $_POST['st_user'];
$st_pwd = $_POST['st_pwd'];
$db = new DB_Connect();
$statement = "update students set s_pwd=? where s_user=?";
$result = $db->prepare($statement);
$result->execute(array(md5($st_pwd), $st_user));
echo json_encode(array('success' => $result->rowCount()));
}
public static function getInstance($dsn = null, $username = null, $password = null)
{
if (!self::$instance instanceof PDO) {
self::$instance = new PDO("{$dsn}", $username, $password);
self::$instance->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}
return self::$instance;
}
function test()
{
self::$connection = mysql_connect(DB_HOST, DB_USER, DB_PASS) or die("unable to connect to database");
$db_select = mysql_select_db(DB_NAME, self::$connection);
if (!$db_select) {
die("Database selection failed: " . mysql_error());
}
}
protected function conn()
{
isset($this->username);
isset($this->password);
if (!$this->db instanceof PDO) {
$this->db = DB_Connect::getInstance($this->dsn, $this->username, $this->password);
}
}
private function setDB()
{
require_once $this->root . "/class/DB_Connect.php";
$ds = new MySQLDataSource(DB_Connect::mysql_db());
//This $db_con link has been created inside KoolPHPSuite/Resources/runexample.php
$ds->SelectCommand = 'select s_id, s_user, s_pwd, s_num, s_name, s_mail, s_date, s_role, s_phone, reg_date, last_login, edu_id, edu_name, dept_name, major_name, class_name, class_id from student join class using(class_id) join major using(major_id) join department using(dept_id) join education using(edu_id) ' . $this->where_cla;
$ds->UpdateCommand = "update student set s_pwd=md5('@s_pwd'), s_name='@s_name', s_num='@s_num' where s_id=@s_id";
$this->grid->DataSource = $ds;
}
private function setDB()
{
require_once $this->root . "/class/DB_Connect.php";
$ds = new MySQLDataSource(DB_Connect::mysql_db());
//This $db_con link has been created inside KoolPHPSuite/Resources/runexample.php
$ds->SelectCommand = "select m_id,m_user,m_name,m_pwd,department.dept_id,dept_name from manager right join department using(dept_id)";
$ds->UpdateCommand = "update manager set m_pwd=md5('@m_pwd'), m_user='******', m_name='@m_name', dept_id='@dept_id' where m_id=@m_id";
$ds->InsertCommand = "insert into manager (m_user, m_pwd, m_name, dept_id) values('@m_user',md5('@m_pwd'), '@m_name', '@dept_id')";
$ds->DeleteCommand = "delete from manager where m_id=@m_id";
$this->grid->DataSource = $ds;
}
public function __construct($s_user)
{
$db = new DB_Connect();
$column = 'a.s_user, a.s_num, a.s_pwd, a.s_name, a.s_mail, a.s_phone, a.s_date, a.test_type_id, d.dept_name, d.id dept_id, c.major_name, c.id major_id,
b.class_name, b.id class_id, a.score_1, a.score_2, a.score_3, a.score_ans, a.score_type, a.reg_date, a.s_role, e.edu_name, e.edu_id ';
$from_clause = 'from students a left join classes b on a.class_id=b.id
left join majors c on b.major_id=c.id
left join departments d on c.department_id=d.id
left join educations e on a.edu_id= e.edu_id ';
$where_clause = 'where a.state=1 and a.s_user=:s_user';
$statement = 'select ' . $column . $from_clause . $where_clause;
$result = $db->prepare($statement);
$result->execute(array(':s_user' => $s_user));
if ($row = $result->fetch()) {
$this->s_user = $row['s_user'];
$this->s_num = $row['s_num'];
$this->s_pwd = $row['s_pwd'];
$this->s_name = $row['s_name'];
$this->s_mail = $row['s_mail'];
$this->s_date = $row['s_date'];
$this->dept_name = $row['dept_name'];
$this->major_name = $row['major_name'];
$this->class_name = $row['class_name'];
$this->score_1 = $row['score_1'];
$this->score_2 = $row['score_2'];
$this->score_3 = $row['score_3'];
$this->score_ans = $row['score_ans'];
$this->score_type = $row['score_type'];
$this->reg_date = $row['reg_date'];
$this->s_role = $row['s_role'];
$this->edu_name = $row['edu_name'];
$this->s_phone = $row['s_phone'];
$this->dept_id = $row['dept_id'];
$this->major_id = $row['major_id'];
$this->class_id = $row['class_id'];
$this->edu_id = $row['edu_id'];
$this->test_type_id = $row['test_type_id'];
} else {
}
}
public function __construct($dbo = NULL, $useDate = NULL)
{
parent::__construct($dbo);
if (isset($userDate)) {
$this->_userDate = $userDate;
} else {
$this->_userDate = date('Y-m-d H:i:s');
}
$ts = strtotime($this->_useDate);
$this->_m = date('m', $ts);
$this->_y = date('y', $ts);
$this->_daysInMonth = cal_days_in_month(CAL_GREGORIAN, $this->_m, $this->_y);
$ts = mktime(0, 0, 0, $this->_m, 1, $this->_y);
$this->_startDay = date('w', $ts);
}
<?php
/*##############################################
# Hawkeye POC Portal #
# Author: Ankita Pawar (ankita.pawar@emc.com) #
###############################################*/
require_once __DIR__ . '/include/db_connect.php';
print_r("DB_HOST=" . DB_HOST . "<br> ");
print_r("DB_USER="******"<br> ");
print_r("DB_PASSWORD="******"<br> ");
print_r("DB_DATABASE=" . DB_DATABASE . "<br> ");
print_r("DB_PORT=" . DB_PORT . "<br> <br>");
$db = new DB_Connect();
$db->connect();
$sql = "create table user( ID int NOT NULL AUTO_INCREMENT, name text, email text, password text, PRIMARY KEY (ID))";
mysql_unbuffered_query($sql);
$sql = "create table array( ID int NOT NULL AUTO_INCREMENT, name text, serial_no text, PRIMARY KEY (ID))";
mysql_unbuffered_query($sql);
$sql = "create table requests( ID int NOT NULL AUTO_INCREMENT, system_id text, cmd text, type text, status text, PRIMARY KEY (ID))";
mysql_unbuffered_query($sql);
$sql = "create table cpu_stat(ID int NOT NULL AUTO_INCREMENT, ts datetime, spa int, spb int, serial text, PRIMARY KEY (ID))";
mysql_unbuffered_query($sql);
$sql = "create table iops_stat(ID int NOT NULL AUTO_INCREMENT, ts datetime, spa_read int, spa_write int, spb_read int, spb_write int, serial text, PRIMARY KEY (ID))";
mysql_unbuffered_query($sql);
$sql = "create table capacity_stat(ID int NOT NULL AUTO_INCREMENT, ts datetime, syscap int, usedcap int, freecap int, unconfigcap int, serial text, PRIMARY KEY (ID))";
mysql_unbuffered_query($sql);
$sql = "create table healthcheck (ID int NOT NULL AUTO_INCREMENT, ts datetime, score int, serial text, note text, PRIMARY KEY (ID))";
mysql_unbuffered_query($sql);
// Insert data in array table for poc
$sql = "select * from array where serial_no = 'APM00143230622'";
$query = mysql_query($sql);
public function getAll()
{
return parent::getArray("SELECT `edu_id`, `edu_name` FROM `educations` where state=1");
}
<?php
error_reporting(E_ALL);
ini_set('display_errors', 1);
include "header.php";
include_once "control.php";
$db = new DB_Connect();
$staff = $db->get_staff();
$jobs = $db->get_jobs();
?>
<div class="container">
<div class="row" >
<div class="col-xs-12">
<div class="well" id="intro_text">
Record your work here and increase your efficiency!
</div>
</div>
</div>
<div class="row">
<div class="col-md-3">
<div id="staff_box">
<div id="page_heading"><span id="span_title"></span>Time Sheet<br/></div>
Employee <select id="staff_member">
<option value="">Please select...</option>
<?php
foreach ($staff as $staffer) {
<?php
include_once "control.php";
$db = new DB_Connect();
if (isset($_POST["start_job"]) && $_POST["start_job"]) {
$data = array("job_id" => $_POST['job'], "staff" => $_POST['staff'], "desc" => $_POST['desc'], "jobCat" => $_POST['Job_Category']);
echo $db->save_start($data);
exit;
}
if (isset($_POST["end_job"]) && $_POST["end_job"]) {
$data = array("taskID" => $_POST['taskID']);
echo $db->save_end($data);
exit;
}
if (isset($_POST["get_staff"]) && $_POST["get_staff"]) {
echo json_encode($db->get_staff());
exit;
}
if (isset($_POST["get_jobs"]) && $_POST["get_jobs"]) {
echo json_encode($db->get_jobs());
exit;
}
if (isset($_POST['update_job']) && $_POST['update_job']) {
$data = array("id" => $_POST["id"], "job_id" => $_POST['job_id'], "client" => $_POST['client'], "job_name" => $_POST['job_name'], "quoted_cost" => $_POST['quoted_cost']);
echo $db->update_job($data);
exit;
}
private function _get_popular_categories($page_slug)
{
$category_array = array();
try {
$sql = "SELECT `tags`\n FROM `" . DB_NAME . "`.`" . DB_PREFIX . "entries`\n WHERE `page_id`=(\n SELECT `page_id`\n FROM `" . DB_NAME . "`.`" . DB_PREFIX . "pages`\n WHERE `page_slug`=:page_slug\n LIMIT 0, 1\n )";
$stmt = DB_Connect::create()->db->prepare($sql);
$stmt->bindParam(':page_slug', $page_slug, PDO::PARAM_STR);
$stmt->execute();
$categories_array = $stmt->fetchAll(PDO::FETCH_OBJ);
foreach ($categories_array as $categories) {
$temp_array = explode(',', strtolower($categories->tags));
foreach ($temp_array as $category) {
if (empty($category)) {
continue;
}
$c = str_replace(' ', '-', trim($category));
if (array_key_exists($c, $category_array)) {
$category_array[$c] += 1;
} else {
$category_array[$c] = 1;
}
}
}
$stmt->closeCursor();
} catch (Exception $e) {
ECMS_Error::log_exception($e);
}
arsort($category_array);
return $category_array;
}
<?php
error_reporting(E_ALL);
ini_set('display_errors', 1);
include_once "control.php";
$db = new DB_Connect();
$staff = $db->get_staff();
//print_r($_POST);
if (isset($_POST['export_times']) && $_POST['export_times']) {
$start = $_POST['start'] . " 00:00:00";
$end = $_POST['end'] . " 23:59:59";
$staff = $_POST['staff'];
$timeSheet = $db->export_times($start, $end, $staff);
$output = fopen("php://output", 'w') or die("Can't open php://output");
header("Content-Type:application/csv;charset=utf-8;");
header("Content-Disposition:attachment;filename=Timesheet.csv;");
fputcsv($output, array('Task ID', 'Job No', 'Client', 'Job Category', 'Staff Member', 'Description', 'Start', 'End', 'Time'));
foreach ($timeSheet as $product) {
$s = strtotime($product['start']);
$e = strtotime($product['end']);
$d = abs($s - $e);
$product['time'] = sprintf('%02d:%02d:%02d', $d / 3600, $d / 60 % 60, $d % 60);
fputcsv($output, $product);
}
fclose($output) or die("Can't close php://output");
exit;
}
include "header.php";
?>
<div class="container">
<div class="row" >
<?php
include 'inc/class.PassHash.inc.php';
include 'inc/class.db_connect.inc.php';
$checkedFormsFields = checkFormField::cleanFormField($_POST);
DB_Connect::test();
if (isset($checkedFormsFields['save'])) {
$today = date("Ymd");
$query = 'insert into users (username, pass, name, firstName, lastName, regDate) values ("' . $checkedFormsFields['username'] . '", "' . PassHash::hash($checkedFormsFields['password']) . '", "' . $checkedFormsFields['name'] . '", "' . $checkedFormsFields['firstName'] . '", "' . $checkedFormsFields['lastName'] . '", "' . $today . '")';
$result = DB_Connect::query($query);
if ($result == 1) {
header('Location: index.php');
}
} else {
$query = 'select * from users where username = "******"';
$result = DB_Connect::query($query);
$fila = mysql_fetch_assoc($result);
if ($checkedFormsFields['validateUsername']) {
echo json_encode($fila);
} else {
if (PassHash::check_password($fila["pass"], $checkedFormsFields['password'])) {
header('Location: success.php');
}
}
}
function Register()
{
$birth = (string) $_POST['st_birth'];
$birth = substr($birth, 6, 4) . '-' . substr($birth, 0, 2) . '-' . substr($birth, 3, 2);
$param = array(':st_user' => (string) $_POST['st_user'], ':st_pwd' => md5((string) $_POST['st_pwd']), ':st_name' => (string) $_POST['st_name'], ':st_no' => (string) $_POST['st_no'], ':st_mail' => (string) $_POST['st_mail'], ':st_depart' => (string) $_POST['st_depart'], ':st_major' => (string) $_POST['st_major'], ':st_class' => (string) $_POST['st_class'], ':st_grade' => (string) $_POST['st_grade'], ':st_birth' => $birth, ':reg_date' => date('y-m-d', time()), ':st_edu' => intval($_POST['st_edu']));
$db = new DB_Connect();
$column = 's_user, s_num, s_pwd, dept_id, s_name, s_mail, s_date, class_id, major_id, reg_date, edu_id, s_grade';
$statement = 'insert into student(' . $column . ') values(:st_user,:st_no,:st_pwd,:st_depart,:st_name,:st_mail,:st_birth,
:st_class,:st_major,:reg_date,:st_edu,:st_grade)';
$result = $db->prepare($statement);
$result->execute($param);
echo json_encode(array('flag' => $result->rowCount()));
}
for ($i = $s_role; $i <= $s_role_to; $i++) {
$testBox[$i] = new KoolListBox("testBox_" . $i);
$testBox[$i]->id = "testBox_{$i}";
}
// <div style='clear:both'></div>
foreach ($testBox as $box) {
$box->AllowTransferOnDoubleClick = true;
$box->Width = "300px";
$box->Height = "490px";
$box->styleFolder = "default";
$box->AllowMultiSelect = true;
}
$testBox[$s_role]->TransferToId = "testBox_{$s_role_to}";
$testBox[$s_role]->ButtonSettings->ShowTransfer = true;
$testBox[$s_role]->ButtonSettings->ShowTransferAll = true;
$db = new DB_Connect();
$sth = $db->prepare($sel);
$sth->execute();
while ($row = $sth->fetch(PDO::FETCH_ASSOC)) {
$role = (int) $row['s_role'];
$item = new ListBoxItem();
$item->Data = array("s_name" => $row['s_name'], "s_num" => $row['s_num'], "s_id" => $row['s_id']);
$testBox[$role]->AddItem($item);
}
foreach ($testBox as $box) {
$box->ItemTemplate = "<div class='student_list_item' id='{s_id}'>姓名:<strong>{s_name}</strong><label id='noLabel'>学号:<strong>{s_num}</strong></label></div>";
$box->Init();
echo "<div style='padding:20px;float:left;'>";
echo $box->Render();
echo "</div>";
}
public function getRandAns($test_type_id = -1, $que_of_num = 60)
{
$sql = "select * from question where q_type=2 ";
if ($test_type_id != -1) {
$sql .= " and test_type_id={$test_type_id}";
}
$sth = parent::prepare($sql);
$sth->execute();
$res_all = $sth->fetchAll();
$res_rand = array();
$pid_num = count($res_all);
$temp = array();
if ($pid_num < $que_of_num) {
$que_of_num = $pid_num;
}
for ($i = 0; $i < $que_of_num; $i++) {
$rand_num = rand(0, $pid_num - $i - 1);
$res_rand[$i] = $res_all[$rand_num];
$temp = $res_all[$rand_num];
$res_all[$rand_num] = $res_all[$pid_num - $i - 1];
$res_all[$pid_num - $i - 1] = $temp;
}
return $res_rand;
}
<?php
set_time_limit(0);
require 'class/xmlrpc.php';
require "instaconnect.php";
include 'class/api.php';
require_once '/home/golive/public_html/class/db.cls.php';
$db = new DB_Connect(MYSQL_INSTACONNECT, true);
$db->log_type = MYSQL_INSTACONNECT;
if (isset($HTTP_RAW_POST_DATA)) {
$rxml = $HTTP_RAW_POST_DATA;
} else {
$rxml = implode("\r\n", file('php://input'));
}
#192.168.0.1
#Gol1v3inc5002012
$host = '50.17.202.43';
$username = '******';
$password = '******';
$dbms = 'asteriskvoip';
/*mysql_connect($host,$username,$password) or die ('Error connecting to mysql');
mysql_select_db($dbms); */
$db_voip = new mysqli($host, $username, $password, $dbms);
#$dbserver = "10.10.26.134";
$dbserver = "cluster-db.crfsqbh1kkpg.us-west-2.rds.amazonaws.com";
$dbuser = "******";
$dbpass = "******";
$dbdata = "voicechanger_web";
$db2 = new mysqli($dbserver, $dbuser, $dbpass, $dbdata);
$rxml = urldecode($rxml);
$db->logfile("voicechanger; {$rxml} ;");
function Register()
{
$birth = (string) $_POST['st_birth'];
//$birth = substr($birth,6,4).'-'.substr($birth,0,2).'-'.substr($birth,3,2);
$param = array($_POST['st_user'], $_POST['st_no'], md5($_POST['st_pwd']), $_POST['st_name'], $_POST['st_mail'], $_POST['st_phone'], $birth, $_POST['st_class'], date('y-m-d', time()), intval($_POST['st_edu']), $_POST['st_grade']);
$db = new DB_Connect();
$column = 's_user, s_num, s_pwd, s_name, s_mail, s_phone, s_date, class_id, reg_date, edu_id, s_grade';
$statement = 'insert into students(' . $column . ') values(?,?,?,?,?,?,?,?,?,?,?)';
$result = $db->prepare($statement);
$result->execute($param);
echo json_encode(array('flag' => $result->rowCount()));
}
<?php
if (isset($_POST['submit'])) {
include_once 'db_functions.php';
$db = new DB_Functions();
$email = "test";
$i = 0;
$regId = array();
$msg = array();
$message = $_POST["message"];
include_once './gcm.php';
$gcm = new GCM();
$c = new DB_Connect();
$d = $c->connect();
$res = mysqli_query($d, "SELECT * FROM gcm_users WHERE email = '{$email}'") or die(mysql_error());
while ($row = mysqli_fetch_array($res)) {
$regId[$i] = $row["gcm_regid"];
$msg[$i] = $message;
$i = $i + 1;
}
for ($j = 0; $j < sizeof($regId); $j = $j + 1) {
$registatoin_ids = array($regId[$j]);
$message = array("price" => $msg[$j]);
$result = $gcm->send_notification($registatoin_ids, $message);
echo $result;
}
}
<?php
include "header.php";
include_once "control.php";
$db = new DB_Connect();
if ($_POST['add_a_job']) {
$data = array("job_id" => $_POST['jobid'], "client" => $_POST['client'], "job_name" => $_POST['jobname'], "quoted_cost" => $_POST['quoted']);
// print_r($data);
if ($db->add_job($data)) {
echo '<div class="alert alert-success" role="alert">' . $_POST['jobid'] . ' added sucessfully</div>';
} else {
echo '<div class="alert alert-danger" role="alert">failed to add job ' . $_POST['jobid'] . '</div>';
}
}
?>
<div id="" class="container">
<div id="heading">
<h1>Create a new job</h1>
</div>
<div id="timesheet" class="row">
<form method="post" action="">
<div id="job_id" class="col-xs-1">
<input placeholder="Job No." type="text" name="jobid">
</div>
<div id="client_name" class="col-xs-2">
<input placeholder="Client" type="text" name="client">
</div>
require_once __DIR__ . '/include/util.inc';
require_once __DIR__ . '/include/db_connect.php';
require_once '/home/vcap/app/lib/vendor/autoload.php';
use PhpAmqpLib\Connection\AMQPConnection;
use PhpAmqpLib\Message\AMQPMessage;
//header('Content-type: text/html');
header('Access-Control-Allow-Origin: *');
$services = getenv('VCAP_SERVICES');
$json = json_decode($services, TRUE);
$hostname = $json['p-rabbitmq'][0]['credentials']['protocols']['amqp']['host'];
$user = $json['p-rabbitmq'][0]['credentials']['protocols']['amqp']['username'];
$password = $json['p-rabbitmq'][0]['credentials']['protocols']['amqp']['password'];
$port = $json['p-rabbitmq'][0]['credentials']['protocols']['amqp']['port'];
$vhost = $json['p-rabbitmq'][0]['credentials']['protocols']['amqp']['vhost'];
$db = new DB_Connect();
$db->connect();
$system_id = string_escape(util_aiod($_POST, 'ID', ""));
$name = string_escape(util_aiod($_POST, 'name', ""));
$type = 'Thin';
$capacity = string_escape(util_aiod($_POST, 'capacity', ""));
$offset = 0;
$sq = 'gb';
$pool_id = '0';
$sp = string_escape(util_aiod($_POST, 'sp', ""));
$auto_assignment = '1';
$tiering_policy = 'autoTier';
$initial_tier = 'highestAvailable';
$cmd = "naviseccli lun -create -type " . $type . " -capacity " . $capacity . " -sq " . $sq . " -poolId " . $pool_id . " -sp " . $sp . " -aa " . $auto_assignment . " -name " . $name . " -offset " . $offset . " -tieringPolicy " . $tiering_policy . " -initialTier " . $initial_tier;
$result = mysql_query("INSERT INTO `requests` (system_id, cmd, type, status) values ('{$system_id}', '{$cmd}', 'create_lun', 'N');");
$tuple_id = mysql_insert_id();
function getMessageTypeToSelect()
{
$db = new DB_Connect();
$statement = "select * from information_types";
$result = $db->prepare($statement);
$result->execute();
$first = 1;
$ret = "";
while ($row = $result->fetch()) {
$ret = $ret . "<option value='" . $row['id'] . "'>" . $row['name'] . "</option>";
}
echo json_encode(array('content' => $ret));
}
