<?php
/*$ids = array(1,2);
$lastName = 'gigi_ln_1';
$firstName = 'gigi_fn_1,gigi_fn_2';
$sqlCond = '';
if(count($ids) > 0) {
$inSQL = str_repeat("?,", count($ids) - 1)."?";
$sqlCond = " Persons.PersonId IN ($inSQL)";
}
$parameters = array();
if(3 == 1) {
$sql = "SELECT * FROM Persons WHERE $sqlCond";
//$parameters[] = $lastName;
if ($sqlCond) {
foreach ($ids as $id) {
$parameters[] = $id;
}
}
} else {
$sql = "SELECT * FROM Persons WHERE $sqlCond";
//$parameters[] = $lastName;
if ($sqlCond) {
foreach ($ids as $id) {
$parameters[] = $id;
}
}
if($firstName) {
$grouptableIdsArray = explode(",", $firstName);
$inGrouptableIdsSQL = str_repeat("?,", count($grouptableIdsArray) - 1)."?";
$sql .= " AND FirstName IN ($inGrouptableIdsSQL)";
foreach ($grouptableIdsArray as $id) {
$parameters[] = $id;
}
}
}*/
/*$arrId = array(1,2);
$inSQL = str_repeat("?,", count($arrId) - 1)."?";
$sql = "UPDATE Persons SET LastName = 'LastName' WHERE PersonID IN ($inSQL)";
$parameters = $arrId;
print($sql);
print_r($parameters);
print("\n\r\n\r");
$stmt = $pdo->prepare($sql);
$a = $stmt->execute($parameters);
//$rs = $stmt->fetchAll(PDO::FETCH_ASSOC);
print($stmt->debugDumpParams());
print($a);
$stmt = $pdo->prepare("SELECT * FROM Persons");
$stmt->execute();
$rs = $stmt->fetchAll(PDO::FETCH_ASSOC);
print_r($rs);*/
// $field = "asdd";
/*$sql = "SELECT cf_policy_id id
FROM cf_policy_defined
WHERE $field = ?
ORDER BY cf_policy_id ASC";*/
// $value = "asd";
// $q = "%$value%";
// echo $sql;
class TestClass {
public $limit;
public function __construct() {
$this->limit = '2';
}
}
$c = new TestClass();
$search_value = "gigi";
$selectTable = "Persons";
$selectField = "FirstName";
$parameters = ['gigi_ln_2'];
$parameters[] = "%$search_value%";
$parameters[] = '20';
// $parameters[] = $c->limit;
//$parameters[] = 1;
$sql = "SELECT $selectTable.$selectField
FROM $selectTable
WHERE $selectTable.LastName = ? AND FirstName LIKE ? AND Age = ? LIMIT $c->limit";
$stmt = $pdo->prepare($sql);
$stmt->execute($parameters);
$rs = $stmt->fetchAll(PDO::FETCH_ASSOC);
print_r($rs);
$idsMachines = [1,2];
$machines_placeholder = implode(',', array_fill(0, count($idsMachines), '?'));
print($machines_placeholder);
print(substr("(1,2),(3,4),", 0, -1));
// $arrMachineIds= [];
// $inSQL = str_repeat("?,", count($arrMachineIds) - 1)."?";
$sqlFile = "SELECT PersonID,Age,LastName INTO OUTFILE '/tmp/result.txt'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"'
LINES TERMINATED BY '\\n'
FROM Persons";
$stmtFile = $pdo->prepare($sqlFile);
$stmtFile->execute();
$rsFile = $stmtFile->fetchAll(PDO::FETCH_ASSOC);
print_r($rsFile);