function get_my_id()
{
return my_mysql_query_one('SELECT id FROM TbIdPerson WHERE firstname=\'Mark\' AND surname=\'Veltzer\'');
}
function make_stat($query, $func, $desc)
{
$result = my_mysql_query_one($query);
if ($func != NULL) {
$result = $func($result);
}
return '<a title="' . $query . '">' . $desc . ' = ' . $result . '</a><br/>';
}
# parameters for this script...
$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');
$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);
\tTbExternalType
WHERE
\tTbIdPerson.id=1 AND
\tTbIdPerson.id=TbWkWorkViewPerson.viewerId AND
\tTbWkWorkViewPerson.viewId=TbWkWorkView.id AND
\tTbWkWorkView.locationId=TbLocation.id AND
\tTbWkWorkView.deviceId=TbDevice.id AND
\tTbWkWorkView.workId=TbWkWork.id AND
\tTbWkWork.typeId=TbWkWorkType.id AND
\tTbWkWorkType.name='video movie' AND
\tTbWkWork.id=TbWkWorkExternal.workId AND
\tTbWkWorkExternal.externalId=TbExternalType.id AND
\tTbExternalType.name='imdb_title_id'
EOT;
/*
* If you want to only show movies that have dates add the following
* predicate to the SQL above:
* TbWkWorkView.endViewDate IS NOT NULL AND
*/
$query_data = sprintf('%s %s %s %s', $sql_select, $sql_frame, $sql_order, $sql_limit);
$query_count = sprintf('%s %s', 'SELECT COUNT(*)', $sql_frame);
# get the data...
$result_obj = my_mysql_query($query_data);
$result_rows = my_get_rows($result_obj);
$total = my_mysql_query_one($query_count);
# form the response
$response = array('total' => $total, 'views' => $result_rows);
# send the response
echo json_encode($response);
# finish up
utils_finish();
<?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 . ']';
<html>
<head>
<!--
<meta http-equiv="Content-type" content="text/html; charset=utf8"/>
-->
<!--
<meta http-equiv="Content-type" content="text/html; charset=UTF-8"/>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
-->
</head>
<body>
<?php
require 'utils.php';
utils_init();
$debug = 0;
# this is a test page to explore various issues like UTF
echo 'שלום לכולם';
echo '<br/>';
$query = sprintf('select name from TbWkWork where id=119');
$result = my_mysql_query_one($query);
echo $result;
echo '<br/>';
?>
</body>
</html>
