Search the Community

Can somebody please explain how to properly add a Facebook Share button to my site? It's not simply a matter of generating the button and pasting the code into my pages; in order to ensure that the right information is shared, I also have to add Open Graph metatags. But the thing that's confusing me is that one of the required Open Graph metatags is this: <meta property="fb:app_id" content="APP_ID_NUMBER" /> Questions 1) Does this mean that I have to register as an app builder before I can add the Share button? If so, why doesn't Facebook say so on the Share button page? 2) When generating the Share button, I am asked for the "URL to share". Does this mean that I have to generate a different Share button for each page? Surely not. 3) I use ShareThis at the moment. Does ShareThis work with Facebook Insights?

The like/dislike button script found here: http://wcetdesigns.com/tutorials/demos/like-dislike-button.html works perfectly for what I am trying to do on my webpage. The issue I am having is I can connect to one table perfect but the script breaks if I try to add another set of like/dislike buttons that connects to another table. How can I add 2 additional like/dislike button sets that can connect to 2 addtional tables in my database. For example Topic name (like/dislike button set that connects to table 1) Messages (like/dislike button set that connect to table 2) Message Replies (like/dislike button set that connects to table 3) any help would be appreciated. Thanks

Ok if have some code that i am trying to add to. <form action="#" method="post" enctype="multipart/form-data"> <input type="text" name="search"/> <input type="submit" name="search1"/> </form> <?php if(isset($_POST['search1'])){ $search=mysql_real_escape_string($_POST['search']); } include 'connect.php'; if(isset($_POST['search1'])){ $query=mysql_query("SELECT * FROM media WHERE extra_cred LIKE '%".$search."%' OR artist_id LIKE '%".$search."%' OR title LIKE '%".$search."%' OR content LIKE '%".$search."%' OR detail LIKE '%".$search."%' OR tags LIKE '%".$search."%' OR user LIKE '%".$search."%' OR type LIKE '%".$search."%' ") ?> What I would like to do is also search another table within that database by the name of artists with the same POST data. Anyone know what to do? I've been at this for a while.

Hello Guys, I have a system that generate project numbers. The system is: YEAR - PROJECT NUMBER . Sub ID 2014.1065.02 I want to be able to search my database for the sub ID's belonging to a project. I have tried using wildcards, but they don't seem to do what I want. Could you please tell me where I'm going wrong? $project_id = $_SESSION['PROJECT']; $project_id_trim = substr($project_id, 0,-3); $trim = mysql_real_escape_string($project_id_trim); echo $trim; $result = mysql_query("SELECT * FROM `Project_subhire` WHERE `Subhire_id` LIKE '%$trim%'"); while ($row = mysql_fetch_array($result)) { $project_results = $row['Project_id']; } Thanks

Hey everyone I finally reach a point where I need to go a little further in what social integration is about. That said, and starting with facebook, I've read a few docs and follow the documention but a few questions still remain. I will start to say what I have understood so far: I've created the app in facebook, configured everything just right (I even manage to get a local and production environment going on) I manage to successful login and get the returned url with the token flag From what I understood, I need to get an access_token from this return token, using the php sdk method provided by facebook (something along the lines of $facebook->getAccessToken(); ) The problem: I want to have a like button (with the share dialog). Currently I'm not managing to get the like to appear on the user timeline - I do have permissions, given upon user login. My question: Has anyone implemented something like this? Should I get the access_token and store it in a session variable? How can I associated the access_token to the "like" request? What is usually the basic workflow? What I have: The user click the login button, gets redirected to the facebook page. Logs in, accepts permission and gets back to the mydomain.com/token=facebook_token. I have a script associated specifically to this url (script that upon login, registers/logs the user into my actual website). I think in this script, I can store whatever tokens I need, I'm just trying to figure out where to use them! I've ask around and either this is just so simple no one cares to explain or I'm just having bad luck! Thank you very, very much for your attention. ps.: I'll buy you a beer!

Query: SELECT UMTS_napetude_cell.parent, UMTS_napetude_nodeb.idnap FROM UMTS_napetude_cell LEFT JOIN UMTS_napetude_nodeb ON UMTS_napetude_cell.parent IS NOT LIKE CONCAT('%',UMTS_napetude_nodeb.idnap,'%') WHERE UMTS_napetude_cell.parent IS NOT NULL Error: Thanks in advanced.

Hi There, I have got this code: function displayPosts() { $query = mysql_query("SELECT * FROM social ORDER BY id DESC") or die(mysql_error()); while( $result = mysql_fetch_assoc($query) ) { echo ' <div id="socialnewsfeeditem"> <p id="newsfeeditemperson"> '.$result["fullname"].' </p> <p id="newsfeeditemcontent"> '.$result["content"].' </p> <p> <center> <a href="social.php?id='.$result["id"].'&do=like">Like!</a> </center> </p> <div id="likes"> <p>'.self::displayLikes($result["id"]).'</p> </div> </div> '; } } function displayLikes($id) { $query = mysql_query("SELECT full_name FROM sociallike WHERE postid = '$id'") or die(mysql_error()); while( $result = mysql_fetch_assoc($query) ) { echo $result['full_name']."likes"; } } function like($id, $username) { $query2 = "INSERT INTO sociallike VALUES('$id', '$username')"; mysql_query($query2); } But when I try to displayLikes the all come up all over the place on the page and I have no clue why it is doing this. I will upload the whole (functions.php) functions and the (social.php) php file on here. Many Thanks for Your Help functions.php social.php

I have some questions about match phrase (more than 1 word) with phrase. I have some items with keywords which I need to match. Case 1: the keyword is "lady's-shoes" and I need to get items with keywords "lady's-shoes lady's-shoe woman's-shoe" but not to match "lady's-jeans lady's-pants". Case 2: the keyword is "long dress green" and I need to get items with keywords "long dress" and "long dress green" and "long dress green for woman" but not "green shoe " nor "long dress red" Which one do I need to use, LIKE or MATCH AGAINST? Do I need '%%' for the LIKE? Case 3: case 1 without dash (-). Is it better to find if I use dash between words? Thank's. Rgds, ayok

hey guys, i have a MySQL query that has multiple LIKE wildcard statement and multiple ORDER BY statements. "SELECT * FROM `content` WHERE `release_date` LIKE '%2013-06%' OR `release_date` LIKE '%2013-05%' OR `release_date` LIKE '%2013-04%' AND `release_country` = 'USA' AND `is_active_member` = 1 ORDER BY `votes' DESC, `release_date` DESC LIMIT 0 , 50" as you can see i have 3 wildcard's 5 total conditionals 2 ORDER BY fields The ISSUE: my wildcard statements work just fine and filters what i need, everything after ( release_country, is_active_member) dont seem to filter, also my ORDER BY only passes the first conditional. and release_date is not sorted. i have done plenty of research to see if there are other formats to this( which there is ) but they also don't seem to work. The data and field names are correct, and when i place the other fields first, they come out correctly. but i cant get this exact query to work. any suggestions as why this is happening ? thanks guys

Hy I'm trying to execute this query $stmt = $mysqli->prepare("SELECT streamer,content,provider FROM evento,canali WHERE canali.id=evento.idcanale AND evento.titolo LIKE '%?%' OR evento.sottotitolo LIKE '%?%' AND evento.datainizio=2013-02-21;"); $stmt->bind_param('ss',$tok,$tok); $stmt->execute(); $stmt->close(); but I get this error Warning: mysqli_stmt::bind_param(): Number of variables doesn't match number of parameters in prepared statement. but to me it seems like the number are the same, you can see how I prepared the statement with 2 arguments to define, and then I passe 2 arguments to add_param, what I'm getting wrong? some has some ideas? thanks daniele New php-forum User Posts: 2 Joined: Fri May 03, 2013 6:48 pm