Re: [PHP-DB] Random pick
Hello List, Trying to learn the right way to code this line. Can anyone tell me if I am doing this the right way? if $req_user_level == 0 || 1 || 2 || 3 || 4 || 5 || 6 || 7 || 8 || 9 ? Guest || Regular User || Intl. User || Contractor || Employee || Sales || Investor || Human Resources || Administrator; I am wanting to stray from the if(foo == bar) { routine. ;) Thanks, Karl DeSaulniers Design Drumm http://designdrumm.com
Re: [PHP-DB] Random pick
Hi, did you mean something like this? $level_names = array(Guest, Regular User, Intl. User, Contractor, Employee, Sales, Investor, Human Resources, Administrator); $user_level = $level_names[$req_user_level]; Regards, Olavi Ivask On Jan 25, 2010, at 9:13 PM, Karl DeSaulniers wrote: Hello List, Trying to learn the right way to code this line. Can anyone tell me if I am doing this the right way? if $req_user_level == 0 || 1 || 2 || 3 || 4 || 5 || 6 || 7 || 8 || 9 ? Guest || Regular User || Intl. User || Contractor || Employee || Sales || Investor || Human Resources || Administrator; I am wanting to stray from the if(foo == bar) { routine. ;) Thanks, Karl DeSaulniers Design Drumm http://designdrumm.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Random pick
On Mon, 25 Jan 2010, Karl DeSaulniers wrote: Hello List, Trying to learn the right way to code this line. Can anyone tell me if I am doing this the right way? if $req_user_level == 0 || 1 || 2 || 3 || 4 || 5 || 6 || 7 || 8 || 9 ? Guest || Regular User || Intl. User || Contractor || Employee || Sales || Investor || Human Resources || Administrator; I am wanting to stray from the if(foo == bar) { routine. ;) if (in_array($req_user_level, array(0,1,2,3,4,5,6,7,8,9,Guest,...))) { // do stuff } --- Peter Beckman Internet Guy beck...@angryox.com http://www.angryox.com/ --- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Random pick
Hi, $req_user_level is a MySql return result and I am trying to utilize shortened code to evaluate whither $req_user_level == 0 || 1 || 2 || 3 || 4 || 5 || 6 || 7 || 8 || 9, if it matches a number, return the text associated with that number. Guest || Regular User || Intl. User || Contractor || Employee || Sales || Investor || Human Resources || Administrator; Karl On Jan 25, 2010, at 1:31 PM, Olavi Ivask wrote: Hi, did you mean something like this? $level_names = array(Guest, Regular User, Intl. User, Contractor, Employee, Sales, Investor, Human Resources, Administrator); $user_level = $level_names[$req_user_level]; Regards, Olavi Ivask On Jan 25, 2010, at 9:13 PM, Karl DeSaulniers wrote: Hello List, Trying to learn the right way to code this line. Can anyone tell me if I am doing this the right way? if $req_user_level == 0 || 1 || 2 || 3 || 4 || 5 || 6 || 7 || 8 || 9 ? Guest || Regular User || Intl. User || Contractor || Employee || Sales || Investor || Human Resources || Administrator; I am wanting to stray from the if(foo == bar) { routine. ;) Thanks, Karl DeSaulniers Design Drumm http://designdrumm.com Karl DeSaulniers Design Drumm http://designdrumm.com
Re: [PHP-DB] Random pick
I am trying to avoid doing this: if ($req_user_level == 0) { $req_user_level = Guest; } else if ($req_user_level == 1) { req_user_level = Regular User } etc.. Karl DeSaulniers Design Drumm http://designdrumm.com
Re: [PHP-DB] Random pick
Don't you like my solution? Regards, Olavi On Jan 25, 2010, at 9:39 PM, Karl DeSaulniers wrote: Hi, $req_user_level is a MySql return result and I am trying to utilize shortened code to evaluate whither $req_user_level == 0 || 1 || 2 || 3 || 4 || 5 || 6 || 7 || 8 || 9, if it matches a number, return the text associated with that number. Guest || Regular User || Intl. User || Contractor || Employee || Sales || Investor || Human Resources || Administrator; Karl On Jan 25, 2010, at 1:31 PM, Olavi Ivask wrote: Hi, did you mean something like this? $level_names = array(Guest, Regular User, Intl. User, Contractor, Employee, Sales, Investor, Human Resources, Administrator); $user_level = $level_names[$req_user_level]; Regards, Olavi Ivask On Jan 25, 2010, at 9:13 PM, Karl DeSaulniers wrote: Hello List, Trying to learn the right way to code this line. Can anyone tell me if I am doing this the right way? if $req_user_level == 0 || 1 || 2 || 3 || 4 || 5 || 6 || 7 || 8 || 9 ? Guest || Regular User || Intl. User || Contractor || Employee || Sales || Investor || Human Resources || Administrator; I am wanting to stray from the if(foo == bar) { routine. ;) Thanks, Karl DeSaulniers Design Drumm http://designdrumm.com Karl DeSaulniers Design Drumm http://designdrumm.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Random pick
Thank you for this as well. Question? What part is in_array playing? Is it comparing $req_user_level to array()? Because the text Guest, etc.. is not in $req_user_level on the database. In other words, is it checking the value of $req_user_level to see if Guest is in it? Karl On Jan 25, 2010, at 1:32 PM, Peter Beckman wrote: On Mon, 25 Jan 2010, Karl DeSaulniers wrote: Hello List, Trying to learn the right way to code this line. Can anyone tell me if I am doing this the right way? if $req_user_level == 0 || 1 || 2 || 3 || 4 || 5 || 6 || 7 || 8 || 9 ? Guest || Regular User || Intl. User || Contractor || Employee || Sales || Investor || Human Resources || Administrator; I am wanting to stray from the if(foo == bar) { routine. ;) if (in_array($req_user_level, array (0,1,2,3,4,5,6,7,8,9,Guest,...))) { // do stuff } -- - Peter Beckman Internet Guy beck...@angryox.com http:// www.angryox.com/ -- - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php Karl DeSaulniers Design Drumm http://designdrumm.com
Re: [PHP-DB] Random pick
On Mon, 25 Jan 2010, Karl DeSaulniers wrote: Thank you for this as well. Question? What part is in_array playing? Is it comparing $req_user_level to array()? Because the text Guest, etc.. is not in $req_user_level on the database. In other words, is it checking the value of $req_user_level to see if Guest is in it? Sorry, I missed the question mark. in_array isn't appropriate here. The previous poster has it right, assuming $req_user_level is an integer of 0..9. $levels = array(Guest, Regular User, 'Intl. User', ...) // the array is 0, 1, 2 , ...) Going a little further: if (!empty($levels[$req_user_level])) { // is both set and doesn't evaluate to false echo The user is a {$levels[$req_user_level]}.\n; } else { // The $req_user_level was not a valid level. echo The returned req_user_level was not valid.\n; } Which would output, if $req_user_level was 1 (one): The user is a Regular User. Then you know you have a valid user level. Careful though -- sometimes 0 will be returned on a failure, depending on your SQL. Beckman --- Peter Beckman Internet Guy beck...@angryox.com http://www.angryox.com/ --- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Random pick
Yes, $req_user_level is an int between 0 and 9. Yes, the other code worked great. Thank you for your response though. That is definitely a good way to cross check. Thanks again for your responses. Best, Karl On Jan 25, 2010, at 2:24 PM, Peter Beckman wrote: On Mon, 25 Jan 2010, Karl DeSaulniers wrote: Thank you for this as well. Question? What part is in_array playing? Is it comparing $req_user_level to array()? Because the text Guest, etc.. is not in $req_user_level on the database. In other words, is it checking the value of $req_user_level to see if Guest is in it? Sorry, I missed the question mark. in_array isn't appropriate here. The previous poster has it right, assuming $req_user_level is an integer of 0..9. $levels = array(Guest, Regular User, 'Intl. User', ...) // the array is 0, 1, 2 , ...) Going a little further: if (!empty($levels[$req_user_level])) { // is both set and doesn't evaluate to false echo The user is a {$levels[$req_user_level]}.\n; } else { // The $req_user_level was not a valid level. echo The returned req_user_level was not valid.\n; } Which would output, if $req_user_level was 1 (one): The user is a Regular User. Then you know you have a valid user level. Careful though -- sometimes 0 will be returned on a failure, depending on your SQL. Beckman -- - Peter Beckman Internet Guy beck...@angryox.com http:// www.angryox.com/ -- - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php Karl DeSaulniers Design Drumm http://designdrumm.com
Re: [PHP-DB] Random pick
On Saturday 19 December 2009 03:54:34 Karl DeSaulniers wrote: Dont know if you found anything, but I ran accross this in on of my other searches. http://php.about.com/od/finishedphp1/p/day_redirect.htm Karl On Dec 18, 2009, at 10:10 AM, Philip Thompson wrote: On Dec 15, 2009, at 6:02 PM, David McGlone wrote: On Monday 14 December 2009 21:44:24 Chris wrote: Chris wrote: David McGlone wrote: On Monday 14 December 2009 21:02:37 Chris wrote: David McGlone wrote: Hi everyone, I've been lurking in the shadows on the list for quite some time and now I'm in need of a little info or advise. Thanks everyone. I tried everybody's suggestions and I learned a lot. Someone else also suggested using a cron job to run the rand script at certain intervals and insert the result into another table. This also works. I probably could've used javascript, which was my initial reaction, but I'm trying to learn PHP/MYSQL and adding java to the mix, would only add to the confusion. -- Blessings David M. I have been driven to my knees many times by the overwhelming conviction that I had nowhere else to go. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Random pick
Dont know if you found anything, but I ran accross this in on of my other searches. http://php.about.com/od/finishedphp1/p/day_redirect.htm Karl On Dec 18, 2009, at 10:10 AM, Philip Thompson wrote: On Dec 15, 2009, at 6:02 PM, David McGlone wrote: On Monday 14 December 2009 21:44:24 Chris wrote: Chris wrote: David McGlone wrote: On Monday 14 December 2009 21:02:37 Chris wrote: David McGlone wrote: Hi everyone, I've been lurking in the shadows on the list for quite some time and now I'm in need of a little info or advise. I'm looking for a way to grab a record out of a database on a certain day each month and I'm wondering if this can be accomplished with just a mysql query or would I need to use PHP also? A mysql query would do it but you'd use something to talk to mysql and process the results (whether it's php, perl, python, ruby etc depends on your other requirements). What I'm trying to do is to have a record picked from the database at random on the 1st of every month and display it on the page. Here is some code I have been working with: $query = SELECT DATEADD(mm, DATEDIFF(mm,0,getdate()), 0); $result = @mysql_query($query); if (!$result){ $query = SELECT * FROM monthlyPooch ORDER BY RAND() LIMIT 1; $result = @mysql_query($query); while ($row = mysql_fetch_array($result)){ echo $row[poochName] ; echo $row[Birthdate]; } } You can check the day of the month in php then do your other query: $today = date('j'); See http://php.net/date for date formats and what they return. if ($today !== 1) { echo Today isn't the first. No need to continue.\n; exit; } .. random query etc here. Hmmm. This isn't exactly what I'm looking for. What I'm trying to do is get a new picture on the 1st of every month and display it for that whole month. Could you not just create a mysql table that contains the month and a url to a file? ?php // image.php $currentMonth = date('n'); $sql = SELECT `image_location` FROM `monthly_images` WHERE `month` = $currentMonth LIMIT 1; $result = mysql_query($sql); list ($loc) = mysql_result ($result); header (Content-type: image/png); readfile ($loc); exit; ? And then in your HTML: img src=image.php alt=MonthlyImage title=Yay for me! / I just wrote that code here in the email, but it should get you going in the right direction. Hope that helps! ~Philip -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php Karl DeSaulniers Design Drumm http://designdrumm.com
Re: [PHP-DB] Random pick
On Dec 15, 2009, at 6:02 PM, David McGlone wrote: On Monday 14 December 2009 21:44:24 Chris wrote: Chris wrote: David McGlone wrote: On Monday 14 December 2009 21:02:37 Chris wrote: David McGlone wrote: Hi everyone, I've been lurking in the shadows on the list for quite some time and now I'm in need of a little info or advise. I'm looking for a way to grab a record out of a database on a certain day each month and I'm wondering if this can be accomplished with just a mysql query or would I need to use PHP also? A mysql query would do it but you'd use something to talk to mysql and process the results (whether it's php, perl, python, ruby etc depends on your other requirements). What I'm trying to do is to have a record picked from the database at random on the 1st of every month and display it on the page. Here is some code I have been working with: $query = SELECT DATEADD(mm, DATEDIFF(mm,0,getdate()), 0); $result = @mysql_query($query); if (!$result){ $query = SELECT * FROM monthlyPooch ORDER BY RAND() LIMIT 1; $result = @mysql_query($query); while ($row = mysql_fetch_array($result)){ echo $row[poochName] ; echo $row[Birthdate]; } } You can check the day of the month in php then do your other query: $today = date('j'); See http://php.net/date for date formats and what they return. if ($today !== 1) { echo Today isn't the first. No need to continue.\n; exit; } .. random query etc here. Hmmm. This isn't exactly what I'm looking for. What I'm trying to do is get a new picture on the 1st of every month and display it for that whole month. Could you not just create a mysql table that contains the month and a url to a file? ?php // image.php $currentMonth = date('n'); $sql = SELECT `image_location` FROM `monthly_images` WHERE `month` = $currentMonth LIMIT 1; $result = mysql_query($sql); list ($loc) = mysql_result ($result); header (Content-type: image/png); readfile ($loc); exit; ? And then in your HTML: img src=image.php alt=MonthlyImage title=Yay for me! / I just wrote that code here in the email, but it should get you going in the right direction. Hope that helps! ~Philip -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Random pick
On Monday 14 December 2009 21:44:24 Chris wrote: Chris wrote: David McGlone wrote: On Monday 14 December 2009 21:02:37 Chris wrote: David McGlone wrote: Hi everyone, I've been lurking in the shadows on the list for quite some time and now I'm in need of a little info or advise. I'm looking for a way to grab a record out of a database on a certain day each month and I'm wondering if this can be accomplished with just a mysql query or would I need to use PHP also? A mysql query would do it but you'd use something to talk to mysql and process the results (whether it's php, perl, python, ruby etc depends on your other requirements). What I'm trying to do is to have a record picked from the database at random on the 1st of every month and display it on the page. Here is some code I have been working with: $query = SELECT DATEADD(mm, DATEDIFF(mm,0,getdate()), 0); $result = @mysql_query($query); if (!$result){ $query = SELECT * FROM monthlyPooch ORDER BY RAND() LIMIT 1; $result = @mysql_query($query); while ($row = mysql_fetch_array($result)){ echo $row[poochName] ; echo $row[Birthdate]; } } You can check the day of the month in php then do your other query: $today = date('j'); See http://php.net/date for date formats and what they return. if ($today !== 1) { echo Today isn't the first. No need to continue.\n; exit; } .. random query etc here. Hmmm. This isn't exactly what I'm looking for. What I'm trying to do is get a new picture on the 1st of every month and display it for that whole month. -- Blessings David M. I have been driven to my knees many times by the overwhelming conviction that I had nowhere else to go. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Random pick
David McGlone wrote: Hi everyone, I've been lurking in the shadows on the list for quite some time and now I'm in need of a little info or advise. I'm looking for a way to grab a record out of a database on a certain day each month and I'm wondering if this can be accomplished with just a mysql query or would I need to use PHP also? A mysql query would do it but you'd use something to talk to mysql and process the results (whether it's php, perl, python, ruby etc depends on your other requirements). -- Postgresql php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Random pick
On Monday 14 December 2009 21:02:37 Chris wrote: David McGlone wrote: Hi everyone, I've been lurking in the shadows on the list for quite some time and now I'm in need of a little info or advise. I'm looking for a way to grab a record out of a database on a certain day each month and I'm wondering if this can be accomplished with just a mysql query or would I need to use PHP also? A mysql query would do it but you'd use something to talk to mysql and process the results (whether it's php, perl, python, ruby etc depends on your other requirements). What I'm trying to do is to have a record picked from the database at random on the 1st of every month and display it on the page. Here is some code I have been working with: $query = SELECT DATEADD(mm, DATEDIFF(mm,0,getdate()), 0); $result = @mysql_query($query); if (!$result){ $query = SELECT * FROM monthlyPooch ORDER BY RAND() LIMIT 1; $result = @mysql_query($query); while ($row = mysql_fetch_array($result)){ echo $row[poochName] ; echo $row[Birthdate]; } } I suspect this code isn't going to work, because I think on the 1st day of the month it's going to choke. What do you think? -- Blessings David M. I have been driven to my knees many times by the overwhelming conviction that I had nowhere else to go. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Random pick
David McGlone wrote: On Monday 14 December 2009 21:02:37 Chris wrote: David McGlone wrote: Hi everyone, I've been lurking in the shadows on the list for quite some time and now I'm in need of a little info or advise. I'm looking for a way to grab a record out of a database on a certain day each month and I'm wondering if this can be accomplished with just a mysql query or would I need to use PHP also? A mysql query would do it but you'd use something to talk to mysql and process the results (whether it's php, perl, python, ruby etc depends on your other requirements). What I'm trying to do is to have a record picked from the database at random on the 1st of every month and display it on the page. Here is some code I have been working with: $query = SELECT DATEADD(mm, DATEDIFF(mm,0,getdate()), 0); $result = @mysql_query($query); if (!$result){ $query = SELECT * FROM monthlyPooch ORDER BY RAND() LIMIT 1; $result = @mysql_query($query); while ($row = mysql_fetch_array($result)){ echo $row[poochName] ; echo $row[Birthdate]; } } You can check the day of the month in php then do your other query: $today = date('j'); if ($today !== 1) { echo Today isn't the first. No need to continue.\n; exit; } .. random query etc here. -- Postgresql php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Random pick
Chris wrote: David McGlone wrote: On Monday 14 December 2009 21:02:37 Chris wrote: David McGlone wrote: Hi everyone, I've been lurking in the shadows on the list for quite some time and now I'm in need of a little info or advise. I'm looking for a way to grab a record out of a database on a certain day each month and I'm wondering if this can be accomplished with just a mysql query or would I need to use PHP also? A mysql query would do it but you'd use something to talk to mysql and process the results (whether it's php, perl, python, ruby etc depends on your other requirements). What I'm trying to do is to have a record picked from the database at random on the 1st of every month and display it on the page. Here is some code I have been working with: $query = SELECT DATEADD(mm, DATEDIFF(mm,0,getdate()), 0); $result = @mysql_query($query); if (!$result){ $query = SELECT * FROM monthlyPooch ORDER BY RAND() LIMIT 1; $result = @mysql_query($query); while ($row = mysql_fetch_array($result)){ echo $row[poochName] ; echo $row[Birthdate]; } } You can check the day of the month in php then do your other query: $today = date('j'); See http://php.net/date for date formats and what they return. if ($today !== 1) { echo Today isn't the first. No need to continue.\n; exit; } .. random query etc here. -- Postgresql php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Random content from MySql DB
If the past questions are 1,2,3,4: Select * from `questions` where id not in (1,2,3,4) order by RAND(); Simcha Younger -Original Message- From: A. Joseph [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 26, 2008 7:38 PM To: php-db@lists.php.net Subject: [PHP-DB] Random content from MySql DB I`m creating a small application that let users take test online, the user will login and visit the test page, questions and answers are stored in MySql database, i want to display each randomly without repeating. test must to completed between some specific amount of time or else the application will forcefully submit the form and calculated the completed ones (Eac question come up at a time and you choose the answer and submit, then another come show up again, just like that), I have plan of saving user`s progress and user may continue next time if he/she has not spent the total test time. I need your help on how to random the questions without repeating any and if a user may need to continue from he/her past, the random should also exclude the past questions stored inside the user progress table. What is your best advice, i want to start creating the mysql table soon. Thank you -- 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.6.7/1632 - Release Date: 25/08/2008 07:05 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] random 'card number' generator
D. Go to the manual at http://be2.php.net/manual/en/function.rand.php and look at the User contributed notes further down the page. You'll find a couple of solutions. Whatever you do, you will presumably need to check the generated number against the db to see if it is already in use and, if not, generate a new random number. Good luck, Jeffrey Desmond Coughlan wrote: X-No-Archive: true Hello, I'm learning PhP and trying to write a library catalogue system, that uses a PostgreSQL back-end. My db looks like this ... http://www.chez.com/desmondcoughlan/unix/bibliotheque.sql I had originally planned to have a username in place of 'card_number', but realised that there was no point. What I need now is the PhP code that will create a card number, and rather than having a sequence, I want a random three-digit number. Can someone point me in the direction of where and how PhP can do this? Thanks. D. - Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Random Password problem
I know that true randomness only exists in nature. However, the randomization in PHP is fairly good. I have only used it on fairly small scales (i.e. Randomizing 200 quotes to give a random quote when people log onto a page.) For passwords I have always gone an easier route. $password = time(); This will produce an impossible to guess string of numbers I think about 9 or 10 characters in length. I am sure others here will have better options. But this has worked well for me and is very very easy. ?php /* Stephen Johnson c | eh The Lone Coder http://www.thelonecoder.com [EMAIL PROTECTED] 562.924.4454 (office) 562.924.4075 (fax) continuing the struggle against bad code */ ? From: J. Connolly [EMAIL PROTECTED] Date: Tue, 08 Mar 2005 14:41:11 -0500 To: PHP list php-db@lists.php.net Subject: [PHP-DB] Random Password problem I am using this php in order to create, store and send random passwords to people who want to join my mailing list. ?php function random_password () { $seed = (integer) md5(microtime()); mt_srand($seed); $password = mt_rand(1,); $password = substr(md5($password), 3,9); return $password; } ? ?php $msg = random_password(); echo $msg; ? I seem to be getting the same number very often which makes me fear that this is not so random. I am a noob so I do not know if this is coincidence or a fault in my coding. Right now, I have been setting up passwords manually, but would like users to be as free from me as possible. Any direction would be helpful. BTW, I keep getting the following number an absurd amount of times. I have deleted cookies and even gone to other machines, and yet it still generates this number. 8f31a3 Thank you, jozef -- 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] Random Password problem
This is one I like to use jozef. function generate_password($length = 10) { $allowable_characters = abcdefghjkmnopqrstuvwxyz23456789; $ps_len = strlen($allowable_characters); mt_srand((double)microtime()*100); $pass = ; for($i = 0; $i $length; $i++) { $pass .= $allowable_characters[mt_rand(0,$ps_len-1)]; } return $pass; } Its been working well for me for sometime. -Wendell Frohwein -Original Message- From: J. Connolly [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 08, 2005 11:41 AM To: PHP list Subject: [PHP-DB] Random Password problem I am using this php in order to create, store and send random passwords to people who want to join my mailing list. ?php function random_password () { $seed = (integer) md5(microtime()); mt_srand($seed); $password = mt_rand(1,); $password = substr(md5($password), 3,9); return $password; } ? ?php $msg = random_password(); echo $msg; ? I seem to be getting the same number very often which makes me fear that this is not so random. I am a noob so I do not know if this is coincidence or a fault in my coding. Right now, I have been setting up passwords manually, but would like users to be as free from me as possible. Any direction would be helpful. BTW, I keep getting the following number an absurd amount of times. I have deleted cookies and even gone to other machines, and yet it still generates this number. 8f31a3 Thank you, jozef -- 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] Random Password problem
and my version function change_password($id, $password) { //generate a random password $pass = ; $salt = abchefghjkmnpqrstuvwxyz0123456789; srand((double)microtime()*100); $i = 0; while ($i = 7) { $num = rand() % 33; $tmp = substr($salt, $num, 1); $pass = $pass . $tmp; $i++; } //change the password in the db $sql = update cust_info set cust_pw ='.md5($pass).', temp_pass = 1 where cust_lg = '$id' and cust_pw = '$password'; $result = connect($sql); if ($result){ return $pass; }else{ change_password($id, $password); } bastien From: Wendell Frohwein [EMAIL PROTECTED] To: 'J. Connolly' [EMAIL PROTECTED],'PHP list' php-db@lists.php.net Subject: RE: [PHP-DB] Random Password problem Date: Tue, 8 Mar 2005 11:51:59 -0800 This is one I like to use jozef. function generate_password($length = 10) { $allowable_characters = abcdefghjkmnopqrstuvwxyz23456789; $ps_len = strlen($allowable_characters); mt_srand((double)microtime()*100); $pass = ; for($i = 0; $i $length; $i++) { $pass .= $allowable_characters[mt_rand(0,$ps_len-1)]; } return $pass; } Its been working well for me for sometime. -Wendell Frohwein -Original Message- From: J. Connolly [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 08, 2005 11:41 AM To: PHP list Subject: [PHP-DB] Random Password problem I am using this php in order to create, store and send random passwords to people who want to join my mailing list. ?php function random_password () { $seed = (integer) md5(microtime()); mt_srand($seed); $password = mt_rand(1,); $password = substr(md5($password), 3,9); return $password; } ? ?php $msg = random_password(); echo $msg; ? I seem to be getting the same number very often which makes me fear that this is not so random. I am a noob so I do not know if this is coincidence or a fault in my coding. Right now, I have been setting up passwords manually, but would like users to be as free from me as possible. Any direction would be helpful. BTW, I keep getting the following number an absurd amount of times. I have deleted cookies and even gone to other machines, and yet it still generates this number. 8f31a3 Thank you, jozef -- 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] Random Password problem
J. Connolly wrote: I am using this php in order to create, store and send random passwords to people who want to join my mailing list. ?php function random_password () { $seed = (integer) md5(microtime()); mt_srand($seed); your seeding the randomizer with the value zero each time! the expression: (integer) md5(microtime()) is (almost) always going to equal zero (unless it happens to start with one or more numeric chars). basically get rid of the code that seeds the randomizer, unless your using a really old version of php, because you don't need to seed the randomizer at all. if you remove the line: mt_srand($seed); your passwords will drastically increase in 'randomness' $password = mt_rand(1,); $password = substr(md5($password), 3,9); return $password; } ? ?php $msg = random_password(); echo $msg; ? I seem to be getting the same number very often which makes me fear that fear causes hesitation, hestitation causes your worse fears to come true. (yadda yadda, that film is sooo pre-Matrix ;-) this is not so random. I am a noob so I do not know if this is coincidence or a fault in my coding. Right now, I have been setting up passwords manually, but would like users to be as free from me as possible. Any direction would be helpful. BTW, I keep getting the following number an absurd amount of times. I have deleted cookies and even gone to other machines, and yet it still generates this number. 8f31a3 Thank you, jozef -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Random Character String
The robots that index the web. Bastien gave me a web site to use for this. Thanks. Ron - Original Message - From: Zareef Ahmed [EMAIL PROTECTED] To: Ron Piggott [EMAIL PROTECTED] Cc: PHP DB php-db@lists.php.net Sent: Saturday, March 05, 2005 11:56 AM Subject: Re: [PHP-DB] Random Character String Hi, Look at uniqueid function, but it gives some lengthy string. You can use string functiions for your specific purpose. http://in.php.net/uniqueid On Sat, 5 Mar 2005 09:38:35 -0500, Ron Piggott [EMAIL PROTECTED] wrote: Is there a way of generating an 8 character random string in PHP? Is there a way to ignore UPPER and lower case when you are using the SELECT command to find a record in the mySQL table? I know this isn't an HTML forum ... I have one more question which is more HTML in nature. I don't want some of the web pages to be indexed that my PHP scripts are creating. Is there a tag you know of to prevent this from happening? what do you mean by indexed here? indexed by whom? search engines? zareef ahmed Ron -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Zareef Ahmed :: A PHP Developer in India ( Delhi ) Homepage :: http://www.zareef.net -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Random Character String
i use this function to generate a random 7 letter password...simple change to make it 8 function change_password($id, $password) { //generate a random password $pass = ; $salt = abchefghjkmnpqrstuvwxyz0123456789; srand((double)microtime()*100); $i = 0; while ($i = 7) { $num = rand() % 33; $tmp = substr($salt, $num, 1); $pass = $pass . $tmp; $i++; } //change the password in the db $sql = update cust_info set cust_pw ='.md5($pass).', temp_pass = 1 where cust_lg = '$id' and cust_pw = '$password'; $result = connect($sql); if ($result){ return $pass; }else{ change_password($id, $password); } }//end function SQL is case insensitive for most queries. but you can use UPPER or LOWER to force case to one or the other if you feel its a problem for the html tag http://www.robotstxt.org/wc/meta-user.html bastien From: Ron Piggott [EMAIL PROTECTED] To: PHP DB php-db@lists.php.net Subject: [PHP-DB] Random Character String Date: Sat, 5 Mar 2005 09:38:35 -0500 Is there a way of generating an 8 character random string in PHP? Is there a way to ignore UPPER and lower case when you are using the SELECT command to find a record in the mySQL table? I know this isn't an HTML forum ... I have one more question which is more HTML in nature. I don't want some of the web pages to be indexed that my PHP scripts are creating. Is there a tag you know of to prevent this from happening? Ron -- 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] Random Number generating and adding it to he database..
On Sun, 23 Jan 2005 10:43:03 +0400, Radwan Aladdin [EMAIL PROTECTED] wrote: I wanted to know the best Random Function for PHP.. But please I don't want duplications to happen at the same second.. because I receive many customers.. For that purpose, mt_rand ( [int min, int max]) function is your best friend, I guess. See http://in2.php.net/manual/en/function.mt-rand.php for more details. And also how can I add [EMAIL PROTECTED], whic abc is a variable... and localhost.com is a static text?? So I only request from the user to enter the abc only and it will automatically be : [EMAIL PROTECTED] //Do you mean -- $user = someuser; echo $user; //And you wish to make [EMAIL PROTECTED] ? //Then, $email_address = $user . @localhost.com; echo $email_address; //Will output [EMAIL PROTECTED] The dot (.) is the cocatenation (string-joining) operator. Regards, Samar M. = Warning: Dates in Calendar are closer than they appear. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Random select -- Where am I going wrong?
See Below On Sun, 2004-07-04 at 05:54, Ronald The Newbie Allen wrote: Here is my code I keep on getting a Resource id #2 ..whatever that meansany help would be appreciated! html head titleTop Frame/title /head body bgcolor=#ff text=#00 link=#ff vlink=#800080 alink=#ff EMBED SRC= autostart=true hidden=true loop=true volume=100% ? $db_host = '##; $db_user = '##'; $db_pass = '##'; $db_name = '##'; $conn = mysql_connect($db_host,$db_user,$db_pass); if ($conn == true) { // Select the database. mysql_select_db($db_name,$conn); $db_table = 'music'; $music = mysql_query (Select * from $db_table ORDER BY RAND() Limit 1); if(!$music) die(Query Failed.); while($row = mysql_fetch_row($music)) print $music; you need something like print $row however, that still will not work. print_r( $row ) will give you all the values. print( $row-the_table_name would yield each value. NOTE: the syntax above is for a call to $row = mysql_fetch_object( $music ) lookup the correct syntax for mysql_fetch_row( $table ). You might want to check mysql_fetch_assoc and mysql_fetch_array to have even more fun! If you really wish to know more check out mysql_result( ) quite useful when you only seek a couple values from the resultset. hope that helps Alvaro Zuniga (337) 654 6515 www.zunitek.com Zunitek Solutions } ? /body /html -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Random select -- Where am I going wrong?
Here is my code I keep on getting a Resource id #2 ..whatever that meansany help would be appreciated! $music = mysql_query (Select * from $db_table ORDER BY RAND() Limit 1); if(!$music) die(Query Failed.); while($row = mysql_fetch_row($music)) print $music; } This is because you're printing $music--which is the resource ID--when you should be working with $row. Also, you're going to need to actually print $row[0] or $row['column'], not just $row. Larry -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Random not working?
This recent thread from the mysql list explains a lot about the problem. http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:15034 hth, Doug On Sat, 1 Mar 2003 12:24:57 +0100, Frank Keessen wrote: Hi All, I'm trying to get a random record each time this script runs; Only it's giving me everytime the first record back.. No random at all.. // generate and execute query $query = SELECT stedenid, naamstad, stadomschrijvk FROM steden ORDER BY RAND() LIMIT 1; $result = mysql_query($query) or die (Error in query: $query. . mysql_error()); $row = mysql_fetch_object($result); echo $row-naamstad; Version info; PHP 4.3.1 Mysql 3.23.54 When i'm trying to excute the SELECT statement in phpmyadmin; i'm only getting the first record back and when i'm taking off the LIMIT 1 it will display all the records in ascending order so also not in random.. Regards, Frank -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] random rows...what about tables
to get all the table names, then return a random table name, try the following: ?php for($i=0;$result;$i++) $table_names[$i] = $result[0]; echo 'A random table name: '.array_rand($table_names); ? dont forget, when you use a mysql_query(), it returns a result set with more than one value for each row returned. ie, $array[$i] could be anything from the table name to its size to its whatever ... Regards, Matthew Moldvan --- System Administrator Trilogy International, Inc http://www.trilogyintl.com/ecommerce/ --- -Original Message- From: Hutchins, Richard [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 17, 2002 9:26 AM To: 'Bruce Levick'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] random rows...what about tables I think it's because mysql_list_tables returns a resource identifier ($result). You have to iterate through the resource identifier ($result) with a while() loop to get the actual table names out. From the PHP.NET site: ?php $dbname = 'mysql_dbname'; if (!mysql_connect('mysql_host', 'mysql_user', 'mysql_password')) { print 'Could not connect to mysql'; exit; } $result = mysql_list_tables($dbname); if (!$result) { print DB Error, could not list tables\n; print 'MySQL Error: ' . mysql_error(); exit; } while ($row = mysql_fetch_row($result)) { print Table: $row[0]\n; } mysql_free_result($result); ? In the example above, I think the output would just be one table name. However, you're going to have (and want) a list of multiple table names, if I understand your problem correctly. In which case you'd have to put the table names in an array called $tablenames so your array_rand($tablenames) will work. Haven't tested this out or done this specifically before, so I hope this helps. -Original Message- From: Bruce Levick [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 17, 2002 9:19 AM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] random rows...what about tables Sorry, Have updated my script with a little help. Upon output i am recieving this. Warning: Argument to array_rand() has to be an array in C:\WORKING\portfolio\vivamotion\site\php\request.php on line 51 this is the code below. // // / ?php //listing table in database $alltables = mysql_list_tables(portfolio); //random array $randomtable = array_rand($alltables); $all = mysql_query(SELECT * FROM Illustrations); $totalRows_Recordset1 = mysql_num_rows($all); $rndm = mysql_query(SELECT * FROM Illustrations ORDER BY RAND() LIMIT 4,$totalRows_Recordset1); if (!$rndm) { echo(PError performing query: . mysql_error() . /P); exit(); } $randrow = mysql_fetch_array($rndm); ? //output to browser ?php print $randomtable\n; ? Hope that helps - Original Message - From: Jason Wong [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, December 17, 2002 11:48 PM Subject: Re: [PHP-DB] random rows...what about tables On Tuesday 17 December 2002 21:38, Bruce Levick wrote: Bruce Levick - Vivamotion Been searching for an answer to selecting a random table and then a random row within the selected table. I have this code which successfully selects a random row within a hard coded table. But just can't get the random table working. [snip] Anybody see the solution?? First we need to know _what_ the problem is. I think we can assume your code doesn't work the way you expected. Can you tell us _how_ it doesn't work? Error messages? -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* We place two copies of PEOPLE magazine in a DARK, HUMID mobile home. 45 minutes later CYNDI LAUPER emerges wearing a BIRD CAGE on her head! */ -- 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] random select
On Tuesday 17 December 2002 18:46, Bruce Levick wrote: Bruce Levick - VivamotionI was curious as to what is the best way to select a random row from a table in my database. I have currently five rows and will be expanding on that as well. I have tried this code. //retrieve random row ?php $rndm = mysql_query(SELECT * FROM Illustrations ORDER BY RAND() LIMIT You need to use one of the mysql_fetch_*() functions. Details and examples in manual. but am not getting anything when output with PHP in a browser. I am working off localhost on a WINXP machine. PHP 4.2.2. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* Ain't that something what happened today. One of us got traded to Kansas City. -- Casey Stengel, informing outfielder Bob Cerv he'd been traded. */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] random rows...what about tables
On Tuesday 17 December 2002 21:38, Bruce Levick wrote: Bruce Levick - Vivamotion Been searching for an answer to selecting a random table and then a random row within the selected table. I have this code which successfully selects a random row within a hard coded table. But just can't get the random table working. [snip] Anybody see the solution?? First we need to know _what_ the problem is. I think we can assume your code doesn't work the way you expected. Can you tell us _how_ it doesn't work? Error messages? -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* We place two copies of PEOPLE magazine in a DARK, HUMID mobile home. 45 minutes later CYNDI LAUPER emerges wearing a BIRD CAGE on her head! */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] random rows...what about tables
At 23:38 17-12-02 +1000, Bruce Levick wrote: Bruce Levick - Vivamotion Been searching for an answer to selecting a random table and then a random row within the selected table. I have this code which successfully selects a random row within a hard coded table. But just can't get the random table working. ?php //trying to select all tables from the database portfoliopfff $alltables = mysql_list_tables(portfolio); //trying to get the array value of the alltables...there are 4 tables in the database. So as far as I know the value of $alltables should be 3. (0table, 1table, 2table, 3table) $randtabnum = array($alltables); $randomtabel = array_rand($alltables); // this selects everything from the Illustrations table. I need to make the FROM table_name a random selection $all = mysql_query(SELECT * FROM Illustrations); //acquires total rows $totalRows_Recordset1 = mysql_num_rows($all); // selects random row from total rows $rndm = mysql_query(SELECT * FROM Illustrations ORDER BY RAND() LIMIT 4,$totalRows_Recordset1); if (!$rndm) { echo(PError performing query: . mysql_error() . /P); exit(); } $randrow = mysql_fetch_array($rndm); ? Anybody see the solution?? Winxp Pro, php 4.2.2 Mysql 3.2 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
Re: [PHP-DB] random rows...what about tables
Sorry, Have updated my script with a little help. Upon output i am recieving this. Warning: Argument to array_rand() has to be an array in C:\WORKING\portfolio\vivamotion\site\php\request.php on line 51 this is the code below. / ?php //listing table in database $alltables = mysql_list_tables(portfolio); //random array $randomtable = array_rand($alltables); $all = mysql_query(SELECT * FROM Illustrations); $totalRows_Recordset1 = mysql_num_rows($all); $rndm = mysql_query(SELECT * FROM Illustrations ORDER BY RAND() LIMIT 4,$totalRows_Recordset1); if (!$rndm) { echo(PError performing query: . mysql_error() . /P); exit(); } $randrow = mysql_fetch_array($rndm); ? //output to browser ?php print $randomtable\n; ? Hope that helps - Original Message - From: Jason Wong [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, December 17, 2002 11:48 PM Subject: Re: [PHP-DB] random rows...what about tables On Tuesday 17 December 2002 21:38, Bruce Levick wrote: Bruce Levick - Vivamotion Been searching for an answer to selecting a random table and then a random row within the selected table. I have this code which successfully selects a random row within a hard coded table. But just can't get the random table working. [snip] Anybody see the solution?? First we need to know _what_ the problem is. I think we can assume your code doesn't work the way you expected. Can you tell us _how_ it doesn't work? Error messages? -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* We place two copies of PEOPLE magazine in a DARK, HUMID mobile home. 45 minutes later CYNDI LAUPER emerges wearing a BIRD CAGE on her head! */ -- 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] random rows...what about tables
I think it's because mysql_list_tables returns a resource identifier ($result). You have to iterate through the resource identifier ($result) with a while() loop to get the actual table names out. From the PHP.NET site: ?php $dbname = 'mysql_dbname'; if (!mysql_connect('mysql_host', 'mysql_user', 'mysql_password')) { print 'Could not connect to mysql'; exit; } $result = mysql_list_tables($dbname); if (!$result) { print DB Error, could not list tables\n; print 'MySQL Error: ' . mysql_error(); exit; } while ($row = mysql_fetch_row($result)) { print Table: $row[0]\n; } mysql_free_result($result); ? In the example above, I think the output would just be one table name. However, you're going to have (and want) a list of multiple table names, if I understand your problem correctly. In which case you'd have to put the table names in an array called $tablenames so your array_rand($tablenames) will work. Haven't tested this out or done this specifically before, so I hope this helps. -Original Message- From: Bruce Levick [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 17, 2002 9:19 AM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] random rows...what about tables Sorry, Have updated my script with a little help. Upon output i am recieving this. Warning: Argument to array_rand() has to be an array in C:\WORKING\portfolio\vivamotion\site\php\request.php on line 51 this is the code below. // // / ?php //listing table in database $alltables = mysql_list_tables(portfolio); //random array $randomtable = array_rand($alltables); $all = mysql_query(SELECT * FROM Illustrations); $totalRows_Recordset1 = mysql_num_rows($all); $rndm = mysql_query(SELECT * FROM Illustrations ORDER BY RAND() LIMIT 4,$totalRows_Recordset1); if (!$rndm) { echo(PError performing query: . mysql_error() . /P); exit(); } $randrow = mysql_fetch_array($rndm); ? //output to browser ?php print $randomtable\n; ? Hope that helps - Original Message - From: Jason Wong [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, December 17, 2002 11:48 PM Subject: Re: [PHP-DB] random rows...what about tables On Tuesday 17 December 2002 21:38, Bruce Levick wrote: Bruce Levick - Vivamotion Been searching for an answer to selecting a random table and then a random row within the selected table. I have this code which successfully selects a random row within a hard coded table. But just can't get the random table working. [snip] Anybody see the solution?? First we need to know _what_ the problem is. I think we can assume your code doesn't work the way you expected. Can you tell us _how_ it doesn't work? Error messages? -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* We place two copies of PEOPLE magazine in a DARK, HUMID mobile home. 45 minutes later CYNDI LAUPER emerges wearing a BIRD CAGE on her head! */ -- 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] random rows...what about tables
On Tuesday 17 December 2002 22:18, Bruce Levick wrote: Sorry, Have updated my script with a little help. Upon output i am recieving this. Warning: Argument to array_rand() has to be an array in C:\WORKING\portfolio\vivamotion\site\php\request.php on line 51 OK, start from the basics. There's an example in the manual which shows you how to use mysql_list_tables(). Get that working, _then_ adapt it to return random tables. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* QOTD: I sprinkled some baking powder over a couple of potatoes, but it didn't work. */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Random numbers with range in mysql?
I'm trying to make shops that sell virtual objects. They restock once every 15 minutes. This is all set up. The problem is, I would like to have objects in these shops with a random chance of being restocked. My idea is to store two numbers in the restock list: chance, and outof. (For a 1/5 chance on each restock, those values would be 1 for chance, 5 for outof). The problem is, I need a way of generating a random number within a certain range. I thought of going through php and mt_rand(), but that would make for a very inefficient script. Any ideas? MySQL has a RAND() function. Returns a random number between zero and one. Multiply it by your limit and add one to get a range. SELECT FLOOR(RAND()*5)+1 To get a random number between one and five. To make an update random, try something like this: UPDATE yourtable SET ... WHERE FLOOR(RAND()*5)+1 = 1 AND ... ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] random
On Wednesday 05 June 2002 03:56, Natividad Castro wrote: hi to all, I have a drop down menu where users will select a word. After they submit it, I will generate a code number where I want to display the first three characters of the word they selected follow by Month and Date and three number that will be generating randomly. I don't have any problem displaying the MM/DD and the three numbers, but I don't know how to get the first three characters. substr() -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* Lake Erie died for your sins. */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Random Selecting from mySQL
are you just looking for a way to display 10 results per page? If yes then you can just use LIMIT to limit your result to 10 .. So, for the first page, you can do SELECT LIMIT 1, 10; and for the second page SELECT ... LIMIT 11, 20 etc etc . You can sure use ORDER BY with LIMIT to to sort the results for a given criteria .. Gurhan -Original Message- From: Georgie Casey [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 2:00 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [PHP-DB] Random Selecting from mySQL I know how to use the ORDER BY rand() command on the end of queries to randomize selection, but that's no good when you want to only display 10 results per page. The next page the user chooses, randomizes again and could show duplicate fields and not at all show other fields. Does anyone know a way round this? -- Regards, Georgie Casey [EMAIL PROTECTED] *** http://www.filmfind.tv Ireland's Online Film Production Directory *** -- 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] Random Selecting from mySQL
yea, i know how to display 10 results per page, but that doesnt work when you want to do a ORDER BY rand() query. Gurhan Ozen [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... are you just looking for a way to display 10 results per page? If yes then you can just use LIMIT to limit your result to 10 .. So, for the first page, you can do SELECT LIMIT 1, 10; and for the second page SELECT ... LIMIT 11, 20 etc etc . You can sure use ORDER BY with LIMIT to to sort the results for a given criteria .. Gurhan -Original Message- From: Georgie Casey [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 2:00 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [PHP-DB] Random Selecting from mySQL I know how to use the ORDER BY rand() command on the end of queries to randomize selection, but that's no good when you want to only display 10 results per page. The next page the user chooses, randomizes again and could show duplicate fields and not at all show other fields. Does anyone know a way round this? -- Regards, Georgie Casey [EMAIL PROTECTED] *** http://www.filmfind.tv Ireland's Online Film Production Directory *** -- 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] Random Selecting from mySQL
could you perhaps do the select on the first page, then store the results in a session (array) and just load different indexed portions of the resultset each page? only problem there is that you wouldn't get any refreshed results while browsing those pages - but i don't know if this matters for you or not. HTH Beau // -Original Message- // From: Georgie Casey [mailto:[EMAIL PROTECTED]] // Sent: Thursday, 14 March 2002 3:00 AM // To: [EMAIL PROTECTED]; [EMAIL PROTECTED] // Subject: [PHP-DB] Random Selecting from mySQL // // // I know how to use the ORDER BY rand() command on the end // of queries to // randomize selection, but that's no good when you want to // only display 10 // results per page. The next page the user chooses, randomizes // again and could // show duplicate fields and not at all show other fields. // // Does anyone know a way round this? // // -- // Regards, // Georgie Casey // [EMAIL PROTECTED] // // *** // http://www.filmfind.tv // Ireland's Online Film Production Directory // *** // // // // -- // 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] Random Selecting from mySQL
Pass along a hidden form which documents exactly what rows have already been shown input type=hidden name=seen value=1:4:3:9:10:5:27 then you could use $seen=explode(':', $seen); to break it into an array... after that use a foreach to add a 'and id != '.$seen into the sql query for every element in $seen... thus not allowing duplicates on a per visit basis... -Original Message- From: Georgie Casey [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 4:11 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [PHP-DB] Random Selecting from mySQL yea, i know how to display 10 results per page, but that doesnt work when you want to do a ORDER BY rand() query. Gurhan Ozen [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... are you just looking for a way to display 10 results per page? If yes then you can just use LIMIT to limit your result to 10 .. So, for the first page, you can do SELECT LIMIT 1, 10; and for the second page SELECT ... LIMIT 11, 20 etc etc . You can sure use ORDER BY with LIMIT to to sort the results for a given criteria .. Gurhan -Original Message- From: Georgie Casey [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 2:00 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [PHP-DB] Random Selecting from mySQL I know how to use the ORDER BY rand() command on the end of queries to randomize selection, but that's no good when you want to only display 10 results per page. The next page the user chooses, randomizes again and could show duplicate fields and not at all show other fields. Does anyone know a way round this? -- Regards, Georgie Casey [EMAIL PROTECTED] *** http://www.filmfind.tv Ireland's Online Film Production Directory *** -- 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] Random numbers?
On sön, 03 feb 2002, Chris Payne wrote: Hi there everyone, I need to generate a random number between 1 and 15 for insertion into a DB, I can easily do the DB side of it but what is the best method for quickly generating a random number between 1 and 15 (including 1 and 15 in the equation)? srand((double)microtime()*100); $randomnumber = rand(1,15); Something like this? -- patrik_wallstrom-foodfight-[EMAIL PROTECTED]+46-709580442 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Random numbers?
Hi there, That is absolutely PERFECT, thank you so much for that you are a lifesaver :-) Regards Chris Payne www.planetoxygene.com On sön, 03 feb 2002, Chris Payne wrote: Hi there everyone, I need to generate a random number between 1 and 15 for insertion into a DB, I can easily do the DB side of it but what is the best method for quickly generating a random number between 1 and 15 (including 1 and 15 in the equation)? srand((double)microtime()*100); $randomnumber = rand(1,15); Something like this? -- patrik_wallstrom-foodfight-[EMAIL PROTECTED]+46-709580442 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] random created numbers and letters
At 25.09.2001 22:46, Saulius Jankauskas wrote: Hello, Can you give me a piece of code, where I could see, how to create random written numbers and letters? For example, I'd like to give my visitor temporary passwrord: BS0147. To another HF0124 and so on... How to generate it with PHP? Sorry, if I didn;t explained clearly what I want. Thanks. Did you read _anything_ in the manual before posting?! (and how on earth is this related to php-DB ?!) check out rand() srand() mt_rand() mt_srand() and so on... and I'll leave it up to the reader to decide how to create a password-fish out of a row of numbers... -- Andreas D Landmark / noXtension Real Time, adj.: Here and now, as opposed to fake time, which only occurs there and then. -- PHP Database 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]
Re: RE: [PHP-DB] Random
Try: $result = mysql_db_query ($DBName,select * from Contacts order by rand() LIMIT 0,5 ); As your first example had the '0' and then the '5' after the LIMIT clause, the second didn't have th any '0'. Cheers. Russ On Fri, 31 Aug 2001 20:59:16 +0100 Seb Frost [EMAIL PROTECTED] wrote: I know it's documented as rand() but you might want to try random() just in case... I'm sure I read that somewhere - seb -Original Message- From: John Hurleston [mailto:[EMAIL PROTECTED]] Sent: 31 August 2001 19:18 To: [EMAIL PROTECTED] Subject: [PHP-DB] Random I would like to get the first 5 random entries out of my mysql database, what would be the correct SELECT option? I adjusted this line $result = mysql_db_query ($DBName,select * from Contacts LIMIT 0,5 ); which works correctly. :) $result = mysql_db_query ($DBName,select * from Contacts order by rand() LIMIT 5 ); Doesn't work at all. :( Can anyone through any light on this subject. Thanks. -- PHP Database 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] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.274 / Virus Database: 144 - Release Date: 23/08/2001 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.274 / Virus Database: 144 - Release Date: 23/08/2001 -- PHP Database 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] #---# Believe nothing - consider everything Russ Michell Anglia Polytechnic University Webteam Room 1C 'The Eastings' East Road, Cambridge e: [EMAIL PROTECTED] w: www.apu.ac.uk/webteam t: +44 (0)1223 363271 x 2331 www.theruss.com #---# -- PHP Database 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]
Re: [PHP-DB] Random
I was sure there was a syntax error in that SELECT statement, but according tho the description at http://www.mysql.com/doc/M/a/Mathematical_functions.html, that looks right on to me. I know this doesn't help a lot, but at least you've had a second set of eyes confirm that your code looks right. John Hurleston wrote: $result = mysql_db_query ($DBName,select * from Contacts order by rand() LIMIT 5 ); Doesn't work at all. :( -- Chris Hobbs Silver Valley Unified School District Head geek: Technology Services Coordinator webmaster: http://www.silvervalley.k12.ca.us/~chobbs/ postmaster: [EMAIL PROTECTED] -- PHP Database 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]
Re: [PHP-DB] Random
according tho the description at http://www.mysql.com/doc/M/a/Mathematical_functions.html, that looks $result = mysql_db_query ($DBName,select * from Contacts order by rand() LIMIT 5 ); Doesn't work at all. :( What version of MySQL are you using? I remember something about ordering by rand() only working in 3.23.xx. If you're using 3.22.xx, it won't work. You could do something with mysql_data_seek() and the php mt_rand() function if that's the case. It would be klunky, but you could probably get it to work. Sincerely, Paul Burney +-+-+ | Paul Burney | P: 310.825.8365 | | Webmaster Programmer | E: [EMAIL PROTECTED] | | UCLA - GSEIS - ETU | W: http://www.gseis.ucla.edu/ | +-+-+ -- PHP Database 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]
RE: [PHP-DB] Random
I know it's documented as rand() but you might want to try random() just in case... I'm sure I read that somewhere - seb -Original Message- From: John Hurleston [mailto:[EMAIL PROTECTED]] Sent: 31 August 2001 19:18 To: [EMAIL PROTECTED] Subject: [PHP-DB] Random I would like to get the first 5 random entries out of my mysql database, what would be the correct SELECT option? I adjusted this line $result = mysql_db_query ($DBName,select * from Contacts LIMIT 0,5 ); which works correctly. :) $result = mysql_db_query ($DBName,select * from Contacts order by rand() LIMIT 5 ); Doesn't work at all. :( Can anyone through any light on this subject. Thanks. -- PHP Database 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] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.274 / Virus Database: 144 - Release Date: 23/08/2001 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.274 / Virus Database: 144 - Release Date: 23/08/2001 -- PHP Database 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]
Re: [PHP-DB] Random question selection in PHP w/ MySQL backend.
Adam, I'm what I would call a novice to PHP and databases in general, however if I had to do what you're doing, I might do the following... Add a field to the table that contains your questions called displayed and have it be an enum of Yes/No True/False, etc... In your script, you'd then query for all the questions that haven't already been displayed. Then get a random one of those (plenty of randomizing functions in PHP I believe). Display it, mark it as displayed in the db... Next time, it won't even get returned in the query. I don't know if you have to do this on a per-user basis or what. If so, you will probably have to create a session table and keep track of the questions each user has viewed... Hope this gets you started... Cheers! My 2 ¢ John Pickett http://www.bvstudios.com/ Co-Author: Inside Dreamweaver 4 http://www.amazon.com/exec/obidos/ASIN/0735710848/xtremist - Original Message - From: Adam Lundrigan [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, July 31, 2001 2:32 PM Subject: [PHP-DB] Random question selection in PHP w/ MySQL backend. I'm having a bit of trouble creating a random question selector. I'm using PHP 4.0.6 and MySQL 3.23.36 on Windows 98 SE. I've tried several different solutions, but none work at all. What i need to do is select 10 questions from a database (db: vpt, table: questions), and make sure that the same question doesn't appear twice. The questions need to appear in a random order each time the script is loaded. It sounds simple enough, but i just can't seem to get it to work. Any suggestions?? Thanks in advance, -Adam Lundrigan CEO, VPU http://www.vpu-virtual.com/ ICQ # 73617446 [EMAIL PROTECTED] -- PHP Database 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]
RE: [PHP-DB] Random Password Generation/MSSQL
-Original Message- From: Ryan Marrs [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 12, 2001 1:54 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Random Password Generation/MSSQL Having an issue with this script, the generator works if I just echo out the password, however when I attempt to update the table, it times-out in IIS. I've bumped the IIS Timeout up to over 20 minutes, and it still times out. This is on a database with approximately 29,000 entries. Any ideas? [snip] for($i=1;$i=$count;$i++){ $DUNSNumber=$row-DUNSNumber; echo rand_pass().br; I bet if you echo $insertquery right here, you won't see what you were expecting to. (Hint: $password and $DUNSNumber aren't set when you give $insertquery its value; neither is the string updated for each iteration of this loop.) MSSQL_QUERY($insertquery); } Perhaps that's not the entire problem, but it can't be helping...if nothing else, once that's corrected maybe you can start looking at doing those updates in smaller batches. 20 minutes does seem a bit extreme, but then it's hard to make much of a judgment on that without knowing more about the machine in question, what else it's being used for besides sql services, how heavily it's being utilized, etc. --- Mark Roedel | Nothing in life is so bad that it cannot be Systems Programmer| made much, much worse by the addition of LeTourneau University |lots of spikes and razors. Longview, Texas, USA |-- Sean Kozma -- PHP Database 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]
Re: [PHP-DB] Random - not that random
Hi Dan, You need to call mt_srand() first to seed the random number generator. It's all described here: http://www.php.net/manual/en/function.mt-rand.php Ken * Dan Eskildsen [EMAIL PROTECTED] [010517 14:22]: Newbie alert Hi! Here is a piece of coding. It randomly choose between four options to display on my homepage. The problem is that it doesn't seem to be that random - rather biased. The last option $message[3] is displayed 9 out of 10 times. Any suggestions? script language=php $message[0] = 'a href=index.php3?Page=vognimg border=0 src=images/trolley.jpgbrRengøringsvogne, mopper m.m./a'; $message[1] = 'a href=index.php3?Page=nilfiskimg border=0 src=images/nilfisk.gifbrNilfisk Advance rengøringsmaskiner/a'; $message[2] = 'a href=index.php3?Page=poleringimg border=0 src=images/ladder.jpgbrHar du set vores Vinduespudserstiger?/a'; $message[3] = 'a href=index.php3?Page=polishimg border=0src=images/logo-bison.gifbrVi importerer selv vore polisher fra en af Canadas førende Polishfabrikker./a'; $number = mt_rand(0,3) ; print$message[$number]; /script -- == Regards from Denmark, Europe Please cc your reply to [EMAIL PROTECTED] == I haven't lost my mind, I've got it backed up on TAPE somewhere... -- PHP Database 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]