<?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); }