관리-도구

편집 파일: actionVenue.php

<?php
  // save venue 
  include_once('../includes/dbconn.php');

function insertVenue($_POST, $_FILES){
  global $db;
  // update db now 
  $sql  = "insert into venues set " ;
  $sql .= "venueimg =?, venuename=?, venueurl=?, ";
  $sql .= "venuedesc=?, venueloc=?, dinnercap=?, ";
  $sql .= "recepcap=?, priceper=?, features=? ";
  $q = $db->prepare($sql); 
  $data = array($_FILES['venueFile']['name'], 
                $_POST[venueName],
                $_POST[venueUrl],
                $_POST[venueDesc],
                $_POST[venueCity],
                $_POST[venueDinner],
                $_POST[venueReception],
                $_POST[venuePricerPerPerson],
                serialize($_POST[chek])
                 );
  $db->Execute($sql, $data);
  //echo "query: $query. " . $db->ErrorMsg() ;
 // move file now  
 $target_path = "venueimg/";
 $target_path = $target_path . basename( $_FILES['venueFile']['name']); 
 //echo $target_path ; 
 if(move_uploaded_file($_FILES['venueFile']['tmp_name'], $target_path)) {
    //echo "The file ".  basename( $_FILES['venueFile']['name']). 
    //" has been uploaded";
 } else{
    //echo "There was an error uploading the file, please try again!";
 }
  header("Location:data_entry2.php"); 
}
 
 function updateVenue($_POST){
 	
 	 global $db;
  // update db now 
  $sql  = "update  venues set " ;
  $sql .= "venuename=?, venueurl=?, ";
  $sql .= "venuedesc=?, venueloc=?, dinnercap=?, ";
  $sql .= "recepcap=?, priceper=?, features=? ";
  $sql .= " where venueid = ? ";
  $q = $db->prepare($sql); 
  $data = array($_POST[venueName],
                $_POST[venueUrl],
                $_POST[venueDesc],
                $_POST[venueCity],
                $_POST[venueDinner],
                $_POST[venueReception],
                $_POST[venuePricerPerPerson],
                serialize($_POST[chek]),
                $_POST[venueid]);
  //print_r($data);              
  $db->Execute($sql, $data);
  echo $db->ErrorMsg();
  header("Location:venue_listing.php"); 
 	
 }
 
 function deleteVenue($_POST){
  global $db;
  $sql = "delete from venues where venueid = " .$_POST[venueid] ;
 	$db->Execute($sql);
 	
 }	
 
 ## main process goes her 
 //print_r($_POST);
 //exit ;
 
 if($_POST['action'] == 'new') {
   insertVenue($_POST, $_FILES);
 }elseif($_POST['action'] == 'updateVenue') {	
 	 updateVenue($_POST);
 }elseif($_POST['action'] == 'delete') {	 	 
 	 deleteVenue($_POST);
 	 header("Location:venue_listing.php"); 
 }else{
 	echo "nothing" . $_POST['action'] ;
 	
 }
?>