17
Hello
In reference to this
topic, im currently trying to show user their own data report
with my limited php/mysql knowledge, here's what i tried so far. The code will show data for the currently logged in user
im stucked in how to display the data value for $udata_value , it is stored something like a:1:{i:0;s:8:"YWRtaW4=";} in the database
<?php
include("../../mainfile.php");
include(XOOPS_ROOT_PATH."/header.php");
$meta_keywords = "WFH Report";
$meta_description = "WFH Report";
$pagetitle = "WFH Report";
if(isset($xoTheme) && is_object($xoTheme)) {
$xoTheme->addMeta( 'meta', 'keywords', $meta_keywords);
$xoTheme->addMeta( 'meta', 'description', $meta_description);
} else {
$xoopsTpl->assign('xoops_meta_keywords', $meta_keywords);
$xoopsTpl->assign('xoops_meta_description', $meta_description);
}
$xoopsTpl->assign('xoops_pagetitle', $pagetitle);
//this will only work if your theme is using this smarty variables
$xoopsTpl->assign( 'xoops_showlblock', 0); //set to 0 to hide left blocks
$xoopsTpl->assign( 'xoops_showrblock', 0); //set to 0 to hide right blocks
$xoopsTpl->assign( 'xoops_showcblock', 1); //set to 0 to hide center blocks
//$xoopsUser->isAdmin() or redirect_header('index.php', 3, _NOPERM);
global $xoopsUser;
//get current user id
$loggedinuid = is_object($xoopsUser) ? $xoopsUser->getVar('uid') : 0;
?>
<div class="container-fluid">
<div class="row">
<h2>Work From Home Report</h2>
<?php
$getcaption=$GLOBALS['xoopsDB']->query("SELECT
form.*, element.*
FROM ".$GLOBALS['xoopsDB']->prefix("xforms_form")." AS form
INNER JOIN ".$GLOBALS['xoopsDB']->prefix("xforms_element")." as element
ON form.form_id=element.form_id WHERE element.form_id=1 ORDER BY ele_order ASC ");
if (!$getcaption) {
trigger_error($GLOBALS['xoopsDB']->error());
}
?>
<table id="report" class="table table-bordered" cellspacing="0">
<thead>
<tr>
<th>User</th>
<th>Date</th>
<th>Ip Address</th>
<?php
while($row = $GLOBALS['xoopsDB']->fetchArray($getcaption))
{
$ele_id=$row['ele_id'];
$ele_caption=$row['ele_caption'];
echo "<th>$ele_caption ($ele_id)</th>";
}
echo "</tr>";
echo "</thead>
<tbody>";
$getdata=$GLOBALS['xoopsDB']->query("SELECT D.uid, D.form_id, D.ele_id, D.udata_time, D.udata_ip, D.udata_value
, U.name, U.uname
, E.ele_type, E.ele_caption
FROM ".$GLOBALS['xoopsDB']->prefix("xforms_userdata")." D
LEFT JOIN ".$GLOBALS['xoopsDB']->prefix("users")." U ON (D.uid=U.uid)
INNER JOIN ".$GLOBALS['xoopsDB']->prefix("xforms_element")." E ON (D.ele_id=E.ele_id)
WHERE D.form_id=1 AND D.uid='$loggedinuid'
ORDER BY D.uid ASC, D.udata_time ASC, D.udata_ip ASC, E.ele_order ASC");
if (!$getdata) {
trigger_error($GLOBALS['xoopsDB']->error());
}
while($row = $GLOBALS['xoopsDB']->fetchArray($getdata))
{
$uid=$row['uid'];
$uname=$row['uname'];
$udata_time2=date("Y-m-d", strval($row["udata_time"]));
$udata_ip=$row['udata_ip'];
$udata_value=$row['udata_value'];
echo "<tr>";
echo "<td>$uname</td>
<td>$udata_time2</td>
<td>$udata_ip</td>
<td>$udata_value</td>
</tr>";
}
?>
</tbody>
</table>
</div></div>
<?php
include(XOOPS_ROOT_PATH."/footer.php");
?>
