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}"); }