[K.....u]

#include
#include "stdafx.h"
#include
#include
#include
#include
char Code(char, char);
char deCode(char, char);
int main()
{

std::string Password = "";
int choice = 1;
std::cout << "Podaj hasło kodowania: " << std::endl;
std::cin >> Password;
std::cout << "Chces zakodowac (1) czy zdekodowac (2)?: " << std::endl;
std::cin >> choice;

std::transform(Password.begin(), Password.end(), Password.begin(), toupper);

std::fstream inputFile;
std::fstream outputFile;
inputFile.open("data.txt", std::ios::in);
if (inputFile.good())
{
outputFile.open("out.txt", std::ios::out);

if (outputFile.good())
{
int PasswordCharIndex = 0;
while (!inputFile.eof())
{

unsigned char fromFile = 0;
inputFile >> std::noskipws >> fromFile;
char tmp = toupper(fromFile);

switch (choice)
{
case 1:
tmp = Code(Password[PasswordCharIndex], tmp);
break;
case 2:
tmp = deCode(Password[PasswordCharIndex], tmp);
break;
default:
break;
}
outputFile << tmp;

PasswordCharIndex++;
if (PasswordCharIndex > Password.size() - 1)
PasswordCharIndex = 0;

}
}
}
else
{
std::cerr << "Błąd otwarcia pliku input" << std::endl;
}
inputFile.close();
outputFile.close();

std::cin.clear();
getchar();
system("PAUSE");
return 0;
}

char Code(char passwordChar, char charToCode)
{
std::string Alphabet = "ABCDEFGHIJKLMNOPQRSTUVWXYZ123456789";
char ret = 0;
for (int i = 0; i < Alphabet.size(); i++)
{
if (Alphabet[i] == charToCode)
{
char temp = charToCode;
for (int j = 0; j < Alphabet.size(); j++)
{
if (Alphabet[j] == passwordChar)
break;
temp++;
if (temp > '9' & temp < 'A')
temp = 'A';
else if (temp > 'Z')
temp = '0';
}
ret = temp;
break;
}

}



return ret;
}
char deCode(char passwordChar, char charTodeCode)
{
std::string Alphabet = "ABCDEFGHIJKLMNOPQRSTUVWXYZ123456789";
char ret = '\0';

for (int i = 0; i < Alphabet.size(); i++)
{
if (Alphabet[i] == passwordChar)
{
int decodedIndex = 0;
char temp = passwordChar;
for (int j = 0; j < Alphabet.size(); j++)
{

if (temp == charTodeCode)
{
decodedIndex = j;
break;
}
temp++;
if (temp > '9' & temp < 'A')
temp = 'A';
else if (temp > 'Z')
temp = '0';

}
ret = Alphabet[decodedIndex];
break;
}

}

return ret;
}
============END:3069437=============
===========BEGIN============
php
class SQLManager{
const DBHOST = 'localhost';
const DBNAME = 'benzfamilia';
const DBUSER = 'root';
const DBPASS = '';
private $pdo = null;

/*
----------------------------------- READ ME -------------------------------
$mysqlhost = 'localhost'; //lub jakiś adres: np sql.nazwabazy.nazwa.pl
$port = '3307'; //domyślnie jest to port 3306
$username = 'login';
$password = 'hasło';
$database = 'nazwa_bazy'; //'produkty'

unset($BlobObj); <- skasuje obiekt przed koncem skryptu
*/

public function _construct(){
$connection = sprintf("mysql:host=%s;dbname=%s;charset=utf8;", self::DBHOST, self::DBNAME);

try{
$this -pdo = new PDO($connection, self::DBUSER, self::DBPASS);
echo 'Connected';
}catch (PDOException $e) {
//echo 'Error';
echo $e->getMessage();
}
}

public function destruct() {
$this->pdo = null;
}

//------------------------------- IMAGES METHODS -----------------------

public function insertImage($filePath, $mime, $partid) {
$blob = fopen($filePath, 'rb');

$sql = "INSERT INTO Image(mime,image,partid) VALUES(default, :mime, :image, :partid)";
$stmt = $this->pdo->prepare($sql);

$stmt->bindParam(':mime', $mime);
$stmt->bindParam(':image', $blob, PDO::PARAMLOB);
$stmt->bindParam(':partid', $partid);

return $stmt->execute(); // $stmt->closeCursor(); lub unset($stmt); // gdzies // zwraca boola
}

public function selectImage($id) {
$sql = "SELECT image FROM Image i JOIN Part p WHERE i.partid = :id;";
$stmt = $this->pdo->prepare($sql);

$stmt->execute(array(":id" => $id)); // id wewnatrz to bindowanie parametrow wejsciowych zamiast bindParam();
//$stmt->bindColumn(1, $mime);
$stmt->bindColumn(1, $obraz, PDO::PARAMLOB);

$stmt->fetch(PDO::FETCHBOUND);

return array("obraz" => $obraz);
// typ mime prawdopodobnie mozna wpisac w headerze na sztywno: image/jpeg, image/png jesli nie trzeba zrobc cos takiego:
//

}

//-------------------------------- PACKAGE METHODS ------------------------

public function insertPackage($name){
$sql = "INSERT INTO Package VALUES(default, :name)"; // mozliwe ze trzeba bedzie dopisac default(primary key)
$stmt = $this->pdo->prepare($sql);

$stmt->bindParam(':name', $name);

return $stmt->execute();
}

public function selectPackage($name){
$sql = "SELECT packageid, packagename FROM Package WHERE packagename = :name;";
$stmt = $this->pdo->prepare($sql);

$result = $stmt->execute(array(":name" => $name));

if($result){
$stmt->bindColumn(1,$packageid);
$stmt->bindColumn(2,$name);
$stmt->fetch(PDO::FETCHBOUND);

return array("id" =>$packageid, "name" => $name);
}else{
// return echo 'Select package error:\n' . $this->pdo->errorInfo();
}
}

public function deletePackage($name){
$sql = "DELETE FROM Package WHERE packagename = :name;";
$stmt = $this->pdo->prepare($sql);

$stmt->bindParam(':name', $name);

return $stmt->execute();
}

public function updatePackage($oldName, $newName){
$sql = "UPDATE Package SET packagename = :newName WHERE packagename = :oldName;";
$stmt = $this->pdo->prepare($sql);

$stmt->bindParam(':oldName', $oldName);
$stmt->bindParam(':newName', $newName);

return $stmt->execute();

}

//--------------------------------- MODEL METHODS -----------------------------

public function insertModel($name, $packageid){
$sql = "INSERT INTO Model VALUES(default, :name, :packageid)"; // mozliwe ze trzeba bedzie dopisac default(primary key)
$stmt = $this->pdo->prepare($sql);

$stmt->bindParam(':name', $name);
$stmt->bindParam(':packageid', $packageid);

return $stmt->execute();
}

public function selectModel($name){
$sql = "SELECT modelid, name FROM Model WHERE modelname = :name;";
$stmt = $this->pdo->prepare($sql);

$result = $stmt->execute(array(":name" => $name));

if($result){
$stmt->bindColumn(1,$modelid);
$stmt->bindColumn(2,$name);
$stmt->fetch(PDO::FETCHBOUND);
return array("id" =>$modelid, "name" =>$name);
}else{
// return echo 'Select Model error:\n' . $this->pdo->errorInfo();
}
}

public function deleteModel($name){
$sql = "DELETE FROM Model WHERE modelname = :name;";
$stmt = $this->pdo->prepare($sql);

$stmt->bindParam(':name', $name);

return $stmt->execute();
}

public function updateModel($oldName, $newName){
$sql = "UPDATE Model SET modelname = :newName WHERE modelname = :oldName;";
$stmt = $this->pdo->prepare($sql);

$stmt->bindParam(':oldName', $oldName);
$stmt->bindParam(':newName', $newName);

return $stmt->execute();

}

//--------------------------------- VARIANT METHODS ----------------------------------

public function insertVariant($name, $modelid){
$sql = "INSERT INTO Variant VALUES(default, :name, :modelid)"; // mozliwe ze trzeba bedzie dopisac default(primary key)
$stmt = $this->pdo->prepare($sql);

$stmt->bindParam(':name', $name);
$stmt->bindParam(':modelid', $modelid);

return $stmt->execute();
}

public function selectVariant($name){
$sql = "SELECT variantid, variantname FROM Variant WHERE variantname = :name;";
$stmt = $this->pdo->prepare($sql);

$result = $stmt->execute(array(":name" => $name));

if($result){
$stmt->bindColumn(1,$modelid);
$stmt->bindColumn(2,$name);

$stmt->fetch(PDO::FETCHBOUND);
return array("id" => $modelid, "name" => $name);
}else{
// return echo 'Select Variant error:\n' . $this->pdo->errorInfo();
}
}

public function deleteVariant($name){
$sql = "DELETE FROM Variant WHERE variantname = :name;";
$stmt = $this->pdo->prepare($sql);

$stmt->bindParam(':name', $name);

return $stmt->execute();
}

public function updateVariant($oldName, $newName){
$sql = "UPDATE Variant SET variantname = :newName WHERE variantname = :oldName;";
$stmt = $this->pdo->prepare($sql);

$stmt->bindParam(':oldName', $oldName);
$stmt->bindParam(':newName', $newName);

return $stmt->execute();

}

//--------------------------------- PART METHODS ---------------------------------------

public function insertPart($namepl, $nameeng, $price, $descproduct, $descmontage, $descdelivery, $descinfo, $variantid){
$sql = "INSERT INTO Part VALUES(default, :namepl, :nameeng, :price, :descproduct, :descmontage, :descdelivery, descinfo, :variantid)";
$stmt = $this->pdo->prepare($sql);

$stmt->bindParam(':namepl', $namepl);
$stmt->bindParam(':nameeng', $nameeng);
$stmt->bindParam(':price', $price);
$stmt->bindParam(':descproduct', $descproduct);
$stmt->bindParam(':descmontage', $descmontage);
$stmt->bindParam(':descdelivery', $descdelivery);
$stmt->bindParam(':descinfo', $descinfo);
$stmt->bindParam(':variantid', $variantid);

return $stmt->execute();
}

public function selectPart($name){
$sql = "SELECT partid, partnamepl, partnameeng FROM Part WHERE partname = :name;"; // do dokonczenia
$stmt = $this->pdo->prepare($sql);

$result = $stmt->execute(array(":name" => $name));

if($result){
$stmt->bindColumn(1,$partid);
$stmt->bindColumn(2,$partnamepl);
$stmt->bindColumn(3,$partnameeng);

$stmt->fetch(PDO::FETCHBOUND);
return array("id" => $partid, "name" => $name);
}else{
// return echo 'Select Part error:\n' . $this->pdo->errorInfo();
}
}

public function deletePart($name){
$sql = "DELETE FROM Part WHERE partname = :name;";
$stmt = $this->pdo->prepare($sql);

$stmt->bindParam(':name', $name);

return $stmt->execute();
}

public function updatePart($oldName, $newName){ // do dopisania wersje z opisami
$sql = "UPDATE Part SET partname = :newName WHERE partname = :oldName;";
$stmt = $this->pdo->prepare($sql);

$stmt->bindParam(':oldName', $oldName);
$stmt->bindParam(':newName', $newName);

return $stmt->execute();

}

};
?>