how to insert random value in to database mysql?

Question

how to insert random value in to database mysql ?

Ok, when i load this code i will have random number format like this

5,3,1,6,4,

and i want to insert 5,3,1,6,4, into database mysql ( 1 row 1 column) , how can i do ?

<?
    $cards = array();
    for ($i = 0; $i < 5; $i++) 
            {
            $card = mt_rand(1, 6); 
            if(!in_array($card, $cards))
                    {
                $cards[$i] = $card;
            }
                else
                    {
            $i--;
            }
            } 
        foreach ($cards as $cards) 
            { 
        echo $cards.","; 
            }
?>

Martin · Accepted Answer · 2014-01-06 15:44:43Z

1

How does it differ from inserting non-random values ?

mysqli_query($link, "INSERT INTO yourtable (id, cards) VALUES (NULL, '$cards')");

Or something similar.

answered Jan 6, 2014 at 15:44

Martin

2,0621 gold badge17 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user3141230 Over a year ago

not work , when i use your code , it's will be insert only first number into mysql (not all of data )

krokodilko · Accepted Answer · 2014-01-06 15:53:22Z

0

Pure (My)SQL solution:

INSERT INTO test( x, y )
SELECT 10*rand(),
       10*rand()
FROM information_schema.columns
LIMIT 10;

Demo: http://www.sqlfiddle.com/#!2/be6e5/2

answered Jan 6, 2014 at 15:53

krokodilko

36.3k7 gold badges62 silver badges86 bronze badges

Comments

Digital Chris · Accepted Answer · 2014-01-06 16:09:35Z

0

The easiest way to do what you describe would be as @Martin answered.

However this will probably screw you up later. Ideally you don't want to store a list in a RDBMS field; it defeats the whole purpose of having a database.

If you make a table like

ID, cardPosition, cardID

You can do this:

$insert = $db->prepare("INSERT INTO cardpositions (cardPosition, cardID) VALUES (:cardPosition, :cardID)");
foreach ($cards as $cardPosition=>$card) 
        { 

    $insert->execute(array(':cardPosition' => $cardPosition, ':cardID' => $card));
        }

OR

The wrong way to do this, but the one you seem to want is:

$cardlist = implode(",",$cards);  //now you have a comma separated list without the trailing comma

then you do this if PDO:

$insert = $db->prepare("INSERT INTO cardpositions (cardlist) VALUES (:cardlist)");
$insert->execute(array(':cardlist' => $cardlist));

or this if mysqli:

mysqli_query($link, "INSERT INTO yourtable (cardlist) VALUES ('$cardlist')");

edited Jan 6, 2014 at 16:09

answered Jan 6, 2014 at 15:54

Digital Chris

6,1771 gold badge22 silver badges29 bronze badges

4 Comments

user3141230 Over a year ago

i want to make a table like ID, number in number column i want to insert 5,3,1,6,4, how can i do ?

Digital Chris Over a year ago

It means I don't know what you are talking about: put the table definition in the question.

user3141230 Over a year ago

OK, i will make table that have 2 column 1.id and 2. number, and i want to insert 5,3,1,6,4, to column number

Digital Chris Over a year ago

what you call "number" i call "cardlist" in the answer above. Take a look... cardlist is a better name than number because it describes what is actually in the field.

Collectives™ on Stack Overflow

how to insert random value in to database mysql?

3 Answers 3

1 Comment

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related