[PHP-DB] Mysql MaxDB Support?
Does PHP natively support MaxDB? I have not seen any mention of it in the manual anywhere. If not and anybody uses ODBC could you kindly post the configuration? Cheers! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Mysql MaxDB Support?
MaxDB is based on sapdb, try searching for that you probably get better results because sapdb is older that maxdb. In the near future maxdb will support the mysql protocol, so i guess you could then use the mysql functions with maxdb. - Original Message - From: Carolyn Longfoot [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 11, 2004 8:57 AM Subject: [PHP-DB] Mysql MaxDB Support? Does PHP natively support MaxDB? I have not seen any mention of it in the manual anywhere. If not and anybody uses ODBC could you kindly post the configuration? Cheers! -- 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: MySQL Backups
Jai Jones wrote: Hi Everyone. I have MySQL databases on various servers, I'd like to know how people automate backups. I imagine there would be lots of scripts and products that do this, I've tried a few, but I guess I'll have to write something myself to do it. I'd be very interested in learning from others who can share experiences/methods. Something simple is all I need :) I would ideally like to backup to a separate Linux server. All the servers are in different remote locations and bandwidth isn't an issue. Please feel free to send me your ideas or scripts off list :) Thankyou! Jai _ MSN Messenger: instale grátis e converse com seus amigos. http://messenger.msn.com.br Try the shell command mysqldump. -- paperCrane Justin Patrin -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Pulldown value not passed to next page
What is wrong with this picture? I build a pulldown for selecting page size(number of rows in one page). If page is new, it gives the default (selected) of 15. For some reason, when Previous/Next are clicked, the value passed is still 15 even though the pulldown says something else (5 or 15 or whatever). Down below my pulldown code is the code to call the Next/Previous pages (just the important part) ** Pulldown built here ** //use rcan select page size from a pulldown $myArray = array('5','10','15','20','25','30','35', '40'); $numElements = count($myArray); If(!$pagesize) { $pagesize=15; } echo SELECT SIZE=1 NAME='pagesize'; /*loop through filling pulldown*/ for($i=0;$i=$numElements;$i++){ echo OPTION VALUE=.$myArray[$i]; If($myArray[$i]==$pagesize) { echo SELECTED.$myArray[$i].\n; } Else { echo .$myArray[$i].\n; } } echo /SELECTbrbr; link when Next/Previous clicked *** else// not the last page, link to the next page echo a href=\chemlatestPAGETEST.php3?pwsno=.$pwsno.pagenum= . ($pagenum + 1).pagesize=.$pagesize. \Next/a; - Do you Yahoo!? Yahoo! Search - Find what youre looking for faster.
[PHP-DB] Impact of MySQL Queries
I have IIS 4.x and MySQL running on the same machine. So do queries use up bandwidth? Does it matter if I have 20 queries per page? Will that slow it down if many people started using my site? Currently only I, and some friends for testing, use it. -- Marcjon -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Pulldown value not passed to next page
Hi Karen, Depending upon the method used for your form, you should be able to find the value in either $_GET['pagesize'] or $_POST['pagesize']. hth, Doug Karen Resplendo wrote: What is wrong with this picture? I build a pulldown for selecting page size(number of rows in one page). If page is new, it gives the default (selected) of 15. For some reason, when Previous/Next are clicked, the value passed is still 15 even though the pulldown says something else (5 or 15 or whatever). Down below my pulldown code is the code to call the Next/Previous pages (just the important part) ** Pulldown built here ** //use rcan select page size from a pulldown $myArray = array('5','10','15','20','25','30','35', '40'); $numElements = count($myArray); If(!$pagesize) { $pagesize=15; } echo SELECT SIZE=1 NAME='pagesize'; /*loop through filling pulldown*/ for($i=0;$i=$numElements;$i++){ echo OPTION VALUE=.$myArray[$i]; If($myArray[$i]==$pagesize) { echo SELECTED.$myArray[$i].\n; } Else { echo .$myArray[$i].\n; } } echo /SELECTbrbr; link when Next/Previous clicked *** else// not the last page, link to the next page echo a href=\chemlatestPAGETEST.php3?pwsno=.$pwsno.pagenum= . ($pagenum + 1).pagesize=.$pagesize. \Next/a; - Do you Yahoo!? Yahoo! Search - Find what youre looking for faster. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Pulldown value not passed to next page
Karen, I'm assuming that when you say: For some reason, when Previous/Next are clicked, the value passed is still 15 even though the pulldown says something else (5 or 15 or whatever) you're drawing that conclusion because 15 images (or whatever) are displayed on the resulting page regardless of what you select in the pulldown. Does the actual URL say 15 or does it say something else (e.g. 20)? If the URL shows that pagesize=15, but the resulting page displays 20 images, it's possible the problem is that you're not checking the actual value passed in the URL. Your current code: If(!$pagesize) { $pagesize=15; } Should read: If(!$_GET[pagesize]){ $pagesize=15; } Else{ $pagesize = $_GET[pagesize]; } This is assuming that you have register globals turned off (I think that's right). Because, otherwise, each time the page loads with your current code, $pagesize would never be set and would always default to 15. Hope this helps. Rich -Original Message- From: Karen Resplendo [mailto:[EMAIL PROTECTED] Sent: Thursday, March 11, 2004 2:11 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Pulldown value not passed to next page What is wrong with this picture? I build a pulldown for selecting page size(number of rows in one page). If page is new, it gives the default (selected) of 15. For some reason, when Previous/Next are clicked, the value passed is still 15 even though the pulldown says something else (5 or 15 or whatever). Down below my pulldown code is the code to call the Next/Previous pages (just the important part) ** Pulldown built here ** //use rcan select page size from a pulldown $myArray = array('5','10','15','20','25','30','35', '40'); $numElements = count($myArray); If(!$pagesize) { $pagesize=15; } echo SELECT SIZE=1 NAME='pagesize'; /*loop through filling pulldown*/ for($i=0;$i=$numElements;$i++){ echo OPTION VALUE=.$myArray[$i]; If($myArray[$i]==$pagesize) { echo SELECTED.$myArray[$i].\n; } Else { echo .$myArray[$i].\n; } } echo /SELECTbrbr; link when Next/Previous clicked *** else// not the last page, link to the next page echo a href=\chemlatestPAGETEST.php3?pwsno=.$pwsno.pagenum= . ($pagenum + 1).pagesize=.$pagesize. \Next/a; - Do you Yahoo!? Yahoo! Search - Find what you're looking for faster. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Impact of MySQL Queries
Think of bandwidth as the volume of data returned by the web server to the browser, not machine cycles. MySQL will use machine cycles, but there's more to it than that. For fastest response the fields you are running the query against should be indexed. What pushes you to 20 queries per page? That seems a little excessive, as each of those is a hit to the database. Are the fields indexed? Are they cascading queries, the second depending on results returned by the first, the third upon the second, and so forth? Could you handle your returned result set by getting more data and grouping it? More information is needed to answer your question properly. Regards - Miles Thompson At 11:16 AM 3/11/2004 -0800, Marcjon Louwersheimer wrote: I have IIS 4.x and MySQL running on the same machine. So do queries use up bandwidth? Does it matter if I have 20 queries per page? Will that slow it down if many people started using my site? Currently only I, and some friends for testing, use it. -- Marcjon -- 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] Impact of MySQL Queries
If both services are running on the same machine then no, the number of queries per page will not affect bandwidth. It will however, affect you processor usage. Without having seen your code, I can only make generalizations. 20 queries is a bit excessive but it's still manageable if the server is not being hit too heavy. To answer your question directly, yes, it will start to slow down as you have more people using the system. I would suggest you consider the following. 1: Use ADODB as your abstraction layer. It has built in query caching and could dramatically improve page speed as well as lower processor usage. 2: Take a hard look at your code and make sure you actually need 20 queries on a page. Would a single query be possible and then spin through the result set? 3: Consider moving to a Linux box. (Sorry, had to be said) Without the overhead of a GUI, your processor will be more available for mysql and your web server. 4: Make sure you have the proper indexes set. If you do need 20 queries, 20 fast queries are better than 20 slow queries. :) HTH. Let me know how I may be of service, =C= * Cal Evans * http://www.eicc.com * We take care of your IT, * So you can take care of your business. * * I think inside the sphere. Marcjon Louwersheimer wrote: I have IIS 4.x and MySQL running on the same machine. So do queries use up bandwidth? Does it matter if I have 20 queries per page? Will that slow it down if many people started using my site? Currently only I, and some friends for testing, use it. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Sort Order Description
How can I have the explanation above a php table on a sort come out as something different than the sort coding? For example, the sort line below results in the following text above the sorted table: Data Set Sorted by (ssa1202.total/vapall.vapall)*100 in Descending Order. I'd prefer simply Data Set Sorted by Percent in Descending Order. I tried naming the sort field as Percent but that didn't change anything. echo tddiv align='center'font size='3'bPercenta href='ssa1202.php?sort_field=(ssa1202.total/vapall.vapall)*100sort_order=desc' target='_self'font size='2'brSort/a/b/font/div/td\n; Ken -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] ODBC support
Yes, I'm a newbie to PHP, but I got a phpBB2 BBS online in a day and I'm psyched. My problem is, the PHP docs and API mention that ODBC is built into PHP 4.x but I can't figure out how to use it. I would like to access the M$ Access JET engine directly from a PHP page. Any clues? tia, Mark -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] ODBC support
Galbreath, Mark A wrote: Yes, I'm a newbie to PHP, but I got a phpBB2 BBS online in a day and I'm psyched. My problem is, the PHP docs and API mention that ODBC is built into PHP 4.x but I can't figure out how to use it. I would like to access the M$ Access JET engine directly from a PHP page. Any clues? tia, Mark ODBC function reference is present at http://pt.php.net/manual/en/ref.odbc.php (you can choose a closer mirror if you want). Scroll down to the bottom of the page to look at the functions list and some immediate examples. Re-post if you need further information. Bruno Ferreira --- [This E-mail scanned for viruses by Declude Virus] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] ODBC support
Take a look at ADODB (It's a good database library that supports a variety of systems): http://php.weblogs.com/ADODB Here's a quick intro: http://www.databasejournal.com/features/php/article.php/651 -Original Message- From: Galbreath, Mark A [mailto:[EMAIL PROTECTED] Sent: Thursday, March 11, 2004 2:04 PM To: '[EMAIL PROTECTED]' Subject: [PHP-DB] ODBC support Yes, I'm a newbie to PHP, but I got a phpBB2 BBS online in a day and I'm psyched. My problem is, the PHP docs and API mention that ODBC is built into PHP 4.x but I can't figure out how to use it. I would like to access the M$ Access JET engine directly from a PHP page. Any clues? tia, Mark -- 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: Sort Order Description
[EMAIL PROTECTED] wrote in news:[EMAIL PROTECTED]: How can I have the explanation above a php table on a sort come out as something different than the sort coding? For example, the sort line below results in the following text above the sorted table: Data Set Sorted by (ssa1202.total/vapall.vapall)*100 in Descending Order. I'd prefer simply Data Set Sorted by Percent in Descending Order. I tried naming the sort field as Percent but that didn't change anything. echo tddiv align='center'font size='3'bPercenta href='ssa1202.php?sort_field=(ssa1202.total/vapall.vapall)*100sort_ord er=desc' target='_self'font size='2'brSort/a/b/font/div/td\n; Ken Without seeing the code that produces the text above the table, its a bit hard to give any suggestions. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: Sort Order Description
I'm not clear on your question. The code I quoted, set forth below, has the text that ends up above the table. The following introduces the series of column headings with sort statements (of which the initial code is one): # write out title if ($sort_order == asc) {$sort_title = Ascending;} else {$sort_title = Descending;} echo pbData Set Sorted By $sort_field in $sort_title Order/b/p\n; # write out table heading echo table width='75%' border='1' cellspacing='0' cellpadding='0' align='center' bgcolor='#99'\n; echo tr\n; The following is at the beginning of the script: # get sort order (if any) passed to script $sort_field = $_REQUEST['sort_field']; if (! $sort_field) {$sort_field = (ssa1202.total/vapall.vapall)*100;} $sort_order = $_REQUEST['sort_order']; if (! $sort_order) {$sort_order = desc;} Thanks. On 12 Mar 2004 00:12:41 -, David Robley [EMAIL PROTECTED] wrote: [EMAIL PROTECTED] wrote in news:[EMAIL PROTECTED]: How can I have the explanation above a php table on a sort come out as something different than the sort coding? For example, the sort line below results in the following text above the sorted table: Data Set Sorted by (ssa1202.total/vapall.vapall)*100 in Descending Order. I'd prefer simply Data Set Sorted by Percent in Descending Order. I tried naming the sort field as Percent but that didn't change anything. echo tddiv align='center'font size='3'bPercenta href='ssa1202.php?sort_field=(ssa1202.total/vapall.vapall)*100sort_ord er=desc' target='_self'font size='2'brSort/a/b/font/div/td\n; Ken Without seeing the code that produces the text above the table, its a bit hard to give any suggestions. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: Sort Order Description
[EMAIL PROTECTED] wrote: [snip...] The following is at the beginning of the script: # get sort order (if any) passed to script $sort_field = $_REQUEST['sort_field']; if (! $sort_field) {$sort_field = (ssa1202.total/vapall.vapall)*100;} $sort_order = $_REQUEST['sort_order']; if (! $sort_order) {$sort_order = desc;} First things first. That code (it seems to me) is vulnerable to SQL injection. Better fix that first... Bruno Ferreira --- [This E-mail scanned for viruses by Declude Virus] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] BLOB
Hi all, how do i find out if a BLOB field in my table is NULL? i tried: SELECT * FROM `MEMBER` WHERE `PASSWD` is NULL however, although there is one entry in my table that has nothing in my PASSWD field, the result set is empty.. how come? how do i search for entries that has password = [BLOB - 0 bytes] ?? thanx so much!! huihui