SharkEye Community

[Web Designers & Developers] Re: Dynamic PHP Tree Menu

info@operacesky.net (SharkEye) — Tue, 19 Aug 2008 21:20:38 GMT

Author: SharkEye
Post subject: Re: Dynamic PHP Tree Menu
Posted: Tue Aug 19, 2008 9:20 pm

Paranoid Android wrote:I've found a few code examples but they all seem to read the menu from an array and not from a dynamically created query. Should i be trying to read from the database into an array first?? Am i missing something?? am I doing the whole bloody thing wrong??? PMSL...

When you query the database your results will be put into an array... u then use this and loop through it to display teh results...

So something like

Code: Select all: $result = mysql_query("SELECT * FROM news WHERE newsid='$newsid' ",$connect); while($myrow = mysql_fetch_assoc($result)) { echo $myrow['nameOfTableCol']; }

[Web Designers & Developers] Re: Dynamic PHP Tree Menu

info@operacesky.net (SharkEye) — Tue, 19 Aug 2008 21:15:25 GMT

Author: SharkEye
Post subject: Re: Dynamic PHP Tree Menu
Posted: Tue Aug 19, 2008 9:15 pm

interesting.... not sure i understand - but...

What i would do is create a page (mypage.php) which lists all the distinct

SELECT DISTINCT(Destinct) FROM myTable ORDER BY Destinct DESC
(not sure if sql is correct for distinct)

Then for each row print this
echo '' . $row['Distinct'] . '';

Then something like
if (!empty($_GET['Destinct']))
{
// Do this quiry and get all the parishes for the selected destinct
SELECT * FROM myTable WHERE Destinct = '$myDestinct' ORDER BY Parish DESC
// print each title and link to fiel name
}

done... hummmmm not the cleanest of posts but i have just quickly put that together as watching BB... post back if you need more code or explination tomorrow....

Thats assuming i have go the right idea...!

[Web Designers & Developers] Dynamic PHP Tree Menu

info@operacesky.net (Paranoid Android) — Tue, 19 Aug 2008 17:53:06 GMT

Author: Paranoid Android
Post subject: Dynamic PHP Tree Menu
Posted: Tue Aug 19, 2008 5:53 pm

OK.. a bit of background first...
I work for a National Park and there is a database of public 'rights of way' changes that have been made over the years. These were originally all stored on paper but have recently been made into pdf's as the government have decreed that they have to be made available to the public on our website. Enter yours truly..!
So.. a (very) simplified version of the database looks like this:

District.......................Parish....................Filename
Scarborough..................Westerdale..............townendfarm.pdf
Scarborough..................Harwood Dale...........anotherfarm.pdf
Scarborough..................Harwood Dale............anotherbloodyfarm.pdf
Rydale.........................Bransdale................anotherpath.pdf
Rydale.........................Rievaulx.................someotherpath.pdf

you get the idea...!?
So.. what "they" have asked for is a tree menu where the first level is the district and when you click that it opens up the Parishes underneath that, and this in turn shows the Rights of Way pdf associated with this amendment.

I've found a few code examples but they all seem to read the menu from an array and not from a dynamically created query. Should i be trying to read from the database into an array first?? Am i missing something?? am I doing the whole bloody thing wrong??? PMSL...

Any advice or direction to a poor I.T. bod from you php guru's???

****runs back to Google****

[Technology & Gadgets] Re: Broadband ISP's

info@operacesky.net (Richyg01) — Tue, 19 Aug 2008 08:26:37 GMT

Author: Richyg01
Post subject: Re: Broadband ISP's
Posted: Tue Aug 19, 2008 8:26 am

No mate, they dont have Sky, but I said it would be a good time to get it if they want to update their TV Choices!

The other problem they have is they are a long way from the telephone exchange so their speed ability is very poor!

[Technology & Gadgets] Re: Broadband ISP's

info@operacesky.net (SharkEye) — Tue, 19 Aug 2008 08:08:29 GMT

Author: SharkEye
Post subject: Re: Broadband ISP's
Posted: Tue Aug 19, 2008 8:08 am

Boooo!

Glad your advising to get rid of AOL!

None-cable... DOH! Do they have sky? I would have said to go with Virgin at the moment... cable is so much better than adsl in my opinion...

BT - I have had no problems with the service... the customer service is sh*t but the server has never gone down... however speed is not worth the money at the moment - they are just too expensive.

Gosh... I am not sure to be honest...

[Technology & Gadgets] Broadband ISP's

info@operacesky.net (Richyg01) — Mon, 18 Aug 2008 14:38:29 GMT

Author: Richyg01
Post subject: Broadband ISP's
Posted: Mon Aug 18, 2008 2:38 pm

I am posting on behalf of my other half's mam.

She is currently on AOL and is having constant connectivity issues, hence I have told her to change ISP.

Can anyone make reccommendations?

They are in a non-cable area btw.

Cheers

[Technology & Gadgets] Re: iphone

info@operacesky.net (Richyg01) — Mon, 18 Aug 2008 14:33:08 GMT

Author: Richyg01
Post subject: Re: iphone
Posted: Mon Aug 18, 2008 2:33 pm

Sounds just the same as you with anything of yours mate!!!

[Technology & Gadgets] Transcription software

info@operacesky.net (blowfish) — Mon, 18 Aug 2008 09:44:21 GMT

Author: blowfish
Post subject: Transcription software
Posted: Mon Aug 18, 2008 9:44 am

Was wondering if anyone knew of any free transcription software.

I am about to start my interviews for my thesis, and for the first time am using a digital voice recorder (instead of tape), so need some software that will allow me to slow down the speed of the sound so I can transcribe it, and something with "hot keys" so i can control the sound file (i.e. pause rewind etc) while using word!

I was told about some software called NCH Express Scribe Transcription Playback Software, but unfortunately it is not free, it has a 14 days trial then will cost me lots of money!

Help!

[Web Designers & Developers] Re: Creation of own CMS

info@operacesky.net (William316) — Sun, 17 Aug 2008 13:15:20 GMT

Author: William316
Post subject: Re: Creation of own CMS
Posted: Sun Aug 17, 2008 1:15 pm

No - I had no part in the design of the site - I have been providing feedback on how the site works and what can be improved, what really works and so on. It's designed as an enhanced social networking and activist platform, to run alongside other Amnesty sites and platforms. I particularly like the Bookmark button that can be dragged and dropped onto a toolbar - cool:)

[Technology & Gadgets] Re: iphone

info@operacesky.net (SharkEye) — Sun, 17 Aug 2008 12:53:46 GMT

Author: SharkEye
Post subject: Re: iphone
Posted: Sun Aug 17, 2008 12:53 pm

my parents came over to visit yesterday and my dad got very excited as he wants an iphone... i could see fiona starting to shake as other people got excited over her phone... as soon as she got it back in her hands she relaxed again...

[Web Designers & Developers] Re: Creation of own CMS

info@operacesky.net (SharkEye) — Sun, 17 Aug 2008 12:51:42 GMT

Author: SharkEye
Post subject: Re: Creation of own CMS
Posted: Sun Aug 17, 2008 12:51 pm

Give us some more info dude... is this something you have help setup? What is the aim of the site?

The desin of the site looks good at first glance... i dont have much time now so i will have a better look at work where I have tesing stuff setup...

[Web Designers & Developers] Re: Creation of own CMS

info@operacesky.net (William316) — Fri, 15 Aug 2008 18:56:34 GMT

Author: William316
Post subject: Re: Creation of own CMS
Posted: Fri Aug 15, 2008 6:56 pm

the site is live! I would appreciate an expert opinion on the new Activist Platform at http://aao.nbwd.co.uk

[Share] Star Trek

info@operacesky.net (William316) — Fri, 15 Aug 2008 13:26:18 GMT

Author: William316
Post subject: Star Trek
Posted: Fri Aug 15, 2008 1:26 pm

This is cute: http://news.zdnet.com/2424-9595_22-216370.html

[Web Designers & Developers] Re: Creation of own CMS

info@operacesky.net (Tanone) — Fri, 15 Aug 2008 11:54:16 GMT

Author: Tanone
Post subject: Re: Creation of own CMS
Posted: Fri Aug 15, 2008 11:54 am

I am fairly sure I can find a few pictures to add to the site.. I grew up in the 80's, NOT a pretty decade!!!

[Web Designers & Developers] Re: Creation of own CMS

info@operacesky.net (William316) — Fri, 15 Aug 2008 08:27:19 GMT

Author: William316
Post subject: Re: Creation of own CMS
Posted: Fri Aug 15, 2008 8:27 am

lol great - I'll look out for it:) - the soft launch has been delayed until next week, the beavering Betatesters have found lots to revise so I guess the revised code is going to take longer than expected. It is a great site though!

[Web Designers & Developers] Re: Creation of own CMS

info@operacesky.net (SharkEye) — Fri, 15 Aug 2008 08:03:42 GMT

Author: SharkEye
Post subject: Re: Creation of own CMS
Posted: Fri Aug 15, 2008 8:03 am

Should have been one 's' BUS.... big poster on the side of a bus!

[Web Designers & Developers] Re: Creation of own CMS

info@operacesky.net (William316) — Thu, 14 Aug 2008 10:30:04 GMT

Author: William316
Post subject: Re: Creation of own CMS
Posted: Thu Aug 14, 2008 10:30 am

Whats a Buss campaign?

[Web Designers & Developers] php & pdf?

info@operacesky.net (SharkEye) — Thu, 14 Aug 2008 10:29:07 GMT

Author: SharkEye
Post subject: php & pdf?
Posted: Thu Aug 14, 2008 10:29 am

Has anyone done any work with creating pfds using php?

[Web Designers & Developers] Re: Creation of own CMS

info@operacesky.net (SharkEye) — Thu, 14 Aug 2008 07:55:35 GMT

Author: SharkEye
Post subject: Re: Creation of own CMS
Posted: Thu Aug 14, 2008 7:55 am

Project going great thanks... had a bit of time on other projects recently so got to get back on it today... we just finished http://www.yakuzapic.com yesterday... its to go alongside a buss campaign starting next week...

[Web Designers & Developers] Re: Creation of own CMS

info@operacesky.net (William316) — Wed, 13 Aug 2008 22:21:02 GMT

Author: William316
Post subject: Re: Creation of own CMS
Posted: Wed Aug 13, 2008 10:21 pm

How is this project going? Although the code functions are several light years over my head I grasped some of it - I've been Betatesting a new site for Amnesty over the past few days - due for soft launch tomorrow. I won't spoil the surprise by telling you what it's called or what it does, but I will post a link as soon as it's live.

[General Chat] Re: I think Mark may have a new job..

info@operacesky.net (SharkEye) — Wed, 13 Aug 2008 12:57:12 GMT

Author: SharkEye
Post subject: Re: I think Mark may have a new job..
Posted: Wed Aug 13, 2008 12:57 pm

This is great news! Is Mark enjoying it then?

[General Chat] Re: I think Mark may have a new job..

info@operacesky.net (Tanone) — Wed, 13 Aug 2008 11:52:39 GMT

Author: Tanone
Post subject: Re: I think Mark may have a new job..
Posted: Wed Aug 13, 2008 11:52 am

So its week 3.. The routine appears to be

Monday.. Sheffield
Tuesday..Glasgow OR Cardiff on alt weeks
Wednesday.. Chester & Manchester
Thursday.. Kettering & Leicester & Nottingham
Friday.. Bradford

They pay on the 8th and he got a weeks wage on payday.. so no working a week or a month in hand..
He's doing ok and he appears to be enjoying it.. He even reckons hes losing some weight..
I drop him off in the morning and pick him up on my way home. As I work a 7am-7pm flexi system I can pretty much come and go as and when I want..Its working out ok.. Looking forward to his first full paycheck!!!!

[Technology & Gadgets] Re: iphone

info@operacesky.net (blowfish) — Tue, 12 Aug 2008 15:47:11 GMT

Author: blowfish
Post subject: Re: iphone
Posted: Tue Aug 12, 2008 3:47 pm

to be fair, there has been a bit of bickering over the iphone..."give it back" "no i'm using it" "i was using it first".

Classic. All good natured of course

[Technology & Gadgets] Re: iphone

info@operacesky.net (Richyg01) — Tue, 12 Aug 2008 13:09:57 GMT

Author: Richyg01
Post subject: Re: iphone
Posted: Tue Aug 12, 2008 1:09 pm

I aint suprised!

I wouldnt want all your sticky fingerprints all over (and I mean all over) my shiny new phone!!

[Technology & Gadgets] Re: iphone

info@operacesky.net (SharkEye) — Mon, 11 Aug 2008 14:57:40 GMT

Author: SharkEye
Post subject: Re: iphone
Posted: Mon Aug 11, 2008 2:57 pm

I am lucky if I get a look at it!

[Technology & Gadgets] Re: iphone

info@operacesky.net (Richyg01) — Mon, 11 Aug 2008 11:41:12 GMT

Author: Richyg01
Post subject: Re: iphone
Posted: Mon Aug 11, 2008 11:41 am

So you mean you have been able to keep it out of James's clutches long enough to play with it!?

[Technology & Gadgets] Re: iphone

info@operacesky.net (SharkEye) — Mon, 11 Aug 2008 07:57:43 GMT

Author: SharkEye
Post subject: Re: iphone
Posted: Mon Aug 11, 2008 7:57 am

She has!

[General Chat] Re: G'day!

info@operacesky.net (iamian) — Sat, 09 Aug 2008 21:12:31 GMT

Author: iamian
Post subject: Re: G'day!
Posted: Sat Aug 09, 2008 9:12 pm

we keep trying to stock up!!

it keeps going missing somehow tho...?

that's cool about you and Fi... i'm sure it won't be too long before we hear the pitter patter of tiny.......................

..........paws

you getting a cat or a dog or is the madness of jack all you need??

[RantEye] Re: Tax (ANGRY)

info@operacesky.net (blowfish) — Fri, 08 Aug 2008 17:28:17 GMT

Author: blowfish
Post subject: Re: Tax (ANGRY)
Posted: Fri Aug 08, 2008 5:28 pm

Paranoid Android wrote:

ergo I shouldn't get involved unless acompanied by a therapist...

I'm here Phillip...shall we begin?

[Technology & Gadgets] iphone

info@operacesky.net (blowfish) — Fri, 08 Aug 2008 17:26:41 GMT

Author: blowfish
Post subject: iphone
Posted: Fri Aug 08, 2008 5:26 pm

Oh my god, i freaking love my new iphone! seriously! I got it yesterday and have been obsessed with it ever since!

AAAAARRRRRRRGGGGGGHHHHH

[General Chat] Re: Congrats to Mr Sharkeye and Blowfish

info@operacesky.net (blowfish) — Fri, 08 Aug 2008 17:25:08 GMT

Author: blowfish
Post subject: Re: Congrats to Mr Sharkeye and Blowfish
Posted: Fri Aug 08, 2008 5:25 pm

hey, thanks tan. I would definitely like us to have a house warming party! i know james has been here for a while, but i reckon it would be ok to have a house warming now as he never had one!

[Web Designers & Developers] Re: Creation of own CMS

info@operacesky.net (SharkEye) — Fri, 08 Aug 2008 08:06:36 GMT

Author: SharkEye
Post subject: Re: Creation of own CMS
Posted: Fri Aug 08, 2008 8:06 am

Its a good start... just wanted to start to think about this sort of thing for future version of dynamic websites... just incase trafic increases on any of them... I am building a ecommerce system (basic at the moment) and I was thinking about doing this with the cateloge of products... will be in a later version

[Web Designers & Developers] Re: Creation of own CMS

info@operacesky.net (Jensen) — Fri, 08 Aug 2008 00:27:00 GMT

Author: Jensen
Post subject: Re: Creation of own CMS
Posted: Fri Aug 08, 2008 12:27 am

Well it really does depend on the site you are dealing with.

For instance, a news page. The content is updated lets say twice a day, so for every time somebody visits the news page it does a query.. this is crazy! query's that are not needed.

So what you do to get around doing a query every time is use ob_start(); and ob_end_clean();
I will give you the basics in simple steps.

Step 1.
Check if the cache fileexists in the cache folder. So our cached file for news is going to be called newspage.html. If it doesnt go to step 3

Step 2.
Use filemtime("cache/newspage.html"); to get the timestamp of when the file was last modified.. compare it to the current time and work out the difference, so if its let say older then 5 hours go to Step 3.. If its less then just include the file. If not go to step 3

Step 3.
use ob_start(); at the top of the code and ob_end_clean() at the end.
Run the query and then use $bufferContent = ob_get_contents(); and save the $bufferContent to the cache file "newspage.html"

Now if somebody would like to update, add etc then you could simply create the cache file after the new entry.. so you always have an upto date version.

This is a very basic example, it is 01:24am and I am very tired... I hope this helps or at least gives you an idea of what to do.

[Web Designers & Developers] Re: Creation of own CMS

info@operacesky.net (SharkEye) — Thu, 07 Aug 2008 21:44:18 GMT

Author: SharkEye
Post subject: Re: Creation of own CMS
Posted: Thu Aug 07, 2008 9:44 pm

Jensen wrote:TIP: Cache your content for the ultimate CMS system. You want less sql queries.

You got any further info on how is best to do this mate?

[General Chat] Re: Congrats to Mr Sharkeye and Blowfish

info@operacesky.net (SharkEye) — Thu, 07 Aug 2008 21:41:45 GMT

Author: SharkEye
Post subject: Re: Congrats to Mr Sharkeye and Blowfish
Posted: Thu Aug 07, 2008 9:41 pm

Yer might do

[General Chat] Re: adverts on sharkeye

info@operacesky.net (Paranoid Android) — Thu, 07 Aug 2008 14:29:31 GMT

Author: Paranoid Android
Post subject: Re: adverts on sharkeye
Posted: Thu Aug 07, 2008 2:29 pm

(although it does slightly piss me off that the ads open in the current SE window and not to a new one (or new tab) that i can look at after i finish on SE)

[General Chat] Re: adverts on sharkeye

info@operacesky.net (Paranoid Android) — Thu, 07 Aug 2008 14:27:29 GMT

Author: Paranoid Android
Post subject: Re: adverts on sharkeye
Posted: Thu Aug 07, 2008 2:27 pm

SharkEye wrote:The adverts will be targeted at the user... so click click click!

Hmm targeted eh?? I always get the "Do you need to start a new carreer???"

Cheers !!!

(still clicked tho)

[General Chat] Re: Congrats to Mr Sharkeye and Blowfish

info@operacesky.net (Paranoid Android) — Thu, 07 Aug 2008 14:25:29 GMT

Author: Paranoid Android
Post subject: Re: Congrats to Mr Sharkeye and Blowfish
Posted: Thu Aug 07, 2008 2:25 pm

COOOOOL

Are you gonna build your log burner so we can all stand round it.??

[General Chat] Re: Congrats to Mr Sharkeye and Blowfish

info@operacesky.net (SharkEye) — Thu, 07 Aug 2008 11:59:19 GMT

Author: SharkEye
Post subject: Re: Congrats to Mr Sharkeye and Blowfish
Posted: Thu Aug 07, 2008 11:59 am

Thanks very much... its something I have thought about and I am guessing the answer will be yes there will be one and yes you will be invited... We need to sort a load of things out first so who knows when it will be...

Thanks

[General Chat] Congrats to Mr Sharkeye and Blowfish

info@operacesky.net (Tanone) — Thu, 07 Aug 2008 11:23:13 GMT

Author: Tanone
Post subject: Congrats to Mr Sharkeye and Blowfish
Posted: Thu Aug 07, 2008 11:23 am

Congratulations,

Just read that you had moved in together thats great news

So does she get her own house warming party...??and are we all invited?

[Share] Re: Sat Nav

info@operacesky.net (Tanone) — Thu, 07 Aug 2008 11:18:43 GMT

Author: Tanone
Post subject: Re: Sat Nav
Posted: Thu Aug 07, 2008 11:18 am

stupid thing doesnt actually charge fully on the docking station...... It charges enough to use it, but doesnt get enough charge to actually link to PC.. How weird is that!!!?

[Share] Re: Sat Nav

info@operacesky.net (SharkEye) — Thu, 07 Aug 2008 07:40:24 GMT

Author: SharkEye
Post subject: Re: Sat Nav
Posted: Thu Aug 07, 2008 7:40 am

Glad you managed to get one... cannot wait for the review!

[General Chat] Re: adverts on sharkeye

info@operacesky.net (SharkEye) — Thu, 07 Aug 2008 07:39:50 GMT

Author: SharkEye
Post subject: Re: adverts on sharkeye
Posted: Thu Aug 07, 2008 7:39 am

The adverts will be targeted at the user... so click click click!

[General Chat] Re: G'day!

info@operacesky.net (SharkEye) — Thu, 07 Aug 2008 07:38:32 GMT

Author: SharkEye
Post subject: Re: G'day!
Posted: Thu Aug 07, 2008 7:38 am

Hi Ian, really good to see you back on the SEC... glad your well and having fun.

Biggest news over here (for me) is Fiona moving in! Its all gone well and we are both loving it...

When we save some money we will be sure to come over... might as well start stocking up on wine now

[General Chat] G'day!

info@operacesky.net (iamian) — Thu, 07 Aug 2008 05:47:10 GMT

Author: iamian
Post subject: G'day!
Posted: Thu Aug 07, 2008 5:47 am

Long time not see!

i hadn't put the old eye in my bookmarks for my new laptop and in the commotion managed to forget about it for a few months!!

So how is everyone? how is boro/the north east...?

Auckland is good! wine is sooooooooooooooo cheap here... i may die. haha!

when is everyone coming over to visit then???

[General Chat] Re: adverts on sharkeye

info@operacesky.net (iamian) — Thu, 07 Aug 2008 05:42:32 GMT

Author: iamian
Post subject: Re: adverts on sharkeye
Posted: Thu Aug 07, 2008 5:42 am

the adverts are for NZ stuff! how cool!

not the google adsense ones... like animation ones and everything... or is that just google 2.0?

[Share] Re: Sat Nav

info@operacesky.net (Tanone) — Wed, 06 Aug 2008 14:51:05 GMT

Author: Tanone
Post subject: Re: Sat Nav
Posted: Wed Aug 06, 2008 2:51 pm

All charged up and ready to go.... shiny shiny!!!!

[Share] Re: Sat Nav

info@operacesky.net (Paranoid Android) — Wed, 06 Aug 2008 12:04:12 GMT

Author: Paranoid Android
Post subject: Re: Sat Nav
Posted: Wed Aug 06, 2008 12:04 pm

Hurrah..!! lol good work.

[General Chat] Re: Edinburgh Fringe

info@operacesky.net (William316) — Wed, 06 Aug 2008 08:24:35 GMT

Author: William316
Post subject: Re: Edinburgh Fringe
Posted: Wed Aug 06, 2008 8:24 am

I've been at the Fringe since Sunday Evening and it has been great - one problem with today (Wednesday) it's pouring with RAIN : nnnnnooooooooooooo - this means Taxi's everywhere - I am working on two plays, one in the afternoon and one in the evening and they are a little distance apart - never mind, it is a fantastic city and just being here is experience enough

[Share] Re: Sat Nav

info@operacesky.net (Tanone) — Tue, 05 Aug 2008 20:06:50 GMT

Author: Tanone
Post subject: Re: Sat Nav
Posted: Tue Aug 05, 2008 8:06 pm

I did it, I stretched.. It will be delivered to work tomorrow so I will get to play with it for a short while before handing it over to Mark!!!