<?php
//=========================================================
error_reporting(E_ALL);
ini_set('display_errors', '1');
require_once 'server/config.php';
require_once 'server/db_pdo.php';
$db = openDatabaseConnection();
//=========================================================
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>בישול טוב</title>
<link href="style.css" rel="stylesheet" type="text/css" />
</head>
<body>
<?php
require_once 'views/header.php';
?>
<div class="mid">
<?php
$data = ev_query("\nSELECT cd.courseid, p.picture place_pic, c.class_level, p.description place_desc, c.avg_class_size, c.age_range, c.course, cd.price, c.cover, p.address, c.description, cd.start_date, cd.price, cd.sessions, p.place, p.location, p.id placeid\nfrom courses_tags ct \njoin courses c on ct.courseid=c.id \njoin courses_dates cd on cd.courseid = c.id \njoin places p on cd.placeid = p.id \nwhere c.id=" . $_REQUEST['cid'] . " limit 1");
foreach ($data as $row) {
<?php
require_once 'inc/constants.php';
require_once 'inc/functions.php';
$films = array();
$numberOfPages = 0;
$pdo = openDatabaseConnection();
$query = isset($_GET['q']) ? trim($_GET['q']) : '';
$offset = isset($_GET['page']) ? (intval($_GET['page']) - 1) * RESULTS_PER_PAGE : 0;
$stmt = $pdo->prepare("SELECT fil_affiche, fil_id, fil_titre, fil_description FROM film WHERE fil_titre LIKE :query OR fil_acteurs LIKE :query OR fil_description LIKE :query OR fil_synopsis LIKE :query ORDER BY fil_id DESC LIMIT :resultsPerPage OFFSET :offset");
$stmt->bindValue(':query', "%{$query}%");
$stmt->bindValue(':resultsPerPage', RESULTS_PER_PAGE, PDO::PARAM_INT);
$stmt->bindValue(':offset', $offset, PDO::PARAM_INT);
if ($stmt->execute()) {
$films = $stmt->fetchAll(PDO::FETCH_ASSOC);
}
$stmt = $pdo->prepare('SELECT COUNT(*) FROM film WHERE fil_titre LIKE :query OR fil_acteurs LIKE :query OR fil_description LIKE :query OR fil_synopsis LIKE :query');
$stmt->bindValue(':query', "%{$query}%");
if ($stmt->execute()) {
$numberOfPages = ceil(intval($stmt->fetchColumn()) / RESULTS_PER_PAGE);
}
$title = 'GCFL - Film list';
require_once 'inc/header.php';
?>
<main>
<ul class="films"><?php
foreach ($films as $film) {
?>
<li>
<object data="<?php
echo $film['fil_affiche'];
function getRowAsArray($query)
{
openDatabaseConnection();
//$query = "SELECT * FROM ".$tablename." WHERE id=".$id;
$result = mysql_query($query) or die("Invalid query: " . mysql_error());
// turn the result into an array
return mysql_fetch_array($result, MYSQL_ASSOC);
// free the result resources
mysql_free_result($result);
}
function doInsertSmtp($username, $password, $host, $port, $security)
{
# Open Database Connection.
$conDatabase = openDatabaseConnection();
# Get the data from database.
$query = "insert into smtpmail(host,port,security,username,password)" . " value('" . $host . "'," . $port . ",'" . $security . "','" . $username . "','" . $password . "')";
mysqli_query($conDatabase, $query);
# Close database connection.
closeDatabaseConnection($conDatabase);
}
<?php
// ini_set('display_errors',true);
// ini_set('display_startup_errors',true);
// ini_set('date.timezone','America/New_York');
// error_reporting (E_ALL|E_STRICT);
require 'Homebase_Routes.php';
// Requests from the same server don't have a HTTP_ORIGIN header
if (!array_key_exists('HTTP_ORIGIN', $_SERVER)) {
$_SERVER['HTTP_ORIGIN'] = $_SERVER['SERVER_NAME'];
}
try {
$GLOBALS['oracle_connection'] = openDatabaseConnection();
$API = new HomebaseApi($_REQUEST['request'], $_SERVER['HTTP_ORIGIN']);
echo $API->processAPI();
$conn = $GLOBALS['oracle_connection'];
oci_close($GLOBALS['oracle_connection']);
} catch (Exception $e) {
echo json_encode(array('error' => $e->getMessage()));
}