These 2 posts made integrating Facebook Client with CodeIgniter piece of cake:
Now I am working on making Facebook Connect integrate with Facebook Client. This one should be easy (fingers-crossed).
Here is some updates: Users can add or update their reviews of stuff. Check it out here: http://amerkhalid.com/facebook/Stuff/index.php
It’s still in development, so please excuse any bugs right now.
Thanks
My PHP has gone rusty. I have been spending a quite bit of time research different syntax for PHP. Anyways, now my app has just one basic ability, check to see if user is a new app user, and if so then gather some basic info in the database.
I have set the app in dev mode, so I don’t think anyone can really add it, (other than developers, of course). But here’s the URL anyways: http://amerkhalid.com/facebook/Stuff/.
So let me present to you my database structure for now. It is still evolving:
|
1 |
<!--more--> |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 |
-- phpMyAdmin SQL Dump -- version 2.11.6 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Jul 31, 2008 at 04:31 PM -- Server version: 4.1.22 -- PHP Version: 5.2.6 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- -- Database: `chaospla_facebook` -- -- -------------------------------------------------------- -- -- Table structure for table `t_platforms` -- CREATE TABLE IF NOT EXISTS `t_platforms` ( `platformid` int(11) NOT NULL auto_increment, `platform_name` varchar(25) NOT NULL default '', PRIMARY KEY (`platformid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -- Dumping data for table `t_platforms` -- INSERT INTO `t_platforms` (`platformid`, `platform_name`) VALUES(1, 'facebook'); -- -------------------------------------------------------- -- -- Table structure for table `t_properties` -- CREATE TABLE IF NOT EXISTS `t_properties` ( `propertyid` int(11) NOT NULL auto_increment, `property_name` varchar(32) NOT NULL default '' COMMENT 'name, address, phone, ', PRIMARY KEY (`propertyid`), UNIQUE KEY `property_name` (`property_name`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ; -- -- Dumping data for table `t_properties` -- INSERT INTO `t_properties` (`propertyid`, `property_name`) VALUES(1, 'First Name'); INSERT INTO `t_properties` (`propertyid`, `property_name`) VALUES(2, 'Last Name'); INSERT INTO `t_properties` (`propertyid`, `property_name`) VALUES(3, 'City'); INSERT INTO `t_properties` (`propertyid`, `property_name`) VALUES(4, 'State'); INSERT INTO `t_properties` (`propertyid`, `property_name`) VALUES(5, 'Country'); INSERT INTO `t_properties` (`propertyid`, `property_name`) VALUES(6, 'Zip'); INSERT INTO `t_properties` (`propertyid`, `property_name`) VALUES(7, 'Sex'); INSERT INTO `t_properties` (`propertyid`, `property_name`) VALUES(8, 'Relationship'); INSERT INTO `t_properties` (`propertyid`, `property_name`) VALUES(9, 'Religion'); INSERT INTO `t_properties` (`propertyid`, `property_name`) VALUES(10, 'politics'); INSERT INTO `t_properties` (`propertyid`, `property_name`) VALUES(11, 'Network'); INSERT INTO `t_properties` (`propertyid`, `property_name`) VALUES(12, 'Looking For'); -- -------------------------------------------------------- -- -- Table structure for table `t_users` -- CREATE TABLE IF NOT EXISTS `t_users` ( `userid` int(10) unsigned NOT NULL auto_increment, `platformid` int(11) NOT NULL default '0', `platform_userid` varchar(60) NOT NULL default '', `crte_date` datetime NOT NULL default '0000-00-00 00:00:00', `active` tinyint(1) NOT NULL default '0', `updt_date` datetime default NULL, PRIMARY KEY (`userid`), UNIQUE KEY `platformid` (`platformid`,`platform_userid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -- Dumping data for table `t_users` -- INSERT INTO `t_users` (`userid`, `platformid`, `platform_userid`, `crte_date`, `active`, `updt_date`) VALUES(1, 1, '25311983', '2008-07-31 16:30:25', 1, NULL); -- -------------------------------------------------------- -- -- Table structure for table `t_user_properties` -- CREATE TABLE IF NOT EXISTS `t_user_properties` ( `userid` int(10) unsigned NOT NULL default '0' COMMENT 'FK', `propertyid` int(10) unsigned NOT NULL default '0' COMMENT 'FK', `value` varchar(64) NOT NULL default '', `active` tinyint(1) NOT NULL default '0', `updt_date` datetime NOT NULL default '0000-00-00 00:00:00', UNIQUE KEY `userid_2` (`userid`,`propertyid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
I am hoping today i will get some chance to do coding on my facebook project. Last night, I was making a feature’s list for the version 1.0. I am planning to keep whole project fully open sourced. This is more like a proof of concept, therefore, i am not worried about competition.
I guess the first part is to explain what is the project about. It is a simple list of things, stuff, locations, arts and everything else that anyone likes or dislikes. I got idea for this from Acosta and Karl, I was able to integrate their ideas together easily, however, I am working on my idea of dating app in this list.
Maybe later today, I will upload my feature list.
I was planning to party for next 2 weeks… but I am just so inclined to do something productive. I will spend these 2 weeks working on my facebook app.
last week was nightmare. I changed my work schedule to go in late and work late in the evening. I thought it would give me all the time to do my own things in the morning but I ended up just sleeping trough the mornings. There is not much I can do late at the night. So today I asked my boss to go back on original schedule.
I was on my way to home right but there was huge traffic jam on 360. So I decided to stop by Starbucks. I should have gone for rock climbing.
I didn’t run at all last week. So bad!
And I couldn’t work on my SCJD project and facebook project.
I was super busy with work stuff. I did manage to eat at new and different resturant everyday last week. Let me see, here are some of the places I ate at:
I have decided to get my own place. I already found the place. I think I will move in there on July 1st.
I just realized that I spend $8.00 to go to work and come back. Ouch!
My vacation got pushed to August. Oh well!
Ralph is back in town.
I guess I will work on SCJD now.
Weekend is almost over. How did I do on my goals?
First the good, I played with facebook api. I figured out a few key things. I setup repository to store code.
Then the bad, I didn’t run at all this week. I did rock climbed twice. I also used stepper but just for ten minutes.
Lastly, the ugly, I could not work on SCJD project. Only thing I did was setup repository.
So the goals for this week are:
Well actually it took much longer than 10 minutes because I got into some issues. First check out my app. It doesn’t do much but its the beginning. The end goal being the dating website.
So here is what I ran into. I followed this tutorial. My webserver uses php4 but the tutorial I got from facebook was for php5. PHP4 does not support try… catch blocks. (I didn’t know that). I had to modify the appinclude.php like this:
//catch the exception that gets thrown if the cookie has an invalid session_key in it
if (!$facebook->api_client->users_isAppAdded()) {
$facebook->redirect($facebook->get_add_url());
}/*Commented out this section, not sure how to deal with this just yet.
{
//this will clear cookies for your application and redirect them to a login prompt
$facebook->set_user(null, null);
$facebook->redirect($appcallbackurl);
}*/
Then like many other’s I had to upload simplexml44-0_4_4 in php4client directory.
After that it worked like a charm.
So that was the first step towards one of my 2008′s objectives.