Jump to content


Photo

Need Help With Public/Private PHP Button


  • Please log in to reply
3 replies to this topic

#1 saadlive

saadlive
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 02 June 2006 - 07:57 PM

Hi there,

I am making a blog and it works perfect except I want to make it so when you log in you can see the private posts and the public can see the public posts.

I made a public button on the blog submission form. I also made it in my SQL database for a public yes/no line.

Now what should I put in my code to make it so it only shows public ones if you arent logged in and if you are logged in then you can see the private posts.


Help? lol

#2 jeremywesselman

jeremywesselman
  • Members
  • PipPipPip
  • Advanced Member
  • 154 posts
  • LocationIndependence, KY

Posted 02 June 2006 - 08:28 PM

<?php
if($IsLoggedIn)
{
     //if client is logged in, show all posts
     $sql = "SELECT * FROM posts";
}
else
{
     //if client is not at logged in, show only public posts
     $sql = "SELECT * FROM posts WHERE public = 'yes'";
}
?>

Where $IsLoggedIn is a variable that that you set after you log in.

[!--coloro:#990000--][span style=\"color:#990000\"][!--/coloro--]Jeremy[!--colorc--][/span][!--/colorc--]

#3 poirot

poirot
  • Members
  • PipPipPip
  • Advanced Member
  • 646 posts
  • LocationAustin, TX

Posted 02 June 2006 - 08:36 PM

That's not all, you will have to modify the script that INSERTs the entry; and also create a public/private button.
~ D Kuang

#4 jeremywesselman

jeremywesselman
  • Members
  • PipPipPip
  • Advanced Member
  • 154 posts
  • LocationIndependence, KY

Posted 02 June 2006 - 08:47 PM

An alternate would be to make a public/private button and write it in the script where you manage your blog posts. This way, you could change the type of post back and forth.

[!--coloro:#990000--][span style=\"color:#990000\"][!--/coloro--]Jeremy[!--colorc--][/span][!--/colorc--]




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users