Re: [PHP-DB] Re: PLS Advise, Highlighted Text from a Query
thanks so much for your help , but would help me more to implement the example : $query = open source world, open mind for all; $text = open; . . $count = 0; $keywords = (split $query into array of whole words); for (each word in $query) { $n = (number of times $word found in $text); $count += (length of $word) * (1 + strength($n)); } $score = ($count + $count) / (length of $query + length of $text ); $score = curve($score); Nabil Mikon Dosogne [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] [...] what about the percentage how much accurate the result returned?? I'm not sure what kind of keywords or text you're searching, but here's the algorithm i used a while back, for plain-text search: given: $query $text /* curve() maps values between 0 and 1 to.. a curve: 0% - 0% 25% - 43% 50% - 75% 75% - 93% 100% - 100% */ function curve($x){ $x = 1 - $x; $x = $x * $x; return 1 - $x; } /* given a number between 0 and +INFINITY, strength returns a value between 0 and 1 (0% and 100%) the higher $n is, the closer to 1 the result. 0 - 0% 6 - 85.7% 1 - 50% 7 - 87.5% 2 - 66.6% 8 - 88.8% 3 - 75% 9 - 90% 4 - 80% 19 - 95% 5 - 83.3% 100 - 99% */ function strength($x){ return ($x / ($x + 1)) } $count = 0 $keywords = (split $query into array of whole words) for (each word in $query) { $n = (number of times $word found in $text); // add the size of $word to $count, or more depending on $n $count += (length of $word) * (1 + strength($n)); } $score = ($count + $count) / (length of $query + length of $text ); $score = curve($score); // repeat a few times if needed, to get decent scores and there you have it. - mikon -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] MySQL editor
Hi all. I need to get a program (interface) for MySQL, I was using MySQL Front but they've discontinued its use. Any suggestions. thanx in advance -Angelo
Re: [PHP-DB] MySQL editor
MySQL CONTROL CENTER from mysql.org (very nice) SQLYOG from sqlyog.com PHPMYADMIN from phpmyadmin.net (web interface) - Original Message - From: Angelo Zanetti [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 19, 2003 11:40 AM Subject: [PHP-DB] MySQL editor Hi all. I need to get a program (interface) for MySQL, I was using MySQL Front but they've discontinued its use. Any suggestions. thanx in advance -Angelo -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] MySQL editor
Try also DBTools (forWindows). Very nice. Been using for 2 years, and happy about it. http://www.dbtools.com.br/EN/ Ignatius _ - Original Message - From: Achilles Maroulis [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 19, 2003 10:46 AM Subject: Re: [PHP-DB] MySQL editor MySQL CONTROL CENTER from mysql.org (very nice) SQLYOG from sqlyog.com PHPMYADMIN from phpmyadmin.net (web interface) - Original Message - From: Angelo Zanetti [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 19, 2003 11:40 AM Subject: [PHP-DB] MySQL editor Hi all. I need to get a program (interface) for MySQL, I was using MySQL Front but they've discontinued its use. Any suggestions. thanx in advance -Angelo -- 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: Lastest versionof PHP
I would like to install php-4.3.2 on a RHL7.3 server. Is there a rpm for RH servers? Alsoshould I upgrade RHL to 8 or stay with 7.3. The only other app on the server is: MySQL-Max-4.0.13-0 MySQL-server-4.0.13-0 MySQL-devel-4.0.13-0 MySQL-client-4.0.13-0 I believe there is a newer version of this also. Jon L. Miller, MCNE, CNS Director/Sr Systems Consultant MMT Networks Pty Ltd http://www.mmtnetworks.com.au I don't know the key to success, but the key to failure is trying to please everybody. -Bill Cosby -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] MySQL editor
Next time ask on the MySQL list! Navicat Mascon PHPMyAdmin (for web interface) SQLYog MyCC (from www.mysql.com) The first two are very professional programs that offer a lot of features including Reports and Query wizards. Similar to using Access on Windows (interface wise), but without the crashing and slow speed (database wise)!! What's wrong with continuing to use MySQL Front? I do. It's still my favorite. ---John Holmes... - Original Message - From: Angelo Zanetti [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 19, 2003 4:40 AM Subject: [PHP-DB] MySQL editor Hi all. I need to get a program (interface) for MySQL, I was using MySQL Front but they've discontinued its use. Any suggestions. thanx in advance -Angelo -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: order by an average in another table (basicallya top 10 list)
chris wrote: I managed to figure it out on my own. For those curious, here's a starting point: SELECT parent_id, avg(rating) as average FROM ratings WHERE average IS NOT NULL GROUP BY parent_id ORDER BY average DESC, parent_id DESC It works in MySQL 3.x, but not certain about PostgreSQL. The not null check was necessary in my select statement, possibly due to the multiple joins I'm doing (I ended up with the oldest unrated picture at the top, then the top 9, instead of 10; the not null check eliminates this). It's probably because NULLs are always on bottom (and on top if you use DESC). -- Milan Babuskov http://fbexport.sourceforge.net http://njam.sourceforge.net -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] MySQL editor
Not free, but mysqlmanager (www.ems-hitech.com) is by far the best I've used. A free alternative (although not quite as featured) is probably Mysqlcc -Mike - Original Message - From: Angelo Zanetti [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 19, 2003 4:40 AM Subject: [PHP-DB] MySQL editor Hi all. I need to get a program (interface) for MySQL, I was using MySQL Front but they've discontinued its use. Any suggestions. thanx in advance -Angelo -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: order by an average in another table (basically a top 10 list)
what version of postgres, newer ones handle null values slightly differently in queries, although there is a setting you can switch to make it work like the older versions. -mike - Original Message - From: Milan Babuskov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 19, 2003 10:10 AM Subject: Re: [PHP-DB] Re: order by an average in another table (basically a top 10 list) chris wrote: I managed to figure it out on my own. For those curious, here's a starting point: SELECT parent_id, avg(rating) as average FROM ratings WHERE average IS NOT NULL GROUP BY parent_id ORDER BY average DESC, parent_id DESC It works in MySQL 3.x, but not certain about PostgreSQL. The not null check was necessary in my select statement, possibly due to the multiple joins I'm doing (I ended up with the oldest unrated picture at the top, then the top 9, instead of 10; the not null check eliminates this). It's probably because NULLs are always on bottom (and on top if you use DESC). -- Milan Babuskov http://fbexport.sourceforge.net http://njam.sourceforge.net -- 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] MySQL editor
Hello, Not really the same purpose, but so powerfull :) http://www.fabforce.net/dbdesigner4/ pierre -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] mysql Editor
A free alternative that works very well is sqlyog. Google it as I don't have the url handy (it may be www.webyog.com or .org). I also use MySQL Front as it still works fine. But I'm switching over to sqlyog because I want to ensure that I am compatible with future releases of MySQL. Michael Lewis -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] mysql Editor
DBTools - www.dbtools.com.br ___ Ryan Marrs Web Developer Sandler Travis Trade Advisory Services, Inc. 248.474.7200 x 183 248.474.8500 (fax) www.strtrade.com -Original Message- From: Michael Lewis [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 10:48 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] mysql Editor A free alternative that works very well is sqlyog. Google it as I don't have the url handy (it may be www.webyog.com or .org). I also use MySQL Front as it still works fine. But I'm switching over to sqlyog because I want to ensure that I am compatible with future releases of MySQL. Michael Lewis -- 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] MySQL editor
mysqlmanager (www.ems-hitech.com) is by far the best I've used. They've changed the name to Navicat now. It really is fantastic software. Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: Michael Scappa [EMAIL PROTECTED] To: Angelo Zanetti [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, 19 June, 2003 10:33 Subject: Re: [PHP-DB] MySQL editor Not free, but mysqlmanager (www.ems-hitech.com) is by far the best I've used. A free alternative (although not quite as featured) is probably Mysqlcc -Mike - Original Message - From: Angelo Zanetti [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 19, 2003 4:40 AM Subject: [PHP-DB] MySQL editor Hi all. I need to get a program (interface) for MySQL, I was using MySQL Front but they've discontinued its use. Any suggestions. thanx in advance -Angelo -- 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] Fw: php-db Digest 17 Jun 2003 06:02:39 -0000 Issue 1886
The digest files are coming as attachments Attachmnts are very light (just 900 bytes or some 2 or 4 Kb. This one carries a whooping 46 KB. Any added spyware or so ? Thanks Raf - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 3:02 AM Subject: php-db Digest 17 Jun 2003 06:02:39 - Issue 1886 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] MySQL editor
Sorry, I mistyped. Navicat was previously known as MySQL Studio. Both are very nice packages. Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: Becoming Digital [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, 19 June, 2003 11:02 Subject: Re: [PHP-DB] MySQL editor mysqlmanager (www.ems-hitech.com) is by far the best I've used. They've changed the name to Navicat now. It really is fantastic software. Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: Michael Scappa [EMAIL PROTECTED] To: Angelo Zanetti [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, 19 June, 2003 10:33 Subject: Re: [PHP-DB] MySQL editor Not free, but mysqlmanager (www.ems-hitech.com) is by far the best I've used. A free alternative (although not quite as featured) is probably Mysqlcc -Mike - Original Message - From: Angelo Zanetti [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 19, 2003 4:40 AM Subject: [PHP-DB] MySQL editor Hi all. I need to get a program (interface) for MySQL, I was using MySQL Front but they've discontinued its use. Any suggestions. thanx in advance -Angelo -- 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] MySQL editor
SQL4x Manager is great, too, but it only runs on the mac platform http://www.macosguru.de/products/sql4xmanager on 19/6/03 5:34 PM, Becoming Digital at [EMAIL PROTECTED] wrote: Sorry, I mistyped. Navicat was previously known as MySQL Studio. Both are very nice packages. Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: Becoming Digital [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, 19 June, 2003 11:02 Subject: Re: [PHP-DB] MySQL editor mysqlmanager (www.ems-hitech.com) is by far the best I've used. They've changed the name to Navicat now. It really is fantastic software. Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: Michael Scappa [EMAIL PROTECTED] To: Angelo Zanetti [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, 19 June, 2003 10:33 Subject: Re: [PHP-DB] MySQL editor Not free, but mysqlmanager (www.ems-hitech.com) is by far the best I've used. A free alternative (although not quite as featured) is probably Mysqlcc -Mike - Original Message - From: Angelo Zanetti [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 19, 2003 4:40 AM Subject: [PHP-DB] MySQL editor Hi all. I need to get a program (interface) for MySQL, I was using MySQL Front but they've discontinued its use. Any suggestions. thanx in advance -Angelo -- 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] Fw: php-db Digest 17 Jun 2003 06:02:39 -0000 Issue 1886
Any added spyware or so ? I believe someone sent a few attachments to the list. Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, 19 June, 2003 12:35 Subject: [PHP-DB] Fw: php-db Digest 17 Jun 2003 06:02:39 - Issue 1886 The digest files are coming as attachments Attachmnts are very light (just 900 bytes or some 2 or 4 Kb. This one carries a whooping 46 KB. Any added spyware or so ? Thanks Raf - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 3:02 AM Subject: php-db Digest 17 Jun 2003 06:02:39 - Issue 1886 -- 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] MySQL editor
With the exception of phpmyadmin is there anything else out there that will allow you to work on your mysql stuff remotely? Tim Winters Manager, Creative Development Sampling Technologies Incorporated (STI) [EMAIL PROTECTED] [EMAIL PROTECTED] W: 902 450 5500 C: 902 430 8498 -Original Message- From: Achilles Maroulis [mailto:[EMAIL PROTECTED] Sent: June 19, 2003 5:46 AM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] MySQL editor MySQL CONTROL CENTER from mysql.org (very nice) SQLYOG from sqlyog.com PHPMYADMIN from phpmyadmin.net (web interface) - Original Message - From: Angelo Zanetti [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 19, 2003 11:40 AM Subject: [PHP-DB] MySQL editor Hi all. I need to get a program (interface) for MySQL, I was using MySQL Front but they've discontinued its use. Any suggestions. thanx in advance -Angelo -- 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] MySQL editor
Thus, the website to find Navicat is http://www.mysqlstudio.com. --Dave Shugarts Sorry, I mistyped. Navicat was previously known as MySQL Studio. Both are very nice packages. Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: Becoming Digital [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, 19 June, 2003 11:02 Subject: Re: [PHP-DB] MySQL editor mysqlmanager (www.ems-hitech.com) is by far the best I've used. They've changed the name to Navicat now. It really is fantastic software. Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: Michael Scappa [EMAIL PROTECTED] To: Angelo Zanetti [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, 19 June, 2003 10:33 Subject: Re: [PHP-DB] MySQL editor Not free, but mysqlmanager (www.ems-hitech.com) is by far the best I've used. A free alternative (although not quite as featured) is probably Mysqlcc -Mike - Original Message - From: Angelo Zanetti [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 19, 2003 4:40 AM Subject: [PHP-DB] MySQL editor Hi all. I need to get a program (interface) for MySQL, I was using MySQL Front but they've discontinued its use. Any suggestions. thanx in advance -Angelo -- 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] MySQL editor
On Friday 20 June 2003 01:11, Creative Solutions New Media wrote: With the exception of phpmyadmin is there anything else out there that will allow you to work on your mysql stuff remotely? They should all allow you to access a remote installation of mysql. Now can we please move this topic to the mysql list where it belongs? -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-db -- /* Everything should be built top-down, except this time. */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] MySQL editor
With the exception of phpmyadmin is there anything else out there that will allow you to work on your mysql stuff remotely? Any of the programs will. The real questions whether you have permission to connect remotely, though... :) ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Problems with formvalues by using Suse 8.2
Hi, under using Suse 8.2 I've the problem that the values of formfields will be put out or worked withit within a phpscript. The testscript with phpinfo() is working fine. What have I to set (in the php.ini) that php is handling the formfieldvalues properly? Regards, Ruprecht -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Problems with formvalues by using Suse 8.2
under using Suse 8.2 I've the problem that the values of formfields will be put out or worked withit within a phpscript. The testscript with phpinfo() is working fine. What have I to set (in the php.ini) that php is handling the formfieldvalues properly? I really have no idea what you just said, but I'm guessing your problem is with register_globals defaulting to OFF instead of ON in php.ini. ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] trouble: joining more than 2 tables
Hello, I am having a little trouble with joining more that two tables. I can join two tables but once I start to add more tables to the WHERE clause only two records show up. I am still pretty new to MySQL, but I am learing. I am just stuck on this one in hopes someone will show me the light. I tried reading the manual and used there samples but this is as far as I got and seems to work but only some what. Here is my query I am trying to use in DreamweaverMX (this one pulls up only 2 records, I have seven records for test purpose): -SELECT instockID, instock.materialCode, instock.treatmentCode, instock.bulkCode, instock.shapeCode, instock.calibrate, instock.price, -material.materialName, material.sDiscription, material.matImage1, -shape.shapeName, bulk.bulkName, treatment.treatmentName - -FROM instock, material, shape, bulk, treatment - -WHERE instock.materialCode = 'colname' AND -instock.shapeCode = shape.shapeCode AND -instock.bulkCode = bulk.bulkCode AND -instock.treatmentCode = treatment.treatmentCode AND -instock.materialCode = material.materialCode - -ORDER BY instock.shapeCode ASC This one I can pull all seven records but I need more information from the other tables that is related to the instock table. -SELECT instock.instockID, instock.materialCode, instock.treatmentCode, instock.bulkCode, instock.shapeCode, instock.calibrate, instock.price, -material.materialName, material.sDiscription, material.matImage1 - -FROM instock, material - -WHERE instock.materialCode = 'colname' AND -instock.materialCode = material.materialCode AND -instock.shapeCode = shape.shapeCode - -ORDER BY instock.shapeCode ASC Could someone help me and show me an other way in writting the top queries. Thanks, David -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Problems with formvalues by using Suse 8.2
Hi Am Donnerstag, 19. Juni 2003 20:07 schrieb Ruprecht Helms: Hi, under using Suse 8.2 I've the problem that the values of formfields will be put out or worked withit within a phpscript. The testscript with phpinfo() is working fine. What have I to set (in the php.ini) that php is handling the formfieldvalues properly? Seems to be a little bit OT here. Your question is not very precise, but I'll give it a try. Depending on your form-method, you can request the values by accessing either $_GET['formfieldname'] or $_POST['formfieldname'] where formfieldname has to be replaced by the real names of the fields. Hope that's it. CU Thorsten -- Thorsten Körner http://www.123tkShop.org -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Problems with formvalues by using Suse 8.2
To protect yourself by keeping register_globals off but still have access to your GET and POST info, do the following: snip foreach($_POST as $key=$value) { $$key = $value; } // Now all the post vars are in their corresponding key names // You can do the same with $_GET vars /snip Using the $$key assigns whatever $key is to a variable with that value, e.g. $key = sid; $value = W; So: $$key = $value; will make the following true: $sid == W; It's a pretty good way of re-doing pages that were written with register_globals=on to run with register_globals=off Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 Pay It Forward mailto:[EMAIL PROTECTED] http://accessingram.com -Original Message- From: Thorsten Körner [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 2:05 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Problems with formvalues by using Suse 8.2 Hi Am Donnerstag, 19. Juni 2003 20:07 schrieb Ruprecht Helms: Hi, under using Suse 8.2 I've the problem that the values of formfields will be put out or worked withit within a phpscript. The testscript with phpinfo() is working fine. What have I to set (in the php.ini) that php is handling the formfieldvalues properly? Seems to be a little bit OT here. Your question is not very precise, but I'll give it a try. Depending on your form-method, you can request the values by accessing either $_GET['formfieldname'] or $_POST['formfieldname'] where formfieldname has to be replaced by the real names of the fields. Hope that's it. CU Thorsten -- Thorsten Körner http://www.123tkShop.org -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] actualy result of problem with formfieldvalues under Suse 8.2
Hi, in the meantime I set the value of register_globals = off the next to on. I get the same result. The following script I use for testing the formfieldvalues ? echo $begriff ? The value I take from a normal formfield by the default transfermethod. After switching to the php-script I get a blank page without the value I inserted into the textfield. Regards, Ruprecht -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] actualy result of problem with formfieldvalues under Suse 8.2
Hi Am Donnerstag, 19. Juni 2003 23:21 schrieb Ruprecht Helms: Hi, in the meantime I set the value of register_globals = off the next to on. I get the same result. The following script I use for testing the formfieldvalues ? echo $begriff ? As I said before, this the wrong way. You should leave register_globals=off and acces your data this way: ?php echo $_POST['begriff']; ? Your second mistake was to forget the ; and the end of the echo-line The value I take from a normal formfield by the default transfermethod. What the heck do you mean with default. You should always set: form action=\foo.php?op=bar\ method=\POST\ or mybe with method=\GET\ and access it with $_GET After switching to the php-script I get a blank page without the value I inserted into the textfield. No wonder;-) CU Thorsten -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Two-column display of data, second method
When I went looking for a script that would give me a two-column layout that would list my faculty members in two roughly equal columns, alphabetized down the first column and then the second, I did not find such a script. [There was indeed a two-column script, but it fed the data row-by-row.] I wrote this one and am glad to share it. The math statements could surely be condensed, but I was using them to confirm the results. This script either creates two equal columns if the total number of items is even, or it makes the first column the longer if the total number of items is odd. --Dave Shugarts ?php /* *** Now selects the Faculty names ** */ $sql =SELECT FirstName, Middle, LastName FROM $table_name ORDER BY LastName, FirstName; /* ** Now passes the result of the search ** */ $faculty_result = @mysql_query($sql, $connection) or die(Error #. mysql_errno() . : . mysql_error()); $faculty_found = @mysql_num_rows($faculty_result); $faculty_half = $faculty_found / 2; $faculty_round = round($faculty_found / 2); $faculty_remain = $faculty_found - $faculty_round; echo table border=0 trtd colspan=2 align=centerb Two-Column header /bbr/td/tr trtd width=49%\n; for ($rownum = 1; $rownum = $faculty_round; $rownum++) { $row = mysql_fetch_array($faculty_result); $FirstName=$row['FirstName']; $Middle=$row['Middle']; $LastName=$row['LastName']; $faculty_block = font class=facultydoc $FirstName $Middle $LastName /font br ; echo $faculty_blockbr; } echo /tdtd\n; for ($rownum = 1; $rownum = $faculty_remain; $rownum++) { $row = mysql_fetch_array($faculty_result); $FirstName=$row['FirstName']; $Middle=$row['Middle']; $LastName=$row['LastName']; $faculty_block = font class=facultydoc $FirstName $Middle $LastName /font br ; echo $faculty_blockbr; } echo /td/trbr/table; ? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] actualy result of problem with formfieldvalues underSuse 8.2
On Thu, 2003-06-19 at 23:30, Thorsten Körner wrote: Hi Am Donnerstag, 19. Juni 2003 23:21 schrieb Ruprecht Helms: Hi, in the meantime I set the value of register_globals = off the next to on. I get the same result. The following script I use for testing the formfieldvalues ? echo $begriff ? As I said before, this the wrong way. You should leave register_globals=off and acces your data this way: ?php echo $_POST['begriff']; ? Ok here the copy of my script in original ? echo $begriff; ? That is all Your second mistake was to forget the ; and the end of the echo-line ?php echo $_POST['begriff']; ? Your second mistake was to forget the ; and the end of the echo-line The value I take from a normal formfield by the default transfermethod. What the heck do you mean with default. You should always set: html head title/title meta http-equiv=Content-Type content=text/html; charset=ISO-8859-15 meta name=GENERATOR content=Quanta Plus /head body form action=formtest.php method=POST input type=text name=begriffbr input type=submit value=senden /form /body /html After switching to the php-script I get a blank page without the value I inserted into the textfield. This problem I have first by upgrading to 8.2. Attached my php.ini Regards, Ruprecht [PHP] ;;; ; WARNING ; ;;; ; This is the default settings file for new PHP installations. ; By default, PHP installs itself with a configuration suitable for ; development purposes, and *NOT* for production purposes. ; For several security-oriented considerations that should be taken ; before going online with your site, please consult php.ini-recommended ; and http://php.net/manual/en/security.php. ;;; ; About this file ; ;;; ; This file controls many aspects of PHP's behavior. In order for PHP to ; read it, it must be named 'php.ini'. PHP looks for it in the current ; working directory, in the path designated by the environment variable ; PHPRC, and in the path that was defined in compile time (in that order). ; Under Windows, the compile-time path is the Windows directory. The ; path in which the php.ini file is looked for can be overridden using ; the -c argument in command line mode. ; ; The syntax of the file is extremely simple. Whitespace and Lines ; beginning with a semicolon are silently ignored (as you probably guessed). ; Section headers (e.g. [Foo]) are also silently ignored, even though ; they might mean something in the future. ; ; Directives are specified using the following syntax: ; directive = value ; Directive names are *case sensitive* - foo=bar is different from FOO=bar. ; ; The value can be a string, a number, a PHP constant (e.g. E_ALL or M_PI), one ; of the INI constants (On, Off, True, False, Yes, No and None) or an expression ; (e.g. E_ALL ~E_NOTICE), or a quoted string (foo). ; ; Expressions in the INI file are limited to bitwise operators and parentheses: ; |bitwise OR ; bitwise AND ; ~bitwise NOT ; !boolean NOT ; ; Boolean flags can be turned on using the values 1, On, True or Yes. ; They can be turned off using the values 0, Off, False or No. ; ; An empty string can be denoted by simply not writing anything after the equal ; sign, or by using the None keyword: ; ; foo = ; sets foo to an empty string ; foo = none; sets foo to an empty string ; foo = none ; sets foo to the string 'none' ; ; If you use constants in your value, and these constants belong to a ; dynamically loaded extension (either a PHP extension or a Zend extension), ; you may only use these constants *after* the line that loads the extension. ; ; All the values in the php.ini-dist file correspond to the builtin ; defaults (that is, if no php.ini is used, or if you delete these lines, ; the builtin defaults will be identical). ; Language Options ; ; Enable the PHP scripting language engine under Apache. engine = On ; Allow the ? tag. Otherwise, only ?php and script tags are recognized. ; NOTE: Using short tags should be avoided when developing applications or ; libraries that are meant for redistribution, or deployment on PHP ; servers which are not under your control, because short tags may not ; be supported on the target server. For portable, redistributable code, ; be sure not to use short tags. short_open_tag = On ; Allow ASP-style % % tags. asp_tags = Off ; The number of significant digits displayed in floating point numbers. precision= 12 ; Enforce year 2000 compliance (will cause problems with non-compliant browsers) y2k_compliance = On ; Output buffering allows you to send header lines (including cookies) even ; after you send body content, at the price of slowing PHP's output layer a ; bit. You can enable output buffering during runtime by calling the output ; buffering functions. You
Re: [PHP-DB] actualy result of problem with formfieldvalues under Suse 8.2
HI Am Donnerstag, 19. Juni 2003 23:54 schrieb Ruprecht Helms: On Thu, 2003-06-19 at 23:30, Thorsten Körner wrote: Hi Am Donnerstag, 19. Juni 2003 23:21 schrieb Ruprecht Helms: Hi, in the meantime I set the value of register_globals = off the next to on. I get the same result. The following script I use for testing the formfieldvalues ? echo $begriff ? As I said before, this the wrong way. You should leave register_globals=off and acces your data this way: ?php echo $_POST['begriff']; ? Ok here the copy of my script in original ? echo $begriff; ? That is all Your second mistake was to forget the ; and the end of the echo-line ?php echo $_POST['begriff']; ? Your second mistake was to forget the ; and the end of the echo-line The value I take from a normal formfield by the default transfermethod. What the heck do you mean with default. You should always set: html head title/title meta http-equiv=Content-Type content=text/html; charset=ISO-8859-15 meta name=GENERATOR content=Quanta Plus /head body form action=formtest.php method=POST ^ Your Form-Method is POST input type=text name=begriffbr ^^^ this is the name of your Formfield. input type=submit value=senden /form /body /html PHP gives all form-data in an array to th script. With method=POST this array is named $_POST You can now access this data in your script the following way: ?php echo $_POST['begriff']; ? You can see the arrays $_GET, $_POST, $_COOKIE and so on as associative arrays with the fieldnames as indizes. After switching to the php-script I get a blank page without the value I inserted into the textfield. This problem I have first by upgrading to 8.2. Attached my php.ini This should be OK. CU Thorsten -- Thorsten Körner http://www.123tkShop.org -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Renaming all pages to .php
I joined this list a few weeks ago because I wanted to learn about php. Unfortunately, I still haven't found time to study it in any depth. Thus, my question might be a bit amateurish, but it's fairly urgent, so I'd appreciate any feedback anyone cares to offer. I'm working on a new website that I need to get online by the end of this month. I had wanted to do some stuff with php on it, but there's no way I can learn php and apply it before the July 1 deadline. No problem - I'll just add the php later. The catch is that my pages will be registered in search engines with URLs ending in .htm, something I'll have to address when I switch to php. Then I saw a discussion on another forum about a guy who was planning on changing all the .htm extensions on his webpages to .php, whether those pages use php or not. The general consensus was that that the pages would work just fine even without php, and they'd be all set up if and when he got around to adding php. I'd like to get some feedback from this forum. Do you agree that a page without php functions or server side includes can be put online with either a .htm or .php function? If I never add a php function to a page with a .php extension, could that cause some kind of problems? Also, I'm thinking of naming all my pages index and sticking them inside folders. That way, visitors can reach a page by typing in www.geobop.com/birds/ , whether the full URL is www.geobop.com/birds/index.htm or www.geobop.com/birds/index.php Is this a good plan, or do you see any problems? Thanks! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Renaming all pages to .php
I'd like to get some feedback from this forum. Do you agree that a page without php functions or server side includes can be put online with either a .htm or .php function? If I never add a php function to a page with a .php extension, could that cause some kind of problems? it won't cause any problems. you'll have the very small overhead of having to run every static page through php's parser, but if you're going to have php in these pages in the future it doesn't really matter. Also, I'm thinking of naming all my pages index and sticking them inside folders. That way, visitors can reach a page by typing in www.geobop.com/birds/ , whether the full URL is www.geobop.com/birds/index.htm or www.geobop.com/birds/index.php Is this a good plan, or do you see any problems? again, no problems. just make sure your web server is setup to search for index.php as a directory index page. -j. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Renaming all pages to .php
You can easily add the .php extension to any .htm(l) page that you have with no worries as long as you have PHP installed and configured properly. The only problem is that page load will be SLIGHTLY slower since PHP will search all .php pages for PHP code to evaluate. Upon finding none, it will simply return the HTML to the requester. But note that this is a tiny bit longer than your web server just serving the page without passing it through PHP. Naming all files index.XXX will be a good idea. Though realize that some people might link directly to the file itself (which can sometimes become visible with different browsers and different activities). But none-the-less, it will work for most users if they do decide to bookmark the folder. -M -Original Message- From: David Blomstrom [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 10:14 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Renaming all pages to .php I'd like to get some feedback from this forum. Do you agree that a page without php functions or server side includes can be put online with either a .htm or .php function? If I never add a php function to a page with a .php extension, could that cause some kind of problems? Also, I'm thinking of naming all my pages index and sticking them inside folders. That way, visitors can reach a page by typing in www.geobop.com/birds/ , whether the full URL is www.geobop.com/birds/index.htm or www.geobop.com/birds/index.php Is this a good plan, or do you see any problems? Thanks! -- 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] Renaming all pages to .php
At 09:16 PM 6/19/2003 -0500, Joshua Stein wrote: it won't cause any problems. you'll have the very small overhead of having to run every static page through php's parser, but if you're going to have php in these pages in the future it doesn't really matter. Also, I'm thinking of naming all my pages index and sticking them inside folders. again, no problems. just make sure your web server is setup to search for index.php as a directory index page. I don't know exactly what you mean, but I just renamed one of my pages (using Dreamweaver) with a .php extension, previewed it in Mozilla, and it worked fine. This is the address displayed in the browser: file:///C:/sites/geosymbols/birds.php However, when I pasted the URL into Internet Explorer. So I linked to the page from page X, previewed page X in IE and clicked the link and was taken to C:\sites\geosymbols\waldman.php That's weird. I never even realized my two browsers displayed localhost links differently - file:///c versus C:, and forward slashes versus back slashes. But I assume that means my server is set up properly. As long as I can preview my pages, I can't complain! * * * * * * * * * * Doug Thompson: You or your company better get busy and hire a competent programmer to complete your project in the alloted time; or you might consider posting to a list of a more general nature and see if anyone there wants to do your work for no pay. So you're saying I should get php installed and running on my pages before I change the extensions? I wouldn't ask anyone to my work for no pay; I have more than 300 pages on my site, and it's a fairly complex project. * * * * * * * * * * Mike Brum: You can easily add the .php extension to any .htm(l) page that you have with no worries as long as you have PHP installed and configured properly. The only problem is that page load will be SLIGHTLY slower since PHP will search all .php pages for PHP code to evaluate. Upon finding none, it will simply return the HTML to the requester. But note that this is a tiny bit longer than your web server just serving the page without passing it through PHP. Naming all files index.XXX will be a good idea. Though realize that some people might link directly to the file itself (which can sometimes become visible with different browsers and different activities). But none-the-less, it will work for most users if they do decide to bookmark the folder. Alright, it sounds like a go. Thanks for all the tips. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php