" . pg_last_error($connection)); $query = "select photo_items.name, photo_items.price, package_items.quantity, photo_items.price*package_items.quantity as value from photo_items inner join package_items on (package_items.itemcode=photo_items.itemcode and package_items.pacode= (select pacode from photo_packages where rec_id='$rec_id'))"; $result = pg_exec($query) or die ('Could not get result of query. ').pg_last_error($result); while ($row = pg_fetch_array($result)){ print '
  • '.$row['quantity'].' '.$row['name'].'
    • '; } pg_close($connection); } function pac_name($id, $usr, $password){ $rec_id = $id; $user = $usr; $password = $password; $db = 'photography'; $connection = pg_connect("dbname=$db user=$user password=$password") or die ("Could Not Connect to PostgreSQL --> " . pg_last_error($connection)); $query = "select name from photo_packages where rec_id='$rec_id'"; $result = pg_exec($query) or die ('Could not get result of query. ').pg_last_error($result); while ($row = pg_fetch_array($result)){ return $row['name']; } pg_close($connection); } function pac_price($id, $usr, $password){ $rec_id = $id; $user = $usr; $password = $password; $db = 'photography'; $connection = pg_connect("dbname=$db user=$user password=$password") or die ("Could Not Connect to PostgreSQL --> " . pg_last_error($connection)); $query = "select price from photo_packages where rec_id='$rec_id'"; $result = pg_exec($query) or die ('Could not get result of query. ').pg_last_error($result); $row = pg_fetch_array($result) or die ('Could not fetch result of query. ').pg_last_error($result); return $row['price']; pg_close($connection); } function pac_value($id, $usr, $password){ $rec_id = $id; $user = $usr; $password = $password; $db = 'photography'; $connection = pg_connect("dbname=$db user=$user password=$password") or die ("Could Not Connect to PostgreSQL --> " . pg_last_error($connection)); $query = "select sum(photo_items.price*package_items.quantity) as value from photo_items inner join package_items on photo_items.itemcode=(select package_items.itemcode where package_items.pacode=(select pacode from photo_packages where photo_packages.rec_id= '$rec_id'))"; $result = pg_exec($query) or die ('Could not get result of query. ').pg_last_error($result); while ($row = pg_fetch_array($result)){ return $row['value']; } pg_close($connection); } function show_all_items($usr, $password){ $user = $usr; $password = $password; $db = 'photography'; $connection = pg_connect("dbname=$db user=$user password=$password") or die ("Could Not Connect to PostgreSQL --> " . pg_last_error($connection)); $query = "select * from photo_items;"; $result = pg_exec($query) or die ('Could not get result of query. ').pg_last_error($result); while ($row = pg_fetch_array($result)){ print '
  • '.$row['name'].' '.$row['description'].' $'.$row['price'].'
    • '; } pg_close($connection); } ?> Loving Impressions Photography at Wedding in Vegas Photo Packages
    WiVP Home
    About Us
    Gallery
    Videography
    Limousines
    Hair & Makeup
    Wedding Attire
    Marriage License
    Las Vegas, Nevada Marriage License Application Blank - Fill out and print to bring with you.Marriage License Application
    Terms & Conditions
    Privacy
    Free! -- Perfect Wedding Guide
    Receptions
    Links
    Anniversary Tips
    Diamond Ring Tips
    Contact Us
    Flowers
    Bakery
    Golf
    '.pac_name("1","$user","$password").''; ?> $'.pac_price("1","$user","$password").''; ?>
    '; ?> '; ?> '; ?>
    '.pac_name("2","$user","$password").''; ?> $'.pac_price("2","$user","$password").''; ?>
    '; ?> '; ?> '; ?>
    '.pac_name("3","$user","$password").''; ?> $'.pac_price("3","$user","$password").''; ?>
    '; ?> '; ?> '; ?>
    '.pac_name("4","$user","$password").''; ?> $'.pac_price("4","$user","$password").''; ?>
    '; ?> '; ?> '; ?>
    '.pac_name("5","$user","$password").''; ?> $'.pac_price("5","$user","$password").''; ?>
    '; ?> '; ?> '; ?>
    Additional Considerations