We help IT Professionals succeed at work.
Get Started

show / hide database results

341 Views
Last Modified: 2012-05-11
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

Comment
Watch Question
This problem has been solved!
Unlock 1 Answer and 11 Comments.
See Answer
Why Experts Exchange?

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.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE