PHP my_get_post_or_null Examples

Example #1

File: NewOrganizationWork.php Project: veltzer/myworld-php

<?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 . ']';

Example #2

File: NewWorkExternal.php Project: veltzer/myworld-php

<?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}]";

Example #3

File: NewWork.php Project: veltzer/myworld-php

<?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}]";

Example #4

File: NewPersonWork.php Project: veltzer/myworld-php

<?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 . ']';

Example #5

File: NewPerson.php Project: veltzer/myworld-php

<?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 . ']';

Example #6

File: NewWorkViewReview.php Project: veltzer/myworld-php

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