Facebook Connect网站喜欢Digg(PHP)(Facebook Connect Site Like Digg (PHP))
我正在寻找一个PHP教程或如何设置像Digg一样的Facebook连接网站的例子。 基本上允许本地用户无限期地将他们的Facebook账户连接到他们的本地账户(直到他们退出)。 然后,每次他们用本地帐户登录时,他们都会自动将它们重新连接到Facebook。
我一直在努力寻找一个完整的开始到结束教程。 任何建议将不胜感激。
I'm looking for a PHP tutorial or example of how to set up a facebook connect site like digg. Basically allowing local users to connect their facebook accounts to their local accounts indefinitely (until they opt out). This would then automatically reconnect them to facebook every time they log in with their local accounts.
I've been trying for a long time to find a complete start-to-finish tutorial. Any suggestions would be greatly appreciated.
原文:https://stackoverflow.com/questions/1646659
最满意答案
这段代码做到了!
results = results.joins(:regionmemberships).where('regionmemberships.region_id = ?', region_id)
在这个线程的帮助下: Rails加入查询
This code did it!
results = results.joins(:regionmemberships).where('regionmemberships.region_id = ?', region_id)
With help from this thread: Rails joins query
相关问答
更多-
SQL连接 - 希望在一个表中搜索关键字,另外两个表(SQL join - Looking to search one table for keyword, two other tables)[2023-01-26]
一种解决方案是将所有三个现有表连接在一起,并根据需要编写where子句。 建议: select c.company_name from company c join company_states cs on c.companyID = cs.companyID join states s on cs.stateID = s.stateID where c.company_name like '%associates%' and s.stateID = 7 One ... -
在您的模型上使用此代码 public function search($cari){ $this->db->select('*'); $this->db->from("uhd_user_order AS t1"); $this->db->join("uhd_user_product_order AS t2", "t2.user_order_id = t1.user_order_id"); # confirm user_order_id in both table ...
-
尝试: SELECT campaign.name AS campaignTitle, campaign.desc AS campaignDesc, users.name AS companyName FROM campaign INNER JOIN users ON campaign.userId=users.id WHERE campaign.name like '%Mia%' OR campaign.desc like '%dolo%' OR users.name like '%iT%' 删除双引号 ...
-
思考Sphinx从同一个连接表中搜索不同的条件?(Thinking Sphinx search for different conditions from the same join table?)[2023-09-25]
我使用快捷方法修复它,不确定它是否可以...我定义了第三个关系,包括我之前为了搜索而定义的关系,并在define_index方法中使用它。 I fixed it using a short cut method, not sure whether it is okay or not... I defined a third relation that include both the relations that I defined earlier only for the sake of searchin ... -
这段代码做到了! results = results.joins(:regionmemberships).where('regionmemberships.region_id = ?', region_id) 在这个线程的帮助下: Rails加入查询 This code did it! results = results.joins(:regionmemberships).where('regionmemberships.region_id = ?', region_id) With help ...
-
SQL连接表日期搜索(SQL Join Table Date search)[2021-08-30]
日期需要在SQL查询中引用。 并且在查询中绝对没有理由使用%d和%s ,这些是与sprintf使用的格式运算符。 $query = "SELECT wp_ch_ifs_neworders.order_contact_id, wp_ch_ifs_neworders.order_date, wp_ch_ifs_neworders.order_contact, wp_ch_ifs_neworders.order_first_name, wp_ch_ifs_neworders.order_last_name, wp ... -
加入搜索结果(Join in search results)[2023-11-03]
如果我理解你,它很容易添加一个连接 ,如: SELECT `groups`.`id`, `groups`.`name`, `groups`.`description`, `groups`.`members`, `groups`.`image`, FROM `groups` LEFT JOIN group_members ON `groups`.`id` = group_members.group_id WHERE `groups`.`name` LI ... -
您正在寻找JOIN 。 你用table1两次JOIN table2两次,使用ALIAS来区分它们。 SELECT T2.id, A.book_name, B.book_name FROM Table2 T2 JOIN Table1 A ON T2.book_1 = A.id JOIN Table1 B ON T2.book_2 = B.id You are looking for JOIN. You JOIN table2 with table1 twice, using ALIA ...
-
如何使用`join`方法从rails中的多个表中访问列(How to use `join` method to access columns from multiple tables in rails)[2022-04-27]
你错过了选择语句,试试这个。 @users = User.select("users.*, masters.*").joins("INNER JOIN masters ON masters.sex = users.sex_id AND masters.type = 8") You have missed the select statement, try this one. @users = User.select("users.*, masters.*").joins("INNER JOIN maste ... -
如何在SQL Server的左连接情况下实现全文搜索?(How to implement full-text search in a left join situation in SQL Server?)[2024-04-04]
根据您的全文搜索条件限制两个表,然后加入它们。 Limit both tables based on your full text search criteria and then join them.