PHP - Enter The Same Random Number Into Only 5 Rows Of Mysql, And Loop Through To Do This So That Enteries Are Randomly Grouped Into 5

If I have an array, $array, how can I loop through it (e.g. with a foreach() ) .. but just do it randomly?

So each time, random entries of the array are used and not necessarily in order.

As above,

I have a lottery style site that picks a random number between 1-8 but my users complain for some reason that this is not enough.

So i was told to look into using fopen and random.org to generate a random number.

Anyone have experience of this and perhaps a code snippet for me to look at and possibly use?

help will be appreciated.

Ok I'm trying to insert multiple rows by using a while loop but having problems. At the same time, need to open a new mysql connection while running the insert query, close it then open the previous mysql connection.

I managed to insert multiple queries before using a loop, but for this time, the loop does not work? 
I think it is because I am opening another connection... yh that would make sense actually?

Here is the code:


$users = safe_query("SELECT * FROM ".PREFIX."user");
       while($dp=mysql_fetch_array($users)) { 
          
   $username = $dp['username'];
 $nickname = $dp['nickname'];
 $pwd1 = $dp['password']; 
 $mail = $dp['email'];
 $ip_add = $dp['ip'];
 $wsID = $dp['userID'];
 $registerdate = $dp['registerdate'];
 $birthday = $dp['birthday'];
 $avatar = $dp['avatar'];
 $icq = $dp['icq']; 
 $hp = $dp['homepage'];
 
echo $username." = 1 username only? :(";
      

// ----- Forum Bridge user insert -----

$result = safe_query("SELECT * FROM `".PREFIX."forum`");
$ds=mysql_fetch_array($result);
$forum_prefix = $ds['prefix'];
define(PREFIX_FORUM, $forum_prefix);
define(FORUMREG_DEBUG, 0);

$con = mysql_connect($ds['host'], $ds['user'], $ds['password']) or system_error('ERROR: Can not connect to MySQL-Server');
$condb = mysql_select_db($ds['db'], $con) or system_error('ERROR: Can not connect to database "'.$ds['db'].'"');
                
include('../_phpbb_func.php');
$phpbbpass = phpbb_hash($pwd1);
$phpbbmailhash = phpbb_email_hash($mail);
$phpbbsalt = unique_id();

safe_query("INSERT INTO `".PREFIX_FORUM."users` (`username`, `username_clean`, `user_password`, `user_pass_convert`, `user_email`, `user_email_hash`, `group_id`, `user_type`, `user_regdate`, `user_passchg`, `user_lastvisit`, `user_lastmark`, `user_new`, `user_options`, `user_form_salt`, `user_ip`, `wsID`, `user_birthday`, `user_avatar`, `user_icq`, `user_website`) VALUES ('$username', '$username', '$phpbbpass', '0', '$mail', '$phpbbmailhash', '2', '0', '$registerdate', '$registerdate', '$registerdate', '$registerdate', '1', '230271', '$phpbbsalt', '$ip_add', '$wsID', '$birthday', '$avatar', '$icq', '$hp')");
if (FORUMREG_DEBUG == '1') {
echo "<p><b>-- DEBUG -- : User added: ".mysql_affected_rows($con)."<br />";
       echo "<br />-- DEBUG -- : Query used: ".end($_mysql_querys)."</b></p><br />";
      
       $result = safe_query("SELECT user_id from ".PREFIX_FORUM."users WHERE username = '$username'");
       $phpbbid = mysql_fetch_row($result);
safe_query("INSERT INTO `".PREFIX_FORUM."user_group` (`group_id`, `user_id`, `group_leader`, `user_pending`) VALUES ('2', '$phpbbid[0]', '0', '0')");
safe_query("INSERT INTO `".PREFIX_FORUM."user_group` (`group_id`, `user_id`, `group_leader`, `user_pending`) VALUES ('7', '$phpbbid[0]', '0', '0')");
mysql_close($con);
}

         include('../_mysql.php');        
         mysql_connect($host, $user, $pwd) or system_error('ERROR: Can not connect to MySQL-Server');
mysql_select_db($db) or system_error('ERROR: Can not connect to database "'.$db.'"');
       
       }



So I need to be able to insert these rows using the while loop.. how can I do this?

I really appreciate any help.

Hi.
I'm making a registration form, that will put each entered item into $_POST, which will then submit to the same page.
First, I need to has the password with this method:
Code: [Select]
<?php
public function hash_password($password) {
$result = hash(sha512, $password . SALT);
return $result;
}
>?then prepare the entered data for mysql with this method:
Code: [Select]
<?php
public function query_prep($value) {
$result = $this->real_escape_string($value);
if (!$result) {
die("Preparing query failed: " . $this->errno);
}
return $result;
}
?>
However, how can I "validate" the form.
I need to pass the now prepared $_POST array into a loop, that executes the prepare method on each item in the array and then puts it in an array again.
Also, how could I do some kind of function that checks if all required fields were filled, and how I can fail the submission if invalid characters were used.

I am working on a quiz app

image 1 shows the index.php page
image 2 shows the first question
image 3 shows the second question
image 4 shows the third question
image 5 shows the result after completing the quiz
image 6 shows the database 'quizzer' and its tables
image 7 shows the 'questions' table
image 8 shows the 'choices' table

THIS LINK CONTAIN ALL THE CODE (and images) I HAVE DONE SO FAR

https://www.mediafir...o7f5q0fe6y/quiz

1.Now my question is how to select the question RANDOMLY from 'questions' table along with 'choices' (by adding code to the existing file or create a new one).

2.If user refresh/reload the page before starting ('Start Quiz') or click 'Take Again' after finishing the quiz, the question should appear randomly.

3.Basically I want to change the order of question appearing in the browser each time I refresh.

4.My work so far is mentioned above.........Please help me with this "RANDOM" problem !!

P.S - Will it be possible, by creating a random function in PHP which will check for repeat questions in a session and check for the 'id' of the question and if it is new display it on the page.

If so what should I do and if no then how to do?

hello, i am trying to see how i can pick a random number between 1-15 and exclude certain numbers.

so i have a staff list that once a random number is created it inserts it into the staffnumber field.  so the next time i create a random number for a staff, i want to make sure that the random number doesnt select an existing staffnumber.

thanks!

Hi Guys

I have a code what inserts very simple queries to database, im trying to add a random reference number for each enrty using
$reference = rand(111111111111,999999999999);

but each time I add an entry it gives me the same random number previously generated for previous entry

can you help pleasE?

is there a way to make a random number input into mysql?

like if i add a new customer to a table, i want to assign a random number to that customer.

i wanted to choose 5 random numbers from 0-20. each number represents an index in an array. is there a way to pick out 5 random items from the array. say if random number generator piked a number 22, the last item in the array is at index 20, it wud then have to go to index 0.

thanks!

Hi I wanted to know how once I have selected and echoed the rows from mysql table how can I get it to number those rows that echo?
etc

1.   echo $variable
2.   echo $variable
3.   echo $variable
4.   echo $variable
5.   echo $variable

Any help is appreciated

Hello,
I am trying to create a simple game random number guessing game in PHP.
Currently, I have an HTML page with a form on it where the user enters a number.
Then when the user clicks the submit button on the form, their number is passed onto the second page.
On the second page, I have some PHP code that generates a random number between 1 and 20, then it checks to see if the two numbers are the same.
If they are the same, it says correct.
If the guess is higher, it says so.
If the guess is lower, it says so.
I also made it display a form to re-guess the number (if the initial guess was incorrect).

The problem I have is when the user attempts to re-guess the number. Whenever the user attempts to enter a new guess, the random number changes.
I want to make it so that the random number stays the same as it is.
Any help?

Here is the Code for the first HTML page:
Code: [Select]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>phpNumberGame</title>
<link href="style.css" rel="stylesheet" type="text/css" />
</head>

<body>

<div id="main"></div>

<div id="enterNumber">
<form action="result.php" method="post">
  Enter a number: <input type="text" name="inputnumber" /><br />
  <input type="submit" value="Guess" />
</form>
</div>

</body>
</html>

Here is the code for the second page:
Code: [Select]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>result</title>
<link href="style.css" rel="stylesheet" type="text/css" />
</head>

<body>
<div id="main"></div>

    <div id="enterNumber">

<?php
$number_actual = rand (1,20);
$number_guess = $_REQUEST["inputnumber"];
         echo "You chose: " . $number_guess . "<br />";
echo "The random number is: " . $number_actual . "<br />";
if ($number_guess==$number_actual)
echo "You guessed <b>Correctly!</b>";
elseif ($number_guess<$number_actual)
{
echo "You are too <b>Low</b>!";
echo "<br />";
echo "<br />";
echo "Try guessing again...";
echo "<form>
<input type='text' name='inputnumber' />
<input type='submit' value='Guess' />
  </form>";
}
elseif ($number_guess>$number_actual)
{
echo "You are too <b>High</b>!";
echo "<br />";
echo "<br />";
echo "Try guessing again...";
echo "<form>
<input type='text' name='inputnumber' />
<input type='submit' value='Guess' />
  </form>";
}
?>
    </div>

</body>
</html>


Here is what I have so far on my website, you can see it he
http://joshkautz.com/phpNumberGame/phpNumberGame.html

I think I included everything necessary for people to give input, if not please let me know and I will give more information!
Do I need to redo things completely?
Any advice would be greatly appreciated.
Thanks a ton!

Hi all,
sorry cos there is no code.
please how can i generate pairs (in twos, threes, fours or five) from a given set of numbers. the numbers are to be typed in the form text field and when click generate(submit button) it brings out the pair of numbers. thanks in advance

my form
Code: [Select]
<form id="form1" name="form1" method="post" action="">
      <table width="100%" border="0" cellspacing="2" cellpadding="1">
        <tr>
          <td width="21%">Input Numbers : </td>
          <td width="79%"><input name="numbers" type="text" id="numbers" size="50" /></td>
        </tr>
        <tr>
          <td>&nbsp;</td>
          <td><input name="generate" type="submit" id="generate" value="Generate" /></td>
        </tr>
        <tr>
          <td colspan="2">&nbsp;</td>
        </tr>
        <tr>
          <td colspan="2">&nbsp;</td>
        </tr>
        <tr>
          <td colspan="2">&nbsp;</td>
        </tr>
        <tr>
          <td colspan="2">&nbsp;</td>
        </tr>
      </table>
        </form>

I'm hoping someone can show me how to get a random decimal number. I've googled and can't find anything that works.

I need to find a random number between 1.0 and 10.0

I can get a random whole number no problem, but decimals aren't working.

When I finally get that working, ideally I'd like to be able to find a random number between two decimals (like above) but also have a small chance of getting a decimal slightly higher than the two given. So, for example, maybe a random decimal between 3.5 and 6.0, but a slight chance of getting 6.2?

Thank you very much for any help!

I need to choose a random number that doesn't currently exist in the database

Hey guys was wondering if anyone could modify the code below to have $output = 'yes' if the number of rows equal 10, 20, 30, 40, 50, 60, 70, 80......... etc

$dbhost = '******';
$dbuser = ''******';';
$dbpass = ''******';';

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('MYSQL N/A - Please Contact Admin');

$dbname = ''******';';
mysql_select_db($dbname);

$query="SELECT * FROM documentaryinfo";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close($conn);
?>

Thanks
--------------------------------------------------------------------------------------------------------
Watch Free Documentaries Online - The Documentary Database
www.free-documentaries-online.com
--------------------------------------------------------------------------------------------------------