" . $query_getObjectIdByNotString);
$stmt_getObjectIdByNotString = $dbh->prepare($query_getObjectIdByNotString);
if (!$stmt_getObjectIdByNotString) {
echo "\nPDO::errorInfo():\n";
print_r($dbh->errorInfo());
}
$stmt_getObjectIdByNotString->bindParam(':Column_value', $Column_value);
if ($stmt_getObjectIdByNotString->execute()) {
$row_getObjectIdByNotString = $stmt_getObjectIdByNotString->fetch();
$num_getObjectIdByNotString = $stmt_getObjectIdByNotString->rowCount();
}
$Value = stripslashes($row_getObjectIdByNotString["Cols"]);
//print("
Cols: ". $Value);
return $Value;
}
function checkForObjectExistence3Values($Table, $Column, $Value, $Column2, $Value2, $Column3, $Value3)
{
//funkcja weryfikuje istnienie obiektu na podstawie 2 kolumn charakterystycznych i zadanego statusu
include('include/db_conn2.php');
$query =
'SELECT
COUNT(*) AS ObjectCount
FROM
' . $Table . '
WHERE
' . $Column . ' = :Value
AND
' . $Column2 . ' = :Value2
AND
' . $Column3 . ' = :Value3
';
//print($query);
//print($Value . ', ' . $Value2 . ', '. $Value);
$stmt = $dbh->prepare($query);
if (!$stmt) {
echo "\nPDO::errorInfo():\n";
print_r($dbh->errorInfo());
}
$stmt->bindParam(':Value', $Value);
$stmt->bindParam(':Value2', $Value2);
$stmt->bindParam(':Value3', $Value3);
if ($stmt->execute()) {
$row = $stmt->fetch();
$num_results = $stmt->rowCount();
}
$ObjectCount = stripslashes($row["ObjectCount"]);
if($ObjectCount == 1)
{
return 1;
}
else
{
return 0;
}
}
function getObjectIdBy3ValuesNonString($Table, $Column_wanted, $Column_given, $Column_value, $Column_given2, $Column_value2, $Column_given3, $Column_value3)
{
//funkcja pobiera id obiektu po jego nazwie
include('include/db_conn2.php');
$query =
'SELECT
'. $Column_wanted .' AS Cols
FROM
' . $Table . '
WHERE
' . $Column_given . ' = :Column_value
AND
' . $Column_given2 . ' = :Column_value2
AND
' . $Column_given3 . ' = :Column_value3
' ;
//print("
" . $query_getObjectIdByName);
$stmt = $dbh->prepare($query);
if (!$stmt) {
echo "\nPDO::errorInfo():\n";
print_r($dbh->errorInfo());
}
$stmt->bindParam(':Column_value', $Column_value);
$stmt->bindParam(':Column_value2', $Column_value2);
$stmt->bindParam(':Column_value3', $Column_value3);
if ($stmt->execute()) {
$row = $stmt->fetch();
$num = $stmt->rowCount();
}
$Value = stripslashes($row["Cols"]);
//print("
Cols: ". $Value);
return $Value;
}
function getObjectIdBy2ValuesNonString($Table, $Column_wanted, $Column_given, $Column_value, $Column_given2, $Column_value2)
{
//funkcja pobiera id obiektu po jego nazwie
include('include/db_conn2.php');
if ($Table == "orders") {
$query_getObjectIdBy2ValuesNonString =
'SELECT
'. $Column_wanted .' AS Cols
FROM
' . $Table . '
WHERE
' . $Column_given . ' = :Column_value
AND
' . $Column_given2 . ' = :Column_value2
ORDER BY id DESC
' ;
} else {
$query_getObjectIdBy2ValuesNonString =
'SELECT
'. $Column_wanted .' AS Cols
FROM
' . $Table . '
WHERE
' . $Column_given . ' = :Column_value
AND
' . $Column_given2 . ' = :Column_value2' ;
}
//print("
" . $query_getObjectIdByName);
$stmt_getObjectIdBy2ValuesNonString = $dbh->prepare($query_getObjectIdBy2ValuesNonString);
if (!$stmt_getObjectIdBy2ValuesNonString) {
echo "\nPDO::errorInfo():\n";
print_r($dbh->errorInfo());
}
$stmt_getObjectIdBy2ValuesNonString->bindParam(':Column_value', $Column_value);
$stmt_getObjectIdBy2ValuesNonString->bindParam(':Column_value2', $Column_value2);
if ($stmt_getObjectIdBy2ValuesNonString->execute()) {
$row_getObjectIdBy2ValuesNonString = $stmt_getObjectIdBy2ValuesNonString->fetch();
$num_getObjectIdBy2ValuesNonString = $stmt_getObjectIdBy2ValuesNonString->rowCount();
}
$Value = stripslashes($row_getObjectIdBy2ValuesNonString["Cols"]);
//print("
Cols: ". $Value);
return $Value;
}
function changeObjectColumnValue($table, $given_column, $given_column_value, $column_name, $column_value)
{
include('include/db_conn2.php');
$query_changeObjectColumnValue = 'UPDATE ' . $table . ' SET
`'.$column_name.'` = :column_value
WHERE '. $given_column .' = :given_column_value';
//print($query_changeObjectColumnValue);
$stmt_changeObjectColumnValue = $dbh->prepare($query_changeObjectColumnValue);
if (!$stmt_changeObjectColumnValue) {
echo "\nPDO::errorInfo():\n";
print_r($dbh->errorInfo());
}
$stmt_changeObjectColumnValue->bindParam(':column_value', $column_value);
$stmt_changeObjectColumnValue->bindParam(':given_column_value', $given_column_value);
$stmt_changeObjectColumnValue->execute();
return TRUE;
}
function checkForObjectExistence2Values($Table, $Column, $Value, $Column2, $Value2)
{
//funkcja weryfikuje istnienie obiektu na podstawie 2 kolumn charakterystycznych i zadanego statusu
include('include/db_conn2.php');
$query =
'SELECT
COUNT(*) AS ObjectCount
FROM
' . $Table . '
WHERE
' . $Column . ' = :Value
AND
' . $Column2 . ' = :Value2
';
//print($query);
//print($Value . ', ' . $Value2 . ', '. $Value);
$stmt = $dbh->prepare($query);
if (!$stmt) {
echo "\nPDO::errorInfo():\n";
print_r($dbh->errorInfo());
}
$stmt->bindParam(':Value', $Value);
$stmt->bindParam(':Value2', $Value2);
if ($stmt->execute()) {
$row = $stmt->fetch();
$num_results = $stmt->rowCount();
}
$ObjectCount = stripslashes($row["ObjectCount"]);
if($ObjectCount > 0)
{
return 1;
}
else
{
return 0;
}
}
function changeObjectColumnValue2Values($table, $given_column, $given_column_value, $given_column2, $given_column_value2, $column_name, $column_value)
{
include('include/db_conn2.php');
$query = 'UPDATE ' . $table . ' SET
'.$column_name.' = :column_value
WHERE '. $given_column .' = :given_column_value AND ' . $given_column2 .' = :given_column_value2';
//print($query_changeObjectColumnValue);
$stmt = $dbh->prepare($query);
if (!$stmt) {
echo "\nPDO::errorInfo():\n";
print_r($dbh->errorInfo());
}
if($column_value == "")
{
$column_value = NULL;
}
//$column_value = addslashes($column_value);
$stmt->bindParam(':column_value', $column_value);
$stmt->bindParam(':given_column_value', $given_column_value);
$stmt->bindParam(':given_column_value2', $given_column_value2);
$stmt->execute();
return TRUE;
}
function createObject2Values($table, $columns, $value, $value2)
{
include('include/db_conn2.php');
$query =
'INSERT INTO ' . $table . ' ('.$columns.')
VALUES (:value, :value2)';
//print($query);
$stmt = $dbh->prepare($query);
if (!$stmt) {
echo "\nPDO::errorInfo():\n";
print_r($dbh->errorInfo());
}
$stmt->bindParam(':value', $value);
$stmt->bindParam(':value2', $value2);
$stmt->execute();
return TRUE;
}
function createObject7Values($table, $columns, $value, $value2, $value3, $value4, $value5, $value6, $value7)
{
include('include/db_conn2.php');
$query =
'INSERT INTO ' . $table . ' ('.$columns.')
VALUES (:value, :value2, :value3, :value4, :value5, :value6, :value7)';
//print($query);
$stmt = $dbh->prepare($query);
if (!$stmt) {
echo "\nPDO::errorInfo():\n";
print_r($dbh->errorInfo());
}
$stmt->bindParam(':value', $value);
$stmt->bindParam(':value2', $value2);
$stmt->bindParam(':value3', $value3);
$stmt->bindParam(':value4', $value4);
$stmt->bindParam(':value5', $value5);
$stmt->bindParam(':value6', $value6);
$stmt->bindParam(':value7', $value7);
$stmt->execute();
return TRUE;
}
function createObject8Values($table, $columns, $value, $value2, $value3, $value4, $value5, $value6, $value7, $value8)
{
include('include/db_conn2.php');
$query =
'INSERT INTO ' . $table . ' ('.$columns.')
VALUES (:value, :value2, :value3, :value4, :value5, :value6, :value7, :value8)';
//print($query);
$stmt = $dbh->prepare($query);
if (!$stmt) {
echo "\nPDO::errorInfo():\n";
print_r($dbh->errorInfo());
}
$stmt->bindParam(':value', $value);
$stmt->bindParam(':value2', $value2);
$stmt->bindParam(':value3', $value3);
$stmt->bindParam(':value4', $value4);
$stmt->bindParam(':value5', $value5);
$stmt->bindParam(':value6', $value6);
$stmt->bindParam(':value7', $value7);
$stmt->bindParam(':value8', $value8);
$stmt->execute();
return TRUE;
}
function createObject5Values($table, $columns, $value, $value2, $value3, $value4, $value5)
{
include('include/db_conn2.php');
$query =
'INSERT INTO ' . $table . ' ('.$columns.')
VALUES (:value, :value2, :value3, :value4, :value5)';
//print($query);
$stmt = $dbh->prepare($query);
if (!$stmt) {
echo "\nPDO::errorInfo():\n";
print_r($dbh->errorInfo());
}
$stmt->bindParam(':value', $value);
$stmt->bindParam(':value2', $value2);
$stmt->bindParam(':value3', $value3);
$stmt->bindParam(':value4', $value4);
$stmt->bindParam(':value5', $value5);
$stmt->execute();
return TRUE;
}
// NEW 10.06.2018 // CREATE PRODUCT
function createObject11Values($table, $columns, $value, $value2, $value3, $value4, $value5, $value6, $value7, $value8, $value9, $value10, $value11)
{
include('include/db_conn2.php');
$query =
'INSERT INTO ' . $table . ' ('.$columns.')
VALUES (:value, :value2, :value3, :value4, :value5, :value6, :value7, :value8, :value9, :value10, :value11)';
//print($query);
$stmt = $dbh->prepare($query);
if (!$stmt) {
echo "\nPDO::errorInfo():\n";
print_r($dbh->errorInfo());
}
$stmt->bindParam(':value', $value);
$stmt->bindParam(':value2', $value2);
$stmt->bindParam(':value3', $value3);
$stmt->bindParam(':value4', $value4);
$stmt->bindParam(':value5', $value5);
$stmt->bindParam(':value6', $value6);
$stmt->bindParam(':value7', $value7);
$stmt->bindParam(':value8', $value8);
$stmt->bindParam(':value9', $value9);
$stmt->bindParam(':value10', $value10);
$stmt->bindParam(':value11', $value11);
$stmt->execute();
return TRUE;
}
function getObjectAmountWith2Values($Table, $Column, $Column_value, $Column2, $Column_value2)
{
include('include/db_conn2.php');
$query =
'SELECT
COUNT(*) AS DocsCount
FROM
' . $Table . '
WHERE
' . $Column . ' = :Column_value
AND '
. $Column2 . ' = :Column_value2
';
// print('
' . $Column_value . ' , ' . $Column_value2 . ' ' . $query . '
');
$stmt = $dbh->prepare($query);
$stmt->bindParam(':Column_value', $Column_value);
$stmt->bindParam(':Column_value2', $Column_value2);
if ($stmt->execute()) {
$row = $stmt->fetch();
$num_results = $stmt->rowCount();
}
$Amount = stripslashes($row["DocsCount"]);
if($Amount == "")
{
return 0;
}
else
{
return $Amount;
}
}
function deleteObjectWithTwoElementsAndWhereClause($table, $column_name, $column_value, $column_name2, $column_value2, $whereClause)
{
include('include/db_conn2.php');
$query = 'DELETE FROM ' . $table . '
WHERE '. $column_name .' = :column_value
AND
'. $column_name2 . $whereClause .' :column_value2 ';
// print($query . '
id = ' . $column_value . '
' . $column_value2 );
$stmt = $dbh->prepare($query);
if (!$stmt) {
echo "\nPDO::errorInfo():\n";
print_r($dbh->errorInfo());
}
$stmt->bindParam(':column_value', $column_value);
$stmt->bindParam(':column_value2', $column_value2);
$stmt->execute();
return TRUE;
}
function getTime()
{
if (!$time) {
$time = microtime();
$time = explode(' ', $time);
$time = $time[1] + $time[0];
$start = $time;
}
}
Fatal error: Uncaught Error: Undefined constant "‘HTTP_ACCEPT_ENCODING’" in /home/jjmediah/domains/przeswietleni.com/public_html/include/fn-database.php:5
Stack trace:
#0 /home/jjmediah/domains/przeswietleni.com/public_html/frontend-header.php(4): require_once()
#1 /home/jjmediah/domains/przeswietleni.com/public_html/delivery.php(23): require_once('/home/jjmediah/...')
#2 {main}
thrown in /home/jjmediah/domains/przeswietleni.com/public_html/include/fn-database.php on line 5