function crearUsuario($nombre, $password, $permisos)
{
if (Database::isUser($nombre)) {
Database::insertData($nombre, $password, $permisos);
return true;
} else {
return false;
}
}
$PhaseofTreatment = $_REQUEST['PhaseofTreatment'];
$DiseasesClassification = $_REQUEST['DiseasesClassification'];
//$subscriberDisease=$_REQUEST['subscriberDisease'];
$sub_BloodGroup = $_REQUEST['bg_type'];
//database
$db = new Database();
$db->connect();
//Generation of ID
$rt = new retrieval();
$sub_id = $rt->subscriber();
$con_id = $rt->contact_person();
echo $con_id;
$dot_id = $rt->dot_provider();
//Adding Contact Person details
$query = "INSERT INTO subscriber_contactpersons( user_id, contact_name, contact_contact, contact_address, contact_city, contact_state, contact_relation) VALUES('{$con_id}','{$c_subName}','{$c_subContact}', '{$c_subAddress}', '{$c_subCity}', '{$c_subState}', '{$realtionship}')";
if (empty($db->insertData($query))) {
echo "Error in Contact";
} else {
$query = "INSERT INTO subscriber_dotprovider(user_id,dot_name,dot_address,dot_city,dot_state,dot_contact)\n\t\t\t\t\tVALUES('{$dot_id}','{$d_subName}','{$d_subAddress}','{$d_subCity}','{$d_subState}','{$d_subContact}')";
if (empty($db->insertData($query))) {
echo "Error in Dot";
} else {
$query = "INSERT INTO subscribers (user_id,contact_person_id,dot_id,doc_id,TB_no,TB_unit,Nikshay_no,Name_phi,sub_name,sub_sex,sub_DOB,sub_occupation,sub_contact,sub_address,sub_city,sub_state,sub_type,sub_blood_group) \n\t\t\t\t\t\tVALUES ('{$sub_id}','{$con_id}','{$dot_id}','{$doc_id}','{$TB_no}','{$TB_unit}','{$Nikshay_no}','{$Name_phi}','{$subName}','{$subSex}','{$subDOB}','{$subOccupation}','{$subContact}','{$subAddress}','{$subCity}','{$subState}','{$sub_type}','{$sub_BloodGroup}')";
if (empty($db->insertData($query))) {
echo "Error in user";
} else {
$pass = md5($sub_id);
$query = "insert into users(user_id,password,type_of_user,user_verified) VALUES('{$sub_id}','{$pass}','2','2')";
$db->insertData($query);
$_SESSION['image'] = $Nikshay_no;
$_SESSION['image_path'] = "uploads/subscriber/";
$rand = rand(1, 1000000);
$cleansedCName = str_replace(" ", "_", $cleansedCName);
$vendorFolderName = $cleansedCName . '_' . $rand;
//Check if folder exists
if (file_exists($vendorFolderName)) {
$rand = rand(1, 1000000);
//Gen new rand num
$vendorFolderName = $cleansedCName . '_' . $rand;
} else {
mkdir("../../images/Vendor/" . $vendorFolderName, 0777);
//Vendor root folder
mkdir("../../images/Vendor/" . $vendorFolderName . "/products", 0777);
//folder to store product images
//Push data to the database
$insert = "INSERT INTO Vendor(vendorName, vendorAddressLine1, vendorAddressLine2, vendorCity, vendorTelephone, vendorAccountCreation,vendorFolderName,vendorDescription,vendorEmail,vendorPassword )VALUES ('{$cName}', '{$addressLine1}', '{$addressLine2}', '{$city}','{$phone}', NOW( ),'{$vendorFolderName}','{$description}','{$email}' , '{$pass1}')";
$connection->insertData($insert);
$connection->closeConnection();
}
?>
<?php
} else {
//Print All the errors instead of the account summary
echo '<div style="margin-top:20px; border:1px solid white;">';
for ($i = 0; $i < count($errors); $i++) {
echo '<center><span class="error">' . $errors[$i] . '</span></center><br>';
}
//Close for loop
echo '<script type="text/javascript">resetPassword()</script>';
<?php
include "../classes/database.php";
if (isset($_POST['intakemedicine'])) {
# write code to decode json
$intake = json_decode($_POST['intakemedicine'], true);
$nikshay_no = $intake['nikshay_no'];
#$query="UPDATE medicine_intake set medicine='1' where nikshay_no='$nikshay_no'";
$query = "INSERT INTO medicine_intake (Nikshay_no,intake) VALUES('{$nikshay_no}','True')";
$db = new Database();
$db->connect();
if (!empty($db->insertData($query))) {
echo true;
} else {
echo false;
}
$db->disconnect();
}
* @package classes/databases
* @file db-test.php
* @data 26/10/15
* @author Graham Murray <*****@*****.**>
* @copyright Copyright (c) 2015
* @description This file is to test the Database class to ensure it functions correctly.
*/
include 'database-connect.php';
$connection = new Database();
//Instance of Database Class
$connection->connectToDatabase();
//Connect to database
echo '<br>';
//Insert Query
$insertSQL = "INSERT INTO Customer( customerFname, customerLname, customerEmail, customerAddress, customerDOB, customerAccountCreation, \tcustomerPassword )VALUES ('John', 'Newman', '*****@*****.**', '133 Hilltown Lawn', '1935/11/18', NOW( ) , '2324')";
$connection->insertData($insertSQL);
//Select Query
$statement = "SELECT * FROM Customer";
$dataset = $connection->selectData($statement);
//Update Query
$update = "UPDATE Customer SET customerFname='Fart' WHERE customerId=3";
$connection->updateDatabase($update);
for ($i = 61; $i <= 67; $i++) {
//Delete Data
$delete = "DELETE FROM Customer\n\t\tWHERE customerId = " . $i;
$connection->deleteData($delete);
echo 'Record ' . $i . ' deleted';
}
//Close Connection
$connection->closeConnection();
//List all values
$createUser = true;
$newUserName = $DB->escapeData($_POST['login']);
/* Check */
if ($_POST['password-one'] != $_POST['password-two']) {
$createUser = false;
}
if (count($DB->getData("users", "WHERE login='******'")) > 0) {
$createUser = false;
}
/* Construct */
$newUser['login'] = $_POST['login'];
$newUser['name'] = $_POST['name'];
$newUser['password'] = $Auth->construct_SSHA($_POST['password-one']);
$newUser['class'] = $_POST['class'];
/* IF - OK - Send create */
$userCreated = $DB->insertData("users", $newUser);
if ($userCreated) {
$spawnSuccess = true;
$spawnSuccessText = "User <strong>" . $newUser['login'] . "</strong> has been created successfully.";
} else {
$spawnError = true;
$spawnErrorText = "Unable to comply. User <strong>" . $newUser['login'] . "</strong> was NOT created.";
}
$loadFormUsers = "users.default.tpl";
} elseif (isset($_GET['deleteID']) and $_GET['deleteID'] != "" and $_GET['deleteID'] > 0) {
$rowDeleted = false;
if ($_GET['deleteID'] != $_SESSION['id']) {
/* IF checks passed - Delete user entry */
$deleteRowId = $DB->escapeData($_GET['deleteID']);
$rowDeleted = $DB->deleteRow("users", $deleteRowId);
}
private function store($data)
{
$id = Database::insertData('bond', $data);
self::log("Add Data {$data['date']} Ok {$id}");
}
