asked on

show / hide database results

i would like to show or hide the results on click in php.

could you show me an example?

here is my code that im working on and i need the show results on click for the sub query.

<?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">&nbsp;</td>';
     echo ' <td nowrap="nowrap" align="right">&nbsp;</td>';
   echo ' </tr>';
    echo '<tr valign="baseline">';
     echo ' <td nowrap="nowrap" align="right">&nbsp;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>

Open in new window

PranjalShah

Here is an example

http://blog.movalog.com/a/javascript-toggle-visibility/

PranjalShah

This one with example

http://www.randomsnippets.com/2008/02/12/how-to-hide-and-show-your-div/

only1wizard

ASKER

could you show me how to echo $SFK1 correclty here is the code that im useing:

echo '<a href="#" onclick="toggle_visibility(\'foo'.'$SFK1'.'\');">Click here to toggle visibility of element #foo</a>';
  echo '<div id="foo'.'$SFK1'.'">';

Open in new window

im going to use an id from the record set to label and identify the div because when i click on the hyper link for say record 10 it opens the form on record 14.

thanks in advance for your help!

PranjalShah

Try it like this...

<a href="#" onclick="toggle_visibility('foo<? echo $SFK1;?>');">Click here to toggle visibility of element #foo</a>
<div id="foo<? echo $SFK1;?>">

Open in new window

only1wizard

ASKER

i already have it in an echo statement in php echoing the complete table layout. i will try this and post my results.

only1wizard

ASKER

ok i have the code working.

here is the working code:

echo '<a href="#" onclick="toggle_visibility(\'foo'."$SFK1".'\');">Click here to toggle visibility of element #foo</a>';
  echo '<div id="foo'."$SFK1".'">';echo '<table align="center">';

Open in new window

but how do i keep the focus on the current object. i.e. when i click on hyperlink record 5 it will go to the top of the page then i have to scroll back down to see that the record is ready to insert.

thanks in advance for your help!

ASKER CERTIFIED SOLUTION

PranjalShah

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

only1wizard

ASKER

ive found out that i added the record id to the hyperlink that keeps the focus to that record.

i have another question how do you show the this insert form just for the last record id and not the last record itself.

thanks in advance for your help!

only1wizard

ASKER

how do i get this to loop through all record sets instead of just showing one record set on click?

only1wizard

ASKER

im referrring to the sub query in the posted code.

thanks in advance for your help!

PranjalShah

Close this question (as we are done with hide/show part) and start a new one with your current scenario. That way you will have more experts looking at your question.