[Open file in folder outside web]

You could try using javascript

[First Ever Website]

For the galleries I would use lightbox to display the pictures. Drop the iframe. Right away it will look far more professional

[Chatroulette]

Have you seen this guy on Chatroulette? Funny stuff: http://www.youtube.com/user/PianoChatImprov

 

Hahaha epic!

[Open file in folder outside web]

You have to put the pdf's in your webfolder.

[Truncating text within a field]

This should do the trick

<?php echo substr($someText, 0,100).'...'; ?>

[error occured when trying to modify details]

it would help if we could see the form that submits to the given piece of code

[[5.0.77] AES_ENCRYPT / AES_DECRYPT]

Thanks alot for the reply MadTechie. I will try it out when I get back to work on monday.

 

About your question, why not using hash. I must say that in the perfect world I would do that without hesitation, but because of how the system I work on was built before I started working there, and that my boss want's to be able to return the passwords as plaintext, I'm afraid that's not an option Tried talking him into letting me rewrite the login system etc, but no luck...

 

Regards,

Shp0ngl3

[Chatroulette]

hehe i laughed at the Linux one and the online support

[Is this funny or am i just a sick little boy?]

Hahahaha... Well if you're just sick, that means I'm sick as well.. cause i found that video hillarious! But my co-worker who was eating when i brought him over to watch it just put away his lunch

[how to approve account based on customer ID]

Try something like this

 

<?php
   
$connect=mysql_connect("localhost","root","");
mysql_select_db("bank",$connect) or die ("could not select database");

   $query = "select * from customer where approved='0'";
   mysql_query($query) or die(mysql_error());
   
   $query = "UPDATE customer SET approved='1'
   WHERE approved='0'";
   $result = mysql_query($query) or die(mysql_error());

   if ($result)
   {
      echo "Details have been successfully approved";
   }

?>

[[5.0.77] AES_ENCRYPT / AES_DECRYPT]

I've been trying to get this to work now since yesterday, but with no luck.

 

I run these two queries in Navicat..

 

UPDATE tbl_members SET member_password=AES_ENCRYPT('password', '1234567890123456') WHERE member_username='rk';
SELECT * FROM tbl_members WHERE member_username='rk' AND member_password=AES_DECRYPT('password','1234567890123456');

 

When I check the member_password field (blob) I find ™Ã7Ée“ûË+{£#”U)Ã, but still the result from SELECT is empty.

 

Anyone has any ideas on how to solve this issue?

 

Regards,

Shp0ngl3

[combining <text> and <input>]

Easiest way would be jQuery. Adding the autocomplete is aprox 7-8 lines of codes for a basic one

[how to extract data from different types of tables and use to generate reports]

i think the best way would be to join the 2 tables into 1 query..

tizag.com has a well explained tutorial abou this http://www.tizag.com/mysqlTutorial/mysqljoins.php

 

Regards,

Shp0ngl3

[how to approve account based on customer ID]

make a new field named "approved" and use 0/1 to define if the user is approved or not.. 0 beeing not approved and 1 beeing approved... then you can easily do like

 

SELECT * FROM table WHERE approved=0

to list all customers that needs to be approved

[Hello from a Texan exiled to California many years ago!]

Welcome to phpfreaks

[Hello from Norway]

Yeah you really should if you like downtempo/ambient/tribe/abstract/psychedelic

[Thoughts on my website]

Really nice website. Love the minimalistic style, and ofc it was funny to see the <marquee> in use again Made me reminisce abit about the old days Also I love the music you're playing. Added it to favorites in screamer

 

Well done

[show local foler with icons]

Yes, like I said. PHP is a server side language. AJAX is the way to go to acomplish what you want to do

[show local foler with icons]

You're not able to do this with PHP alone. PHP is server side. To be able to do this you would have to use AJAX

[Help. PHP delete old files]

Not 100% sure, but I would maybe try to first store the directories into an array, with the correct path as value. Then loop through the array deleting the correct files.

 

Regards,

Shp0ngl3

[Ello from Manchester]

Hello and welcome

[Hello from Norway]

First off, thanks for the reply About the nick. Don't know if it means anything special. But I almost always listen to Shpongle when I'm working with development. Both at home and when I'm at my job Just love their music, put's me in a state of mind where I'm really able to focus over a long period of time

[Hello from Norway]

Hello everyone!

 

My name is Ole, and I'm a 26 year old guy from Norway. I currently work as a developer trainee at a company named Klopp Data - Web & Software Engineering.

 

So far I'm only self taught, but I've applied for a course at "Høgskolen i Vestfold", a college near where I live. It's a open source webdevelopment web based course which takes 5 months to complete, covering PHP, MySQL and Linux. Hopefully I get in

 

Anything you're interested in knowing? Just ask

 

Best regards,

Shp0ngl3