On Jul 30, 2009, at 9:10 PM, Rob Marscher
wrote:
On Jul 30, 2009, at 6:33 PM, Allen Shaw wrote:
I'm thinking the multi-table joins performed twice for each search
will make more of a hit in performance (and maintenance) than
writing two rows for each relationship and then always being a
On Jul 30, 2009, at 6:33 PM, Allen Shaw wrote:
I'm thinking the multi-table joins performed twice for each search
will make more of a hit in performance (and maintenance) than
writing two rows for each relationship and then always being able to
search only once.
I've used code like that
[reformatted]
Mitch Pirtle wrote:
On Thu, Jul 30, 2009 at 5:07 PM, Elijah Insua wrote:
This is how I would approach the problem (simplified/pseudocode)
CREATE TABLE user (
id INT,
username VARCHAR
);
CREATE TABLE friend (
id INT,
user_id INT,
friend_id INT
);
-- Get al
++ on this approach, took a similar route on a very high traffic site
and that was a major bonus.
-- Mitch
On Thu, Jul 30, 2009 at 5:07 PM, Elijah Insua wrote:
> This is how I would approach the problem (simplified/pseudocode)
>
> CREATE TABLE user (
> id INT,
> username VARCHAR
> );
>
>
Thanks for clarifying.
glenn
On Jul 30, 2009, at 5:07 PM, Allen Shaw wrote:
Glenn Powell wrote:
... if 100 considers 300 a friend, that does not mean that 300
considers 100 a friend.
It could be maddening for a user to see that they are a friend of
300, when in fact they have not done a
Glenn Powell wrote:
... if 100 considers 300 a friend, that does not mean that 300
considers 100 a friend.
It could be maddening for a user to see that they are a friend of 300,
when in fact they have not done anything in the system
to create that relationship.
Hi Glenn,
For a social networ
This is how I would approach the problem (simplified/pseudocode)
CREATE TABLE user (
id INT,
username VARCHAR
);
CREATE TABLE friend (
id INT,
user_id INT,
friend_id INT
);
-- Get all of user #1's friends usernames
SELECT u.username FROM users u, friends f WHERE f.user_id = 1
On Thu, 30 Jul 2009, Michele Waldman wrote:
> Will sudo work from the php script? That would work for me.
>
> Basically, I'm looking through domain names gotten from mysql and copying
> files from a template directory in one domain to the other domains.
>
> Sudo has been setup for the user, but
imho,
For option 1, if looking for friends of 100, maybe you only have to
look in col 1.
if 100 considers 300 a friend, that does not mean that 300 considers
100 a friend.
It could be maddening for a user to see that they are a friend of 300,
when in fact they have not done anything in
I'd go with option #2, because it allows a "two-way" friendship,
similar to how LiveJournal does it. Or, you could run a logic hook
and check that both relationships exists, or the friendship is
"pending." Option #1 means that you'd have to query the table twice
(or the RDBMS would) to get a frie
I've had a lot of success with jQuery Flot: http://code.google.com/p/flot/
On Thu, Jul 30, 2009 at 3:53 PM, Brian D. wrote:
> There's a number of them out there, but if your needs are humble the
> Google Chart API is absolutely fantastic if only for it's sheer
> simplicity.
>
> - Brian
>
> realm3
I did this a few years ago and I believe I went with option 1 (disclaimer:
most what I did back then would be shunned by even the most beginner of
programmers).
#2 definitely has its advantages but goes against database normalization
theory (in my opinion), especially since there is inherently no
There's a number of them out there, but if your needs are humble the
Google Chart API is absolutely fantastic if only for it's sheer
simplicity.
- Brian
realm3 web applications [realm3.com]
Information architecture, application development.
phone: (917) 512-3594
fax: (440) 744-3559
On Thu, Jul
> Are you sure?
yah, pretty much - if you want to connect to a server using ssh, then this
is the way to go...
> The scenario is I'm running a php script but I want to switch linix
> users?
>
> Do I have to use ssh2? I would have to go off the server and come back
> in just to switch users?
Wh
That's what I was originally thinking.
I was hoping for a way around.
Michele
> -Original Message-
> From: talk-boun...@lists.nyphp.org [mailto:talk-boun...@lists.nyphp.org]
> On Behalf Of John Campbell
> Sent: Thursday, July 30, 2009 4:00 PM
> To: NYPHP Talk
> Subject: Re: [nyphp-talk]
Hi Gang,
To support "friend" relationships in a contacts management database, I'm
expecting to use a simple table like this one (plus a few columns for
unique id, etc.):
CREATE TABLE `tcontactrelationships` (
`contact1` int(11),
`contact2` int(11)
);
My concern is that when I'm looking for
On Thu, Jul 30, 2009 at 3:44 PM, Michele Waldman wrote:
> Will sudo work from the php script? That would work for me.
Unfortunately it won't work.
I am not sure what the problem you are having is, but my instinct
tells me the correct solution has something to do with groups and
permissions.
Reg
Will sudo work from the php script? That would work for me.
Basically, I'm looking through domain names gotten from mysql and copying
files from a template directory in one domain to the other domains.
Sudo has been setup for the user, but I didn't know if it would work or how
it works or
Why not use sudo? or run a damon as the other user that performs the task
you need.
What exactly does the other user need to do?
On Thu, Jul 30, 2009 at 3:35 PM, Ajai Khattri wrote:
> On Thu, 30 Jul 2009, Michele Waldman wrote:
>
> > The scenario is I'm running a php script but I want to switch
On Thu, 30 Jul 2009, Michele Waldman wrote:
> The scenario is I'm running a php script but I want to switch linix users?
>
> Do I have to use ssh2? I would have to go off the server and come back in
> just to switch users?
Only root can change user and I doubt your script will be running as root
Are you sure?
The scenario is I'm running a php script but I want to switch linix users?
Do I have to use ssh2? I would have to go off the server and come back in
just to switch users?
Michele
> -Original Message-
> From: talk-boun...@lists.nyphp.org [mailto:talk-boun...@lists.nyphp.or
> If I'm on a server already what function can I use to connect as
> another user?
Seems like a reasonable choice:
http://us2.php.net/manual/en/function.ssh2-connect.php
Then you'll probably want:
http://us2.php.net/manual/en/function.ssh2-auth-password.php
H
On Thu, 30 Jul 2009, David A. Roth wrote:
> I asked this question two years ago and wanted to know if anyone has
> updates to these suggestions?
Protovis - http://vis.stanford.edu/protovis/ (JS)
GoogChart -
http://luddep.se/notebook/2008/04/13/charts-php-and-google-charts-api/
FusionCharts Fr
http://www.lmsotfy.com/index.php?q=open%20source%20PHP%20chart%20and%20graph%20library
And more seriously:
http://stackoverflow.com/questions/395541/graphs-charts-in-php
On Thu, Jul 30, 2009 at 2:11 PM, Brent Baisley wrote:
> I was looking into this a few weeks ago and discovered Google charts.
I was looking into this a few weeks ago and discovered Google charts.
It's not PHP, but you just pass them some data in a URL and they will
render a chart for you. The chart is actually a graphic image, so you
can incorporate it any way you want.
http://code.google.com/apis/chart/
Of course, you a
Another JS library, but I've heard good things about Flot.
http://code.google.com/p/flot/
On Thu, Jul 30, 2009 at 2:05 PM, David A. Roth wrote:
> I asked this question two years ago and wanted to know if anyone has
> updates to these suggestions? (By the way,
> http://pear.veggerby.dk/samples/ i
I asked this question two years ago and wanted to know if anyone has
updates to these suggestions? (By the way,
http://pear.veggerby.dk/samples/ is still in Alpha)
http://pear.veggerby.dk/samples/
JpGraph http://www.aditus.nu/jpgraph/
PHP/SWF Charts http://www.maani.us/charts/index.php
Javascri
If I'm on a server already what function can I use to connect as another
user?
Michele
> -Original Message-
> From: talk-boun...@lists.nyphp.org [mailto:talk-boun...@lists.nyphp.org]
> On Behalf Of Hans Zaunere
> Sent: Thursday, July 30, 2009 1:20 PM
> To: 'NYPHP Talk'
> Subject: Re: [nyp
> Does anyone know if you need a library for SSH2_CONNECT?
>
> If so, which one?
http://us2.php.net/manual/en/ssh2.installation.php
Most (all?) unix systems should have the required libs already.
H
___
New York PHP User Group Community Talk Mailing
Does anyone know if you need a library for SSH2_CONNECT?
If so, which one?
Margaret Michele Waldman
Sovereign Sites L.L.C.
Website Development
646-861-3375
Rule your domain ...
___
New York PHP User Group Community Talk Mailing List
http:/
> That's the strategy I use ... I sure hope that's not unsafe
>
> Hello everyone.
> First of I wanna say hi, since it's my first contribution here.
> Also I'm not from NY, but Norway. Found your site trough google
>
> Now, back on topic:
> It's a very nice, short and
That's the strategy I use ... I sure hope that's not unsafe
On Tue, Jul 28, 2009 at 11:58 AM, PHP Tutor wrote:
> Hello everyone.
> First of I wanna say hi, since it's my first contribution here.
> Also I'm not from NY, but Norway. Found your site trough google
>
> Now, back on topic:
> It's a v
32 matches
Mail list logo
