spikypunker

Hi guys, just a really simple problem, i'm bringing in a Date from a Mysql database and it's displaying as yyyy-mm-dd, i'd simply like to reverse this or maybe convert it to just "13th March" etc. Can anyone help out please!

MY GOD!! EVERYONE NEEDS TO KNOW THIS!! holy crap thats awesome lol, my webstie now rules thanks for the help!

lol! I dont know! How else would i do it? I've got a sidebar with a bunch of different <div>'s from the CSS page and then a couple of PHP sections and want to be able to change it in one place and have it go through the whole site! In the next coupla months i'm going to construct it so that the content is stored in the DB but for now, i need to instead store the sidebar and navbar in a seperate place, hence the DB! Help!

Hi guys, have just embarked on making my site all dynamic, and have had the same problem which i could foresee. I've got the navbar code all stored in the db fine, and it's bringing it in in a seperate function page and then called in the main page, this is working great. I've also got a sidebar on the page which i wanted to do the same to, so went about it in the same method. However the sidebar also had PHP code in, and this code isnt being processed, just echoed on the page! So to clarify, On the page i've got a funciton call to a seperate php page with a function called "sidebar". This is called from the page then the result ECHOED. In the sidebar function there is php code which brings in from the Mysql DB, WHERE area=sidebar, and then RETURNS the result. HOWEVER (lol) in this code which is bought in from the mysql, there is also PHP code which draws from a different mysql db. So basically i want it to process the code, bring in more code, and then process it again, which i;m guessin is the problem! Is there anyway round this? Kind Regards, Chris

Hey guys Just wanna get some thoughts on how to approach a small problem. I've developed a section on my website where i can enter gigs in an entry from and they get displayed on 5 different pages, (5 different cities) When you enter the gig or event you have to enter a date for it, this is in the standard mysql date format yyyy-mm-dd. I then display the listings in date ascending order etc. Is there a way of building a routine that deletes from the mysql db, any entires older than the current date? Either that or make it not pull entries from the db that are older than the current date. IE can the DATE fromat of a mysql db be compared to the TIME function in php? Here is the code for pulling the entries, very simple: $query = "SELECT * FROM events WHERE town='colchester' ORDER BY date ASC";

Hi there, thnks for helping. Yeah i'm using that script and also will spend some time using URLencode and will change my code so it renames the uploaded file when it saves it to the server and replaces the spaces with underscores. However i still dont get how it suddenly stopped working?? Any ideas?

arrrghh!!! i've tried everything!

i'm gonna cry!

Anyone got any idea?

If you'd like to see the page in question then please ask!

Hey guys, have asked a few questions recently and everyones been a GREEEAT help. Recently posted http://www.phpfreaks.com/forums/index.php/topic,238039.msg1108811.html#msg1108811 topic and got it all working great. HOWEVER, today i phoned up my hosters and requested the POST limit of my site to be increased to allow people to upload past the 8mb limit. The guy did this and for it to work he reset my server. All cool, the limit increased and all was good. BUT i went back to trying the force download and it's now not passing correctly to the force download. The page gets sent the value of the file for example, song.mp3 then the SAVE AS window pops up and the file is shown and the user is given the choice to save as or open with. This used to work fine but now, the SAVE AS box is only getting the filename, up to any spaces or special characters! For example, "song's.mp3" becomes song another would be "good' song.mp3" would become "good" even the dot becomes a problem for it "song.mp3" becomes "song" so windows saves the file but doesnt know what to do with it cause it doesnt save the extension!! This only happens in Firefox, not IE but it defiantly wasnt doing it before today. It's also affecting uploading of the songs, when you try and save a tracks title to the mysql, it only send the string upto any special characters!!! I've spoken to the tech guys and they dont know whats changed, does anyone have any idea?? THe advice i've been given is to make sure all URL variables are URLencoded, this is ok and i will do this, but it doesnt explain why the server would suddenly start doing this?? Nor why if i echo out the variable, i get the full string displayed on screen but when i try and force the download, the string gets cut short! ANY help would be awesome, cheers again ppl

Thats great thanks for that! All working perfectly and hopefully secure now! Cheers again php people!

Thanks very much for helping me, again have learnt the reasons behind the help, cheers guys! Concerning the validating, i have to make sure the file is an MP3? This way someone trying to hack will only be able to download the mp3s and not try and hack me by downloading the raw PHP files etc? Am i correct?

Hey guys, been researching this one and it seems to be quite contested, due to security risks? Basically i want people to click a button and it downloads an MP3 rather than having to right-click save as. First i want to get the basic workings of it going, then will see how to make it more secure.... I've found a different way to do it than the Application Force-download method and it works if done like so to test.... <?php $file = $_GET['file']; $user = $_GET['user']; header('Content-disposition: attachment; filename=Deserted.mp3'); header('Content-type: audio/mpeg'); readfile('netdog/music/Deserted.mp3'); ?> However if i try and get it to work using the Filename sent from the last page, it's doesnt convert the variable to the value, just displays the variable as the filename??? <?php $file = $_GET['file']; $user = $_GET['user']; header('Content-disposition: attachment; filename=$file'); header('Content-type: audio/mpeg'); readfile('netdog/music/$file'); ?> This is strange but as i said, it brings up the SAVE AS or OPEN WITH box but the filename in there is $file so it's not converting it into the value!!!! After i've got this working i will expand it so that it is more secure. But could someone explain the security risk? Apparantly it allows people to be able to download any file on our system?? But all the files are accessed throught the site anyway surly? But i guess they'd be able to see the PHP code in a doc thats normally converted to HTML in a browser?

hmm ok... I've found a good free player that runs usign flash and javascript http://www.schillmania.com/projects/soundmanager2/demo/template/ and this seems exactly what i need for the play bit. Now i just need to sort the download button out? I dont want to have to have a thing saying "Please right-click and save as" cause thats lame! So i just need to know the PHP function to start a download.....if there is one? Sounds like a virus risk????? hmmmmmmmm help!

hey guuyyys! Ok, have asked a few questios so far, am bulidng a small music sharing service for unsigned bands etc. I've got it all working sweet, just need to address how the mp3s are accessed. As a temp solution i simlpy have a button linking to them, this means that depending on the users setup they either are asked if they wanna download it or open with, or it opens straight with the person Quicktime etc. I'd like it so that one button automatically starts a download (or the open with/save as window) but always does this so that i can label it DOWNLOAD and it wont try and play it in Quicktime. Then i'd like to find some kind of universal solution to stream it so that there can be a second button, PLAY NOW. I'm getting more up on my Flash knowledge so could this be a good route? Just send the variable of the filename into a simple Flash movie wich then streams it? Or is there a free PHP based profgram which allows a variable to be sent into it (the filename of the track) and then plays it? Any thoughts or links to free software would make me happy! peace! Chris

haha i thought i would find this thread had exploded when i checked it in the morning! But yeah everybody thanks for disagreeing with the 'php wizz' i thought his estimation was slightly exageratted. To let you know how long it's taken me so far, i spent about a day actually designing the concept, all i got was the simple idea so had to layout exactly what it was gonna do. Then i had to spend another day, maybe more, thinking up the branding for it and doing the graphics for the layout. I've spent about 7 days on the coding so far, and am about 70% there. But yes i will be honest, i have limited knowledge of php and hadnt actually used it for over a year so a lot of time has been refreshing my memory and figuring out how to do things! But i think i'm on a good track! But thanks for putting my mind at rest slightly, i was half expecting everyone to say the same as RedArrow but not so extreme as 2 hours! Dude if you can plan, design and code that in 2 hours, have it work professionally and look really good then you're amazing, but i think you may be slightly exageratting! Thanks for the help anyway, will prob be asking another question soon so you can prove how amazing you are and help me out when i do! Peace!!!

lol dude it'd take longer than that to design just graphically, otherwise it'd look shite. But ok, so you're saying the coding, php-wise isnt that much?

hi guys bit of a different one here. Have been asking a few questions lately, all around the same build So as you can guess am working solo on a large project. My problems been that i've always been the solo person working on web design. First as a junior in a design agency that didnt have a web designer...exactly, who was i junior to? myself! So i have notihgn to compare how quickly i work. I've got a new job now, working again as sole web designer for a magazine. I've been asked my the magazine to build an extension to the website i run, to allow people to share music they have made. This involves, profile, uploading images, uploading mp3s, listing the mp3s in genres and top tens, and then editng your tracks and profile infomation. Bearing in mind that i can not use PHP to not a large degree. So far in my career i've built one simple news system, wehre they could login and enter news stories and then it'd display them as hyper links etc etc and another very simple site. How long would be reasonable time estimation? Bearing in mind that i am the only one working on it, and i have to graphical (and conceptualy) design the whole thing too. Any thoughts on this would be great! Chris

ahhhhh got it working and it GETs the variable and puts em in! Simple! Thanks guys you all ruuule p.s love you

Yeah i must admit i did read this earlier and thought it must be an old rule because i had this working on a previous prject, but you say it might have been set up on the server? On then well i have a slight follow on question, if this has to be the first thing done in the script, how on earth do i GET a url variable so that i can put this into the cookie? I'm just going to try adjusting the code so it's the first thing. brb

Hey ya, am having a wee problem setting a cookie. I'm using the exact same code as before with no joy, just getting an error saying cannot modify headers? Here is the code: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> <title>Cookie Setter</title> <?php $Month = 2592000 + time(); //this adds 30 days to the current time setcookie(AboutVisit, date("F jS - g:i a"), $Month); echo "<meta http-equiv=\"refresh\" content=\"0;URL=admin.php\">"; ?> </head> <body> </body> </html> And the error message i get is: Seems strange this is being denied when it worked before? Thanks for any help! Chris

Hey Guys, am currently developing a small user generated content site, have been helped with some things already on here in the last few days. I've got an annoying glitch thats come up during the testing phase. I've got an image uploader for the profile image and also a file uploader for uploading tracks. These are all working fine normally, and i thought i was out of the woods. But during the testing it's come apparent that for some computers neither file uploader is working! There's a bunch of tests in the PHP code, checking the file size, type etc and it's bringing up the Error message from the first check, Incorrect file type. I've come to realise that the computers that this is happening on are running XP and the ones that have worked are running Vista, anyone seen this before?? Heres the code! Also it would be sweet if i could know how to make this accept GIFS too?? <?php $user = $_GET['user']; if((!empty($_FILES["uploaded_file"])) && ($_FILES['uploaded_file']['error'] == 0)) { $filename = basename($_FILES['uploaded_file']['name']); $ext = substr($filename, strrpos($filename, '.') + 1); if (($ext == "jpg") && ($_FILES["uploaded_file"]["type"] == "image/jpeg") && ($_FILES["uploaded_file"]["size"] < 100000000)) { $newname = dirname(__FILE__).'/netdog/userpics/'.$filename; if (!file_exists($newname)) { if ((move_uploaded_file($_FILES['uploaded_file']['tmp_name'],$newname))) { mysql_connect ("localhost","maddogma_netdog","mightyb00sh"); @mysql_select_db("maddogma_netdog") or die ("unable to connect"); $query = " UPDATE USER SET image = '$filename' WHERE user='$user' "; mysql_query($query); mysql_close(); echo "<meta http-equiv=\"refresh\" content=\"0;URL=profile.php?user=$user\">"; } else { echo "Error: A problem occurred during file upload!"; } } else { echo "Error: File ".$_FILES["uploaded_file"]["name"]." already exists"; } } else { echo "Error: Only .jpg images under 350Kb are accepted for upload"; } } else { echo "Error: No file uploaded"; } ?> Peace!

haha yeah i noticed that < typo but musta not changed it! Right cool ok man, thats just made me understand that bit more haha wicked, cheers!

Is this possible?? This isn't working!! $i = 0; while ($i < $num) && ($i > '10') { $title = mysql_result($result2,$i,"title"); $image2 = mysql_result($result2,$i,"image"); echo "<a href='netdog-track.php?user=$user&title=$title'><img src='netdog/musicpics/$image2' height='80' width='80' border='0'> "; $i++; }