[PHP] checkdate function

checkdate function verifies whether the date is valid or not by taking month, day and year as arguments. The problem is when someone enters a three digit year by mistake (200 instead of 2003), this function does not catch it. We are separating the year part from the string and validating sep

[PHP] Auto escalation

Dear All, I'm new to the list. I'm intended to use the auto escalation functionality in my current project which is related to helpdesk. Can you please give me some suggestions about how to develop this. I'm using PHP, MySQL -- Thanks & Regards Praveen SoftPro Systems Ltd, Plot #12, Software

RE: [PHP] excel 2 csv 2 mysql

ok i've built a class to acomplish this now class Export_Excel { var $command function Export_Excel() { $this->command = "/www_tools/apache/catdoc/bin/xls2csv"; } function xls2csv($path,$xls_file,$short_name) { $cmd = escapeshellcmd(

Re: [PHP] global var.

On Tuesday 01 April 2003 11:59, Sebastian wrote: > Hmm, interesting.. i dunno why it doesn't work for me, here is a bit of the > code, $var isn't getting the output of $id, any ideas? Are you sure that $id contains what you think it contains? Also could you explain the reason why your code is lai

[PHP] Re: [Newbie] Password()

Hello First of all NO there is no way of reversing the MySQL password function since it is a hash not an encryption. I think the real problem lies in your concern for security. Why hash the password or encrypt it in a database when you are sending it over the internet per email? A better way

Re: [PHP] Re: XML+XSLT or Smarty again??

Hello Ok can't refrain from giving my opinion to this one. First of all I think separating presentation from business logic can be achived fairly simple with SMARTY and if your template code acutally contains business logic than you have not understood the concept of the template engine. The

[PHP] date() and mktime() functions: weeknumbers and months.

Hi people, I would like to select news from my database bases on week/year and month/year. How can i do this.. I would like to pass two arguments in the query string, like news.php?week=14&year=2003 or news.php?month=3&year=2003. Can anybody help me.. Thanks in advance. I have been looking at the

Re: [PHP] date() and mktime() functions: weeknumbers and months.

Check out mysql manual, section 6.3.4 - Date and Time Functions, example $condition=''; if($GET['week']) $condition .= "WEEK(date)='$_GET[week]' AND "; if($GET['year']) $condition .= "YEAR(date)='$_GET[week]' AND "; and so on then use the condition: $sql = "SELECT * FROM news WHERE $condition 1";

<    1   2