관리-도구

편집 파일: class-add-users.php

<?php

require_once("classes/dbroot.php");

class users extends dbroot {

function get_addusers($firstname, $lastname, $address, $city, $state, $zipcode, $phone, $emailaddress, $weddingdate, $referral, $comments,$chkspecialoffers,$cwlife){

//$sql = "INSERT INTO `users`

//	 (`firstname` , `lastname` , `address` , `city` , `state` , `zipcode` , `phone` , `emailaddress` , `weddingdate` , `cakes` , `catering` , `dj` , `floral` , `registry` , `accommodations` , `photography` , `reception` , `transportation` , `tuxedo` , `videography` , `location` , `referral` , `comments`, `registereddatetime` , `chkspecialoffers`)

// VALUES ('$firstname','$lastname', '$address', '$city', '$state', '$zipcode', '$phone', '$emailaddress', '$weddingdate', '$cakes', '$catering', '$dj', '$floral', '$registry', '$accommodations', '$photography', '$reception', '$transportation', '$tuxedo', '$videography', '$location', '$referral', '$comments','" . date("Y-m-d H:i:s") . "', '$chkspecialoffers');";

$sql = "INSERT INTO `users`

(`firstname` , `lastname` , `address` , `city` , `state` , `zipcode` , `phone` , `emailaddress` , `weddingdate` , `referral` , `comments`, `registereddatetime` , `chkspecialoffers`, `cwlife`)

VALUES ('$firstname','$lastname', '$address', '$city', '$state', '$zipcode', '$phone', '$emailaddress', '$weddingdate', '$referral', '$comments','" . date("Y-m-d H:i:s") . "', '$chkspecialoffers', '$cwlife');";

//echo $sql ;

//exit ;

$results = $this->connect->query($sql);

if (DB::isError($results)){

return $this->raiseError("couldn't execute qurey $sql", $results->getMessage());

}else{

return $result_id;

}

} //end function

function get_addusers2011($firstname, $lastname, $address, $city, $state, $zipcode, $phone, $emailaddress, $weddingdate, $referral, $comments,$chkspecialoffers,$cwlife){