Amen to that. Even though I

IO.Relentless — Sun, 26 Oct 2008 15:01:08 +0000

Amen to that.

Even though I may not be coding with the latests technology or OO PHP I am still enjoying the learning experience. I am trying to concentrate on security, I am attempting to incorporate login attempt logs so each user can see if anyone has been trying to login with their account, which I believe will not only benefit the users but me the administrator as well. I am looking for the best way to change passwords and such too, maybe the password should just be sent to the registered e-mail in plain text, or should it be re-set? And if the re-set option is chosen then maybe it should only be allowed within a time limit and on the same IP address. For example a user clicks "Reset Pass" a reset email is then sent to the registered email address saying you have 1 hour to click this link, using this IP address. But I believe this could cause many problems. What do you all think? Know of any interesting articles related to this?

Thanks all again,
Relentless.

Not a problem. Good luck

pr0gr4mm3r — Sun, 26 Oct 2008 03:03:48 +0000

Not a problem. Good luck with your web application. I find coding PHP sites from scratch quite enjoyable as well as a valuable learning experience.

Excellent, thanks again I

IO.Relentless — Sun, 26 Oct 2008 00:31:05 +0000

Excellent, thanks again

I will have a look at a way to implement this, need to do some googeling

Just finished the Article comment system

Relentless.

Glad to help . Well...you

pr0gr4mm3r — Sun, 26 Oct 2008 00:23:11 +0000

Glad to help .

Well...you are going have to store more information about the page view if you are going to tell the difference between a unique hit and a repeat hit.

One option is to map their IP addresses. This is the easiest method to implement, but it has faults. If a page gets attention on a large campus or company network, your statistics won't show it because it all comes from the same IP.

The other option is to set a cookie on the user's computer. This takes a bit more code, and it won't work if the visitor doesn't accept cookies, but most do these days, and I think that would be the better option. All you would have to do is store a value in a cookie that you would check for to determine if it's a repeat visit or not.

Sorted thank you! The only

IO.Relentless — Sat, 25 Oct 2008 23:20:02 +0000

Sorted thank you!

The only problem now is, every time the page refresh it classes it as a new read :S

Any thoughts on a way to implement a better system?

Thank you all sooooooooooo much!

Relentless.

Looks like your problem is

pr0gr4mm3r — Sat, 25 Oct 2008 23:00:15 +0000

Looks like your problem is that you are using a reserved word in your query as a column name, in this case "reads". You can do that, but you need to use the backquotes (`) around that column name, so your query would look like this:

UPDATE articles SET `reads` = '46' WHERE id = '3'

Thanks, I have heard of the

IO.Relentless — Sat, 25 Oct 2008 21:10:13 +0000

Thanks, I have heard of the model view controller approach before. unfortunately, I don't have that much spare time on my hands at the moment, so diving head first into OO PHP is not my best option, I will continue building my site old school for now while learning about OO PHP, and we will see that happens

I am having some problems with this bit of code!

if($_SESSION['username'] != $v_author) {
$update_reads = $v_reads + 1;
$rq = "UPDATE articles SET reads='$update_reads' WHERE id='$v_id'";
$rr = mysql_query($rq, $conn) or die("Could not update reads, Error: " . mysql_error());
}

I get the following error:

Could not update reads, Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'reads='46' WHERE id='3'' at line 1

The values are correct, it just seems that mysql_query() does not like something xD any ideas?

Thank you all again,
Relentless.

OO programming in my opinion

pr0gr4mm3r — Sat, 25 Oct 2008 19:42:21 +0000

OO programming in my opinion is way better and much more organized. You may also want to look into the MVC approach. I always follow both of these techniques for my PHP applications, and it makes them much more manageable.

Great, thank you for the tip

IO.Relentless — Sat, 25 Oct 2008 16:24:50 +0000

Great, thank you for the tip

At the moment I am looking at recoding the whole site! because I have been looking at OO PHP. What are your views on this? I have done OOP in C# so have most of the methodology down. Just need to time to learn the implementation.

Cheers,
Relentless.

Agreed with pr0gr4mm3r here,

JeevesBond — Wed, 22 Oct 2008 23:41:37 +0000

Agreed with pr0gr4mm3r here, most 'online' indicators just show whether the user has viewed a page within the last 15 minutes.