Do i need to create an array of forms or js?
thanks in advance for your help!
Theo Werntz II
Expand|Select|Wrap|Line Numbers
- <?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());
- }
- ?>
- <!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 language="javascript">
- function showF(f1){
- if(document.getElementById(f1).style.display=='none'){
- document.getElementById(f1).style.display='inline';
- }
- else{document.getElementById(f1).style.display='none';}
- }
- </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 '<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>'.$catagory_id.'</td>';
- echo ' <td>',$SFK1,'</td>';
- echo '</tr>';
- echo '</table>';
- //end row and cell for outer while
- // echo '</td>';
- // echo '</tr>';
- echo '<form action="$editFormAction" method="post" name="form1" id="form1">';
- echo "<a href=\"#\" onclick=\"showF('f1');return false\" style=\"position:relative\">part 1</a><br>";
- echo '<div id="f1" 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>