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);