<?php
include 'scripts/web_scripts/get_connection.php';
try {
if (PHP_SAPI === 'cli') {
$id = $argv[1];
} else {
$id = $_GET['id'];
}
if (!empty($_POST)) {
// 8/27/15
set_opinions($conn, $id);
}
get_opinions($conn, $id);
} catch (PDOException $e) {
echo "Connection failed: " . $e->getMessage();
return;
}
$conn = null;
function set_opinions($conn, $id)
{
$form = $_POST;
//************* this needs to be finished *****************//
$query = "SELECT opinions.opin_descrip, user_opin.opinion FROM opinions JOIN user_opin ON opinions.id = user_opin.opin_id WHERE user_opin.user_id = :id;";
$query = $conn->prepare($query);
$query->bindparam(':id', $id);
$query->execute();
$query_results = $query->fetchAll();
$length = count($query_results);
<?php
include 'get_connection.php';
try {
if (PHP_SAPI === 'cli') {
$user_id = $argv[1];
} else {
$user_id = $_GET['user_id'];
}
get_opinions($conn, $user_id);
} catch (PDOException $e) {
echo "Connection failed: " . $e->getMessage();
return;
}
$conn = null;
function get_opinions($conn, $user_id)
{
$query = $conn->prepare("SELECT opinions.opin_name, user_opin.opinion FROM opinions JOIN user_opin ON opinions.id = user_opin.opin_id WHERE user_opin.user_id = :user_id;");
$query->bindparam(':user_id', $user_id);
$query->execute();
$result = $query->fetchAll();
print_r($result);
}
