include_once '../includes/tipoRespuesta.php';
include_once '../includes/Answer.php';
//include_once ('../PDO/NewModel.php');
$tipo = new TipoRespuesta();
$respuesta = new Answer();
if (isset($_SESSION['name']) and $_SESSION['id'] == '10207674962976867') {
if (isset($_GET['id_type'])) {
$id_type = $_GET['id_type'];
$id_answer = $_GET['id_answer'];
//echo "<script type=\"text/javascript\">
// alert('Se ha borrado correctamente la noticia');
//history.go(-2);
//</script>";
//exit;
$query = $pdo->prepare('DELETE FROM TipoRespuesta WHERE id_type = ?');
$query = bindValue(1, $id_type);
$query->execute();
echo "<script type=\"text/javascript\">\n alert('Se ha borrado correctamente el tipo');\n history.go(-2);\n </script>";
exit;
}
$tipos = $tipo->fetch_all();
$respuestas = $respuesta->fetch_all();
?>
<html xmlns="http://www.w3.org/1999/html">
<head>
<title>Eliminar Tipo - Version editable</title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"/>
<link href="../../Card-2/card-2.css" type="text/css" rel="stylesheet">
<!--<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/materialize/0.97.0/css/materialize.min.css">-->
<link href="../css/materialize.css" type="text/css" rel="stylesheet" media="screen,projection"/>
<?php
//get category data
$name = filter_input(INPUT_POST, 'name');
//make sure that $name is valid
if ($name == null) {
$error = "Invalid name";
include 'error.php';
} else {
require_once 'database.php';
}
//add product to database
$query = 'INSERT INTO categories(categoryName) VALUES(:category_name)';
$statement = $db->prepare($query);
$statement = bindValue(':category_name', $name);
$statement->execute();
$statement->closeCursor();
//display Category List
include 'category_list.php';
/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
$username = $config['user'];
$password = $config['password'];
$host = $config['host'];
$port = $config['port'];
$dbname = $config['dbname'];
$connection_string = "(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = " . $host . ")(PORT = " . $port . ")) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = " . $dbname . ")))";
$connection = oci_connect($username, $password, $connection_string);
log_if_error($connection);
$statement = oci_parse($connection, "INSERT INTO PARAMETRO(CHAVE, VALOR, DATA_CRIACAO) VALUES(:param1, :param2, TO_DATE(:param3, 'YYYY-MM-DD HH24:MI:SS'))");
log_if_error($statement);
$chave = 'chave_sample';
$valor = 'valor_sample';
$data = new \DateTime();
$data = $data->format('Y-m-d H:i:s');
bindValue($statement, ':param1', $chave);
bindValue($statement, ':param2', $valor);
// Using oci_bind_by_name after using bindValue still reproduces the same behaviour
oci_bind_by_name($statement, ':param3', $data);
/**
* Inserted values will be | $data | $data | $data |
* Instead of | $chave | $valor | $data |
*/
$result = oci_execute($statement);
log_if_error($result);
/**
* If $value is set as reference it will work fine
* It also works if you copy $value to a variable outside function scope.
*/
function bindValue($statement, $name, $value)
{
/** Local variable as reference to oci_bind_by_name? */
$password = $config['password'];
$host = $config['host'];
$port = $config['port'];
$dbname = $config['dbname'];
$connection_string = "(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = " . $host . ")(PORT = " . $port . ")) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = " . $dbname . ")))";
$connection = oci_connect($username, $password, $connection_string);
log_if_error($connection);
$statement = oci_parse($connection, "INSERT INTO PARAMETRO(CHAVE, VALOR, DATA_CRIACAO) VALUES(:param1, :param2, TO_DATE(:param3, 'YYYY-MM-DD HH24:MI:SS'))");
log_if_error($statement);
$chave = 'chave_sample';
$valor = 'valor_sample';
$data = new \DateTime();
$data = $data->format('Y-m-d H:i:s');
bindValue($statement, ':param1', $chave);
bindValue($statement, ':param2', $valor);
bindValue($statement, ':param3', $data);
/**
* Inserted values will be | $data | $data | $data |
* Instead of | $chave | $valor | $data |
*/
$result = oci_execute($statement);
log_if_error($result);
/**
* If $value is set as reference it will work fine
* It also works if you copy $value to a variable outside function scope.
*/
function bindValue($statement, $name, $value)
{
/** Local variable as reference to oci_bind_by_name? */
return oci_bind_by_name($statement, $name, $value);
}
