관리-도구

편집 파일: saveVenue.php

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

// 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";
    header("Location:data_entry2.php");
 } else{
    //echo "There was an error uploading the file, please try again!";
 }
?>