I’m trying to place these in a seperate file that’ll be included on every page.
[php]
$sql = ‘select id, name, age, address, pincode from json where name = :name’;
$arr = array(":name" => $name);
// There are some 30 diff sql’s and arrays[/php]
Another page
[php]
$name = ‘peter’;
$conn = connect();
function myType(){
global $conn;
global $sql;
global $arr;
$stmt = $conn->prepare($sql);
$stmt->execute($arr);
while( $row = $stmt->fetch(PDO::FETCH_ASSOC) ) {
foreach ($row as $value) {
echo $value.' <br>';
}
}
}
myType();
[/php]
What I’m trying to do is keep the sql’s and arrays in a separate file and use them when needed.
Keeps things clean and easy to maintain. But the variables are declared later, which gives me: Notice: Undefined variable: name in C:\web\apache\htdocs\dev\json.php on line 24
Can you see a way to do this without uglying things?
Thanks,