<?php require_once('Connections/Del_Comments.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
if (PHP_VERSION < 6) {
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
}
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {
$insertSQL = sprintf("INSERT INTO ascomments (Id, Memo, `Date`) VALUES (%s, %s, now())",
GetSQLValueString($_POST['Id'], "int"),
GetSQLValueString($_POST['Memo'], "text"));
mysql_select_db($database_Del_Comments, $Del_Comments);
$Result1 = mysql_query($insertSQL, $Del_Comments) or die(mysql_error());
$Cfk = mysql_insert_id();
$UId = '2';
$insertSQL = sprintf("INSERT INTO asmanystatusupdate (Id, SFk, CFk, CFk0, UIdFk0, UIdFk1, Dates) VALUES (%s, %s, '$Cfk', '$Cfk', '$UId', '$UId', now())",
GetSQLValueString($_POST['Id'], "int"),
GetSQLValueString($_POST['SFk'], "int"));
mysql_select_db($database_Del_Comments, $Del_Comments);
$Result1 = mysql_query($insertSQL, $Del_Comments) or die(mysql_error());
}
mysql_select_db($database_Del_Comments, $Del_Comments);
$query_Recordset1 = "SELECT * FROM ahcomments";
$Recordset1 = mysql_query($query_Recordset1, $Del_Comments) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Untitled Document</title>
<script type="text/javascript">
<!--
function toggle_visibility(id) {
var e = document.getElementById(id);
if(e.style.display == 'block')
e.style.display = 'none';
else
e.style.display = 'block';
}
//-->
</script>
</head>
<body>
<?php
//c.sfk={$row['sfk']}
mysql_select_db($database_Del_Comments, $Del_Comments);
$result = sprintf("SELECT a.Id, a.Type,
a.Dates,
a.UIdFk as UIdFk,
b.Id as Did,
b.comment as Comment,
b.dates as Day,
b.sfk as Sfk ,
aes_decrypt(e.ProfileName, '$Ukey') as Name,
substr(i.Path, 4) as Path
FROM
asstatusupdate as a
left join asstatusdata as b
on a.id = b.sfk
right join ASWebInfo as e
on e.Uidfk = a.uidfk
right join ASManyAlbums as f
on f.UserId=a.uidfk
right join ASAlbums as g
on f.AlbumId=g.Id
right join ASTitle as h
on g.Id=h.AlbumId
right join ASData as i
on h.Id=i.TitleId
where a.uidfk in (select friendid from asfriends where uidfk0='1') and i.DefaultProfilePic='Y' order by dates desc;
");
$statusUpdate = mysql_query($result, $Del_Comments) or die(mysql_error());
$category_id = '';
echo '<table align="center" width="40%" border="3" cellpadding="0" cellspacing="0">';
while($row = mysql_fetch_array($statusUpdate)) {
if ($row['Id'] != $category_id) {
$category_id = $row['Id'];
// grab table variables
$Type = $row['Type'];
$Dates = $row['Dates'];
$Comment = $row['Comment'];
$Name = $row['Name'];
$Path = $row['Path'];
$FriendId = $row['UIdFk'];
$SFK = $row['Sfk'];
echo '<tr>';
echo ' <td align="center">', $Name, '<br><a href="source/source.php?FriendId=',$FriendId,'"><img src="',$Path,'" height="120" width="120" align="middle" border="3" /></a></td>';
echo ' <td align="center"> ',$Dates,'<br><br>',$Type,'<br/>',$Comment,'</td>';
echo ' <td>',$category_id,'</td>';
echo ' <td>',$SFK,'</td>';
echo '</tr>';
} // end of if
mysql_select_db($database_Del_Comments, $Del_Comments);
$comments= sprintf("SELECT
c.sfk as sfk1,
c.UIdFk0,
d.Memo as Memo,
d.Date as Dates1,
e.ProfileName,
substr(i.Path, 4) as Path
FROM
asmanystatusupdate as c
left join ascomments as d on d.id = c.cfk
right join ASWebInfo as e on e.Uidfk = c.uidfk0
right join ASManyAlbums as f on f.UserId=c.uidfk0
right join ASAlbums as g on f.AlbumId=g.Id
right join ASTitle as h on g.Id=h.AlbumId
right join ASData as i on h.Id=i.TitleId
where c.sfk={$row['Sfk']} AND c.uidfk0 in (select friendid from asfriends where uidfk0='1') and i.DefaultProfilePic='Y' order by dates desc;
");
$statusComments = mysql_query($comments, $Del_Comments) or die(mysql_error());
while($user_row = mysql_fetch_array($statusComments)){
// test the query
//if($row['sfk'] == $user_row['sfk'])
{
$Dates1 = $user_row['Dates1'];
$Memo = $user_row['Memo'];
$Name1 = $user_row['Name'];
$Path1 = $user_row['Path'];
$FriendId1 = $user_row['UIdFk0'];
$SFK1 = $user_row['sfk1'];
//row and cell for "outer" while
echo '<tr>';
echo '<td colspan="4" style="padding-left:1em;">';
// display table
echo '<a href="#0'."$SFK1".'" onclick="toggle_visibility(\'foo1'."$SFK1".'\');" ;return false\" style=\"position:relative\">Click here to show records</a>'; // to show comment records
echo '<div id="foo1'."$SFK1".'"style="position:relative;display:none">'; // to show comment records
echo '<table align="center" width="60%" border="3" cellpadding="0" cellspacing="0">';
echo '<tr>';
echo ' <td align="center">',$Name1,'<br/><a href="source/source.php?FriendId=',$FriendId1,'"><img src="',$Path1,'" height="120" width="120" align="middle" border="3" /></a></td>';
echo ' <td align="center" width="40%"> ',$Dates1,'<br/><br/><br/>',$Memo,'</td>';
echo ' <td>' ,$category_id, '</td>';
echo ' <td>',$SFK1,'</td>';
echo '</tr>';
echo '</table>';
echo '</div>'; // for comment results show query
//end row and cell for outer while
//echo '</td>';
//echo '</tr>';
echo '<form action="$editFormAction" method="post" name="form1" id="form1">';
echo '<a href="#'."$SFK1".'" onclick="toggle_visibility(\'foo'."$SFK1".'\');" ;return false\" style=\"position:relative\">Click here to toggle visibility of element #foo</a>';
echo '<div id="foo'."$SFK1".'"style="position:relative;display:none">';echo '<table align="center">';
echo '<tr valign="baseline">';
echo '<td nowrap="nowrap" align="right">Memo:</td>';
echo '<td><input type="text" name="Memo" value="" size="32" /></td>';
echo '</tr>';
echo '<tr valign="baseline">';
echo '<td nowrap="nowrap" align="right"> </td>';
echo ' <td nowrap="nowrap" align="right"> </td>';
echo ' </tr>';
echo '<tr valign="baseline">';
echo ' <td nowrap="nowrap" align="right"> SFK:' ."$SFK1". '</td>';
echo ' <td><input type="submit" value="Insert record" /></td>';
echo ' </tr>';
echo ' </table>';
echo '<input type="hidden" name="Id" value="" />';
echo '<input type="hidden" name="Id" value="" />';
echo ' <input type="hidden" name="SFk" value="' ."$SFK1". '" />';
echo ' <input type="hidden" name="MM_insert" value="form1" />';
echo '</form>';
echo '</div>';
} // end of if
} // end of while loop
}// end of main loop
echo '</table>';
?>
</body>
</html>
Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.
When asked, what has been your best career decision?
Deciding to stick with EE.
Being involved with EE helped me to grow personally and professionally.
Connect with Certified Experts to gain insight and support on specific technology challenges including:
We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE