PHP - Display Facebook Reviews On Website

Hello Friends i just need your reviews for the following code

Code: [Select]
<?php 
   session_start();
   require_once("conf.php");
   mysql_select_db('site');
   $subjects=$_GET['sublen'];
   $username=$_SESSION['user'];
  for($i=1;$i<=$subjects;$i++)
  {
     $subject=$_GET[',Sub'.$i];
     $query="INSERT INTO Subjects(id,Subjects,User,Classs) VALUES($i,'$subject','$username','F.Y.B.Sc')";
     $true=mysql_query($query) or die("Cannot Store subjects".mysql_error());
   }

?>

Is this a valid way to store data in database????

I tried searching on google but couldn't find any relevant information, please redirect me to relevant source or help me with the code.

I want to pass a domain name in text field which will be scanned and then the script will display entire site map.

Not external links or links on a page. Sorry it is not easy for me to explain.

Eg. if i pass abc.com

Script will display

abc.com/12/adn.php
abc.com/asd/asd/
etc

Whatever their url format is.

All the links on that domain.

<?php
$con = mysql_connect("localhost","root","password");
if (!$con)
  {
  die('Could not connect:' . mysql_error());
  }
  mysql_select_db("Products", $con);
 $result = mysql_query("SELECT * FROM btp_reviews" );
echo "<table border='1' cellspacing='0' cellpadding='0'>";
echo '<tr>
<td>Id</td>
<td>Review</td>
<td>Name</td>
<td>Update</td>
<td>Status</td>
</tr>';
while($row = mysql_fetch_assoc($result))
  {
  echo '<tr>';
  echo '<td>' . $row['id'] . '</td>';
  echo "<td>" . $row['review'] . "</td>";
  echo "<td>" . $row['r_name'] . "</td>";
  echo "<td>" ."<form action='radio.php' method='post' ><a href=http://localhost/editt.php?id=".$row['id'].">Edit</a>.</td>
                <td>" ."<input type='radio' name='r1' value='2' />Approve<br/><input type=hidden name=id value='".$row['id']."' />
                         <input type='radio' name='r1' value='3' /> Reject<br/>
                             <input type=submit value=Submit /></form>"."</td>";
                           
  }
echo "</table>";
mysql_close($con);
?>

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=317436.0

It's very possible, and I've seen a website that's done it (http://www.zybez.net/radio/) - They are able to include the recent songs played on there website. The information can be obtained from right he http://68.168.100.60:7942/played.html

But I'm not sure if thats where they get it from. If I login to my Admin section, there will be an option that says get XML stats. But I'm not sure if that shows the recent songs played like it would at http://68.168.100.60:7942/played.html

(Everytime I refresh the page, the stats/data/info in the XML change)

Code: [Select]
1250001522Rockhttp://srbuckey.listen2myradio.comMusicPEAK - RockKings of Leon - Radioactive N/AN/AN/A226153140audio/mpeg1.9.86201901701119000000004013207.144.125.60NSPlayer/11.0.6001.7006 WMFSDK/11.0026101521287587284Kings of Leon - Radioactive 1287586919Three Days Grace - Riot 1287586542Alice In Chains - Here Comes The Rooster 1287586281Green Day - Boulevard of Broken Dreams 1287586277down 1287586075Green Day - American Idiot 1287586044Metallica - Enter Sandman 1287585836ACDC Highway To Hell.mp3 1287585449Metallica - 04 The Unforgiven I.MP3 1287585448[HTTP/1.1 200 OK] http://www.ventsi.com/Music/MetallicA/1991 - Black Album/Metallica - 04 The Unforgiven I.MP3

hello, I want to display the  echo ''"; in the right place on my website in changepassword_form.html all messages are written in changepassword.php. how can i move these echo after entering the wrong password or username?

changepassword.php


<?php
...........

  //success

  //change password in db

  $querychange = mysql_query("UPDATE users SET password='$newpassword' WHERE username='$username'");

  

  session_destroy();

  

  echo 'Password Has Been Changed Successfully !'; //move these 

  

}

else{

    echo('new password doesnt match!'); //move these

}

}

else {

      
           die('old password doesnt match!'); //move these

   

}

}

 else

 {

echo "";

include 'changepassword_form.html';

exit();

 }
}
else{
    echo 'you must be logged ';

 }
?>




move these echos somewhere to my html code how to do these??

Hi,   I've got a "data.txt" file with the following content:

One1:One2:One3:One4:One5:One6
Two1:Two2:Two3:Two4:Two5:Two6
Three1:Three2:Three3:Three4:Three5:Three6

Now I want to be able to take each data and put on a specific location of a htlm code. Each line for its own. So for the first line, it should look something like this:

<html>
<head>
<title></title>
<head>
<body>
<h1>One2</h1>
<h2>One4 some other Text One5</h2>
<img src="One6.jpg">
</body>
</html>

Unforturtunately I don't have a clue how to do that. Can anybody help me out or does someone know a good and easy tutorial?   Thanks a lot

Hi   I'm looking for some advice on how to parse an xml feed and display any odds on my site   Here is an example http://feed.youwincd...in_football.xml   and as you can see it is quite large so calling it every time would have an impact on the server.   I am looking at using many different feeds in the future so want to start this properly and in a scaleable way. I want to use php but open to any ideas on the best way to do this   Many thanks Sam

I'm working with a downloaded open-source CMS on localhost, and trying to learn.

Is there a tool that will list the files (php and otherwise) that are accessed (in order) as the CMS does various normal operations?  I want to see the order and the repetition of files that are opened, even if it is something minor.

Thanks.

Hi Guys,

I am using the PHP Facebook code with my app;

<?php    $app_id = "";   $app_secret = "";   $my_url = "";   session_start();   $code = $_REQUEST["code"];   if(empty($code)) {     $_SESSION['state'] = md5(uniqid(rand(), TRUE)); //CSRF protection     $dialog_url = "https://www.facebook.com/dialog/oauth?client_id="        . $app_id . "&redirect_uri=" . urlencode($my_url) . "&state="       . $_SESSION['state'];     echo("<script> top.location.href='" . $dialog_url . "'</script>");   }   if($_REQUEST['state'] == $_SESSION['state']) {     $token_url = "https://graph.facebook.com/oauth/access_token?"       . "client_id=" . $app_id . "&redirect_uri=" . urlencode($my_url)       . "&client_secret=" . $app_secret . "&code=" . $code;     $response = @file_get_contents($token_url);     $params = "user_questions";     parse_str($response, $params);     $graph_url = "https://graph.facebook.com/me?access_token="        . $params['access_token'];     $user = json_decode(file_get_contents($graph_url));     echo("Hello " . $user->name);   }   else {     echo("The state does not match. You may be a victim of CSRF.");   } ?>()

However I am having issues with the permissions, I can only ever get it to ask for "Yout basic info" when it needs to ask for more than that.

Any ideas why?

Cheers in advance.

On Facebook, when you click on "view friends" on one of your friends' profile, a window pops up. Is that made with PHP? Or is it flash or something? In case it's PHP, what would you use to make something like that? Thank you in advance!

Hi,

Is anyone here familiar with the Facebook API?

My boss wants people to be able to share their store with their friends on Facebook from within the stores admin panel. He wants the following.

1) Display all friends with a checkbox next to each name.
2) Check the friends you want to inform about your store.
3) Post a message on checked friends wall.

It sounds simple.

The problem is the friends selection screen. Some of my friends on Facebook have 1000 friends. Obviously listing all of them is inpractical. Ideally I need a search box to limit the friends that display and make it easy to find who you are looking for. Does something like this already exist? Does it have a name?

Hi there!

First, i must say that i have no php knowledge, maybe a 1%

Here is what i want to do:

I have wordpress, with a plugin called Facebook connect, it has a cool feature where you can invite your facebook friends, it looks like this:

http://dailyerz.com/login/?fbconnect_action=invite

And i am also using cubepoints, a plugin that rewards users with points. I want to reward users for every user they invite.

From the cube points docs http://techcube.net/docs/1.3/docs.html
i got this:

Quote

The following code will add 10 points to the current logged in user. If no user is logged in, no points will be added. You may input negative number to subtract points.


<php
  if( function_exists('cp_alterPoints') && is_user_logged_in() ){
    cp_alterPoints(cp_currentUser(), 10);
  }
?>

and the invite.php of facebook connect looks like this:

<?php get_header(); 
$fb_user = fb_get_loggedin_user();
?>
<div style="padding:20px;" >
<?php if(FBCONNECT_CANVAS=="web") : ?>
  <fb:serverfbml style="width: 100%;">
    <script type="text/fbml">
      <fb:fbml>
<?php endif; ?>       
      
          <fb:request-form
                    action="<?php echo get_option('siteurl'); ?>"
                    method="GET"
                    invite="true"
                    type="<?php echo get_option('blogname');?>"
                    content="<?php echo get_option('blogname')." : ".get_option('blogdescription'); ?>
                 <fb:req-choice url='<?php echo get_option('siteurl'); ?>'
                       label='<?php _e('Become a Member!', 'fbconnect') ?>' />
              "
              >
 
                    <fb:multi-friend-selector
rows="5"
email_invite="false"
cols="3"
                    showborder="false"
                    actiontext="<?php _e('Invite your friends to Dailyerz.', 'fbconnect') ?>">
        </fb:request-form>
<?php if(FBCONNECT_CANVAS=="web") : ?>
      </fb:fbml>
 
    </script>
  </fb:serverfbml>
<?php endif; ?>
</div>
<?php get_footer(); ?>


Any idea on how to make this work? Do i have to create a Facebook App? 

Thanks!

Hi,
I'm having problems with my phpbb forum/facebook coding. I have recently put Facebook Share links in my forum...

The facebook 'Share' links(buttons), are attached to every post viewable within th eforum, and link to:
http://www.facebook.com/sharer.php?u=http://www.mywebsite.com/facebook/share-fb.php?postNo=" . $postrow[$i]['post_id'].'&title='.$userdata['username'].'%20on%20facebook!!'
--> where
'$userdata['username']' username of forum user
..and
'$postrow[$i]['post_id']' = the id of the forum post, to be processed by share-fb.php


So as according to he
http://developers.facebook.com/docs/share
under the Basics section, I will be able to control the thumbnail, title and content from
Quote

You can control the exact title, description, and thumbnail that Facebook Share uses by adding the following meta tags to the <head> element in your page:

So the url looks like this:
http://www.anclchess.net/facebook/share.php?postNo=65914&title=My%20Names%20on%20facebook!!Title%20of%20post

There are 2 major problems.
1) I am passing the post number identity via URL.. which means anyone wanting to view posts they may not have permissions to view, would simply need to change the share.php?postNo=65914&title= and they would have access..
and
2) The the thumbnail, title and content don't seem to work.. I cant figure out why.. see below
This is 'share-fb.php':
<?php

define('IN_PHPBB', true);  // allows infomation to be passed to external page, such as '$userdata['username'] '(username)
$phpbb_root_path = '../forum/';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);

//
// Start session management
//
$userdata = session_pagestart($user_ip, PAGE_INDEX);
init_userprefs($userdata);
//
// End session management
//
?>
<?php

$postIdent = $_GET['postNo']; // gets forum post identity from URL, to then later query.. \\
$titleIdent = $_GET['title']; // gets title of post from URL too \\

if($userdata['session_logged_in'])
{

//echo'Hello ' . $userdata['username'] . '. The facebook system is not yet up-and-running. Please try later.<br>'; // <-works \\
$sql = "SELECT post_id, post_subject, post_text FROM phpbb_posts_text WHERE post_id='$postIdent'";
if( !($result = $db->sql_query($sql)) )
{
message_die(CRITICAL_ERROR, "Could not query config information", "", __LINE__, __FILE__, $sql);
}

while ( $row = $db->sql_fetchrow($result) ) // executes database query \\
{
$postSubject = $row['post_subject'];
$postText = $row['post_text'];

}
$pattern = '#\[[^\]]+\]#';
$postTextFormat = preg_replace($pattern, '', $postText);  // this search and replaces the forum square brackets code such as: '[ url ]' & '[ /url ]' content 
?>
<!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></title> // left empty \\ 
<script src="http://static.ak.fbcdn.net/connect.php/js/FB.Share" 
        type="text/javascript">
</script>
<meta name="title" content="<?php echo echo $titleIdent; ?>" /> // this doesnt work - I don't know why. The variables work in the <body> but not here \\
<meta name="description" content="<?php echo $postSubject.$postTextFormat; ?>" /> 
<link rel="image_src" href="http://www.mywebsite.com/images/website_log.png" />
</head>

<body>
<?php  
echo $postSubject.'<br>'.$postTextFormat; // contains content of forum post \\
?>
</body>
</html>
<?php
}
else
{
echo('You are a forum guest. Please sign in or register.');
}

?>


Please help if you can.