BetterPHP

I've really missed this place. I liked having a place to refresh my brain from a long day doing stuff. Looking at someone elses code for a bit really resets the mind I feel. It's also pretty rewarding knowing that you've helped someone learn. Some of the guys here ( me included ) started from scratc...

Now that Jacek is back ( Hooray! ) and the spambots are gone ( Hooray! x2 ) we actually have a second chance at making this forum decent again! I haven't really been here at all in like, a year. So I've got a lot of unread posts that I'm going through. So I've got a bit of a dilemma. Is it worth spe...

This actually seems useful, I'll definitely check it out

I'm very excited to see you back here! I was worried something had happened to you after multiple failed attempts at trying to contact you. I would be more than happy to come back to being active here now that the bot issue has been resolved. That really was the big thing that kept me from coming ba...

I need to get some serious sleep before I can make any decisions, but for now Skype seems to be the most agreed upon option.
PM me your Skype handles and I'll add you to a group conversation eventually.

There are a few things I would do differently, and some I wouldn't do at all. First of all, I would just fetch the post_date as is. It is a unix timestamp if I'm not mistaken, and those are really easy to manipulate with PHP instead of SQL. [syntax=php] function get_archive(){ $sql = "SELECT `p...

It would probably be better to think of a new name. It's best to be without those ties that could cause issues later. YouTube would be the best option to get the site recognized. A lot of people search for tutorials on there. It would not only expand the audience, it would also get the site more at...

The problem with sponsors is that they can pull the plug at any moment without prior warning. I do not want to rely on sponsors, but I would not mind a sponsor helping out. It depends on what company it is I guess. If it's all legit then I'd be happy to take his money, but if it's shady in any way I...

I would front the money for this if you truly are interested. I'm probably not gonna do it if it's only the two of us, but if we get at least 4 or 5 people with at least moderate interest I'd be more than happy to set everything up. We'd have to agree on quite a few things first though.

Oh, the spambots are not gone, I can assure you of that. I just recently banned all of them. But they'll be back.

The site looks really clean. Pretty much what I'd expect from a photography portfolio

I cannot possibly spend my time deleting over 25.000 spam posts every week, and I don't think Helx finds this very funny either. We need to move to another site or just cut our losses and realize that Jacek isn't coming back. I'd love to keep helping people with PHP, but not on this forum. It's comp...

When voting, save the users IP address along with the voting data. When the user clicks the voting button, check the users current IP with all saved IP addresses. If there is a match, don't allow the vote. I'm sorry I can't provide you with any code, but it should be pretty basic stuff - even if yo...

I really haven't done anything with that blog code you're referring to, but I know Jacek made a Database Searching tutorial using that blog as a base. m I haven't watched it in ages so I can't remember if it does exactly what you want, but it should get you on the way. I'll be available to help if y...

Have you tried yourself? This really is the easiest thing one can do in programming. It's just simple IF statements.

IF <= 40 $color = red
IF > 40 && < 60 $color = yellow
IF > 60 $color = green

Yes, the code I helped you wish only checks whether or not the person has posted in the last 24 hours or not. It does not count how many posts he's made. To do that you would have to create a new table in your database with a column that increments by 1 every time a user posts, and then resets back ...

Thanks. I won't have time to look at it in depth today but I'll have an answer for you by tomorrow.

The problem is with you using semiqoutes ( ' ) instead of backticks ( ` ) in your select statement. This [syntax=php]$result = mysql_query("SELECT 'user_id' FROM 'users' WHERE 'user_name' = '{$user_name}' AND 'user_password' = '{$user_password}' ");[/syntax] Should be this: [syntax=php]$re...

Could you export your database to an sql file and zip that up too? I need it to play around with the code.
At first glance I can't really see what's wrong. But I'll take a good look at it later tonight or tomorrow.

Hello, and welcome to the Forums! I'll do my best to walk you through this troubleshooting. Could show me the structure of your database? I haven't looked at it in quite a while so I could use a refresh on that. It also might contain a typo or an invalid datatype. Even though it does not show you an...

Just change line 5 from:
[syntax=php]if(isset($_FILES['file'])){[/syntax]

to
[syntax=php]if(isset($_FILES['file']) && !empty($_FILES['file'])){[/syntax]

it should stop the upload happening if there's no file.

You need to create a new column in your posts table where you will store a unix timestamp. When a user posts, you insert the current times into the table along with the rest of the post data. When the user wants to post again, you check the timestamp in your database in the way I showed in the previ...