<?php require 'utils.php'; utils_init(); $debug = 0; if ($debug) { print_r($_POST) . "\n"; } # parameters for this script... $p_workId = my_get_post_or_null('workId'); $p_typeId = my_get_post_or_null('typeId'); $p_organizationId = my_get_post_or_null('organizationId'); my_mysql_start_transaction(); $query = sprintf('insert into TbWkWorkContrib (workId,typeId,organizationId) values(%s,%s,%s)', my_mysql_real_escape_string($p_workId), my_mysql_real_escape_string($p_typeId), my_mysql_real_escape_string($p_organizationId)); my_mysql_query($query); $p_id = my_mysql_insert_id(); my_mysql_commit(); echo 'new record successfully inserted with id [' . $p_id . ']';
<?php require 'utils.php'; utils_init(); $debug = 0; if ($debug) { print_r($_POST) . "\n"; } # parameters for this script... $p_workId = my_get_post_or_null('workId'); $p_externalId = my_get_post_or_null('externalId'); $p_externalCode = my_get_post_or_null('externalCode'); my_mysql_start_transaction(); $query = sprintf('insert into TbWkWorkExternal (workId,externalId,externalCode) values(%s,%s,%s)', my_mysql_real_escape_string($p_workId), my_mysql_real_escape_string($p_externalId), my_mysql_real_escape_string($p_externalCode)); my_mysql_query($query); $p_workexternalid = my_mysql_insert_id(); my_mysql_commit(); echo "new external successfully inserted with id [{$p_workexternalid}]";
<?php require 'utils.php'; utils_init(); $debug = 0; if ($debug) { print_r($_POST) . "\n"; } # parameters for this script... $p_name = my_get_post_or_null('name'); $p_typeId = my_get_post_or_null('typeId'); $p_languageId = my_get_post_or_null('languageId'); my_mysql_start_transaction(); $query = sprintf('insert into TbWkWork (name,typeId,languageId) values(%s,%s,%s)', my_mysql_real_escape_string($p_name), my_mysql_real_escape_string($p_typeId), my_mysql_real_escape_string($p_languageId)); my_mysql_query($query); $p_workid = my_mysql_insert_id(); my_mysql_commit(); echo "new work successfully inserted with id [{$p_workid}]";
<?php require 'utils.php'; utils_init(); $debug = 0; if ($debug) { print_r($_POST) . "\n"; } # parameters for this script... $p_workId = my_get_post_or_null('workId'); $p_typeId = my_get_post_or_null('typeId'); $p_personId = my_get_post_or_null('personId'); #$p_organizationId=my_get_post_or_null('organizationId'); my_mysql_start_transaction(); /* $query=sprintf('insert into TbWkWorkContrib (workId,typeId,personId,organizationId) values(%s,%s,%s,%s)', my_mysql_real_escape_string($p_workId), my_mysql_real_escape_string($p_typeId), my_mysql_real_escape_string($p_personId), my_mysql_real_escape_string($p_organizationId) ); */ $query = sprintf('insert into TbWkWorkContrib (workId,typeId,personId) values(%s,%s,%s)', my_mysql_real_escape_string($p_workId), my_mysql_real_escape_string($p_typeId), my_mysql_real_escape_string($p_personId)); my_mysql_query($query); $p_id = my_mysql_insert_id(); my_mysql_commit(); echo 'new record successfully inserted with id [' . $p_id . ']';
<?php require 'utils.php'; utils_init(); $debug = 0; if ($debug) { print_r($_POST) . "\n"; } # parameters for this script... $p_honorificId = my_get_post_or_null('honorificId'); $p_firstname = my_get_post_or_null('firstname'); $p_surname = my_get_post_or_null('surname'); $p_othername = my_get_post_or_null('othername'); $p_ordinal = my_get_post_or_null('ordinal'); $p_remark = my_get_post_or_null('remark'); my_mysql_start_transaction(); $query = sprintf('insert into TbIdPerson (honorificId,firstname,surname,othername,ordinal,remark) values(%s,%s,%s,%s,%s,%s)', my_mysql_real_escape_string($p_honorificId), my_mysql_real_escape_string($p_firstname), my_mysql_real_escape_string($p_surname), my_mysql_real_escape_string($p_othername), my_mysql_real_escape_string($p_ordinal), my_mysql_real_escape_string($p_remark)); my_mysql_query($query); $p_id = my_mysql_insert_id(); my_mysql_commit(); echo 'new person successfully inserted with id [' . $p_id . ']';
<?php require 'utils.php'; utils_init(); $debug = 0; if ($debug) { print_r($_POST) . "\n"; } # parameters for this script... $p_name = my_get_post('name'); $p_typeId = my_get_post_or_null('typeId'); $p_externalId = my_get_post('externalId'); $p_externalCode = my_get_post('externalCode'); $p_end = javascriptdate_to_mysqldate(my_get_post('end')); if ($p_end != '') { $p_end = javascriptdate_to_mysqldate($p_end); } $p_personId = my_get_post('personId'); $p_locationId = my_get_post('locationId'); $p_deviceId = my_get_post('deviceId'); $p_remark = my_get_post('remark'); $p_ratingId = my_get_post('ratingId'); $p_review = my_get_post('review'); my_mysql_start_transaction(); // insert the actual work $query = sprintf('insert into TbWkWork (name,typeId) values(%s,%s)', my_mysql_real_escape_string($p_name), my_mysql_real_escape_string($p_typeId)); my_mysql_query($query); $p_workId = my_mysql_insert_id(); // insert an external id $query = sprintf('insert into TbWkWorkExternal (workId,externalId,externalCode) values(%s,%s,%s)', my_mysql_real_escape_string($p_workId), my_mysql_real_escape_string($p_externalId), my_mysql_real_escape_string($p_externalCode)); my_mysql_query($query);