public function saveDescHeader(\DescHeaderVO $obj)
{
$config_properties = (require '../../model-db-connection/GoGetRighconf.properties.php');
// Create connection
$mysqli = new mysqli($config_properties['domain'], $config_properties['username'], $config_properties['password'], $config_properties['databasename']);
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit;
}
$mysqli->set_charset("utf8");
// prepare and bind
$stmt = $mysqli->prepare("INSERT INTO GTRICH_DESCRIPTION_HEADER (DESC_HEADER_ID,DESC_HEADER_NAME,DESC_HEADER_CREATED_DATE_TIME) VALUES (?,?,NOW())");
$stmt->bind_param("ss", $obj->getDescHeaderID(), $obj->getDescHeaderName());
$stmt->execute();
$stmt->close();
$mysqli->close();
return 200;
}
<?php
/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
require '../../model/com.gogetrich.dao/DescHeaderDaoImpl.php';
require '../../model/com.gogetrich.service/DescHeaderService.php';
require '../../model/com.gogetrich.model/DescHeaderVO.php';
$descDao = new DescHeaderDaoImpl();
$descHeaderService = new DescHeaderService($descDao);
$descHeaderName = $_GET['descHeaderName'];
$descHeaderVO = new DescHeaderVO();
$descHeaderVO->setDescHeaderID(md5(date("h:i:sa")));
$descHeaderVO->setDescHeaderName($descHeaderName);
echo $descHeaderService->saveDescHeader($descHeaderVO);
