PHPize Online / SQLize Online  /  SQLtest Online

<?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); $params = []; $department_id = ""; if ($department_id == "") { $idsArr = explode(",", $department_id); //$inSQL = str_repeat("?,", count($idsArr) - 1)."?"; $inSQL = implode(",", array_fill(0, count($idsArr), '?')); $sql = " AND department_id IN ($inSQL)"; $params = array_merge($params, $idsArr); } print($sql); print_r($params);