php-general Digest 2 Sep 2001 01:19:48 -0000 Issue 851
Topics (messages 65598 through 65619):
loop? or conditional problem
65598 by: syaggie
FULLTEXT search sorting results
65599 by: BRACK
65617 by: Mark Maggelet
Re: The future of PHP
65600 by: Christian Reiniger
65602 by: Zeev Suraski
65603 by: Zeev Suraski
Re: formating numbers to two decimal points - money - best ways
65601 by: fx
Mdb conversion
65604 by: Rogerio Coelho - Equipeweb - CompuLand ISP
65606 by: Jeff Lewis
65607 by: Adi Wibowo
Re: Reg-Variables
65605 by: Papp Gyozo
*Great Mortgage Rates*
65608 by: turboduck.mails.ch
Re: File Upload Problem Solving?
65609 by: Marc Davenport
generate random ascii string
65610 by: bill
65611 by: Sean C. McCarthy
65612 by: Philip Olson
65613 by: bill
Re: $str[0] vs $str{0} was : generate random ascii string
65614 by: Philip Olson
65616 by: bill
Memory Usage
65615 by: Prottoss
potential preg_replace bug; unsure however
65618 by: alvarez.sto13.st-oneline.de
Re: seeking good annotate script
65619 by: Matthew A. Schneider
Administrivia:
To subscribe to the digest, e-mail:
[EMAIL PROTECTED]
To unsubscribe from the digest, e-mail:
[EMAIL PROTECTED]
To post to the list, e-mail:
[EMAIL PROTECTED]
----------------------------------------------------------------------
Okay the the script is attached below. i am baffled at the problem. as you
can see the script does a rather simplistic generation of passwords. it
then writes them into two files.
the problem is the first time i run (i am running it stand alone) it works
fine and the result is two files with 32 entries (and the mysql entries are
also correct). the second time i run it. i (there should be 44 new entries
make one file with 76 entries and another with 44)
however what i get is a file with 1233 entries and another with 1201.
now i admit the code is not beautiful but my concern is more of what is
causing this. i have checked the variables both $i and $rows appear fine.
when i look at the text files what i see is it assigns the 44 entries and
then repeats them. all i can figure is it is the conditional or whiel loop?
why does it work perfect the first time??
<?php
mysql_connect("localhost:/var/run/mysql/mysql.sock");
mysql_select_db("VQRGDATA");
$letter = array("Gob", "Lol", "woZ", "Kop", "MoS", "tRu", "SAw", "NoR",
"TEf","TaF", "JoP", "lOg", "tAn", "FiSH", "cAT", "VAn", "bAb", "Mob",
"KorN", "BeAt", "roSe", "KlaP", "iZ", "GEr", "HaT", "ZaaM", "toAd", "emU");
$results = mysql_query("SELECT members.id, members.lname FROM members, users
WHERE users.id <> members.id");
$rows= mysql_num_rows($results);
if($rows != 0)
{
while($info = mysql_fetch_array($results))
{
if($info[0] != 0)
{
$ids[] = $info[0];
$lnames[] = $info[1];
}
}
mysql_free_result($results);
$i=0;
while($i < $rows-1)
{
srand((double) microtime() * 1000000);
$pass_letter_key = array_rand($letter);
srand((double) microtime() * 1000000);
$pass_num1 = mt_rand(0, 26);
srand((double) microtime() * 1000000);
$pass_num2 = mt_rand(100, 926);
$strip = trim($lnames[$i]);
$lower = strtolower($strip);
$infochop = substr($lower, -5, 4);
$username = $infochop.$pass_num2;
$password = $pass_num1. $letter[$pass_letter_key].$pass_num2;
$respass = mysql_query("SELECT password FROM users WHERE
password='$password'");
$pass_row = mysql_num_rows($respass);
if(!$pass_row)
{
mysql_query("INSERT INTO users(id, username,password) VALUES('$ids[$i]',
'$username', '$password') ");
$complete = fopen("complete.txt", "a+");
$input[] = $ids[$i]."\t".$username."\t".$password."\n";
fputs($complete, $input[$i]);
fclose($complete);
$i++;
}
mysql_free_result($respass);
}
}
$new = implode("", $input);
$newtxt = fopen("new.txt", "w");
fputs($newtxt, $new);
fclose($newtxt);
?>
I have query -
$res = mysql_query("SELECT
skits.*,category.cat_id,category.cat_name FROM skits,category WHERE
MATCH (title,descr,skits) AGAINST ('%$search_idea%') and skits.lang
like 'English' and skits.category like category.cat_id limit $limit,10 ");
I expect to get results sorted by relevance and it actually does BUT (!)
inside of categories =( I mean it sorts result first by category and
second by relevance. How do I make it to be sorted by only relevance?
Thank you in advance,
Youri
<>< <>< <>< <>< God is our provider ><> ><> ><> ><>
http://www.body-builders.org
On Sat, 1 Sep 2001 14:01:57 +0200, BRACK ([EMAIL PROTECTED]) wrote:
>I have query -
>
>$res = mysql_query("SELECT
>skits.*,category.cat_id,category.cat_name FROM skits,category WHERE
>MATCH (title,descr,skits) AGAINST ('%$search_idea%') and skits.lang
>like 'English' and skits.category like category.cat_id limit
>$limit,10 ");
>
>I expect to get results sorted by relevance and it actually does BUT
>(!)
>inside of categories =( I mean it sorts result first by category and
>second by relevance. How do I make it to be sorted by only
relevance?
try it like this:
$res = mysql_query("SELECT
skits.*,category.cat_id,category.cat_name,MATCH (title,descr,skits)
AGAINST ('%$search_idea%') as relevance FROM skits,category WHERE
skits.lang like 'English' and skits.category like category.cat_id
having relevance>0 order by relevance desc limit $limit,10 ");
On Friday 31 August 2001 15:22, Manuel Lemos wrote:
> > I actually mention PHP-GTK in my sessions. I mention it as an
> > anecdote, much like I mention some of the other interesting modules
> > and projects in PHP (e.g., PEAR). I'm really not sure why people
> > think I'm trying to bury PHP-GTK. Just because I don't see PHP-GTK
> > as a main course of PHP, doesn't mean I don't think it's an important
> > and useful project.
>
> Oh, man, do you really do that? That is worse than not mention it at
> all. You may be joking but not everybody may understand it that way.
> Doing that you ruining the credibility of those efforts that take PHP
> far out what originally it was meant for. If you are going to just make
> it a joke, you'd better not mention it at all. I think that is
Heyheyhey, cool down. Anecdote != Joke. That's important. "Anecdote" in
this context simply means an "and by the way, there also other
interesting uses for PHP: ..."
Actually that's just what you wanted him to say :)
> > >In this company, they have choose Microsoft stuff because they think
> > > it is the right choice for what they do. For some things, PHP could
> > > be a better choice, but it would be hard to convince who is in
> > > charge above me because PHP does not benefit of a great credibility
> > > in the market that would help me to make a good case to switch to
> > > PHP.
> >
> > In the US (and perhaps in the rest of America), that's relatively
> > true. That's not the case in Europe or the far east. It has a lot
> > to do with mentality and corporate culture.
>
> So, what? Even if it is like you say, because you have this perception
> that it is not that way in Europe and far east, you are not going to do
> anything to help people living in the Americas to make a better case
> for PHP in the corporate world?
Much can be done - we all know that. But:
(1) Most of that requires either mucho $$ or heaps|truckloads|... of
time. Rasmus certainly has neither and the zend people already spend
their time doing the really important thing (improving the language).
So such marketing campaigns have to come from other people.
(2) American corporate culture (hmm, rhymes with "vulture"... :) listens
to the players with the most money. MS, Sun, Oracle, ...
So the only marketing plan that has a good chance to work is "Somehow
make about 5 billion dollars within a year and burn half of it for glossy
ads etc".
I certainly won't do this...
(3) http://php.net/usage.php
Period.
Marketing really isn't the most important thing to do :)
Conclusion:
PHP's future looks bright, everyone is working hard to make it even
brighter, and we all can dance happily around on the flowery meadows
(except when working of course :)
--
Christian Reiniger
LGDC Webmaster (http://lgdc.sunsite.dk/)
Error 032: Recursion error - see error 032
At 16:22 31-08-01, Manuel Lemos wrote:
>Oh, man, do you really do that? That is worse than not mention it at
>all. You may be joking but not everybody may understand it that way.
>Doing that you ruining the credibility of those efforts that take PHP
>far out what originally it was meant for. If you are going to just make
>it a joke, you'd better not mention it at all. I think that is extremely
>unfair for people like Andrei and other that worked so much on it! :-(
Uhm, I'm not joking. Richard pointed out to me in a personal letter that
anecdote may not be the right word here (thanks, Richard :). I mention
them (PHP-GTK, PEAR, etc) at the end of my presentations, as a list of
pointers people should look into if they have interest in that particular
subject.
Manuel, you should *REALLY* relax about this 'Zeev vs. PHP-GTK'. This is
absolutely the last time I'm going to say it - I have nothing against
PHP-GTK, and Andrei and I work very well together.
>So, what? Even if it is like you say, because you have this perception
>that it is not that way in Europe and far east, you are not going to do
>anything to help people living in the Americas to make a better case for
>PHP in the corporate world?
No, that's not what I'm saying. I'm not going to say what I was saying
again, though. Look in my old posts if you're interested...
Zeev
At 14:52 01-09-01, Christian Reiniger wrote:
>On Friday 31 August 2001 15:22, Manuel Lemos wrote:
> > > I actually mention PHP-GTK in my sessions. I mention it as an
> > > anecdote, much like I mention some of the other interesting modules
> > > and projects in PHP (e.g., PEAR). I'm really not sure why people
> > > think I'm trying to bury PHP-GTK. Just because I don't see PHP-GTK
> > > as a main course of PHP, doesn't mean I don't think it's an important
> > > and useful project.
> >
> > Oh, man, do you really do that? That is worse than not mention it at
> > all. You may be joking but not everybody may understand it that way.
> > Doing that you ruining the credibility of those efforts that take PHP
> > far out what originally it was meant for. If you are going to just make
> > it a joke, you'd better not mention it at all. I think that is
>
>Heyheyhey, cool down. Anecdote != Joke. That's important. "Anecdote" in
>this context simply means an "and by the way, there also other
>interesting uses for PHP: ..."
>Actually that's just what you wanted him to say :)
Oh, so it *was* the right word? :)
Zeev
if your datas are stored in a DB you should specify the precision of the
float in the table : float(8,2)
> Anyone have functions for formatting numbers being multiplied by variables
> and whatnot to two decimal points - rounded up? As for displaying total
> cost, etc?
> _________________________________________________________________
> Get your FREE download of MSN Explorer at http://explorer.msn.com
>
Hi, Folks !!
I am in trouble. I need to convert a mdb database to mysql.
Can PHP handle this? Where can I learn about it?
Thanks in advance.
[]�s
Rogerio Coelho.
Equipeweb - CompuLand Design
http://www.equipeweb.com.br
Tel/Fax:(xx) 24 237-2088
I needed this recently as well and found some converters right here:
http://www.mysql.com/documentation/mysql/bychapter/manual_Contrib.html#SEC60
7
They usually are run from within the MDB macros but it helped me convert my
database over :)
Jeff
----- Original Message -----
From: "Rogerio Coelho - Equipeweb - CompuLand ISP"
<[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, September 01, 2001 9:40 AM
Subject: [PHP] Mdb conversion
Hi, Folks !!
I am in trouble. I need to convert a mdb database to mysql.
Can PHP handle this? Where can I learn about it?
Thanks in advance.
[]�s
Rogerio Coelho.
Equipeweb - CompuLand Design
http://www.equipeweb.com.br
Tel/Fax:(xx) 24 237-2088
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
On Sat, 1 Sep 2001, Rogerio Coelho - Equipeweb - CompuLand ISP wrote:
> Hi, Folks !!
>
> I am in trouble. I need to convert a mdb database to mysql.
> Can PHP handle this? Where can I learn about it?
>
> Thanks in advance.
It doesn't need PHP to convert access to mysql.
Just go to mysql.com and search for convertion script (vb) to be included
into mdb and run it.
You will get two text files (consist of SQL scripts that create tables and
insert data). Use those files as scripts for mysql.
Adi Wibowo ------ http://dewey.petra.ac.id
* Work matter : [EMAIL PROTECTED]
* Private matter : [EMAIL PROTECTED]
------------------------------------------
Hi,
On Linux/Unix systems you may use Semaphore and shared memory functions.
http://www.php.net/manual/en/ref-sem.php
or simply use sessions. However, session variables are stored in flat files
or in db.
----- Original Message -----
From: senthilvellan <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, September 01, 2001 7:08 AM
Subject: [PHP] Reg-Variables
Hello Techies,
Is it possible to have our own global variables that can
be shared between more than one programs in php.Is there any other go to
share between programs(Other than flat files and database).Any help is
appreciate.
Thanks in advance,
Senthilvellan.
mnu76
Whether a new home loan is what you seek or to refinance
your current home loan at a lower interest rate, we can help!
Mortgage rates haven't been this low in the last 12 months,
take action now!
Refinance your home with us and include all of those pesky
credit card bills or use the extra cash for that pool you've
always wanted...
Where others say NO, we say YES!!!
Even if you have been turned down elsewhere, we can help!
Easy terms! Our mortgage referral service combines the
highest quality loans with the most economical rates and
the easiest qualifications!
Take just 2 minutes to complete the following form.
There is no obligation, all information is kept strictly
confidential, and you must be at least 18 years of age.
Service is available within the United States only.
This service is fast and free.
Free information request form:
PLEASE VISIT
http://www.freewebhostingcentral.com/mortgagezone
****************************************************************
Since you have received this message you have either responded
to one of our offers in the past or your address has been
registered with us. If you wish to be removed please reply to:
mailto:[EMAIL PROTECTED]?subject=remove
****************************************************************
xqw3j
*********
On Fri, 31 Aug 2001, Jeff Oien wrote:
> I have a user who is unable to upload files but I don't know where
> to start with the troubleshooting process. I have this:
>
> @copy("$img1", "/blah/$username/$img1_name")
> or die("File upload didn't work.");
>
> and they are getting the die message. All but one person are able
> to upload.
> Jeff Oien
Check the following things.
1. Permissions. The Directory of the particular user might be set
different and therefore be the reason for the upload.
2. Max File Size. I'm assuming that you are trying the same file for all
people, but if not then the one person that can upload might just be
uploading a smaller file than the rest. Just a thought.
You may want to use is_uploaded_file() and move_uploaded_file() if you are
using PHP 4.0.2 or greater.
hope this helps
cheers,
marc davenport
How can a random string of only letters and numbers be generated?
I'm stumped so far on how to avoid including symbols.
Hi,
If you have random string including symbols just take them of with
regexp. Look at the manual for regular expresion functions. Hope it
helps.
Sean C. McCarthy
SCI, s.L. (www.sci-spain.com)
bill wrote:
>
> How can a random string of only letters and numbers be generated?
>
> I'm stumped so far on how to avoid including symbols.
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
Hi Bill,
Here's a quick hack, should get you on your way :
function randomString($len)
{
global $seed;
$tmp = '';
$chars = 'abcdefghijklmnopqrstuvwxyz';
$chars .= strtoupper($chars);
$chars .= '0123456789';
if (empty($seed)) {
mt_srand ((float) microtime() * 1000000);
$seed = TRUE;
}
// weak error checking mechanism
if ($len < 1 || !is_numeric($len)) $len = 8;
$chars_len = strlen($chars);
for ($a=1; $a <= $len; $a++) {
$tmp .= $chars{mt_rand(0,$chars_len)};
}
return $tmp;
}
That was fun :)
Regards,
Philip Olson
On Sat, 1 Sep 2001, bill wrote:
> How can a random string of only letters and numbers be generated?
>
> I'm stumped so far on how to avoid including symbols.
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
Philip,
With a few tweaks, it works great, thanks!
Here's what worked:
function randomString($len)
{
global $seed;
$tmp = '';
$chars = 'abcdefghijklmnopqrstuvwxyz';
$chars .= strtoupper($chars);
$chars .= '0123456789';
if (empty($seed)) {
mt_srand ((float) microtime() * 1000000);
$seed = TRUE;
}
// weak error checking mechanism
if ($len < 1 || !intval($len)) $len = 8;
$chars_len = strlen($chars);
for ($a=1; $a <= $len; $a++) {
$tmp .= $chars[mt_rand(0,$chars_len)];
}
return $tmp;
}
Philip Olson wrote:
> Hi Bill,
>
> Here's a quick hack, should get you on your way :
>
> function randomString($len)
> {
> global $seed;
>
> $tmp = '';
>
> $chars = 'abcdefghijklmnopqrstuvwxyz';
> $chars .= strtoupper($chars);
> $chars .= '0123456789';
>
> if (empty($seed)) {
> mt_srand ((float) microtime() * 1000000);
> $seed = TRUE;
> }
>
> // weak error checking mechanism
> if ($len < 1 || !is_numeric($len)) $len = 8;
>
> $chars_len = strlen($chars);
>
> for ($a=1; $a <= $len; $a++) {
> $tmp .= $chars{mt_rand(0,$chars_len)};
> }
>
> return $tmp;
> }
>
> That was fun :)
>
> Regards,
> Philip Olson
>
> On Sat, 1 Sep 2001, bill wrote:
>
> > How can a random string of only letters and numbers be generated?
> >
> > I'm stumped so far on how to avoid including symbols.
> >
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> >
It appears the only change you made was :
> $tmp .= $chars[mt_rand(0,$chars_len)];
>From :
> > $tmp .= $chars{mt_rand(0,$chars_len)};
Which is strange. the [] use on strings has been depreciated in favor
of {} as of php4 but I don't know at what version {} came into being
exactly. What version of PHP are you running, php3? Or, does anyone know
much about this?
Anyway, glad it works :)
For informational purposes, this depreciation is stated here :
http://www.php.net/manual/en/language.types.string.php
And for those watching at home, am referring to :
$string = 'abc';
print $string[0]; // depreciated (might not work one day, when?)
vs.
print $string{0};
Both print 'a' though.
Regards,
Philip Olson
Hi Philip,
Yes, I have a choice of PHP3 or 4 and this script happened to be in PHP 3 so
I just tweaked it. I didn't realize that one day
$chars[mt_rand(0,$chars_len)] would "no longer work", but at least it is
backwards compatible now. I've made a mental note of that for future
reference.
PHP 3 also barked at
is_numeric()
which I just changed to intval()
I should really do better bounds checking. How about:
$len=intval($len);
if (!$len) $len=8;
kind regards,
bill
Philip Olson wrote:
> It appears the only change you made was :
>
> > $tmp .= $chars[mt_rand(0,$chars_len)];
>
> >From :
>
> > > $tmp .= $chars{mt_rand(0,$chars_len)};
>
> Which is strange. the [] use on strings has been depreciated in favor
> of {} as of php4 but I don't know at what version {} came into being
> exactly. What version of PHP are you running, php3? Or, does anyone know
> much about this?
>
> Anyway, glad it works :)
>
> For informational purposes, this depreciation is stated here :
>
> http://www.php.net/manual/en/language.types.string.php
>
> And for those watching at home, am referring to :
>
> $string = 'abc';
>
> print $string[0]; // depreciated (might not work one day, when?)
>
> vs.
>
> print $string{0};
>
> Both print 'a' though.
>
> Regards,
> Philip Olson
Is it possible to profile the memory usage of a php script?
I am trying to determine why do certain scripts claim to reach the 8meg
memory limit although not appear to do anything that would result in large
memory usage.
Prottoss
I built a Perl-style regex to match function calls in C-like
languages where $name is the functions name. The functions
are assumed to accept a single string as parameter.
Here it is.
/$name\s*\(\s*\"(.*)\"\s*\)\s*;/s
The expression is successfully preg_match'ed on a stream
of code, but when preg_replace is passed the same expression
it does not return. The piece of code I tested this with was
fairly small so that an increased demand of computation time
is unlikely be the reason for this behaviour.
Substituting the subexpression (.*) by ([^\"]*) remedies this.
The version of the PHP install is 4.05.
Any ideas?
D. Alvarez Arribas <[EMAIL PROTECTED]>
Daniel,
It doesn't get much easier than Philip Greenspun's "Loquacious"
(http://www.greenspun.com/com/home.html). Philip begins the description of
his free comment server thusly:
"You have a Web server with static pages. You want users to be able to
add comments dynamically to any of your pages. However, you don't
want to turn all of your Web pages into computer programs. You don't
want to sweat your way through all of Web Tools Review and
learn how to run your own Relational Database Management System-backed
Web site. You don't want to spend the rest of your life backing up
and maintaining the relational database."
Try it you'll like it. It's not PHP though (TCL likely).
Best regards,
Matthew A. Schneider
[EMAIL PROTECTED]
----- Original Message -----
From: "daniel goldin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, August 31, 2001 10:31 PM
Subject: [PHP] seeking good annotate script
>
> I'm looking for a good script that implements an
> annotation function--much like the manual at php.net. Anybody
> know where I could find such a beast?
>
>
> Daniel Goldin
> [EMAIL PROTECTED]
> 323-225-1926
>
> www.blue-lamp.com
>
>
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
