" . 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 '
Marriage License Application
