本文整理汇总了PHP中DataBase::getExecuteDmlAndGetLastInsertId方法的典型用法代码示例。如果您正苦于以下问题：PHP DataBase::getExecuteDmlAndGetLastInsertId方法的具体用法？PHP DataBase::getExecuteDmlAndGetLastInsertId怎么用？PHP DataBase::getExecuteDmlAndGetLastInsertId使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类DataBase的用法示例。
在下文中一共展示了DataBase::getExecuteDmlAndGetLastInsertId方法的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: insertTypeStructureNotes
/**
* The implementation method for insert data to the instance data Base.
*
* @throws None.
*
* @access public
* @static No.
* @see None.
* @since Available from the version 1.0 01-01-2013.
* @deprecated No.
*/
public function insertTypeStructureNotes($data, $idTransaction)
{
$this->setAditionalDataInsert($idTransaction);
$result = null;
$query = null;
try {
$query = "insert into `mac_teacher`(datetime_assign,\r\n teacher_status,\r\n fk_id_person,\r\n data_1,\r\n data_2,\r\n data_3,\r\n data_4,\r\n data_5,\r\n registration_status,\r\n datetime_last_transaction,\r\n datetime_creation_register, \r\n company) " . " values(?,\r\n ?,\r\n ?,\r\n ?,\r\n ?,\r\n ?,\r\n ?,\r\n ?,\r\n 'A',\r\n '" . $this->datetimeLastTransaction . "',\r\n '" . $this->datetimeCreationRegister . "', \r\n '" . $this->company . "')";
DataBase::getBeginTransaction($this->instanceDataBase);
$result = DataBase::getExecuteDmlAndGetLastInsertId($query, $data, $this->instanceDataBase);
DataBase::getCommitTransaction($this->instanceDataBase);
} catch (PDOException $e) {
echo 'Error JF-Model-0012: ' . $e->getMessage();
}
return $result;
}示例2: insertDebtShare
/**
* The implementation method for insert data to the instance data Base.
*
* @throws None.
*
* @access public
* @static No.
* @see None.
* @since Available from the version 1.0 01-01-2013.
* @deprecated No.
*/
public function insertDebtShare($data, $idTransaction)
{
$this->setAditionalDataInsert($idTransaction);
$result = null;
$query = null;
try {
$query = "insert into `mac_debt_share`(fk_id_type_debt_share ,\r\n fk_id_student ,\r\n fk_id_father ,\r\n concept ,\r\n detail ,\r\n amount,\r\n registration_status,datetime_last_transaction,datetime_creation_register, creation_user_transaction, last_user_transaction, creation_transaction, last_transaction, company) " . " values(?,?,?,?,?,?,'A', '" . $this->datetimeLastTransaction . "','" . $this->datetimeCreationRegister . "','" . $this->creationUserTransaction . "','" . $this->lastUserTransaction . "','" . $this->creationTransaction . "','" . $this->lastTransaction . "','" . $this->company . "')";
DataBase::getBeginTransaction($this->instanceDataBase);
$result = DataBase::getExecuteDmlAndGetLastInsertId($query, $data, $this->instanceDataBase);
DataBase::getCommitTransaction($this->instanceDataBase);
} catch (PDOException $e) {
echo 'Error JF-Model-0012: ' . $e->getMessage();
}
return $result;
}示例3: insertSeatReservation
/**
* The implementation method for insert data to the instance data Base.
*
* @throws None.
*
* @access public
* @static No.
* @see None.
* @since Available from the version 1.0 01-01-2013.
* @deprecated No.
*/
public function insertSeatReservation($data, $idTransaction)
{
$this->setAditionalDataInsert($idTransaction);
$result = null;
$query = null;
try {
$query = "insert into `mac_seat_reservation`\r\n (fk_id_seat_reservation_period, \r\n fk_id_assign_holder_student,\r\n datetime_assign,\r\n registration_status,\r\n datetime_last_transaction,\r\n datetime_creation_register, \r\n creation_user_transaction, \r\n last_user_transaction, \r\n creation_transaction, \r\n last_transaction, \r\n company) " . " values(?,\r\n ?,\r\n CURRENT_TIMESTAMP,\r\n 'A', \r\n '" . $this->datetimeLastTransaction . "',\r\n '" . $this->datetimeCreationRegister . "',\r\n '" . $this->creationUserTransaction . "',\r\n '" . $this->lastUserTransaction . "',\r\n '" . $this->creationTransaction . "',\r\n '" . $this->lastTransaction . "',\r\n '" . $this->company . "')";
DataBase::getBeginTransaction($this->instanceDataBase);
$result = DataBase::getExecuteDmlAndGetLastInsertId($query, $data, $this->instanceDataBase);
DataBase::getCommitTransaction($this->instanceDataBase);
} catch (PDOException $e) {
echo 'Error JF-Model-0012: ' . $e->getMessage();
}
return $result;
}示例4: insertSchooling
/**
* The implementation method for insert data to the instance data Base.
*
* @throws None.
*
* @access public
* @static No.
* @see None.
* @since Available from the version 1.0 01-01-2013.
* @deprecated No.
*/
public function insertSchooling($data, $idTransaction)
{
$this->setAditionalDataInsert($idTransaction);
$result = null;
$query = null;
try {
$query = "insert into `mac_schooling`(previous_school, \r\n place,\r\n grades_reached,\r\n year,\r\n fk_id_membership_app_form, \r\n registration_status,\r\n datetime_last_transaction,\r\n datetime_creation_register,\r\n creation_user_transaction, \r\n last_user_transaction, \r\n creation_transaction, \r\n last_transaction, \r\n company) " . " values(?,?,?,?,?,'A', '" . $this->datetimeLastTransaction . "','" . $this->datetimeCreationRegister . "','" . $this->creationUserTransaction . "','" . $this->lastUserTransaction . "','" . $this->creationTransaction . "','" . $this->lastTransaction . "','" . $this->company . "')";
DataBase::getBeginTransaction($this->instanceDataBase);
$result = DataBase::getExecuteDmlAndGetLastInsertId($query, $data, $this->instanceDataBase);
DataBase::getCommitTransaction($this->instanceDataBase);
} catch (PDOException $e) {
echo 'Error JF-Model-0012: ' . $e->getMessage();
}
return $result;
}示例5: insertStudentTaskFile
/**
* The implementation method for insert data to the instance data Base.
*
* @throws None.
*
* @access public
* @static No.
* @see None.
* @since Available from the version 1.0 01-01-2013.
* @deprecated No.
*/
public function insertStudentTaskFile($data, $idTransaction)
{
$this->setAditionalDataInsert($idTransaction);
$result = null;
$query = null;
try {
$query = "insert into `mac_student_task_file`(description_file_contents,\r\n fk_id_student_task,\r\n fk_id_file, \r\n registration_status,\r\n datetime_last_transaction,\r\n datetime_creation_register,\r\n creation_user_transaction,\r\n last_user_transaction,\r\n creation_transaction, \r\n last_transaction, \r\n company) " . " values(?,?,?,'A', '" . $this->datetimeLastTransaction . "','" . $this->datetimeCreationRegister . "','" . $this->creationUserTransaction . "','" . $this->lastUserTransaction . "','" . $this->creationTransaction . "','" . $this->lastTransaction . "','" . $this->company . "')";
DataBase::getBeginTransaction($this->instanceDataBase);
$result = DataBase::getExecuteDmlAndGetLastInsertId($query, $data, $this->instanceDataBase);
DataBase::getCommitTransaction($this->instanceDataBase);
} catch (PDOException $e) {
echo 'Error JF-Model-0012: ' . $e->getMessage();
}
return $result;
}示例6: insertPerson
/**
* The implementation method for insert data to the instance data Base.
*
* @throws None.
*
* @access public
* @static No.
* @see None.
* @since Available from the version 1.0 01-01-2013.
* @deprecated No.
*/
public function insertPerson($data, $idTransaction)
{
$this->setAditionalDataInsert($idTransaction);
$result = 0;
$query = null;
try {
$query = "insert into `mac_person`(name,last_name,maternal_name,married_name,fk_id_gender,fk_id_marital_status,blood_type,birthday,birth_city,country_birth,locality_birth,foto,ext_file_foto,registration_status,datetime_last_transaction,datetime_creation_register, creation_user_transaction, last_user_transaction, creation_transaction, last_transaction, company) " . " values(?,?,?,?,?,?,?,?,?,?,?,?,?,'A', '" . $this->datetimeLastTransaction . "','" . $this->datetimeCreationRegister . "','" . $this->creationUserTransaction . "','" . $this->lastUserTransaction . "','" . $this->creationTransaction . "','" . $this->lastTransaction . "','" . $this->company . "')";
DataBase::getBeginTransaction($this->instanceDataBase);
$result = DataBase::getExecuteDmlAndGetLastInsertId($query, $data, $this->instanceDataBase);
DataBase::getCommitTransaction($this->instanceDataBase);
} catch (PDOException $e) {
echo 'Error JF-Model-0012: ' . $e->getMessage();
$result = 0;
}
return $result;
}示例7: insertKindBrother
/**
* The implementation method for insert data to the instance data Base.
*
* @throws None.
*
* @access public
* @static No.
* @see None.
* @since Available from the version 1.0 01-01-2013.
* @deprecated No.
*/
public function insertKindBrother($data, $idTransaction)
{
$this->setAditionalDataInsert($idTransaction);
$result = null;
$query = null;
try {
$query = "insert into `mac_kind_brother`(\r\n fk_id_membership_app_form,\r\n type_kind_brother,\r\n names, \r\n birthday,\r\n school,\r\n university,\r\n work,\r\n registration_status,\r\n datetime_last_transaction,\r\n datetime_creation_register,\r\n creation_user_transaction, \r\n last_user_transaction, \r\n creation_transaction, \r\n last_transaction, \r\n company) " . " values(?,?,?,?,?,?,?,'A', '" . $this->datetimeLastTransaction . "','" . $this->datetimeCreationRegister . "','" . $this->creationUserTransaction . "','" . $this->lastUserTransaction . "','" . $this->creationTransaction . "','" . $this->lastTransaction . "','" . $this->company . "')";
DataBase::getBeginTransaction($this->instanceDataBase);
$result = DataBase::getExecuteDmlAndGetLastInsertId($query, $data, $this->instanceDataBase);
DataBase::getCommitTransaction($this->instanceDataBase);
} catch (PDOException $e) {
echo 'Error JF-Model-0012: ' . $e->getMessage();
}
return $result;
}示例8: insertAssignHCourseHardMatterTeacher
/**
* The implementation method for insert data to the instance data Base.
*
* @throws None.
*
* @access public
* @static No.
* @see None.
* @since Available from the version 1.0 01-01-2013.
* @deprecated No.
*/
public function insertAssignHCourseHardMatterTeacher($data, $idTransaction)
{
$this->setAditionalDataInsert($idTransaction);
$result = null;
$query = null;
try {
$query = "insert into `mac_assign_hcourse_matter_teacher`(datetime_assign,\r\n fk_id_teacher, fk_id_main_course_matter, fk_id_course_hard,\r\n registration_status,datetime_last_transaction,datetime_creation_register, creation_user_transaction, last_user_transaction, creation_transaction, last_transaction, company) " . " values(now(),?,?,?,'A', '" . $this->datetimeLastTransaction . "','" . $this->datetimeCreationRegister . "','" . $this->creationUserTransaction . "','" . $this->lastUserTransaction . "','" . $this->creationTransaction . "','" . $this->lastTransaction . "','" . $this->company . "')";
DataBase::getBeginTransaction($this->instanceDataBase);
$result = DataBase::getExecuteDmlAndGetLastInsertId($query, $data, $this->instanceDataBase);
DataBase::getCommitTransaction($this->instanceDataBase);
} catch (PDOException $e) {
echo 'Error JF-Model-0012: ' . $e->getMessage();
}
return $result;
}示例9: insertAdmissionProcess
/**
* The implementation method for insert data to the instance data Base.
*
* @throws None.
*
* @access public
* @static No.
* @see None.
* @since Available from the version 1.0 01-01-2013.
* @deprecated No.
*/
public function insertAdmissionProcess($data, $idTransaction)
{
$this->setAditionalDataInsert($idTransaction);
$result = null;
$query = null;
try {
$query = "insert into `mac_admission_process`(fk_id_membership_app_form, \r\n fk_id_admission_area,\r\n fk_id_supervisor_admission_area,\r\n start_datetime_area_process,\r\n end_datetime_area_process,\r\n observation_status,\r\n status_admission_process,\r\n registration_status,\r\n datetime_last_transaction,\r\n datetime_creation_register,\r\n creation_user_transaction, \r\n last_user_transaction, \r\n creation_transaction, \r\n last_transaction, \r\n company) " . " values(?,?,?,now(),now(),?,?,'A', '" . $this->datetimeLastTransaction . "','" . $this->datetimeCreationRegister . "','" . $this->creationUserTransaction . "','" . $this->lastUserTransaction . "','" . $this->creationTransaction . "','" . $this->lastTransaction . "','" . $this->company . "')";
DataBase::getBeginTransaction($this->instanceDataBase);
$result = DataBase::getExecuteDmlAndGetLastInsertId($query, $data, $this->instanceDataBase);
DataBase::getCommitTransaction($this->instanceDataBase);
} catch (PDOException $e) {
echo 'Error JF-Model-0012: ' . $e->getMessage();
}
return $result;
}示例10: insertMainCourse
/**
* The implementation method for insert data to the instance data Base.
*
* @throws None.
*
* @access public
* @static No.
* @see None.
* @since Available from the version 1.0 01-01-2013.
* @deprecated No.
*/
public function insertMainCourse($data, $idTransaction)
{
$this->setAditionalDataInsert($idTransaction);
$result = null;
$query = null;
try {
$query = "insert into `mac_main_course`(\r\n name,\r\n course_code,\r\n description,\r\n is_abstract_course,\r\n is_course_configuration,\r\n status_main_course,\r\n data_1,\r\n data_2,\r\n data_3,\r\n data_4,\r\n data_5, \r\n registration_status,\r\n datetime_last_transaction,\r\n datetime_creation_register, \r\n creation_user_transaction, \r\n last_user_transaction, \r\n creation_transaction, \r\n last_transaction, \r\n company) " . " values(?,?,?,?,?,?,?,?,?,?,?,'A','" . $this->datetimeLastTransaction . "','" . $this->datetimeCreationRegister . "','" . $this->creationUserTransaction . "','" . $this->lastUserTransaction . "','" . $this->creationTransaction . "','" . $this->lastTransaction . "','" . $this->company . "')";
DataBase::getBeginTransaction($this->instanceDataBase);
$result = DataBase::getExecuteDmlAndGetLastInsertId($query, $data, $this->instanceDataBase);
DataBase::getCommitTransaction($this->instanceDataBase);
} catch (PDOException $e) {
echo 'Error JF-Model-0012: ' . $e->getMessage();
}
return $result;
}示例11: insertAssignPersonIdentifyDoc
/**
* The implementation method for insert data to the instance data Base.
*
* @throws None.
*
* @access public
* @static No.
* @see None.
* @since Available from the version 1.0 01-01-2013.
* @deprecated No.
*/
public function insertAssignPersonIdentifyDoc($data, $idTransaction)
{
$this->setAditionalDataInsert($idTransaction);
$result = null;
$query = null;
try {
$query = "insert into `mac_assign_person_identify_doc`(identify_document,description,date_assign,city_expedition,fk_id_person,fk_id_type_identify_doc,fk_id_country,registration_status,datetime_last_transaction,datetime_creation_register, creation_user_transaction, last_user_transaction, creation_transaction, last_transaction, company) " . " values(?,?,now(),?,?,?,?,'A', '" . $this->datetimeLastTransaction . "','" . $this->datetimeCreationRegister . "','" . $this->creationUserTransaction . "','" . $this->lastUserTransaction . "','" . $this->creationTransaction . "','" . $this->lastTransaction . "','" . $this->company . "')";
DataBase::getBeginTransaction($this->instanceDataBase);
$result = DataBase::getExecuteDmlAndGetLastInsertId($query, $data, $this->instanceDataBase);
DataBase::getCommitTransaction($this->instanceDataBase);
} catch (PDOException $e) {
echo 'Error JF-Model-0012: ' . $e->getMessage();
}
return $result;
}示例12: insertTransaction
/**
* The implementation method for insert data to the instance data Base.
*
* @throws None.
*
* @access public
* @static No.
* @see None.
* @since Available from the version 1.0 01-01-2010.
* @deprecated No.
*/
public function insertTransaction($data)
{
$query = null;
$idTransaction = null;
$idUser = null;
$company = null;
try {
if (isset($_SESSION['authenticated_id_user'])) {
$idUser = $_SESSION['authenticated_id_user'];
} else {
$idUser = 1;
}
if (isset($_SESSION['id_company'])) {
$company = $_SESSION['id_company'];
} else {
$company = 1;
}
$query = "INSERT INTO sec_transaction( " . "business, operation, description_aplication, datetime_last_transaction, user_transaction, company) " . " VALUES ( ?,?,?, CURRENT_TIMESTAMP(), " . $idUser . "," . $company . ")";
DataBase::getBeginTransaction($this->instanceDataBase);
$idTransaction = DataBase::getExecuteDmlAndGetLastInsertId($query, $data, $this->instanceDataBase);
DataBase::getCommitTransaction($this->instanceDataBase);
} catch (PDOException $e) {
echo 'Error JF-Model-0072: ' . $e->getMessage();
}
return $idTransaction;
}示例13: insertCourseApplyPeriod
/**
* The implementation method for insert data to the instance data Base.
*
* @throws None.
*
* @access public
* @static No.
* @see None.
* @since Available from the version 1.0 01-01-2013.
* @deprecated No.
*/
public function insertCourseApplyPeriod($data, $idTransaction)
{
$this->setAditionalDataInsert($idTransaction);
$result = null;
$query = null;
try {
$query = "insert into `mac_course_apply_period`( \r\n datetime_assign ,\r\n fk_id_admission_period ,\r\n fk_id_main_course ,\r\n registration_status,\r\n datetime_last_transaction,\r\n datetime_creation_register,\r\n creation_user_transaction, \r\n last_user_transaction, \r\n creation_transaction, \r\n last_transaction, \r\n company) " . " values('" . $this->datetimeCreationRegister . "',?,?,'A', '" . $this->datetimeLastTransaction . "','" . $this->datetimeCreationRegister . "','" . $this->creationUserTransaction . "','" . $this->lastUserTransaction . "','" . $this->creationTransaction . "','" . $this->lastTransaction . "','" . $this->company . "')";
DataBase::getBeginTransaction($this->instanceDataBase);
$result = DataBase::getExecuteDmlAndGetLastInsertId($query, $data, $this->instanceDataBase);
DataBase::getCommitTransaction($this->instanceDataBase);
} catch (PDOException $e) {
echo 'Error JF-Model-0012: ' . $e->getMessage();
}
return $result;
}示例14: insertPlanificationActivity
/**
* The implementation method for insert data to the instance data Base.
*
* @throws None.
*
* @access public
* @static No.
* @see None.
* @since Available from the version 1.0 01-01-2013.
* @deprecated No.
*/
public function insertPlanificationActivity($data, $idTransaction)
{
$this->setAditionalDataInsert($idTransaction);
$result = null;
$query = null;
try {
$query = "insert into `mac_planification_activity`(activity,\r\n activity_start_datetime,\r\n activity_end_datetime,\r\n activity_description,\r\n fk_id_type_planification_activity,\r\n fk_id_hcourse_matter_teacher,\r\n registration_status,\r\n datetime_last_transaction,\r\n datetime_creation_register, \r\n creation_user_transaction, \r\n last_user_transaction, \r\n creation_transaction, \r\n last_transaction, \r\n company) " . " values(?,?,?,?,?,?,'A', '" . $this->datetimeLastTransaction . "','" . $this->datetimeCreationRegister . "','" . $this->creationUserTransaction . "','" . $this->lastUserTransaction . "','" . $this->creationTransaction . "','" . $this->lastTransaction . "','" . $this->company . "')";
DataBase::getBeginTransaction($this->instanceDataBase);
$result = DataBase::getExecuteDmlAndGetLastInsertId($query, $data, $this->instanceDataBase);
DataBase::getCommitTransaction($this->instanceDataBase);
} catch (PDOException $e) {
echo 'Error JF-Model-0012: ' . $e->getMessage();
}
return $result;
}示例15: insertMembershipAppForm
/**
* The implementation method for insert data to the instance data Base.
*
* @throws None.
*
* @access public
* @static No.
* @see None.
* @since Available from the version 1.0 01-01-2013.
* @deprecated No.
*/
public function insertMembershipAppForm($data, $idTransaction)
{
$this->setAditionalDataInsert($idTransaction);
$result = null;
$query = null;
try {
$query = "insert into `mac_membership_app_form`( \r\n form_registration_date ,\r\n a_partner ,\r\n name_student ,\r\n last_name_student ,\r\n maternal_name_student ,\r\n rude ,\r\n identify_doc_student ,\r\n type_identify_doc_student ,\r\n city_expedition_student ,\r\n country_expedition_student ,\r\n gender_student ,\r\n birthday_student ,\r\n blood_type_student ,\r\n lives_with ,\r\n religion ,\r\n previous_school ,\r\n expired_last_year ,\r\n course_that_postulates ,\r\n cause_of_separation ,\r\n years_spent_in_our_school ,\r\n years_away_from_our_school ,\r\n school_choice_motivation_1 ,\r\n school_choice_motivation_2 ,\r\n school_choice_motivation_3 ,\r\n active_partner_names_1 ,\r\n active_partner_phone_1 ,\r\n active_partner_cell_phone_1 ,\r\n active_partner_email_1 ,\r\n active_partner_names_2 ,\r\n active_partner_phone_2 ,\r\n active_partner_cell_phone_2 ,\r\n active_partner_email_2 ,\r\n names_partner ,\r\n last_name_partner ,\r\n maternal_name_partner ,\r\n identify_document ,\r\n type_identify_document_partner ,\r\n city_expedition_partner ,\r\n country_expedition_partner ,\r\n person_school_affairs ,\r\n invoice_name ,\r\n nit ,\r\n disease ,\r\n accidents ,\r\n allergies ,\r\n surgeries ,\r\n vaccines ,\r\n medication ,\r\n alia ,\r\n games_practice ,\r\n hobbies ,\r\n form_filling_contact ,\r\n direction_contact ,\r\n phone_address_contact ,\r\n work_phone_contact ,\r\n cell_phone_contact ,\r\n status_admission ,\r\n registration_status,\r\n datetime_last_transaction,\r\n datetime_creation_register,\r\n creation_user_transaction, \r\n last_user_transaction, \r\n creation_transaction, \r\n last_transaction, \r\n company) " . " values(CURRENT_TIMESTAMP,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,36,'A', '" . $this->datetimeLastTransaction . "','" . $this->datetimeCreationRegister . "','" . $this->creationUserTransaction . "','" . $this->lastUserTransaction . "','" . $this->creationTransaction . "','" . $this->lastTransaction . "','" . $this->company . "')";
DataBase::getBeginTransaction($this->instanceDataBase);
$result = DataBase::getExecuteDmlAndGetLastInsertId($query, $data, $this->instanceDataBase);
DataBase::getCommitTransaction($this->instanceDataBase);
} catch (PDOException $e) {
echo 'Error JF-Model-0012: ' . $e->getMessage();
}
return $result;
}