[PHP-DB] Re: Zend Optimizer for PHP on Linux
I too am looking into this though with PHP5. Does anyone have any experience of this - I am also interested in benchmark results in terms of performance improvments/hits when using the optimizer both with and without SSL based websites. Reagrds, David naren pendyal wrote: Hello, Can any one give me some tips on installing and setting up Zend Optimizerâ„¢ for PHP4 on Linux. I am currently hosting my web site http://www.bigfatprize.com on Linux Shared Hosting services. I am planning to move to my own Dedicated Linux Server. Any tips or information will be helpful Thanks In advance Naren (www.bigfatprize.com) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] PHP5 and Multiple Database Connections
Hello Everyone! I am currently writing a sequence of php pages to help me retrieve data from a Pervasive 9.5 database, display that data in my web browser with a form built in to collect more data, and then will push the retrieved Pervasive data and the input data to MySQL. I am having problems getting PHP to retrieve the data from Pervasive. I know the query is sound as I run it all the time on the Control Center, but I cannot get the ODBC connector to work in the page itself. I am also concerned that I will not be able to get the page to push the data to MySQL once I do get it to retrieve. Is this possible? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Date Translation in MySQL
I'm looking for a quick and simple way to query a MySQL database by date, or more specifically, by day of the week. My dates are stored in the DB in -MM-DD HH:MM:SS format. Question, is there a built-in for PHP or MySQL that will take this column and return only Saturdays, for example, without having to use PHP to find each of the last X number of Saturdays and then for each Saturday, query the database? In case it matters, I am running on PHP v 4.4.7 and MySQL version 4.1.22. Thanks in advance. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] PHP5 and Multiple Database Connections
Have you tested the DSN outside of PHP? Openoffice.org Database has facilities to test ODBC connections. Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com [EMAIL PROTECTED] wrote: Hello Everyone! I am currently writing a sequence of php pages to help me retrieve data from a Pervasive 9.5 database, display that data in my web browser with a form built in to collect more data, and then will push the retrieved Pervasive data and the input data to MySQL. I am having problems getting PHP to retrieve the data from Pervasive. I know the query is sound as I run it all the time on the Control Center, but I cannot get the ODBC connector to work in the page itself. I am also concerned that I will not be able to get the page to push the data to MySQL once I do get it to retrieve. Is this possible? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Date Translation in MySQL
Select * FROM ... WHERE DAYOFWEEK(datecol)=7 -Original Message- From: Ben Miller [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2008 8:10 PM To: PHP. DB Mail List Subject: [PHP-DB] Date Translation in MySQL I'm looking for a quick and simple way to query a MySQL database by date, or more specifically, by day of the week. My dates are stored in the DB in -MM-DD HH:MM:SS format. Question, is there a built-in for PHP or MySQL that will take this column and return only Saturdays, for example, without having to use PHP to find each of the last X number of Saturdays and then for each Saturday, query the database? In case it matters, I am running on PHP v 4.4.7 and MySQL version 4.1.22. Thanks in advance. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.138 / Virus Database: 270.5.12/1592 - Release Date: 05/08/2008 06:03 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] PHP5 and Multiple Database Connections
Yes I am sure the ODBC works as it is installed on my laptop and I use Excel to import many various queries of data. -- Original message -- From: Micah Gersten [EMAIL PROTECTED] Have you tested the DSN outside of PHP? Openoffice.org Database has facilities to test ODBC connections. Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com [EMAIL PROTECTED] wrote: Hello Everyone! I am currently writing a sequence of php pages to help me retrieve data from a Pervasive 9.5 database, display that data in my web browser with a form built in to collect more data, and then will push the retrieved Pervasive data and the input data to MySQL. I am having problems getting PHP to retrieve the data from Pervasive. I know the query is sound as I run it all the time on the Control Center, but I cannot get the ODBC connector to work in the page itself. I am also concerned that I will not be able to get the page to push the data to MySQL once I do get it to retrieve. Is this possible? -- 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] PHP5 and Multiple Database Connections
What does the connector return to you when you connect in PHP? Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com [EMAIL PROTECTED] wrote: Yes I am sure the ODBC works as it is installed on my laptop and I use Excel to import many various queries of data. -- Original message -- From: Micah Gersten [EMAIL PROTECTED] Have you tested the DSN outside of PHP? Openoffice.org Database has facilities to test ODBC connections. Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com [EMAIL PROTECTED] wrote: Hello Everyone! I am currently writing a sequence of php pages to help me retrieve data from a Pervasive 9.5 database, display that data in my web browser with a form built in to collect more data, and then will push the retrieved Pervasive data and the input data to MySQL. I am having problems getting PHP to retrieve the data from Pervasive. I know the query is sound as I run it all the time on the Control Center, but I cannot get the ODBC connector to work in the page itself. I am also concerned that I will not be able to get the page to push the data to MySQL once I do get it to retrieve. Is this possible? -- 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] Date Translation in MySQL
Figured there had to be an easier way. Thank you so much. -Original Message- From: Simcha Younger [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2008 2:48 PM To: php-db@lists.php.net Subject: RE: [PHP-DB] Date Translation in MySQL Select * FROM ... WHERE DAYOFWEEK(datecol)=7 -Original Message- From: Ben Miller [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2008 8:10 PM To: PHP. DB Mail List Subject: [PHP-DB] Date Translation in MySQL I'm looking for a quick and simple way to query a MySQL database by date, or more specifically, by day of the week. My dates are stored in the DB in -MM-DD HH:MM:SS format. Question, is there a built-in for PHP or MySQL that will take this column and return only Saturdays, for example, without having to use PHP to find each of the last X number of Saturdays and then for each Saturday, query the database? In case it matters, I am running on PHP v 4.4.7 and MySQL version 4.1.22. Thanks in advance. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.138 / Virus Database: 270.5.12/1592 - Release Date: 05/08/2008 06:03 -- 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] PHP5 and Multiple Database Connections
Here are the messages that are currently displayed and my current script: Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in D:\xampp\htdocs\test2.php on line 11 Warning: odbc_exec(): supplied argument is not a valid ODBC-Link resource in D:\xampp\htdocs\test2.php on line 17 Warning: odbc_result_all(): supplied argument is not a valid ODBC result resource in D:\xampp\htdocs\test2.php on line 19 Warning: odbc_close(): supplied argument is not a valid ODBC-Link resource in D:\xampp\htdocs\test2.php on line 21 // BEGIN SCRIPT // !DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Strict//EN http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd; html xmlns=http://www.w3.org/1999/xhtml; head titleToday's Customers/title meta http-equiv=content-type content=text/html; charset=iso-8859-1 / /head body ?php $conn = odbc_connect(HOMES, , ); $query = (SELECT sls_his_cust_id FROM CUST where sls_his_prchdat_alt = 20080801); $result = odbc_exec($conn, $query); odbc_result_all($result); odbc_close($conn); ? /body /html // END SCRIPT // HOMES is created on the local server as a DSN using the Pervasive ODBC connector and I know it works because I have used it with SQLyog to migrate data unto MySQL -- Original message -- From: Micah Gersten [EMAIL PROTECTED] What does the connector return to you when you connect in PHP? Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com [EMAIL PROTECTED] wrote: Yes I am sure the ODBC works as it is installed on my laptop and I use Excel to import many various queries of data. -- Original message -- From: Micah Gersten [EMAIL PROTECTED] Have you tested the DSN outside of PHP? Openoffice.org Database has facilities to test ODBC connections. Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com [EMAIL PROTECTED] wrote: Hello Everyone! I am currently writing a sequence of php pages to help me retrieve data from a Pervasive 9.5 database, display that data in my web browser with a form built in to collect more data, and then will push the retrieved Pervasive data and the input data to MySQL. I am having problems getting PHP to retrieve the data from Pervasive. I know the query is sound as I run it all the time on the Control Center, but I cannot get the ODBC connector to work in the page itself. I am also concerned that I will not be able to get the page to push the data to MySQL once I do get it to retrieve. Is this possible? -- 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 Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] PHP5 and Multiple Database Connections
Is it set up as a system DSN or User DSN. Try testing an app as the same user as the webserver and see if you can connect to the DSN. Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com [EMAIL PROTECTED] wrote: Here are the messages that are currently displayed and my current script: Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in D:\xampp\htdocs\test2.php on line 11 Warning: odbc_exec(): supplied argument is not a valid ODBC-Link resource in D:\xampp\htdocs\test2.php on line 17 Warning: odbc_result_all(): supplied argument is not a valid ODBC result resource in D:\xampp\htdocs\test2.php on line 19 Warning: odbc_close(): supplied argument is not a valid ODBC-Link resource in D:\xampp\htdocs\test2.php on line 21 // BEGIN SCRIPT // !DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Strict//EN http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd; html xmlns=http://www.w3.org/1999/xhtml; head titleToday's Customers/title meta http-equiv=content-type content=text/html; charset=iso-8859-1 / /head body ?php $conn = odbc_connect(HOMES, , ); $query = (SELECT sls_his_cust_id FROM CUST where sls_his_prchdat_alt = 20080801); $result = odbc_exec($conn, $query); odbc_result_all($result); odbc_close($conn); ? /body /html // END SCRIPT // HOMES is created on the local server as a DSN using the Pervasive ODBC connector and I know it works because I have used it with SQLyog to migrate data unto MySQL -- Original message -- From: Micah Gersten [EMAIL PROTECTED] What does the connector return to you when you connect in PHP? Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com [EMAIL PROTECTED] wrote: Yes I am sure the ODBC works as it is installed on my laptop and I use Excel to import many various queries of data. -- Original message -- From: Micah Gersten [EMAIL PROTECTED] Have you tested the DSN outside of PHP? Openoffice.org Database has facilities to test ODBC connections. Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com [EMAIL PROTECTED] wrote: Hello Everyone! I am currently writing a sequence of php pages to help me retrieve data from a Pervasive 9.5 database, display that data in my web browser with a form built in to collect more data, and then will push the retrieved Pervasive data and the input data to MySQL. I am having problems getting PHP to retrieve the data from Pervasive. I know the query is sound as I run it all the time on the Control Center, but I cannot get the ODBC connector to work in the page itself. I am also concerned that I will not be able to get the page to push the data to MySQL once I do get it to retrieve. Is this possible? -- 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 Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php