RE: [PHP-DB] Determine last quarter
If anyone is interested, this is what I finally came up with. I'm not sure how graceful it is, but it works ;) ? $quarter = ceil(date('n')/3); if ($quarter = 1) { $period_first_day = date(Y-m-d, mktime(0,0,0,10,1,date(Y)-1)); $period_last_day = date(Y-m-d, mktime(0,0,0,12,31,date(Y)-1)); } elseif ($quarter = 2) { $period_first_day = date(Y-m-d, mktime(0,0,0,1,1,date(Y))); $period_last_day = date(Y-m-d, mktime(0,0,0,3,31,date(Y))); } elseif ($quarter = 3) { $period_first_day = date(Y-m-d, mktime(0,0,0,4,1,date(Y))); $period_last_day = date(Y-m-d, mktime(0,0,0,6,30,date(Y))); } elseif ($quarter = 4) { $period_first_day = date(Y-m-d, mktime(0,0,0,7,1,date(Y))); $period_last_day = date(Y-m-d, mktime(0,0,0,9,30,date(Y))); } echo Start of Period: $period_first_daybr; echo End of Period: $period_last_day; ? -Original Message- From: Rankin, Randy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 19, 2002 8:57 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Determine last quarter Hello all, Does anyone know how I might determine the start date and end date of the previous calendar quarter based on today's date. For example, today is 2002-03-19, so the previous quarter start date would return 2001-10-01 and the previous quarter end date would return 2001-12-31. I am trying to determine these dates for a report that generates previous quarter sales based on today (whatever 'today' might be). Hope that's clear. Thanks in advance, Randy Rankin
[PHP-DB] oracle-mysql
hi all, i need to migrate an oracle database (+-1gb) to a mysql one, but i don't have a clue how to do this. i'm thinking in dumping the whole content of the oracle database to a txt file but i don't know if there is a better way any ideias on this one. btw the oracle machine is running on windows 2000 server and the mysql one is running on linux i don't have php on either machines but the mysql i'll have a connection to an apache running machine. the prob here is... what is the better way to migrate the data? thanx -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Copy distinct results to new table
Hi there everyone, How can I copy distinct results of a query to a table in a DB? I have 3 pulldowns, the first one selects the category, then the second one gets the holiday type based on the category, and the third one gets from countries where category = category AND holiday type = holiday type. The problem is there is almost 30,000 entries which it needs to sort through and it takes a few seconds for each pulldown to be calculated, is there a better way than the below Basically i'm guessing I can grab the results and then insert them into a seperate table so that I only save the unique results and so don't have to sort once i've created the new table? Thanks for your help everyone, Chris (For the first pulldown): form method=post action=#form1 form method=post action=#form1 div align=centerbfont face=Arial, Helvetica, sans-serif size=2 color=#FF ?$result = mysql_query(select distinct category from search ORDER BY category);? select name=category onChange=submit() ? if ($category ==){ ? optionMake a Selection/option ?} else { ? optionSelected /option ? }? ? if ($result) { while ($myrow = mysql_fetch_array($result)) { echo OPTION VALUE=\.$myrow[category].\. $myrow[category]. /OPTION; }? /select ? } ? /font/b/div /form For the second pulldown: form method=post action=#form2 div align=centerbfont face=Arial, Helvetica, sans-serif size=2 color=#FF ?$result = mysql_query(select distinct type from search WHERE category = '$category' ORDER BY type );? select name=type onChange=submit() ? if ($type ==){ ? optionMake a Selection/option ?} else { ? option Selected /option ? }? ? if ($result) { while ($myrow = mysql_fetch_array($result)) { echo OPTION VALUE=\.$myrow[type].\. $myrow[type]. /OPTION ; }? /select ? } ? input type=hidden name=category value=?=$category? /font/b/div /form For the third pulldown: form method=post action=#search div align=centerbfont face=Arial, Helvetica, sans-serif size=2 color=#FF ?$result = mysql_query(select distinct country from search WHERE category = '$category' AND type = '$type' ORDER BY country);? select name=country onChange=submit() ? if ($country ==){ ? optionMake a Selection/option ?} else { ? option Selected /option ? }? ? if ($result) { while ($myrow = mysql_fetch_array($result)) { echo OPTION VALUE=\.$myrow[country].\. $myrow[country]. /OPTION ; }? /select ? } ? input type=hidden name=type value=?=$type? input type=hidden name=category value=?=$category? /font/b/div /form
[PHP-DB] Determine last quarter
If anyone is interested, this is what I finally came up with. I'm not sure how graceful it is, but it works ;) Here's another method... which can be condensed, but I left it expanded to demonstrate what was going on. The trick is finding the first day of the *next* month, and getting the previous day ( mktime(0,0,0,$start_month+3,0,$year) ), which is always the last day of the previous month. -Hank ? $quarter = ceil(date('n')/3); $last_quarter = ($quarter==1?4:$quarter-1); $year =($last_quarter==4?date(Y)-1:date(Y)); $start_month = (($last_quarter-1)*3)+1; $end_day = date(d,mktime(0,0,0,$start_month+3,0,$year)); echo Start Date:.date(Y-m-d,mktime(0,0,0,$start_month,1,$year)).\n; echo End Date:.date(Y-m-d,mktime(0,0,0,$start_month+2,$end_day,$year)).\n; ? __ Do You Yahoo!? Yahoo! Sports - live college hoops coverage http://sports.yahoo.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] order by problem
Hello All, I´m having a 'problem' that I dont know how to resolve. The problem is: I have a table that I want to get the last number to increment. To do this I want to sort the filed 'ctrlnumber'. Using this query´s I get: mysql SELECT ctrlnumber FROM table WHERE id=14; ++ | ctrlnumber | ++ | 7 | | 1 | | 2 | | 3 | | 4 | | 5 | | 6 | | 8 | | 9 | | 10 | | 11 | ++ 11 rows in set (0.00 sec) mysql SELECT ctrlnumber FROM table WHERE id=14 order by ctrlnumber; ++ | ctrlnumber | ++ | 1 | | 10 | | 11 | | 2 | | 3 | | 4 | | 5 | | 6 | | 7 | | 8 | | 9 | ++ 11 rows in set (0.01 sec) When I try to sort, it doesn´t return to me in the order that I need (1 2 3 4 5 6 7 8 9 10 11). Is there a way to do this or I´ll have to include 01 02 03 04 05 to all my recoreds ? Thank´s in advance, Gus -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] major performance disparities with mysql/php
Hello - I'm posted this to the mysql list but got no response. While it sounds like a mysql problem, I'm convinced that it is a PHP problem (see bottom of note.) I've recently installed mySQL on a RH7.2 box without any problems - it runs great. I've been testing some long running queries (full table scans, etc) under different scenarios, and get wildy differing results. Between each test case, I was flushing all tables and re-starting the mysql deamon. When I run one of my longest queries in the mysql command line client, it runs in about 77 seconds. When I run the identical query via a simple PHP script running on the box, the same query takes about 930 seconds to complete. For the life of me, I can not figure out why the identical query would run differently from the command line than from PHP. I've repeated this test about 10 times just to be sure - and it is entirely repeatable: command line - about a minute - PHP - about 16 times longer. Any ideas or suggestions? I'm running RH 7.2 (2.4.9-21) on a Dell Poweredge 2550, 1GB memory, RAID, with mysql version 3.23.41 (the standard install unchanged from the RH media). Here is the query...pretty simple: insert into summary_table select frb, denom, series, count(*) as cnt, sum(bills) as bills, sum(bills_hit) as bills_hit, sum(total_hits) as total_hits from detail_table If it a memory/cpu resource problem, how do I set RH to give PHP and Apache the same priority as the mysql deamon? I've also written a small Perl script to execute the same queries, and that runs in 70 seconds (same as mysql client), so there must be some memory/processor limitation placed on PHP that prevents it from running as quickly as these other methods. Any ideas/suggestions? Many thanks in advance.. -Hank __ Do You Yahoo!? Yahoo! Sports - live college hoops coverage http://sports.yahoo.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] order by problem
Make CtrlNumber a numeric value instead of a string. =C= * * Cal Evans * Techno-Mage * http://www.calevans.com * - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 20, 2002 7:21 AM Subject: [PHP-DB] order by problem Hello All, I´m having a 'problem' that I dont know how to resolve. The problem is: I have a table that I want to get the last number to increment. To do this I want to sort the filed 'ctrlnumber'. Using this query´s I get: mysql SELECT ctrlnumber FROM table WHERE id=14; ++ | ctrlnumber | ++ | 7 | | 1 | | 2 | | 3 | | 4 | | 5 | | 6 | | 8 | | 9 | | 10 | | 11 | ++ 11 rows in set (0.00 sec) mysql SELECT ctrlnumber FROM table WHERE id=14 order by ctrlnumber; ++ | ctrlnumber | ++ | 1 | | 10 | | 11 | | 2 | | 3 | | 4 | | 5 | | 6 | | 7 | | 8 | | 9 | ++ 11 rows in set (0.01 sec) When I try to sort, it doesn´t return to me in the order that I need (1 2 3 4 5 6 7 8 9 10 11). Is there a way to do this or I´ll have to include 01 02 03 04 05 to all my recoreds ? Thank´s in advance, Gus -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] order by problem
On Wed, 20 Mar 2002 [EMAIL PROTECTED] wrote: You have your ctrlnumber field defined as varchar. If you define ctrlnumber as number, you could also use SELECT max(ctrlnumber) FROM table WHERE id=14; Cheers Urosh Hello All, Im having a 'problem' that I dont know how to resolve. The problem is: I have a table that I want to get the last number to increment. To do this I want to sort the filed 'ctrlnumber'. Using this querys I get: mysql SELECT ctrlnumber FROM table WHERE id=14; ++ | ctrlnumber | ++ | 7 | | 1 | | 2 | | 3 | | 4 | | 5 | | 6 | | 8 | | 9 | | 10 | | 11 | ++ 11 rows in set (0.00 sec) mysql SELECT ctrlnumber FROM table WHERE id=14 order by ctrlnumber; ++ | ctrlnumber | ++ | 1 | | 10 | | 11 | | 2 | | 3 | | 4 | | 5 | | 6 | | 7 | | 8 | | 9 | ++ 11 rows in set (0.01 sec) When I try to sort, it doesnt return to me in the order that I need (1 2 3 4 5 6 7 8 9 10 11). Is there a way to do this or Ill have to include 01 02 03 04 05 to all my recoreds ? Thanks in advance, Gus -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Copy distinct results to new table solved
Hi there everyone, Just to let you all know I solved the problem I was having earlier - it's probably not the most elegant solution but hey, it works and it's very fast so I can't complain :-) Thanks to everyone in this group for your help on everything i've asked in the past (And will probably ask in the future :-) Chris
Re: [PHP-DB] major performance disparities with mysql/php
Hank, i don´t know, but i thing the PHP have a time out for the PHP process and a time out for the MySQL connection, cause i a lot of people that don´t like to stay 70 seconds in front of computer :) probably have some way to extend the time out At 05:30 20/03/02 -0800, you wrote: Hello - I'm posted this to the mysql list but got no response. While it sounds like a mysql problem, I'm convinced that it is a PHP problem (see bottom of note.) I've recently installed mySQL on a RH7.2 box without any problems - it runs great. I've been testing some long running queries (full table scans, etc) under different scenarios, and get wildy differing results. Between each test case, I was flushing all tables and re-starting the mysql deamon. When I run one of my longest queries in the mysql command line client, it runs in about 77 seconds. When I run the identical query via a simple PHP script running on the box, the same query takes about 930 seconds to complete. For the life of me, I can not figure out why the identical query would run differently from the command line than from PHP. I've repeated this test about 10 times just to be sure - and it is entirely repeatable: command line - about a minute - PHP - about 16 times longer. Any ideas or suggestions? I'm running RH 7.2 (2.4.9-21) on a Dell Poweredge 2550, 1GB memory, RAID, with mysql version 3.23.41 (the standard install unchanged from the RH media). Here is the query...pretty simple: insert into summary_table select frb, denom, series, count(*) as cnt, sum(bills) as bills, sum(bills_hit) as bills_hit, sum(total_hits) as total_hits from detail_table If it a memory/cpu resource problem, how do I set RH to give PHP and Apache the same priority as the mysql deamon? I've also written a small Perl script to execute the same queries, and that runs in 70 seconds (same as mysql client), so there must be some memory/processor limitation placed on PHP that prevents it from running as quickly as these other methods. Any ideas/suggestions? Many thanks in advance.. -Hank __ Do You Yahoo!? Yahoo! Sports - live college hoops coverage http://sports.yahoo.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php Henrique Flach Latorre Moreno Smart Tech Consulting www.smartech.com.br Av. Rio Branco 181, 1005 Centro - Rio de Janeiro - RJ Tels : (21) 2532-6335 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: oracle-mysql
How many tables ? do you have the script that generated the oracle tables and their relationships ? what about the triggers, views, foreign keys, ... Are theses functionalities exist on MySQL (I don't know MySQL) ? You could have a look at Chyfo (http://www.ispirer.com/products/). Chyfo can export data from any database accessible through the ODBC interface. It exports data into text files (CSV, TAB delimited, fixed length, SQL INSERT statements and XML are supported formats), generates native DDL (Data Definition Language) and import/load scripts for various databases. See also Genio (http://www.hummingbird.com/products/dirs/genio/index.html), and http://www.quest.com/schema_manager/index.asp Regards, Philippe Pedro M. S. Oliveira [EMAIL PROTECTED] a écrit dans le message news: 006c01c1d009$6fd83d10$[EMAIL PROTECTED] hi all, i need to migrate an oracle database (+-1gb) to a mysql one, but i don't have a clue how to do this. i'm thinking in dumping the whole content of the oracle database to a txt file but i don't know if there is a better way any ideias on this one. btw the oracle machine is running on windows 2000 server and the mysql one is running on linux i don't have php on either machines but the mysql i'll have a connection to an apache running machine. the prob here is... what is the better way to migrate the data? thanx -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] elseif statement syntax
You probably have error reporting turned off in your php.ini file or you may be directing errors into your log file, try checking there. Why are you tacking or die(mysql_error()) on the end of each of your query assignments? You're just assigning a string to a variable so there's nothing to fail, or at least no mysql errors. -Steve On Wednesday, March 20, 2002, at 10:41 AM, Andrea Caldwell wrote: Hi All, I'm pretty new at this, so go easy on me please ;-) What is wrong w/ this syntax? If the search results are 0, it just displays a blank screen instead of echoing the error message if numresults ==0 or the mysql_error message. If data is found, everything is fine. Thanks in advance for your help! if($searchterm){ $query = select directory.realname, directory.phone, directory.ext, directory.phone2, directory.email, directory.location from directory where realname like '%.$searchterm.%' or die (mysql_error()); } elseif($location){ $query = select directory.realname, directory.phone, directory.ext, directory.phone2, directory.email, directory.location from directory where location like '%.$location.%' or die (mysql_error()); } else{ $query = select directory.realname, directory.phone, directory.ext, directory.phone2, directory.email, directory.location from directory where location like '%.$searchloc.%' or die (mysql_error()); } $result = mysql_query($query) or die (mysql_error()); $num_results = mysql_num_rows($result)or die (mysql_error());; if($num_results==0){ echo Sorry, nothing matched your search request. Please go back and try again.; } else { echo pspan class=stdtext_boldNumber of Entries Found: .$num_results./p/span; } -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] PHP4 LDAP
Not sure if this is the right list for this, but I didn't see any others on the PHP web site that made sense... I'm using the following packages: php-common-4.1.2-1mdk php-4.1.2-1mdk mod_php-4.1.2-1mdk php-ldap-4.1.2-1mdk openldap-clients-2.0.21-1.1mdk openldap-servers-2.0.21-1.1mdk openldap-2.0.21-1.1mdk libldap2-2.0.21-1.1mdk php-ldap-4.1.2-1mdk apache-modules-1.3.23-4mdk apache-common-1.3.23-4mdk apache-conf-1.3.23-3mdk apache-1.3.23-4mdk I'm trying to use my LDAP server for privilege access to certain portions of the site. I'm verifying the user's account information via LDAP and that seems to work ok, because I can bind and do a modify on the user's information. I'm updating a particular field to hold the sessionID and a time stamp. The record updates just fine, because I can do a ldapsearch from the command line on the server using the same credentials I use in PHP and I can see the update. I also have the server WIDE OPEN at the moment to test. I didn't want any stray ACL's to get in the way of debugging this. The problem arises when I try to read back all of the attributes within the PHP script. I can see only certain attributes: uid, mail, cn (the normal stuff) but if I try to read these fields that I want to use for the session, they don't print in PHP, but the show up from the LDAP command line util. The fields include: employeeNumber, carLicense, departmentNumber. Like I said earlier, I can update them from PHP, just can't read them back. Any ideas are greatly appreciated! David Christensen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] PHP Linux performance vs. PHP Windows XP performance
Hi all. Anyone have experience/comments on the general performance of PHP (and perhaps MySQL) on Linux (e.g. RH 7.2) compared to that of Windows XP using the same hardware? Thanks. David -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] elseif statement syntax
Thanks for responding Steve, My error reporting is turned on, because I always get errors. I found the problem, I had two ;; at the end of one of the statements. Thanks- Andrea -Original Message- From: Steve Cayford [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 20, 2002 10:27 AM To: Andrea Caldwell Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] elseif statement syntax You probably have error reporting turned off in your php.ini file or you may be directing errors into your log file, try checking there. Why are you tacking or die(mysql_error()) on the end of each of your query assignments? You're just assigning a string to a variable so there's nothing to fail, or at least no mysql errors. -Steve On Wednesday, March 20, 2002, at 10:41 AM, Andrea Caldwell wrote: Hi All, I'm pretty new at this, so go easy on me please ;-) What is wrong w/ this syntax? If the search results are 0, it just displays a blank screen instead of echoing the error message if numresults ==0 or the mysql_error message. If data is found, everything is fine. Thanks in advance for your help! if($searchterm){ $query = select directory.realname, directory.phone, directory.ext, directory.phone2, directory.email, directory.location from directory where realname like '%.$searchterm.%' or die (mysql_error()); } elseif($location){ $query = select directory.realname, directory.phone, directory.ext, directory.phone2, directory.email, directory.location from directory where location like '%.$location.%' or die (mysql_error()); } else{ $query = select directory.realname, directory.phone, directory.ext, directory.phone2, directory.email, directory.location from directory where location like '%.$searchloc.%' or die (mysql_error()); } $result = mysql_query($query) or die (mysql_error()); $num_results = mysql_num_rows($result)or die (mysql_error());; if($num_results==0){ echo Sorry, nothing matched your search request. Please go back and try again.; } else { echo pspan class=stdtext_boldNumber of Entries Found: .$num_results./p/span; } -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: PHP4 LDAP
Just in case anyone was wondering, here's a bit more info. I'm not sure why some attributes show up the other way though: ? $baseDN = dc=mydomain,dc=com; $bindDN = uid=dumbuser,dc=mydomain,dc=com; $bindPass = mypass; $linkID = ldap_connect(ldapServer,ldapPort); if ($linkID) if (ldap_bind($linkID,$bindDN,$bindPass) == false) DO SOME ERROR PARSING $filter = uid=dumbuser; $search = ldap_search($linkID,$baseDN,$filter); $entry = ldap_first_entry($linkID,$search); #- ALL TOO IMPORTANT LINE $values = ldap_get_values($linkID,$entry,departmentNumber); for ($i = 0; $i $values[count]; $i++) print $i . : . $values[$i] . br\n; ldap_close($linkID); ? Now (for some reason I haven't figured out yet) if you don't do the ldap_first_entry() step, you cannot access all of the attribute values returned from the $search! You can test by commenting it out and changing the $values line to use the $search value as the second arg. I hope that helps someone. I could have used it for sure. David Christensen wrote: Not sure if this is the right list for this, but I didn't see any others on the PHP web site that made sense... I'm using the following packages: php-common-4.1.2-1mdk php-4.1.2-1mdk mod_php-4.1.2-1mdk php-ldap-4.1.2-1mdk openldap-clients-2.0.21-1.1mdk openldap-servers-2.0.21-1.1mdk openldap-2.0.21-1.1mdk libldap2-2.0.21-1.1mdk php-ldap-4.1.2-1mdk apache-modules-1.3.23-4mdk apache-common-1.3.23-4mdk apache-conf-1.3.23-3mdk apache-1.3.23-4mdk I'm trying to use my LDAP server for privilege access to certain portions of the site. I'm verifying the user's account information via LDAP and that seems to work ok, because I can bind and do a modify on the user's information. I'm updating a particular field to hold the sessionID and a time stamp. The record updates just fine, because I can do a ldapsearch from the command line on the server using the same credentials I use in PHP and I can see the update. I also have the server WIDE OPEN at the moment to test. I didn't want any stray ACL's to get in the way of debugging this. The problem arises when I try to read back all of the attributes within the PHP script. I can see only certain attributes: uid, mail, cn (the normal stuff) but if I try to read these fields that I want to use for the session, they don't print in PHP, but the show up from the LDAP command line util. The fields include: employeeNumber, carLicense, departmentNumber. Like I said earlier, I can update them from PHP, just can't read them back. Any ideas are greatly appreciated! David Christensen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php