<?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_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_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}]";
$p_remark = my_get_post('remark'); $p_ratingId = my_get_post('ratingId'); $p_review = my_get_post('review'); // this is a line you can use for debugging... //error('query not yet implemented'); // my_mysql_start_transaction(); $p_typeId = my_mysql_query_one('select id from TbWkWorkType where name=\'video movie\''); $p_externalId = my_mysql_query_one('select id from TbExternalType where name=\'imdb_title_id\''); // 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 imdb 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_imdbid)); my_mysql_query($query); $p_externalId = my_mysql_insert_id(); // insert a new view $query = sprintf('insert into TbWkWorkView (endViewDate,locationId,deviceId,workId,remark) values(%s,%s,%s,%s,%s)', my_mysql_real_escape_string($p_date), my_mysql_real_escape_string($p_locationId), my_mysql_real_escape_string($p_deviceId), my_mysql_real_escape_string($p_workId), my_mysql_real_escape_string($p_remark)); my_mysql_query($query); $p_workviewid = my_mysql_insert_id(); // insert the viewer $query = sprintf('insert into TbWkWorkViewPerson (viewerId,viewId) values(%s,%s)', my_mysql_real_escape_string($p_personId), my_mysql_real_escape_string($p_workviewid)); my_mysql_query($query); $p_workviewpersonid = my_mysql_insert_id(); // insert a new review $query = sprintf('insert into TbWkWorkReview (ratingId,review,reviewDate,workId,reviewerId) values(%s,%s,%s,%s,%s)', my_mysql_real_escape_string($p_ratingId), my_mysql_real_escape_string($p_review), my_mysql_real_escape_string($p_date), my_mysql_real_escape_string($p_workId), my_mysql_real_escape_string($p_personId)); my_mysql_query($query); $p_workreviewid = my_mysql_insert_id(); my_mysql_commit(); echo "new work [{$p_workId}], external [{$p_externalId}], view [{$p_workviewid}], viewperson[{$p_workviewpersonid}], review [{$p_workreviewid}] successfully inserted";
<?php require 'utils.php'; utils_init(); $debug = 0; if ($debug) { print_r($_POST) . "\n"; } # parameters for this script... $p_personId = my_get_post_or_null('personId'); $p_externalId = my_get_post_or_null('externalId'); $p_externalCode = my_get_post_or_null('externalCode'); my_mysql_start_transaction(); $query = sprintf('insert into TbIdPersonExternal (personId,externalId,externalCode) values(%s,%s,%s)', my_mysql_real_escape_string($p_personId), my_mysql_real_escape_string($p_externalId), my_mysql_real_escape_string($p_externalCode)); my_mysql_query($query); $p_personexternalid = my_mysql_insert_id(); my_mysql_commit(); echo "new external successfully inserted with id [{$p_personexternalid}]";
<?php require "utils.php"; utils_init(); $debug = 1; if ($debug) { print_r($_POST) . "\n"; } # parameters for this script... $p_name = my_get_post('name'); $p_calendarIy = my_get_post('calendarId'); $p_companIy = my_get_post('companyId'); $p_courseId = my_get_post('courseId'); $p_locationId = my_get_post('locationId'); $p_personId = my_get_post('personId'); $p_remark = my_get_post('remark'); my_mysql_start_transaction(); $query = sprintf("insert into TbEvent (name,calendarId,companyId,courseId,locationId,personId,remark) values(%s,%s,%s,%s,%s,%s,%s)", my_mysql_real_escape_string($p_name), my_mysql_real_escape_string($p_calendarId), my_mysql_real_escape_string($p_companyId), my_mysql_real_escape_string($p_courseId), my_mysql_real_escape_string($p_locationId), my_mysql_real_escape_string($p_personId), my_mysql_real_escape_string($p_remark)); my_mysql_query($query); $p_eventid = my_mysql_insert_id(); my_mysql_commit(); echo 'new event successfully inserted with id [' . $p_eventid . ']';
$p_personId = my_get_post('personId'); $p_name = my_get_post('name'); $p_imdbid = my_get_post('imdbid'); $p_date = javascriptdate_to_mysqldate(my_get_post('date')); $p_locationId = my_get_post('locationId'); $p_deviceId = my_get_post('deviceId'); $p_remark = my_get_post('remark'); // this is a line you can use for debugging... //error('query not yet implemented'); // my_mysql_start_transaction(); $p_typeId = my_mysql_query_one('select id from TbWkWorkType where name=\'video movie\''); $p_externalId = my_mysql_query_one('select id from TbExternalType where name=\'imdb_title_id\''); // 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 imdb 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_imdbid)); my_mysql_query($query); $p_externalId = my_mysql_insert_id(); // insert a new view $query = sprintf('insert into TbWkWorkView (endViewDate,locationId,deviceId,workId,remark) values(%s,%s,%s,%s,%s)', my_mysql_real_escape_string($p_date), my_mysql_real_escape_string($p_locationId), my_mysql_real_escape_string($p_deviceId), my_mysql_real_escape_string($p_workId), my_mysql_real_escape_string($p_remark)); my_mysql_query($query); $p_workviewid = my_mysql_insert_id(); // insert the viewer $query = sprintf('insert into TbWkWorkViewPerson (viewerId,viewId) values(%s,%s)', my_mysql_real_escape_string($p_personId), my_mysql_real_escape_string($p_workviewid)); my_mysql_query($query); $p_workviewpersonid = my_mysql_insert_id(); my_mysql_commit(); echo "new work [{$p_workId}], external [{$p_externalId}], view [{$p_workviewid}], viewperson[{$p_workviewpersonid}] successfully inserted";
<?php require 'utils.php'; utils_init(); $debug = 0; if ($debug) { print_r($_POST) . "\n"; } # parameters for this script... #$p_start=javascriptdate_to_mysqldate(my_get_post('start')); $p_end = javascriptdate_to_mysqldate(my_get_post('end')); #$p_personId=my_get_post('personId'); $p_locationId = my_get_post('locationId'); $p_activityId = my_get_post('activityId'); $p_remark = my_get_post('remark'); my_mysql_start_transaction(); # this is instead of getting it via the form above... $p_personId = my_mysql_query_one('select id from TbIdPerson where firstname=\'Mark\' and surname=\'Veltzer\''); $query = sprintf('insert into TbTdDone (end,personId,locationId,activityId,remark) values(%s,%s,%s,%s,%s)', my_mysql_real_escape_string($p_end), my_mysql_real_escape_string($p_personId), my_mysql_real_escape_string($p_locationId), my_mysql_real_escape_string($p_activityId), my_mysql_real_escape_string($p_remark)); my_mysql_query($query); $p_doneid = my_mysql_insert_id(); my_mysql_commit(); echo 'done item inserted with id [' . $p_doneid . ']';